{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Stavba","103 3326102 KL","103 3326102 Rek","103 3326102 Pol","104 3326104 KL","104 3326104 Rek","104 3326104 Pol","105 3326105.1 KL","105 3326105.1 Rek","105 3326105.1 Pol","105 3326105.2 KL","105 3326105.2 Rek","105 3326105.2 Pol","105 3326105.3 KL","105 3326105.3 Rek","105 3326105.3 Pol","106 3326106 KL","106 3326106 Rek","106 3326106 Pol","107 3326107 KL","107 3326107 Rek","107 3326107 Pol","108 3326108 KL","108 3326108 Rek","108 3326108 Pol"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":102,"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":"Stavba","index":0,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9]]}
[]
[null,null,"Položkový rozpočet stavby",null,null,null,null,"Datum: ",{"$f":"TODAY()","v":"2022-09-16"}]
[null,null,null," "]
[]
[null,null,"Stavba :","3326","Oprava místních komunikací Turnov"]
[]
[null,null,"Objednatel : ","Město TURNOV",null,null,null,"IČO :","00276227"]
[null,null,null,"Antonína Dvořáka 335",null,null,null,"DIČ :","CZ00276227"]
[null,null,"51122","Turnov"]
[]
[null,null,"Zhotovitel : ",".",null,null,null,"IČO :"]
[null,null,null,null,null,null,null,"DIČ :"]
[]
[null,null,"Za zhotovitele :",null,null,null,null,"Za objednatele :"]
[]
[null,null,"_______________",null,null,null,null,"_______________"]
[]
[null,null,null,null,null,null,null,null,null,"Rozpočtové náklady"]
[null,"Základ pro DPH",null,15,"%",null,null,null,{"$f":"ROUND(G35,0)","v":0}]
[null,"DPH ",null,{"$f":"SazbaDPH1","v":15},"%",null,null,null,{"$f":"ROUND(I19*D20/100,0)","v":0}]
[null,"Základ pro DPH",null,21,"%",null,null,null,{"$f":"ROUND(H35,0)","v":0}]
[null,"DPH ",null,{"$f":"SazbaDPH2","v":21},"%",null,null,null,{"$f":"ROUND(I21*D21/100,0)","v":0}]
[null,"Cena celkem za stavbu",null,null,null,null,null,null,{"$f":"SUM(I19:I22)","v":0}]
[]
[]
[null,"Rekapitulace stavebních objektů a provozních souborů"]
[]
[null,"Číslo a název objektu / provozního souboru",null,null,null,"Cena celkem",{"$f":"CONCATENATE(\"Základ DPH \",SazbaDPH1,\" %\")","v":"Základ DPH 15 %"},{"$f":"CONCATENATE(\"Základ DPH \",SazbaDPH2,\" %\")","v":"Základ DPH 21 %"},"DPH celkem","%"]
[null,"103","Oprava MK \"Nudvojovice - V úvozu\"",null,null,{"$f":"G29+H29+I29","v":0},0,{"$f":"SUM(H40)","v":0},{"$f":"(G29*SazbaDPH1)/100+(H29*SazbaDPH2)/100","v":0},{"$f":"IF(CelkemObjekty=0,\"\",F29/CelkemObjekty*100)","v":""}]
[null,"104","Oprava MK \"Mašov - V Koutě\"",null,null,0,0,{"$f":"SUM(H41)","v":0},0,""]
[null,"105","Oprava MK \"Mašov - Mašovská u hřbitova\"",null,null,0,0,{"$f":"SUM(H42:H44)","v":0},0,""]
[null,"106","Oprava ZP na ppč. 130/1 a 141/2 v kú. Turnov",null,null,0,0,{"$f":"SUM(H45)","v":0},0,""]
[null,"107","Vesecko - Rozšíření zpevněné plochy",null,null,0,0,{"$f":"SUM(H46)","v":0},0,""]
[null,"108","Oprava komunikace \"Ve Struhách\"",null,null,0,0,{"$f":"SUM(H47)","v":0},0,""]
[null,"Celkem za stavbu",null,null,null,{"$f":"SUM(F29:F34)","v":0},{"$f":"SUM(G29:G34)","v":0},{"$f":"SUM(H29:H34)","v":0},{"$f":"SUM(I29:I34)","v":0},{"$f":"IF(CelkemObjekty=0,\"\",F35/CelkemObjekty*100)","v":""}]
[]
[null,"Rekapitulace stavebních rozpočtů"]
[]
[null,"Číslo objektu","Číslo a název rozpočtu",null,null,"Cena celkem",{"$f":"CONCATENATE(\"Základ DPH \",SazbaDPH1,\" %\")","v":"Základ DPH 15 %"},{"$f":"CONCATENATE(\"Základ DPH \",SazbaDPH2,\" %\")","v":"Základ DPH 21 %"},"DPH celkem","%"]
[null,"103","3326/102 Oprava MK \"Nudvojovice - V úvozu\"",null,null,{"$f":"G40+H40+I40","v":0},0,{"$f":"SUM('103 3326102 KL'!C23)","v":0},{"$f":"(G40*SazbaDPH1)/100+(H40*SazbaDPH2)/100","v":0},{"$f":"IF(CelkemObjekty=0,\"\",F40/CelkemObjekty*100)","v":""}]
[null,"104","3326/104 Oprava MK \"Mašov - V Koutě\"",null,null,0,0,{"$f":"SUM('104 3326104 KL'!C23)","v":0},0,""]
[null,"105","3326/105.1 Oprava MK \"Mašov-Mašovská u hřbitova\"-úsek k ČOV",null,null,0,0,{"$f":"SUM('105 3326105.1 KL'!C23)","v":0},0,""]
[null,"105","3326/105.2 Oprava MK \"Mašov-Mašovská u hřbitova\"-křiž. u ČOV",null,null,0,0,{"$f":"SUM('105 3326105.2 KL'!C23)","v":0},0,""]
[null,"105","3326/105.3 Oprava MK \"Mašov-Mašovská u hřbitova\"-úsek do ČOV",null,null,0,0,{"$f":"SUM('105 3326105.3 KL'!C23)","v":0},0,""]
[null,"106","3326/106 Oprava ZP na ppč. 130/1 a 141/2 v kú. Turnov",null,null,0,0,{"$f":"SUM('106 3326106 KL'!C23)","v":0},0,""]
[null,"107","3326/107 Vesecko - Rozšíření pruhu zpevněné plochy -3,0 m",null,null,0,0,{"$f":"SUM('107 3326107 KL'!C23)","v":0},0,""]
[null,"108","3326/108 Oprava komunikace \"Ve Struhách\" od čp. 908",null,null,0,0,{"$f":"SUM('108 3326108 KL'!C23)","v":0},0,""]
[null,"Celkem za stavbu",null,null,null,{"$f":"SUM(F40:F47)","v":0},{"$f":"SUM(G40:G47)","v":0},{"$f":"SUM(H40:H47)","v":0},{"$f":"SUM(I40:I47)","v":0},{"$f":"IF(CelkemObjekty=0,\"\",F48/CelkemObjekty*100)","v":""}]

{"sheet":"103 3326102 KL","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[22,0,22,1],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[50,1,50,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,1,44,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6]]}
["POLOŽKOVÝ ROZPOČET"]
["Rozpočet",null,"3326/102","Oprava MK \"Nudvojovice - V úvozu\"",null,"JKSO ","822.29"]
[]
["Objekt",null,null,null,null,"SKP "]
["103",null,"Oprava MK \"Nudvojovice - V úvozu\"",null,null,"Měrná jednotka","m2"]
["Stavba",null,null,null,null,"Počet jednotek",0]
["3326",null,"Oprava místních komunikací Turnov",null,null,"Náklady na m.j.",{"$f":"IF(G6=0,,ROUND((F30+F32)/G6,1))","v":0}]
["Projektant",null,null,null,null,"Typ rozpočtu"]
["Zpracovatel projektu"]
["Objednatel",null,"Město TURNOV"]
["Dodavatel",null,".",null,null,"Zakázkové číslo "]
["Rozpočtoval",null,null,null,null,"Počet listů"]
["ROZPOČTOVÉ NÁKLADY"]
["Základní rozpočtové náklady",null,null,"Ostatní rozpočtové náklady"]
[null,"HSV celkem",{"$f":"'103 3326102 Rek'!E13","v":0},{"$f":"'103 3326102 Rek'!A18","v":"Zařízení staveniště"},null,null,{"$f":"'103 3326102 Rek'!I18","v":0}]
["Z","PSV celkem",{"$f":"'103 3326102 Rek'!F13","v":0},{"$f":"'103 3326102 Rek'!A19","v":"Kompletační činnost (IČD)"},null,null,{"$f":"'103 3326102 Rek'!I19","v":0}]
["R","M práce celkem",{"$f":"'103 3326102 Rek'!H13","v":0},{"$f":"'103 3326102 Rek'!A20","v":"Vytýčení stavby a podz. inženýrských sítí"},null,null,{"$f":"'103 3326102 Rek'!I20","v":0}]
["N","M dodávky celkem",{"$f":"'103 3326102 Rek'!G13","v":0},{"$f":"'103 3326102 Rek'!A21","v":"DIO"},null,null,{"$f":"'103 3326102 Rek'!I21","v":0}]
["ZRN celkem",null,{"$f":"SUM(C15:C18)","v":0}]
[]
["HZS",null,{"$f":"'103 3326102 Rek'!I13","v":0}]
["ZRN+HZS",null,{"$f":"C19+C21","v":0}]
["ZRN+ost.náklady+HZS",null,{"$f":"C22+G23","v":0},"Ostatní náklady celkem",null,null,{"$f":"'103 3326102 Rek'!H22","v":0}]
["Vypracoval",null,null,"Za zhotovitele",null,"Za objednatele"]
["Jméno :",null,null,"Jméno :",null,"Jméno :"]
["Datum :",null,null,"Datum :",null,"Datum :"]
[]
["Podpis :",null,null,"Podpis:",null,"Podpis:"]
[]
["Základ pro DPH",null,21,"%  ",null,{"$f":"C23-F32","v":0}]
["DPH",null,{"$f":"C30","v":21},"% ",null,{"$f":"ROUND(PRODUCT(F30,C31/100),0)","v":0}]
["Základ pro DPH",null,0,"% ",null,0]
["DPH",null,{"$f":"C32","v":0},"% ",null,{"$f":"ROUND(PRODUCT(F32,C33/100),0)","v":0}]
["CENA ZA OBJEKT CELKEM",null,null,null,null,{"$f":"ROUND(SUM(F30:F33),0)","v":0}]
[]
["Poznámka :",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"103 3326102 Rek","index":2,"n_rows":22,"n_cols":53,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[1,6,1,8],[21,7,21,8]]}
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,null,null,"Rozpočet :","3326/102"]
["Objekt :",null,"103 Oprava MK \"Nudvojovice - V úvozu\"",null,null,null,"Oprava MK \"Nudvojovice - V úvozu\""]
[]
["REKAPITULACE  STAVEBNÍCH  DÍLŮ"]
[]
[null,"Stavební díl",null,null,"HSV","PSV","Dodávka","Montáž","HZS"]
[{"$f":"'103 3326102 Pol'!B7","v":"1"},{"$f":"'103 3326102 Pol'!C7","v":"Zemní práce"},null,null,{"$f":"'103 3326102 Pol'!BA16","v":0},{"$f":"'103 3326102 Pol'!BB16","v":0},{"$f":"'103 3326102 Pol'!BC16","v":0},{"$f":"'103 3326102 Pol'!BD16","v":0},{"$f":"'103 3326102 Pol'!BE16","v":0}]
[{"$f":"'103 3326102 Pol'!B17","v":"5"},{"$f":"'103 3326102 Pol'!C17","v":"Komunikace"},null,null,{"$f":"'103 3326102 Pol'!BA33","v":0},{"$f":"'103 3326102 Pol'!BB33","v":0},{"$f":"'103 3326102 Pol'!BC33","v":0},{"$f":"'103 3326102 Pol'!BD33","v":0},{"$f":"'103 3326102 Pol'!BE33","v":0}]
[{"$f":"'103 3326102 Pol'!B34","v":"8"},{"$f":"'103 3326102 Pol'!C34","v":"Trubní vedení"},null,null,{"$f":"'103 3326102 Pol'!BA41","v":0},{"$f":"'103 3326102 Pol'!BB41","v":0},{"$f":"'103 3326102 Pol'!BC41","v":0},{"$f":"'103 3326102 Pol'!BD41","v":0},{"$f":"'103 3326102 Pol'!BE41","v":0}]
[{"$f":"'103 3326102 Pol'!B42","v":"91"},{"$f":"'103 3326102 Pol'!C42","v":"Doplňující práce na komunikaci"},null,null,{"$f":"'103 3326102 Pol'!BA48","v":0},{"$f":"'103 3326102 Pol'!BB48","v":0},{"$f":"'103 3326102 Pol'!BC48","v":0},{"$f":"'103 3326102 Pol'!BD48","v":0},{"$f":"'103 3326102 Pol'!BE48","v":0}]
[{"$f":"'103 3326102 Pol'!B49","v":"93"},{"$f":"'103 3326102 Pol'!C49","v":"Dokončovací práce inženýrských staveb"},null,null,{"$f":"'103 3326102 Pol'!BA57","v":0},{"$f":"'103 3326102 Pol'!BB57","v":0},{"$f":"'103 3326102 Pol'!BC57","v":0},{"$f":"'103 3326102 Pol'!BD57","v":0},{"$f":"'103 3326102 Pol'!BE57","v":0}]
[{"$f":"'103 3326102 Pol'!B58","v":"99"},{"$f":"'103 3326102 Pol'!C58","v":"Staveništní přesun hmot"},null,null,{"$f":"'103 3326102 Pol'!BA60","v":0},{"$f":"'103 3326102 Pol'!BB60","v":0},{"$f":"'103 3326102 Pol'!BC60","v":0},{"$f":"'103 3326102 Pol'!BD60","v":0},{"$f":"'103 3326102 Pol'!BE60","v":0}]
[null,"CELKEM  OBJEKT",null,null,{"$f":"SUM(E7:E12)","v":0},{"$f":"SUM(F7:F12)","v":0},{"$f":"SUM(G7:G12)","v":0},{"$f":"SUM(H7:H12)","v":0},{"$f":"SUM(I7:I12)","v":0}]
[]
["VEDLEJŠÍ ROZPOČTOVÉ  NÁKLADY"]
[]
["Název VRN",null,null,null,"Kč",null,null,null,"Kč"]
["Zařízení staveniště",null,null,null,0,null,null,null,{"$f":"E18+F18*G18/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Kompletační činnost (IČD)",null,null,null,0,null,null,null,{"$f":"E19+F19*G19/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Vytýčení stavby a podz. inženýrských sítí",null,null,null,0,null,null,null,{"$f":"E20+F20*G20/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["DIO",null,null,null,0,null,null,null,{"$f":"E21+F21*G21/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"CELKEM VRN",null,null,null,null,null,{"$f":"SUM(I18:I21)","v":0}]

{"sheet":"103 3326102 Pol","index":3,"n_rows":60,"n_cols":80,"rows_kept":60,"cut":false,"hidden":false,"merged":[[10,2,10,3],[14,2,14,6],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,4,3,6],[8,2,8,3],[35,2,35,3],[36,2,36,3],[38,2,38,3],[39,2,39,3],[18,2,18,3],[20,2,20,3],[22,2,22,3],[23,2,23,3],[25,2,25,3],[27,2,27,3],[29,2,29,3],[31,2,31,3],[44,2,44,3],[50,2,50,3],[52,2,52,3],[54,2,54,3],[55,2,55,3]]}
["Položkový rozpočet "]
[]
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,"Rozpočet:",{"$f":"'103 3326102 Rek'!H1","v":"3326/102"}]
["Objekt :",null,"103 Oprava MK \"Nudvojovice - V úvozu\"",null,{"$f":"'103 3326102 Rek'!G2","v":"Oprava MK \"Nudvojovice - V úvozu\""}]
[]
["P.č.","Číslo položky","Název položky","MJ","množství","cena / MJ","celkem (Kč)","Jednotková hmotnost","Celková hmotnost","Jednotková dem.hmot.","Celková dem.hmot."]
["Díl:","1","Zemní práce",null,null,null,null,null,null,null,null,null,null,null,1]
[1,"113107515R00","Odstranění podkladu pl. 50 m2,kam.drcené tl.15 cm ","m2",4,null,{"$f":"E8*F8","v":0},0,{"$f":"E8*H8","v":0},-0.33,{"$f":"E8*J8","v":-1.32},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ8=1,G8,0)","v":0},{"$f":"IF(AZ8=2,G8,0)","v":0},{"$f":"IF(AZ8=3,G8,0)","v":0},{"$f":"IF(AZ8=4,G8,0)","v":0},{"$f":"IF(AZ8=5,G8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Pro osazení obrubníků :10,00*0,40",null,4,null,null,null,null,null,null,null,"Pro osazení obrubníků :10,00*0,40"]
[2,"113108320R00","Odstranění asfaltové vrstvy pl. do 50 m2, tl.20 cm ","m2",4,null,{"$f":"E10*F10","v":0},0,{"$f":"E10*H10","v":0},-0.44,{"$f":"E10*J10","v":-1.76},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ10=1,G10,0)","v":0},{"$f":"IF(AZ10=2,G10,0)","v":0},{"$f":"IF(AZ10=3,G10,0)","v":0},{"$f":"IF(AZ10=4,G10,0)","v":0},{"$f":"IF(AZ10=5,G10,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Pro osazení obrubníků :10,00*0,40",null,4,null,null,null,null,null,null,null,"Pro osazení obrubníků :10,00*0,40"]
[3,"979082113RSZ","Vodorovná doprava suti po suchu na skládku zhotovitele","t",3.08,null,{"$f":"E12*F12","v":0},0,{"$f":"E12*H12","v":0},0,{"$f":"E12*J12","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ12=1,G12,0)","v":0},{"$f":"IF(AZ12=2,G12,0)","v":0},{"$f":"IF(AZ12=3,G12,0)","v":0},{"$f":"IF(AZ12=4,G12,0)","v":0},{"$f":"IF(AZ12=5,G12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[4,"979089001R00","Poplatek za  uložení odpadního štěrku a kameniva skupina odpadu 010408","t",1.32,null,{"$f":"E13*F13","v":0},0,{"$f":"E13*H13","v":0},0,{"$f":"E13*J13","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ13=1,G13,0)","v":0},{"$f":"IF(AZ13=2,G13,0)","v":0},{"$f":"IF(AZ13=3,G13,0)","v":0},{"$f":"IF(AZ13=4,G13,0)","v":0},{"$f":"IF(AZ13=5,G13,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[5,"979990112RRA","Poplatek za skládku suti - obalované kam. - asfalt ","t",1.76,null,{"$f":"E14*F14","v":0},0,{"$f":"E14*H14","v":0},0,{"$f":"E14*J14","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ14=1,G14,0)","v":0},{"$f":"IF(AZ14=2,G14,0)","v":0},{"$f":"IF(AZ14=3,G14,0)","v":0},{"$f":"IF(AZ14=4,G14,0)","v":0},{"$f":"IF(AZ14=5,G14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Položka je určena pro suť o velikosti kusu do 30x30 cm (technologický materiál určený k recyklaci).",null,null,null,null,null,null,null,null,"Položka je určena pro suť o velikosti kusu do 30x30 cm (technologický materiál určený k recyklaci).",null,null,3]
[null,"Celkem za","1 Zemní práce",null,null,null,{"$f":"SUM(G7:G15)","v":0},null,{"$f":"SUM(I7:I15)","v":0},null,{"$f":"SUM(K7:K15)","v":-3.08},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA7:BA15)","v":0},{"$f":"SUM(BB7:BB15)","v":0},{"$f":"SUM(BC7:BC15)","v":0},{"$f":"SUM(BD7:BD15)","v":0},{"$f":"SUM(BE7:BE15)","v":0}]
["Díl:","5","Komunikace",null,null,null,null,null,null,null,null,null,null,null,1]
[6,"565131211RT2","Podklad z obal kamen. ACP 16+, š.nad 3 m, tl. 5 cm plochy 201-1000 m2","m2",60,null,{"$f":"E18*F18","v":0},0.13188,{"$f":"E18*H18","v":7.9127999999999998},0,{"$f":"E18*J18","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ18=1,G18,0)","v":0},{"$f":"IF(AZ18=2,G18,0)","v":0},{"$f":"IF(AZ18=3,G18,0)","v":0},{"$f":"IF(AZ18=4,G18,0)","v":0},{"$f":"IF(AZ18=5,G18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha křižovatky:60,00",null,60,null,null,null,null,null,null,null,"Plocha křižovatky:60,00"]
[7,"566301111R00","Úprava krytu kamenivem drceným do 0,06 m3/m2 ","m2",60,null,{"$f":"E20*F20","v":0},9.8479999999999998E-2,{"$f":"E20*H20","v":5.9088000000000003},0,{"$f":"E20*J20","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ20=1,G20,0)","v":0},{"$f":"IF(AZ20=2,G20,0)","v":0},{"$f":"IF(AZ20=3,G20,0)","v":0},{"$f":"IF(AZ20=4,G20,0)","v":0},{"$f":"IF(AZ20=5,G20,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha křižovatky:60,00",null,60,null,null,null,null,null,null,null,"Plocha křižovatky:60,00"]
[8,"569831111R00","Zpevnění krajnic štěrkodrtí tloušťky  10 cm ","m2",41.25,null,{"$f":"E22*F22","v":0},0.18776000000000001,{"$f":"E22*H22","v":7.7451000000000008},0,{"$f":"E22*J22","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ22=1,G22,0)","v":0},{"$f":"IF(AZ22=2,G22,0)","v":0},{"$f":"IF(AZ22=3,G22,0)","v":0},{"$f":"IF(AZ22=4,G22,0)","v":0},{"$f":"IF(AZ22=5,G22,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Podél komunikace:(65,00+2*25)*0,25",null,28.75,null,null,null,null,null,null,null,"Podél komunikace:(65,00+2*25)*0,25"]
[null,null,"Křižovatka:25,00*0,50",null,12.5,null,null,null,null,null,null,null,"Křižovatka:25,00*0,50"]
[9,"572713112R00","Vyrovnání povrchu krytů kamen. obaleným asfaltem ","t",45,null,{"$f":"E25*F25","v":0},1,{"$f":"E25*H25","v":45},0,{"$f":"E25*J25","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ25=1,G25,0)","v":0},{"$f":"IF(AZ25=2,G25,0)","v":0},{"$f":"IF(AZ25=3,G25,0)","v":0},{"$f":"IF(AZ25=4,G25,0)","v":0},{"$f":"IF(AZ25=5,G25,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha komunikace a křižovatky:450,00*0,08/2*2,5",null,45,null,null,null,null,null,null,null,"Plocha komunikace a křižovatky:450,00*0,08/2*2,5"]
[10,"573111111R00","Postřik živičný infiltr.+ posyp, asfalt. 0,60kg/m2 ","m2",510,null,{"$f":"E27*F27","v":0},5.6100000000000004E-3,{"$f":"E27*H27","v":2.8611000000000004},0,{"$f":"E27*J27","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ27=1,G27,0)","v":0},{"$f":"IF(AZ27=2,G27,0)","v":0},{"$f":"IF(AZ27=3,G27,0)","v":0},{"$f":"IF(AZ27=4,G27,0)","v":0},{"$f":"IF(AZ27=5,G27,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha komunikace a křižovatky:450,00+60,00",null,510,null,null,null,null,null,null,null,"Plocha komunikace a křižovatky:450,00+60,00"]
[11,"573231126R00","Postřik spojovací z KAE množství zbytkového asfaltu 0,6 kg/m2","m2",510,null,{"$f":"E29*F29","v":0},5.0000000000000001E-4,{"$f":"E29*H29","v":0.255},0,{"$f":"E29*J29","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ29=1,G29,0)","v":0},{"$f":"IF(AZ29=2,G29,0)","v":0},{"$f":"IF(AZ29=3,G29,0)","v":0},{"$f":"IF(AZ29=4,G29,0)","v":0},{"$f":"IF(AZ29=5,G29,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha komunikace a křižovatky:450,00+60,00",null,510,null,null,null,null,null,null,null,"Plocha komunikace a křižovatky:450,00+60,00"]
[12,"577131211RT2","Beton asfalt. ACO 8,nebo ACO 11, do 3 m, tl. 4 cm plochy 201-1000 m2","m2",510,null,{"$f":"E31*F31","v":0},0.10141,{"$f":"E31*H31","v":51.719099999999997},0,{"$f":"E31*J31","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ31=1,G31,0)","v":0},{"$f":"IF(AZ31=2,G31,0)","v":0},{"$f":"IF(AZ31=3,G31,0)","v":0},{"$f":"IF(AZ31=4,G31,0)","v":0},{"$f":"IF(AZ31=5,G31,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha komunikace a křižovatky:450,00+60,00",null,510,null,null,null,null,null,null,null,"Plocha komunikace a křižovatky:450,00+60,00"]
[null,"Celkem za","5 Komunikace",null,null,null,{"$f":"SUM(G17:G32)","v":0},null,{"$f":"SUM(I17:I32)","v":121.40189999999998},null,{"$f":"SUM(K17:K32)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA17:BA32)","v":0},{"$f":"SUM(BB17:BB32)","v":0},{"$f":"SUM(BC17:BC32)","v":0},{"$f":"SUM(BD17:BD32)","v":0},{"$f":"SUM(BE17:BE32)","v":0}]
["Díl:","8","Trubní vedení",null,null,null,null,null,null,null,null,null,null,null,1]
[13,"899331111R00","Výšková úprava vstupu do 20 cm, zvýšení poklopu ","kus",6,null,{"$f":"E35*F35","v":0},0.43093999999999999,{"$f":"E35*H35","v":2.5856399999999997},0,{"$f":"E35*J35","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ35=1,G35,0)","v":0},{"$f":"IF(AZ35=2,G35,0)","v":0},{"$f":"IF(AZ35=3,G35,0)","v":0},{"$f":"IF(AZ35=4,G35,0)","v":0},{"$f":"IF(AZ35=5,G35,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,"Kanalizace:5",null,5,null,null,null,null,null,null,null,"Kanalizace:5"]
[null,null,"Vodoměrná šachta:1",null,1,null,null,null,null,null,null,null,"Vodoměrná šachta:1"]
[14,"899431111R00","Výšková úprava do 20 cm, zvýšení krytu šoupěte ","kus",5,null,{"$f":"E38*F38","v":0},0.31590000000000001,{"$f":"E38*H38","v":1.5795000000000001},0,{"$f":"E38*J38","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ38=1,G38,0)","v":0},{"$f":"IF(AZ38=2,G38,0)","v":0},{"$f":"IF(AZ38=3,G38,0)","v":0},{"$f":"IF(AZ38=4,G38,0)","v":0},{"$f":"IF(AZ38=5,G38,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Vodovod:4",null,4,null,null,null,null,null,null,null,"Vodovod:4"]
[null,null,"Hydrant:1",null,1,null,null,null,null,null,null,null,"Hydrant:1"]
[null,"Celkem za","8 Trubní vedení",null,null,null,{"$f":"SUM(G34:G40)","v":0},null,{"$f":"SUM(I34:I40)","v":4.1651400000000001},null,{"$f":"SUM(K34:K40)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA34:BA40)","v":0},{"$f":"SUM(BB34:BB40)","v":0},{"$f":"SUM(BC34:BC40)","v":0},{"$f":"SUM(BD34:BD40)","v":0},{"$f":"SUM(BE34:BE40)","v":0}]
["Díl:","91","Doplňující práce na komunikaci",null,null,null,null,null,null,null,null,null,null,null,1]
[15,"917762111RT5","Osazení ležat. obrub. bet. s opěrou,lože z C 12/15 včetně obrubníku ABO 10 100/10/25","m",10,null,{"$f":"E43*F43","v":0},0.24357999999999999,{"$f":"E43*H43","v":2.4358},0,{"$f":"E43*J43","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ43=1,G43,0)","v":0},{"$f":"IF(AZ43=2,G43,0)","v":0},{"$f":"IF(AZ43=3,G43,0)","v":0},{"$f":"IF(AZ43=4,G43,0)","v":0},{"$f":"IF(AZ43=5,G43,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[16,"918101111R00","Lože pod obrubníky nebo obruby dlažeb z C 12/15 ","m3",0.4,null,{"$f":"E44*F44","v":0},2.5249999999999999,{"$f":"E44*H44","v":1.01},0,{"$f":"E44*J44","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ44=1,G44,0)","v":0},{"$f":"IF(AZ44=2,G44,0)","v":0},{"$f":"IF(AZ44=3,G44,0)","v":0},{"$f":"IF(AZ44=4,G44,0)","v":0},{"$f":"IF(AZ44=5,G44,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Obrubníky:10,00*0,40*0,10",null,0.4,null,null,null,null,null,null,null,"Obrubníky:10,00*0,40*0,10"]
[17,"919731122R00","Zarovnání styčné plochy živičné tl. do 10 cm ","m",4,null,{"$f":"E46*F46","v":0},0,{"$f":"E46*H46","v":0},0,{"$f":"E46*J46","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ46=1,G46,0)","v":0},{"$f":"IF(AZ46=2,G46,0)","v":0},{"$f":"IF(AZ46=3,G46,0)","v":0},{"$f":"IF(AZ46=4,G46,0)","v":0},{"$f":"IF(AZ46=5,G46,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[18,"919735114R00","Řezání stávajícího živičného krytu tl. 15 - 20 cm ","m",20,null,{"$f":"E47*F47","v":0},0,{"$f":"E47*H47","v":0},0,{"$f":"E47*J47","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ47=1,G47,0)","v":0},{"$f":"IF(AZ47=2,G47,0)","v":0},{"$f":"IF(AZ47=3,G47,0)","v":0},{"$f":"IF(AZ47=4,G47,0)","v":0},{"$f":"IF(AZ47=5,G47,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,"Celkem za","91 Doplňující práce na komunikaci",null,null,null,{"$f":"SUM(G42:G47)","v":0},null,{"$f":"SUM(I42:I47)","v":3.4458000000000002},null,{"$f":"SUM(K42:K47)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA42:BA47)","v":0},{"$f":"SUM(BB42:BB47)","v":0},{"$f":"SUM(BC42:BC47)","v":0},{"$f":"SUM(BD42:BD47)","v":0},{"$f":"SUM(BE42:BE47)","v":0}]
["Díl:","93","Dokončovací práce inženýrských staveb",null,null,null,null,null,null,null,null,null,null,null,1]
[19,"938909111R00","Odstranění nánosu s povrchu podkladu štěrkového ","m2",510,null,{"$f":"E50*F50","v":0},0,{"$f":"E50*H50","v":0},0,{"$f":"E50*J50","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ50=1,G50,0)","v":0},{"$f":"IF(AZ50=2,G50,0)","v":0},{"$f":"IF(AZ50=3,G50,0)","v":0},{"$f":"IF(AZ50=4,G50,0)","v":0},{"$f":"IF(AZ50=5,G50,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha komunikace a křižovatky:450,00+60,00",null,510,null,null,null,null,null,null,null,"Plocha komunikace a křižovatky:450,00+60,00"]
[20,"938909311R00","Odstranění nánosu z povrchu živičného nebo beton. ","m2",450,null,{"$f":"E52*F52","v":0},0,{"$f":"E52*H52","v":0},0,{"$f":"E52*J52","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ52=1,G52,0)","v":0},{"$f":"IF(AZ52=2,G52,0)","v":0},{"$f":"IF(AZ52=3,G52,0)","v":0},{"$f":"IF(AZ52=4,G52,0)","v":0},{"$f":"IF(AZ52=5,G52,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha komunikace a křižovatky:450,00",null,450,null,null,null,null,null,null,null,"Plocha komunikace a křižovatky:450,00"]
[21,"938909612R00","Odstranění nánosu na krajnicích tl. do 20 cm ","m2",41.25,null,{"$f":"E54*F54","v":0},0,{"$f":"E54*H54","v":0},-0.252,{"$f":"E54*J54","v":-10.395},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ54=1,G54,0)","v":0},{"$f":"IF(AZ54=2,G54,0)","v":0},{"$f":"IF(AZ54=3,G54,0)","v":0},{"$f":"IF(AZ54=4,G54,0)","v":0},{"$f":"IF(AZ54=5,G54,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Podél komunikace:(65,00+2*25)*0,25",null,28.75,null,null,null,null,null,null,null,"Podél komunikace:(65,00+2*25)*0,25"]
[null,null,"Křižovatka:25,00*0,50",null,12.5,null,null,null,null,null,null,null,"Křižovatka:25,00*0,50"]
[null,"Celkem za","93 Dokončovací práce inženýrských staveb",null,null,null,{"$f":"SUM(G49:G56)","v":0},null,{"$f":"SUM(I49:I56)","v":0},null,{"$f":"SUM(K49:K56)","v":-10.395},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA49:BA56)","v":0},{"$f":"SUM(BB49:BB56)","v":0},{"$f":"SUM(BC49:BC56)","v":0},{"$f":"SUM(BD49:BD56)","v":0},{"$f":"SUM(BE49:BE56)","v":0}]
["Díl:","99","Staveništní přesun hmot",null,null,null,null,null,null,null,null,null,null,null,1]
[22,"998225111R00","Přesun hmot, pozemní komunikace, kryt živičný ","t",129.01284000000001,null,{"$f":"E59*F59","v":0},0,{"$f":"E59*H59","v":0},null,{"$f":"E59*J59","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,7,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ59=1,G59,0)","v":0},{"$f":"IF(AZ59=2,G59,0)","v":0},{"$f":"IF(AZ59=3,G59,0)","v":0},{"$f":"IF(AZ59=4,G59,0)","v":0},{"$f":"IF(AZ59=5,G59,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1]
[null,"Celkem za","99 Staveništní přesun hmot",null,null,null,{"$f":"SUM(G58:G59)","v":0},null,{"$f":"SUM(I58:I59)","v":0},null,{"$f":"SUM(K58:K59)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA58:BA59)","v":0},{"$f":"SUM(BB58:BB59)","v":0},{"$f":"SUM(BC58:BC59)","v":0},{"$f":"SUM(BD58:BD59)","v":0},{"$f":"SUM(BE58:BE59)","v":0}]

{"sheet":"104 3326104 KL","index":4,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[22,0,22,1],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[50,1,50,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,1,44,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6]]}
["POLOŽKOVÝ ROZPOČET"]
["Rozpočet",null,"3326/104","Oprava MK \"Mašov - V Koutě\"",null,"JKSO ","822.29"]
[]
["Objekt",null,null,null,null,"SKP "]
["104",null,"Oprava MK \"Mašov - V Koutě\"",null,null,"Měrná jednotka","m2"]
["Stavba",null,null,null,null,"Počet jednotek",0]
["3326",null,"Oprava místních komunikací Turnov",null,null,"Náklady na m.j.",{"$f":"IF(G6=0,,ROUND((F30+F32)/G6,1))","v":0}]
["Projektant",null,null,null,null,"Typ rozpočtu"]
["Zpracovatel projektu"]
["Objednatel",null,"Město TURNOV"]
["Dodavatel",null,".",null,null,"Zakázkové číslo "]
["Rozpočtoval",null,null,null,null,"Počet listů"]
["ROZPOČTOVÉ NÁKLADY"]
["Základní rozpočtové náklady",null,null,"Ostatní rozpočtové náklady"]
[null,"HSV celkem",{"$f":"'104 3326104 Rek'!E12","v":0},{"$f":"'104 3326104 Rek'!A17","v":"Zařízení staveniště"},null,null,{"$f":"'104 3326104 Rek'!I17","v":0}]
["Z","PSV celkem",{"$f":"'104 3326104 Rek'!F12","v":0},{"$f":"'104 3326104 Rek'!A18","v":"Kompletační činnost (IČD)"},null,null,{"$f":"'104 3326104 Rek'!I18","v":0}]
["R","M práce celkem",{"$f":"'104 3326104 Rek'!H12","v":0},{"$f":"'104 3326104 Rek'!A19","v":"Vytýčení stavby a podz. inženýrských sítí"},null,null,{"$f":"'104 3326104 Rek'!I19","v":0}]
["N","M dodávky celkem",{"$f":"'104 3326104 Rek'!G12","v":0},{"$f":"'104 3326104 Rek'!A20","v":"DIO"},null,null,{"$f":"'104 3326104 Rek'!I20","v":0}]
["ZRN celkem",null,{"$f":"SUM(C15:C18)","v":0}]
[]
["HZS",null,{"$f":"'104 3326104 Rek'!I12","v":0}]
["ZRN+HZS",null,{"$f":"C19+C21","v":0}]
["ZRN+ost.náklady+HZS",null,{"$f":"C22+G23","v":0},"Ostatní náklady celkem",null,null,{"$f":"'104 3326104 Rek'!H21","v":0}]
["Vypracoval",null,null,"Za zhotovitele",null,"Za objednatele"]
["Jméno :",null,null,"Jméno :",null,"Jméno :"]
["Datum :",null,null,"Datum :",null,"Datum :"]
[]
["Podpis :",null,null,"Podpis:",null,"Podpis:"]
[]
["Základ pro DPH",null,21,"%  ",null,{"$f":"C23-F32","v":0}]
["DPH",null,{"$f":"C30","v":21},"% ",null,{"$f":"ROUND(PRODUCT(F30,C31/100),0)","v":0}]
["Základ pro DPH",null,0,"% ",null,0]
["DPH",null,{"$f":"C32","v":0},"% ",null,{"$f":"ROUND(PRODUCT(F32,C33/100),0)","v":0}]
["CENA ZA OBJEKT CELKEM",null,null,null,null,{"$f":"ROUND(SUM(F30:F33),0)","v":0}]
[]
["Poznámka :",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"104 3326104 Rek","index":5,"n_rows":21,"n_cols":53,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[1,6,1,8],[20,7,20,8]]}
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,null,null,"Rozpočet :","3326/104"]
["Objekt :",null,"104 Oprava MK \"Mašov - V Koutě\"",null,null,null,"Oprava MK \"Mašov - V Koutě\""]
[]
["REKAPITULACE  STAVEBNÍCH  DÍLŮ"]
[]
[null,"Stavební díl",null,null,"HSV","PSV","Dodávka","Montáž","HZS"]
[{"$f":"'104 3326104 Pol'!B7","v":"5"},{"$f":"'104 3326104 Pol'!C7","v":"Komunikace"},null,null,{"$f":"'104 3326104 Pol'!BA30","v":0},{"$f":"'104 3326104 Pol'!BB30","v":0},{"$f":"'104 3326104 Pol'!BC30","v":0},{"$f":"'104 3326104 Pol'!BD30","v":0},{"$f":"'104 3326104 Pol'!BE30","v":0}]
[{"$f":"'104 3326104 Pol'!B31","v":"8"},{"$f":"'104 3326104 Pol'!C31","v":"Trubní vedení"},null,null,{"$f":"'104 3326104 Pol'!BA33","v":0},{"$f":"'104 3326104 Pol'!BB33","v":0},{"$f":"'104 3326104 Pol'!BC33","v":0},{"$f":"'104 3326104 Pol'!BD33","v":0},{"$f":"'104 3326104 Pol'!BE33","v":0}]
[{"$f":"'104 3326104 Pol'!B34","v":"91"},{"$f":"'104 3326104 Pol'!C34","v":"Doplňující práce na komunikaci"},null,null,{"$f":"'104 3326104 Pol'!BA37","v":0},{"$f":"'104 3326104 Pol'!BB37","v":0},{"$f":"'104 3326104 Pol'!BC37","v":0},{"$f":"'104 3326104 Pol'!BD37","v":0},{"$f":"'104 3326104 Pol'!BE37","v":0}]
[{"$f":"'104 3326104 Pol'!B38","v":"93"},{"$f":"'104 3326104 Pol'!C38","v":"Dokončovací práce inženýrských staveb"},null,null,{"$f":"'104 3326104 Pol'!BA45","v":0},{"$f":"'104 3326104 Pol'!BB45","v":0},{"$f":"'104 3326104 Pol'!BC45","v":0},{"$f":"'104 3326104 Pol'!BD45","v":0},{"$f":"'104 3326104 Pol'!BE45","v":0}]
[{"$f":"'104 3326104 Pol'!B46","v":"99"},{"$f":"'104 3326104 Pol'!C46","v":"Staveništní přesun hmot"},null,null,{"$f":"'104 3326104 Pol'!BA48","v":0},{"$f":"'104 3326104 Pol'!BB48","v":0},{"$f":"'104 3326104 Pol'!BC48","v":0},{"$f":"'104 3326104 Pol'!BD48","v":0},{"$f":"'104 3326104 Pol'!BE48","v":0}]
[null,"CELKEM  OBJEKT",null,null,{"$f":"SUM(E7:E11)","v":0},{"$f":"SUM(F7:F11)","v":0},{"$f":"SUM(G7:G11)","v":0},{"$f":"SUM(H7:H11)","v":0},{"$f":"SUM(I7:I11)","v":0}]
[]
["VEDLEJŠÍ ROZPOČTOVÉ  NÁKLADY"]
[]
["Název VRN",null,null,null,"Kč",null,null,null,"Kč"]
["Zařízení staveniště",null,null,null,0,null,null,null,{"$f":"E17+F17*G17/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Kompletační činnost (IČD)",null,null,null,0,null,null,null,{"$f":"E18+F18*G18/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Vytýčení stavby a podz. inženýrských sítí",null,null,null,0,null,null,null,{"$f":"E19+F19*G19/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["DIO",null,null,null,0,null,null,null,{"$f":"E20+F20*G20/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"CELKEM VRN",null,null,null,null,null,{"$f":"SUM(I17:I20)","v":0}]

{"sheet":"104 3326104 Pol","index":6,"n_rows":48,"n_cols":80,"rows_kept":48,"cut":false,"hidden":false,"merged":[[20,2,20,3],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,4,3,6],[8,2,8,3],[9,2,9,3],[10,2,10,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[16,2,16,3],[18,2,18,3],[19,2,19,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[43,2,43,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[26,2,26,3],[27,2,27,3],[28,2,28,3]]}
["Položkový rozpočet "]
[]
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,"Rozpočet:",{"$f":"'104 3326104 Rek'!H1","v":"3326/104"}]
["Objekt :",null,"104 Oprava MK \"Mašov - V Koutě\"",null,{"$f":"'104 3326104 Rek'!G2","v":"Oprava MK \"Mašov - V Koutě\""}]
[]
["P.č.","Číslo položky","Název položky","MJ","množství","cena / MJ","celkem (Kč)","Jednotková hmotnost","Celková hmotnost","Jednotková dem.hmot.","Celková dem.hmot."]
["Díl:","5","Komunikace",null,null,null,null,null,null,null,null,null,null,null,1]
[1,"565131111RT2","Podklad z obal kamen. ACP 16+, š. do 3 m, tl. 5 cm plochy 201-1000 m2","m2",230,null,{"$f":"E8*F8","v":0},0.13188,{"$f":"E8*H8","v":30.3324},0,{"$f":"E8*J8","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ8=1,G8,0)","v":0},{"$f":"IF(AZ8=2,G8,0)","v":0},{"$f":"IF(AZ8=3,G8,0)","v":0},{"$f":"IF(AZ8=4,G8,0)","v":0},{"$f":"IF(AZ8=5,G8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:175,00",null,175,null,null,null,null,null,null,null,"Komunikace:175,00"]
[null,null,"Křižovatka :30,00",null,30,null,null,null,null,null,null,null,"Křižovatka :30,00"]
[null,null,"Nájezd ke gazáži:25,00",null,25,null,null,null,null,null,null,null,"Nájezd ke gazáži:25,00"]
[2,"566501111R00","Úprava krytu kamenivem drceným do 0,10 m3/m2 ","m2",230,null,{"$f":"E12*F12","v":0},0.17726,{"$f":"E12*H12","v":40.769800000000004},0,{"$f":"E12*J12","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ12=1,G12,0)","v":0},{"$f":"IF(AZ12=2,G12,0)","v":0},{"$f":"IF(AZ12=3,G12,0)","v":0},{"$f":"IF(AZ12=4,G12,0)","v":0},{"$f":"IF(AZ12=5,G12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:175,00",null,175,null,null,null,null,null,null,null,"Komunikace:175,00"]
[null,null,"Křižovatka :30,00",null,30,null,null,null,null,null,null,null,"Křižovatka :30,00"]
[null,null,"Nájezd ke gazáži:25,00",null,25,null,null,null,null,null,null,null,"Nájezd ke gazáži:25,00"]
[3,"569831111R00","Zpevnění krajnic štěrkodrtí tloušťky  10 cm ","m2",34,null,{"$f":"E16*F16","v":0},0.18776000000000001,{"$f":"E16*H16","v":6.3838400000000002},0,{"$f":"E16*J16","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ16=1,G16,0)","v":0},{"$f":"IF(AZ16=2,G16,0)","v":0},{"$f":"IF(AZ16=3,G16,0)","v":0},{"$f":"IF(AZ16=4,G16,0)","v":0},{"$f":"IF(AZ16=5,G16,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace a křižovatka:136,00*0,25",null,34,null,null,null,null,null,null,null,"Komunikace a křižovatka:136,00*0,25"]
[4,"573111111R00","Postřik živičný infiltr.+ posyp, asfalt. 0,60kg/m2 ","m2",230,null,{"$f":"E18*F18","v":0},5.6100000000000004E-3,{"$f":"E18*H18","v":1.2903},0,{"$f":"E18*J18","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ18=1,G18,0)","v":0},{"$f":"IF(AZ18=2,G18,0)","v":0},{"$f":"IF(AZ18=3,G18,0)","v":0},{"$f":"IF(AZ18=4,G18,0)","v":0},{"$f":"IF(AZ18=5,G18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:175,00",null,175,null,null,null,null,null,null,null,"Komunikace:175,00"]
[null,null,"Křižovatka :30,00",null,30,null,null,null,null,null,null,null,"Křižovatka :30,00"]
[null,null,"Nájezd ke gazáži:25,00",null,25,null,null,null,null,null,null,null,"Nájezd ke gazáži:25,00"]
[5,"573231126R00","Postřik spojovací z KAE množství zbytkového asfaltu 0,6 kg/m2","m2",230,null,{"$f":"E22*F22","v":0},5.0000000000000001E-4,{"$f":"E22*H22","v":0.115},0,{"$f":"E22*J22","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ22=1,G22,0)","v":0},{"$f":"IF(AZ22=2,G22,0)","v":0},{"$f":"IF(AZ22=3,G22,0)","v":0},{"$f":"IF(AZ22=4,G22,0)","v":0},{"$f":"IF(AZ22=5,G22,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:175,00",null,175,null,null,null,null,null,null,null,"Komunikace:175,00"]
[null,null,"Křižovatka :30,00",null,30,null,null,null,null,null,null,null,"Křižovatka :30,00"]
[null,null,"Nájezd ke gazáži:25,00",null,25,null,null,null,null,null,null,null,"Nájezd ke gazáži:25,00"]
[6,"577131211RT2","Beton asfalt. ACO 8,nebo ACO 11, do 3 m, tl. 4 cm plochy 201-1000 m2","m2",230,null,{"$f":"E26*F26","v":0},0.10141,{"$f":"E26*H26","v":23.324300000000001},0,{"$f":"E26*J26","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ26=1,G26,0)","v":0},{"$f":"IF(AZ26=2,G26,0)","v":0},{"$f":"IF(AZ26=3,G26,0)","v":0},{"$f":"IF(AZ26=4,G26,0)","v":0},{"$f":"IF(AZ26=5,G26,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:175,00",null,175,null,null,null,null,null,null,null,"Komunikace:175,00"]
[null,null,"Křižovatka :30,00",null,30,null,null,null,null,null,null,null,"Křižovatka :30,00"]
[null,null,"Nájezd ke gazáži:25,00",null,25,null,null,null,null,null,null,null,"Nájezd ke gazáži:25,00"]
[null,"Celkem za","5 Komunikace",null,null,null,{"$f":"SUM(G7:G29)","v":0},null,{"$f":"SUM(I7:I29)","v":102.21564000000001},null,{"$f":"SUM(K7:K29)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA7:BA29)","v":0},{"$f":"SUM(BB7:BB29)","v":0},{"$f":"SUM(BC7:BC29)","v":0},{"$f":"SUM(BD7:BD29)","v":0},{"$f":"SUM(BE7:BE29)","v":0}]
["Díl:","8","Trubní vedení",null,null,null,null,null,null,null,null,null,null,null,1]
[7,"899431111R00","Výšková úprava do 20 cm, zvýšení krytu šoupěte ","kus",2,null,{"$f":"E32*F32","v":0},0.31590000000000001,{"$f":"E32*H32","v":0.63180000000000003},0,{"$f":"E32*J32","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ32=1,G32,0)","v":0},{"$f":"IF(AZ32=2,G32,0)","v":0},{"$f":"IF(AZ32=3,G32,0)","v":0},{"$f":"IF(AZ32=4,G32,0)","v":0},{"$f":"IF(AZ32=5,G32,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,"Celkem za","8 Trubní vedení",null,null,null,{"$f":"SUM(G31:G32)","v":0},null,{"$f":"SUM(I31:I32)","v":0.63180000000000003},null,{"$f":"SUM(K31:K32)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA31:BA32)","v":0},{"$f":"SUM(BB31:BB32)","v":0},{"$f":"SUM(BC31:BC32)","v":0},{"$f":"SUM(BD31:BD32)","v":0},{"$f":"SUM(BE31:BE32)","v":0}]
["Díl:","91","Doplňující práce na komunikaci",null,null,null,null,null,null,null,null,null,null,null,1]
[8,"919731122R00","Zarovnání styčné plochy živičné tl. do 10 cm ","m",3.5,null,{"$f":"E35*F35","v":0},0,{"$f":"E35*H35","v":0},0,{"$f":"E35*J35","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ35=1,G35,0)","v":0},{"$f":"IF(AZ35=2,G35,0)","v":0},{"$f":"IF(AZ35=3,G35,0)","v":0},{"$f":"IF(AZ35=4,G35,0)","v":0},{"$f":"IF(AZ35=5,G35,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[9,"919735112R00","Řezání stávajícího živičného krytu tl. 5 - 10 cm ","m",3.5,null,{"$f":"E36*F36","v":0},0,{"$f":"E36*H36","v":0},0,{"$f":"E36*J36","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ36=1,G36,0)","v":0},{"$f":"IF(AZ36=2,G36,0)","v":0},{"$f":"IF(AZ36=3,G36,0)","v":0},{"$f":"IF(AZ36=4,G36,0)","v":0},{"$f":"IF(AZ36=5,G36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,"Celkem za","91 Doplňující práce na komunikaci",null,null,null,{"$f":"SUM(G34:G36)","v":0},null,{"$f":"SUM(I34:I36)","v":0},null,{"$f":"SUM(K34:K36)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA34:BA36)","v":0},{"$f":"SUM(BB34:BB36)","v":0},{"$f":"SUM(BC34:BC36)","v":0},{"$f":"SUM(BD34:BD36)","v":0},{"$f":"SUM(BE34:BE36)","v":0}]
["Díl:","93","Dokončovací práce inženýrských staveb",null,null,null,null,null,null,null,null,null,null,null,1]
[10,"938909111R00","Odstranění nánosu s povrchu podkladu štěrkového ","m2",230,null,{"$f":"E39*F39","v":0},0,{"$f":"E39*H39","v":0},0,{"$f":"E39*J39","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ39=1,G39,0)","v":0},{"$f":"IF(AZ39=2,G39,0)","v":0},{"$f":"IF(AZ39=3,G39,0)","v":0},{"$f":"IF(AZ39=4,G39,0)","v":0},{"$f":"IF(AZ39=5,G39,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:175,00",null,175,null,null,null,null,null,null,null,"Komunikace:175,00"]
[null,null,"Křižovatka :30,00",null,30,null,null,null,null,null,null,null,"Křižovatka :30,00"]
[null,null,"Nájezd ke gazáži:25,00",null,25,null,null,null,null,null,null,null,"Nájezd ke gazáži:25,00"]
[11,"938909611R00","Odstranění nánosu na krajnicích tl. do 10 cm ","m2",34,null,{"$f":"E43*F43","v":0},0,{"$f":"E43*H43","v":0},-0.126,{"$f":"E43*J43","v":-4.2839999999999998},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ43=1,G43,0)","v":0},{"$f":"IF(AZ43=2,G43,0)","v":0},{"$f":"IF(AZ43=3,G43,0)","v":0},{"$f":"IF(AZ43=4,G43,0)","v":0},{"$f":"IF(AZ43=5,G43,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace a křižovatka:136,00*0,25",null,34,null,null,null,null,null,null,null,"Komunikace a křižovatka:136,00*0,25"]
[null,"Celkem za","93 Dokončovací práce inženýrských staveb",null,null,null,{"$f":"SUM(G38:G44)","v":0},null,{"$f":"SUM(I38:I44)","v":0},null,{"$f":"SUM(K38:K44)","v":-4.2839999999999998},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA38:BA44)","v":0},{"$f":"SUM(BB38:BB44)","v":0},{"$f":"SUM(BC38:BC44)","v":0},{"$f":"SUM(BD38:BD44)","v":0},{"$f":"SUM(BE38:BE44)","v":0}]
["Díl:","99","Staveništní přesun hmot",null,null,null,null,null,null,null,null,null,null,null,1]
[12,"998225111R00","Přesun hmot, pozemní komunikace, kryt živičný ","t",102.84744000000001,null,{"$f":"E47*F47","v":0},0,{"$f":"E47*H47","v":0},null,{"$f":"E47*J47","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,7,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ47=1,G47,0)","v":0},{"$f":"IF(AZ47=2,G47,0)","v":0},{"$f":"IF(AZ47=3,G47,0)","v":0},{"$f":"IF(AZ47=4,G47,0)","v":0},{"$f":"IF(AZ47=5,G47,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1]
[null,"Celkem za","99 Staveništní přesun hmot",null,null,null,{"$f":"SUM(G46:G47)","v":0},null,{"$f":"SUM(I46:I47)","v":0},null,{"$f":"SUM(K46:K47)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA46:BA47)","v":0},{"$f":"SUM(BB46:BB47)","v":0},{"$f":"SUM(BC46:BC47)","v":0},{"$f":"SUM(BD46:BD47)","v":0},{"$f":"SUM(BE46:BE47)","v":0}]

{"sheet":"105 3326105.1 KL","index":7,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[22,0,22,1],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[50,1,50,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,1,44,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6]]}
["POLOŽKOVÝ ROZPOČET"]
["Rozpočet",null,"3326/105.1","Oprava MK \"Mašov-Mašovská u hřbitova\"-úsek k ČOV",null,"JKSO ","822.29"]
[]
["Objekt",null,null,null,null,"SKP "]
["105",null,"Oprava MK \"Mašov - Mašovská u hřbitova\"",null,null,"Měrná jednotka","m2"]
["Stavba",null,null,null,null,"Počet jednotek",0]
["3326",null,"Oprava místních komunikací Turnov",null,null,"Náklady na m.j.",{"$f":"IF(G6=0,,ROUND((F30+F32)/G6,1))","v":0}]
["Projektant",null,null,null,null,"Typ rozpočtu"]
["Zpracovatel projektu"]
["Objednatel",null,"Město TURNOV"]
["Dodavatel",null,".",null,null,"Zakázkové číslo "]
["Rozpočtoval",null,null,null,null,"Počet listů"]
["ROZPOČTOVÉ NÁKLADY"]
["Základní rozpočtové náklady",null,null,"Ostatní rozpočtové náklady"]
[null,"HSV celkem",{"$f":"'105 3326105.1 Rek'!E11","v":0},{"$f":"'105 3326105.1 Rek'!A16","v":"Zařízení staveniště"},null,null,{"$f":"'105 3326105.1 Rek'!I16","v":0}]
["Z","PSV celkem",{"$f":"'105 3326105.1 Rek'!F11","v":0},{"$f":"'105 3326105.1 Rek'!A17","v":"Kompletační činnost (IČD)"},null,null,{"$f":"'105 3326105.1 Rek'!I17","v":0}]
["R","M práce celkem",{"$f":"'105 3326105.1 Rek'!H11","v":0},{"$f":"'105 3326105.1 Rek'!A18","v":"Vytýčení stavby a podz. inženýrských sítí"},null,null,{"$f":"'105 3326105.1 Rek'!I18","v":0}]
["N","M dodávky celkem",{"$f":"'105 3326105.1 Rek'!G11","v":0},{"$f":"'105 3326105.1 Rek'!A19","v":"DIO"},null,null,{"$f":"'105 3326105.1 Rek'!I19","v":0}]
["ZRN celkem",null,{"$f":"SUM(C15:C18)","v":0}]
[]
["HZS",null,{"$f":"'105 3326105.1 Rek'!I11","v":0}]
["ZRN+HZS",null,{"$f":"C19+C21","v":0}]
["ZRN+ost.náklady+HZS",null,{"$f":"C22+G23","v":0},"Ostatní náklady celkem",null,null,{"$f":"'105 3326105.1 Rek'!H20","v":0}]
["Vypracoval",null,null,"Za zhotovitele",null,"Za objednatele"]
["Jméno :",null,null,"Jméno :",null,"Jméno :"]
["Datum :",null,null,"Datum :",null,"Datum :"]
[]
["Podpis :",null,null,"Podpis:",null,"Podpis:"]
[]
["Základ pro DPH",null,21,"%  ",null,{"$f":"C23-F32","v":0}]
["DPH",null,{"$f":"C30","v":21},"% ",null,{"$f":"ROUND(PRODUCT(F30,C31/100),0)","v":0}]
["Základ pro DPH",null,0,"% ",null,0]
["DPH",null,{"$f":"C32","v":0},"% ",null,{"$f":"ROUND(PRODUCT(F32,C33/100),0)","v":0}]
["CENA ZA OBJEKT CELKEM",null,null,null,null,{"$f":"ROUND(SUM(F30:F33),0)","v":0}]
[]
["Poznámka :",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"105 3326105.1 Rek","index":8,"n_rows":20,"n_cols":53,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[1,6,1,8],[19,7,19,8]]}
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,null,null,"Rozpočet :","3326/105.1"]
["Objekt :",null,"105 Oprava MK \"Mašov - Mašovská u hřbitova\"",null,null,null,"Oprava MK \"Mašov-Mašovská u hřbitova\"-úsek k ČOV"]
[]
["REKAPITULACE  STAVEBNÍCH  DÍLŮ"]
[]
[null,"Stavební díl",null,null,"HSV","PSV","Dodávka","Montáž","HZS"]
[{"$f":"'105 3326105.1 Pol'!B7","v":"5"},{"$f":"'105 3326105.1 Pol'!C7","v":"Komunikace"},null,null,{"$f":"'105 3326105.1 Pol'!BA24","v":0},{"$f":"'105 3326105.1 Pol'!BB24","v":0},{"$f":"'105 3326105.1 Pol'!BC24","v":0},{"$f":"'105 3326105.1 Pol'!BD24","v":0},{"$f":"'105 3326105.1 Pol'!BE24","v":0}]
[{"$f":"'105 3326105.1 Pol'!B25","v":"91"},{"$f":"'105 3326105.1 Pol'!C25","v":"Doplňující práce na komunikaci"},null,null,{"$f":"'105 3326105.1 Pol'!BA28","v":0},{"$f":"'105 3326105.1 Pol'!BB28","v":0},{"$f":"'105 3326105.1 Pol'!BC28","v":0},{"$f":"'105 3326105.1 Pol'!BD28","v":0},{"$f":"'105 3326105.1 Pol'!BE28","v":0}]
[{"$f":"'105 3326105.1 Pol'!B29","v":"93"},{"$f":"'105 3326105.1 Pol'!C29","v":"Dokončovací práce inženýrských staveb"},null,null,{"$f":"'105 3326105.1 Pol'!BA36","v":0},{"$f":"'105 3326105.1 Pol'!BB36","v":0},{"$f":"'105 3326105.1 Pol'!BC36","v":0},{"$f":"'105 3326105.1 Pol'!BD36","v":0},{"$f":"'105 3326105.1 Pol'!BE36","v":0}]
[{"$f":"'105 3326105.1 Pol'!B37","v":"99"},{"$f":"'105 3326105.1 Pol'!C37","v":"Staveništní přesun hmot"},null,null,{"$f":"'105 3326105.1 Pol'!BA39","v":0},{"$f":"'105 3326105.1 Pol'!BB39","v":0},{"$f":"'105 3326105.1 Pol'!BC39","v":0},{"$f":"'105 3326105.1 Pol'!BD39","v":0},{"$f":"'105 3326105.1 Pol'!BE39","v":0}]
[null,"CELKEM  OBJEKT",null,null,{"$f":"SUM(E7:E10)","v":0},{"$f":"SUM(F7:F10)","v":0},{"$f":"SUM(G7:G10)","v":0},{"$f":"SUM(H7:H10)","v":0},{"$f":"SUM(I7:I10)","v":0}]
[]
["VEDLEJŠÍ ROZPOČTOVÉ  NÁKLADY"]
[]
["Název VRN",null,null,null,"Kč",null,null,null,"Kč"]
["Zařízení staveniště",null,null,null,0,null,null,null,{"$f":"E16+F16*G16/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Kompletační činnost (IČD)",null,null,null,0,null,null,null,{"$f":"E17+F17*G17/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Vytýčení stavby a podz. inženýrských sítí",null,null,null,0,null,null,null,{"$f":"E18+F18*G18/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["DIO",null,null,null,0,null,null,null,{"$f":"E19+F19*G19/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"CELKEM VRN",null,null,null,null,null,{"$f":"SUM(I16:I19)","v":0}]

{"sheet":"105 3326105.1 Pol","index":9,"n_rows":39,"n_cols":80,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,2,10,3],[12,2,12,3],[14,2,14,3],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,4,3,6],[8,2,8,3],[30,2,30,3],[32,2,32,3],[34,2,34,3],[16,2,16,3],[18,2,18,3],[19,2,19,3],[21,2,21,3],[22,2,22,3]]}
["Položkový rozpočet "]
[]
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,"Rozpočet:",{"$f":"'105 3326105.1 Rek'!H1","v":"3326/105.1"}]
["Objekt :",null,"105 Oprava MK \"Mašov - Mašovská u hřbitova\"",null,{"$f":"'105 3326105.1 Rek'!G2","v":"Oprava MK \"Mašov-Mašovská u hřbitova\"-úsek k ČOV"}]
[]
["P.č.","Číslo položky","Název položky","MJ","množství","cena / MJ","celkem (Kč)","Jednotková hmotnost","Celková hmotnost","Jednotková dem.hmot.","Celková dem.hmot."]
["Díl:","5","Komunikace",null,null,null,null,null,null,null,null,null,null,null,1]
[1,"565131211RT3","Podklad z obal kamen. ACP 16+, š.nad 3 m, tl. 5 cm plochy 101-200 m2","m2",35,null,{"$f":"E8*F8","v":0},0.13188,{"$f":"E8*H8","v":4.6158000000000001},0,{"$f":"E8*J8","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ8=1,G8,0)","v":0},{"$f":"IF(AZ8=2,G8,0)","v":0},{"$f":"IF(AZ8=3,G8,0)","v":0},{"$f":"IF(AZ8=4,G8,0)","v":0},{"$f":"IF(AZ8=5,G8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Odstavná plocha u hřbitova:35,00",null,35,null,null,null,null,null,null,null,"Odstavná plocha u hřbitova:35,00"]
[2,"566501111R00","Úprava krytu kamenivem drceným do 0,10 m3/m2 ","m2",35,null,{"$f":"E10*F10","v":0},0.17726,{"$f":"E10*H10","v":6.2041000000000004},0,{"$f":"E10*J10","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ10=1,G10,0)","v":0},{"$f":"IF(AZ10=2,G10,0)","v":0},{"$f":"IF(AZ10=3,G10,0)","v":0},{"$f":"IF(AZ10=4,G10,0)","v":0},{"$f":"IF(AZ10=5,G10,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Odstavná plocha u hřbitova:35,00",null,35,null,null,null,null,null,null,null,"Odstavná plocha u hřbitova:35,00"]
[3,"569831111R00","Zpevnění krajnic štěrkodrtí tloušťky  10 cm ","m2",120,null,{"$f":"E12*F12","v":0},0.18776000000000001,{"$f":"E12*H12","v":22.531200000000002},0,{"$f":"E12*J12","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ12=1,G12,0)","v":0},{"$f":"IF(AZ12=2,G12,0)","v":0},{"$f":"IF(AZ12=3,G12,0)","v":0},{"$f":"IF(AZ12=4,G12,0)","v":0},{"$f":"IF(AZ12=5,G12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Krajnice:240,00*0,25*2",null,120,null,null,null,null,null,null,null,"Krajnice:240,00*0,25*2"]
[4,"572713112R00","Vyrovnání povrchu krytů kamen. obaleným asfaltem ","t",101,null,{"$f":"E14*F14","v":0},1,{"$f":"E14*H14","v":101},0,{"$f":"E14*J14","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ14=1,G14,0)","v":0},{"$f":"IF(AZ14=2,G14,0)","v":0},{"$f":"IF(AZ14=3,G14,0)","v":0},{"$f":"IF(AZ14=4,G14,0)","v":0},{"$f":"IF(AZ14=5,G14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:1010,00*0,08/2*2,5",null,101,null,null,null,null,null,null,null,"Komunikace:1010,00*0,08/2*2,5"]
[5,"573111111R00","Postřik živičný infiltr.+ posyp, asfalt. 0,60kg/m2 ","m2",35,null,{"$f":"E16*F16","v":0},5.6100000000000004E-3,{"$f":"E16*H16","v":0.19635000000000002},0,{"$f":"E16*J16","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ16=1,G16,0)","v":0},{"$f":"IF(AZ16=2,G16,0)","v":0},{"$f":"IF(AZ16=3,G16,0)","v":0},{"$f":"IF(AZ16=4,G16,0)","v":0},{"$f":"IF(AZ16=5,G16,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Odstavná plocha u hřbitova:35,00",null,35,null,null,null,null,null,null,null,"Odstavná plocha u hřbitova:35,00"]
[6,"573231126R00","Postřik spojovací z KAE množství zbytkového asfaltu 0,6 kg/m2","m2",1045,null,{"$f":"E18*F18","v":0},5.0000000000000001E-4,{"$f":"E18*H18","v":0.52249999999999996},0,{"$f":"E18*J18","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ18=1,G18,0)","v":0},{"$f":"IF(AZ18=2,G18,0)","v":0},{"$f":"IF(AZ18=3,G18,0)","v":0},{"$f":"IF(AZ18=4,G18,0)","v":0},{"$f":"IF(AZ18=5,G18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:1010,00",null,1010,null,null,null,null,null,null,null,"Komunikace:1010,00"]
[null,null,"Odstavná plocha u hřbitova:35,00",null,35,null,null,null,null,null,null,null,"Odstavná plocha u hřbitova:35,00"]
[7,"577142112RT2","Beton asfaltový ACO 11+, ACO 16+, nad 3 m, tl.5 cm plochy 201-1000 m2","m2",1045,null,{"$f":"E21*F21","v":0},0.12966,{"$f":"E21*H21","v":135.49469999999999},0,{"$f":"E21*J21","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ21=1,G21,0)","v":0},{"$f":"IF(AZ21=2,G21,0)","v":0},{"$f":"IF(AZ21=3,G21,0)","v":0},{"$f":"IF(AZ21=4,G21,0)","v":0},{"$f":"IF(AZ21=5,G21,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:1010,00",null,1010,null,null,null,null,null,null,null,"Komunikace:1010,00"]
[null,null,"Odstavná plocha u hřbitova:35,00",null,35,null,null,null,null,null,null,null,"Odstavná plocha u hřbitova:35,00"]
[null,"Celkem za","5 Komunikace",null,null,null,{"$f":"SUM(G7:G23)","v":0},null,{"$f":"SUM(I7:I23)","v":270.56465000000003},null,{"$f":"SUM(K7:K23)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA7:BA23)","v":0},{"$f":"SUM(BB7:BB23)","v":0},{"$f":"SUM(BC7:BC23)","v":0},{"$f":"SUM(BD7:BD23)","v":0},{"$f":"SUM(BE7:BE23)","v":0}]
["Díl:","91","Doplňující práce na komunikaci",null,null,null,null,null,null,null,null,null,null,null,1]
[8,"919731122R00","Zarovnání styčné plochy živičné tl. do 10 cm ","m",10,null,{"$f":"E26*F26","v":0},0,{"$f":"E26*H26","v":0},0,{"$f":"E26*J26","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ26=1,G26,0)","v":0},{"$f":"IF(AZ26=2,G26,0)","v":0},{"$f":"IF(AZ26=3,G26,0)","v":0},{"$f":"IF(AZ26=4,G26,0)","v":0},{"$f":"IF(AZ26=5,G26,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[9,"919735112R00","Řezání stávajícího živičného krytu tl. 5 - 10 cm ","m",10,null,{"$f":"E27*F27","v":0},0,{"$f":"E27*H27","v":0},0,{"$f":"E27*J27","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ27=1,G27,0)","v":0},{"$f":"IF(AZ27=2,G27,0)","v":0},{"$f":"IF(AZ27=3,G27,0)","v":0},{"$f":"IF(AZ27=4,G27,0)","v":0},{"$f":"IF(AZ27=5,G27,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,"Celkem za","91 Doplňující práce na komunikaci",null,null,null,{"$f":"SUM(G25:G27)","v":0},null,{"$f":"SUM(I25:I27)","v":0},null,{"$f":"SUM(K25:K27)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA25:BA27)","v":0},{"$f":"SUM(BB25:BB27)","v":0},{"$f":"SUM(BC25:BC27)","v":0},{"$f":"SUM(BD25:BD27)","v":0},{"$f":"SUM(BE25:BE27)","v":0}]
["Díl:","93","Dokončovací práce inženýrských staveb",null,null,null,null,null,null,null,null,null,null,null,1]
[10,"938909111R00","Odstranění nánosu s povrchu podkladu štěrkového ","m2",35,null,{"$f":"E30*F30","v":0},0,{"$f":"E30*H30","v":0},0,{"$f":"E30*J30","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ30=1,G30,0)","v":0},{"$f":"IF(AZ30=2,G30,0)","v":0},{"$f":"IF(AZ30=3,G30,0)","v":0},{"$f":"IF(AZ30=4,G30,0)","v":0},{"$f":"IF(AZ30=5,G30,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Odstavná plocha u hřbitova:35,00",null,35,null,null,null,null,null,null,null,"Odstavná plocha u hřbitova:35,00"]
[11,"938909311R00","Odstranění nánosu z povrchu živičného nebo beton. ","m2",1010,null,{"$f":"E32*F32","v":0},0,{"$f":"E32*H32","v":0},0,{"$f":"E32*J32","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ32=1,G32,0)","v":0},{"$f":"IF(AZ32=2,G32,0)","v":0},{"$f":"IF(AZ32=3,G32,0)","v":0},{"$f":"IF(AZ32=4,G32,0)","v":0},{"$f":"IF(AZ32=5,G32,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace:1010,00",null,1010,null,null,null,null,null,null,null,"Komunikace:1010,00"]
[12,"938909611R00","Odstranění nánosu na krajnicích tl. do 10 cm ","m2",120,null,{"$f":"E34*F34","v":0},0,{"$f":"E34*H34","v":0},-0.126,{"$f":"E34*J34","v":-15.120000000000001},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ34=1,G34,0)","v":0},{"$f":"IF(AZ34=2,G34,0)","v":0},{"$f":"IF(AZ34=3,G34,0)","v":0},{"$f":"IF(AZ34=4,G34,0)","v":0},{"$f":"IF(AZ34=5,G34,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Krajnice:240,00*0,25*2",null,120,null,null,null,null,null,null,null,"Krajnice:240,00*0,25*2"]
[null,"Celkem za","93 Dokončovací práce inženýrských staveb",null,null,null,{"$f":"SUM(G29:G35)","v":0},null,{"$f":"SUM(I29:I35)","v":0},null,{"$f":"SUM(K29:K35)","v":-15.120000000000001},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA29:BA35)","v":0},{"$f":"SUM(BB29:BB35)","v":0},{"$f":"SUM(BC29:BC35)","v":0},{"$f":"SUM(BD29:BD35)","v":0},{"$f":"SUM(BE29:BE35)","v":0}]
["Díl:","99","Staveništní přesun hmot",null,null,null,null,null,null,null,null,null,null,null,1]
[13,"998225111R00","Přesun hmot, pozemní komunikace, kryt živičný ","t",270.56464999999997,null,{"$f":"E38*F38","v":0},0,{"$f":"E38*H38","v":0},null,{"$f":"E38*J38","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,7,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ38=1,G38,0)","v":0},{"$f":"IF(AZ38=2,G38,0)","v":0},{"$f":"IF(AZ38=3,G38,0)","v":0},{"$f":"IF(AZ38=4,G38,0)","v":0},{"$f":"IF(AZ38=5,G38,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1]
[null,"Celkem za","99 Staveništní přesun hmot",null,null,null,{"$f":"SUM(G37:G38)","v":0},null,{"$f":"SUM(I37:I38)","v":0},null,{"$f":"SUM(K37:K38)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA37:BA38)","v":0},{"$f":"SUM(BB37:BB38)","v":0},{"$f":"SUM(BC37:BC38)","v":0},{"$f":"SUM(BD37:BD38)","v":0},{"$f":"SUM(BE37:BE38)","v":0}]

{"sheet":"105 3326105.2 KL","index":10,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[22,0,22,1],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[50,1,50,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,1,44,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6]]}
["POLOŽKOVÝ ROZPOČET"]
["Rozpočet",null,"3326/105.2","Oprava MK \"Mašov-Mašovská u hřbitova\"-křiž. u ČOV",null,"JKSO ","822.29"]
[]
["Objekt",null,null,null,null,"SKP "]
["105",null,"Oprava MK \"Mašov - Mašovská u hřbitova\"",null,null,"Měrná jednotka","m2"]
["Stavba",null,null,null,null,"Počet jednotek",0]
["3326",null,"Oprava místních komunikací Turnov",null,null,"Náklady na m.j.",{"$f":"IF(G6=0,,ROUND((F30+F32)/G6,1))","v":0}]
["Projektant",null,null,null,null,"Typ rozpočtu"]
["Zpracovatel projektu"]
["Objednatel",null,"Město TURNOV"]
["Dodavatel",null,".",null,null,"Zakázkové číslo "]
["Rozpočtoval",null,null,null,null,"Počet listů"]
["ROZPOČTOVÉ NÁKLADY"]
["Základní rozpočtové náklady",null,null,"Ostatní rozpočtové náklady"]
[null,"HSV celkem",{"$f":"'105 3326105.2 Rek'!E11","v":0},{"$f":"'105 3326105.2 Rek'!A16","v":"Zařízení staveniště"},null,null,{"$f":"'105 3326105.2 Rek'!I16","v":0}]
["Z","PSV celkem",{"$f":"'105 3326105.2 Rek'!F11","v":0},{"$f":"'105 3326105.2 Rek'!A17","v":"Kompletační činnost (IČD)"},null,null,{"$f":"'105 3326105.2 Rek'!I17","v":0}]
["R","M práce celkem",{"$f":"'105 3326105.2 Rek'!H11","v":0},{"$f":"'105 3326105.2 Rek'!A18","v":"Vytýčení stavby a podz. inženýrských sítí"},null,null,{"$f":"'105 3326105.2 Rek'!I18","v":0}]
["N","M dodávky celkem",{"$f":"'105 3326105.2 Rek'!G11","v":0},{"$f":"'105 3326105.2 Rek'!A19","v":"DIO"},null,null,{"$f":"'105 3326105.2 Rek'!I19","v":0}]
["ZRN celkem",null,{"$f":"SUM(C15:C18)","v":0}]
[]
["HZS",null,{"$f":"'105 3326105.2 Rek'!I11","v":0}]
["ZRN+HZS",null,{"$f":"C19+C21","v":0}]
["ZRN+ost.náklady+HZS",null,{"$f":"C22+G23","v":0},"Ostatní náklady celkem",null,null,{"$f":"'105 3326105.2 Rek'!H20","v":0}]
["Vypracoval",null,null,"Za zhotovitele",null,"Za objednatele"]
["Jméno :",null,null,"Jméno :",null,"Jméno :"]
["Datum :",null,null,"Datum :",null,"Datum :"]
[]
["Podpis :",null,null,"Podpis:",null,"Podpis:"]
[]
["Základ pro DPH",null,21,"%  ",null,{"$f":"C23-F32","v":0}]
["DPH",null,{"$f":"C30","v":21},"% ",null,{"$f":"ROUND(PRODUCT(F30,C31/100),0)","v":0}]
["Základ pro DPH",null,0,"% ",null,0]
["DPH",null,{"$f":"C32","v":0},"% ",null,{"$f":"ROUND(PRODUCT(F32,C33/100),0)","v":0}]
["CENA ZA OBJEKT CELKEM",null,null,null,null,{"$f":"ROUND(SUM(F30:F33),0)","v":0}]
[]
["Poznámka :",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"105 3326105.2 Rek","index":11,"n_rows":20,"n_cols":53,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[1,6,1,8],[19,7,19,8]]}
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,null,null,"Rozpočet :","3326/105.2"]
["Objekt :",null,"105 Oprava MK \"Mašov - Mašovská u hřbitova\"",null,null,null,"Oprava MK \"Mašov-Mašovská u hřbitova\"-křiž. u ČOV"]
[]
["REKAPITULACE  STAVEBNÍCH  DÍLŮ"]
[]
[null,"Stavební díl",null,null,"HSV","PSV","Dodávka","Montáž","HZS"]
[{"$f":"'105 3326105.2 Pol'!B7","v":"5"},{"$f":"'105 3326105.2 Pol'!C7","v":"Komunikace"},null,null,{"$f":"'105 3326105.2 Pol'!BA16","v":0},{"$f":"'105 3326105.2 Pol'!BB16","v":0},{"$f":"'105 3326105.2 Pol'!BC16","v":0},{"$f":"'105 3326105.2 Pol'!BD16","v":0},{"$f":"'105 3326105.2 Pol'!BE16","v":0}]
[{"$f":"'105 3326105.2 Pol'!B17","v":"8"},{"$f":"'105 3326105.2 Pol'!C17","v":"Trubní vedení"},null,null,{"$f":"'105 3326105.2 Pol'!BA19","v":0},{"$f":"'105 3326105.2 Pol'!BB19","v":0},{"$f":"'105 3326105.2 Pol'!BC19","v":0},{"$f":"'105 3326105.2 Pol'!BD19","v":0},{"$f":"'105 3326105.2 Pol'!BE19","v":0}]
[{"$f":"'105 3326105.2 Pol'!B20","v":"93"},{"$f":"'105 3326105.2 Pol'!C20","v":"Dokončovací práce inženýrských staveb"},null,null,{"$f":"'105 3326105.2 Pol'!BA25","v":0},{"$f":"'105 3326105.2 Pol'!BB25","v":0},{"$f":"'105 3326105.2 Pol'!BC25","v":0},{"$f":"'105 3326105.2 Pol'!BD25","v":0},{"$f":"'105 3326105.2 Pol'!BE25","v":0}]
[{"$f":"'105 3326105.2 Pol'!B26","v":"99"},{"$f":"'105 3326105.2 Pol'!C26","v":"Staveništní přesun hmot"},null,null,{"$f":"'105 3326105.2 Pol'!BA28","v":0},{"$f":"'105 3326105.2 Pol'!BB28","v":0},{"$f":"'105 3326105.2 Pol'!BC28","v":0},{"$f":"'105 3326105.2 Pol'!BD28","v":0},{"$f":"'105 3326105.2 Pol'!BE28","v":0}]
[null,"CELKEM  OBJEKT",null,null,{"$f":"SUM(E7:E10)","v":0},{"$f":"SUM(F7:F10)","v":0},{"$f":"SUM(G7:G10)","v":0},{"$f":"SUM(H7:H10)","v":0},{"$f":"SUM(I7:I10)","v":0}]
[]
["VEDLEJŠÍ ROZPOČTOVÉ  NÁKLADY"]
[]
["Název VRN",null,null,null,"Kč",null,null,null,"Kč"]
["Zařízení staveniště",null,null,null,0,null,null,null,{"$f":"E16+F16*G16/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Kompletační činnost (IČD)",null,null,null,0,null,null,null,{"$f":"E17+F17*G17/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Vytýčení stavby a podz. inženýrských sítí",null,null,null,0,null,null,null,{"$f":"E18+F18*G18/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["DIO",null,null,null,0,null,null,null,{"$f":"E19+F19*G19/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"CELKEM VRN",null,null,null,null,null,{"$f":"SUM(I16:I19)","v":0}]

{"sheet":"105 3326105.2 Pol","index":12,"n_rows":28,"n_cols":80,"rows_kept":28,"cut":false,"hidden":false,"merged":[[21,2,21,3],[23,2,23,3],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,4,3,6],[8,2,8,3],[10,2,10,3],[12,2,12,3],[14,2,14,3]]}
["Položkový rozpočet "]
[]
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,"Rozpočet:",{"$f":"'105 3326105.2 Rek'!H1","v":"3326/105.2"}]
["Objekt :",null,"105 Oprava MK \"Mašov - Mašovská u hřbitova\"",null,{"$f":"'105 3326105.2 Rek'!G2","v":"Oprava MK \"Mašov-Mašovská u hřbitova\"-křiž. u ČOV"}]
[]
["P.č.","Číslo položky","Název položky","MJ","množství","cena / MJ","celkem (Kč)","Jednotková hmotnost","Celková hmotnost","Jednotková dem.hmot.","Celková dem.hmot."]
["Díl:","5","Komunikace",null,null,null,null,null,null,null,null,null,null,null,1]
[1,"569831111R00","Zpevnění krajnic štěrkodrtí tloušťky  10 cm ","m2",13.75,null,{"$f":"E8*F8","v":0},0.18776000000000001,{"$f":"E8*H8","v":2.5817000000000001},0,{"$f":"E8*J8","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ8=1,G8,0)","v":0},{"$f":"IF(AZ8=2,G8,0)","v":0},{"$f":"IF(AZ8=3,G8,0)","v":0},{"$f":"IF(AZ8=4,G8,0)","v":0},{"$f":"IF(AZ8=5,G8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Křižovatka u ČOV:55,00*0,25",null,13.75,null,null,null,null,null,null,null,"Křižovatka u ČOV:55,00*0,25"]
[2,"572713112R00","Vyrovnání povrchu krytů kamen. obaleným asfaltem ","t",20.5,null,{"$f":"E10*F10","v":0},1,{"$f":"E10*H10","v":20.5},0,{"$f":"E10*J10","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ10=1,G10,0)","v":0},{"$f":"IF(AZ10=2,G10,0)","v":0},{"$f":"IF(AZ10=3,G10,0)","v":0},{"$f":"IF(AZ10=4,G10,0)","v":0},{"$f":"IF(AZ10=5,G10,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Křižovatka u ČOV:205,00*0,08/2*2,5",null,20.5,null,null,null,null,null,null,null,"Křižovatka u ČOV:205,00*0,08/2*2,5"]
[3,"573231126R00","Postřik spojovací z KAE množství zbytkového asfaltu 0,6 kg/m2","m2",205,null,{"$f":"E12*F12","v":0},5.0000000000000001E-4,{"$f":"E12*H12","v":0.10250000000000001},0,{"$f":"E12*J12","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ12=1,G12,0)","v":0},{"$f":"IF(AZ12=2,G12,0)","v":0},{"$f":"IF(AZ12=3,G12,0)","v":0},{"$f":"IF(AZ12=4,G12,0)","v":0},{"$f":"IF(AZ12=5,G12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Křižovatka u ČOV:205,00",null,205,null,null,null,null,null,null,null,"Křižovatka u ČOV:205,00"]
[4,"577142112RT2","Beton asfaltový ACO 11+, ACO 16+, nad 3 m, tl.5 cm plochy 201-1000 m2","m2",205,null,{"$f":"E14*F14","v":0},0.12966,{"$f":"E14*H14","v":26.580300000000001},0,{"$f":"E14*J14","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ14=1,G14,0)","v":0},{"$f":"IF(AZ14=2,G14,0)","v":0},{"$f":"IF(AZ14=3,G14,0)","v":0},{"$f":"IF(AZ14=4,G14,0)","v":0},{"$f":"IF(AZ14=5,G14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Křižovatka u ČOV:205,00",null,205,null,null,null,null,null,null,null,"Křižovatka u ČOV:205,00"]
[null,"Celkem za","5 Komunikace",null,null,null,{"$f":"SUM(G7:G15)","v":0},null,{"$f":"SUM(I7:I15)","v":49.764499999999998},null,{"$f":"SUM(K7:K15)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA7:BA15)","v":0},{"$f":"SUM(BB7:BB15)","v":0},{"$f":"SUM(BC7:BC15)","v":0},{"$f":"SUM(BD7:BD15)","v":0},{"$f":"SUM(BE7:BE15)","v":0}]
["Díl:","8","Trubní vedení",null,null,null,null,null,null,null,null,null,null,null,1]
[5,"899331111R00","Výšková úprava vstupu do 20 cm, zvýšení poklopu ","kus",2,null,{"$f":"E18*F18","v":0},0.43093999999999999,{"$f":"E18*H18","v":0.86187999999999998},0,{"$f":"E18*J18","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ18=1,G18,0)","v":0},{"$f":"IF(AZ18=2,G18,0)","v":0},{"$f":"IF(AZ18=3,G18,0)","v":0},{"$f":"IF(AZ18=4,G18,0)","v":0},{"$f":"IF(AZ18=5,G18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,"Celkem za","8 Trubní vedení",null,null,null,{"$f":"SUM(G17:G18)","v":0},null,{"$f":"SUM(I17:I18)","v":0.86187999999999998},null,{"$f":"SUM(K17:K18)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA17:BA18)","v":0},{"$f":"SUM(BB17:BB18)","v":0},{"$f":"SUM(BC17:BC18)","v":0},{"$f":"SUM(BD17:BD18)","v":0},{"$f":"SUM(BE17:BE18)","v":0}]
["Díl:","93","Dokončovací práce inženýrských staveb",null,null,null,null,null,null,null,null,null,null,null,1]
[6,"938909311R00","Odstranění nánosu z povrchu živičného nebo beton. ","m2",205,null,{"$f":"E21*F21","v":0},0,{"$f":"E21*H21","v":0},0,{"$f":"E21*J21","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ21=1,G21,0)","v":0},{"$f":"IF(AZ21=2,G21,0)","v":0},{"$f":"IF(AZ21=3,G21,0)","v":0},{"$f":"IF(AZ21=4,G21,0)","v":0},{"$f":"IF(AZ21=5,G21,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Křižovatka u ČOV:205,00",null,205,null,null,null,null,null,null,null,"Křižovatka u ČOV:205,00"]
[7,"938909611R00","Odstranění nánosu na krajnicích tl. do 10 cm ","m2",13.75,null,{"$f":"E23*F23","v":0},0,{"$f":"E23*H23","v":0},-0.126,{"$f":"E23*J23","v":-1.7324999999999999},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ23=1,G23,0)","v":0},{"$f":"IF(AZ23=2,G23,0)","v":0},{"$f":"IF(AZ23=3,G23,0)","v":0},{"$f":"IF(AZ23=4,G23,0)","v":0},{"$f":"IF(AZ23=5,G23,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Křižovatka u ČOV:55,00*0,25",null,13.75,null,null,null,null,null,null,null,"Křižovatka u ČOV:55,00*0,25"]
[null,"Celkem za","93 Dokončovací práce inženýrských staveb",null,null,null,{"$f":"SUM(G20:G24)","v":0},null,{"$f":"SUM(I20:I24)","v":0},null,{"$f":"SUM(K20:K24)","v":-1.7324999999999999},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA20:BA24)","v":0},{"$f":"SUM(BB20:BB24)","v":0},{"$f":"SUM(BC20:BC24)","v":0},{"$f":"SUM(BD20:BD24)","v":0},{"$f":"SUM(BE20:BE24)","v":0}]
["Díl:","99","Staveništní přesun hmot",null,null,null,null,null,null,null,null,null,null,null,1]
[8,"998225111R00","Přesun hmot, pozemní komunikace, kryt živičný ","t",50.626379999999997,null,{"$f":"E27*F27","v":0},0,{"$f":"E27*H27","v":0},null,{"$f":"E27*J27","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,7,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ27=1,G27,0)","v":0},{"$f":"IF(AZ27=2,G27,0)","v":0},{"$f":"IF(AZ27=3,G27,0)","v":0},{"$f":"IF(AZ27=4,G27,0)","v":0},{"$f":"IF(AZ27=5,G27,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1]
[null,"Celkem za","99 Staveništní přesun hmot",null,null,null,{"$f":"SUM(G26:G27)","v":0},null,{"$f":"SUM(I26:I27)","v":0},null,{"$f":"SUM(K26:K27)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA26:BA27)","v":0},{"$f":"SUM(BB26:BB27)","v":0},{"$f":"SUM(BC26:BC27)","v":0},{"$f":"SUM(BD26:BD27)","v":0},{"$f":"SUM(BE26:BE27)","v":0}]

{"sheet":"105 3326105.3 KL","index":13,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[22,0,22,1],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[50,1,50,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,1,44,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6]]}
["POLOŽKOVÝ ROZPOČET"]
["Rozpočet",null,"3326/105.3","Oprava MK \"Mašov-Mašovská u hřbitova\"-úsek do ČOV",null,"JKSO ","822.29"]
[]
["Objekt",null,null,null,null,"SKP "]
["105",null,"Oprava MK \"Mašov - Mašovská u hřbitova\"",null,null,"Měrná jednotka","m2"]
["Stavba",null,null,null,null,"Počet jednotek",0]
["3326",null,"Oprava místních komunikací Turnov",null,null,"Náklady na m.j.",{"$f":"IF(G6=0,,ROUND((F30+F32)/G6,1))","v":0}]
["Projektant",null,null,null,null,"Typ rozpočtu"]
["Zpracovatel projektu"]
["Objednatel",null,"Město TURNOV"]
["Dodavatel",null,".",null,null,"Zakázkové číslo "]
["Rozpočtoval",null,null,null,null,"Počet listů"]
["ROZPOČTOVÉ NÁKLADY"]
["Základní rozpočtové náklady",null,null,"Ostatní rozpočtové náklady"]
[null,"HSV celkem",{"$f":"'105 3326105.3 Rek'!E11","v":0},{"$f":"'105 3326105.3 Rek'!A16","v":"Zařízení staveniště"},null,null,{"$f":"'105 3326105.3 Rek'!I16","v":0}]
["Z","PSV celkem",{"$f":"'105 3326105.3 Rek'!F11","v":0},{"$f":"'105 3326105.3 Rek'!A17","v":"Kompletační činnost (IČD)"},null,null,{"$f":"'105 3326105.3 Rek'!I17","v":0}]
["R","M práce celkem",{"$f":"'105 3326105.3 Rek'!H11","v":0},{"$f":"'105 3326105.3 Rek'!A18","v":"Vytýčení stavby a podz. inženýrských sítí"},null,null,{"$f":"'105 3326105.3 Rek'!I18","v":0}]
["N","M dodávky celkem",{"$f":"'105 3326105.3 Rek'!G11","v":0},{"$f":"'105 3326105.3 Rek'!A19","v":"DIO"},null,null,{"$f":"'105 3326105.3 Rek'!I19","v":0}]
["ZRN celkem",null,{"$f":"SUM(C15:C18)","v":0}]
[]
["HZS",null,{"$f":"'105 3326105.3 Rek'!I11","v":0}]
["ZRN+HZS",null,{"$f":"C19+C21","v":0}]
["ZRN+ost.náklady+HZS",null,{"$f":"C22+G23","v":0},"Ostatní náklady celkem",null,null,{"$f":"'105 3326105.3 Rek'!H20","v":0}]
["Vypracoval",null,null,"Za zhotovitele",null,"Za objednatele"]
["Jméno :",null,null,"Jméno :",null,"Jméno :"]
["Datum :",null,null,"Datum :",null,"Datum :"]
[]
["Podpis :",null,null,"Podpis:",null,"Podpis:"]
[]
["Základ pro DPH",null,21,"%  ",null,{"$f":"C23-F32","v":0}]
["DPH",null,{"$f":"C30","v":21},"% ",null,{"$f":"ROUND(PRODUCT(F30,C31/100),0)","v":0}]
["Základ pro DPH",null,0,"% ",null,0]
["DPH",null,{"$f":"C32","v":0},"% ",null,{"$f":"ROUND(PRODUCT(F32,C33/100),0)","v":0}]
["CENA ZA OBJEKT CELKEM",null,null,null,null,{"$f":"ROUND(SUM(F30:F33),0)","v":0}]
[]
["Poznámka :",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"105 3326105.3 Rek","index":14,"n_rows":20,"n_cols":53,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[1,6,1,8],[19,7,19,8]]}
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,null,null,"Rozpočet :","3326/105.3"]
["Objekt :",null,"105 Oprava MK \"Mašov - Mašovská u hřbitova\"",null,null,null,"Oprava MK \"Mašov-Mašovská u hřbitova\"-úsek do ČOV"]
[]
["REKAPITULACE  STAVEBNÍCH  DÍLŮ"]
[]
[null,"Stavební díl",null,null,"HSV","PSV","Dodávka","Montáž","HZS"]
[{"$f":"'105 3326105.3 Pol'!B7","v":"5"},{"$f":"'105 3326105.3 Pol'!C7","v":"Komunikace"},null,null,{"$f":"'105 3326105.3 Pol'!BA16","v":0},{"$f":"'105 3326105.3 Pol'!BB16","v":0},{"$f":"'105 3326105.3 Pol'!BC16","v":0},{"$f":"'105 3326105.3 Pol'!BD16","v":0},{"$f":"'105 3326105.3 Pol'!BE16","v":0}]
[{"$f":"'105 3326105.3 Pol'!B17","v":"8"},{"$f":"'105 3326105.3 Pol'!C17","v":"Trubní vedení"},null,null,{"$f":"'105 3326105.3 Pol'!BA20","v":0},{"$f":"'105 3326105.3 Pol'!BB20","v":0},{"$f":"'105 3326105.3 Pol'!BC20","v":0},{"$f":"'105 3326105.3 Pol'!BD20","v":0},{"$f":"'105 3326105.3 Pol'!BE20","v":0}]
[{"$f":"'105 3326105.3 Pol'!B21","v":"93"},{"$f":"'105 3326105.3 Pol'!C21","v":"Dokončovací práce inženýrských staveb"},null,null,{"$f":"'105 3326105.3 Pol'!BA26","v":0},{"$f":"'105 3326105.3 Pol'!BB26","v":0},{"$f":"'105 3326105.3 Pol'!BC26","v":0},{"$f":"'105 3326105.3 Pol'!BD26","v":0},{"$f":"'105 3326105.3 Pol'!BE26","v":0}]
[{"$f":"'105 3326105.3 Pol'!B27","v":"99"},{"$f":"'105 3326105.3 Pol'!C27","v":"Staveništní přesun hmot"},null,null,{"$f":"'105 3326105.3 Pol'!BA29","v":0},{"$f":"'105 3326105.3 Pol'!BB29","v":0},{"$f":"'105 3326105.3 Pol'!BC29","v":0},{"$f":"'105 3326105.3 Pol'!BD29","v":0},{"$f":"'105 3326105.3 Pol'!BE29","v":0}]
[null,"CELKEM  OBJEKT",null,null,{"$f":"SUM(E7:E10)","v":0},{"$f":"SUM(F7:F10)","v":0},{"$f":"SUM(G7:G10)","v":0},{"$f":"SUM(H7:H10)","v":0},{"$f":"SUM(I7:I10)","v":0}]
[]
["VEDLEJŠÍ ROZPOČTOVÉ  NÁKLADY"]
[]
["Název VRN",null,null,null,"Kč",null,null,null,"Kč"]
["Zařízení staveniště",null,null,null,0,null,null,null,{"$f":"E16+F16*G16/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Kompletační činnost (IČD)",null,null,null,0,null,null,null,{"$f":"E17+F17*G17/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Vytýčení stavby a podz. inženýrských sítí",null,null,null,0,null,null,null,{"$f":"E18+F18*G18/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["DIO",null,null,null,0,null,null,null,{"$f":"E19+F19*G19/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"CELKEM VRN",null,null,null,null,null,{"$f":"SUM(I16:I19)","v":0}]

{"sheet":"105 3326105.3 Pol","index":15,"n_rows":29,"n_cols":80,"rows_kept":29,"cut":false,"hidden":false,"merged":[[22,2,22,3],[24,2,24,3],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,4,3,6],[8,2,8,3],[10,2,10,3],[12,2,12,3],[14,2,14,3]]}
["Položkový rozpočet "]
[]
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,"Rozpočet:",{"$f":"'105 3326105.3 Rek'!H1","v":"3326/105.3"}]
["Objekt :",null,"105 Oprava MK \"Mašov - Mašovská u hřbitova\"",null,{"$f":"'105 3326105.3 Rek'!G2","v":"Oprava MK \"Mašov-Mašovská u hřbitova\"-úsek do ČOV"}]
[]
["P.č.","Číslo položky","Název položky","MJ","množství","cena / MJ","celkem (Kč)","Jednotková hmotnost","Celková hmotnost","Jednotková dem.hmot.","Celková dem.hmot."]
["Díl:","5","Komunikace",null,null,null,null,null,null,null,null,null,null,null,1]
[1,"569831111R00","Zpevnění krajnic štěrkodrtí tloušťky  10 cm ","m2",16.25,null,{"$f":"E8*F8","v":0},0.18776000000000001,{"$f":"E8*H8","v":3.0511000000000004},0,{"$f":"E8*J8","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ8=1,G8,0)","v":0},{"$f":"IF(AZ8=2,G8,0)","v":0},{"$f":"IF(AZ8=3,G8,0)","v":0},{"$f":"IF(AZ8=4,G8,0)","v":0},{"$f":"IF(AZ8=5,G8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace od ČOV:65,00*0,25",null,16.25,null,null,null,null,null,null,null,"Komunikace od ČOV:65,00*0,25"]
[2,"572713112R00","Vyrovnání povrchu krytů kamen. obaleným asfaltem ","t",28.875,null,{"$f":"E10*F10","v":0},1,{"$f":"E10*H10","v":28.875},0,{"$f":"E10*J10","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ10=1,G10,0)","v":0},{"$f":"IF(AZ10=2,G10,0)","v":0},{"$f":"IF(AZ10=3,G10,0)","v":0},{"$f":"IF(AZ10=4,G10,0)","v":0},{"$f":"IF(AZ10=5,G10,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace od ČOV:210,00*0,11/2*2,5",null,28.875,null,null,null,null,null,null,null,"Komunikace od ČOV:210,00*0,11/2*2,5"]
[3,"573231126R00","Postřik spojovací z KAE množství zbytkového asfaltu 0,6 kg/m2","m2",210,null,{"$f":"E12*F12","v":0},5.0000000000000001E-4,{"$f":"E12*H12","v":0.105},0,{"$f":"E12*J12","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ12=1,G12,0)","v":0},{"$f":"IF(AZ12=2,G12,0)","v":0},{"$f":"IF(AZ12=3,G12,0)","v":0},{"$f":"IF(AZ12=4,G12,0)","v":0},{"$f":"IF(AZ12=5,G12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace od ČOV:210,00",null,210,null,null,null,null,null,null,null,"Komunikace od ČOV:210,00"]
[4,"577142112RT2","Beton asfaltový ACO 11+, ACO 16+, nad 3 m, tl.5 cm plochy 201-1000 m2","m2",210,null,{"$f":"E14*F14","v":0},0.12966,{"$f":"E14*H14","v":27.2286},0,{"$f":"E14*J14","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ14=1,G14,0)","v":0},{"$f":"IF(AZ14=2,G14,0)","v":0},{"$f":"IF(AZ14=3,G14,0)","v":0},{"$f":"IF(AZ14=4,G14,0)","v":0},{"$f":"IF(AZ14=5,G14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace od ČOV:210,00",null,210,null,null,null,null,null,null,null,"Komunikace od ČOV:210,00"]
[null,"Celkem za","5 Komunikace",null,null,null,{"$f":"SUM(G7:G15)","v":0},null,{"$f":"SUM(I7:I15)","v":59.259700000000002},null,{"$f":"SUM(K7:K15)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA7:BA15)","v":0},{"$f":"SUM(BB7:BB15)","v":0},{"$f":"SUM(BC7:BC15)","v":0},{"$f":"SUM(BD7:BD15)","v":0},{"$f":"SUM(BE7:BE15)","v":0}]
["Díl:","8","Trubní vedení",null,null,null,null,null,null,null,null,null,null,null,1]
[5,"899331111R00","Výšková úprava vstupu do 20 cm, zvýšení poklopu ","kus",2,null,{"$f":"E18*F18","v":0},0.43093999999999999,{"$f":"E18*H18","v":0.86187999999999998},0,{"$f":"E18*J18","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ18=1,G18,0)","v":0},{"$f":"IF(AZ18=2,G18,0)","v":0},{"$f":"IF(AZ18=3,G18,0)","v":0},{"$f":"IF(AZ18=4,G18,0)","v":0},{"$f":"IF(AZ18=5,G18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[6,"899431111R00","Výšková úprava do 20 cm, zvýšení krytu šoupěte ","kus",4,null,{"$f":"E19*F19","v":0},0.31590000000000001,{"$f":"E19*H19","v":1.2636000000000001},0,{"$f":"E19*J19","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ19=1,G19,0)","v":0},{"$f":"IF(AZ19=2,G19,0)","v":0},{"$f":"IF(AZ19=3,G19,0)","v":0},{"$f":"IF(AZ19=4,G19,0)","v":0},{"$f":"IF(AZ19=5,G19,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,"Celkem za","8 Trubní vedení",null,null,null,{"$f":"SUM(G17:G19)","v":0},null,{"$f":"SUM(I17:I19)","v":2.12548},null,{"$f":"SUM(K17:K19)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA17:BA19)","v":0},{"$f":"SUM(BB17:BB19)","v":0},{"$f":"SUM(BC17:BC19)","v":0},{"$f":"SUM(BD17:BD19)","v":0},{"$f":"SUM(BE17:BE19)","v":0}]
["Díl:","93","Dokončovací práce inženýrských staveb",null,null,null,null,null,null,null,null,null,null,null,1]
[7,"938909311R00","Odstranění nánosu z povrchu živičného nebo beton. ","m2",210,null,{"$f":"E22*F22","v":0},0,{"$f":"E22*H22","v":0},0,{"$f":"E22*J22","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ22=1,G22,0)","v":0},{"$f":"IF(AZ22=2,G22,0)","v":0},{"$f":"IF(AZ22=3,G22,0)","v":0},{"$f":"IF(AZ22=4,G22,0)","v":0},{"$f":"IF(AZ22=5,G22,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace od ČOV:210,00",null,210,null,null,null,null,null,null,null,"Komunikace od ČOV:210,00"]
[8,"938909611R00","Odstranění nánosu na krajnicích tl. do 10 cm ","m2",16.25,null,{"$f":"E24*F24","v":0},0,{"$f":"E24*H24","v":0},-0.126,{"$f":"E24*J24","v":-2.0474999999999999},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ24=1,G24,0)","v":0},{"$f":"IF(AZ24=2,G24,0)","v":0},{"$f":"IF(AZ24=3,G24,0)","v":0},{"$f":"IF(AZ24=4,G24,0)","v":0},{"$f":"IF(AZ24=5,G24,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Komunikace od ČOV:65,00*0,25",null,16.25,null,null,null,null,null,null,null,"Komunikace od ČOV:65,00*0,25"]
[null,"Celkem za","93 Dokončovací práce inženýrských staveb",null,null,null,{"$f":"SUM(G21:G25)","v":0},null,{"$f":"SUM(I21:I25)","v":0},null,{"$f":"SUM(K21:K25)","v":-2.0474999999999999},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA21:BA25)","v":0},{"$f":"SUM(BB21:BB25)","v":0},{"$f":"SUM(BC21:BC25)","v":0},{"$f":"SUM(BD21:BD25)","v":0},{"$f":"SUM(BE21:BE25)","v":0}]
["Díl:","99","Staveništní přesun hmot",null,null,null,null,null,null,null,null,null,null,null,1]
[9,"998225111R00","Přesun hmot, pozemní komunikace, kryt živičný ","t",61.385179999999998,null,{"$f":"E28*F28","v":0},0,{"$f":"E28*H28","v":0},null,{"$f":"E28*J28","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,7,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ28=1,G28,0)","v":0},{"$f":"IF(AZ28=2,G28,0)","v":0},{"$f":"IF(AZ28=3,G28,0)","v":0},{"$f":"IF(AZ28=4,G28,0)","v":0},{"$f":"IF(AZ28=5,G28,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1]
[null,"Celkem za","99 Staveništní přesun hmot",null,null,null,{"$f":"SUM(G27:G28)","v":0},null,{"$f":"SUM(I27:I28)","v":0},null,{"$f":"SUM(K27:K28)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA27:BA28)","v":0},{"$f":"SUM(BB27:BB28)","v":0},{"$f":"SUM(BC27:BC28)","v":0},{"$f":"SUM(BD27:BD28)","v":0},{"$f":"SUM(BE27:BE28)","v":0}]

{"sheet":"106 3326106 KL","index":16,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[22,0,22,1],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[50,1,50,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,1,44,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6]]}
["POLOŽKOVÝ ROZPOČET"]
["Rozpočet",null,"3326/106","Oprava ZP na ppč. 130/1 a 141/2 v kú. Turnov",null,"JKSO ","822.52"]
[]
["Objekt",null,null,null,null,"SKP "]
["106",null,"Oprava ZP na ppč. 130/1 a 141/2 v kú. Turnov",null,null,"Měrná jednotka","m2"]
["Stavba",null,null,null,null,"Počet jednotek",0]
["3326",null,"Oprava místních komunikací Turnov",null,null,"Náklady na m.j.",{"$f":"IF(G6=0,,ROUND((F30+F32)/G6,1))","v":0}]
["Projektant",null,null,null,null,"Typ rozpočtu"]
["Zpracovatel projektu"]
["Objednatel",null,"Město TURNOV"]
["Dodavatel",null,".",null,null,"Zakázkové číslo "]
["Rozpočtoval",null,null,null,null,"Počet listů"]
["ROZPOČTOVÉ NÁKLADY"]
["Základní rozpočtové náklady",null,null,"Ostatní rozpočtové náklady"]
[null,"HSV celkem",{"$f":"'106 3326106 Rek'!E12","v":0},{"$f":"'106 3326106 Rek'!A17","v":"Zařízení staveniště"},null,null,{"$f":"'106 3326106 Rek'!I17","v":0}]
["Z","PSV celkem",{"$f":"'106 3326106 Rek'!F12","v":0},{"$f":"'106 3326106 Rek'!A18","v":"Provoz investora"},null,null,{"$f":"'106 3326106 Rek'!I18","v":0}]
["R","M práce celkem",{"$f":"'106 3326106 Rek'!H12","v":0},{"$f":"'106 3326106 Rek'!A19","v":"Kompletační činnost (IČD)"},null,null,{"$f":"'106 3326106 Rek'!I19","v":0}]
["N","M dodávky celkem",{"$f":"'106 3326106 Rek'!G12","v":0},{"$f":"'106 3326106 Rek'!A20","v":"Vytýčení stavby a podz. inženýrských sítí"},null,null,{"$f":"'106 3326106 Rek'!I20","v":0}]
["ZRN celkem",null,{"$f":"SUM(C15:C18)","v":0},{"$f":"'106 3326106 Rek'!A21","v":"DIO"},null,null,{"$f":"'106 3326106 Rek'!I21","v":0}]
[]
["HZS",null,{"$f":"'106 3326106 Rek'!I12","v":0}]
["ZRN+HZS",null,{"$f":"C19+C21","v":0}]
["ZRN+ost.náklady+HZS",null,{"$f":"C22+G23","v":0},"Ostatní náklady celkem",null,null,{"$f":"'106 3326106 Rek'!H22","v":0}]
["Vypracoval",null,null,"Za zhotovitele",null,"Za objednatele"]
["Jméno :",null,null,"Jméno :",null,"Jméno :"]
["Datum :",null,null,"Datum :",null,"Datum :"]
[]
["Podpis :",null,null,"Podpis:",null,"Podpis:"]
[]
["Základ pro DPH",null,21,"%  ",null,{"$f":"C23-F32","v":0}]
["DPH",null,{"$f":"C30","v":21},"% ",null,{"$f":"ROUND(PRODUCT(F30,C31/100),0)","v":0}]
["Základ pro DPH",null,0,"% ",null,0]
["DPH",null,{"$f":"C32","v":0},"% ",null,{"$f":"ROUND(PRODUCT(F32,C33/100),0)","v":0}]
["CENA ZA OBJEKT CELKEM",null,null,null,null,{"$f":"ROUND(SUM(F30:F33),0)","v":0}]
[]
["Poznámka :",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"106 3326106 Rek","index":17,"n_rows":22,"n_cols":53,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[1,6,1,8],[21,7,21,8]]}
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,null,null,"Rozpočet :","3326/106"]
["Objekt :",null,"106 Oprava ZP na ppč. 130/1 a 141/2 v kú. Turnov",null,null,null,"Oprava ZP na ppč. 130/1 a 141/2 v kú. Turnov"]
[]
["REKAPITULACE  STAVEBNÍCH  DÍLŮ"]
[]
[null,"Stavební díl",null,null,"HSV","PSV","Dodávka","Montáž","HZS"]
[{"$f":"'106 3326106 Pol'!B7","v":"1"},{"$f":"'106 3326106 Pol'!C7","v":"Zemní práce"},null,null,{"$f":"'106 3326106 Pol'!BA20","v":0},{"$f":"'106 3326106 Pol'!BB20","v":0},{"$f":"'106 3326106 Pol'!BC20","v":0},{"$f":"'106 3326106 Pol'!BD20","v":0},{"$f":"'106 3326106 Pol'!BE20","v":0}]
[{"$f":"'106 3326106 Pol'!B21","v":"5"},{"$f":"'106 3326106 Pol'!C21","v":"Komunikace"},null,null,{"$f":"'106 3326106 Pol'!BA38","v":0},{"$f":"'106 3326106 Pol'!BB38","v":0},{"$f":"'106 3326106 Pol'!BC38","v":0},{"$f":"'106 3326106 Pol'!BD38","v":0},{"$f":"'106 3326106 Pol'!BE38","v":0}]
[{"$f":"'106 3326106 Pol'!B39","v":"91"},{"$f":"'106 3326106 Pol'!C39","v":"Doplňující práce na komunikaci"},null,null,{"$f":"'106 3326106 Pol'!BA46","v":0},{"$f":"'106 3326106 Pol'!BB46","v":0},{"$f":"'106 3326106 Pol'!BC46","v":0},{"$f":"'106 3326106 Pol'!BD46","v":0},{"$f":"'106 3326106 Pol'!BE46","v":0}]
[{"$f":"'106 3326106 Pol'!B47","v":"93"},{"$f":"'106 3326106 Pol'!C47","v":"Dokončovací práce inženýrských staveb"},null,null,{"$f":"'106 3326106 Pol'!BA51","v":0},{"$f":"'106 3326106 Pol'!BB51","v":0},{"$f":"'106 3326106 Pol'!BC51","v":0},{"$f":"'106 3326106 Pol'!BD51","v":0},{"$f":"'106 3326106 Pol'!BE51","v":0}]
[{"$f":"'106 3326106 Pol'!B52","v":"99"},{"$f":"'106 3326106 Pol'!C52","v":"Staveništní přesun hmot"},null,null,{"$f":"'106 3326106 Pol'!BA54","v":0},{"$f":"'106 3326106 Pol'!BB54","v":0},{"$f":"'106 3326106 Pol'!BC54","v":0},{"$f":"'106 3326106 Pol'!BD54","v":0},{"$f":"'106 3326106 Pol'!BE54","v":0}]
[null,"CELKEM  OBJEKT",null,null,{"$f":"SUM(E7:E11)","v":0},{"$f":"SUM(F7:F11)","v":0},{"$f":"SUM(G7:G11)","v":0},{"$f":"SUM(H7:H11)","v":0},{"$f":"SUM(I7:I11)","v":0}]
[]
["VEDLEJŠÍ ROZPOČTOVÉ  NÁKLADY"]
[]
["Název VRN",null,null,null,"Kč",null,null,null,"Kč"]
["Zařízení staveniště",null,null,null,0,null,null,null,{"$f":"E17+F17*G17/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Provoz investora",null,null,null,0,null,null,null,{"$f":"E18+F18*G18/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Kompletační činnost (IČD)",null,null,null,0,null,null,null,{"$f":"E19+F19*G19/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Vytýčení stavby a podz. inženýrských sítí",null,null,null,0,null,null,null,{"$f":"E20+F20*G20/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["DIO",null,null,null,0,null,null,null,{"$f":"E21+F21*G21/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"CELKEM VRN",null,null,null,null,null,{"$f":"SUM(I17:I21)","v":0}]

{"sheet":"106 3326106 Pol","index":18,"n_rows":54,"n_cols":80,"rows_kept":54,"cut":false,"hidden":false,"merged":[[10,2,10,6],[11,2,11,3],[12,2,12,3],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,4,3,6],[8,2,8,3],[36,2,36,3],[14,2,14,6],[15,2,15,3],[16,2,16,3],[22,2,22,6],[23,2,23,3],[24,2,24,3],[25,2,25,3],[27,2,27,3],[28,2,28,3],[30,2,30,3],[31,2,31,3],[33,2,33,3],[34,2,34,3],[48,2,48,3],[49,2,49,3],[40,2,40,3],[41,2,41,3],[43,2,43,3],[44,2,44,3]]}
["Položkový rozpočet "]
[]
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,"Rozpočet:",{"$f":"'106 3326106 Rek'!H1","v":"3326/106"}]
["Objekt :",null,"106 Oprava ZP na ppč. 130/1 a 141/2 v kú. Turnov",null,{"$f":"'106 3326106 Rek'!G2","v":"Oprava ZP na ppč. 130/1 a 141/2 v kú. Turnov"}]
[]
["P.č.","Číslo položky","Název položky","MJ","množství","cena / MJ","celkem (Kč)","Jednotková hmotnost","Celková hmotnost","Jednotková dem.hmot.","Celková dem.hmot."]
["Díl:","1","Zemní práce",null,null,null,null,null,null,null,null,null,null,null,1]
[1,"113106121R00","Rozebrání dlažeb z betonových dlaždic na sucho pro opětovné použití","m2",52,null,{"$f":"E8*F8","v":0},0.13800000000000001,{"$f":"E8*H8","v":7.1760000000000002},-0.13800000000000001,{"$f":"E8*J8","v":-7.1760000000000002},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ8=1,G8,0)","v":0},{"$f":"IF(AZ8=2,G8,0)","v":0},{"$f":"IF(AZ8=3,G8,0)","v":0},{"$f":"IF(AZ8=4,G8,0)","v":0},{"$f":"IF(AZ8=5,G8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Okapový chodník u objektu:52,00*1,00",null,52,null,null,null,null,null,null,null,"Okapový chodník u objektu:52,00*1,00"]
[2,"113107515R00","Odstranění podkladu pl. 50 m2,kam.drcené tl.15 cm ","m2",18.45,null,{"$f":"E10*F10","v":0},0,{"$f":"E10*H10","v":0},-0.33,{"$f":"E10*J10","v":-6.0884999999999998},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ10=1,G10,0)","v":0},{"$f":"IF(AZ10=2,G10,0)","v":0},{"$f":"IF(AZ10=3,G10,0)","v":0},{"$f":"IF(AZ10=4,G10,0)","v":0},{"$f":"IF(AZ10=5,G10,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Průměrná hloubka",null,null,null,null,null,null,null,null,"Průměrná hloubka",null,null,3]
[null,null,"Podél okapového chodníku:52,00*0,30",null,15.6,null,null,null,null,null,null,null,"Podél okapového chodníku:52,00*0,30"]
[null,null,"Na konci parkovací plochy:9,50*0,30",null,2.85,null,null,null,null,null,null,null,"Na konci parkovací plochy:9,50*0,30"]
[3,"113107610R00","Odstranění podkladu nad 50 m2,kam.drcené tl.10 cm ","m2",137.5,null,{"$f":"E14*F14","v":0},0,{"$f":"E14*H14","v":0},-0.22,{"$f":"E14*J14","v":-30.25},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ14=1,G14,0)","v":0},{"$f":"IF(AZ14=2,G14,0)","v":0},{"$f":"IF(AZ14=3,G14,0)","v":0},{"$f":"IF(AZ14=4,G14,0)","v":0},{"$f":"IF(AZ14=5,G14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Průměrná tloušťka",null,null,null,null,null,null,null,null,"Průměrná tloušťka",null,null,3]
[null,null,"Plocha části podél trafostanice:15,00*3,00*0,5",null,22.5,null,null,null,null,null,null,null,"Plocha části podél trafostanice:15,00*3,00*0,5"]
[null,null,"Plocha části parkoviště:23,00*5,00",null,115,null,null,null,null,null,null,null,"Plocha části parkoviště:23,00*5,00"]
[4,"979082113RSZ","Vodorovná doprava suti po suchu na skládku zhotovitele","t",36.338500000000003,null,{"$f":"E18*F18","v":0},0,{"$f":"E18*H18","v":0},0,{"$f":"E18*J18","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ18=1,G18,0)","v":0},{"$f":"IF(AZ18=2,G18,0)","v":0},{"$f":"IF(AZ18=3,G18,0)","v":0},{"$f":"IF(AZ18=4,G18,0)","v":0},{"$f":"IF(AZ18=5,G18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[5,"979089001R00","Poplatek za  uložení odpadního štěrku a kameniva skupina odpadu 010408","t",36.338500000000003,null,{"$f":"E19*F19","v":0},0,{"$f":"E19*H19","v":0},0,{"$f":"E19*J19","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ19=1,G19,0)","v":0},{"$f":"IF(AZ19=2,G19,0)","v":0},{"$f":"IF(AZ19=3,G19,0)","v":0},{"$f":"IF(AZ19=4,G19,0)","v":0},{"$f":"IF(AZ19=5,G19,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,"Celkem za","1 Zemní práce",null,null,null,{"$f":"SUM(G7:G19)","v":0},null,{"$f":"SUM(I7:I19)","v":7.1760000000000002},null,{"$f":"SUM(K7:K19)","v":-43.514499999999998},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA7:BA19)","v":0},{"$f":"SUM(BB7:BB19)","v":0},{"$f":"SUM(BC7:BC19)","v":0},{"$f":"SUM(BD7:BD19)","v":0},{"$f":"SUM(BE7:BE19)","v":0}]
["Díl:","5","Komunikace",null,null,null,null,null,null,null,null,null,null,null,1]
[6,"566501111R00","Úprava krytu kamenivem drceným do 0,10 m3/m2 ","m2",237,null,{"$f":"E22*F22","v":0},0.17726,{"$f":"E22*H22","v":42.010620000000003},0,{"$f":"E22*J22","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ22=1,G22,0)","v":0},{"$f":"IF(AZ22=2,G22,0)","v":0},{"$f":"IF(AZ22=3,G22,0)","v":0},{"$f":"IF(AZ22=4,G22,0)","v":0},{"$f":"IF(AZ22=5,G22,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Průměrná tloušťka",null,null,null,null,null,null,null,null,"Průměrná tloušťka",null,null,3]
[null,null,"Okapový chodník u objektu (tl. 0 - 20 cm):52,00*1,00",null,52,null,null,null,null,null,null,null,"Okapový chodník u objektu (tl. 0 - 20 cm):52,00*1,00"]
[null,null,"Plocha podél trafostanice:15,00*3,00",null,45,null,null,null,null,null,null,null,"Plocha podél trafostanice:15,00*3,00"]
[null,null,"Plocha části parkoviště (tl. 0 - 20 cm):28,00*5,00",null,140,null,null,null,null,null,null,null,"Plocha části parkoviště (tl. 0 - 20 cm):28,00*5,00"]
[7,"569831111R00","Zpevnění krajnic štěrkodrtí tloušťky  10 cm ","m2",38.5,null,{"$f":"E27*F27","v":0},0.18776000000000001,{"$f":"E27*H27","v":7.2287600000000003},0,{"$f":"E27*J27","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ27=1,G27,0)","v":0},{"$f":"IF(AZ27=2,G27,0)","v":0},{"$f":"IF(AZ27=3,G27,0)","v":0},{"$f":"IF(AZ27=4,G27,0)","v":0},{"$f":"IF(AZ27=5,G27,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha podél trafostanice:15,00*0,25*2",null,7.5,null,null,null,null,null,null,null,"Plocha podél trafostanice:15,00*0,25*2"]
[null,null,"Plocha části parkoviště:31,00*1,00",null,31,null,null,null,null,null,null,null,"Plocha části parkoviště:31,00*1,00"]
[8,"573111111R00","Postřik živičný infiltr.+ posyp, asfalt. 0,60kg/m2 ","m2",200,null,{"$f":"E30*F30","v":0},5.6100000000000004E-3,{"$f":"E30*H30","v":1.1220000000000001},0,{"$f":"E30*J30","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ30=1,G30,0)","v":0},{"$f":"IF(AZ30=2,G30,0)","v":0},{"$f":"IF(AZ30=3,G30,0)","v":0},{"$f":"IF(AZ30=4,G30,0)","v":0},{"$f":"IF(AZ30=5,G30,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha podél trafostanice:15,00*3,00",null,45,null,null,null,null,null,null,null,"Plocha podél trafostanice:15,00*3,00"]
[null,null,"Plocha části parkoviště:31,00*5,00",null,155,null,null,null,null,null,null,null,"Plocha části parkoviště:31,00*5,00"]
[9,"577162214RT3","Beton asfaltový ACO 16 obrusný, š.nad 3 m, tl.7 cm plochy 101-200 m2","m2",200,null,{"$f":"E33*F33","v":0},0.17871999999999999,{"$f":"E33*H33","v":35.744},0,{"$f":"E33*J33","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ33=1,G33,0)","v":0},{"$f":"IF(AZ33=2,G33,0)","v":0},{"$f":"IF(AZ33=3,G33,0)","v":0},{"$f":"IF(AZ33=4,G33,0)","v":0},{"$f":"IF(AZ33=5,G33,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha podél trafostanice:15,00*3,00",null,45,null,null,null,null,null,null,null,"Plocha podél trafostanice:15,00*3,00"]
[null,null,"Plocha části parkoviště:31,00*5,00",null,155,null,null,null,null,null,null,null,"Plocha části parkoviště:31,00*5,00"]
[10,"596811111R00","Kladení dlaždic kom.pro pěší, lože z kameniva těž. Původní betonová dlažba 50x50 cm","m2",52,null,{"$f":"E36*F36","v":0},0.20200000000000001,{"$f":"E36*H36","v":10.504000000000001},0,{"$f":"E36*J36","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ36=1,G36,0)","v":0},{"$f":"IF(AZ36=2,G36,0)","v":0},{"$f":"IF(AZ36=3,G36,0)","v":0},{"$f":"IF(AZ36=4,G36,0)","v":0},{"$f":"IF(AZ36=5,G36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Okapový chodník u objektu:52,00*1,00",null,52,null,null,null,null,null,null,null,"Okapový chodník u objektu:52,00*1,00"]
[null,"Celkem za","5 Komunikace",null,null,null,{"$f":"SUM(G21:G37)","v":0},null,{"$f":"SUM(I21:I37)","v":96.609380000000002},null,{"$f":"SUM(K21:K37)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA21:BA37)","v":0},{"$f":"SUM(BB21:BB37)","v":0},{"$f":"SUM(BC21:BC37)","v":0},{"$f":"SUM(BD21:BD37)","v":0},{"$f":"SUM(BE21:BE37)","v":0}]
["Díl:","91","Doplňující práce na komunikaci",null,null,null,null,null,null,null,null,null,null,null,1]
[11,"917862111RT5","Osazení stojat. obrub.bet. s opěrou,lože z C 12/15 včetně obrubníku ABO 100/10/25","m",61.5,null,{"$f":"E40*F40","v":0},0.22133,{"$f":"E40*H40","v":13.611795000000001},0,{"$f":"E40*J40","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ40=1,G40,0)","v":0},{"$f":"IF(AZ40=2,G40,0)","v":0},{"$f":"IF(AZ40=3,G40,0)","v":0},{"$f":"IF(AZ40=4,G40,0)","v":0},{"$f":"IF(AZ40=5,G40,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Podél okapového chodníku:52,00",null,52,null,null,null,null,null,null,null,"Podél okapového chodníku:52,00"]
[null,null,"Na konci parkovací plochy:9,50",null,9.5,null,null,null,null,null,null,null,"Na konci parkovací plochy:9,50"]
[12,"918101111R00","Lože pod obrubníky nebo obruby dlažeb z C 12/15 ","m3",1.845,null,{"$f":"E43*F43","v":0},2.5249999999999999,{"$f":"E43*H43","v":4.6586249999999998},0,{"$f":"E43*J43","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ43=1,G43,0)","v":0},{"$f":"IF(AZ43=2,G43,0)","v":0},{"$f":"IF(AZ43=3,G43,0)","v":0},{"$f":"IF(AZ43=4,G43,0)","v":0},{"$f":"IF(AZ43=5,G43,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Podél okapového chodníku:52,00*0,30*0,10",null,1.56,null,null,null,null,null,null,null,"Podél okapového chodníku:52,00*0,30*0,10"]
[null,null,"Na konci parkovací plochy:9,50*0,30*0,10",null,0.28499999999999998,null,null,null,null,null,null,null,"Na konci parkovací plochy:9,50*0,30*0,10"]
[null,"Celkem za","91 Doplňující práce na komunikaci",null,null,null,{"$f":"SUM(G39:G45)","v":0},null,{"$f":"SUM(I39:I45)","v":18.270420000000001},null,{"$f":"SUM(K39:K45)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA39:BA45)","v":0},{"$f":"SUM(BB39:BB45)","v":0},{"$f":"SUM(BC39:BC45)","v":0},{"$f":"SUM(BD39:BD45)","v":0},{"$f":"SUM(BE39:BE45)","v":0}]
["Díl:","93","Dokončovací práce inženýrských staveb",null,null,null,null,null,null,null,null,null,null,null,1]
[13,"938909111R00","Odstranění nánosu s povrchu podkladu štěrkového ","m2",200,null,{"$f":"E48*F48","v":0},0,{"$f":"E48*H48","v":0},0,{"$f":"E48*J48","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ48=1,G48,0)","v":0},{"$f":"IF(AZ48=2,G48,0)","v":0},{"$f":"IF(AZ48=3,G48,0)","v":0},{"$f":"IF(AZ48=4,G48,0)","v":0},{"$f":"IF(AZ48=5,G48,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha podél trafostanice:15,00*3,00",null,45,null,null,null,null,null,null,null,"Plocha podél trafostanice:15,00*3,00"]
[null,null,"Plocha části parkoviště:31,00*5,00",null,155,null,null,null,null,null,null,null,"Plocha části parkoviště:31,00*5,00"]
[null,"Celkem za","93 Dokončovací práce inženýrských staveb",null,null,null,{"$f":"SUM(G47:G50)","v":0},null,{"$f":"SUM(I47:I50)","v":0},null,{"$f":"SUM(K47:K50)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA47:BA50)","v":0},{"$f":"SUM(BB47:BB50)","v":0},{"$f":"SUM(BC47:BC50)","v":0},{"$f":"SUM(BD47:BD50)","v":0},{"$f":"SUM(BE47:BE50)","v":0}]
["Díl:","99","Staveništní přesun hmot",null,null,null,null,null,null,null,null,null,null,null,1]
[14,"998225111R00","Přesun hmot, pozemní komunikace, kryt živičný ","t",122.0558,null,{"$f":"E53*F53","v":0},0,{"$f":"E53*H53","v":0},null,{"$f":"E53*J53","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,7,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ53=1,G53,0)","v":0},{"$f":"IF(AZ53=2,G53,0)","v":0},{"$f":"IF(AZ53=3,G53,0)","v":0},{"$f":"IF(AZ53=4,G53,0)","v":0},{"$f":"IF(AZ53=5,G53,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1]
[null,"Celkem za","99 Staveništní přesun hmot",null,null,null,{"$f":"SUM(G52:G53)","v":0},null,{"$f":"SUM(I52:I53)","v":0},null,{"$f":"SUM(K52:K53)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA52:BA53)","v":0},{"$f":"SUM(BB52:BB53)","v":0},{"$f":"SUM(BC52:BC53)","v":0},{"$f":"SUM(BD52:BD53)","v":0},{"$f":"SUM(BE52:BE53)","v":0}]

{"sheet":"107 3326107 KL","index":19,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[22,0,22,1],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[50,1,50,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,1,44,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6]]}
["POLOŽKOVÝ ROZPOČET"]
["Rozpočet",null,"3326/107","Vesecko - Rozšíření pruhu zpevněné plochy -3,0 m",null,"JKSO ","822.52"]
[]
["Objekt",null,null,null,null,"SKP "]
["107",null,"Vesecko - Rozšíření zpevněné plochy",null,null,"Měrná jednotka","m2"]
["Stavba",null,null,null,null,"Počet jednotek",0]
["3326",null,"Oprava místních komunikací Turnov",null,null,"Náklady na m.j.",{"$f":"IF(G6=0,,ROUND((F30+F32)/G6,1))","v":0}]
["Projektant",null,null,null,null,"Typ rozpočtu"]
["Zpracovatel projektu"]
["Objednatel",null,"Město TURNOV"]
["Dodavatel",null,".",null,null,"Zakázkové číslo "]
["Rozpočtoval",null,null,null,null,"Počet listů"]
["ROZPOČTOVÉ NÁKLADY"]
["Základní rozpočtové náklady",null,null,"Ostatní rozpočtové náklady"]
[null,"HSV celkem",{"$f":"'107 3326107 Rek'!E12","v":0},{"$f":"'107 3326107 Rek'!A17","v":"Zařízení staveniště"},null,null,{"$f":"'107 3326107 Rek'!I17","v":0}]
["Z","PSV celkem",{"$f":"'107 3326107 Rek'!F12","v":0},{"$f":"'107 3326107 Rek'!A18","v":"Provoz investora"},null,null,{"$f":"'107 3326107 Rek'!I18","v":0}]
["R","M práce celkem",{"$f":"'107 3326107 Rek'!H12","v":0},{"$f":"'107 3326107 Rek'!A19","v":"Kompletační činnost (IČD)"},null,null,{"$f":"'107 3326107 Rek'!I19","v":0}]
["N","M dodávky celkem",{"$f":"'107 3326107 Rek'!G12","v":0},{"$f":"'107 3326107 Rek'!A20","v":"DIO"},null,null,{"$f":"'107 3326107 Rek'!I20","v":0}]
["ZRN celkem",null,{"$f":"SUM(C15:C18)","v":0}]
[]
["HZS",null,{"$f":"'107 3326107 Rek'!I12","v":0}]
["ZRN+HZS",null,{"$f":"C19+C21","v":0}]
["ZRN+ost.náklady+HZS",null,{"$f":"C22+G23","v":0},"Ostatní náklady celkem",null,null,{"$f":"'107 3326107 Rek'!H21","v":0}]
["Vypracoval",null,null,"Za zhotovitele",null,"Za objednatele"]
["Jméno :",null,null,"Jméno :",null,"Jméno :"]
["Datum :",null,null,"Datum :",null,"Datum :"]
[]
["Podpis :",null,null,"Podpis:",null,"Podpis:"]
[]
["Základ pro DPH",null,21,"%  ",null,{"$f":"C23-F32","v":0}]
["DPH",null,{"$f":"C30","v":21},"% ",null,{"$f":"ROUND(PRODUCT(F30,C31/100),0)","v":0}]
["Základ pro DPH",null,0,"% ",null,0]
["DPH",null,{"$f":"C32","v":0},"% ",null,{"$f":"ROUND(PRODUCT(F32,C33/100),0)","v":0}]
["CENA ZA OBJEKT CELKEM",null,null,null,null,{"$f":"ROUND(SUM(F30:F33),0)","v":0}]
[]
["Poznámka :",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"107 3326107 Rek","index":20,"n_rows":21,"n_cols":53,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[1,6,1,8],[20,7,20,8]]}
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,null,null,"Rozpočet :","3326/107"]
["Objekt :",null,"107 Vesecko - Rozšíření zpevněné plochy",null,null,null,"Vesecko - Rozšíření pruhu zpevněné plochy -3,0 m"]
[]
["REKAPITULACE  STAVEBNÍCH  DÍLŮ"]
[]
[null,"Stavební díl",null,null,"HSV","PSV","Dodávka","Montáž","HZS"]
[{"$f":"'107 3326107 Pol'!B7","v":"1"},{"$f":"'107 3326107 Pol'!C7","v":"Zemní práce"},null,null,{"$f":"'107 3326107 Pol'!BA13","v":0},{"$f":"'107 3326107 Pol'!BB13","v":0},{"$f":"'107 3326107 Pol'!BC13","v":0},{"$f":"'107 3326107 Pol'!BD13","v":0},{"$f":"'107 3326107 Pol'!BE13","v":0}]
[{"$f":"'107 3326107 Pol'!B14","v":"5"},{"$f":"'107 3326107 Pol'!C14","v":"Komunikace"},null,null,{"$f":"'107 3326107 Pol'!BA21","v":0},{"$f":"'107 3326107 Pol'!BB21","v":0},{"$f":"'107 3326107 Pol'!BC21","v":0},{"$f":"'107 3326107 Pol'!BD21","v":0},{"$f":"'107 3326107 Pol'!BE21","v":0}]
[{"$f":"'107 3326107 Pol'!B22","v":"91"},{"$f":"'107 3326107 Pol'!C22","v":"Doplňující práce na komunikaci"},null,null,{"$f":"'107 3326107 Pol'!BA27","v":0},{"$f":"'107 3326107 Pol'!BB27","v":0},{"$f":"'107 3326107 Pol'!BC27","v":0},{"$f":"'107 3326107 Pol'!BD27","v":0},{"$f":"'107 3326107 Pol'!BE27","v":0}]
[{"$f":"'107 3326107 Pol'!B28","v":"93"},{"$f":"'107 3326107 Pol'!C28","v":"Dokončovací práce inženýrských staveb"},null,null,{"$f":"'107 3326107 Pol'!BA33","v":0},{"$f":"'107 3326107 Pol'!BB33","v":0},{"$f":"'107 3326107 Pol'!BC33","v":0},{"$f":"'107 3326107 Pol'!BD33","v":0},{"$f":"'107 3326107 Pol'!BE33","v":0}]
[{"$f":"'107 3326107 Pol'!B34","v":"99"},{"$f":"'107 3326107 Pol'!C34","v":"Staveništní přesun hmot"},null,null,{"$f":"'107 3326107 Pol'!BA36","v":0},{"$f":"'107 3326107 Pol'!BB36","v":0},{"$f":"'107 3326107 Pol'!BC36","v":0},{"$f":"'107 3326107 Pol'!BD36","v":0},{"$f":"'107 3326107 Pol'!BE36","v":0}]
[null,"CELKEM  OBJEKT",null,null,{"$f":"SUM(E7:E11)","v":0},{"$f":"SUM(F7:F11)","v":0},{"$f":"SUM(G7:G11)","v":0},{"$f":"SUM(H7:H11)","v":0},{"$f":"SUM(I7:I11)","v":0}]
[]
["VEDLEJŠÍ ROZPOČTOVÉ  NÁKLADY"]
[]
["Název VRN",null,null,null,"Kč",null,null,null,"Kč"]
["Zařízení staveniště",null,null,null,0,null,null,null,{"$f":"E17+F17*G17/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Provoz investora",null,null,null,0,null,null,null,{"$f":"E18+F18*G18/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Kompletační činnost (IČD)",null,null,null,0,null,null,null,{"$f":"E19+F19*G19/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["DIO",null,null,null,0,null,null,null,{"$f":"E20+F20*G20/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"CELKEM VRN",null,null,null,null,null,{"$f":"SUM(I17:I20)","v":0}]

{"sheet":"107 3326107 Pol","index":21,"n_rows":36,"n_cols":80,"rows_kept":36,"cut":false,"hidden":false,"merged":[[11,2,11,6],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,4,3,6],[8,2,8,3],[29,2,29,3],[31,2,31,3],[15,2,15,3],[17,2,17,3],[19,2,19,3]]}
["Položkový rozpočet "]
[]
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,"Rozpočet:",{"$f":"'107 3326107 Rek'!H1","v":"3326/107"}]
["Objekt :",null,"107 Vesecko - Rozšíření zpevněné plochy",null,{"$f":"'107 3326107 Rek'!G2","v":"Vesecko - Rozšíření pruhu zpevněné plochy -3,0 m"}]
[]
["P.č.","Číslo položky","Název položky","MJ","množství","cena / MJ","celkem (Kč)","Jednotková hmotnost","Celková hmotnost","Jednotková dem.hmot.","Celková dem.hmot."]
["Díl:","1","Zemní práce",null,null,null,null,null,null,null,null,null,null,null,1]
[1,"113108305R00","Odstranění asfaltové vrstvy pl.do 50 m2, tl. 5 cm ","m2",239.25,null,{"$f":"E8*F8","v":0},0,{"$f":"E8*H8","v":0},-0.11,{"$f":"E8*J8","v":-26.317499999999999},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ8=1,G8,0)","v":0},{"$f":"IF(AZ8=2,G8,0)","v":0},{"$f":"IF(AZ8=3,G8,0)","v":0},{"$f":"IF(AZ8=4,G8,0)","v":0},{"$f":"IF(AZ8=5,G8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha upravované ZP - lokálně odstraňovaná degradovaná vrstva na 55% plochy:145,00*3,00*0,55",null,239.25,null,null,null,null,null,null,null,"Plocha upravované ZP - lokálně odstraňovaná degradovaná vrstva na 55% plochy:145,00*3,00*0,55"]
[2,"979082113RSZ","Vodorovná doprava suti po suchu na skládku zhotovitele","t",26.317499999999999,null,{"$f":"E10*F10","v":0},0,{"$f":"E10*H10","v":0},0,{"$f":"E10*J10","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ10=1,G10,0)","v":0},{"$f":"IF(AZ10=2,G10,0)","v":0},{"$f":"IF(AZ10=3,G10,0)","v":0},{"$f":"IF(AZ10=4,G10,0)","v":0},{"$f":"IF(AZ10=5,G10,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[3,"979990112RRA","Poplatek za skládku suti - obalované kam. - asfalt ","t",26.317499999999999,null,{"$f":"E11*F11","v":0},0,{"$f":"E11*H11","v":0},0,{"$f":"E11*J11","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ11=1,G11,0)","v":0},{"$f":"IF(AZ11=2,G11,0)","v":0},{"$f":"IF(AZ11=3,G11,0)","v":0},{"$f":"IF(AZ11=4,G11,0)","v":0},{"$f":"IF(AZ11=5,G11,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Položka je určena pro suť o velikosti kusu do 30x30 cm (technologický materiál určený k recyklaci).",null,null,null,null,null,null,null,null,"Položka je určena pro suť o velikosti kusu do 30x30 cm (technologický materiál určený k recyklaci).",null,null,3]
[null,"Celkem za","1 Zemní práce",null,null,null,{"$f":"SUM(G7:G12)","v":0},null,{"$f":"SUM(I7:I12)","v":0},null,{"$f":"SUM(K7:K12)","v":-26.317499999999999},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA7:BA12)","v":0},{"$f":"SUM(BB7:BB12)","v":0},{"$f":"SUM(BC7:BC12)","v":0},{"$f":"SUM(BD7:BD12)","v":0},{"$f":"SUM(BE7:BE12)","v":0}]
["Díl:","5","Komunikace",null,null,null,null,null,null,null,null,null,null,null,1]
[4,"572713112R00","Vyrovnání povrchu krytů kamen. obaleným asfaltem ","t",29.906300000000002,null,{"$f":"E15*F15","v":0},1,{"$f":"E15*H15","v":29.906300000000002},0,{"$f":"E15*J15","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ15=1,G15,0)","v":0},{"$f":"IF(AZ15=2,G15,0)","v":0},{"$f":"IF(AZ15=3,G15,0)","v":0},{"$f":"IF(AZ15=4,G15,0)","v":0},{"$f":"IF(AZ15=5,G15,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha upravované ZP - vyrovnávací vrstva na 55% plochy:145,00*3,00*0,05*2,50*0,55",null,29.906300000000002,null,null,null,null,null,null,null,"Plocha upravované ZP - vyrovnávací vrstva na 55% plochy:145,00*3,00*0,05*2,50*0,55"]
[5,"573231126R00","Postřik spojovací z KAE množství zbytkového asfaltu 0,6 kg/m2","m2",674.25,null,{"$f":"E17*F17","v":0},5.0000000000000001E-4,{"$f":"E17*H17","v":0.33712500000000001},0,{"$f":"E17*J17","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ17=1,G17,0)","v":0},{"$f":"IF(AZ17=2,G17,0)","v":0},{"$f":"IF(AZ17=3,G17,0)","v":0},{"$f":"IF(AZ17=4,G17,0)","v":0},{"$f":"IF(AZ17=5,G17,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha upravované ZP:145,00*3,00*(1,00+0,55)",null,674.25,null,null,null,null,null,null,null,"Plocha upravované ZP:145,00*3,00*(1,00+0,55)"]
[6,"577131111RT2","Beton asfalt. ACO 11+ obrusný, š. do 3 m, tl. 4 cm plochy 201-1000 m2","m2",435,null,{"$f":"E19*F19","v":0},0.10373,{"$f":"E19*H19","v":45.122550000000004},0,{"$f":"E19*J19","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ19=1,G19,0)","v":0},{"$f":"IF(AZ19=2,G19,0)","v":0},{"$f":"IF(AZ19=3,G19,0)","v":0},{"$f":"IF(AZ19=4,G19,0)","v":0},{"$f":"IF(AZ19=5,G19,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha upravované ZP:145,00*3,00",null,435,null,null,null,null,null,null,null,"Plocha upravované ZP:145,00*3,00"]
[null,"Celkem za","5 Komunikace",null,null,null,{"$f":"SUM(G14:G20)","v":0},null,{"$f":"SUM(I14:I20)","v":75.365975000000006},null,{"$f":"SUM(K14:K20)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA14:BA20)","v":0},{"$f":"SUM(BB14:BB20)","v":0},{"$f":"SUM(BC14:BC20)","v":0},{"$f":"SUM(BD14:BD20)","v":0},{"$f":"SUM(BE14:BE20)","v":0}]
["Díl:","91","Doplňující práce na komunikaci",null,null,null,null,null,null,null,null,null,null,null,1]
[7,"919723111R00","Dilatační spáry - řezání, podélné, šířka 2 - 5 mm ","m",160,null,{"$f":"E23*F23","v":0},1.0000000000000001E-5,{"$f":"E23*H23","v":1.6000000000000001E-3},0,{"$f":"E23*J23","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ23=1,G23,0)","v":0},{"$f":"IF(AZ23=2,G23,0)","v":0},{"$f":"IF(AZ23=3,G23,0)","v":0},{"$f":"IF(AZ23=4,G23,0)","v":0},{"$f":"IF(AZ23=5,G23,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[8,"919723211R00","Dilatační spáry řez.podélné 9 mm,zalití za studena ","m",160,null,{"$f":"E24*F24","v":0},2.0000000000000002E-5,{"$f":"E24*H24","v":3.2000000000000002E-3},0,{"$f":"E24*J24","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ24=1,G24,0)","v":0},{"$f":"IF(AZ24=2,G24,0)","v":0},{"$f":"IF(AZ24=3,G24,0)","v":0},{"$f":"IF(AZ24=4,G24,0)","v":0},{"$f":"IF(AZ24=5,G24,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[9,"919731121R00","Zarovnání styčné plochy živičné tl. do 5 cm ","m",160,null,{"$f":"E25*F25","v":0},0,{"$f":"E25*H25","v":0},0,{"$f":"E25*J25","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ25=1,G25,0)","v":0},{"$f":"IF(AZ25=2,G25,0)","v":0},{"$f":"IF(AZ25=3,G25,0)","v":0},{"$f":"IF(AZ25=4,G25,0)","v":0},{"$f":"IF(AZ25=5,G25,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[10,"919735111R00","Řezání stávajícího živičného krytu tl. do 5 cm ","m",160,null,{"$f":"E26*F26","v":0},0,{"$f":"E26*H26","v":0},0,{"$f":"E26*J26","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ26=1,G26,0)","v":0},{"$f":"IF(AZ26=2,G26,0)","v":0},{"$f":"IF(AZ26=3,G26,0)","v":0},{"$f":"IF(AZ26=4,G26,0)","v":0},{"$f":"IF(AZ26=5,G26,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,"Celkem za","91 Doplňující práce na komunikaci",null,null,null,{"$f":"SUM(G22:G26)","v":0},null,{"$f":"SUM(I22:I26)","v":4.8000000000000004E-3},null,{"$f":"SUM(K22:K26)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA22:BA26)","v":0},{"$f":"SUM(BB22:BB26)","v":0},{"$f":"SUM(BC22:BC26)","v":0},{"$f":"SUM(BD22:BD26)","v":0},{"$f":"SUM(BE22:BE26)","v":0}]
["Díl:","93","Dokončovací práce inženýrských staveb",null,null,null,null,null,null,null,null,null,null,null,1]
[11,"938908411R00","Očištění povrchu krytu saponátovým roztokem ","m2",435,null,{"$f":"E29*F29","v":0},1.0000000000000001E-5,{"$f":"E29*H29","v":4.3500000000000006E-3},0,{"$f":"E29*J29","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ29=1,G29,0)","v":0},{"$f":"IF(AZ29=2,G29,0)","v":0},{"$f":"IF(AZ29=3,G29,0)","v":0},{"$f":"IF(AZ29=4,G29,0)","v":0},{"$f":"IF(AZ29=5,G29,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha upravované ZP:145,00*3,00",null,435,null,null,null,null,null,null,null,"Plocha upravované ZP:145,00*3,00"]
[12,"938909311R00","Odstranění nánosu z povrchu živičného nebo beton. ","m2",435,null,{"$f":"E31*F31","v":0},0,{"$f":"E31*H31","v":0},0,{"$f":"E31*J31","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ31=1,G31,0)","v":0},{"$f":"IF(AZ31=2,G31,0)","v":0},{"$f":"IF(AZ31=3,G31,0)","v":0},{"$f":"IF(AZ31=4,G31,0)","v":0},{"$f":"IF(AZ31=5,G31,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha upravované ZP:145,00*3,00",null,435,null,null,null,null,null,null,null,"Plocha upravované ZP:145,00*3,00"]
[null,"Celkem za","93 Dokončovací práce inženýrských staveb",null,null,null,{"$f":"SUM(G28:G32)","v":0},null,{"$f":"SUM(I28:I32)","v":4.3500000000000006E-3},null,{"$f":"SUM(K28:K32)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA28:BA32)","v":0},{"$f":"SUM(BB28:BB32)","v":0},{"$f":"SUM(BC28:BC32)","v":0},{"$f":"SUM(BD28:BD32)","v":0},{"$f":"SUM(BE28:BE32)","v":0}]
["Díl:","99","Staveništní přesun hmot",null,null,null,null,null,null,null,null,null,null,null,1]
[13,"998225111R00","Přesun hmot, pozemní komunikace, kryt živičný ","t",75.375124999999997,null,{"$f":"E35*F35","v":0},0,{"$f":"E35*H35","v":0},null,{"$f":"E35*J35","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,7,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ35=1,G35,0)","v":0},{"$f":"IF(AZ35=2,G35,0)","v":0},{"$f":"IF(AZ35=3,G35,0)","v":0},{"$f":"IF(AZ35=4,G35,0)","v":0},{"$f":"IF(AZ35=5,G35,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1]
[null,"Celkem za","99 Staveništní přesun hmot",null,null,null,{"$f":"SUM(G34:G35)","v":0},null,{"$f":"SUM(I34:I35)","v":0},null,{"$f":"SUM(K34:K35)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA34:BA35)","v":0},{"$f":"SUM(BB34:BB35)","v":0},{"$f":"SUM(BC34:BC35)","v":0},{"$f":"SUM(BD34:BD35)","v":0},{"$f":"SUM(BE34:BE35)","v":0}]

{"sheet":"108 3326108 KL","index":22,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[22,0,22,1],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[50,1,50,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,1,44,6],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6],[49,1,49,6]]}
["POLOŽKOVÝ ROZPOČET"]
["Rozpočet",null,"3326/108","Oprava komunikace \"Ve Struhách\" od čp. 908",null,"JKSO ","822.29"]
[]
["Objekt",null,null,null,null,"SKP "]
["108",null,"Oprava komunikace \"Ve Struhách\"",null,null,"Měrná jednotka","m2"]
["Stavba",null,null,null,null,"Počet jednotek",0]
["3326",null,"Oprava místních komunikací Turnov",null,null,"Náklady na m.j.",{"$f":"IF(G6=0,,ROUND((F30+F32)/G6,1))","v":0}]
["Projektant",null,null,null,null,"Typ rozpočtu"]
["Zpracovatel projektu"]
["Objednatel",null,"Město TURNOV"]
["Dodavatel",null,".",null,null,"Zakázkové číslo "]
["Rozpočtoval",null,null,null,null,"Počet listů"]
["ROZPOČTOVÉ NÁKLADY"]
["Základní rozpočtové náklady",null,null,"Ostatní rozpočtové náklady"]
[null,"HSV celkem",{"$f":"'108 3326108 Rek'!E13","v":0},{"$f":"'108 3326108 Rek'!A18","v":"Zařízení staveniště"},null,null,{"$f":"'108 3326108 Rek'!I18","v":0}]
["Z","PSV celkem",{"$f":"'108 3326108 Rek'!F13","v":0},{"$f":"'108 3326108 Rek'!A19","v":"Kompletační činnost (IČD)"},null,null,{"$f":"'108 3326108 Rek'!I19","v":0}]
["R","M práce celkem",{"$f":"'108 3326108 Rek'!H13","v":0},{"$f":"'108 3326108 Rek'!A20","v":"DIO"},null,null,{"$f":"'108 3326108 Rek'!I20","v":0}]
["N","M dodávky celkem",{"$f":"'108 3326108 Rek'!G13","v":0}]
["ZRN celkem",null,{"$f":"SUM(C15:C18)","v":0}]
[]
["HZS",null,{"$f":"'108 3326108 Rek'!I13","v":0}]
["ZRN+HZS",null,{"$f":"C19+C21","v":0}]
["ZRN+ost.náklady+HZS",null,{"$f":"C22+G23","v":0},"Ostatní náklady celkem",null,null,{"$f":"'108 3326108 Rek'!H21","v":0}]
["Vypracoval",null,null,"Za zhotovitele",null,"Za objednatele"]
["Jméno :",null,null,"Jméno :",null,"Jméno :"]
["Datum :",null,null,"Datum :",null,"Datum :"]
[]
["Podpis :",null,null,"Podpis:",null,"Podpis:"]
[]
["Základ pro DPH",null,21,"%  ",null,{"$f":"C23-F32","v":0}]
["DPH",null,{"$f":"C30","v":21},"% ",null,{"$f":"ROUND(PRODUCT(F30,C31/100),0)","v":0}]
["Základ pro DPH",null,0,"% ",null,0]
["DPH",null,{"$f":"C32","v":0},"% ",null,{"$f":"ROUND(PRODUCT(F32,C33/100),0)","v":0}]
["CENA ZA OBJEKT CELKEM",null,null,null,null,{"$f":"ROUND(SUM(F30:F33),0)","v":0}]
[]
["Poznámka :",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"108 3326108 Rek","index":23,"n_rows":21,"n_cols":53,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[1,6,1,8],[20,7,20,8]]}
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,null,null,"Rozpočet :","3326/108"]
["Objekt :",null,"108 Oprava komunikace \"Ve Struhách\"",null,null,null,"Oprava komunikace \"Ve Struhách\" od čp. 908"]
[]
["REKAPITULACE  STAVEBNÍCH  DÍLŮ"]
[]
[null,"Stavební díl",null,null,"HSV","PSV","Dodávka","Montáž","HZS"]
[{"$f":"'108 3326108 Pol'!B7","v":"1"},{"$f":"'108 3326108 Pol'!C7","v":"Zemní práce"},null,null,{"$f":"'108 3326108 Pol'!BA16","v":0},{"$f":"'108 3326108 Pol'!BB16","v":0},{"$f":"'108 3326108 Pol'!BC16","v":0},{"$f":"'108 3326108 Pol'!BD16","v":0},{"$f":"'108 3326108 Pol'!BE16","v":0}]
[{"$f":"'108 3326108 Pol'!B17","v":"5"},{"$f":"'108 3326108 Pol'!C17","v":"Komunikace"},null,null,{"$f":"'108 3326108 Pol'!BA32","v":0},{"$f":"'108 3326108 Pol'!BB32","v":0},{"$f":"'108 3326108 Pol'!BC32","v":0},{"$f":"'108 3326108 Pol'!BD32","v":0},{"$f":"'108 3326108 Pol'!BE32","v":0}]
[{"$f":"'108 3326108 Pol'!B33","v":"8"},{"$f":"'108 3326108 Pol'!C33","v":"Trubní vedení"},null,null,{"$f":"'108 3326108 Pol'!BA35","v":0},{"$f":"'108 3326108 Pol'!BB35","v":0},{"$f":"'108 3326108 Pol'!BC35","v":0},{"$f":"'108 3326108 Pol'!BD35","v":0},{"$f":"'108 3326108 Pol'!BE35","v":0}]
[{"$f":"'108 3326108 Pol'!B36","v":"91"},{"$f":"'108 3326108 Pol'!C36","v":"Doplňující práce na komunikaci"},null,null,{"$f":"'108 3326108 Pol'!BA41","v":0},{"$f":"'108 3326108 Pol'!BB41","v":0},{"$f":"'108 3326108 Pol'!BC41","v":0},{"$f":"'108 3326108 Pol'!BD41","v":0},{"$f":"'108 3326108 Pol'!BE41","v":0}]
[{"$f":"'108 3326108 Pol'!B42","v":"93"},{"$f":"'108 3326108 Pol'!C42","v":"Dokončovací práce inženýrských staveb"},null,null,{"$f":"'108 3326108 Pol'!BA45","v":0},{"$f":"'108 3326108 Pol'!BB45","v":0},{"$f":"'108 3326108 Pol'!BC45","v":0},{"$f":"'108 3326108 Pol'!BD45","v":0},{"$f":"'108 3326108 Pol'!BE45","v":0}]
[{"$f":"'108 3326108 Pol'!B46","v":"99"},{"$f":"'108 3326108 Pol'!C46","v":"Staveništní přesun hmot"},null,null,{"$f":"'108 3326108 Pol'!BA48","v":0},{"$f":"'108 3326108 Pol'!BB48","v":0},{"$f":"'108 3326108 Pol'!BC48","v":0},{"$f":"'108 3326108 Pol'!BD48","v":0},{"$f":"'108 3326108 Pol'!BE48","v":0}]
[null,"CELKEM  OBJEKT",null,null,{"$f":"SUM(E7:E12)","v":0},{"$f":"SUM(F7:F12)","v":0},{"$f":"SUM(G7:G12)","v":0},{"$f":"SUM(H7:H12)","v":0},{"$f":"SUM(I7:I12)","v":0}]
[]
["VEDLEJŠÍ ROZPOČTOVÉ  NÁKLADY"]
[]
["Název VRN",null,null,null,"Kč",null,null,null,"Kč"]
["Zařízení staveniště",null,null,null,0,null,null,null,{"$f":"E18+F18*G18/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Kompletační činnost (IČD)",null,null,null,0,null,null,null,{"$f":"E19+F19*G19/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["DIO",null,null,null,0,null,null,null,{"$f":"E20+F20*G20/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"CELKEM VRN",null,null,null,null,null,{"$f":"SUM(I18:I20)","v":0}]

{"sheet":"108 3326108 Pol","index":24,"n_rows":48,"n_cols":80,"rows_kept":48,"cut":false,"hidden":false,"merged":[[10,2,10,3],[12,2,12,3],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,4,3,6],[8,2,8,3],[43,2,43,3],[37,2,37,3],[18,2,18,3],[20,2,20,3],[22,2,22,3],[24,2,24,3],[26,2,26,3],[28,2,28,3],[30,2,30,3]]}
["Položkový rozpočet "]
[]
["Stavba :",null,"3326 Oprava místních komunikací Turnov",null,"Rozpočet:",{"$f":"'108 3326108 Rek'!H1","v":"3326/108"}]
["Objekt :",null,"108 Oprava komunikace \"Ve Struhách\"",null,{"$f":"'108 3326108 Rek'!G2","v":"Oprava komunikace \"Ve Struhách\" od čp. 908"}]
[]
["P.č.","Číslo položky","Název položky","MJ","množství","cena / MJ","celkem (Kč)","Jednotková hmotnost","Celková hmotnost","Jednotková dem.hmot.","Celková dem.hmot."]
["Díl:","1","Zemní práce",null,null,null,null,null,null,null,null,null,null,null,1]
[1,"113107320RRR","Odstranění podkladu pl. 50 m2,kam.těžené tl.20 cm včetně cihel a zeminy","m2",28,null,{"$f":"E8*F8","v":0},0,{"$f":"E8*H8","v":0},-0.44,{"$f":"E8*J8","v":-12.32},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ8=1,G8,0)","v":0},{"$f":"IF(AZ8=2,G8,0)","v":0},{"$f":"IF(AZ8=3,G8,0)","v":0},{"$f":"IF(AZ8=4,G8,0)","v":0},{"$f":"IF(AZ8=5,G8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Část plochy komunikace:40,00*0,70",null,28,null,null,null,null,null,null,null,"Část plochy komunikace:40,00*0,70"]
[2,"113108442R00","Rozrytí krytu,kamenivo bez zhut.,se živič. pojivem ","m2",185,null,{"$f":"E10*F10","v":0},0,{"$f":"E10*H10","v":0},0,{"$f":"E10*J10","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ10=1,G10,0)","v":0},{"$f":"IF(AZ10=2,G10,0)","v":0},{"$f":"IF(AZ10=3,G10,0)","v":0},{"$f":"IF(AZ10=4,G10,0)","v":0},{"$f":"IF(AZ10=5,G10,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,"Plocha komunikace :185,00",null,185,null,null,null,null,null,null,null,"Plocha komunikace :185,00"]
[3,"113109320RRR","Odstranění podkladu pl.50 m2, bet.prostý tl.20 cm včetně likvidace suti","m2",2.25,null,{"$f":"E12*F12","v":0},0,{"$f":"E12*H12","v":0},-0.48,{"$f":"E12*J12","v":-1.08},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ12=1,G12,0)","v":0},{"$f":"IF(AZ12=2,G12,0)","v":0},{"$f":"IF(AZ12=3,G12,0)","v":0},{"$f":"IF(AZ12=4,G12,0)","v":0},{"$f":"IF(AZ12=5,G12,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Szávající odvodňovací žlab:4,50*0,50",null,2.25,null,null,null,null,null,null,null,"Szávající odvodňovací žlab:4,50*0,50"]
[4,"979082113RSZ","Vodorovná doprava suti po suchu na skládku zhotovitele","t",12.32,null,{"$f":"E14*F14","v":0},0,{"$f":"E14*H14","v":0},0,{"$f":"E14*J14","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ14=1,G14,0)","v":0},{"$f":"IF(AZ14=2,G14,0)","v":0},{"$f":"IF(AZ14=3,G14,0)","v":0},{"$f":"IF(AZ14=4,G14,0)","v":0},{"$f":"IF(AZ14=5,G14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[5,"979089001R00","Poplatek za  uložení odpadního štěrku a kameniva skupina odpadu 010408","t",12.32,null,{"$f":"E15*F15","v":0},0,{"$f":"E15*H15","v":0},0,{"$f":"E15*J15","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ15=1,G15,0)","v":0},{"$f":"IF(AZ15=2,G15,0)","v":0},{"$f":"IF(AZ15=3,G15,0)","v":0},{"$f":"IF(AZ15=4,G15,0)","v":0},{"$f":"IF(AZ15=5,G15,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,"Celkem za","1 Zemní práce",null,null,null,{"$f":"SUM(G7:G15)","v":0},null,{"$f":"SUM(I7:I15)","v":0},null,{"$f":"SUM(K7:K15)","v":-13.4},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA7:BA15)","v":0},{"$f":"SUM(BB7:BB15)","v":0},{"$f":"SUM(BC7:BC15)","v":0},{"$f":"SUM(BD7:BD15)","v":0},{"$f":"SUM(BE7:BE15)","v":0}]
["Díl:","5","Komunikace",null,null,null,null,null,null,null,null,null,null,null,1]
[6,"564861111RT4","Podklad ze štěrkodrti po zhutnění tloušťky 20 cm štěrkodrť frakce 0-63 mm","m2",28,null,{"$f":"E18*F18","v":0},0.441,{"$f":"E18*H18","v":12.348000000000001},0,{"$f":"E18*J18","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ18=1,G18,0)","v":0},{"$f":"IF(AZ18=2,G18,0)","v":0},{"$f":"IF(AZ18=3,G18,0)","v":0},{"$f":"IF(AZ18=4,G18,0)","v":0},{"$f":"IF(AZ18=5,G18,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Část plochy komunikace - doplnění:40,00*0,70",null,28,null,null,null,null,null,null,null,"Část plochy komunikace - doplnění:40,00*0,70"]
[7,"564901113R00","Recyklace podkladu s přid.kameniva drc. 0,08 m3/m2 ","m2",185,null,{"$f":"E20*F20","v":0},0.13769000000000001,{"$f":"E20*H20","v":25.472650000000002},0,{"$f":"E20*J20","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ20=1,G20,0)","v":0},{"$f":"IF(AZ20=2,G20,0)","v":0},{"$f":"IF(AZ20=3,G20,0)","v":0},{"$f":"IF(AZ20=4,G20,0)","v":0},{"$f":"IF(AZ20=5,G20,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,"Plocha komunikace :185,00",null,185,null,null,null,null,null,null,null,"Plocha komunikace :185,00"]
[8,"569831111R00","Zpevnění krajnic štěrkodrtí tloušťky  10 cm ","m2",21.25,null,{"$f":"E22*F22","v":0},0.18776000000000001,{"$f":"E22*H22","v":3.9899},0,{"$f":"E22*J22","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ22=1,G22,0)","v":0},{"$f":"IF(AZ22=2,G22,0)","v":0},{"$f":"IF(AZ22=3,G22,0)","v":0},{"$f":"IF(AZ22=4,G22,0)","v":0},{"$f":"IF(AZ22=5,G22,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Dosypání krajnic:85,00*0,25",null,21.25,null,null,null,null,null,null,null,"Dosypání krajnic:85,00*0,25"]
[9,"572713112R00","Vyrovnání povrchu krytů kamen. obaleným asfaltem ","t",23.125,null,{"$f":"E24*F24","v":0},1,{"$f":"E24*H24","v":23.125},0,{"$f":"E24*J24","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ24=1,G24,0)","v":0},{"$f":"IF(AZ24=2,G24,0)","v":0},{"$f":"IF(AZ24=3,G24,0)","v":0},{"$f":"IF(AZ24=4,G24,0)","v":0},{"$f":"IF(AZ24=5,G24,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha komunikace :185,00*0,05*2,5",null,23.125,null,null,null,null,null,null,null,"Plocha komunikace :185,00*0,05*2,5"]
[10,"573231126R00","Postřik spojovací z KAE množství zbytkového asfaltu 0,6 kg/m2","m2",185,null,{"$f":"E26*F26","v":0},5.0000000000000001E-4,{"$f":"E26*H26","v":9.2499999999999999E-2},0,{"$f":"E26*J26","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ26=1,G26,0)","v":0},{"$f":"IF(AZ26=2,G26,0)","v":0},{"$f":"IF(AZ26=3,G26,0)","v":0},{"$f":"IF(AZ26=4,G26,0)","v":0},{"$f":"IF(AZ26=5,G26,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha komunikace :185,00",null,185,null,null,null,null,null,null,null,"Plocha komunikace :185,00"]
[11,"577151113RT3","Beton asfalt. ACO 16+ obrusný, š. do 3 m, tl. 6 cm plochy 101-200 m2","m2",185,null,{"$f":"E28*F28","v":0},0.15559000000000001,{"$f":"E28*H28","v":28.78415},0,{"$f":"E28*J28","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ28=1,G28,0)","v":0},{"$f":"IF(AZ28=2,G28,0)","v":0},{"$f":"IF(AZ28=3,G28,0)","v":0},{"$f":"IF(AZ28=4,G28,0)","v":0},{"$f":"IF(AZ28=5,G28,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Plocha komunikace :185,00",null,185,null,null,null,null,null,null,null,"Plocha komunikace :185,00"]
[12,"597141221R00","Rigol dlážděný, lom.kámen 25 cm, MC, lože štěrkop. ","m",4.5,null,{"$f":"E30*F30","v":0},1.22925,{"$f":"E30*H30","v":5.531625},0,{"$f":"E30*J30","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ30=1,G30,0)","v":0},{"$f":"IF(AZ30=2,G30,0)","v":0},{"$f":"IF(AZ30=3,G30,0)","v":0},{"$f":"IF(AZ30=4,G30,0)","v":0},{"$f":"IF(AZ30=5,G30,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Odvodňovací žlab:4,50",null,4.5,null,null,null,null,null,null,null,"Odvodňovací žlab:4,50"]
[null,"Celkem za","5 Komunikace",null,null,null,{"$f":"SUM(G17:G31)","v":0},null,{"$f":"SUM(I17:I31)","v":99.34382500000001},null,{"$f":"SUM(K17:K31)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA17:BA31)","v":0},{"$f":"SUM(BB17:BB31)","v":0},{"$f":"SUM(BC17:BC31)","v":0},{"$f":"SUM(BD17:BD31)","v":0},{"$f":"SUM(BE17:BE31)","v":0}]
["Díl:","8","Trubní vedení",null,null,null,null,null,null,null,null,null,null,null,1]
[13,"899231111R00","Výšková úprava vstupu do 20 cm, zvýšení mříže ","kus",1,null,{"$f":"E34*F34","v":0},0.43381999999999998,{"$f":"E34*H34","v":0.43381999999999998},0,{"$f":"E34*J34","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ34=1,G34,0)","v":0},{"$f":"IF(AZ34=2,G34,0)","v":0},{"$f":"IF(AZ34=3,G34,0)","v":0},{"$f":"IF(AZ34=4,G34,0)","v":0},{"$f":"IF(AZ34=5,G34,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,"Celkem za","8 Trubní vedení",null,null,null,{"$f":"SUM(G33:G34)","v":0},null,{"$f":"SUM(I33:I34)","v":0.43381999999999998},null,{"$f":"SUM(K33:K34)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA33:BA34)","v":0},{"$f":"SUM(BB33:BB34)","v":0},{"$f":"SUM(BC33:BC34)","v":0},{"$f":"SUM(BD33:BD34)","v":0},{"$f":"SUM(BE33:BE34)","v":0}]
["Díl:","91","Doplňující práce na komunikaci",null,null,null,null,null,null,null,null,null,null,null,1]
[14,"918101111R00","Lože pod obrubníky nebo obruby dlažeb z C 12/15 ","m3",0.33750000000000002,null,{"$f":"E37*F37","v":0},2.5249999999999999,{"$f":"E37*H37","v":0.85218749999999999},0,{"$f":"E37*J37","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ37=1,G37,0)","v":0},{"$f":"IF(AZ37=2,G37,0)","v":0},{"$f":"IF(AZ37=3,G37,0)","v":0},{"$f":"IF(AZ37=4,G37,0)","v":0},{"$f":"IF(AZ37=5,G37,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Odvodňovací žlab:4,50*0,50*0,15",null,0.33750000000000002,null,null,null,null,null,null,null,"Odvodňovací žlab:4,50*0,50*0,15"]
[15,"919731122R00","Zarovnání styčné plochy živičné tl. do 10 cm ","m",4.5,null,{"$f":"E39*F39","v":0},0,{"$f":"E39*H39","v":0},0,{"$f":"E39*J39","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ39=1,G39,0)","v":0},{"$f":"IF(AZ39=2,G39,0)","v":0},{"$f":"IF(AZ39=3,G39,0)","v":0},{"$f":"IF(AZ39=4,G39,0)","v":0},{"$f":"IF(AZ39=5,G39,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[16,"919735112R00","Řezání stávajícího živičného krytu tl. 5 - 10 cm ","m",4.5,null,{"$f":"E40*F40","v":0},0,{"$f":"E40*H40","v":0},0,{"$f":"E40*J40","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ40=1,G40,0)","v":0},{"$f":"IF(AZ40=2,G40,0)","v":0},{"$f":"IF(AZ40=3,G40,0)","v":0},{"$f":"IF(AZ40=4,G40,0)","v":0},{"$f":"IF(AZ40=5,G40,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,"Celkem za","91 Doplňující práce na komunikaci",null,null,null,{"$f":"SUM(G36:G40)","v":0},null,{"$f":"SUM(I36:I40)","v":0.85218749999999999},null,{"$f":"SUM(K36:K40)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA36:BA40)","v":0},{"$f":"SUM(BB36:BB40)","v":0},{"$f":"SUM(BC36:BC40)","v":0},{"$f":"SUM(BD36:BD40)","v":0},{"$f":"SUM(BE36:BE40)","v":0}]
["Díl:","93","Dokončovací práce inženýrských staveb",null,null,null,null,null,null,null,null,null,null,null,1]
[17,"938909612R00","Odstranění nánosu na krajnicích tl. do 20 cm ","m2",30,null,{"$f":"E43*F43","v":0},0,{"$f":"E43*H43","v":0},-0.252,{"$f":"E43*J43","v":-7.5600000000000005},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ43=1,G43,0)","v":0},{"$f":"IF(AZ43=2,G43,0)","v":0},{"$f":"IF(AZ43=3,G43,0)","v":0},{"$f":"IF(AZ43=4,G43,0)","v":0},{"$f":"IF(AZ43=5,G43,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Stávající krajnice a břehy:120,00*0,25",null,30,null,null,null,null,null,null,null,"Stávající krajnice a břehy:120,00*0,25"]
[null,"Celkem za","93 Dokončovací práce inženýrských staveb",null,null,null,{"$f":"SUM(G42:G44)","v":0},null,{"$f":"SUM(I42:I44)","v":0},null,{"$f":"SUM(K42:K44)","v":-7.5600000000000005},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA42:BA44)","v":0},{"$f":"SUM(BB42:BB44)","v":0},{"$f":"SUM(BC42:BC44)","v":0},{"$f":"SUM(BD42:BD44)","v":0},{"$f":"SUM(BE42:BE44)","v":0}]
["Díl:","99","Staveništní přesun hmot",null,null,null,null,null,null,null,null,null,null,null,1]
[18,"998225111R00","Přesun hmot, pozemní komunikace, kryt živičný ","t",100.62983250000001,null,{"$f":"E47*F47","v":0},0,{"$f":"E47*H47","v":0},null,{"$f":"E47*J47","v":0},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,7,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AZ47=1,G47,0)","v":0},{"$f":"IF(AZ47=2,G47,0)","v":0},{"$f":"IF(AZ47=3,G47,0)","v":0},{"$f":"IF(AZ47=4,G47,0)","v":0},{"$f":"IF(AZ47=5,G47,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1]
[null,"Celkem za","99 Staveništní přesun hmot",null,null,null,{"$f":"SUM(G46:G47)","v":0},null,{"$f":"SUM(I46:I47)","v":0},null,{"$f":"SUM(K46:K47)","v":0},null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BA46:BA47)","v":0},{"$f":"SUM(BB46:BB47)","v":0},{"$f":"SUM(BC46:BC47)","v":0},{"$f":"SUM(BD46:BD47)","v":0},{"$f":"SUM(BE46:BE47)","v":0}]