{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["LKWsRukou","Určenie nákladného auta","údaje","LKW"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LKWsRukou","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[[36,1,36,6],[3,8,10,8],[0,1,0,6],[1,0,1,7],[13,8,21,8],[18,0,18,7]]}
[null,"Kombinácia sortimentov PORFIX podľa objemovej a pevnostnej triedy \n(podľa hmotnosti, bez uvažovania s priestorovým rozložením)"]
["AUTO"]
[null,"Druh výrobkov","Trieda/typ výrobku","Rozmer","Merná jednotka","Množstvo","Hmotnosť\n[kg]"]
[null,null,null,null,{"$f":"IF($D4=\"\",\" \",IF(OR($D4=\"500x250x500\",$D4=\"500x250x250\",$D4=\"500x250x300\",$D4=\"500x250x375\",$D4=\"500x250x50\",$D4=\"500x250x75\",$D4=\"500x250x100\",$D4=\"500x250x125\",$D4=\"500x250x150\",$D4=\"500x250x200\",$D4=\"248x249x175 - PD\",$D4=\"248x249x199 - PDK\",$D4=\"248x249x248 - PDK\",$D4=\"248x249x125 - PD\",$D4=\"248x249x150 - PD\",$D4=\"PORFIX\",$D4=\"PORFIX\",$D4=\"PORFIX AKU\"),\"pal\",\"ks\"))","v":" "},null,{"$f":"IFERROR($F4*VLOOKUP(_xlfn.CONCAT($C4,\" \",$D4),údaje!$H:$I,2,FALSE),\" \")","v":" "},null,"ZMENA AUTA"]
[null,null,null,null," ",null,{"$f":"IFERROR($F5*VLOOKUP(_xlfn.CONCAT($C5,\" \",$D5),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F6*VLOOKUP(_xlfn.CONCAT($C6,\" \",$D6),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F7*VLOOKUP(_xlfn.CONCAT($C7,\" \",$D7),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F8*VLOOKUP(_xlfn.CONCAT($C8,\" \",$D8),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F9*VLOOKUP(_xlfn.CONCAT($C9,\" \",$D9),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F10*VLOOKUP(_xlfn.CONCAT($C10,\" \",$D10),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F11*VLOOKUP(_xlfn.CONCAT($C11,\" \",$D11),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F12*VLOOKUP(_xlfn.CONCAT($C12,\" \",$D12),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F13*VLOOKUP(_xlfn.CONCAT($C13,\" \",$D13),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F14*VLOOKUP(_xlfn.CONCAT($C14,\" \",$D14),údaje!$H:$I,2,FALSE),\" \")","v":" "},null,"VYČISTIŤ\nFORMULÁR"]
[null,null,null,null," ",null,{"$f":"IFERROR($F15*VLOOKUP(_xlfn.CONCAT($C15,\" \",$D15),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F16*VLOOKUP(_xlfn.CONCAT($C16,\" \",$D16),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,"Spolu paliet",{"$f":"SUMIF(Tabuľka13[Merná jednotka],\"pal\",Tabuľka13[Množstvo])","v":0},"Spolu",{"$f":"SUBTOTAL(109,Tabuľka13[Hmotnosť\n'[kg']])","v":0}]
[]
["VLEK"]
[null,"Druh výrobkov","Trieda/typ výrobku","Rozmer","Merná jednotka","Množstvo","Hmotnosť\n[kg]"]
[null,null,null,null,{"$f":"IF($D21=\"\",\" \",IF(OR($D21=\"500x250x500\",$D21=\"500x250x250\",$D21=\"500x250x300\",$D21=\"500x250x375\",$D21=\"500x250x50\",$D21=\"500x250x75\",$D21=\"500x250x100\",$D21=\"500x250x125\",$D21=\"500x250x150\",$D21=\"500x250x200\",$D21=\"248x249x175 - PD\",$D21=\"248x249x199 - PDK\",$D21=\"248x249x248 - PDK\",$D21=\"248x249x125 - PD\",$D21=\"248x249x150 - PD\",$D21=\"PORFIX\",$D21=\"PORFIX\",$D21=\"PORFIX AKU\"),\"pal\",\"ks\"))","v":" "},null,{"$f":"IFERROR($F21*VLOOKUP(_xlfn.CONCAT($C21,\" \",$D21),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F22*VLOOKUP(_xlfn.CONCAT($C22,\" \",$D22),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F23*VLOOKUP(_xlfn.CONCAT($C23,\" \",$D23),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F24*VLOOKUP(_xlfn.CONCAT($C24,\" \",$D24),údaje!$H:$I,2,FALSE),\" \")","v":" "},null,{"$f":"IF(AND(OR($E21=\" \",$E21=\"pal\"),OR($E22=\" \",$E22=\"pal\"),OR($E23=\" \",$E23=\"pal\"),OR($E24=\" \",$E24=\"pal\"),OR($E25=\" \",$E25=\"pal\"),OR($E26=\" \",$E26=\"pal\"),OR($E27=\" \",$E27=\"pal\"),OR($E28=\" \",$E28=\"pal\"),OR($E29=\" \",$E29=\"pal\"),OR($E30=\" \",$E30=\"pal\"),OR($E31=\" \",$E31=\"pal\"),OR($E32=\" \",$E32=\"pal\"),OR($E33=\" \",$E33=\"pal\"),$G$34<14000),FALSE,IF($G$34<14000,FALSE,TRUE))","v":false}]
[null,null,null,null," ",null,{"$f":"IFERROR($F25*VLOOKUP(_xlfn.CONCAT($C25,\" \",$D25),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F26*VLOOKUP(_xlfn.CONCAT($C26,\" \",$D26),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F27*VLOOKUP(_xlfn.CONCAT($C27,\" \",$D27),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F28*VLOOKUP(_xlfn.CONCAT($C28,\" \",$D28),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F29*VLOOKUP(_xlfn.CONCAT($C29,\" \",$D29),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F30*VLOOKUP(_xlfn.CONCAT($C30,\" \",$D30),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F31*VLOOKUP(_xlfn.CONCAT($C31,\" \",$D31),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F32*VLOOKUP(_xlfn.CONCAT($C32,\" \",$D32),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null," ",null,{"$f":"IFERROR($F33*VLOOKUP(_xlfn.CONCAT($C33,\" \",$D33),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,"Spolu paliet",{"$f":"SUMIF(Tabuľka134[Merná jednotka],\"pal\",Tabuľka134[Množstvo])","v":0},"Spolu",{"$f":"SUBTOTAL(109,Tabuľka134[Hmotnosť\n'[kg']])","v":0}]
[null,null,null,null,null,"Hmotnosť spolu:",{"$f":"SUM(G34,G17)","v":0}]
[null,"POZNÁMKA:"]
[null,"-  maximálny počet paliet auta nesmie presiahnuť 10 ks, dĺžka auta je 6 m,\n-  maximálny počet paliet vleku nesmie presiahnuť 12 ks, dĺžka vleku je 6,5 m,\n- maximálna hmotnosť auta nesmie presiahnuť 15 000 kg,\n- maximálna hmotnosť vleku nesmie presiahnuť 14 000 kg,\n- maximálna hmotnosť súpravy nesmie presiahnuť 22 500 kg,\n- niektoré kombinácie murovacieho materiálu a doplnkovéo sortimentu nie je možné naložiť z dôvodu priestorového usporiadania a vyváženia náprav dopravného prostriedku napriek tomu, že celková hmotnosť nebude presiahnutá."]

{"sheet":"Určenie nákladného auta","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["VYBER DRUH NÁKLADNÉHO AUTA"]

{"sheet":"údaje","index":2,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["Murovací materiál",null,"Doplnkový sortiment","nosný preklad",null,"nosný preklad","1200x250x75",{"$f":"_xlfn.CONCAT(F1,\" \",G1)","v":"nosný preklad 1200x250x75"},52.1,0.09,10,0.75,4,null,null,"hmotnosť ks/pal"]
["Doplnkový sortiment",null,"Doplnkový sortiment","samonosný preklad L",null,"nosný preklad","1200x250x100",{"$f":"_xlfn.CONCAT(F2,\" \",G2)","v":"nosný preklad 1200x250x100"},56.4,0.15,6,0.75,4,null,null,"plocha 1 ks"]
[null,null,"Doplnkový sortiment","samonosný preklad",null,"nosný preklad","1200x250x125","nosný preklad 1200x250x125",73.8,0.15,6,0.75,4,null,null,"počet ks na palete"]
[null,null,"Doplnkový sortiment","U-profil",null,"nosný preklad","1500x250x75","nosný preklad 1500x250x75",65.099999999999994,0.11249999999999999,10,0.75,4,null,null,"šírka palety"]
[null,null,"Doplnkový sortiment","stropná vložka",null,"nosný preklad","1500x250x100","nosný preklad 1500x250x100",70.599999999999994,0.1875,6,0.75,4,null,null,"počet vrstiev paliet"]
[null,null,"Doplnkový sortiment","stropný nosník",null,"nosný preklad","1500x250x125","nosný preklad 1500x250x125",92.3,0.1875,6,0.75,4]
[null,null,"Doplnkový sortiment","zakladacia malta",null,"nosný preklad","1800x250x75","nosný preklad 1800x250x75",78.099999999999994,0.13500000000000001,10,0.75,4]
[null,null,"Doplnkový sortiment","lepidlo",null,"nosný preklad","1800x250x100","nosný preklad 1800x250x100",84.8,0.22500000000000001,6,0.75,4]
[null,null,"Murovací materiál","P2-400",null,"nosný preklad","1800x250x125","nosný preklad 1800x250x125",110.7,0.22500000000000001,6,0.75,4]
[null,null,"Murovací materiál","P2-440",null,"nosný preklad","2100x250x75","nosný preklad 2100x250x75",91.2,0.1575,10,0.75,4]
[null,null,"Murovací materiál","P2-500",null,"nosný preklad","2100x250x100","nosný preklad 2100x250x100",98.8,0.26250000000000001,6,0.75,4]
[null,null,"Murovací materiál","P4-600",null,"nosný preklad","2100x250x125","nosný preklad 2100x250x125",129.19999999999999,0.26250000000000001,6,0.75,4]
[null,null,"Murovací materiál","P6-650",null,"nosný preklad","2400x250x75","nosný preklad 2400x250x75",104.2,0.18,10,0.75,4]
[null,null,"Murovací materiál","AKU",null,"nosný preklad","2400x250x100","nosný preklad 2400x250x100",113,0.3,6,0.75,4]
[null,null,null,null,null,"nosný preklad","2400x250x125","nosný preklad 2400x250x125",147.6,0.3,6,0.75,4]
[null,null,null,null,null,"nosný preklad","2700x250x75","nosný preklad 2700x250x75",117.2,0.20250000000000001,10,0.75,4]
[null,null,null,null,null,"nosný preklad","2700x250x100","nosný preklad 2700x250x100",127.1,0.33750000000000002,6,0.75,4]
[null,null,null,null,null,"nosný preklad","2700x250x125","nosný preklad 2700x250x125",166.1,0.33750000000000002,6,0.75,4]
[null,null,null,null,null,"samonosný preklad L","1000x250x75","samonosný preklad L 1000x250x75",13,7.4999999999999997E-2,60,1.125,5]
[null,null,null,null,null,"samonosný preklad L","1000x250x100","samonosný preklad L 1000x250x100",17.100000000000001,0.1,50,1.125,5]
[null,null,null,null,null,"samonosný preklad L","1000x250x125","samonosný preklad L 1000x250x125",21.1,0.125,40,1.125,5]
[null,null,null,null,null,"samonosný preklad L","1000x250x150","samonosný preklad L 1000x250x150",25.2,0.15,30,1.125,5]
[null,null,null,null,null,"samonosný preklad L","1250x250x100","samonosný preklad L 1250x250x100",21.1,0.125,50,1.125,5]
[null,null,null,null,null,"samonosný preklad L","1250x250x125","samonosný preklad L 1250x250x125",26.2,0.15625,40,1.125,5]
[null,null,null,null,null,"samonosný preklad L","1250x250x150","samonosný preklad L 1250x250x150",31.3,0.1875,30,1.125,5]
[null,null,null,null,null,"samonosný preklad L","1500x250x100","samonosný preklad L 1500x250x100",25.2,0.15000000000000002,50,1.125,5]
[null,null,null,null,null,"samonosný preklad L","1500x250x125","samonosný preklad L 1500x250x125",31.3,0.1875,40,1.125,5]
[null,null,null,null,null,"samonosný preklad L","1500x250x150","samonosný preklad L 1500x250x150",37.4,0.22499999999999998,30,1.125,5]
[null,null,null,null,null,"samonosný preklad","2000x250x100","samonosný preklad 2000x250x100",42.8,0.2,50,1.125,5]
[null,null,null,null,null,"samonosný preklad","2000x250x125","samonosný preklad 2000x250x125",45.6,0.25,40,1.125,5]
[null,null,null,null,null,"samonosný preklad","2000x250x150","samonosný preklad 2000x250x150",53,0.3,30,1.125,5]
[null,null,null,null,null,"samonosný preklad","2500x250x100","samonosný preklad 2500x250x100",53.5,0.25,50,1.125,5]
[null,null,null,null,null,"samonosný preklad","2500x250x125","samonosný preklad 2500x250x125",57,0.3125,40,1.125,5]
[null,null,null,null,null,"samonosný preklad","2500x250x150","samonosný preklad 2500x250x150",66.3,0.375,30,1.125,5]
[null,null,null,null,null,"U-profil","500x250x200","U-profil 500x250x200",11.47,null,60,1.125,1]
[null,null,null,null,null,"U-profil","500x250x250","U-profil 500x250x250",12.81,null,48,1.125,1]
[null,null,null,null,null,"U-profil","500x250x300","U-profil 500x250x300",14.14,null,36,1.125,1]
[null,null,null,null,null,"U-profil","500x250x375","U-profil 500x250x375",19.170000000000002,null,36,1.125,1]
[null,null,null,null,null,"stropná vložka","500x200x250","stropná vložka 500x200x250",16.010000000000002,null,64,1.125,1]
[null,null,null,null,null,"stropný nosník",800,"stropný nosník 800",16,{"$f":"(G40/1000)*0.1875","v":0.15000000000000002},12,2.25,7]
[null,null,null,null,null,"stropný nosník",1000,"stropný nosník 1000",20,{"$f":"(G41/1000)*0.1875","v":0.1875},12,2.25,7]
[null,null,null,null,null,"stropný nosník",1200,"stropný nosník 1200",24,0.22499999999999998,12,2.25,7]
[null,null,null,null,null,"stropný nosník",1400,"stropný nosník 1400",28,0.26249999999999996,12,2.25,7]
[null,null,null,null,null,"stropný nosník",1600,"stropný nosník 1600",32,0.30000000000000004,12,2.25,7]
[null,null,null,null,null,"stropný nosník",1800,"stropný nosník 1800",36,0.33750000000000002,12,2.25,7]
[null,null,null,null,null,"stropný nosník",2000,"stropný nosník 2000",40,0.375,12,2.25,7]
[null,null,null,null,null,"stropný nosník",2200,"stropný nosník 2200",44,0.41250000000000003,12,2.25,7]
[null,null,null,null,null,"stropný nosník",2400,"stropný nosník 2400",48,0.44999999999999996,12,2.25,7]
[null,null,null,null,null,"stropný nosník",2600,"stropný nosník 2600",52,0.48750000000000004,12,2.25,7]
[null,null,null,null,null,"stropný nosník",2800,"stropný nosník 2800",56,0.52499999999999991,12,2.25,7]
[null,null,null,null,null,"stropný nosník",3000,"stropný nosník 3000",60,0.5625,12,2.25,7]
[null,null,null,null,null,"stropný nosník",3200,"stropný nosník 3200",64,0.60000000000000009,12,2.25,7]
[null,null,null,null,null,"stropný nosník",3400,"stropný nosník 3400",68,0.63749999999999996,12,2.25,7]
[null,null,null,null,null,"stropný nosník",3600,"stropný nosník 3600",72,0.67500000000000004,12,2.25,7]
[null,null,null,null,null,"stropný nosník",3800,"stropný nosník 3800",76,0.71249999999999991,12,2.25,7]
[null,null,null,null,null,"stropný nosník",4000,"stropný nosník 4000",80,0.75,12,2.25,7]
[null,null,null,null,null,"stropný nosník",4200,"stropný nosník 4200",84,0.78750000000000009,12,2.25,7]
[null,null,null,null,null,"stropný nosník",4400,"stropný nosník 4400",88,0.82500000000000007,12,2.25,7]
[null,null,null,null,null,"stropný nosník",4600,"stropný nosník 4600",92,0.86249999999999993,12,2.25,7]
[null,null,null,null,null,"stropný nosník",4800,"stropný nosník 4800",96,0.89999999999999991,12,2.25,7]
[null,null,null,null,null,"stropný nosník",5000,"stropný nosník 5000",100,0.9375,12,2.25,7]
[null,null,null,null,null,"stropný nosník",5200,"stropný nosník 5200",104,0.97500000000000009,12,2.25,7]
[null,null,null,null,null,"stropný nosník",5400,"stropný nosník 5400",108,1.0125000000000002,12,2.25,7]
[null,null,null,null,null,"stropný nosník",5600,"stropný nosník 5600",112,1.0499999999999998,12,2.25,7]
[null,null,null,null,null,"stropný nosník",5800,"stropný nosník 5800",116,1.0874999999999999,12,2.25,7]
[null,null,null,null,null,"stropný nosník",6000,{"$f":"_xlfn.CONCAT(F66,\" \",G66)","v":"stropný nosník 6000"},120,1.125,12,2.25,7]
[null,null,null,null,null,"stropný nosník",6200,"stropný nosník 6200",124,1.1625000000000001,12,2.25,7]
[null,null,null,null,null,"stropný nosník",6400,"stropný nosník 6400",128,1.2000000000000002,12,2.25,7]
[null,null,null,null,null,"stropný nosník",6600,"stropný nosník 6600",132,1.2374999999999998,12,2.25,7]
[null,null,null,null,null,"stropný nosník",6800,"stropný nosník 6800",136,1.2749999999999999,12,2.25,7]
[null,null,null,null,null,"stropný nosník",7000,"stropný nosník 7000",140,1.3125,12,2.25,7]
[null,null,null,null,null,"stropný nosník",7200,"stropný nosník 7200",144,1.35,12,2.25,7]
[null,null,null,null,null,"stropný nosník",7400,"stropný nosník 7400",148,1.3875000000000002,12,2.25,7]
[null,null,null,null,null,"stropný nosník",7600,"stropný nosník 7600",152,1.4249999999999998,12,2.25,7]
[null,null,null,null,null,"stropný nosník",7800,"stropný nosník 7800",156,1.4624999999999999,12,2.25,7]
[null,null,null,null,null,"stropný nosník",8000,"stropný nosník 8000",160,1.5,12,2.25,7]
[null,null,null,null,null,"zakladacia malta","PORFIX (20kg)","zakladacia malta PORFIX (20kg)",20,null,36,1.125,1]
[null,null,null,null,null,"lepidlo","PORFIX (20kg)","lepidlo PORFIX (20kg)",20,null,36,1.125,1]
[null,null,null,null,null,"lepidlo","PORFIX AKU (25kg)","lepidlo PORFIX AKU (25kg)",25,null,25,1.125,1]
[null,null,null,null,null,"P2-400","500x250x300","P2-400 500x250x300",875,null,1,1.125,1]
[null,null,null,null,null,"P2-400","500x250x375","P2-400 500x250x375",875,null,1,1.125,1]
[null,null,null,null,null,"P2-400","500x250x500","P2-400 500x250x500",875,null,1,1.125,1]
[null,null,null,null,null,"P2-440","500x250x250","P2-440 500x250x250",995,null,1,1.125,1]
[null,null,null,null,null,"P2-440","500x250x300","P2-440 500x250x300",995,null,1,1.125,1]
[null,null,null,null,null,"P2-440","500x250x375","P2-440 500x250x375",995,null,1,1.125,1]
[null,null,null,null,null,"P2-500","500x250x50","P2-500 500x250x50",1055,null,1,1.125,1]
[null,null,null,null,null,"P2-500","500x250x75","P2-500 500x250x75",1055,null,1,1.125,1]
[null,null,null,null,null,"P2-500","500x250x100","P2-500 500x250x100",1055,null,1,1.125,1]
[null,null,null,null,null,"P2-500","500x250x125","P2-500 500x250x125",1055,null,1,1.125,1]
[null,null,null,null,null,"P2-500","500x250x150","P2-500 500x250x150",1055,null,1,1.125,1]
[null,null,null,null,null,"P2-500","500x250x200","P2-500 500x250x200",1055,null,1,1.125,1]
[null,null,null,null,null,"P4-600","500x250x250","P4-600 500x250x250",1295,null,1,1.125,1]
[null,null,null,null,null,"P4-600","500x250x300","P4-600 500x250x300",1295,null,1,1.125,1]
[null,null,null,null,null,"P4-600","500x250x375","P4-600 500x250x375",1295,null,1,1.125,1]
[null,null,null,null,null,"P4-600","500x250x200","P4-600 500x250x200",1295,null,1,1.125,1]
[null,null,null,null,null,"P6-650","500x250x250","P6-650 500x250x250",1430,null,1,1.125,1]
[null,null,null,null,null,"P6-650","500x250x300","P6-650 500x250x300",1430,null,1,1.125,1]
[null,null,null,null,null,"P6-650","500x250x375","P6-650 500x250x375",1430,null,1,1.125,1]
[null,null,null,null,null,"P6-650","500x250x200","P6-650 500x250x200",1430,null,1,1.125,1]
[null,null,null,null,null,"AKU","248x249x175 - PD","AKU 248x249x175 - PD",1317,null,1,1.125,1]
[null,null,null,null,null,"AKU","248x249x199 - PDK","AKU 248x249x199 - PDK",1256,null,1,1.125,1]
[null,null,null,null,null,"AKU","248x249x248 - PDK","AKU 248x249x248 - PDK",1321,null,1,1.125,1]
[null,null,null,null,null,"AKU","248x249x125 - PD","AKU 248x249x125 - PD",1205,null,1,1.125,1]
[null,null,null,null,null,"AKU","248x249x150 - PD","AKU 248x249x150 - PD",1296,null,1,1.125,1]

{"sheet":"LKW","index":3,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":true,"merged":[[27,1,68,6],[13,8,22,8],[0,1,0,6],[26,1,26,6],[1,0,1,7],[4,8,11,8]]}
[null,"Kombinácia sortimentov PORFIX podľa objemovej a pevnostnej triedy \n(podľa hmotnosti, bez uvažovania s priestorovým rozložením)"]
[]
[null,"Druh výrobkov","Trieda/typ výrobku","Rozmer","Merná jednotka","Množstvo","Hmotnosť\n[kg]"]
[null,null,null,null,{"$f":"IF($B4=\"Murovací materiál\",\"pal\",IF($B4=\"Doplnkový sortiment\",\"ks\",\"\"))","v":""},null,{"$f":"IFERROR($F4*VLOOKUP(_xlfn.CONCAT($C4,\" \",$D4),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F5*VLOOKUP(_xlfn.CONCAT($C5,\" \",$D5),údaje!$H:$I,2,FALSE),\" \")","v":" "},null,"ZMENA AUTA"]
[null,null,null,null,"",null,{"$f":"IFERROR($F6*VLOOKUP(_xlfn.CONCAT($C6,\" \",$D6),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F7*VLOOKUP(_xlfn.CONCAT($C7,\" \",$D7),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F8*VLOOKUP(_xlfn.CONCAT($C8,\" \",$D8),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F9*VLOOKUP(_xlfn.CONCAT($C9,\" \",$D9),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F10*VLOOKUP(_xlfn.CONCAT($C10,\" \",$D10),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F11*VLOOKUP(_xlfn.CONCAT($C11,\" \",$D11),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F12*VLOOKUP(_xlfn.CONCAT($C12,\" \",$D12),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F13*VLOOKUP(_xlfn.CONCAT($C13,\" \",$D13),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F14*VLOOKUP(_xlfn.CONCAT($C14,\" \",$D14),údaje!$H:$I,2,FALSE),\" \")","v":" "},null,"VYČISTIŤ\nFORMULÁR"]
[null,null,null,null,"",null,{"$f":"IFERROR($F15*VLOOKUP(_xlfn.CONCAT($C15,\" \",$D15),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F16*VLOOKUP(_xlfn.CONCAT($C16,\" \",$D16),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F17*VLOOKUP(_xlfn.CONCAT($C17,\" \",$D17),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F18*VLOOKUP(_xlfn.CONCAT($C18,\" \",$D18),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F19*VLOOKUP(_xlfn.CONCAT($C19,\" \",$D19),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F20*VLOOKUP(_xlfn.CONCAT($C20,\" \",$D20),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F21*VLOOKUP(_xlfn.CONCAT($C21,\" \",$D21),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F22*VLOOKUP(_xlfn.CONCAT($C22,\" \",$D22),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,null,"",null,{"$f":"IFERROR($F23*VLOOKUP(_xlfn.CONCAT($C23,\" \",$D23),údaje!$H:$I,2,FALSE),\" \")","v":" "}]
[null,null,null,"Spolu paliet",{"$f":"SUMIF(Tabuľka1[Merná jednotka],\"pal\",Tabuľka1[Množstvo])","v":0},"Spolu",{"$f":"SUBTOTAL(109,Tabuľka1[Hmotnosť\n'[kg']])","v":0}]
[]
[null,"POZNÁMKA:"]
[null,"-  maximálny počet paliet nesmie presiahnuť 26 ks,\n- maximálna hmotnosť nesmie presiahnuť 22 500 kg,\n- niektoré kombinácie murovacieho materiálu a doplnkovéo sortimentu nie je možné naložiť z dôvodu priestorového usporiadania a vyváženia náprav dopravného prostriedku napriek tomu, že celková hmotnosť nebude presiahnutá."]