{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["VZT"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"VZT","index":0,"n_rows":193,"n_cols":17,"rows_kept":193,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"AKCE :","1CSCS a.s. - ROZVOJ A  REVITELIZACE VÝROBNÍHO AREÁLU\nD.1.41c - VZDUCHOTECHNIKA A VYTÁPĚNÍ - VRATOVÉ CLONY",null,null,null,null,null,null,null,null,null,{"$f":"V210","v":0}]
[null,"Dodavatel / Výrobce","Druh zboží","Číslo","Název položky","Měrná jednotka","Množství","Projekční MJ/Kč","Montaž %","Kód přirážky","Cena MJ","Materiál celkem","Nákupní cena brutto m.j.","Kód přirážky","Cena MJ","Montáž celkem","Cena Celkem"]
[]
[null,null,null,null,"Vzduchotechnika - specifikaci upřesní účastník dle konkrétního nabízeného typu vratových clon"]
[]
[null,null,null,null,"ZAŘÍZENí č.1 - Vratové clony"]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 5,0m x 5,0m (šxv) - poz. 1.1   "]
[]
[null,null,null,"1.1.","Vzduchová dveřní clona průmyslová horizontální studenovzdušná, předpokládané parametry:  Vmax=25 000m3/h, vent.P=1x1,95 kW, napětí 230 V - 50Hz, 10,8 A, 3100x500x480 (lxhxš), 152 kg","ks",1,null,null,"A",null,{"$f":"(G11*H11)","v":0},null,"D",null,{"$f":"SUM(L11/1)*I11","v":0},{"$f":"(L11+P11)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G12=0,H12=0),0,IF(I12<>0,((H12*(1-I12))*(1+VLOOKUP(J12,#REF!,2,0))),H12*(1+VLOOKUP(J12,#REF!,2,0))))","v":0},{"$f":"IF(J12=0,0,G12*K12)","v":0},null,"D",null,0,{"$f":"IF(OR(I12=100,K12=0),(G12*O12),(G12*K12*(1+#REF!))+(G12*O12))","v":0}]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální studenovzdušná, předpokládané parametry  Vmax=15 400m3/h, vent. P=1x1,17 kW, 230 V - 50Hz, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1,null,null,"A",null,{"$f":"(G13*H13)","v":0},null,"D",null,{"$f":"SUM(L13/1)*I13","v":0},{"$f":"(L13+P13)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G16=0,H16=0),0,IF(I16<>0,((H16*(1-I16))*(1+VLOOKUP(J16,#REF!,2,0))),H16*(1+VLOOKUP(J16,#REF!,2,0))))","v":0},0,null,"D",null,0,{"$f":"IF(OR(I16=100,K16=0),(G16*O16),(G16*K16*(1+#REF!))+(G16*O16))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G17*H17)","v":0},null,"D",null,0,{"$f":"(L17+P17)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G18=0,H18=0),0,IF(I18<>0,((H18*(1-I18))*(1+VLOOKUP(J18,#REF!,2,0))),H18*(1+VLOOKUP(J18,#REF!,2,0))))","v":0},0,null,"D",null,0,{"$f":"IF(OR(I18=100,K18=0),(G18*O18),(G18*K18*(1+#REF!))+(G18*O18))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G19*H19)","v":0},null,"D",null,{"$f":"SUM(L19/1)*I19","v":0},{"$f":"(L19+P19)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G21*H21)","v":0},null,"D",{"$f":"IF(E200=\"Ano\",K21*IF(ISNUMBER(N21)=TRUE,N21,VLOOKUP(N21,#REF!,2)),IF(M21=0,0,M21*(1+VLOOKUP(N21,#REF!,2,0))))","v":0},{"$f":"SUM(L21/1)*I21","v":0},{"$f":"(L21+P21)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G23*H23)","v":0},null,"D",{"$f":"IF(E202=\"Ano\",K23*IF(ISNUMBER(N23)=TRUE,N23,VLOOKUP(N23,F196:G197,2)),IF(M23=0,0,M23*(1+VLOOKUP(N23,#REF!,2,0))))","v":0},{"$f":"SUM(L23/1)*I23","v":0},{"$f":"(L23+P23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G24=0,H24=0),0,IF(I24<>0,((H24*(1-I24))*(1+VLOOKUP(J24,#REF!,2,0))),H24*(1+VLOOKUP(J24,#REF!,2,0))))","v":0},0,null,null,{"$f":"IF(E201=\"Ano\",K24*IF(ISNUMBER(N24)=TRUE,N24,VLOOKUP(N24,F196:G196,2)),IF(M24=0,0,M24*(1+VLOOKUP(N24,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I24=100,K24=0),(G24*O24),(G24*K24*(1+#REF!))+(G24*O24))","v":0}]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 5,0m x 5,0m (šxv) - Poz. 2.1  "]
[]
[null,null,null,"2.1.","Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry: Vmax=25 000m3/h, vent. P=1x1,95 kW, 230 - 50Hz V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1,null,null,"A",null,{"$f":"(G27*H27)","v":0},null,"D",{"$f":"IF(E206=\"Ano\",K27*IF(ISNUMBER(N27)=TRUE,N27,VLOOKUP(N27,F198:G201,2)),IF(M27=0,0,M27*(1+VLOOKUP(N27,#REF!,2,0))))","v":0},{"$f":"SUM(L27/1)*I27","v":0},{"$f":"(L27+P27)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G28=0,H28=0),0,IF(I28<>0,((H28*(1-I28))*(1+VLOOKUP(J28,#REF!,2,0))),H28*(1+VLOOKUP(J28,#REF!,2,0))))","v":0},{"$f":"IF(J28=0,0,G28*K28)","v":0},null,"D",{"$f":"IF(E208=\"Ano\",K28*IF(ISNUMBER(N28)=TRUE,N28,VLOOKUP(N28,F200:G203,2)),IF(M28=0,0,M28*(1+VLOOKUP(N28,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I28=100,K28=0),(G28*O28),(G28*K28*(1+#REF!))+(G28*O28))","v":0}]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální studenovzdušná, předpokládané parametry: Vmax=15 400m3/h, vent. P=1x1,17 kW, 230 V-50Hz, 6,5 A, 2100x500x480 (lxhxš), 94 kg   ","ks",1,null,null,"A",null,{"$f":"(G29*H29)","v":0},null,"D",{"$f":"IF(E208=\"Ano\",K29*IF(ISNUMBER(N29)=TRUE,N29,VLOOKUP(N29,F200:G203,2)),IF(M29=0,0,M29*(1+VLOOKUP(N29,#REF!,2,0))))","v":0},0,{"$f":"(L29+P29)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L31/1)*I31","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G32=0,H32=0),0,IF(I32<>0,((H32*(1-I32))*(1+VLOOKUP(J32,#REF!,2,0))),H32*(1+VLOOKUP(J32,#REF!,2,0))))","v":0},{"$f":"IF(J32=0,0,G32*K32)","v":0},null,"D",{"$f":"IF(E209=\"Ano\",K32*IF(ISNUMBER(N32)=TRUE,N32,VLOOKUP(N32,F201:G204,2)),IF(M32=0,0,M32*(1+VLOOKUP(N32,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I32=100,K32=0),(G32*O32),(G32*K32*(1+#REF!))+(G32*O32))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G33*H33)","v":0},null,"D",{"$f":"IF(E212=\"Ano\",K33*IF(ISNUMBER(N33)=TRUE,N33,VLOOKUP(N33,F204:G207,2)),IF(M33=0,0,M33*(1+VLOOKUP(N33,#REF!,2,0))))","v":0},{"$f":"SUM(L33/1)*I33","v":0},{"$f":"(L33+P33)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G34=0,H34=0),0,IF(I34<>0,((H34*(1-I34))*(1+VLOOKUP(J34,#REF!,2,0))),H34*(1+VLOOKUP(J34,#REF!,2,0))))","v":0},{"$f":"IF(J34=0,0,G34*K34)","v":0},null,"D",{"$f":"IF(E211=\"Ano\",K34*IF(ISNUMBER(N34)=TRUE,N34,VLOOKUP(N34,F203:G206,2)),IF(M34=0,0,M34*(1+VLOOKUP(N34,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I34=100,K34=0),(G34*O34),(G34*K34*(1+#REF!))+(G34*O34))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G35*H35)","v":0},null,"D",{"$f":"IF(E212=\"Ano\",K35*IF(ISNUMBER(N35)=TRUE,N35,VLOOKUP(N35,F204:G207,2)),IF(M35=0,0,M35*(1+VLOOKUP(N35,#REF!,2,0))))","v":0},0,{"$f":"(L35+P35)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G37*H37)","v":0},null,"D",{"$f":"IF(E214=\"Ano\",K37*IF(ISNUMBER(N37)=TRUE,N37,VLOOKUP(N37,F206:G209,2)),IF(M37=0,0,M37*(1+VLOOKUP(N37,#REF!,2,0))))","v":0},{"$f":"SUM(L37/1)*I37","v":0},{"$f":"(L37+P37)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G39*H39)","v":0},null,"D",{"$f":"IF(E216=\"Ano\",K39*IF(ISNUMBER(N39)=TRUE,N39,VLOOKUP(N39,F208:G211,2)),IF(M39=0,0,M39*(1+VLOOKUP(N39,#REF!,2,0))))","v":0},{"$f":"SUM(L39/1)*I39","v":0},{"$f":"(L39+P39)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 4,3m x 5,0m (šxv) - Poz. 3.1   "]
[]
[null,null,null,"3.1.","Vzduchová dveřní clona průmyslová horizontální studenovzdušná, Předpokládané parametry: Vmax=25 000m3/h, vent. P=1x1,95 kW, 230 V - 50Hz, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1,null,null,"A",null,{"$f":"(G43*H43)","v":0},null,"D",{"$f":"IF(E220=\"Ano\",K43*IF(ISNUMBER(N43)=TRUE,N43,VLOOKUP(N43,F212:G215,2)),IF(M43=0,0,M43*(1+VLOOKUP(N43,#REF!,2,0))))","v":0},{"$f":"SUM(L43/1)*I43","v":0},{"$f":"(L43+P43)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G44=0,H44=0),0,IF(I44<>0,((H44*(1-I44))*(1+VLOOKUP(J44,#REF!,2,0))),H44*(1+VLOOKUP(J44,#REF!,2,0))))","v":0},{"$f":"IF(J44=0,0,G44*K44)","v":0},null,"D",{"$f":"IF(E222=\"Ano\",K44*IF(ISNUMBER(N44)=TRUE,N44,VLOOKUP(N44,F214:G217,2)),IF(M44=0,0,M44*(1+VLOOKUP(N44,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I44=100,K44=0),(G44*O44),(G44*K44*(1+#REF!))+(G44*O44))","v":0}]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, Předpokládané parametry:  Vmax=14 400m3/h, P=1x1,17 kW, 230 V, 6,5 A, 1800x500x480 (lxhxš), 74 kg   ","ks",1,null,null,"A",null,{"$f":"(G45*H45)","v":0},null,"D",{"$f":"IF(E222=\"Ano\",K45*IF(ISNUMBER(N45)=TRUE,N45,VLOOKUP(N45,F214:G217,2)),IF(M45=0,0,M45*(1+VLOOKUP(N45,#REF!,2,0))))","v":0},0,{"$f":"(L45+P45)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L47/1)*I47","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G48=0,H48=0),0,IF(I48<>0,((H48*(1-I48))*(1+VLOOKUP(J48,#REF!,2,0))),H48*(1+VLOOKUP(J48,#REF!,2,0))))","v":0},{"$f":"IF(J48=0,0,G48*K48)","v":0},null,"D",{"$f":"IF(E223=\"Ano\",K48*IF(ISNUMBER(N48)=TRUE,N48,VLOOKUP(N48,F215:G218,2)),IF(M48=0,0,M48*(1+VLOOKUP(N48,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I48=100,K48=0),(G48*O48),(G48*K48*(1+#REF!))+(G48*O48))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G49*H49)","v":0},null,"D",{"$f":"IF(E224=\"Ano\",K49*IF(ISNUMBER(N49)=TRUE,N49,VLOOKUP(N49,F216:G219,2)),IF(M49=0,0,M49*(1+VLOOKUP(N49,#REF!,2,0))))","v":0},0,{"$f":"(L49+P49)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G50=0,H50=0),0,IF(I50<>0,((H50*(1-I50))*(1+VLOOKUP(J50,#REF!,2,0))),H50*(1+VLOOKUP(J50,#REF!,2,0))))","v":0},{"$f":"IF(J50=0,0,G50*K50)","v":0},null,"D",{"$f":"IF(E225=\"Ano\",K50*IF(ISNUMBER(N50)=TRUE,N50,VLOOKUP(N50,F217:G220,2)),IF(M50=0,0,M50*(1+VLOOKUP(N50,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I50=100,K50=0),(G50*O50),(G50*K50*(1+#REF!))+(G50*O50))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G51*H51)","v":0},null,"D",{"$f":"IF(E226=\"Ano\",K51*IF(ISNUMBER(N51)=TRUE,N51,VLOOKUP(N51,F218:G221,2)),IF(M51=0,0,M51*(1+VLOOKUP(N51,#REF!,2,0))))","v":0},0,{"$f":"(L51+P51)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G53*H53)","v":0},null,"D",{"$f":"IF(E228=\"Ano\",K53*IF(ISNUMBER(N53)=TRUE,N53,VLOOKUP(N53,F220:G223,2)),IF(M53=0,0,M53*(1+VLOOKUP(N53,#REF!,2,0))))","v":0},{"$f":"SUM(L53/1)*I53","v":0},{"$f":"(L53+P53)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G55*H55)","v":0},null,"D",{"$f":"IF(E230=\"Ano\",K55*IF(ISNUMBER(N55)=TRUE,N55,VLOOKUP(N55,F222:G225,2)),IF(M55=0,0,M55*(1+VLOOKUP(N55,#REF!,2,0))))","v":0},{"$f":"SUM(L55/1)*I55","v":0},{"$f":"(L55+P55)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 4,8m x 5,0m (šxv) - Poz. 4.1   "]
[]
[null,null,null,"4.1.","Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry Vmax=25 000m3/h, vent. P=1x1,95 kW, 230 V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1,null,null,"A",null,{"$f":"(G59*H59)","v":0},null,"D",{"$f":"IF(E234=\"Ano\",K59*IF(ISNUMBER(N59)=TRUE,N59,VLOOKUP(N59,F226:G229,2)),IF(M59=0,0,M59*(1+VLOOKUP(N59,#REF!,2,0))))","v":0},{"$f":"SUM(L59/1)*I59","v":0},{"$f":"(L59+P59)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G60=0,H60=0),0,IF(I60<>0,((H60*(1-I60))*(1+VLOOKUP(J60,#REF!,2,0))),H60*(1+VLOOKUP(J60,#REF!,2,0))))","v":0},{"$f":"IF(J60=0,0,G60*K60)","v":0},null,"D",{"$f":"IF(E236=\"Ano\",K60*IF(ISNUMBER(N60)=TRUE,N60,VLOOKUP(N60,F228:G231,2)),IF(M60=0,0,M60*(1+VLOOKUP(N60,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I60=100,K60=0),(G60*O60),(G60*K60*(1+#REF!))+(G60*O60))","v":0}]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry: Vmax=14 400m3/h, vent. P=1x1,17 kW, 230 V-50Hz, 6,5 A, 1800x500x480 (lxhxš), 74 kg   ","ks",1,null,null,"A",null,{"$f":"(G61*H61)","v":0},null,"D",{"$f":"IF(E236=\"Ano\",K61*IF(ISNUMBER(N61)=TRUE,N61,VLOOKUP(N61,F228:G231,2)),IF(M61=0,0,M61*(1+VLOOKUP(N61,#REF!,2,0))))","v":0},0,{"$f":"(L61+P61)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L63/1)*I63","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G64=0,H64=0),0,IF(I64<>0,((H64*(1-I64))*(1+VLOOKUP(J64,#REF!,2,0))),H64*(1+VLOOKUP(J64,#REF!,2,0))))","v":0},{"$f":"IF(J64=0,0,G64*K64)","v":0},null,"D",{"$f":"IF(E237=\"Ano\",K64*IF(ISNUMBER(N64)=TRUE,N64,VLOOKUP(N64,F229:G232,2)),IF(M64=0,0,M64*(1+VLOOKUP(N64,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I64=100,K64=0),(G64*O64),(G64*K64*(1+#REF!))+(G64*O64))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G65*H65)","v":0},null,"D",{"$f":"IF(E238=\"Ano\",K65*IF(ISNUMBER(N65)=TRUE,N65,VLOOKUP(N65,F230:G233,2)),IF(M65=0,0,M65*(1+VLOOKUP(N65,#REF!,2,0))))","v":0},0,{"$f":"(L65+P65)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G66=0,H66=0),0,IF(I66<>0,((H66*(1-I66))*(1+VLOOKUP(J66,#REF!,2,0))),H66*(1+VLOOKUP(J66,#REF!,2,0))))","v":0},{"$f":"IF(J66=0,0,G66*K66)","v":0},null,"D",{"$f":"IF(E239=\"Ano\",K66*IF(ISNUMBER(N66)=TRUE,N66,VLOOKUP(N66,F231:G234,2)),IF(M66=0,0,M66*(1+VLOOKUP(N66,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I66=100,K66=0),(G66*O66),(G66*K66*(1+#REF!))+(G66*O66))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G67*H67)","v":0},null,"D",{"$f":"IF(E240=\"Ano\",K67*IF(ISNUMBER(N67)=TRUE,N67,VLOOKUP(N67,F232:G235,2)),IF(M67=0,0,M67*(1+VLOOKUP(N67,#REF!,2,0))))","v":0},0,{"$f":"(L67+P67)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G69*H69)","v":0},null,"D",{"$f":"IF(E242=\"Ano\",K69*IF(ISNUMBER(N69)=TRUE,N69,VLOOKUP(N69,F234:G237,2)),IF(M69=0,0,M69*(1+VLOOKUP(N69,#REF!,2,0))))","v":0},{"$f":"SUM(L69/1)*I69","v":0},{"$f":"(L69+P69)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G71*H71)","v":0},null,"D",{"$f":"IF(E244=\"Ano\",K71*IF(ISNUMBER(N71)=TRUE,N71,VLOOKUP(N71,F236:G239,2)),IF(M71=0,0,M71*(1+VLOOKUP(N71,#REF!,2,0))))","v":0},{"$f":"SUM(L71/1)*I71","v":0},{"$f":"(L71+P71)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 6,9m x 5,1m (šxv) - Poz. 5.1   "]
[]
[null,null,null,"5.1.","Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry:  Vmax=25 000m3/h, vent. P=1x1,95 kW, 230 V - 50Hz, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1,null,null,"A",null,{"$f":"(G75*H75)","v":0},null,"D",{"$f":"IF(E248=\"Ano\",K75*IF(ISNUMBER(N75)=TRUE,N75,VLOOKUP(N75,F240:G243,2)),IF(M75=0,0,M75*(1+VLOOKUP(N75,#REF!,2,0))))","v":0},{"$f":"SUM(L75/1)*I75","v":0},{"$f":"(L75+P75)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G76=0,H76=0),0,IF(I76<>0,((H76*(1-I76))*(1+VLOOKUP(J76,#REF!,2,0))),H76*(1+VLOOKUP(J76,#REF!,2,0))))","v":0},{"$f":"IF(J76=0,0,G76*K76)","v":0},null,"D",{"$f":"IF(E250=\"Ano\",K76*IF(ISNUMBER(N76)=TRUE,N76,VLOOKUP(N76,F242:G245,2)),IF(M76=0,0,M76*(1+VLOOKUP(N76,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I76=100,K76=0),(G76*O76),(G76*K76*(1+#REF!))+(G76*O76))","v":0}]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální - studenovzdušná, předpokládané parametry: Vmax=15 400m3/h, vent. P=1x1,17 kW, 230 V - 50Hz, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1,null,null,"A",null,{"$f":"(G77*H77)","v":0},null,"D",{"$f":"IF(E250=\"Ano\",K77*IF(ISNUMBER(N77)=TRUE,N77,VLOOKUP(N77,F242:G245,2)),IF(M77=0,0,M77*(1+VLOOKUP(N77,#REF!,2,0))))","v":0},0,{"$f":"(L77+P77)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry: Vmax=14 400m3/h, vent. P=1x1,17 kW, 230 V - 50Hz, 6,5 A, 1800x500x480 (lxhxš), 74 kg   ","ks",1,null,null,"A",null,{"$f":"(G79*H79)","v":0},null,"D",{"$f":"IF(E252=\"Ano\",K79*IF(ISNUMBER(N79)=TRUE,N79,VLOOKUP(N79,F244:G247,2)),IF(M79=0,0,M79*(1+VLOOKUP(N79,#REF!,2,0))))","v":0},{"$f":"SUM(L79/1)*I79","v":0},{"$f":"(L79+P79)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L81/1)*I81","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G82=0,H82=0),0,IF(I82<>0,((H82*(1-I82))*(1+VLOOKUP(J82,#REF!,2,0))),H82*(1+VLOOKUP(J82,#REF!,2,0))))","v":0},{"$f":"IF(J82=0,0,G82*K82)","v":0},null,"D",{"$f":"IF(E251=\"Ano\",K82*IF(ISNUMBER(N82)=TRUE,N82,VLOOKUP(N82,F243:G246,2)),IF(M82=0,0,M82*(1+VLOOKUP(N82,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I82=100,K82=0),(G82*O82),(G82*K82*(1+#REF!))+(G82*O82))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G83*H83)","v":0},null,"D",{"$f":"IF(E252=\"Ano\",K83*IF(ISNUMBER(N83)=TRUE,N83,VLOOKUP(N83,F244:G247,2)),IF(M83=0,0,M83*(1+VLOOKUP(N83,#REF!,2,0))))","v":0},0,{"$f":"(L83+P83)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G84=0,H84=0),0,IF(I84<>0,((H84*(1-I84))*(1+VLOOKUP(J84,#REF!,2,0))),H84*(1+VLOOKUP(J84,#REF!,2,0))))","v":0},{"$f":"IF(J84=0,0,G84*K84)","v":0},null,"D",{"$f":"IF(E253=\"Ano\",K84*IF(ISNUMBER(N84)=TRUE,N84,VLOOKUP(N84,F245:G248,2)),IF(M84=0,0,M84*(1+VLOOKUP(N84,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I84=100,K84=0),(G84*O84),(G84*K84*(1+#REF!))+(G84*O84))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G85*H85)","v":0},null,"D",{"$f":"IF(E254=\"Ano\",K85*IF(ISNUMBER(N85)=TRUE,N85,VLOOKUP(N85,F246:G249,2)),IF(M85=0,0,M85*(1+VLOOKUP(N85,#REF!,2,0))))","v":0},0,{"$f":"(L85+P85)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",3,null,null,"A",null,{"$f":"(G87*H87)","v":0},null,"D",{"$f":"IF(E256=\"Ano\",K87*IF(ISNUMBER(N87)=TRUE,N87,VLOOKUP(N87,F248:G251,2)),IF(M87=0,0,M87*(1+VLOOKUP(N87,#REF!,2,0))))","v":0},{"$f":"SUM(L87/1)*I87","v":0},{"$f":"(L87+P87)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G89*H89)","v":0},null,"D",{"$f":"IF(E258=\"Ano\",K89*IF(ISNUMBER(N89)=TRUE,N89,VLOOKUP(N89,F250:G253,2)),IF(M89=0,0,M89*(1+VLOOKUP(N89,#REF!,2,0))))","v":0},{"$f":"SUM(L89/1)*I89","v":0},{"$f":"(L89+P89)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 4,9m x 5,om (šxv) - Poz. 6.1   "]
[]
[null,null,null,"6.1.","Vzduchová dveřní clona průmyslová horizontální studenovzdušná, předpokládané parametry: Vmax=25 000m3/h, vent. P=1x1,95 kW, 230 V - 50Hz, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1,null,null,"A",null,{"$f":"(G93*H93)","v":0},null,"D",{"$f":"IF(E264=\"Ano\",K93*IF(ISNUMBER(N93)=TRUE,N93,VLOOKUP(N93,F256:G259,2)),IF(M93=0,0,M93*(1+VLOOKUP(N93,#REF!,2,0))))","v":0},{"$f":"SUM(L93/1)*I93","v":0},{"$f":"(L93+P93)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G94=0,H94=0),0,IF(I94<>0,((H94*(1-I94))*(1+VLOOKUP(J94,#REF!,2,0))),H94*(1+VLOOKUP(J94,#REF!,2,0))))","v":0},{"$f":"IF(J94=0,0,G94*K94)","v":0},null,"D",{"$f":"IF(E266=\"Ano\",K94*IF(ISNUMBER(N94)=TRUE,N94,VLOOKUP(N94,F258:G261,2)),IF(M94=0,0,M94*(1+VLOOKUP(N94,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I94=100,K94=0),(G94*O94),(G94*K94*(1+#REF!))+(G94*O94))","v":0}]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry:  Vmax=15 400m3/h, vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1,null,null,"A",null,{"$f":"(G95*H95)","v":0},null,"D",{"$f":"IF(E266=\"Ano\",K95*IF(ISNUMBER(N95)=TRUE,N95,VLOOKUP(N95,F258:G261,2)),IF(M95=0,0,M95*(1+VLOOKUP(N95,#REF!,2,0))))","v":0},0,{"$f":"(L95+P95)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L97/1)*I97","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G98=0,H98=0),0,IF(I98<>0,((H98*(1-I98))*(1+VLOOKUP(J98,#REF!,2,0))),H98*(1+VLOOKUP(J98,#REF!,2,0))))","v":0},{"$f":"IF(J98=0,0,G98*K98)","v":0},null,"D",{"$f":"IF(E267=\"Ano\",K98*IF(ISNUMBER(N98)=TRUE,N98,VLOOKUP(N98,F259:G262,2)),IF(M98=0,0,M98*(1+VLOOKUP(N98,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I98=100,K98=0),(G98*O98),(G98*K98*(1+#REF!))+(G98*O98))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G99*H99)","v":0},null,"D",{"$f":"IF(E268=\"Ano\",K99*IF(ISNUMBER(N99)=TRUE,N99,VLOOKUP(N99,F260:G263,2)),IF(M99=0,0,M99*(1+VLOOKUP(N99,#REF!,2,0))))","v":0},0,{"$f":"(L99+P99)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G100=0,H100=0),0,IF(I100<>0,((H100*(1-I100))*(1+VLOOKUP(J100,#REF!,2,0))),H100*(1+VLOOKUP(J100,#REF!,2,0))))","v":0},{"$f":"IF(J100=0,0,G100*K100)","v":0},null,"D",{"$f":"IF(E269=\"Ano\",K100*IF(ISNUMBER(N100)=TRUE,N100,VLOOKUP(N100,F261:G264,2)),IF(M100=0,0,M100*(1+VLOOKUP(N100,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I100=100,K100=0),(G100*O100),(G100*K100*(1+#REF!))+(G100*O100))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G101*H101)","v":0},null,"D",{"$f":"IF(E270=\"Ano\",K101*IF(ISNUMBER(N101)=TRUE,N101,VLOOKUP(N101,F262:G265,2)),IF(M101=0,0,M101*(1+VLOOKUP(N101,#REF!,2,0))))","v":0},0,{"$f":"(L101+P101)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G103*H103)","v":0},null,"D",{"$f":"IF(E272=\"Ano\",K103*IF(ISNUMBER(N103)=TRUE,N103,VLOOKUP(N103,F264:G267,2)),IF(M103=0,0,M103*(1+VLOOKUP(N103,#REF!,2,0))))","v":0},{"$f":"SUM(L103/1)*I103","v":0},{"$f":"(L103+P103)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G105*H105)","v":0},null,"D",{"$f":"IF(E274=\"Ano\",K105*IF(ISNUMBER(N105)=TRUE,N105,VLOOKUP(N105,F266:G269,2)),IF(M105=0,0,M105*(1+VLOOKUP(N105,#REF!,2,0))))","v":0},{"$f":"SUM(L105/1)*I105","v":0},{"$f":"(L105+P105)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 4,9m x 5,0m (šxv) - Poz. 7.1   "]
[]
[null,null,null,"7.1.","Vzduchová dveřní clona průmyslová horizontální studenovzdušná,  předpokládané parametry : Vmax=25 000m3/h, vent. P=1x1,95 kW, 230 V-50Hz, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1,null,null,"A",null,{"$f":"(G109*H109)","v":0},null,"D",{"$f":"IF(E278=\"Ano\",K109*IF(ISNUMBER(N109)=TRUE,N109,VLOOKUP(N109,F270:G273,2)),IF(M109=0,0,M109*(1+VLOOKUP(N109,#REF!,2,0))))","v":0},{"$f":"SUM(L109/1)*I109","v":0},{"$f":"(L109+P109)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G110=0,H110=0),0,IF(I110<>0,((H110*(1-I110))*(1+VLOOKUP(J110,#REF!,2,0))),H110*(1+VLOOKUP(J110,#REF!,2,0))))","v":0},{"$f":"IF(J110=0,0,G110*K110)","v":0},null,"D",{"$f":"IF(E280=\"Ano\",K110*IF(ISNUMBER(N110)=TRUE,N110,VLOOKUP(N110,F272:G275,2)),IF(M110=0,0,M110*(1+VLOOKUP(N110,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I110=100,K110=0),(G110*O110),(G110*K110*(1+#REF!))+(G110*O110))","v":0}]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry: Vmax=15 400m3/h, vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1,null,null,"A",null,{"$f":"(G111*H111)","v":0},null,"D",{"$f":"IF(E280=\"Ano\",K111*IF(ISNUMBER(N111)=TRUE,N111,VLOOKUP(N111,F272:G275,2)),IF(M111=0,0,M111*(1+VLOOKUP(N111,#REF!,2,0))))","v":0},0,{"$f":"(L111+P111)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L113/1)*I113","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G114=0,H114=0),0,IF(I114<>0,((H114*(1-I114))*(1+VLOOKUP(J114,#REF!,2,0))),H114*(1+VLOOKUP(J114,#REF!,2,0))))","v":0},{"$f":"IF(J114=0,0,G114*K114)","v":0},null,"D",{"$f":"IF(E281=\"Ano\",K114*IF(ISNUMBER(N114)=TRUE,N114,VLOOKUP(N114,F273:G276,2)),IF(M114=0,0,M114*(1+VLOOKUP(N114,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I114=100,K114=0),(G114*O114),(G114*K114*(1+#REF!))+(G114*O114))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G115*H115)","v":0},null,"D",{"$f":"IF(E282=\"Ano\",K115*IF(ISNUMBER(N115)=TRUE,N115,VLOOKUP(N115,F274:G277,2)),IF(M115=0,0,M115*(1+VLOOKUP(N115,#REF!,2,0))))","v":0},0,{"$f":"(L115+P115)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G116=0,H116=0),0,IF(I116<>0,((H116*(1-I116))*(1+VLOOKUP(J116,#REF!,2,0))),H116*(1+VLOOKUP(J116,#REF!,2,0))))","v":0},{"$f":"IF(J116=0,0,G116*K116)","v":0},null,"D",{"$f":"IF(E283=\"Ano\",K116*IF(ISNUMBER(N116)=TRUE,N116,VLOOKUP(N116,F275:G278,2)),IF(M116=0,0,M116*(1+VLOOKUP(N116,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I116=100,K116=0),(G116*O116),(G116*K116*(1+#REF!))+(G116*O116))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G117*H117)","v":0},null,"D",{"$f":"IF(E284=\"Ano\",K117*IF(ISNUMBER(N117)=TRUE,N117,VLOOKUP(N117,F276:G279,2)),IF(M117=0,0,M117*(1+VLOOKUP(N117,#REF!,2,0))))","v":0},0,{"$f":"(L117+P117)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G119*H119)","v":0},null,"D",{"$f":"IF(E286=\"Ano\",K119*IF(ISNUMBER(N119)=TRUE,N119,VLOOKUP(N119,F278:G281,2)),IF(M119=0,0,M119*(1+VLOOKUP(N119,#REF!,2,0))))","v":0},{"$f":"SUM(L119/1)*I119","v":0},{"$f":"(L119+P119)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G121*H121)","v":0},null,"D",{"$f":"IF(E288=\"Ano\",K121*IF(ISNUMBER(N121)=TRUE,N121,VLOOKUP(N121,F280:G283,2)),IF(M121=0,0,M121*(1+VLOOKUP(N121,#REF!,2,0))))","v":0},{"$f":"SUM(L121/1)*I121","v":0},{"$f":"(L121+P121)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 4,9m x 4,2m (šxv) - Poz. 8.1   "]
[]
[null,null,null,"8.1.","Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry:  Vmax=25 000m3/h, vent. P=1x1,95 kW, 230 V-50Hz, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1,null,null,"A",null,{"$f":"(G125*H125)","v":0},null,"D",{"$f":"IF(E292=\"Ano\",K125*IF(ISNUMBER(N125)=TRUE,N125,VLOOKUP(N125,F284:G287,2)),IF(M125=0,0,M125*(1+VLOOKUP(N125,#REF!,2,0))))","v":0},{"$f":"SUM(L125/1)*I125","v":0},{"$f":"(L125+P125)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G126=0,H126=0),0,IF(I126<>0,((H126*(1-I126))*(1+VLOOKUP(J126,#REF!,2,0))),H126*(1+VLOOKUP(J126,#REF!,2,0))))","v":0},{"$f":"IF(J126=0,0,G126*K126)","v":0},null,"D",{"$f":"IF(E294=\"Ano\",K126*IF(ISNUMBER(N126)=TRUE,N126,VLOOKUP(N126,F286:G289,2)),IF(M126=0,0,M126*(1+VLOOKUP(N126,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I126=100,K126=0),(G126*O126),(G126*K126*(1+#REF!))+(G126*O126))","v":0}]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální studenovzdušná, předpokládané parametry:  Vmax=15 400m3/h, vent. P=1x1,17 kW, 230 V-50Hz, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1,null,null,"A",null,{"$f":"(G127*H127)","v":0},null,"D",{"$f":"IF(E294=\"Ano\",K127*IF(ISNUMBER(N127)=TRUE,N127,VLOOKUP(N127,F286:G289,2)),IF(M127=0,0,M127*(1+VLOOKUP(N127,#REF!,2,0))))","v":0},0,{"$f":"(L127+P127)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L129/1)*I129","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G130=0,H130=0),0,IF(I130<>0,((H130*(1-I130))*(1+VLOOKUP(J130,#REF!,2,0))),H130*(1+VLOOKUP(J130,#REF!,2,0))))","v":0},{"$f":"IF(J130=0,0,G130*K130)","v":0},null,"D",{"$f":"IF(E295=\"Ano\",K130*IF(ISNUMBER(N130)=TRUE,N130,VLOOKUP(N130,F287:G290,2)),IF(M130=0,0,M130*(1+VLOOKUP(N130,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I130=100,K130=0),(G130*O130),(G130*K130*(1+#REF!))+(G130*O130))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G131*H131)","v":0},null,"D",{"$f":"IF(E296=\"Ano\",K131*IF(ISNUMBER(N131)=TRUE,N131,VLOOKUP(N131,F288:G291,2)),IF(M131=0,0,M131*(1+VLOOKUP(N131,#REF!,2,0))))","v":0},0,{"$f":"(L131+P131)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G132=0,H132=0),0,IF(I132<>0,((H132*(1-I132))*(1+VLOOKUP(J132,#REF!,2,0))),H132*(1+VLOOKUP(J132,#REF!,2,0))))","v":0},{"$f":"IF(J132=0,0,G132*K132)","v":0},null,"D",{"$f":"IF(E297=\"Ano\",K132*IF(ISNUMBER(N132)=TRUE,N132,VLOOKUP(N132,F289:G292,2)),IF(M132=0,0,M132*(1+VLOOKUP(N132,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I132=100,K132=0),(G132*O132),(G132*K132*(1+#REF!))+(G132*O132))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G133*H133)","v":0},null,"D",{"$f":"IF(E298=\"Ano\",K133*IF(ISNUMBER(N133)=TRUE,N133,VLOOKUP(N133,F290:G293,2)),IF(M133=0,0,M133*(1+VLOOKUP(N133,#REF!,2,0))))","v":0},0,{"$f":"(L133+P133)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G135*H135)","v":0},null,"D",{"$f":"IF(E300=\"Ano\",K135*IF(ISNUMBER(N135)=TRUE,N135,VLOOKUP(N135,F292:G295,2)),IF(M135=0,0,M135*(1+VLOOKUP(N135,#REF!,2,0))))","v":0},{"$f":"SUM(L135/1)*I135","v":0},{"$f":"(L135+P135)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G137*H137)","v":0},null,"D",{"$f":"IF(E302=\"Ano\",K137*IF(ISNUMBER(N137)=TRUE,N137,VLOOKUP(N137,F294:G297,2)),IF(M137=0,0,M137*(1+VLOOKUP(N137,#REF!,2,0))))","v":0},{"$f":"SUM(L137/1)*I137","v":0},{"$f":"(L137+P137)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 4,2m x 4,0m (šxv) - Poz. 9.1   "]
[]
[null,null,null,"9.1.","Vzduchová dveřní clona průmyslová horizontální studenovzdušná, předpokládané parametry:  Vmax=15 400m3/h, vent. P=1x1,17 kW, 230 V-50Hz, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",2,null,null,"A",null,{"$f":"(G141*H141)","v":0},null,"D",{"$f":"IF(E306=\"Ano\",K141*IF(ISNUMBER(N141)=TRUE,N141,VLOOKUP(N141,F298:G301,2)),IF(M141=0,0,M141*(1+VLOOKUP(N141,#REF!,2,0))))","v":0},{"$f":"SUM(L141/1)*I141","v":0},{"$f":"(L141+P141)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L143/1)*I143","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G144=0,H144=0),0,IF(I144<>0,((H144*(1-I144))*(1+VLOOKUP(J144,#REF!,2,0))),H144*(1+VLOOKUP(J144,#REF!,2,0))))","v":0},{"$f":"IF(J144=0,0,G144*K144)","v":0},null,"D",{"$f":"IF(E307=\"Ano\",K144*IF(ISNUMBER(N144)=TRUE,N144,VLOOKUP(N144,F299:G302,2)),IF(M144=0,0,M144*(1+VLOOKUP(N144,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I144=100,K144=0),(G144*O144),(G144*K144*(1+#REF!))+(G144*O144))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G145*H145)","v":0},null,"D",{"$f":"IF(E308=\"Ano\",K145*IF(ISNUMBER(N145)=TRUE,N145,VLOOKUP(N145,F300:G303,2)),IF(M145=0,0,M145*(1+VLOOKUP(N145,#REF!,2,0))))","v":0},0,{"$f":"(L145+P145)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G146=0,H146=0),0,IF(I146<>0,((H146*(1-I146))*(1+VLOOKUP(J146,#REF!,2,0))),H146*(1+VLOOKUP(J146,#REF!,2,0))))","v":0},{"$f":"IF(J146=0,0,G146*K146)","v":0},null,"D",{"$f":"IF(E309=\"Ano\",K146*IF(ISNUMBER(N146)=TRUE,N146,VLOOKUP(N146,F301:G304,2)),IF(M146=0,0,M146*(1+VLOOKUP(N146,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I146=100,K146=0),(G146*O146),(G146*K146*(1+#REF!))+(G146*O146))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G147*H147)","v":0},null,"D",{"$f":"IF(E310=\"Ano\",K147*IF(ISNUMBER(N147)=TRUE,N147,VLOOKUP(N147,F302:G305,2)),IF(M147=0,0,M147*(1+VLOOKUP(N147,#REF!,2,0))))","v":0},0,{"$f":"(L147+P147)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G149*H149)","v":0},null,"D",{"$f":"IF(E312=\"Ano\",K149*IF(ISNUMBER(N149)=TRUE,N149,VLOOKUP(N149,F304:G307,2)),IF(M149=0,0,M149*(1+VLOOKUP(N149,#REF!,2,0))))","v":0},{"$f":"SUM(L149/1)*I149","v":0},{"$f":"(L149+P149)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G151*H151)","v":0},null,"D",{"$f":"IF(E314=\"Ano\",K151*IF(ISNUMBER(N151)=TRUE,N151,VLOOKUP(N151,F306:G309,2)),IF(M151=0,0,M151*(1+VLOOKUP(N151,#REF!,2,0))))","v":0},{"$f":"SUM(L151/1)*I151","v":0},{"$f":"(L151+P151)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 4,2m x 4,0m (šxv) - Poz. 10.1   "]
[]
[null,null,null,"10.1.","Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry: Vmax=15 400m3/h, vent. P=1x1,17 kW, 230 V-50Hz, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",2,null,null,"A",null,{"$f":"(G155*H155)","v":0},null,"D",{"$f":"IF(E318=\"Ano\",K155*IF(ISNUMBER(N155)=TRUE,N155,VLOOKUP(N155,F310:G313,2)),IF(M155=0,0,M155*(1+VLOOKUP(N155,#REF!,2,0))))","v":0},{"$f":"SUM(L155/1)*I155","v":0},{"$f":"(L155+P155)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L157/1)*I157","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G158=0,H158=0),0,IF(I158<>0,((H158*(1-I158))*(1+VLOOKUP(J158,#REF!,2,0))),H158*(1+VLOOKUP(J158,#REF!,2,0))))","v":0},{"$f":"IF(J158=0,0,G158*K158)","v":0},null,"D",{"$f":"IF(E319=\"Ano\",K158*IF(ISNUMBER(N158)=TRUE,N158,VLOOKUP(N158,F311:G314,2)),IF(M158=0,0,M158*(1+VLOOKUP(N158,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I158=100,K158=0),(G158*O158),(G158*K158*(1+#REF!))+(G158*O158))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G159*H159)","v":0},null,"D",{"$f":"IF(E320=\"Ano\",K159*IF(ISNUMBER(N159)=TRUE,N159,VLOOKUP(N159,F312:G315,2)),IF(M159=0,0,M159*(1+VLOOKUP(N159,#REF!,2,0))))","v":0},0,{"$f":"(L159+P159)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G160=0,H160=0),0,IF(I160<>0,((H160*(1-I160))*(1+VLOOKUP(J160,#REF!,2,0))),H160*(1+VLOOKUP(J160,#REF!,2,0))))","v":0},{"$f":"IF(J160=0,0,G160*K160)","v":0},null,"D",{"$f":"IF(E321=\"Ano\",K160*IF(ISNUMBER(N160)=TRUE,N160,VLOOKUP(N160,F313:G316,2)),IF(M160=0,0,M160*(1+VLOOKUP(N160,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I160=100,K160=0),(G160*O160),(G160*K160*(1+#REF!))+(G160*O160))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G161*H161)","v":0},null,"D",{"$f":"IF(E322=\"Ano\",K161*IF(ISNUMBER(N161)=TRUE,N161,VLOOKUP(N161,F314:G317,2)),IF(M161=0,0,M161*(1+VLOOKUP(N161,#REF!,2,0))))","v":0},0,{"$f":"(L161+P161)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G163*H163)","v":0},null,"D",{"$f":"IF(E324=\"Ano\",K163*IF(ISNUMBER(N163)=TRUE,N163,VLOOKUP(N163,F316:G319,2)),IF(M163=0,0,M163*(1+VLOOKUP(N163,#REF!,2,0))))","v":0},{"$f":"SUM(L163/1)*I163","v":0},{"$f":"(L163+P163)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G165*H165)","v":0},null,"D",{"$f":"IF(E326=\"Ano\",K165*IF(ISNUMBER(N165)=TRUE,N165,VLOOKUP(N165,F318:G321,2)),IF(M165=0,0,M165*(1+VLOOKUP(N165,#REF!,2,0))))","v":0},{"$f":"SUM(L165/1)*I165","v":0},{"$f":"(L165+P165)","v":0}]
[]
[null,null,null,null,"Vzduchová dveřní clona průmyslová horizontální složená pro rozměr vrat 3,2m x 4,5m (šxv) - Poz. 11.1   "]
[]
[null,null,null,"11.1.","Vzduchová dveřní clona průmyslová horizontální  studenovzdušná, předpokládané parametry: Vmax=14 400m3/h, vent. P=1x1,17 kW, 230 V-50Hz, 6,5 A, 1800x500x480 (lxhxš), 74 kg   ","ks",2,null,null,"A",null,{"$f":"(G169*H169)","v":0},null,"D",{"$f":"IF(E330=\"Ano\",K169*IF(ISNUMBER(N169)=TRUE,N169,VLOOKUP(N169,F322:G325,2)),IF(M169=0,0,M169*(1+VLOOKUP(N169,#REF!,2,0))))","v":0},{"$f":"SUM(L169/1)*I169","v":0},{"$f":"(L169+P169)","v":0}]
[]
[null,null,null,null,"Příslušenství :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L171/1)*I171","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G172=0,H172=0),0,IF(I172<>0,((H172*(1-I172))*(1+VLOOKUP(J172,#REF!,2,0))),H172*(1+VLOOKUP(J172,#REF!,2,0))))","v":0},{"$f":"IF(J172=0,0,G172*K172)","v":0},null,"D",{"$f":"IF(E331=\"Ano\",K172*IF(ISNUMBER(N172)=TRUE,N172,VLOOKUP(N172,F323:G326,2)),IF(M172=0,0,M172*(1+VLOOKUP(N172,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I172=100,K172=0),(G172*O172),(G172*K172*(1+#REF!))+(G172*O172))","v":0}]
[null,null,null,null,"Čtyřstupńový regulátor otáček","ks",1,null,null,"A",null,{"$f":"(G173*H173)","v":0},null,"D",{"$f":"IF(E332=\"Ano\",K173*IF(ISNUMBER(N173)=TRUE,N173,VLOOKUP(N173,F324:G327,2)),IF(M173=0,0,M173*(1+VLOOKUP(N173,#REF!,2,0))))","v":0},0,{"$f":"(L173+P173)","v":0}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G174=0,H174=0),0,IF(I174<>0,((H174*(1-I174))*(1+VLOOKUP(J174,#REF!,2,0))),H174*(1+VLOOKUP(J174,#REF!,2,0))))","v":0},{"$f":"IF(J174=0,0,G174*K174)","v":0},null,"D",{"$f":"IF(E333=\"Ano\",K174*IF(ISNUMBER(N174)=TRUE,N174,VLOOKUP(N174,F325:G328,2)),IF(M174=0,0,M174*(1+VLOOKUP(N174,#REF!,2,0))))","v":0},0,{"$f":"IF(OR(I174=100,K174=0),(G174*O174),(G174*K174*(1+#REF!))+(G174*O174))","v":0}]
[null,null,null,null,"Vratový kontakt magnetický přepínací","ks",1,null,null,"A",null,{"$f":"(G175*H175)","v":0},null,"D",{"$f":"IF(E334=\"Ano\",K175*IF(ISNUMBER(N175)=TRUE,N175,VLOOKUP(N175,F326:G329,2)),IF(M175=0,0,M175*(1+VLOOKUP(N175,#REF!,2,0))))","v":0},0,{"$f":"(L175+P175)","v":0}]
[]
[null,null,null,null,"Závěsy podstropní ","ks",2,null,null,"A",null,{"$f":"(G177*H177)","v":0},null,"D",{"$f":"IF(E336=\"Ano\",K177*IF(ISNUMBER(N177)=TRUE,N177,VLOOKUP(N177,F328:G331,2)),IF(M177=0,0,M177*(1+VLOOKUP(N177,#REF!,2,0))))","v":0},{"$f":"SUM(L177/1)*I177","v":0},{"$f":"(L177+P177)","v":0}]
[]
[null,null,null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1,null,null,"A",null,{"$f":"(G179*H179)","v":0},null,"D",{"$f":"IF(E338=\"Ano\",K179*IF(ISNUMBER(N179)=TRUE,N179,VLOOKUP(N179,F330:G333,2)),IF(M179=0,0,M179*(1+VLOOKUP(N179,#REF!,2,0))))","v":0},{"$f":"SUM(L179/1)*I179","v":0},{"$f":"(L179+P179)","v":0}]
[]
[null,null,null,null,"Materiál montážní na závěsy - závěsové systémy,  všechny prvky z pozinkované oceli","kg",275,null,null,null,null,null,null,null,null,{"$f":"SUM(G181*H181)","v":0},{"$f":"(L181+P181)","v":0}]
[]
[null,null,null,null,"Doprava","kmpl",11,null,null,null,null,null,null,null,null,{"$f":"SUM(G183*H183)","v":0},{"$f":"(L183+P183)","v":0}]
[]
[null,null,null,null,"Celkem zařízení č.1","kmpl",1,null,null,null,null,{"$f":"SUM(L7:L184)","v":0},null,null,null,{"$f":"SUM(P7:P184)","v":0},{"$f":"SUM(Q7:Q184)","v":0}]
[]
[null,null,null,null,"LEŠENÍ"]
[]
[null,null,null,null,"Lešení prostorové lehké, montáž do 10 m","m2",100,null,null,null,null,null,null,null,null,{"$f":"SUM(G189*H189)","v":0},{"$f":"(L189+P189)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L190/1)*I190","v":0}]
[null,null,null,null,"Celkem lešení","kmpl",1,null,null,null,null,{"$f":"SUM(L187:L190)","v":0},null,null,null,{"$f":"SUM(P187:P190)","v":0},{"$f":"SUM(Q187:Q190)","v":0}]
[]
[null,null,null,null,"Celkem",null,null,null,null,null,null,{"$f":"SUM(L185+L191)","v":0},null,null,null,{"$f":"SUM(P185+P191)","v":0},{"$f":"SUM(L193+P193)","v":0}]