{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Hodnotenie dodávateľov","Evaluation of suppliers","synchronisation","gestion documentaire","aide du modèle"],"not_rendered":{"images":3,"macros":1,"external_links":1,"defined_names":35,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"Hodnotenie dodávateľov","index":0,"n_rows":51,"n_cols":24,"rows_kept":51,"merged":[[0,0,0,5],[0,18,3,18],[0,19,3,19],[0,20,3,20],[0,21,3,21],[0,22,3,22],[0,23,3,23],[2,1,2,5],[3,1,3,5],[5,0,6,0],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[9,2,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[16,2,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[23,2,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,13],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[35,12,35,13],[37,2,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[37,12,37,13],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[41,12,41,13],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[46,12,46,13],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,13]]}
["HODNOTENIE DODÁVATEĽOV",{"$nulls":17},"DO NOT ERASE","DO NOT ERASE","DO NOT ERASE","DO NOT ERASE","DO NOT ERASE","DO NOT ERASE"]
[]
["NÁZOV PROJEKTU (AKTIVITY)"]
["PROJEKTOVÝ MANAŽÉR:"]
[]
["ROZPIS",null,"DODÁVATEĽ 1",null,"DODÁVATEĽ 2",null,"DODÁVATEĽ 3",null,"DODÁVATEĽ 4",null,"DODÁVATEĽ 5",null,"DODÁVATEĽ 6",{"$nulls":5},"NA",2,"NA",2,"NA",2]
[null,null,"Popis","Počet bodov","Popis","Počet bodov","Popis","Počet bodov","Popis","Počet bodov","Popis","Počet bodov","Popis","Počet bodov",{"$nulls":4},"Chýba",0,"Nie",0,"Nedostatočné",0]
[{"$nulls":18},"Základné",1,"Áno",2,"Dostatočné",1]
["FUNKČNÁ TECHNICKÁ ČASŤ","Weighting",{"$nulls":16},"Detailné",2,null,null,"Uspokojivé",2]
["1 - PREZENTÁCIA PROJEKTU",{"$f":"SUM(B11:B12)*2","v":4},{"$f":"SUM(D11:D12)","v":4},null,{"$f":"SUM(F11:F12)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H11:H12)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J11:J12)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L11:L12)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N11:N12)","v":{"$error":"#N/A"}}]
["1.1 - Uvedené odkazy na dokumentáciu (zadávacie podmienky, …)",1,"Áno",{"$f":"IF((C11=\"na\"),$B11*$T$6,$B11*VLOOKUP(C11,$U$6:$V$8,2,FALSE))","v":2},null,{"$f":"IF($E11=\"na\",$B11*2,$B11*VLOOKUP(E11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G11=\"na\",$B11*2,$B11*VLOOKUP(G11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I11=\"na\",$B11*2,$B11*VLOOKUP(I11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K11=\"na\",$B11*2,$B11*VLOOKUP(K11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M11=\"na\",$B11*2,$B11*VLOOKUP(M11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["1.2 - Uvedené odkazy na normy",1,"Detailné",{"$f":"IF($C12=\"na\",$B12*$T$6,$B12*VLOOKUP(C12,$S$6:$T$9,2,FALSE))","v":2},null,{"$f":"IF($E12=\"na\",$B12*$T$6,$B12*VLOOKUP(E12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G12=\"na\",$B12*$T$6,$B12*VLOOKUP(G12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I12=\"na\",$B12*$T$6,$B12*VLOOKUP(I12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF(K12=\"na\",$B12*$T$6,$B12*VLOOKUP(K12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M12=\"na\",$B12*$T$6,$B12*VLOOKUP(M12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2 - FUNKČNÝ POPIS RIEŠENIA",{"$f":"SUM(B14:B16)*2","v":18},{"$f":"SUM(D14:D16)","v":15},null,{"$f":"SUM(F14:F16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H14:H16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J14:J16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L14:L16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N14:N16)","v":{"$error":"#N/A"}}]
["2.1 - Popis funkčnosti zariadení",3,"Základné",{"$f":"IF($C14=\"na\",$B14*$T$6,$B14*VLOOKUP(C14,$S$6:$T$9,2,FALSE))","v":3},null,{"$f":"IF($E14=\"na\",$B14*$T$6,$B14*VLOOKUP(E14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G14=\"na\",$B14*$T$6,$B14*VLOOKUP(G14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I14=\"na\",$B14*$T$6,$B14*VLOOKUP(I14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K14=\"na\",$B14*$T$6,$B14*VLOOKUP(K14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M14=\"na\",$B14*$T$6,$B14*VLOOKUP(M14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2-2 - Odpovedá cenová ponuka na naše požiadavky?",3,"Áno",{"$f":"IF($C15=\"na\",$B15*$T$6,$B15*VLOOKUP(C15,$U$6:$V$8,2,FALSE))","v":6},null,{"$f":"IF(E15=\"na\",$B15*$T$6,$B15*VLOOKUP(E15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G15=\"na\",$B15*$T$6,$B15*VLOOKUP(G15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I15=\"na\",$B15*$T$6,$B15*VLOOKUP(I15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K15=\"na\",$B15*$T$6,$B15*VLOOKUP(K15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M15=\"na\",$B15*$T$6,$B15*VLOOKUP(M15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["2.3 - Popis záložného riešenia",3,"Detailné",{"$f":"IF($C16=\"na\",$B16*$T$6,$B16*VLOOKUP(C16,$S$6:$T$9,2,FALSE))","v":6},null,{"$f":"IF($E16=\"na\",$B16*$T$6,$B16*VLOOKUP(E16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G16=\"na\",$B16*$T$6,$B16*VLOOKUP(G16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I16=\"na\",$B16*$T$6,$B16*VLOOKUP(I16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K16=\"na\",$B16*$T$6,$B16*VLOOKUP(K16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M16=\"na\",$B16*$T$6,$B16*VLOOKUP(M16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["3 - TECHNICKÝ POPIS RIEŠENÍ",{"$f":"SUM(B18:B20)*2","v":18},{"$f":"SUM(D18:D20)","v":15},null,{"$f":"SUM(F18:F20)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H18:H20)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J18:J20)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L18:L20)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N18:N20)","v":{"$error":"#N/A"}}]
["3.1 - Popis mechanických zariadení",3,"Základné",{"$f":"IF($C18=\"na\",$B18*$T$6,$B18*VLOOKUP(C18,$S$6:$T$9,2,FALSE))","v":3},null,{"$f":"IF($E18=\"na\",$B18*$T$6,$B18*VLOOKUP(E18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G18=\"na\",$B18*$T$6,$B18*VLOOKUP(G18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I18=\"na\",$B18*$T$6,$B18*VLOOKUP(I18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K18=\"na\",$B18*$T$6,$B18*VLOOKUP(K18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M18=\"na\",$B18*$T$6,$B18*VLOOKUP(M18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["3.2 - Popis jednotlivých fáz dodania riešenia (výkresová dokumentácia, dispozičný plán, štúdia uskutočniteľnosi, simulácia...)",3,"Áno",{"$f":"IF($C19=\"na\",$B19*$T$6,$B19*VLOOKUP(C19,$U$6:$V$8,2,FALSE))","v":6},null,{"$f":"IF($E19=\"na\",$B19*$T$6,$B19*VLOOKUP(E19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G19=\"na\",$B19*$T$6,$B19*VLOOKUP(G19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I19=\"na\",$B19*$T$6,$B19*VLOOKUP(I19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K19=\"na\",$B19*$T$6,$B19*VLOOKUP(K19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M19=\"na\",$B19*$T$6,$B19*VLOOKUP(M19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["3.3 - Technické zhodnotenie riešenia",3,"Uspokojivé",{"$f":"IF($C20=\"na\",$B20*$T$6,$B20*VLOOKUP(C20,$W$6:$X$9,2,FALSE))","v":6},null,{"$f":"IF($E20=\"na\",$B20*$T$6,$B20*VLOOKUP(E20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G20=\"na\",$B20*$T$6,$B20*VLOOKUP(G20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I20=\"na\",$B20*$T$6,$B20*VLOOKUP(I20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K20=\"na\",$B20*$T$6,$B20*VLOOKUP(K20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M20=\"na\",$B20*$T$6,$B20*VLOOKUP(M20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["TECHNICKÝ OPIS Z POHĽADU AUTOMATIZÁCIE",{"$f":"SUM(B22:B23)*2","v":8},{"$f":"SUM(D22:D23)","v":4},null,{"$f":"SUM(F22:F23)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H22:H23)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J22:J23)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L22:L23)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N22:N23)","v":{"$error":"#N/A"}}]
["4.1 - Hodnotenie z pohľadu automatizácie",2,"Dostatočné",{"$f":"IF($C22=\"na\",$B22*$T$6,$B22*VLOOKUP(C22,$W$6:$X$9,2,FALSE))","v":2},null,{"$f":"IF($E22=\"na\",$B22*$T$6,$B22*VLOOKUP(E22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G22=\"na\",$B22*$T$6,$B22*VLOOKUP(G22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I22=\"na\",$B22*$T$6,$B22*VLOOKUP(I22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K22=\"na\",$B22*$T$6,$B22*VLOOKUP(K22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M22=\"na\",$B22*$T$6,$B22*VLOOKUP(M22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["4.1 - Hodnotenie z pohľadu efektu na existujúci dopravník",2,"Dostatočné",{"$f":"IF($C23=\"na\",$B23*$T$6,$B23*VLOOKUP(C23,$W$6:$X$9,2,FALSE))","v":2},null,{"$f":"IF($E23=\"na\",$B23*$T$6,$B23*VLOOKUP(E23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G23=\"na\",$B23*$T$6,$B23*VLOOKUP(G23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I23=\"na\",$B23*$T$6,$B23*VLOOKUP(I23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K23=\"na\",$B23*$T$6,$B23*VLOOKUP(K23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M23=\"na\",$B23*$T$6,$B23*VLOOKUP(M23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["SPOLU",{"$f":"B10+B13+B17+B21","v":48},{"$f":"IF(OR(D15=0,D20= 0),0,C10+C13+C17+C21)","v":38},null,{"$f":"IF(OR(F15=0,F20= 0),0,E10+E13+E17+E21)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(H15=0,H20= 0),0,G10+G13+G17+G21)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(J15=0,J20= 0),0,I10+I13+I17+I21)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(L15=0,L20= 0),0,K10+K13+K17+K21)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(N15=0,N20= 0),0,M10+M13+M17+M21)","v":{"$error":"#N/A"}}]
[]
["PROJEKTOVÉ RIADENIE A ORGANIZÁCIA","Weighting"]
["1 - PROJEKTOVÉ RIADENIE - Kvalita",{"$f":"SUM(B28:B30)*2","v":14},{"$f":"SUM(D28:D30)","v":12},null,{"$f":"SUM(F28:F30)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H28:H30)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J28:J30)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L28:L30)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N28:N30)","v":{"$error":"#N/A"}}]
["1.1 - Organizačná štruktúra riadenia projektu",2,"Základné",{"$f":"IF($C28=\"na\",$B28*$T$6,$B28*VLOOKUP(C28,$S$6:$T$9,2,FALSE))","v":2},null,{"$f":"IF($E28=\"na\",$B28*$T$6,$B28*VLOOKUP(E28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G28=\"na\",$B28*$T$6,$B28*VLOOKUP(G28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I28=\"na\",$B28*$T$6,$B28*VLOOKUP(I28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K28=\"na\",$B28*$T$6,$B28*VLOOKUP(K28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M28=\"na\",$B28*$T$6,$B28*VLOOKUP(M28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["1.2 - Zoznam subdodávateľov a ich organizácia",2,"Áno",{"$f":"IF($C29=\"na\",$B29*$T$6,$B29*VLOOKUP(C29,$U$6:$V$8,2,FALSE))","v":4},null,{"$f":"IF($E29=\"na\",$B29*$T$6,$B29*VLOOKUP(E29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G29=\"na\",$B29*$T$6,$B29*VLOOKUP(G29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G29=\"na\",$B29*$T$6,$B29*VLOOKUP(I29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K29=\"na\",$B29*$T$6,$B29*VLOOKUP(K29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M29=\"na\",$B29*$T$6,$B29*VLOOKUP(M29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["1.3 - Čašový plán zhodný s požiadavkami",3,"Áno",{"$f":"IF($C30=\"na\",$B30*$T$6,$B30*VLOOKUP(C30,$U$6:$V$8,2,FALSE))","v":6},null,{"$f":"IF($E30=\"na\",$B30*$T$6,$B30*VLOOKUP(E30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G30=\"na\",$B30*$T$6,$B30*VLOOKUP(G30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G30=\"na\",$B30*$T$6,$B30*VLOOKUP(I30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K30=\"na\",$B30*$T$6,$B30*VLOOKUP(K30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M30=\"na\",$B30*$T$6,$B30*VLOOKUP(M30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["2 - ORGANIZÁCIA PROJEKTOVÝCH AKTIVÍT",{"$f":"SUM(B32:B35)*2","v":16},{"$f":"SUM(D32:D35)","v":13},null,{"$f":"SUM(F32:F35)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H32:H35)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J32:J35)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L32:L35)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N32:N35)","v":{"$error":"#N/A"}}]
["2.1 - Popis dizajnovej a výrobnej fázy - štúdie",3,"Detailné",{"$f":"IF($C32=\"na\",$B32*$T$6,$B32*VLOOKUP(C32,$S$6:$T$9,2,FALSE))","v":6},null,{"$f":"IF($E32=\"na\",$B32*$T$6,$B32*VLOOKUP(E32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G32=\"na\",$B32*$T$6,$B32*VLOOKUP(G32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I32=\"na\",$B32*$T$6,$B32*VLOOKUP(I32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K32=\"na\",$B32*$T$6,$B32*VLOOKUP(K32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M32=\"na\",$B32*$T$6,$B32*VLOOKUP(M32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2.2 - Popis testov, predmontáž u dodávateľa a zoznam potrebných dielov",2,"Detailné",{"$f":"IF($C33=\"na\",$B33*$T$6,$B33*VLOOKUP(C33,$S$6:$T$9,2,FALSE))","v":4},null,{"$f":"IF($E33=\"na\",$B33*$T$6,$B33*VLOOKUP(E33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G33=\"na\",$B33*$T$6,$B33*VLOOKUP(G33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I33=\"na\",$B33*$T$6,$B33*VLOOKUP(I33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K33=\"na\",$B33*$T$6,$B33*VLOOKUP(K33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M33=\"na\",$B33*$T$6,$B33*VLOOKUP(M33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2.3 - Popis prítomnosti dodávateľa v PCA počas implementácie riešenia",1,"Základné",{"$f":"IF($C34=\"na\",$B34*$T$6,$B34*VLOOKUP(C34,$S$6:$T$9,2,FALSE))","v":1},null,{"$f":"IF($E34=\"na\",$B34*$T$6,$B34*VLOOKUP(E34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G34=\"na\",$B34*$T$6,$B34*VLOOKUP(G34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I34=\"na\",$B34*$T$6,$B34*VLOOKUP(I34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K34=\"na\",$B34*$T$6,$B34*VLOOKUP(K34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M34=\"na\",$B34*$T$6,$B34*VLOOKUP(M34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2.4 - Popis prítomnosti dodávateľa v PCA počas fázy nábehu až po finálne odovzdanie zariadenia do užívania",2,"Základné",{"$f":"IF($C35=\"na\",$B35*$T$6,$B35*VLOOKUP(C35,$S$6:$T$9,2,FALSE))","v":2},null,{"$f":"IF($C35=\"na\",$B35*$T$6,$B35*VLOOKUP(E35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G35=\"na\",$B35*$T$6,$B35*VLOOKUP(G35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I35=\"na\",$B35*$T$6,$B35*VLOOKUP(I35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K35=\"na\",$B35*$T$6,$B35*VLOOKUP(K35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M35=\"na\",$B35*$T$6,$B35*VLOOKUP(M35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["3 -KOMPETENCIE",{"$f":"SUM(B37:B37)*2","v":6},{"$f":"SUM(D37:D37)","v":6},null,{"$f":"SUM(F37:F37)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H37:H37)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J37:J37)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L37:L37)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N37:N37)","v":{"$error":"#N/A"}}]
["3.1 - Dodávateľ je kompetentný na dodanie technického riešenia",3,"Uspokojivé",{"$f":"IF($C37=\"na\",$B37*$T$6,$B37*VLOOKUP(C37,$W$6:$X$9,2,FALSE))","v":6},null,{"$f":"IF($E37=\"na\",$B37*$T$6,$B37*VLOOKUP(E37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G37=\"na\",$B37*$T$6,$B37*VLOOKUP(G37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I37=\"na\",$B37*$T$6,$B37*VLOOKUP(I37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K37=\"na\",$B37*$T$6,$B37*VLOOKUP(K37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M37=\"na\",$B37*$T$6,$B37*VLOOKUP(M37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["4 - PONUKA",{"$f":"SUM(B39:B41)*2","v":10},{"$f":"SUM(D39:D41)","v":7},null,{"$f":"SUM(F39:F41)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H39:H41)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J39:J41)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L39:L41)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N39:N41)","v":{"$error":"#N/A"}}]
["4.1 - Cenová ponuka dodaná načas - bez potreby urgovania",2,"Dostatočné",{"$f":"IF($C39=\"na\",$B39*$T$6,$B39*VLOOKUP(C39,$W$6:$X$9,2,FALSE))","v":2},null,{"$f":"IF($E39=\"na\",$B39*$T$6,$B39*VLOOKUP(E39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G39=\"na\",$B39*$T$6,$B39*VLOOKUP(G39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I39=\"na\",$B39*$T$6,$B39*VLOOKUP(I39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K39=\"na\",$B39*$T$6,$B39*VLOOKUP(K39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M39=\"na\",$B39*$T$6,$B39*VLOOKUP(M39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["4.2 - Vypracovanie cenovej ponuky (formát, zrozumiteľné informácie, ...)",1,"Dostatočné",{"$f":"IF($C40=\"na\",$B40*$T$6,$B40*VLOOKUP(C40,$W$6:$X$9,2,FALSE))","v":1},null,{"$f":"IF($E40=\"na\",$B40*$T$6,$B40*VLOOKUP(E40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G40=\"na\",$B40*$T$6,$B40*VLOOKUP(G40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I40=\"na\",$B40*$T$6,$B40*VLOOKUP(I40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K40=\"na\",$B40*$T$6,$B40*VLOOKUP(K40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M40=\"na\",$B40*$T$6,$B40*VLOOKUP(M40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["4.3 - Motivácia dodávateľa (proaktívny prístup)",2,"Uspokojivé",{"$f":"IF($C41=\"na\",$B41*$T$6,$B41*VLOOKUP(C41,$W$6:$X$9,2,FALSE))","v":4},null,{"$f":"IF($E41=\"na\",$B41*$T$6,$B41*VLOOKUP(E41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G41=\"na\",$B41*$T$6,$B41*VLOOKUP(G41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I41=\"na\",$B41*$T$6,$B41*VLOOKUP(I41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K41=\"na\",$B41*$T$6,$B41*VLOOKUP(K41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M41=\"na\",$B41*$T$6,$B41*VLOOKUP(M41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["SPOLU",{"$f":"B27+B31+B36+B38","v":46},{"$f":"IF(OR(D30=0,D37=0,),0,C27+C31+C36+C38)","v":38},null,{"$f":"IF(OR(F30=0,F37=0,),0,E27+E31+E36+E38)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(H30=0,H37=0,),0,G27+G31+G36+G38)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(J30=0,J37=0,),0,I27+I31+I36+I38)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(L30=0,L37=0,),0,K27+K31+K36+K38)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(N30=0,N37=0,),0,M27+M31+M36+M38)","v":{"$error":"#N/A"}}]
[]
["EKONOMICKÁ ČASŤ"]
["5 - CENA",{"$f":"B46*2","v":6},{"$f":"SUM(D46:D54)","v":6},null,{"$f":"SUM(F46:F54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H46:H54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J46:J54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L46:L54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N46:N54)","v":{"$error":"#N/A"}}]
["5.1 - Spĺňa ponúknutá cena našu požiadavku?",3,"Áno",{"$f":"IF($C46=\"na\",$B46*$T$6,$B46*VLOOKUP(C46,$U$6:$V$8,2,FALSE))","v":6},null,{"$f":"IF($E46=\"na\",$B46*$T$6,$B46*VLOOKUP(E46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G46=\"na\",$B46*$T$6,$B46*VLOOKUP(G46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I46=\"na\",$B46*$T$6,$B46*VLOOKUP(I46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K46=\"na\",$B46*$T$6,$B46*VLOOKUP(K46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M46=\"na\",$B46*$T$6,$B46*VLOOKUP(M46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["SPOLU",{"$f":"B45","v":6},{"$f":"D46","v":6},null,{"$f":"F46","v":{"$error":"#N/A"}},null,{"$f":"H46","v":{"$error":"#N/A"}},null,{"$f":"J46","v":{"$error":"#N/A"}},null,{"$f":"L46","v":{"$error":"#N/A"}},null,{"$f":"N46","v":{"$error":"#N/A"}}]
[]
["CELKOVÝ POČET BODOV           Body / 100",{"$f":"B24+B42+B47","v":100},{"$f":"IF(OR(C24=0,C42=0),0,C24+C42+C47)","v":82},null,{"$f":"IF(OR(E24=0,E42=0),0,E24+E42+E47)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(G24=0,G42=0),0,G24+G42+G47)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(I24=0,I42=0),0,I24+I42+I47)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(K24=0,K42=0),0,K24+K42+K47)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(M24=0,M42=0),0,M24+M42+M47)","v":{"$error":"#N/A"}}]
[]
["Známka / 20",null,{"$f":"20*C49/$B$49","v":16.4},null,{"$f":"20*E49/$B$49","v":{"$error":"#N/A"}},null,{"$f":"20*G49/$B$49","v":{"$error":"#N/A"}},null,{"$f":"20*I49/$B$49","v":{"$error":"#N/A"}},null,{"$f":"20*K49/$B$49","v":{"$error":"#N/A"}},null,{"$f":"20*M49/$B$49","v":{"$error":"#N/A"}}]

{"sheet":"Evaluation of suppliers","index":1,"n_rows":51,"n_cols":24,"rows_kept":51,"merged":[[0,0,0,5],[0,18,3,18],[0,19,3,19],[0,20,3,20],[0,21,3,21],[0,22,3,22],[0,23,3,23],[2,1,2,5],[3,1,3,5],[5,0,6,0],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[7,2,8,3],[7,4,8,5],[7,6,8,7],[7,8,8,9],[7,10,8,11],[7,12,8,13],[9,2,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[16,2,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[23,2,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,13],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[35,12,35,13],[37,2,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[37,12,37,13],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[41,12,41,13],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[46,12,46,13],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,13]]}
["EVALUATION OF SUPPLIERS",{"$nulls":17},"DO NOT ERASE","DO NOT ERASE","DO NOT ERASE","DO NOT ERASE","DO NOT ERASE","DO NOT ERASE"]
[]
["PROJECT (ACTIVITY) NAME:"]
["PROJECT MANAGER:"]
[]
["BREAKDOWN ",null,{"$f":"[1]Synthèse!A8","v":"SUPPLIER 1"},null,{"$f":"[1]Synthèse!A18","v":"SUPPLIER 2"},null,{"$f":"[1]Synthèse!A28","v":"SUPPLIER 3"},null,{"$f":"[1]Synthèse!A38","v":"SUPPLIER 4"},null,{"$f":"[1]Synthèse!A48","v":"SUPPLIER 5"},null,{"$f":"[1]Synthèse!A58","v":"SUPPLIER 6"},{"$nulls":5},"NA",2,"NA",2,"NA",2]
[null,null,"Description","Weighted grade","Description","Weighted grade","Description","Weighted grade","Description","Weighted grade","Description","Weighted grade","Description","Weighted grade",{"$nulls":4},"Absent",0,"No",0,"Insufficient",0]
[{"$nulls":18},"Basic",1,"Yes",2,"Passing",1]
["FUNCTIONAL TECHNICAL PART","Weighting",{"$nulls":16},"Detailed",2,null,null,"Satisfying",2]
["1 - PROJECT PRESENTATION",{"$f":"SUM(B11:B12)*2","v":4},{"$f":"SUM(D11:D12)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F11:F12)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H11:H12)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J11:J12)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L11:L12)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N11:N12)","v":{"$error":"#N/A"}}]
["1.1 - Reminder of reference documents  (CDC last version + Integrator CDC + AUT CDC …)",1,null,{"$f":"IF((C11=\"na\"),$B11*$T$6,$B11*VLOOKUP(C11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E11=\"na\",$B11*2,$B11*VLOOKUP(E11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G11=\"na\",$B11*2,$B11*VLOOKUP(G11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I11=\"na\",$B11*2,$B11*VLOOKUP(I11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K11=\"na\",$B11*2,$B11*VLOOKUP(K11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M11=\"na\",$B11*2,$B11*VLOOKUP(M11,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["1.2 - Consideration and respect of reference documents (+PV)",1,null,{"$f":"IF($C12=\"na\",$B12*$T$6,$B12*VLOOKUP(C12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E12=\"na\",$B12*$T$6,$B12*VLOOKUP(E12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G12=\"na\",$B12*$T$6,$B12*VLOOKUP(G12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I12=\"na\",$B12*$T$6,$B12*VLOOKUP(I12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF(K12=\"na\",$B12*$T$6,$B12*VLOOKUP(K12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M12=\"na\",$B12*$T$6,$B12*VLOOKUP(M12,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2 - DESCRIPTION OF OPERATIONS",{"$f":"SUM(B14:B16)*2","v":18},{"$f":"SUM(D14:D16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F14:F16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H14:H16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J14:J16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L14:L16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N14:N16)","v":{"$error":"#N/A"}}]
["2.1 - Description of equipment functioning ",3,null,{"$f":"IF($C14=\"na\",$B14*$T$6,$B14*VLOOKUP(C14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E14=\"na\",$B14*$T$6,$B14*VLOOKUP(E14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G14=\"na\",$B14*$T$6,$B14*VLOOKUP(G14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I14=\"na\",$B14*$T$6,$B14*VLOOKUP(I14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K14=\"na\",$B14*$T$6,$B14*VLOOKUP(K14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M14=\"na\",$B14*$T$6,$B14*VLOOKUP(M14,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2-2 - Did the supplier respond to the need?",3,null,{"$f":"IF($C15=\"na\",$B15*$T$6,$B15*VLOOKUP(C15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF(E15=\"na\",$B15*$T$6,$B15*VLOOKUP(E15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G15=\"na\",$B15*$T$6,$B15*VLOOKUP(G15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I15=\"na\",$B15*$T$6,$B15*VLOOKUP(I15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K15=\"na\",$B15*$T$6,$B15*VLOOKUP(K15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M15=\"na\",$B15*$T$6,$B15*VLOOKUP(M15,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["2.3 - Description of back-up procedures",3,null,{"$f":"IF($C16=\"na\",$B16*$T$6,$B16*VLOOKUP(C16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E16=\"na\",$B16*$T$6,$B16*VLOOKUP(E16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G16=\"na\",$B16*$T$6,$B16*VLOOKUP(G16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I16=\"na\",$B16*$T$6,$B16*VLOOKUP(I16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K16=\"na\",$B16*$T$6,$B16*VLOOKUP(K16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M16=\"na\",$B16*$T$6,$B16*VLOOKUP(M16,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["3 - TECHNICAL DESCRIPTION",{"$f":"SUM(B18:B20)*2","v":18},{"$f":"SUM(D18:D20)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F18:F20)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H18:H20)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J18:J20)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L18:L20)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N18:N20)","v":{"$error":"#N/A"}}]
["3.1 - Description of mechanical equipment",3,null,{"$f":"IF($C18=\"na\",$B18*$T$6,$B18*VLOOKUP(C18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E18=\"na\",$B18*$T$6,$B18*VLOOKUP(E18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G18=\"na\",$B18*$T$6,$B18*VLOOKUP(G18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I18=\"na\",$B18*$T$6,$B18*VLOOKUP(I18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K18=\"na\",$B18*$T$6,$B18*VLOOKUP(K18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M18=\"na\",$B18*$T$6,$B18*VLOOKUP(M18,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["3.2 - Presentation of an AVP (with documents on layout, feasibility, simulation…)",3,null,{"$f":"IF($C19=\"na\",$B19*$T$6,$B19*VLOOKUP(C19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E19=\"na\",$B19*$T$6,$B19*VLOOKUP(E19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G19=\"na\",$B19*$T$6,$B19*VLOOKUP(G19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I19=\"na\",$B19*$T$6,$B19*VLOOKUP(I19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K19=\"na\",$B19*$T$6,$B19*VLOOKUP(K19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M19=\"na\",$B19*$T$6,$B19*VLOOKUP(M19,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["3.3 - Technical level (quality, quantity).",3,null,{"$f":"IF($C20=\"na\",$B20*$T$6,$B20*VLOOKUP(C20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E20=\"na\",$B20*$T$6,$B20*VLOOKUP(E20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G20=\"na\",$B20*$T$6,$B20*VLOOKUP(G20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I20=\"na\",$B20*$T$6,$B20*VLOOKUP(I20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K20=\"na\",$B20*$T$6,$B20*VLOOKUP(K20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M20=\"na\",$B20*$T$6,$B20*VLOOKUP(M20,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["AUTOMATION TECHNICAL DESCRIPTION : HANDLLING (fill in with AUT and MAN correspondents)",{"$f":"SUM(B22:B23)*2","v":8},{"$f":"SUM(D22:D23)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F22:F23)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H22:H23)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J22:J23)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L22:L23)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N22:N23)","v":{"$error":"#N/A"}}]
["4.1 - ATE Grading (AUT)",2,null,{"$f":"IF($C22=\"na\",$B22*$T$6,$B22*VLOOKUP(C22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E22=\"na\",$B22*$T$6,$B22*VLOOKUP(E22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G22=\"na\",$B22*$T$6,$B22*VLOOKUP(G22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I22=\"na\",$B22*$T$6,$B22*VLOOKUP(I22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K22=\"na\",$B22*$T$6,$B22*VLOOKUP(K22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M22=\"na\",$B22*$T$6,$B22*VLOOKUP(M22,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["4.1 - CTE Grading (MAN)",2,null,{"$f":"IF($C23=\"na\",$B23*$T$6,$B23*VLOOKUP(C23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E23=\"na\",$B23*$T$6,$B23*VLOOKUP(E23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G23=\"na\",$B23*$T$6,$B23*VLOOKUP(G23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I23=\"na\",$B23*$T$6,$B23*VLOOKUP(I23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K23=\"na\",$B23*$T$6,$B23*VLOOKUP(K23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M23=\"na\",$B23*$T$6,$B23*VLOOKUP(M23,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["TOTAL ",{"$f":"B10+B13+B17+B21","v":48},{"$f":"IF(OR(D15=0,D20= 0),0,C10+C13+C17+C21)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(F15=0,F20= 0),0,E10+E13+E17+E21)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(H15=0,H20= 0),0,G10+G13+G17+G21)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(J15=0,J20= 0),0,I10+I13+I17+I21)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(L15=0,L20= 0),0,K10+K13+K17+K21)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(N15=0,N20= 0),0,M10+M13+M17+M21)","v":{"$error":"#N/A"}}]
[]
["PROJECT MANAGEMENT AND ORGANIZATION PART","Weighting"]
["1 - PROJECT MANAGEMENT - Quality Assurance Plan",{"$f":"SUM(B28:B30)*2","v":14},{"$f":"SUM(D28:D30)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F28:F30)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H28:H30)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J28:J30)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L28:L30)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N28:N30)","v":{"$error":"#N/A"}}]
["1.1 - Project Organisational chart",2,null,{"$f":"IF($C28=\"na\",$B28*$T$6,$B28*VLOOKUP(C28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E28=\"na\",$B28*$T$6,$B28*VLOOKUP(E28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G28=\"na\",$B28*$T$6,$B28*VLOOKUP(G28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I28=\"na\",$B28*$T$6,$B28*VLOOKUP(I28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K28=\"na\",$B28*$T$6,$B28*VLOOKUP(K28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M28=\"na\",$B28*$T$6,$B28*VLOOKUP(M28,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["1.2 - List of sub-contractors consulted and Organization  + Controle/Management ",2,null,{"$f":"IF($C29=\"na\",$B29*$T$6,$B29*VLOOKUP(C29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E29=\"na\",$B29*$T$6,$B29*VLOOKUP(E29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G29=\"na\",$B29*$T$6,$B29*VLOOKUP(G29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G29=\"na\",$B29*$T$6,$B29*VLOOKUP(I29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K29=\"na\",$B29*$T$6,$B29*VLOOKUP(K29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M29=\"na\",$B29*$T$6,$B29*VLOOKUP(M29,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["1.3 - Planning compliant with Specifications",3,null,{"$f":"IF($C30=\"na\",$B30*$T$6,$B30*VLOOKUP(C30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E30=\"na\",$B30*$T$6,$B30*VLOOKUP(E30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G30=\"na\",$B30*$T$6,$B30*VLOOKUP(G30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G30=\"na\",$B30*$T$6,$B30*VLOOKUP(I30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K30=\"na\",$B30*$T$6,$B30*VLOOKUP(K30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M30=\"na\",$B30*$T$6,$B30*VLOOKUP(M30,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["2 - ORGANIZATION OF PROJECT ACTIVITIES",{"$f":"SUM(B32:B35)*2","v":16},{"$f":"SUM(D32:D35)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F32:F35)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H32:H35)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J32:J35)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L32:L35)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N32:N35)","v":{"$error":"#N/A"}}]
["2.1 - Description of design, manufacturing phases",3,null,{"$f":"IF($C32=\"na\",$B32*$T$6,$B32*VLOOKUP(C32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E32=\"na\",$B32*$T$6,$B32*VLOOKUP(E32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G32=\"na\",$B32*$T$6,$B32*VLOOKUP(G32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I32=\"na\",$B32*$T$6,$B32*VLOOKUP(I32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K32=\"na\",$B32*$T$6,$B32*VLOOKUP(K32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M32=\"na\",$B32*$T$6,$B32*VLOOKUP(M32,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2.2 - Description of tests, pre-assembly at supplier's and the parts requirement",2,null,{"$f":"IF($C33=\"na\",$B33*$T$6,$B33*VLOOKUP(C33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E33=\"na\",$B33*$T$6,$B33*VLOOKUP(E33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G33=\"na\",$B33*$T$6,$B33*VLOOKUP(G33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I33=\"na\",$B33*$T$6,$B33*VLOOKUP(I33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K33=\"na\",$B33*$T$6,$B33*VLOOKUP(K33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M33=\"na\",$B33*$T$6,$B33*VLOOKUP(M33,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2.3 - Detail the on-site presence of Supplier during project and workshop phase",1,null,{"$f":"IF($C34=\"na\",$B34*$T$6,$B34*VLOOKUP(C34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E34=\"na\",$B34*$T$6,$B34*VLOOKUP(E34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G34=\"na\",$B34*$T$6,$B34*VLOOKUP(G34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I34=\"na\",$B34*$T$6,$B34*VLOOKUP(I34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K34=\"na\",$B34*$T$6,$B34*VLOOKUP(K34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M34=\"na\",$B34*$T$6,$B34*VLOOKUP(M34,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["2.4 - Description of production ramp-up and performances",2,null,{"$f":"IF($C35=\"na\",$B35*$T$6,$B35*VLOOKUP(C35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($C35=\"na\",$B35*$T$6,$B35*VLOOKUP(E35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G35=\"na\",$B35*$T$6,$B35*VLOOKUP(G35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I35=\"na\",$B35*$T$6,$B35*VLOOKUP(I35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K35=\"na\",$B35*$T$6,$B35*VLOOKUP(K35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M35=\"na\",$B35*$T$6,$B35*VLOOKUP(M35,$S$6:$T$9,2,FALSE))","v":{"$error":"#N/A"}}]
["3 -COMPETENCE",{"$f":"SUM(B37:B37)*2","v":6},{"$f":"SUM(D37:D37)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F37:F37)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H37:H37)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J37:J37)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L37:L37)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N37:N37)","v":{"$error":"#N/A"}}]
["3.1 - On technical and Project mangement levels",3,null,{"$f":"IF($C37=\"na\",$B37*$T$6,$B37*VLOOKUP(C37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E37=\"na\",$B37*$T$6,$B37*VLOOKUP(E37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G37=\"na\",$B37*$T$6,$B37*VLOOKUP(G37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I37=\"na\",$B37*$T$6,$B37*VLOOKUP(I37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K37=\"na\",$B37*$T$6,$B37*VLOOKUP(K37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M37=\"na\",$B37*$T$6,$B37*VLOOKUP(M37,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["4 - BID",{"$f":"SUM(B39:B41)*2","v":10},{"$f":"SUM(D39:D41)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F39:F41)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H39:H41)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J39:J41)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L39:L41)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N39:N41)","v":{"$error":"#N/A"}}]
["4.1 - Return of bid on time",2,"Satisfying",{"$f":"IF($C39=\"na\",$B39*$T$6,$B39*VLOOKUP(C39,$W$6:$X$9,2,FALSE))","v":4},null,{"$f":"IF($E39=\"na\",$B39*$T$6,$B39*VLOOKUP(E39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G39=\"na\",$B39*$T$6,$B39*VLOOKUP(G39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I39=\"na\",$B39*$T$6,$B39*VLOOKUP(I39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K39=\"na\",$B39*$T$6,$B39*VLOOKUP(K39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M39=\"na\",$B39*$T$6,$B39*VLOOKUP(M39,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["4.2 - Drafting bid (format, exhaustiveness)",1,"Satisfying",{"$f":"IF($C40=\"na\",$B40*$T$6,$B40*VLOOKUP(C40,$W$6:$X$9,2,FALSE))","v":2},null,{"$f":"IF($E40=\"na\",$B40*$T$6,$B40*VLOOKUP(E40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G40=\"na\",$B40*$T$6,$B40*VLOOKUP(G40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I40=\"na\",$B40*$T$6,$B40*VLOOKUP(I40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K40=\"na\",$B40*$T$6,$B40*VLOOKUP(K40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M40=\"na\",$B40*$T$6,$B40*VLOOKUP(M40,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["4.3 - Motivation of supplier (proactiveness)",2,null,{"$f":"IF($C41=\"na\",$B41*$T$6,$B41*VLOOKUP(C41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E41=\"na\",$B41*$T$6,$B41*VLOOKUP(E41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G41=\"na\",$B41*$T$6,$B41*VLOOKUP(G41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I41=\"na\",$B41*$T$6,$B41*VLOOKUP(I41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K41=\"na\",$B41*$T$6,$B41*VLOOKUP(K41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M41=\"na\",$B41*$T$6,$B41*VLOOKUP(M41,$W$6:$X$9,2,FALSE))","v":{"$error":"#N/A"}}]
["TOTAL",{"$f":"B27+B31+B36+B38","v":46},{"$f":"IF(OR(D30=0,D37=0,),0,C27+C31+C36+C38)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(F30=0,F37=0,),0,E27+E31+E36+E38)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(H30=0,H37=0,),0,G27+G31+G36+G38)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(J30=0,J37=0,),0,I27+I31+I36+I38)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(L30=0,L37=0,),0,K27+K31+K36+K38)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(N30=0,N37=0,),0,M27+M31+M36+M38)","v":{"$error":"#N/A"}}]
[]
["ECONOMIC PART"]
["5 - PRICE",{"$f":"B46*2","v":6},{"$f":"SUM(D46:D54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F46:F54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(H46:H54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(J46:J54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(L46:L54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(N46:N54)","v":{"$error":"#N/A"}}]
["5.1 - Is the bid coherent (technical price)?",3,null,{"$f":"IF($C46=\"na\",$B46*$T$6,$B46*VLOOKUP(C46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($E46=\"na\",$B46*$T$6,$B46*VLOOKUP(E46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($G46=\"na\",$B46*$T$6,$B46*VLOOKUP(G46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($I46=\"na\",$B46*$T$6,$B46*VLOOKUP(I46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($K46=\"na\",$B46*$T$6,$B46*VLOOKUP(K46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF($M46=\"na\",$B46*$T$6,$B46*VLOOKUP(M46,$U$6:$V$8,2,FALSE))","v":{"$error":"#N/A"}}]
["TOTAL",{"$f":"B45","v":6},{"$f":"D46","v":{"$error":"#N/A"}},null,{"$f":"F46","v":{"$error":"#N/A"}},null,{"$f":"H46","v":{"$error":"#N/A"}},null,{"$f":"J46","v":{"$error":"#N/A"}},null,{"$f":"L46","v":{"$error":"#N/A"}},null,{"$f":"N46","v":{"$error":"#N/A"}}]
[]
["OVERALL TOTAL           Points / 100",{"$f":"B24+B42+B47","v":100},{"$f":"IF(OR(C24=0,C42=0),0,C24+C42+C47)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(E24=0,E42=0),0,E24+E42+E47)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(G24=0,G42=0),0,G24+G42+G47)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(I24=0,I42=0),0,I24+I42+I47)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(K24=0,K42=0),0,K24+K42+K47)","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(M24=0,M42=0),0,M24+M42+M47)","v":{"$error":"#N/A"}}]
[]
["Grade / 20",null,{"$f":"20*C49/$B$49","v":{"$error":"#N/A"}},null,{"$f":"20*E49/$B$49","v":{"$error":"#N/A"}},null,{"$f":"20*G49/$B$49","v":{"$error":"#N/A"}},null,{"$f":"20*I49/$B$49","v":{"$error":"#N/A"}},null,{"$f":"20*K49/$B$49","v":{"$error":"#N/A"}},null,{"$f":"20*M49/$B$49","v":{"$error":"#N/A"}}]

{"sheet":"synchronisation","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"hidden":true,"merged":[[1,4,1,6],[3,4,3,6],[4,4,4,6],[5,3,6,3],[7,3,8,3],[9,3,10,3],[10,0,10,1]]}
[]
[{"$nulls":3},{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"feuille d'ouverture :\",\"sheet to open\")","v":"feuille d'ouverture :"}]
[]
[{"$nulls":3},{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"en-têtes et pieds de page synchronisés :\",\"synchronization of headings and footers:\")","v":"en-têtes et pieds de page synchronisés :"},"YES"]
[{"$nulls":3},{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Synchronisation automatique :\",\"Automatic synchronization:\")","v":"Synchronisation automatique :"},"NON"]
[{"$nulls":3},{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Taille de la police de caractères dans les en-têtes et pieds de page :\",\"Font size in the headers and footers:\")","v":"Taille de la police de caractères dans les en-têtes et pieds de page :"},10,8,10]
[{"$nulls":4},-10,10,-10]
[{"$f":"IF(synchronisation!langue_affichée=\"English\",\"Used template:\",\"modèle utilisé :\")","v":"modèle utilisé :"},"00964_08_00005 V 6.45",null,{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Nombre de lignes dans les en-têtes et pieds de page :\",\"Number of lines in the  headers and footers:\")","v":"Nombre de lignes dans les en-têtes et pieds de page :"},2,2,2]
[{"$nulls":4},1,1,1]
[{"$f":"IF(synchronisation!langue_affichée=\"English\",\"Caution: so that synchronisation is done automatically, this sheet should not be removed.\",\"Attention : pour que la synchronisation se fasse en automatique, cette feuille ne doit pas être supprimée.\")","v":"Attention : pour que la synchronisation se fasse en automatique, cette feuille ne doit pas être supprimée."},null,null,{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Contenu des en-têtes et pieds de page :\",\"Contents of the headings and footers:\")","v":"Contenu des en-têtes et pieds de page :"},"Reference","Title","Date"]
["Données synchronisées avec DocInfo (propriétés psa_XXX)",{"$nulls":3},"Owner","Pagination","Confidentiality"]
["psa_titre","CTE Template_English"]
["psa_reference","00963_16_00034"]
["psa_date_modification","25/10/2017 14:31",null,{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"langue affichée :\",\"posted language\")","v":"langue affichée :"},"French"]
["psa_auteur","GUYON MARTIAL - P522412  "]
["psa_emetteur","BINI ORTEGA CELINE - E481013 (ASSYSTEM FRANCE) "]
["psa_version","4.0"]
["psa_commentaire","Ce document est également consultable sur le site web CMON."]
["psa_status","publie"]
["psa_niveau_confidentialite","C1 - Non sensible"]
["psa_type_doc","Modèle"]
["psa_communaute","Métier Moyens montage"]
["psa_lecteurs","Tous les collaborateurs PSA, Tous les prestataires de PSA,"]
["psa_classements",""]
["psa_date_creation","14/01/2016 13:50"]
["psa_langue_principale","Français"]
["psa_confidentialite","A usage interne"]
["psa_url_fiche","http://docinfogroupe.inetpsa.com/ead/doc/ref.00963_16_00034/v.4.0"]
["psa_url_modification","http://docinfogroupe.inetpsa.com/ead/doc/modif/ref.00963_16_00034/fiche"]
["psa_date_publication","25/10/2017 14:31"]

{"sheet":"gestion documentaire","index":3,"n_rows":31,"n_cols":4,"rows_kept":31,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1],[22,0,22,1],[29,0,29,1]]}
[]
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Pour changer la langue affichée, utiliser la feuille \"\"synchronisation\"\" \",\"To change the posted language, use the synchronisation sheet\")","v":"Pour changer la langue affichée, utiliser la feuille \"synchronisation\" "}]
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"objet :\",\"Purpose:\")","v":"objet :"},{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Ce classeur est un modèle de classeur synchronisé avec sa fiche documentaire DocInfo. \nIl possède une interface intégrée qui permet d'implanter les éléments nécessaires à cette synchronisation dans un classeur non synchronisé.\",\"This workbook is a template workbook synchronised with its DocInfo document sheet. \nIt has an integrated interface which allows the information necessary for this synchronisation to be entered in a non-synchronised workbook.\")","v":"Ce classeur est un modèle de classeur synchronisé avec sa fiche documentaire DocInfo. \nIl possède une interface intégrée qui permet d'implanter les éléments nécessaires à cette synchronisation dans un classeur non synchronisé."}]
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"domaine d'application :\",\"application domain:\")","v":"domaine d'application :"},{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Il est applicable par tout le personnel CMON créant ou mettant un classeur EXCEL, dans DocInfo.\",\"It is applicable for all CMON personnel creating or placing an EXCEL workbook in DocInfo.\")","v":"Il est applicable par tout le personnel CMON créant ou mettant un classeur EXCEL, dans DocInfo."}]
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"principes généraux :\",\"general principles:\")","v":"principes généraux :"},{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Les explications détaillées sur son utilisation sont données dans le guide \"\"Synchronisation des pièces jointes Excel dans DocInfo\"\", référence \"\"00964_09_00398\"\".\",\"Detailed explanations concerning its use are given in the \"\"Synchronisation of  Excel attachments in DocInfo\"\" guide, reference \"\"00964_09_00398\"\".\")","v":"Les explications détaillées sur son utilisation sont données dans le guide \"Synchronisation des pièces jointes Excel dans DocInfo\", référence \"00964_09_00398\"."}]
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Cycle de révision :\",\"Revision cycle of document:\")","v":"Cycle de révision :"},"The CMON document system manager must revise this document at least once every 2 years and whenever an office tool is modified (DocInfo, Office, etc.) in a way that can impact the document. "]
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Vérification du respect du standard (VRS) :\",\"Checking standard compliance:\")","v":"Vérification du respect du standard (VRS) :"},"Reference documents, must be systematically revised by the person responsible for checking them while they are being formalized (all reference documents must be synchronized); all other documents will be punctually revised, by sampling, by the document system manager or CMON community managers."]
[]
["Update","Modification",{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Propriétaire\",\"Owner\")","v":"Propriétaire"},"Date"]
[10,"Deleted \"PR ratio\" evaluation criterion from form.","Eric FOSTIER","2012-02-10"]
[11,"Modified price objectives.","Jérôme LEBOUVIER","2012-04-02"]
[12,"Overall modifications of the CTE","Jérôme LEBOUVIER","2012-10-05"]
[13,"Corrections following remarks on validation round.","Jérôme LEBOUVIER","2012-10-22"]
[14,"Integrated whole document into an Excel framework","Jérôme LEBOUVIER","2012-11-19"]
{"$rows_empty":8}
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Documents de référence\",\"Reference documents\")","v":"Documents de référence"}]
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Référence\",\"Reference\")","v":"Référence"},{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Titre\",\"Title\")","v":"Titre"},"Location"]
["00964_09_00398",{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Synchronisation des pièces jointes Excel dans DocInfo\",\"Synchronisation of Excel attachments in DocInfo\")","v":"Synchronisation des pièces jointes Excel dans DocInfo"},"WEB DITV/CMON"]
[null,null,"(DocInfo)"]
[]
[]
[]
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"terminologie\",\"terminology:\")","v":"terminologie"}]
[{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Classeur synchronisé :\",\"Synchronised workbook\")","v":"Classeur synchronisé :"},{"$f":"IF(synchronisation!langue_affichée<>\"English\",\"Classeur EXCEL comportant des macros et une page de synchronisation permettant de récupérer en automatique certaines informations (titre, auteur, référence, version, etc.) depuis la fiche documentaire du classeur dans DocInfo.\",\"EXCEL workbook containing macros and a sync page allowing automatic retrieval of certain information (title, author, reference, version, etc.) from the workbook's document sheet in  DocInfo.\")","v":"Classeur EXCEL comportant des macros et une page de synchronisation permettant de récupérer en automatique certaines informations (titre, auteur, référence, version, etc.) depuis la fiche documentaire du classeur dans DocInfo."}]

{"sheet":"aide du modèle","index":4,"n_rows":67,"n_cols":4,"rows_kept":67,"hidden":true}
["\"Synchronization\" worksheet (formerly \"Cover page\")",null,null,{"$f":"LEN(C1)","v":0}]
[null,null,"This worksheet is essentially dedicated to the synchronization with the DocInfo document sheet. ",96]
[null,null,"It displays and makes available the synchronized data, allows the synchronized worksheet headers and footers to be configured and allows the synchronization mechanism to be copied into an existing work book.",207]
[null,null,"It also allows forcing the display of a given worksheet when the work book is opened.",85]
[null,"Synchronized data.",null,0]
[null,null,"The cover page includes a table with a yellow background containing the data synchronized with the DocInfo document sheet. This data comes from this sheet and is updated whenever the work book is opened.",203]
[null,null,"The table contains two columns: the right-hand column displays the name of the synchronized data (e.g.: \"psa_title\") and the left-hand column displays its value.",161]
[null,null,"To use this data in another worksheet of this work book, only enter the formula\"=psa_xxx\" in a cell of the target worksheet (with \"psa_xxx\" selected in the left-hand column of the table).",187]
[null,null,"This cell will then display the value indicated by the right-hand column of the table. This value will be automatically updated by DocInfo and refreshed on each opening of this work book.",187]
[null,"Opening worksheet.",null,0]
[null,null,"The green cells in the cover page allow the work book to be automatically opened at a predefined worksheet. Simply copy the name of the opening worksheet into the green cell at the extreme right. ",196]
[null,null,"If no worksheet is specified, the work book opens at the last worksheet opened (normal Excel operation).",104]
[null,"Synchronized worksheet headers and footers:",null,0]
[null,null,"To assist observance of the document management rules, this work book includes a macro which runs on each opening of the work book.",131]
[null,null,"This macro automatically creates the worksheet headers and footers with the information that must be present on all the worksheets of a shared document.",152]
[null,null,"On some PCs, and when the work book contains many worksheets, performance of this macro can take a long time (> 10 s). To get around this problem, the blue cells in the cover page allow performance of this macro to be configured:",229]
[null,null,"- If the field \"synchronized worksheet headers and footers\" is set to \"YES\", the macro is active. The worksheet headers and footers will be automatically created by the macro. Its activation will be governed by the \"automatic synchronization\" field. ",250]
[null,null,"If this field is set to \"YES\", the macro will run automatically on each opening of the work book. If it is set to \"NO\", a dialogue box will ask whether you want to update the worksheet headers and footers.",205]
[null,null,"- If the field \"synchronized worksheet headers and footers\" is set to \"NO\", the macro is inactive. The author of the document must create the headers and footers him or herself if their use is deemed necessary. ",211]
[null,null,"If the work book presents no response time problems, it is recommended that performance of the macro is left as automatic.",122]
[null,null,"If the macro is deactivated, the user producing the document must ensure the document management rules are observed by manually inserting the necessary synchronized fields in each of the worksheets in this work book.",216]
[null,"Re-synchronizing this work book",null,0]
[null,null,"This button allows display of the synchronized data to be manually updated. ",76]
[null,null,"This is useful after copying synchronization data into an existing work book (after this copy operation, the newly created cover page continues to display the info of the original work book). ",192]
[null,"Synchronization of an existing work book.",null,0]
[null,null,"The \"Synchronize other work books\" button present in the template displays a dialogue box which  allows you to synchronize already existing Excel work books. ",158]
[null,null,"The dialogue box contains two lists. The left-hand list indicates work books tjat are open but which do not contain the Synchronization macros and worksheet. The right-hand list contains work books that are open and already contain this information (excluding this template).",275]
[null,null,"It also contains tick boxes that allow you to choose ancillary worksheets (help and document management). ",106]
[null,null,"If the box is ticked and the worksheet already exists in the target work book, the old worksheet is deleted and replaced by the new one. ",137]
[null,null,"BEWARE: the worksheets are identified by the name of their VB module and not by the name which appears in the work book worksheet tabs (which allows the worksheets to be handled automatically even where the user has changed their names).",237]
[null,null,"To copy (or recopy) the macros and worksheets into a work book, simply select them by clicking on them, choose the ancillary worksheets to be copied, then click on the \"Install\" button.",185]
[null,null,"IMPORTANT: ",11]
[null,null,"To synchronize a work book already placed in DocInfo, you must open it in modification mode before opening the template in consultation mode + You can only display one work book in the dialogue box (the last one opened before opening the template).",248]
[null,null,"From the moment you open the template in consultation mode, there is no required opening order to be observed to synchronize work books placed on your PC + You can display as many as you want in the dialogue box.",212]
[null,"Template used",null,0]
[null,null,"The pink cells indicate the reference and version number of the template used to create the operational document. Under normal circumstances, they need not be modified by the user.",180]
[null,null,"In the template, the reference indicated must be that indicated by psa_reference. If this is the case, the version number is updated automatically by the Synchronization macros. ",178]
[null,null,"This allows the reference and version of the template used to be inserted in the document created, without human intervention.",126]
[null,null,"If the document created is also a template, then, to preserve this mechanism, the user producing this new template must manually specify the reference of the new template in place of that of the initial template.",212]
["\"Document management\" worksheet",null,null,0]
[null,null,"This worksheet allows documentary management of the document Its presence is mandatory for a reference document and left to the judgement of the user in the case of an operational document",188]
[null,null,"It must not confuse management of the template with that of the document created from the template: the user must delete the data from the template before reusing the \"document management\" worksheet in the work book created using the template.",243]
[null,"Document context.",null,0]
[null,null,"Purpose:  must indicate what the work book is used for.",55]
[null,null,"Area of application:  must indicate who uses the work book (all CMON employees, project managers, technical engineers etc...) as well as their conditions of application.",169]
[null,null,"May indicate situations where this work book does not apply (all sites, all projects, only in a certain factories or certain departments, etc.).",144]
[null,null,"General principles: must give information needed to understand the work book or its sections. In the case of a template, the reference documents implemented through this model must be mentioned. ",195]
[null,"Monitoring of changes.",null,0]
[null,null,"This table contains four columns:",33]
[null,null,"- revision must contain the revision number of the version described",68]
[null,null,"- modification  must contain a short description but specify changes made (modification of certain values following a RETEX, deletion of a test, correction of a bug, etc.)",171]
[null,null,"author: must specify who made the modification",46]
[null,null,"Date: date of the modification",30]
[null,null,"WARNING: this data must be entered manually and must be planned ahead (any modification of an attachment requires a new version number). ",137]
[null,null,"The first line is a bit specific, the version is always \"0.1\", the modification is always a \"creation\" and the date of modification is the date it was created, which can be found in the document sheet. ",202]
[null,null,"Only the author is entered in this line.",40]
[null,"Reference documents.",null,0]
[null,null,"This table must list each of the documents mentioned in this work book.",71]
[null,null,"For each one, it must specify: the reference, title and storage location ",73]
[null,null,"A link to the reference must allow consultation of this document. Another link to the storage location must allow access to it if the first link is faulty.",155]
[null,"Terminology",null,0]
[null,null,"This table is essentially intended for beginners It lists the abbreviations and esoteric terms used in the work book, thereby making it more readable. It also allows the exact sense of an expression to be stated where it can have several meanings.",247]
[null,null,"The author may make use of the various glossaries accessible on the CMON web site to complete this table.",105]
["Observance of the document management rules.",null,null,0]
[null,null,"Any shared document must have a reference (in the present case, the reference is automatically allocated by DocInfo when the document is created or stored). ",157]
[null,null,"The reference, version number, title, level of confidentiality and complete pagination must appear on each of the worksheets or attachments.",140]
[null,null,"The creation and modification dates, the name of the owner, the reference of the template used, and the names of the validators (if any) must appear at least once in the attachment(s).",184]