{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["REK","UT","PLYN","ZTI","CHL","VZT","FVE"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":18,"comments":6,"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":"REK","index":0,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[24,0,24,2],[28,0,28,2],[19,0,19,3],[42,0,43,3],[29,0,29,2],[8,0,8,3],[10,0,10,3],[11,0,11,3],[13,0,13,3],[14,0,14,3],[17,0,17,3],[21,0,21,3],[27,0,27,2],[26,0,26,2],[23,0,23,2],[22,0,22,2],[25,0,25,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Zapsána u Krajského obchodního soudu v Brně, oddíl B, vložka 6207"]
[]
["Sídlo: NWT a.s., nám. Míru 1217, 768 24 Hulín"]
["IČO: 63469511, DIČ: CZ63469511, Bankovní spojení: 178049258/0300"]
[]
["Pobočka Zlín: NWT a.s., tř. Tomáše Bati, 760 01 Zlín"]
[" e-mail: jakub.mracek@nwt.cz"]
[]
[]
["Rozpočet RD ŠTĚRBÁČEK"]
[]
["RD ŠTĚRBÁČEK"]
[]
["Rekapitulace - Celková"]
["Dodávky",null,null,"Cena v Kč"]
["UT",null,null,{"$f":"UT!N69","v":520}]
["PLYN",null,null,{"$f":"PLYN!N69","v":144}]
["ZTI",null,null,{"$f":"ZTI!N69","v":144}]
["CHL",null,null,{"$f":"CHL!N69","v":144}]
["VZT",null,null,{"$f":"VZT!N185","v":0}]
["FVE",null,null,{"$f":"FVE!N69","v":144}]
["Dodávka celkem:",null,null,{"$f":"SUM(D24:D29)","v":1096}]
[]
["Ceny jsou uvedeny v Kč bez DPH."]
[]
["Nabídku zpracoval:","Radim Pešek","Kontroloval:"]
["Dne:",{"$f":"TODAY()","v":"2018-08-21"},"Revize ze dne:"]
["Kontaktní telefon:",420720053792,"Revize číslo:"]
["E-mail:","radim.pesek@nwt.cz","Datum tisku:"]
[null,null,"Kurz EURO:",26.5]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Ano"]
[null,null,null,null,null,null,null,null,null,null,"Ne"]

{"sheet":"UT","index":1,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[67,10,67,11],[67,13,67,14],[68,10,68,12],[68,13,68,14],[64,10,64,11],[64,13,64,14],[65,10,65,11],[65,13,65,14],[66,1,66,3],[66,10,66,11],[66,13,66,14],[61,3,61,4],[61,10,61,11],[61,13,61,14],[62,10,62,11],[62,13,62,14],[63,10,63,11],[63,13,63,14],[59,3,59,4],[59,10,59,11],[59,12,59,14],[60,3,60,4],[60,10,60,11],[60,13,60,14],[57,3,57,6],[57,10,57,11],[57,13,57,14],[58,3,58,4],[58,10,58,11],[58,12,58,14]]}
[]
[null,null,null,"AKCE :",{"$f":"REK!$A$18","v":"Rozpočet RD ŠTĚRBÁČEK"},null,null,null,null,null,null,null,null,null,{"$f":"V84","v":0}]
[null,"Dodavatel / Výrobce","Druh zboží","Číslo","Název položky","Měrná jednotka","Množství","Nákupní cena brutto MJ","Rabat %","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,null,"ks",1,100,null,"A",{"$f":"IF(OR(G5=0,H5=0),0,IF(I5<>0,((H5*(1-I5))*(1+VLOOKUP(J5,$F$59:$G$62,2,0))),H5*(1+VLOOKUP(J5,$F$59:$G$62,2,0))))","v":100},{"$f":"IF(J5=0,0,G5*K5)","v":100},0,0.2,{"$f":"IF(E67=\"Ano\",K5*IF(ISNUMBER(N5)=TRUE,N5,VLOOKUP(N5,F59:G62,2)),IF(M5=0,0,M5*(1+VLOOKUP(N5,$F$59:$G$62,2,0))))","v":20},{"$f":"IF(N5=0,0,G5*O5)","v":20},{"$f":"IF(OR(I5=100,K5=0),(G5*O5),(G5*K5*(1+$E$64))+(G5*O5))","v":120}]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G6=0,H6=0),0,IF(I6<>0,((H6*(1-I6))*(1+VLOOKUP(J6,$F$59:$G$62,2,0))),H6*(1+VLOOKUP(J6,$F$59:$G$62,2,0))))","v":0},{"$f":"IF(J6=0,0,G6*K6)","v":0},null,"D",{"$f":"IF(E68=\"Ano\",K6*IF(ISNUMBER(N6)=TRUE,N6,VLOOKUP(N6,F60:G63,2)),IF(M6=0,0,M6*(1+VLOOKUP(N6,$F$59:$G$62,2,0))))","v":0},{"$f":"IF(N6=0,0,G6*O6)","v":0},{"$f":"IF(OR(I6=100,K6=0),(G6*O6),(G6*K6*(1+$E$64))+(G6*O6))","v":0}]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,"ks",2,200,null,"A",200,400,null,"D",0,0,400]
[null,null,null,null,"Celkem",null,null,null,null,null,null,{"$f":"SUM(L5:L54)","v":500},null,null,null,{"$f":"SUM(P5:P54)","v":20},{"$f":"SUM(Q5:Q54)","v":520}]
[]
[]
[null,null,null,"Kód přirážky",null,null,null,null,null,null,"Název",null,"[%]","[Kč]"]
[null,null,null,"Přirážka na materiál 1",null,"A",0,null,null,null,"Materiál celkem",null,{"$f":"L55","v":500}]
[null,null,null,"Přirážka na materiál 2",null,"B",0.2,null,null,null,"Montáže celkem",null,{"$f":"P55","v":20}]
[null,null,null,"Přirážka na montáž 1",null,"C",0.2,null,null,null,"Doprava",null,0,{"$f":"M59*M61","v":0}]
[null,null,null,"Přirážka na montáž 2",null,"D",0.2,null,null,null,"Vnitrostaveništní přesuny",null,0,{"$f":"M60*M62","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Zařízení staveniště",null,0,{"$f":"(M59+M60+N61+N62+N64+N68)*M63","v":0}]
[null,null,null,"Koeficient přípočtu:",{"$f":"SUM(N61:N68)/M59","v":0},null,null,null,null,null,"Kompletační činnost",null,0,{"$f":"(M59+M60)*M64","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Jeřáby  ",null,0,{"$f":"M59*M65","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Lešení",null,0,{"$f":"M59*M66","v":0}]
[null,"Procentuální montážní cena:",null,null,"Ano",0.2,null,null,null,null,"Realizační dokumentace",null,0,{"$f":"M59*M67","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Dokumentace skutečného provedení",null,0,{"$f":"M60*M68","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Nabídka celkem  ",null,null,{"$f":"SUM(N61:N68)+M59+M60","v":520}]

{"sheet":"PLYN","index":2,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[67,10,67,11],[67,13,67,14],[68,10,68,12],[68,13,68,14],[64,10,64,11],[64,13,64,14],[65,10,65,11],[65,13,65,14],[66,1,66,3],[66,10,66,11],[66,13,66,14],[61,3,61,4],[61,10,61,11],[61,13,61,14],[62,10,62,11],[62,13,62,14],[63,10,63,11],[63,13,63,14],[59,3,59,4],[59,10,59,11],[59,12,59,14],[60,3,60,4],[60,10,60,11],[60,13,60,14],[57,3,57,6],[57,10,57,11],[57,13,57,14],[58,3,58,4],[58,10,58,11],[58,12,58,14]]}
[]
[null,null,null,"AKCE :",{"$f":"REK!$A$18","v":"Rozpočet RD ŠTĚRBÁČEK"},null,null,null,null,null,null,null,null,null,{"$f":"V84","v":0}]
[null,"Dodavatel / Výrobce","Druh zboží","Číslo","Název položky","Měrná jednotka","Množství","Nákupní cena brutto MJ","Rabat %","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,null,"ks",1,100,null,"A",{"$f":"IF(OR(G5=0,H5=0),0,IF(I5<>0,((H5*(1-I5))*(1+VLOOKUP(J5,$F$59:$G$62,2,0))),H5*(1+VLOOKUP(J5,$F$59:$G$62,2,0))))","v":120},{"$f":"IF(J5=0,0,G5*K5)","v":120},null,"D",{"$f":"IF(E67=\"Ano\",K5*IF(ISNUMBER(N5)=TRUE,N5,VLOOKUP(N5,F59:G62,2)),IF(M5=0,0,M5*(1+VLOOKUP(N5,$F$59:$G$62,2,0))))","v":24},{"$f":"IF(N5=0,0,G5*O5)","v":24},{"$f":"IF(OR(I5=100,K5=0),(G5*O5),(G5*K5*(1+$E$64))+(G5*O5))","v":144}]
[null,null,null,null,null,null,null,null,null,"A",0,{"$f":"IF(J6=0,0,G6*K6)","v":0},null,"D",{"$f":"IF(E68=\"Ano\",K6*IF(ISNUMBER(N6)=TRUE,N6,VLOOKUP(N6,F60:G63,2)),IF(M6=0,0,M6*(1+VLOOKUP(N6,$F$59:$G$62,2,0))))","v":0},{"$f":"IF(N6=0,0,G6*O6)","v":0},0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G37=0,H37=0),0,IF(I37<>0,((H37*(1-I37))*(1+VLOOKUP(J37,$F$59:$G$62,2,0))),H37*(1+VLOOKUP(J37,$F$59:$G$62,2,0))))","v":0},0,null,"D",0,0,{"$f":"IF(OR(I37=100,K37=0),(G37*O37),(G37*K37*(1+$E$64))+(G37*O37))","v":0}]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,"Celkem",null,null,null,null,null,null,{"$f":"SUM(L5:L54)","v":120},null,null,null,{"$f":"SUM(P5:P54)","v":24},{"$f":"SUM(Q5:Q54)","v":144}]
[]
[]
[null,null,null,"Kód přirážky",null,null,null,null,null,null,"Název",null,"[%]","[Kč]"]
[null,null,null,"Přirážka na materiál 1",null,"A",0.2,null,null,null,"Materiál celkem",null,{"$f":"L55","v":120}]
[null,null,null,"Přirážka na materiál 2",null,"B",0.2,null,null,null,"Montáže celkem",null,{"$f":"P55","v":24}]
[null,null,null,"Přirážka na montáž 1",null,"C",0.2,null,null,null,"Doprava",null,0,{"$f":"M59*M61","v":0}]
[null,null,null,"Přirážka na montáž 2",null,"D",0.2,null,null,null,"Vnitrostaveništní přesuny",null,0,{"$f":"M60*M62","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Zařízení staveniště",null,0,{"$f":"(M59+M60+N61+N62+N64+N68)*M63","v":0}]
[null,null,null,"Koeficient přípočtu:",{"$f":"SUM(N61:N68)/M59","v":0},null,null,null,null,null,"Kompletační činnost",null,0,{"$f":"(M59+M60)*M64","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Jeřáby  ",null,0,{"$f":"M59*M65","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Lešení",null,0,{"$f":"M59*M66","v":0}]
[null,"Procentuální montážní cena:",null,null,"Ano",0.2,null,null,null,null,"Realizační dokumentace",null,0,{"$f":"M59*M67","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Dokumentace skutečného provedení",null,0,{"$f":"M60*M68","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Nabídka celkem  ",null,null,{"$f":"SUM(N61:N68)+M59+M60","v":144}]

{"sheet":"ZTI","index":3,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[66,1,66,3],[59,12,59,14],[58,12,58,14],[57,13,57,14],[68,13,68,14],[68,10,68,12],[63,13,63,14],[64,13,64,14],[65,13,65,14],[66,13,66,14],[67,13,67,14],[58,10,58,11],[59,10,59,11],[60,10,60,11],[61,10,61,11],[62,10,62,11],[63,10,63,11],[64,10,64,11],[65,10,65,11],[66,10,66,11],[67,10,67,11],[57,10,57,11],[60,13,60,14],[61,13,61,14],[62,13,62,14],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[57,3,57,6]]}
[]
[null,null,null,"AKCE :",{"$f":"REK!$A$18","v":"Rozpočet RD ŠTĚRBÁČEK"},null,null,null,null,null,null,null,null,null,{"$f":"V84","v":0}]
[null,"Dodavatel / Výrobce","Druh zboží","Číslo","Název položky","Měrná jednotka","Množství","Nákupní cena brutto MJ","Rabat %","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,null,"ks",1,100,null,"A",{"$f":"IF(OR(G5=0,H5=0),0,IF(I5<>0,((H5*(1-I5))*(1+VLOOKUP(J5,$F$59:$G$62,2,0))),H5*(1+VLOOKUP(J5,$F$59:$G$62,2,0))))","v":120},{"$f":"IF(J5=0,0,G5*K5)","v":120},null,"D",{"$f":"IF(E67=\"Ano\",K5*IF(ISNUMBER(N5)=TRUE,N5,VLOOKUP(N5,F59:G62,2)),IF(M5=0,0,M5*(1+VLOOKUP(N5,$F$59:$G$62,2,0))))","v":24},{"$f":"IF(N5=0,0,G5*O5)","v":24},{"$f":"IF(OR(I5=100,K5=0),(G5*O5),(G5*K5*(1+$E$64))+(G5*O5))","v":144}]
[null,null,null,null,null,null,null,null,null,"A",0,{"$f":"IF(J6=0,0,G6*K6)","v":0},null,"D",{"$f":"IF(E68=\"Ano\",K6*IF(ISNUMBER(N6)=TRUE,N6,VLOOKUP(N6,F60:G63,2)),IF(M6=0,0,M6*(1+VLOOKUP(N6,$F$59:$G$62,2,0))))","v":0},{"$f":"IF(N6=0,0,G6*O6)","v":0},0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,{"$f":"IF(J15=0,0,G15*K15)","v":0},null,"D",0,{"$f":"IF(N15=0,0,G15*O15)","v":0},0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,{"$f":"IF(J25=0,0,G25*K25)","v":0},null,"D",0,{"$f":"IF(N25=0,0,G25*O25)","v":0},0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G37=0,H37=0),0,IF(I37<>0,((H37*(1-I37))*(1+VLOOKUP(J37,$F$59:$G$62,2,0))),H37*(1+VLOOKUP(J37,$F$59:$G$62,2,0))))","v":0},0,null,"D",0,0,{"$f":"IF(OR(I37=100,K37=0),(G37*O37),(G37*K37*(1+$E$64))+(G37*O37))","v":0}]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,"Celkem",null,null,null,null,null,null,{"$f":"SUM(L5:L54)","v":120},null,null,null,{"$f":"SUM(P5:P54)","v":24},{"$f":"SUM(Q5:Q54)","v":144}]
[]
[]
[null,null,null,"Kód přirážky",null,null,null,null,null,null,"Název",null,"[%]","[Kč]"]
[null,null,null,"Přirážka na materiál 1",null,"A",0.2,null,null,null,"Materiál celkem",null,{"$f":"L55","v":120}]
[null,null,null,"Přirážka na materiál 2",null,"B",0.2,null,null,null,"Montáže celkem",null,{"$f":"P55","v":24}]
[null,null,null,"Přirážka na montáž 1",null,"C",0.2,null,null,null,"Doprava",null,0,{"$f":"M59*M61","v":0}]
[null,null,null,"Přirážka na montáž 2",null,"D",0.2,null,null,null,"Vnitrostaveništní přesuny",null,0,{"$f":"M60*M62","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Zařízení staveniště",null,0,{"$f":"(M59+M60+N61+N62+N64+N68)*M63","v":0}]
[null,null,null,"Koeficient přípočtu:",{"$f":"SUM(N61:N68)/M59","v":0},null,null,null,null,null,"Kompletační činnost",null,0,{"$f":"(M59+M60)*M64","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Jeřáby  ",null,0,{"$f":"M59*M65","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Lešení",null,0,{"$f":"M59*M66","v":0}]
[null,"Procentuální montážní cena:",null,null,"Ano",0.2,null,null,null,null,"Realizační dokumentace",null,0,{"$f":"M59*M67","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Dokumentace skutečného provedení",null,0,{"$f":"M60*M68","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Nabídka celkem  ",null,null,{"$f":"SUM(N61:N68)+M59+M60","v":144}]

{"sheet":"CHL","index":4,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[67,10,67,11],[67,13,67,14],[68,10,68,12],[68,13,68,14],[64,10,64,11],[64,13,64,14],[65,10,65,11],[65,13,65,14],[66,1,66,3],[66,10,66,11],[66,13,66,14],[61,3,61,4],[61,10,61,11],[61,13,61,14],[62,10,62,11],[62,13,62,14],[63,10,63,11],[63,13,63,14],[59,3,59,4],[59,10,59,11],[59,12,59,14],[60,3,60,4],[60,10,60,11],[60,13,60,14],[57,3,57,6],[57,10,57,11],[57,13,57,14],[58,3,58,4],[58,10,58,11],[58,12,58,14]]}
[]
[null,null,null,"AKCE :",{"$f":"REK!$A$18","v":"Rozpočet RD ŠTĚRBÁČEK"},null,null,null,null,null,null,null,null,null,{"$f":"V84","v":0}]
[null,"Dodavatel / Výrobce","Druh zboží","Číslo","Název položky","Měrná jednotka","Množství","Nákupní cena brutto MJ","Rabat %","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,null,"ks",1,100,null,"A",{"$f":"IF(OR(G5=0,H5=0),0,IF(I5<>0,((H5*(1-I5))*(1+VLOOKUP(J5,$F$59:$G$62,2,0))),H5*(1+VLOOKUP(J5,$F$59:$G$62,2,0))))","v":120},{"$f":"IF(J5=0,0,G5*K5)","v":120},null,"D",{"$f":"IF(E67=\"Ano\",K5*IF(ISNUMBER(N5)=TRUE,N5,VLOOKUP(N5,F59:G62,2)),IF(M5=0,0,M5*(1+VLOOKUP(N5,$F$59:$G$62,2,0))))","v":24},{"$f":"IF(N5=0,0,G5*O5)","v":24},{"$f":"IF(OR(I5=100,K5=0),(G5*O5),(G5*K5*(1+$E$64))+(G5*O5))","v":144}]
[null,null,null,null,null,null,null,null,null,"A",0,{"$f":"IF(J6=0,0,G6*K6)","v":0},null,"D",{"$f":"IF(E68=\"Ano\",K6*IF(ISNUMBER(N6)=TRUE,N6,VLOOKUP(N6,F60:G63,2)),IF(M6=0,0,M6*(1+VLOOKUP(N6,$F$59:$G$62,2,0))))","v":0},{"$f":"IF(N6=0,0,G6*O6)","v":0},0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G37=0,H37=0),0,IF(I37<>0,((H37*(1-I37))*(1+VLOOKUP(J37,$F$59:$G$62,2,0))),H37*(1+VLOOKUP(J37,$F$59:$G$62,2,0))))","v":0},0,null,"D",0,0,{"$f":"IF(OR(I37=100,K37=0),(G37*O37),(G37*K37*(1+$E$64))+(G37*O37))","v":0}]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,"Celkem",null,null,null,null,null,null,{"$f":"SUM(L5:L54)","v":120},null,null,null,{"$f":"SUM(P5:P54)","v":24},{"$f":"SUM(Q5:Q54)","v":144}]
[]
[]
[null,null,null,"Kód přirážky",null,null,null,null,null,null,"Název",null,"[%]","[Kč]"]
[null,null,null,"Přirážka na materiál 1",null,"A",0.2,null,null,null,"Materiál celkem",null,{"$f":"L55","v":120}]
[null,null,null,"Přirážka na materiál 2",null,"B",0.2,null,null,null,"Montáže celkem",null,{"$f":"P55","v":24}]
[null,null,null,"Přirážka na montáž 1",null,"C",0.2,null,null,null,"Doprava",null,0,{"$f":"M59*M61","v":0}]
[null,null,null,"Přirážka na montáž 2",null,"D",0.2,null,null,null,"Vnitrostaveništní přesuny",null,0,{"$f":"M60*M62","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Zařízení staveniště",null,0,{"$f":"(M59+M60+N61+N62+N64+N68)*M63","v":0}]
[null,null,null,"Koeficient přípočtu:",{"$f":"SUM(N61:N68)/M59","v":0},null,null,null,null,null,"Kompletační činnost",null,0,{"$f":"(M59+M60)*M64","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Jeřáby  ",null,0,{"$f":"M59*M65","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Lešení",null,0,{"$f":"M59*M66","v":0}]
[null,"Procentuální montážní cena:",null,null,"Ano",0.2,null,null,null,null,"Realizační dokumentace",null,0,{"$f":"M59*M67","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Dokumentace skutečného provedení",null,0,{"$f":"M60*M68","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Nabídka celkem  ",null,null,{"$f":"SUM(N61:N68)+M59+M60","v":144}]

{"sheet":"VZT","index":5,"n_rows":185,"n_cols":17,"rows_kept":185,"cut":false,"hidden":false,"merged":[[183,10,183,11],[183,13,183,14],[184,10,184,12],[184,13,184,14],[180,10,180,11],[180,13,180,14],[181,10,181,11],[181,13,181,14],[182,1,182,3],[182,10,182,11],[182,13,182,14],[177,3,177,4],[177,10,177,11],[177,13,177,14],[178,10,178,11],[178,13,178,14],[179,10,179,11],[179,13,179,14],[175,3,175,4],[175,10,175,11],[175,12,175,14],[176,3,176,4],[176,10,176,11],[176,13,176,14],[173,3,173,6],[173,10,173,11],[173,13,173,14],[174,3,174,4],[174,10,174,11],[174,12,174,14]]}
[]
[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":"V200","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           "]
[]
[null,null,null,null,"ZAŘÍZENí č.1 - Vratové clony"]
[]
[null,"Stavokloma",null,"1.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-314-4-AXI - studenovzdušná, Vmax=25 000m3/h, axiální vent. P=1x1,95 kW, 230 V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1]
[]
[null,"Stavokloma",null,null,"Vzduchová dveřní clona průmyslová horizontální SHCP-214-4-AXI - studenovzdušná, Vmax=15 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 30-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"2.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-314-4-AXI - studenovzdušná, Vmax=25 000m3/h, axiální vent. P=1x1,95 kW, 230 V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1]
[]
[null,"Stavokloma",null,null,"Vzduchová dveřní clona průmyslová horizontální SHCP-214-4-AXI - studenovzdušná, Vmax=15 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 94 kg   ","ks",1]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 30-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"3.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-314-4-AXI - studenovzdušná, Vmax=25 000m3/h, axiální vent. P=1x1,95 kW, 230 V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1]
[]
[null,"Stavokloma",null,null,"Vzduchová dveřní clona průmyslová horizontální SHCP-184-4-AXI - studenovzdušná, Vmax=14 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 1800x500x480 (lxhxš), 74 kg   ","ks",1]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 30-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"4.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-314-4-AXI - studenovzdušná, Vmax=25 000m3/h, axiální vent. P=1x1,95 kW, 230 V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1]
[]
[null,"Stavokloma",null,null,"Vzduchová dveřní clona průmyslová horizontální SHCP-184-4-AXI - studenovzdušná, Vmax=14 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 1800x500x480 (lxhxš), 74 kg   ","ks",1]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 30-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"5.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-314-4-AXI - studenovzdušná, Vmax=25 000m3/h, axiální vent. P=1x1,95 kW, 230 V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1]
[]
[null,"Stavokloma",null,null,"Vzduchová dveřní clona průmyslová horizontální SHCP-214-4-AXI - studenovzdušná, Vmax=15 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1]
[]
[null,"Stavokloma",null,null,"Vzduchová dveřní clona průmyslová horizontální SHCP-184-4-AXI - studenovzdušná, Vmax=14 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 1800x500x480 (lxhxš), 74 kg   ","ks",1]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 30-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",3]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"6.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-314-4-AXI - studenovzdušná, Vmax=25 000m3/h, axiální vent. P=1x1,95 kW, 230 V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1]
[]
[null,"Stavokloma",null,null,"Vzduchová dveřní clona průmyslová horizontální SHCP-214-4-AXI - studenovzdušná, Vmax=15 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 30-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"7.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-314-4-AXI - studenovzdušná, Vmax=25 000m3/h, axiální vent. P=1x1,95 kW, 230 V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1]
[]
[null,"Stavokloma",null,null,"Vzduchová dveřní clona průmyslová horizontální SHCP-214-4-AXI - studenovzdušná, Vmax=15 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 30-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"8.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-314-4-AXI - studenovzdušná, Vmax=25 000m3/h, axiální vent. P=1x1,95 kW, 230 V, 10,8 A, 3100x500x480 (lxhxš), 152 kg   ","ks",1]
[]
[null,"Stavokloma",null,null,"Vzduchová dveřní clona průmyslová horizontální SHCP-214-4-AXI - studenovzdušná, Vmax=15 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",1]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 30-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"9.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-214-4-AXI - studenovzdušná, Vmax=15 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",2]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 14-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"10.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-214-4-AXI - studenovzdušná, Vmax=15 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 2100x500x480 (lxhxš), 79kg   ","ks",2]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 14-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Stavokloma",null,"11.1.","Vzduchová dveřní clona průmyslová horizontální SHCP-184-4-AXI - studenovzdušná, Vmax=14 400m3/h, axiální vent. P=1x1,17 kW, 230 V, 6,5 A, 1800x500x480 (lxhxš), 74 kg   ","ks",2]
[]
[null,null,null,null,"Příslušenství :"]
[]
[null,"Stavoklima",null,null,"Elektronika pro řízení clony s příslušenstvím ROJ 14-10 light (0-3) - s ON/OF, pro DK(EK), 24 V, s čas.doběhem-bez","ks",1]
[]
[null,"Stavoklima",null,null,"Vratový kontakt magnetický přepínací - WKMG","ks",1]
[]
[null,"Stavoklima",null,null,"Závěsy podstropní AXI - ZS-PA","ks",2]
[]
[null,"Stavoklima",null,null,"Ocelová konstrukce pro clony včetně kotvících příček a materiálu","ks",1]
[]
[null,"Hilty, Kebek",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,"Doprava","kmpl",11]
[]
[null,null,null,null,"Celkem zařízení č.1","kmpl",1]
[]
[null,null,null,null,"LEŠENÍ"]
[]
[null,null,null,null,"Lešení prostorové lehké, montáž do 10 m","m2",100]
[]
[null,null,null,null,"Celkem lešení","kmpl",1]
[]
[null,null,null,null,"Celkem"]
[]
[]
[null,null,null,"Kód přirážky",null,null,null,null,null,null,"Název",null,"[%]","[Kč]"]
[null,null,null,"Přirážka na materiál 1",null,"A",0.2,null,null,null,"Materiál celkem",null,{"$f":"L171","v":0}]
[null,null,null,"Přirážka na materiál 2",null,"B",0.2,null,null,null,"Montáže celkem",null,{"$f":"P171","v":0}]
[null,null,null,"Přirážka na montáž 1",null,"C",0.2,null,null,null,"Doprava",null,0,{"$f":"M175*M177","v":0}]
[null,null,null,"Přirážka na montáž 2",null,"D",0.2,null,null,null,"Vnitrostaveništní přesuny",null,0,{"$f":"M176*M178","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Zařízení staveniště",null,0,{"$f":"(M175+M176+N177+N178+N180+N184)*M179","v":0}]
[null,null,null,"Koeficient přípočtu:",{"$f":"SUM(N177:N184)/M175","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Kompletační činnost",null,0,{"$f":"(M175+M176)*M180","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Jeřáby  ",null,0,{"$f":"M175*M181","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Lešení",null,0,{"$f":"M175*M182","v":0}]
[null,"Procentuální montážní cena:",null,null,"Ne",0.2,null,null,null,null,"Realizační dokumentace",null,0,{"$f":"M175*M183","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Dokumentace skutečného provedení",null,0,{"$f":"M176*M184","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Nabídka celkem  ",null,null,{"$f":"SUM(N177:N184)+M175+M176","v":0}]

{"sheet":"FVE","index":6,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[67,10,67,11],[67,13,67,14],[68,10,68,12],[68,13,68,14],[64,10,64,11],[64,13,64,14],[65,10,65,11],[65,13,65,14],[66,1,66,3],[66,10,66,11],[66,13,66,14],[61,3,61,4],[61,10,61,11],[61,13,61,14],[62,10,62,11],[62,13,62,14],[63,10,63,11],[63,13,63,14],[59,3,59,4],[59,10,59,11],[59,12,59,14],[60,3,60,4],[60,10,60,11],[60,13,60,14],[57,3,57,6],[57,10,57,11],[57,13,57,14],[58,3,58,4],[58,10,58,11],[58,12,58,14]]}
[]
[null,null,null,"AKCE :",{"$f":"REK!$A$18","v":"Rozpočet RD ŠTĚRBÁČEK"},null,null,null,null,null,null,null,null,null,{"$f":"V84","v":0}]
[null,"Dodavatel / Výrobce","Druh zboží","Číslo","Název položky","Měrná jednotka","Množství","Nákupní cena brutto MJ","Rabat %","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,null,"ks",1,100,null,"A",{"$f":"IF(OR(G5=0,H5=0),0,IF(I5<>0,((H5*(1-I5))*(1+VLOOKUP(J5,$F$59:$G$62,2,0))),H5*(1+VLOOKUP(J5,$F$59:$G$62,2,0))))","v":120},{"$f":"IF(J5=0,0,G5*K5)","v":120},null,"D",{"$f":"IF(E67=\"Ano\",K5*IF(ISNUMBER(N5)=TRUE,N5,VLOOKUP(N5,F59:G62,2)),IF(M5=0,0,M5*(1+VLOOKUP(N5,$F$59:$G$62,2,0))))","v":24},{"$f":"IF(N5=0,0,G5*O5)","v":24},{"$f":"IF(OR(I5=100,K5=0),(G5*O5),(G5*K5*(1+$E$64))+(G5*O5))","v":144}]
[null,null,null,null,null,null,null,null,null,"A",0,{"$f":"IF(J6=0,0,G6*K6)","v":0},null,"D",{"$f":"IF(E68=\"Ano\",K6*IF(ISNUMBER(N6)=TRUE,N6,VLOOKUP(N6,F60:G63,2)),IF(M6=0,0,M6*(1+VLOOKUP(N6,$F$59:$G$62,2,0))))","v":0},{"$f":"IF(N6=0,0,G6*O6)","v":0},0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(OR(G37=0,H37=0),0,IF(I37<>0,((H37*(1-I37))*(1+VLOOKUP(J37,$F$59:$G$62,2,0))),H37*(1+VLOOKUP(J37,$F$59:$G$62,2,0))))","v":0},0,null,"D",0,0,{"$f":"IF(OR(I37=100,K37=0),(G37*O37),(G37*K37*(1+$E$64))+(G37*O37))","v":0}]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,null,null,null,null,null,"A",0,0,null,"D",0,0,0]
[null,null,null,null,"Celkem",null,null,null,null,null,null,{"$f":"SUM(L5:L54)","v":120},null,null,null,{"$f":"SUM(P5:P54)","v":24},{"$f":"SUM(Q5:Q54)","v":144}]
[]
[]
[null,null,null,"Kód přirážky",null,null,null,null,null,null,"Název",null,"[%]","[Kč]"]
[null,null,null,"Přirážka na materiál 1",null,"A",0.2,null,null,null,"Materiál celkem",null,{"$f":"L55","v":120}]
[null,null,null,"Přirážka na materiál 2",null,"B",0.2,null,null,null,"Montáže celkem",null,{"$f":"P55","v":24}]
[null,null,null,"Přirážka na montáž 1",null,"C",0.2,null,null,null,"Doprava",null,0,{"$f":"M59*M61","v":0}]
[null,null,null,"Přirážka na montáž 2",null,"D",0.2,null,null,null,"Vnitrostaveništní přesuny",null,0,{"$f":"M60*M62","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Zařízení staveniště",null,0,{"$f":"(M59+M60+N61+N62+N64+N68)*M63","v":0}]
[null,null,null,"Koeficient přípočtu:",{"$f":"SUM(N61:N68)/M59","v":0},null,null,null,null,null,"Kompletační činnost",null,0,{"$f":"(M59+M60)*M64","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Jeřáby  ",null,0,{"$f":"M59*M65","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Lešení",null,0,{"$f":"M59*M66","v":0}]
[null,"Procentuální montážní cena:",null,null,"Ano",0.2,null,null,null,null,"Realizační dokumentace",null,0,{"$f":"M59*M67","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Dokumentace skutečného provedení",null,0,{"$f":"M60*M68","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Nabídka celkem  ",null,null,{"$f":"SUM(N61:N68)+M59+M60","v":144}]