{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Stavební rozpočet","Stavební rozpočet - součet","Krycí list rozpočtu"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Stavební rozpočet","index":0,"n_rows":242,"n_cols":37,"rows_kept":242,"cut":false,"hidden":false,"merged":[[223,7,223,8],[206,3,206,6],[209,3,209,6],[211,3,211,6],[187,3,187,6],[189,3,189,6],[200,3,200,6],[214,3,214,6],[198,3,198,6],[179,3,179,6],[181,3,181,6],[183,3,183,6],[185,3,185,6],[162,7,162,8],[171,3,171,6],[175,3,175,6],[177,3,177,6],[143,3,143,6],[145,3,145,6],[166,3,166,6],[147,3,147,6],[149,3,149,6],[152,3,152,6],[111,3,111,6],[115,3,115,6],[117,3,117,6],[119,3,119,6],[121,3,121,6],[9,7,9,9],[9,10,9,11],[13,3,13,6],[22,3,22,6],[89,7,89,8],[37,3,37,6],[39,3,39,6],[43,3,43,6],[46,3,46,6],[55,3,55,6],[27,3,27,6],[29,3,29,6],[31,3,31,6],[33,3,33,6],[77,3,77,6],[80,3,80,6],[7,9,8,11],[7,4,8,5],[1,6,2,7],[3,6,4,7],[5,6,6,7],[7,6,8,7],[3,4,4,5],[7,8,8,8],[7,0,8,2],[1,3,2,3],[3,3,4,3],[5,3,6,3],[7,3,8,3],[0,0,0,11],[1,0,2,2],[3,0,4,2],[5,0,6,2],[1,4,2,5],[5,4,6,5],[1,8,2,8],[3,8,4,8],[5,8,6,8],[1,9,2,11],[3,9,4,11],[5,9,6,11],[227,3,227,6],[241,7,241,8],[57,3,57,6],[64,3,64,6],[66,3,66,6],[70,3,70,6],[73,3,73,6],[75,3,75,6],[93,3,93,6],[99,3,99,6],[104,3,104,6],[106,3,106,6],[109,3,109,6],[132,3,132,6],[130,3,130,6],[139,3,139,6]]}
["Stavební rozpočet"]
["Název stavby:",null,null,"Cyklostezka W Krásné Pole","Doba výstavby:",null,null,null,"Objednatel:"]
[]
["Druh stavby:",null,null,null,"Začátek výstavby:",null,null,null,"Projektant:"]
[]
["Lokalita:",null,null,"úsek Nová kolonie - Zauliční","Konec výstavby:",null,null,null,"Zhotovitel:"]
[]
["JKSO:",null,null,null,"Zpracováno dne:",null,"2013-01-21",null,"Zpracoval:"]
[]
[" "," "," "," "," "," ","Jednot.","Náklady (Kč)",null,null,"Hmotnost (t)"]
["Č","Objekt","Kód","Zkrácený popis","M.j.","Množství","cena (Kč)","Dodávka","Montáž","Celkem","Jednot.","Celkem",null,null,null,"Přesuny","Typ skupiny","HSV mat","HSV prac","PSV mat","PSV prac","Mont mat","Mont prac","Ostatní mat."]
[]
[null,null,null,"Ul. Hájkovická"]
[null,null,"11","Přípravné a přidružené práce",null,null,null,{"$f":"SUM(H15:H22)","v":0},{"$f":"SUM(I15:I22)","v":81815},{"$f":"H14+I14","v":81815},null,{"$f":"SUM(L15:L22)","v":183.20099999999999},null,null,null,{"$f":"IF(Q14=\"PR\",J14,SUM(O15:O22))","v":0},"HS",{"$f":"IF(Q14=\"HS\",H14,0)","v":0},{"$f":"IF(Q14=\"HS\",I14-P14,0)","v":81815},{"$f":"IF(Q14=\"PS\",H14,0)","v":0},{"$f":"IF(Q14=\"PS\",I14-P14,0)","v":0},{"$f":"IF(Q14=\"MP\",H14,0)","v":0},{"$f":"IF(Q14=\"MP\",I14-P14,0)","v":0},{"$f":"IF(Q14=\"OM\",H14,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z15:Z22)","v":0},{"$f":"SUM(AA15:AA22)","v":0},{"$f":"SUM(AB15:AB22)","v":81815}]
["1",null,"113151314R00","Frézování krytu nad 500 m2, s překážkami, tl.5 cm","m2",870,75,{"$f":"ROUND(F15*AE15,2)","v":0},{"$f":"J15-H15","v":65250},{"$f":"ROUND(F15*G15,2)","v":65250},0.128,{"$f":"F15*K15","v":111.36},null,"1",{"$f":"IF(N15=\"5\",I15,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD15=0,J15,0)","v":0},{"$f":"IF(AD15=14,J15,0)","v":0},{"$f":"IF(AD15=20,J15,0)","v":65250},null,20,{"$f":"G15*0","v":0},{"$f":"G15*(1-0)","v":75}]
["2",null,"113107141R00","Odstranění podkladu pl. do 200 m2, živice tl. 5 cm","m2",55,50,0,2750,2750,9.8000000000000004E-2,5.3900000000000006,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,2750,null,20,0,50]
["3",null,"113107123R00","Odstranění podkladu pl. 200 m2,kam.drcené tl.30 cm","m2",113,100,0,11300,11300,0.4,45.2,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,11300,null,20,0,100]
["4",null,"113106121R00","Rozebrání dlažeb z betonových dlaždic na sucho - zatravňovací dlažba","m2",9,15,0,135,135,0.13800000000000001,1.242,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,135,null,20,0,15]
["5",null,"113106121R00","Rozebrání dlažeb z betonových dlaždic na sucho","m2",84,15,0,1260,1260,0.13800000000000001,11.592000000000001,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,1260,null,20,0,15]
["6",null,"113106222R00","Rozebrání dlažeb z drobných kostek v živici","m2",4,15,0,60,60,0.28799999999999998,1.1519999999999999,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,60,null,20,0,15]
["7",null,"113202111R00","Vytrhání obrub z krajníků nebo obrubníků stojatých","m",39,20,0,780,780,0.14499999999999999,5.6549999999999994,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,780,null,20,0,20]
["8",null,"113203111R00","Vytrhání obrub z dlažebních kostek","m",14,20,0,280,280,0.115,1.61,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,280,null,20,0,20]
[null,null,"12","Odkopávky a prokopávky",null,null,null,{"$f":"SUM(H24:H27)","v":0},{"$f":"SUM(I24:I27)","v":14072.5},{"$f":"H23+I23","v":14072.5},null,{"$f":"SUM(L24:L27)","v":0},null,null,null,{"$f":"IF(Q23=\"PR\",J23,SUM(O24:O27))","v":0},"HS",{"$f":"IF(Q23=\"HS\",H23,0)","v":0},{"$f":"IF(Q23=\"HS\",I23-P23,0)","v":14072.5},{"$f":"IF(Q23=\"PS\",H23,0)","v":0},{"$f":"IF(Q23=\"PS\",I23-P23,0)","v":0},{"$f":"IF(Q23=\"MP\",H23,0)","v":0},{"$f":"IF(Q23=\"MP\",I23-P23,0)","v":0},{"$f":"IF(Q23=\"OM\",H23,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z24:Z27)","v":0},{"$f":"SUM(AA24:AA27)","v":0},{"$f":"SUM(AB24:AB27)","v":14072.5}]
["9",null,"121101101R00","Sejmutí ornice s přemístěním do 50 m","m3",5,32,{"$f":"ROUND(F24*AE24,2)","v":0},{"$f":"J24-H24","v":160},{"$f":"ROUND(F24*G24,2)","v":160},0,{"$f":"F24*K24","v":0},null,"1",{"$f":"IF(N24=\"5\",I24,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD24=0,J24,0)","v":0},{"$f":"IF(AD24=14,J24,0)","v":0},{"$f":"IF(AD24=20,J24,0)","v":160},null,20,{"$f":"G24*0","v":0},{"$f":"G24*(1-0)","v":32}]
["10",null,"122201101R00","Odkopávky nezapažené v hor. 3 do 100 m3","m3",105,80,{"$f":"ROUND(F25*AE25,2)","v":0},{"$f":"J25-H25","v":8400},{"$f":"ROUND(F25*G25,2)","v":8400},0,{"$f":"F25*K25","v":0},null,"1",{"$f":"IF(N25=\"5\",I25,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD25=0,J25,0)","v":0},{"$f":"IF(AD25=14,J25,0)","v":0},{"$f":"IF(AD25=20,J25,0)","v":8400},null,20,{"$f":"G25*0","v":0},{"$f":"G25*(1-0)","v":80}]
["11",null,"122201109R00","Příplatek za lepivost - odkopávky v hor. 3","m3",52.5,5,{"$f":"ROUND(F26*AE26,2)","v":0},{"$f":"J26-H26","v":262.5},{"$f":"ROUND(F26*G26,2)","v":262.5},0,{"$f":"F26*K26","v":0},null,"1",{"$f":"IF(N26=\"5\",I26,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD26=0,J26,0)","v":0},{"$f":"IF(AD26=14,J26,0)","v":0},{"$f":"IF(AD26=20,J26,0)","v":262.5},null,20,{"$f":"G26*0","v":0},{"$f":"G26*(1-0)","v":5}]
["12",null,"120001101R00","Příplatek za ztížení vykopávky v blízkosti vedení","m3",21,250,{"$f":"ROUND(F27*AE27,2)","v":0},{"$f":"J27-H27","v":5250},{"$f":"ROUND(F27*G27,2)","v":5250},0,{"$f":"F27*K27","v":0},null,"1",{"$f":"IF(N27=\"5\",I27,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD27=0,J27,0)","v":0},{"$f":"IF(AD27=14,J27,0)","v":0},{"$f":"IF(AD27=20,J27,0)","v":5250},null,20,{"$f":"G27*0","v":0},{"$f":"G27*(1-0)","v":250}]
[null,null,"16","Přemístění výkopku",null,null,null,{"$f":"SUM(H29:H29)","v":0},{"$f":"SUM(I29:I29)","v":14700},{"$f":"H28+I28","v":14700},null,{"$f":"SUM(L29:L29)","v":0},null,null,null,{"$f":"IF(Q28=\"PR\",J28,SUM(O29:O29))","v":0},"HS",{"$f":"IF(Q28=\"HS\",H28,0)","v":0},{"$f":"IF(Q28=\"HS\",I28-P28,0)","v":14700},{"$f":"IF(Q28=\"PS\",H28,0)","v":0},{"$f":"IF(Q28=\"PS\",I28-P28,0)","v":0},{"$f":"IF(Q28=\"MP\",H28,0)","v":0},{"$f":"IF(Q28=\"MP\",I28-P28,0)","v":0},{"$f":"IF(Q28=\"OM\",H28,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z29:Z29)","v":0},{"$f":"SUM(AA29:AA29)","v":0},{"$f":"SUM(AB29:AB29)","v":14700}]
["13",null,"162701105R00","Vodorovné přemístění výkopku z hor.1-4 do 10000 m","m3",98,150,{"$f":"ROUND(F29*AE29,2)","v":0},{"$f":"J29-H29","v":14700},{"$f":"ROUND(F29*G29,2)","v":14700},0,{"$f":"F29*K29","v":0},null,"1",{"$f":"IF(N29=\"5\",I29,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD29=0,J29,0)","v":0},{"$f":"IF(AD29=14,J29,0)","v":0},{"$f":"IF(AD29=20,J29,0)","v":14700},null,20,{"$f":"G29*0","v":0},{"$f":"G29*(1-0)","v":150}]
[null,null,"17","Konstrukce ze zemin",null,null,null,{"$f":"SUM(H31:H31)","v":0},{"$f":"SUM(I31:I31)","v":980},{"$f":"H30+I30","v":980},null,{"$f":"SUM(L31:L31)","v":0},null,null,null,{"$f":"IF(Q30=\"PR\",J30,SUM(O31:O31))","v":0},"HS",{"$f":"IF(Q30=\"HS\",H30,0)","v":0},{"$f":"IF(Q30=\"HS\",I30-P30,0)","v":980},{"$f":"IF(Q30=\"PS\",H30,0)","v":0},{"$f":"IF(Q30=\"PS\",I30-P30,0)","v":0},{"$f":"IF(Q30=\"MP\",H30,0)","v":0},{"$f":"IF(Q30=\"MP\",I30-P30,0)","v":0},{"$f":"IF(Q30=\"OM\",H30,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z31:Z31)","v":0},{"$f":"SUM(AA31:AA31)","v":0},{"$f":"SUM(AB31:AB31)","v":980}]
["14",null,"171201201R00","Uložení sypaniny na skl.-modelace na výšku přes 2m","m3",98,10,{"$f":"ROUND(F31*AE31,2)","v":0},{"$f":"J31-H31","v":980},{"$f":"ROUND(F31*G31,2)","v":980},0,{"$f":"F31*K31","v":0},null,"1",{"$f":"IF(N31=\"5\",I31,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD31=0,J31,0)","v":0},{"$f":"IF(AD31=14,J31,0)","v":0},{"$f":"IF(AD31=20,J31,0)","v":980},null,20,{"$f":"G31*0","v":0},{"$f":"G31*(1-0)","v":10}]
[null,null,"171VD","17 konstrukce ze zemin",null,null,null,{"$f":"SUM(H33:H33)","v":0},{"$f":"SUM(I33:I33)","v":11760},{"$f":"H32+I32","v":11760},null,{"$f":"SUM(L33:L33)","v":0},null,null,null,{"$f":"IF(Q32=\"PR\",J32,SUM(O33:O33))","v":0},"HS",{"$f":"IF(Q32=\"HS\",H32,0)","v":0},{"$f":"IF(Q32=\"HS\",I32-P32,0)","v":11760},{"$f":"IF(Q32=\"PS\",H32,0)","v":0},{"$f":"IF(Q32=\"PS\",I32-P32,0)","v":0},{"$f":"IF(Q32=\"MP\",H32,0)","v":0},{"$f":"IF(Q32=\"MP\",I32-P32,0)","v":0},{"$f":"IF(Q32=\"OM\",H32,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z33:Z33)","v":0},{"$f":"SUM(AA33:AA33)","v":0},{"$f":"SUM(AB33:AB33)","v":11760}]
["15",null,"171201299VD","poplatek za uložení zeminy na skládku","m3",98,120,{"$f":"ROUND(F33*AE33,2)","v":0},{"$f":"J33-H33","v":11760},{"$f":"ROUND(F33*G33,2)","v":11760},0,{"$f":"F33*K33","v":0},null,"1",{"$f":"IF(N33=\"5\",I33,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD33=0,J33,0)","v":0},{"$f":"IF(AD33=14,J33,0)","v":0},{"$f":"IF(AD33=20,J33,0)","v":11760},null,20,{"$f":"G33*0","v":0},{"$f":"G33*(1-0)","v":120}]
[null,null,"18","Povrchové úpravy terénu",null,null,null,{"$f":"SUM(H35:H37)","v":161.77000000000001},{"$f":"SUM(I35:I37)","v":12578.23},{"$f":"H34+I34","v":12740},null,{"$f":"SUM(L35:L37)","v":0},null,null,null,{"$f":"IF(Q34=\"PR\",J34,SUM(O35:O37))","v":0},"HS",{"$f":"IF(Q34=\"HS\",H34,0)","v":161.77000000000001},{"$f":"IF(Q34=\"HS\",I34-P34,0)","v":12578.23},{"$f":"IF(Q34=\"PS\",H34,0)","v":0},{"$f":"IF(Q34=\"PS\",I34-P34,0)","v":0},{"$f":"IF(Q34=\"MP\",H34,0)","v":0},{"$f":"IF(Q34=\"MP\",I34-P34,0)","v":0},{"$f":"IF(Q34=\"OM\",H34,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z35:Z37)","v":0},{"$f":"SUM(AA35:AA37)","v":0},{"$f":"SUM(AB35:AB37)","v":12740}]
["16",null,"181101102R00","Úprava pláně v zářezech v hor. 1-4, se zhutněním","m2",746,10,{"$f":"ROUND(F35*AE35,2)","v":0},{"$f":"J35-H35","v":7460},{"$f":"ROUND(F35*G35,2)","v":7460},0,{"$f":"F35*K35","v":0},null,"1",{"$f":"IF(N35=\"5\",I35,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD35=0,J35,0)","v":0},{"$f":"IF(AD35=14,J35,0)","v":0},{"$f":"IF(AD35=20,J35,0)","v":7460},null,20,{"$f":"G35*0","v":0},{"$f":"G35*(1-0)","v":10}]
["17",null,"180402111R00","Založení trávníku parkového výsevem v rovině","m2",120,15,{"$f":"ROUND(F36*AE36,2)","v":161.77000000000001},{"$f":"J36-H36","v":1638.23},{"$f":"ROUND(F36*G36,2)","v":1800},0,{"$f":"F36*K36","v":0},null,"1",{"$f":"IF(N36=\"5\",I36,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD36=0,J36,0)","v":0},{"$f":"IF(AD36=14,J36,0)","v":0},{"$f":"IF(AD36=20,J36,0)","v":1800},null,20,{"$f":"G36*0.0898725687458082","v":1.3480885311871231},{"$f":"G36*(1-0.0898725687458082)","v":13.651911468812877}]
["18",null,"181301101R00","Rozprostření ornice, rovina, tl. do 10 cm do 500m2","m2",120,29,{"$f":"ROUND(F37*AE37,2)","v":0},{"$f":"J37-H37","v":3480},{"$f":"ROUND(F37*G37,2)","v":3480},0,{"$f":"F37*K37","v":0},null,"1",{"$f":"IF(N37=\"5\",I37,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD37=0,J37,0)","v":0},{"$f":"IF(AD37=14,J37,0)","v":0},{"$f":"IF(AD37=20,J37,0)","v":3480},null,20,{"$f":"G37*0","v":0},{"$f":"G37*(1-0)","v":29}]
[null,null,"21","Úprava podloží a základové spáry",null,null,null,{"$f":"SUM(H39:H39)","v":23935.16},{"$f":"SUM(I39:I39)","v":5514.84},{"$f":"H38+I38","v":29450},null,{"$f":"SUM(L39:L39)","v":50.007999999999996},null,null,null,{"$f":"IF(Q38=\"PR\",J38,SUM(O39:O39))","v":0},"HS",{"$f":"IF(Q38=\"HS\",H38,0)","v":23935.16},{"$f":"IF(Q38=\"HS\",I38-P38,0)","v":5514.84},{"$f":"IF(Q38=\"PS\",H38,0)","v":0},{"$f":"IF(Q38=\"PS\",I38-P38,0)","v":0},{"$f":"IF(Q38=\"MP\",H38,0)","v":0},{"$f":"IF(Q38=\"MP\",I38-P38,0)","v":0},{"$f":"IF(Q38=\"OM\",H38,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z39:Z39)","v":0},{"$f":"SUM(AA39:AA39)","v":0},{"$f":"SUM(AB39:AB39)","v":29450}]
["19",null,"212752114R00","Trativody z drenážních trubek, lože, DN 210 mm","m",190,155,{"$f":"ROUND(F39*AE39,2)","v":23935.16},{"$f":"J39-H39","v":5514.84},{"$f":"ROUND(F39*G39,2)","v":29450},0.26319999999999999,{"$f":"F39*K39","v":50.007999999999996},null,"1",{"$f":"IF(N39=\"5\",I39,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD39=0,J39,0)","v":0},{"$f":"IF(AD39=14,J39,0)","v":0},{"$f":"IF(AD39=20,J39,0)","v":29450},null,20,{"$f":"G39*0.812738740339345","v":125.97450475259848},{"$f":"G39*(1-0.812738740339345)","v":29.025495247401523}]
[null,null,"212VD","212 - kanalizace",null,null,null,{"$f":"SUM(H41:H43)","v":1393.94},{"$f":"SUM(I41:I43)","v":28786.06},{"$f":"H40+I40","v":30180},null,{"$f":"SUM(L41:L43)","v":0},null,null,null,{"$f":"IF(Q40=\"PR\",J40,SUM(O41:O43))","v":0},"HS",{"$f":"IF(Q40=\"HS\",H40,0)","v":1393.94},{"$f":"IF(Q40=\"HS\",I40-P40,0)","v":28786.06},{"$f":"IF(Q40=\"PS\",H40,0)","v":0},{"$f":"IF(Q40=\"PS\",I40-P40,0)","v":0},{"$f":"IF(Q40=\"MP\",H40,0)","v":0},{"$f":"IF(Q40=\"MP\",I40-P40,0)","v":0},{"$f":"IF(Q40=\"OM\",H40,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z41:Z43)","v":0},{"$f":"SUM(AA41:AA43)","v":0},{"$f":"SUM(AB41:AB43)","v":30180}]
["20",null,"212101008VD","Napojení odvodňovacího žlabu do drenáže  DN 200","ks",8,345,{"$f":"ROUND(F41*AE41,2)","v":1393.94},{"$f":"J41-H41","v":1366.06},{"$f":"ROUND(F41*G41,2)","v":2760},0,{"$f":"F41*K41","v":0},null,"1",{"$f":"IF(N41=\"5\",I41,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD41=0,J41,0)","v":0},{"$f":"IF(AD41=14,J41,0)","v":0},{"$f":"IF(AD41=20,J41,0)","v":2760},null,20,{"$f":"G41*0.505050505050505","v":174.24242424242422},{"$f":"G41*(1-0.505050505050505)","v":170.75757575757578}]
["21",null,"212101001VD","zhotovení uliční vpusti, výkopy, D+M vč. koše na bahno, odkalovacího prostoru, sifonu , obetonování","ks",4,4860,{"$f":"ROUND(F42*AE42,2)","v":0},{"$f":"J42-H42","v":19440},{"$f":"ROUND(F42*G42,2)","v":19440},0,{"$f":"F42*K42","v":0},null,"1",{"$f":"IF(N42=\"5\",I42,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD42=0,J42,0)","v":0},{"$f":"IF(AD42=14,J42,0)","v":0},{"$f":"IF(AD42=20,J42,0)","v":19440},null,20,{"$f":"G42*0","v":0},{"$f":"G42*(1-0)","v":4860}]
["22",null,"212101002VD","přípojka UV PP DN 150 , včetně výkopů, odvozu a uložení zeminy, dodávky mat., zásypu rýhy","m",12,665,{"$f":"ROUND(F43*AE43,2)","v":0},{"$f":"J43-H43","v":7980},{"$f":"ROUND(F43*G43,2)","v":7980},0,{"$f":"F43*K43","v":0},null,"1",{"$f":"IF(N43=\"5\",I43,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD43=0,J43,0)","v":0},{"$f":"IF(AD43=14,J43,0)","v":0},{"$f":"IF(AD43=20,J43,0)","v":7980},null,20,{"$f":"G43*0","v":0},{"$f":"G43*(1-0)","v":665}]
[null,null,"56","Podkladní vrstvy komunikací a zpevněných ploch",null,null,null,{"$f":"SUM(H45:H46)","v":43134.29},{"$f":"SUM(I45:I46)","v":9240.7100000000009},{"$f":"H44+I44","v":52375},null,{"$f":"SUM(L45:L46)","v":189.00682},null,null,null,{"$f":"IF(Q44=\"PR\",J44,SUM(O45:O46))","v":0},"HS",{"$f":"IF(Q44=\"HS\",H44,0)","v":43134.29},{"$f":"IF(Q44=\"HS\",I44-P44,0)","v":9240.7100000000009},{"$f":"IF(Q44=\"PS\",H44,0)","v":0},{"$f":"IF(Q44=\"PS\",I44-P44,0)","v":0},{"$f":"IF(Q44=\"MP\",H44,0)","v":0},{"$f":"IF(Q44=\"MP\",I44-P44,0)","v":0},{"$f":"IF(Q44=\"OM\",H44,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z45:Z46)","v":0},{"$f":"SUM(AA45:AA46)","v":0},{"$f":"SUM(AB45:AB46)","v":52375}]
["23",null,"564801112R00","Podklad ze štěrkodrti po zhutnění tloušťky 4 cm - vyrovnání profilu","m2",360,25,{"$f":"ROUND(F45*AE45,2)","v":5303.4},{"$f":"J45-H45","v":3696.6000000000004},{"$f":"ROUND(F45*G45,2)","v":9000},8.0030000000000004E-2,{"$f":"F45*K45","v":28.8108},null,"1",{"$f":"IF(N45=\"5\",I45,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD45=0,J45,0)","v":0},{"$f":"IF(AD45=14,J45,0)","v":0},{"$f":"IF(AD45=20,J45,0)","v":9000},null,20,{"$f":"G45*0.589266623904212","v":14.7316655976053},{"$f":"G45*(1-0.589266623904212)","v":10.2683344023947}]
["24",null,"564871111R00","Podklad ze štěrkodrti po zhutnění tloušťky 25 cm","m2",347,125,{"$f":"ROUND(F46*AE46,2)","v":37830.89},{"$f":"J46-H46","v":5544.1100000000006},{"$f":"ROUND(F46*G46,2)","v":43375},0.46166000000000001,{"$f":"F46*K46","v":160.19602},null,"1",{"$f":"IF(N46=\"5\",I46,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD46=0,J46,0)","v":0},{"$f":"IF(AD46=14,J46,0)","v":0},{"$f":"IF(AD46=20,J46,0)","v":43375},null,20,{"$f":"G46*0.872181834913039","v":109.02272936412987},{"$f":"G46*(1-0.872181834913039)","v":15.977270635870122}]
[null,null,"59","Dlažby a předlažby pozemních komunikací a zpevněných ploch",null,null,null,{"$f":"SUM(H48:H55)","v":95183.1},{"$f":"SUM(I48:I55)","v":101120.90000000001},{"$f":"H47+I47","v":196304},null,{"$f":"SUM(L48:L55)","v":71.398323200000007},null,null,null,{"$f":"IF(Q47=\"PR\",J47,SUM(O48:O55))","v":0},"HS",{"$f":"IF(Q47=\"HS\",H47,0)","v":95183.1},{"$f":"IF(Q47=\"HS\",I47-P47,0)","v":101120.90000000001},{"$f":"IF(Q47=\"PS\",H47,0)","v":0},{"$f":"IF(Q47=\"PS\",I47-P47,0)","v":0},{"$f":"IF(Q47=\"MP\",H47,0)","v":0},{"$f":"IF(Q47=\"MP\",I47-P47,0)","v":0},{"$f":"IF(Q47=\"OM\",H47,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z48:Z55)","v":0},{"$f":"SUM(AA48:AA55)","v":0},{"$f":"SUM(AB48:AB55)","v":190864}]
["25",null,"596215021R00","Kladení zámkové dlažby tl. 6 cm do drtě tl. 4 cm","m2",564,130,{"$f":"ROUND(F48*AE48,2)","v":11756.49},{"$f":"J48-H48","v":61563.51},{"$f":"ROUND(F48*G48,2)","v":73320},7.3899999999999993E-2,{"$f":"F48*K48","v":41.679599999999994},null,"1",{"$f":"IF(N48=\"5\",I48,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD48=0,J48,0)","v":0},{"$f":"IF(AD48=14,J48,0)","v":0},{"$f":"IF(AD48=20,J48,0)","v":73320},null,20,{"$f":"G48*0.160344906664221","v":20.84483786634873},{"$f":"G48*(1-0.160344906664221)","v":109.15516213365127}]
["26",null,"596215040R00","Kladení zámkové dlažby tl. 8 cm do drtě tl. 4 cm","m2",182,140,3917.24,21562.760000000002,25480,7.3899999999999993E-2,13.449799999999998,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,25480,null,20,{"$f":"G49*0.153737906772208","v":21.52330694810912},{"$f":"G49*(1-0.153737906772208)","v":118.47669305189088}]
["27",null,"597101113R00","Montáž odvodňovacího žlabu - polymerbeton","m",44,400,10489.91,7110.09,17600,0.24146999999999999,10.62468,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,17600,null,20,{"$f":"G50*0.596017385133936","v":238.4069540535744},{"$f":"G50*(1-0.596017385133936)","v":161.5930459464256}]
["28",null,"597091111R00","Žlab odvodňovací   dl. 1000 mm","kus",40,800,{"$f":"ROUND(F51*AE51,2)","v":28559.47},{"$f":"J51-H51","v":3440.5299999999988},{"$f":"ROUND(F51*G51,2)","v":32000},9.733E-2,3.8932000000000002,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,32000,null,20,{"$f":"G51*0.892483551651644","v":713.98684132131518},{"$f":"G51*(1-0.892483551651644)","v":86.013158678684846}]
["29",null,"597091112R00","Žlab odvodňovací   dl. 500 mm","kus",8,680,{"$f":"ROUND(F52*AE52,2)","v":0},5440,{"$f":"ROUND(F52*G52,2)","v":5440},5.0860000000000002E-2,{"$f":"F52*K52","v":0.40688000000000002}]
["30",null,"597091131R00","Čelo žlabu  plné typ 0-20","kus",16,58,907.08,20.919999999999959,928,1.42E-3,2.2720000000000001E-2,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,928,null,20,{"$f":"G53*0.977454221297775","v":56.692344835270951},{"$f":"G53*(1-0.977454221297775)","v":1.3076551647290477}]
["31",null,"597091153R00","Krycí rošt  zatížení C 250 dl.500 mm","kus",88,451.2,38738.03,967.56999999999971,39705.599999999999,3.0500000000000002E-3,0.26840000000000003,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,39705.599999999999,null,20,{"$f":"G54*0.975631319220074","v":440.20485123209738},{"$f":"G54*(1-0.975631319220074)","v":10.995148767902631}]
["32",null,"596245041R00","Kladení zámkové dlažby tl. 8 cm do MC tl. 5 cm","m2",7.04,260,814.88,1015.5200000000001,1830.4,0.14957999999999999,1.0530431999999998,null,"1",0,null,null,null,null,null,null,null,null,null,null,0,0,1830.4,null,20,{"$f":"G55*0.445191425022949","v":115.74977050596674},{"$f":"G55*(1-0.445191425022949)","v":144.25022949403328}]
[null,null,"89","Ostatní konstrukce a práce na trubním vedení",null,null,null,{"$f":"H57","v":0},{"$f":"I57","v":9750},{"$f":"H56+I56","v":9750},null,{"$f":"L57","v":4.7262000000000004}]
["33",null,"899431111R00","Výšková úprava do 20 cm, zvýšení krytu šoupěte","kus",15,650,{"$f":"ROUND(F57*AE57,2)","v":0},{"$f":"J57-H57","v":9750},{"$f":"ROUND(F57*G57,2)","v":9750},0.31508000000000003,{"$f":"F57*K57","v":4.7262000000000004}]
[null,null,"91","Doplňující konstrukce a práce na pozemních komunikacích a zpevněných plochách",null,null,null,{"$f":"SUM(H59:H64)","v":31295.969999999998},{"$f":"SUM(I59:I64)","v":15284.030000000002},{"$f":"H58+I58","v":46580},null,{"$f":"SUM(L59:L64)","v":39.493540000000003},null,null,null,{"$f":"IF(Q58=\"PR\",J58,SUM(O59:O64))","v":0},"HS",{"$f":"IF(Q58=\"HS\",H58,0)","v":31295.969999999998},{"$f":"IF(Q58=\"HS\",I58-P58,0)","v":15284.030000000002},{"$f":"IF(Q58=\"PS\",H58,0)","v":0},{"$f":"IF(Q58=\"PS\",I58-P58,0)","v":0},{"$f":"IF(Q58=\"MP\",H58,0)","v":0},{"$f":"IF(Q58=\"MP\",I58-P58,0)","v":0},{"$f":"IF(Q58=\"OM\",H58,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z59:Z64)","v":0},{"$f":"SUM(AA59:AA64)","v":0},{"$f":"SUM(AB59:AB64)","v":46230}]
["34",null,"919735111R00","Řezání stávajícího živičného krytu tl. do 5 cm","m",14,40,{"$f":"ROUND(F59*AE59,2)","v":310.76},{"$f":"J59-H59","v":249.24},{"$f":"ROUND(F59*G59,2)","v":560},0,{"$f":"F59*K59","v":0},null,"1",{"$f":"IF(N59=\"5\",I59,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD59=0,J59,0)","v":0},{"$f":"IF(AD59=14,J59,0)","v":0},{"$f":"IF(AD59=20,J59,0)","v":560},null,20,{"$f":"G59*0.55493519441675","v":22.197407776669998},{"$f":"G59*(1-0.55493519441675)","v":17.802592223330002}]
["35",null,"917461111R00","Osazení stoj.obrubníků, s opěrou, lože z BP 12,5","m",14,160,1520.23,719.77,2240,0.1479,2.0706000000000002,null,"1",{"$f":"IF(N60=\"5\",I60,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD60=0,J60,0)","v":0},{"$f":"IF(AD60=14,J60,0)","v":0},{"$f":"IF(AD60=20,J60,0)","v":2240},null,20,{"$f":"G60*0.678673554100175","v":108.587768656028},{"$f":"G60*(1-0.678673554100175)","v":51.412231343971996}]
["36",null,"916261111R00","Osazení obruby z kostek drobných, s boční opěrou","m",14,95,967.38,362.62,1330,9.4200000000000006E-2,1.3188,null,"1",{"$f":"IF(N61=\"5\",I61,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD61=0,J61,0)","v":0},{"$f":"IF(AD61=14,J61,0)","v":0},{"$f":"IF(AD61=20,J61,0)","v":1330},null,20,{"$f":"G61*0.727350096711799","v":69.098259187620897},{"$f":"G61*(1-0.727350096711799)","v":25.901740812379099}]
["37",null,"917862111R00","Osazení stojat. obrub. bet. s opěrou,lože z B 12,5","m",257,160,27896.53,13223.470000000001,41120,0.13611999999999999,34.982839999999996,null,"1",{"$f":"IF(N62=\"5\",I62,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD62=0,J62,0)","v":0},{"$f":"IF(AD62=14,J62,0)","v":0},{"$f":"IF(AD62=20,J62,0)","v":41120},null,20,{"$f":"G62*0.67841762643966","v":108.54682023034559},{"$f":"G62*(1-0.67841762643966)","v":51.453179769654405}]
["38",null,"914431111R00","Osazení dopravního zrcadla na sloupek nebo konstr.","kus",1,350,0,350,350,1.0610999999999999,1.0610999999999999]
["39",null,"919721211R00","Dilatační spáry vkládané vyplněné asfalt. zálivkou","m",14,70,601.07000000000005,378.92999999999995,980,4.3E-3,6.0200000000000004E-2,null,"1",{"$f":"IF(N64=\"5\",I64,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD64=0,J64,0)","v":0},{"$f":"IF(AD64=14,J64,0)","v":0},{"$f":"IF(AD64=20,J64,0)","v":980},null,20,{"$f":"G64*0.613339662948018","v":42.933776406361261},{"$f":"G64*(1-0.613339662948018)","v":27.066223593638739}]
[null,null,"966","Ostatních stavebních konstrukcí",null,null,null,{"$f":"SUM(H66:H66)","v":0},{"$f":"SUM(I66:I66)","v":3800},{"$f":"H65+I65","v":3800},null,{"$f":"SUM(L66:L66)","v":0},null,null,null,{"$f":"IF(Q65=\"PR\",J65,SUM(O66:O66))","v":0},"HS",{"$f":"IF(Q65=\"HS\",H65,0)","v":0},{"$f":"IF(Q65=\"HS\",I65-P65,0)","v":3800},{"$f":"IF(Q65=\"PS\",H65,0)","v":0},{"$f":"IF(Q65=\"PS\",I65-P65,0)","v":0},{"$f":"IF(Q65=\"MP\",H65,0)","v":0},{"$f":"IF(Q65=\"MP\",I65-P65,0)","v":0},{"$f":"IF(Q65=\"OM\",H65,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z66:Z66)","v":0},{"$f":"SUM(AA66:AA66)","v":0},{"$f":"SUM(AB66:AB66)","v":3800}]
["40",null,"966001001VD","Bourání stávající UV, vč. odvozu suti a poplatku za skládku","ks",4,950,{"$f":"ROUND(F66*AE66,2)","v":0},{"$f":"J66-H66","v":3800},{"$f":"ROUND(F66*G66,2)","v":3800},0,{"$f":"F66*K66","v":0},null,"1",{"$f":"IF(N66=\"5\",I66,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD66=0,J66,0)","v":0},{"$f":"IF(AD66=14,J66,0)","v":0},{"$f":"IF(AD66=20,J66,0)","v":3800},null,20,{"$f":"G66*0","v":0},{"$f":"G66*(1-0)","v":950}]
[null,null,"97","Prorážení otvorů a ostatní bourací práce",null,null,null,{"$f":"SUM(H68:H70)","v":0},{"$f":"SUM(I68:I70)","v":1785.8},{"$f":"H67+I67","v":1785.8},null,{"$f":"SUM(L68:L70)","v":0},null,null,null,{"$f":"IF(Q67=\"PR\",J67,SUM(O68:O70))","v":0},"HS",{"$f":"IF(Q67=\"HS\",H67,0)","v":0},{"$f":"IF(Q67=\"HS\",I67-P67,0)","v":1785.8},{"$f":"IF(Q67=\"PS\",H67,0)","v":0},{"$f":"IF(Q67=\"PS\",I67-P67,0)","v":0},{"$f":"IF(Q67=\"MP\",H67,0)","v":0},{"$f":"IF(Q67=\"MP\",I67-P67,0)","v":0},{"$f":"IF(Q67=\"OM\",H67,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z68:Z70)","v":0},{"$f":"SUM(AA68:AA70)","v":0},{"$f":"SUM(AB68:AB70)","v":1785.8}]
["41",null,"979054441R00","Očištění vybour. dlaždic s výplní kamen. těženým","m2",39,35,{"$f":"ROUND(F68*AE68,2)","v":0},{"$f":"J68-H68","v":1365},{"$f":"ROUND(F68*G68,2)","v":1365},0,{"$f":"F68*K68","v":0},null,"1",{"$f":"IF(N68=\"5\",I68,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD68=0,J68,0)","v":0},{"$f":"IF(AD68=14,J68,0)","v":0},{"$f":"IF(AD68=20,J68,0)","v":1365},null,20,{"$f":"G68*0","v":0},{"$f":"G68*(1-0)","v":35}]
["42",null,"979024441R00","Očištění vybour. obrubníků všech loží a výplní","m",26,15,{"$f":"ROUND(F69*AE69,2)","v":0},{"$f":"J69-H69","v":390},{"$f":"ROUND(F69*G69,2)","v":390},0,{"$f":"F69*K69","v":0},null,"1",{"$f":"IF(N69=\"5\",I69,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD69=0,J69,0)","v":0},{"$f":"IF(AD69=14,J69,0)","v":0},{"$f":"IF(AD69=20,J69,0)","v":390},null,20,{"$f":"G69*0","v":0},{"$f":"G69*(1-0)","v":15}]
["43",null,"979071122R00","Očištění vybour.kostek drobných s výplní MC/živicí","m2",1.4,22,{"$f":"ROUND(F70*AE70,2)","v":0},{"$f":"J70-H70","v":30.8},{"$f":"ROUND(F70*G70,2)","v":30.8},0,{"$f":"F70*K70","v":0},null,"1",{"$f":"IF(N70=\"5\",I70,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD70=0,J70,0)","v":0},{"$f":"IF(AD70=14,J70,0)","v":0},{"$f":"IF(AD70=20,J70,0)","v":30.8},null,20,{"$f":"G70*0","v":0},{"$f":"G70*(1-0)","v":22}]
[null,null,"979VD","979 - skládka",null,null,null,{"$f":"SUM(H72:H73)","v":0},{"$f":"SUM(I72:I73)","v":21238.75},{"$f":"H71+I71","v":21238.75},null,{"$f":"SUM(L72:L73)","v":0},null,null,null,{"$f":"IF(Q71=\"PR\",J71,SUM(O72:O73))","v":0},"HS",{"$f":"IF(Q71=\"HS\",H71,0)","v":0},{"$f":"IF(Q71=\"HS\",I71-P71,0)","v":21238.75},{"$f":"IF(Q71=\"PS\",H71,0)","v":0},{"$f":"IF(Q71=\"PS\",I71-P71,0)","v":0},{"$f":"IF(Q71=\"MP\",H71,0)","v":0},{"$f":"IF(Q71=\"MP\",I71-P71,0)","v":0},{"$f":"IF(Q71=\"OM\",H71,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z72:Z73)","v":0},{"$f":"SUM(AA72:AA73)","v":0},{"$f":"SUM(AB72:AB73)","v":21238.75}]
["44",null,"979089998VD","poplatek za uložení suti na skládku","t",66.45,100,{"$f":"ROUND(F72*AE72,2)","v":0},{"$f":"J72-H72","v":6645},{"$f":"ROUND(F72*G72,2)","v":6645},0,{"$f":"F72*K72","v":0},null,"1",{"$f":"IF(N72=\"5\",I72,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD72=0,J72,0)","v":0},{"$f":"IF(AD72=14,J72,0)","v":0},{"$f":"IF(AD72=20,J72,0)","v":6645},null,20,{"$f":"G72*0","v":0},{"$f":"G72*(1-0)","v":100}]
["45",null,"979089999VD","Poplatek za uložení živice na skládku","t",116.75,125,{"$f":"ROUND(F73*AE73,2)","v":0},{"$f":"J73-H73","v":14593.75},{"$f":"ROUND(F73*G73,2)","v":14593.75},0,{"$f":"F73*K73","v":0},null,"1",{"$f":"IF(N73=\"5\",I73,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD73=0,J73,0)","v":0},{"$f":"IF(AD73=14,J73,0)","v":0},{"$f":"IF(AD73=20,J73,0)","v":14593.75},null,20,{"$f":"G73*0","v":0},{"$f":"G73*(1-0)","v":125}]
[null,null,"999VD","999 - různé",null,null,null,{"$f":"SUM(H75:H75)","v":0},{"$f":"SUM(I75:I75)","v":8000},{"$f":"H74+I74","v":8000},null,{"$f":"SUM(L75:L75)","v":0},null,null,null,{"$f":"IF(Q74=\"PR\",J74,SUM(#REF!))","v":{"$error":"#REF!"}},"HS",{"$f":"IF(Q74=\"HS\",H74,0)","v":0},{"$f":"IF(Q74=\"HS\",I74-P74,0)","v":{"$error":"#REF!"}},{"$f":"IF(Q74=\"PS\",H74,0)","v":0},{"$f":"IF(Q74=\"PS\",I74-P74,0)","v":0},{"$f":"IF(Q74=\"MP\",H74,0)","v":0},{"$f":"IF(Q74=\"MP\",I74-P74,0)","v":0},{"$f":"IF(Q74=\"OM\",H74,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
["46",null,"999001016VD","D+M silničního zábradlí v 1,1 m, vč. souvisejících prací","m",5,1600,{"$f":"ROUND(F75*AE75,2)","v":0},{"$f":"J75-H75","v":8000},{"$f":"ROUND(F75*G75,2)","v":8000},0,{"$f":"F75*K75","v":0}]
[null,null,"H22","Komunikace pozemní a letiště",null,null,null,{"$f":"SUM(H77:H77)","v":0},{"$f":"SUM(I77:I77)","v":9393},{"$f":"H76+I76","v":9393},null,{"$f":"SUM(L77:L77)","v":0},null,null,null,{"$f":"IF(Q76=\"PR\",J76,SUM(O77:O77))","v":9393},"PR",{"$f":"IF(Q76=\"HS\",H76,0)","v":0},{"$f":"IF(Q76=\"HS\",I76-P76,0)","v":0},{"$f":"IF(Q76=\"PS\",H76,0)","v":0},{"$f":"IF(Q76=\"PS\",I76-P76,0)","v":0},{"$f":"IF(Q76=\"MP\",H76,0)","v":0},{"$f":"IF(Q76=\"MP\",I76-P76,0)","v":0},{"$f":"IF(Q76=\"OM\",H76,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z77:Z77)","v":0},{"$f":"SUM(AA77:AA77)","v":0},{"$f":"SUM(AB77:AB77)","v":9393}]
["47",null,"998223011R00","Přesun hmot, pozemní komunikace, kryt dlážděný","t",{"$f":"L38+L44+L47+L56+L58+L81","v":469.64993219999997},20,{"$f":"ROUND(F77*AE77,2)","v":0},{"$f":"J77-H77","v":9393},{"$f":"ROUND(F77*G77,2)","v":9393},0,{"$f":"F77*K77","v":0},null,"5",{"$f":"IF(N77=\"5\",I77,0)","v":9393},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD77=0,J77,0)","v":0},{"$f":"IF(AD77=14,J77,0)","v":0},{"$f":"IF(AD77=20,J77,0)","v":9393},null,20,{"$f":"G77*0","v":0},{"$f":"G77*(1-0)","v":20}]
[null,null,"S","Přesuny sutí",null,null,null,{"$f":"SUM(H79:H80)","v":0},{"$f":"SUM(I79:I80)","v":21617.599999999999},{"$f":"H78+I78","v":21617.599999999999},null,{"$f":"SUM(L79:L80)","v":0},null,null,null,{"$f":"IF(Q78=\"PR\",J78,SUM(O79:O80))","v":21617.599999999999},"PR",{"$f":"IF(Q78=\"HS\",H78,0)","v":0},{"$f":"IF(Q78=\"HS\",I78-P78,0)","v":0},{"$f":"IF(Q78=\"PS\",H78,0)","v":0},{"$f":"IF(Q78=\"PS\",I78-P78,0)","v":0},{"$f":"IF(Q78=\"MP\",H78,0)","v":0},{"$f":"IF(Q78=\"MP\",I78-P78,0)","v":0},{"$f":"IF(Q78=\"OM\",H78,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z79:Z80)","v":0},{"$f":"SUM(AA79:AA80)","v":0},{"$f":"SUM(AB79:AB80)","v":21617.599999999999}]
["48",null,"979082213R00","Vodorovná doprava suti po suchu do 1 km","t",183.2,46,{"$f":"ROUND(F79*AE79,2)","v":0},{"$f":"J79-H79","v":8427.2000000000007},{"$f":"ROUND(F79*G79,2)","v":8427.2000000000007},0,{"$f":"F79*K79","v":0},null,"5",{"$f":"IF(N79=\"5\",I79,0)","v":8427.2000000000007},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD79=0,J79,0)","v":0},{"$f":"IF(AD79=14,J79,0)","v":0},{"$f":"IF(AD79=20,J79,0)","v":8427.2000000000007},null,20,{"$f":"G79*0","v":0},{"$f":"G79*(1-0)","v":46}]
["49",null,"979082219R00","Příplatek za dopravu suti po suchu za další 1 km","t",1648.8,8,{"$f":"ROUND(F80*AE80,2)","v":0},{"$f":"J80-H80","v":13190.4},{"$f":"ROUND(F80*G80,2)","v":13190.4},0,{"$f":"F80*K80","v":0},null,"5",{"$f":"IF(N80=\"5\",I80,0)","v":13190.4},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD80=0,J80,0)","v":0},{"$f":"IF(AD80=14,J80,0)","v":0},{"$f":"IF(AD80=20,J80,0)","v":13190.4},null,20,{"$f":"G80*0","v":0},{"$f":"G80*(1-0)","v":8}]
[null,null,null,"Ostatní materiál",null,null,null,{"$f":"SUM(H82:H89)","v":138504.29999999999},{"$f":"SUM(I82:I89)","v":0},{"$f":"H81+I81","v":138504.29999999999},null,{"$f":"SUM(L82:L89)","v":115.01704899999997},null,null,null,{"$f":"IF(Q81=\"PR\",J81,SUM(O82:O89))","v":0},"OM",{"$f":"IF(Q81=\"HS\",H81,0)","v":0},{"$f":"IF(Q81=\"HS\",I81-P81,0)","v":0},{"$f":"IF(Q81=\"PS\",H81,0)","v":0},{"$f":"IF(Q81=\"PS\",I81-P81,0)","v":0},{"$f":"IF(Q81=\"MP\",H81,0)","v":0},{"$f":"IF(Q81=\"MP\",I81-P81,0)","v":0},{"$f":"IF(Q81=\"OM\",H81,0)","v":138504.29999999999},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z82:Z89)","v":0},{"$f":"SUM(AA82:AA89)","v":0},{"$f":"SUM(AB82:AB89)","v":131704.29999999999}]
["50",null,"592451101VD","Dlažba betonová zámková H tl. 60 mm, přírodní","m2",534.29,120,{"$f":"ROUND(F82*AE82,2)","v":64114.8},{"$f":"J82-H82","v":0},{"$f":"ROUND(F82*G82,2)","v":64114.8},0.128,{"$f":"F82*K82","v":68.389119999999991},null,"0",{"$f":"IF(N82=\"5\",I82,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD82=0,J82,0)","v":0},{"$f":"IF(AD82=14,J82,0)","v":0},{"$f":"IF(AD82=20,J82,0)","v":64114.8},null,20,{"$f":"G82*1","v":120},{"$f":"G82*(1-1)","v":0}]
["51",null,"592451014VD","Dlažba betonová zámková  slepecká 200x100 tl. 60 mm , červená","m2",9.09,385,3499.65,0,3499.65,0.13650000000000001,1.240785,null,"0",0,null,null,null,null,null,null,null,null,null,null,0,0,3499.65,null,20,385,0]
["52",null,"592451013VD","Dlažba betonová zámková  slepecká 200x100 tl. 60 mm , přírodní","m2",10.1,334,3373.4,0,3373.4,0.13650000000000001,1.3786500000000002,null,"0",0,null,null,null,null,null,null,null,null,null,null,0,0,3373.4,null,20,334,0]
["53",null,"592451104VD","Dlažba betonová zámková  tl. 80 mm, červená","m2",145.44,240,34905.599999999999,0,34905.599999999999,0.17749999999999999,25.8156,null,"0",0,null,null,null,null,null,null,null,null,null,null,0,0,34905.599999999999,null,20,240,0]
["54",null,"592451015VD","Dlažba betonová zámková  slepecká 200x100 tl. 80 mm , přírodní","m2",18.18,400,7272,0,7272,0.18329999999999999,3.3323939999999999,null,"0",0,null,null,null,null,null,null,null,null,null,null,0,0,7272,null,20,400,0]
["55",null,"59217421","Obrubník chodníkový  14-10 1000/100/250","kus",247.45,73,18063.849999999999,0,18063.849999999999,0.06,14.847,null,"0",0,null,null,null,null,null,null,null,null,null,null,0,0,18063.849999999999,null,20,73,0]
["56",null,"40444927.A","Zrcadlo dopravní kruhové  900 mm","kus",1,6800,6800,0,6800,8.5000000000000006E-3,8.5000000000000006E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6800,0]
["57",null,"00572400","Směs travní parková I. běžná zátěž PROFI","kg",5,95,475,0,475,1E-3,5.0000000000000001E-3,null,"0",0,null,null,null,null,null,null,null,null,null,null,0,0,475,null,20,95,0]
[null,null,null,"ul. Hájkovická",null,null,null,"Celkem:",null,{"$f":"J14+J23+J28+J30+J32+J34+J38+J40+J44+J47+J56+J58+J65+J67+J71+J74+J76+J78+J81","v":705045.95},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z15:Z89)","v":0},{"$f":"SUM(AA15:AA89)","v":0},{"$f":"SUM(AB15:AB89)","v":674705.95000000007}]
[]
[]
[null,null,null,"ul. Družební km 0,212 - km 0,260"]
[null,null,"11","Přípravné a přidružené práce",null,null,null,{"$f":"SUM(H95:H99)","v":0},{"$f":"SUM(I95:I99)","v":4276},{"$f":"H94+I94","v":4276},null,{"$f":"SUM(L95:L99)","v":24.832000000000004}]
["58",null,"113106241R00","Rozebrání ploch ze silničních panelů","m2",16,36,{"$f":"ROUND(F95*AE95,2)","v":0},{"$f":"J95-H95","v":576},{"$f":"ROUND(F95*G95,2)","v":576},0.40799999999999997,{"$f":"F95*K95","v":6.5279999999999996}]
["59",null,"113107123R00","Odstranění podkladu pl. 200 m2,kam.drcené tl.30 cm","m2",28,100,{"$f":"ROUND(F96*AE96,2)","v":0},{"$f":"J96-H96","v":2800},{"$f":"ROUND(F96*G96,2)","v":2800},0.4,{"$f":"F96*K96","v":11.200000000000001}]
["60",null,"113106121R00","Rozebrání dlažeb z betonových dlaždic na sucho","m2",28,15,{"$f":"ROUND(F97*AE97,2)","v":0},{"$f":"J97-H97","v":420},{"$f":"ROUND(F97*G97,2)","v":420},0.13800000000000001,{"$f":"F97*K97","v":3.8640000000000003}]
["61",null,"113202111R00","Vytrhání obrub z krajníků nebo obrubníků stojatých","m",16,20,{"$f":"ROUND(F98*AE98,2)","v":0},{"$f":"J98-H98","v":320},{"$f":"ROUND(F98*G98,2)","v":320},0.14499999999999999,{"$f":"F98*K98","v":2.3199999999999998}]
["62",null,"113203111R00","Vytrhání obrub z dlažebních kostek","m",8,20,{"$f":"ROUND(F99*AE99,2)","v":0},{"$f":"J99-H99","v":160},{"$f":"ROUND(F99*G99,2)","v":160},0.115,{"$f":"F99*K99","v":0.92}]
[null,null,"12","Odkopávky a prokopávky",null,null,null,{"$f":"SUM(H101:H104)","v":0},{"$f":"SUM(I101:I104)","v":7977.5},{"$f":"H100+I100","v":7977.5},null,{"$f":"SUM(L101:L104)","v":0}]
["63",null,"121101101R00","Sejmutí ornice s přemístěním do 50 m","m3",5,32,{"$f":"ROUND(F101*AE101,2)","v":0},{"$f":"J101-H101","v":160},{"$f":"ROUND(F101*G101,2)","v":160},0,{"$f":"F101*K101","v":0}]
["64",null,"122201101R00","Odkopávky nezapažené v hor. 3 do 100 m3","m3",59,80,{"$f":"ROUND(F102*AE102,2)","v":0},{"$f":"J102-H102","v":4720},{"$f":"ROUND(F102*G102,2)","v":4720},0,{"$f":"F102*K102","v":0}]
["65",null,"122201109R00","Příplatek za lepivost - odkopávky v hor. 3","m3",29.5,5,{"$f":"ROUND(F103*AE103,2)","v":0},{"$f":"J103-H103","v":147.5},{"$f":"ROUND(F103*G103,2)","v":147.5},0,{"$f":"F103*K103","v":0}]
["66",null,"120001101R00","Příplatek za ztížení vykopávky v blízkosti vedení","m3",11.8,250,{"$f":"ROUND(F104*AE104,2)","v":0},{"$f":"J104-H104","v":2950},{"$f":"ROUND(F104*G104,2)","v":2950},0,{"$f":"F104*K104","v":0}]
[null,null,"16","Přemístění výkopku",null,null,null,{"$f":"SUM(H106:H106)","v":0},{"$f":"SUM(I106:I106)","v":9300},{"$f":"H105+I105","v":9300},null,{"$f":"SUM(L106:L106)","v":0}]
["67",null,"162701105R00","Vodorovné přemístění výkopku z hor.1-4 do 10000 m","m3",62,150,{"$f":"ROUND(F106*AE106,2)","v":0},{"$f":"J106-H106","v":9300},{"$f":"ROUND(F106*G106,2)","v":9300},0,{"$f":"F106*K106","v":0}]
[null,null,"17","Konstrukce ze zemin",null,null,null,{"$f":"SUM(H108:H109)","v":0},{"$f":"SUM(I108:I109)","v":1920},{"$f":"H107+I107","v":1920},null,{"$f":"SUM(L108:L109)","v":10}]
["68",null,"171201201R00","Uložení sypaniny na skl.-modelace na výšku přes 2m","m3",62,10,{"$f":"ROUND(F108*AE108,2)","v":0},{"$f":"J108-H108","v":620},{"$f":"ROUND(F108*G108,2)","v":620},0,{"$f":"F108*K108","v":0}]
["69",null,"171102105R00","Uložení sypaniny do násypů, zhutn, na 103% PS","m3",10,130,{"$f":"ROUND(F109*AE109,2)","v":0},{"$f":"J109-H109","v":1300},{"$f":"ROUND(F109*G109,2)","v":1300},1,{"$f":"F109*K109","v":10}]
[null,null,"171VD","17 konstrukce ze zemin",null,null,null,{"$f":"SUM(H111:H111)","v":0},{"$f":"SUM(I111:I111)","v":7440},{"$f":"H110+I110","v":7440},null,{"$f":"SUM(L111:L111)","v":0}]
["70",null,"171201299VD","poplatek za uložení zeminy na skládku","m3",62,120,{"$f":"ROUND(F111*AE111,2)","v":0},{"$f":"J111-H111","v":7440},{"$f":"ROUND(F111*G111,2)","v":7440},0,{"$f":"F111*K111","v":0}]
[null,null,"18","Povrchové úpravy terénu",null,null,null,{"$f":"SUM(H113:H115)","v":0},{"$f":"SUM(I113:I115)","v":2620},{"$f":"H112+I112","v":2620},null,{"$f":"SUM(L113:L115)","v":0}]
["71",null,"181101102R00","Úprava pláně v zářezech v hor. 1-4, se zhutněním","m2",174,10,{"$f":"ROUND(F113*AE113,2)","v":0},{"$f":"J113-H113","v":1740},{"$f":"ROUND(F113*G113,2)","v":1740},0,{"$f":"F113*K113","v":0}]
["72",null,"180402111R00","Založení trávníku parkového výsevem v rovině","m2",20,15,{"$f":"ROUND(F114*AE114,2)","v":0},{"$f":"J114-H114","v":300},{"$f":"ROUND(F114*G114,2)","v":300},0,{"$f":"F114*K114","v":0}]
["73",null,"181301101R00","Rozprostření ornice, rovina, tl. do 10 cm do 500m2","m2",20,29,{"$f":"ROUND(F115*AE115,2)","v":0},{"$f":"J115-H115","v":580},{"$f":"ROUND(F115*G115,2)","v":580},0,{"$f":"F115*K115","v":0}]
[null,null,"21","Úprava podloží a základové spáry",null,null,null,{"$f":"SUM(H117:H117)","v":0},{"$f":"SUM(I117:I117)","v":7750},{"$f":"H116+I116","v":7750},null,{"$f":"SUM(L117:L117)","v":13.16}]
["74",null,"212752114R00","Trativody z drenážních trubek, lože, DN 210 mm","m",50,155,{"$f":"ROUND(F117*AE117,2)","v":0},{"$f":"J117-H117","v":7750},{"$f":"ROUND(F117*G117,2)","v":7750},0.26319999999999999,{"$f":"F117*K117","v":13.16}]
[null,null,"212VD","212 - kanalizace",null,null,null,{"$f":"SUM(H119:H119)","v":0},{"$f":"SUM(I119:I119)","v":690},{"$f":"H118+I118","v":690},null,{"$f":"SUM(L119:L119)","v":0}]
["75",null,"212101008VD","Napojení odvodňovacího žlabu do drenáže  DN 200","ks",2,345,{"$f":"ROUND(F119*AE119,2)","v":0},{"$f":"J119-H119","v":690},{"$f":"ROUND(F119*G119,2)","v":690},0,{"$f":"F119*K119","v":0}]
[null,null,"56","Podkladní vrstvy komunikací a zpevněných ploch",null,null,null,{"$f":"SUM(H121:H121)","v":0},{"$f":"SUM(I121:I121)","v":19750},{"$f":"H120+I120","v":19750},null,{"$f":"SUM(L121:L121)","v":72.942279999999997}]
["76",null,"564871111R00","Podklad ze štěrkodrti po zhutnění tloušťky 25 cm","m2",158,125,{"$f":"ROUND(F121*AE121,2)","v":0},{"$f":"J121-H121","v":19750},{"$f":"ROUND(F121*G121,2)","v":19750},0.46166000000000001,{"$f":"F121*K121","v":72.942279999999997}]
[null,null,"59","Dlažby a předlažby pozemních komunikací a zpevněných ploch",null,null,null,{"$f":"SUM(H123:H130)","v":0},{"$f":"SUM(I123:I130)","v":43208},{"$f":"H122+I122","v":43208},null,{"$f":"SUM(L123:L130)","v":16.1881652}]
["77",null,"596215021R00","Kladení zámkové dlažby tl. 6 cm do drtě tl. 4 cm","m2",124,130,{"$f":"ROUND(F123*AE123,2)","v":0},{"$f":"J123-H123","v":16120},{"$f":"ROUND(F123*G123,2)","v":16120},7.3899999999999993E-2,{"$f":"F123*K123","v":9.1635999999999989}]
["78",null,"596215040R00","Kladení zámkové dlažby tl. 8 cm do drtě tl. 4 cm","m2",50,140,0,7000,7000,7.3899999999999993E-2,3.6949999999999998]
["79",null,"597101113R00","Montáž odvodňovacího žlabu - polymerbeton","m",9,400,0,3600,3600,0.24146999999999999,2.1732299999999998]
["80",null,"597091111R00","Žlab odvodňovací  dl. 1000 mm","kus",8,800,0,6400,6400,9.733E-2,0.77864]
["81",null,"597091112R00","Žlab odvodňovací  dl. 500 mm","kus",2,680,0,1360,1360,5.0860000000000002E-2,0.10172]
["82",null,"597091131R00","Čelo žlabu  plné typ 0-20","kus",4,58,0,232,232,1.42E-3,5.6800000000000002E-3]
["83",null,"597091153R00","Krycí rošt  zatížení C 250 dl.500 mm","kus",18,451.2,0,8121.6,8121.6,3.0500000000000002E-3,5.4900000000000004E-2]
["84",null,"596245041R00","Kladení zámkové dlažby tl. 8 cm do MC tl. 5 cm","m2",1.44,260,0,374.4,374.4,0.14957999999999999,0.21539519999999998]
[null,null,"89","Ostatní konstrukce a práce na trubním vedení",null,null,null,{"$f":"H132","v":0},{"$f":"I132","v":3250},{"$f":"H131+I131","v":3250},null,{"$f":"L132","v":1.5754000000000001}]
["85",null,"899431111R00","Výšková úprava do 20 cm, zvýšení krytu šoupěte","kus",5,650,{"$f":"ROUND(F132*AE132,2)","v":0},{"$f":"J132-H132","v":3250},{"$f":"ROUND(F132*G132,2)","v":3250},0.31508000000000003,1.5754000000000001]
[null,null,"91","Doplňující konstrukce a práce na pozemních komunikacích a zpevněných plochách",null,null,null,{"$f":"SUM(H134:H139)","v":0},{"$f":"SUM(I134:I139)","v":39620},{"$f":"H133+I133","v":39620},null,{"$f":"SUM(L134:L139)","v":25.978600000000004}]
["86",null,"919735111R00","Řezání stávajícího živičného krytu tl. do 5 cm","m",58,40,{"$f":"ROUND(F134*AE134,2)","v":0},{"$f":"J134-H134","v":2320},{"$f":"ROUND(F134*G134,2)","v":2320},0,{"$f":"F134*K134","v":0}]
["87",null,"917461111R00","Osazení stoj.obrubníků, s opěrou, lože z BP 12,5","m",64,160,0,10240,10240,0.1479,9.4656000000000002]
["88",null,"916261111R00","Osazení obruby z kostek drobných, s boční opěrou","m",64,95,0,6080,6080,9.4200000000000006E-2,6.0288000000000004]
["89",null,"917862111R00","Osazení stojat. obrub. bet. s opěrou,lože z B 12,5","m",75,160,0,12000,12000,0.13611999999999999,10.209]
["90",null,"999001032VD","D+M schody ze zámkové dlažby, stupně obruba BO 10/25","soub",1,4500,0,4500,4500,0,0]
["91",null,"919721211R00","Dilatační spáry vkládané vyplněné asfalt. zálivkou","m",64,70,0,4480,4480,4.3E-3,0.2752]
[null,null,"97","Prorážení otvorů a ostatní bourací práce",null,null,null,{"$f":"SUM(H141:H143)","v":0},{"$f":"SUM(I141:I143)","v":817.6},{"$f":"H140+I140","v":817.6},null,{"$f":"SUM(L141:L143)","v":0}]
["92",null,"979054441R00","Očištění vybour. dlaždic s výplní kamen. těženým","m2",16,35,{"$f":"ROUND(F141*AE141,2)","v":0},{"$f":"J141-H141","v":560},{"$f":"ROUND(F141*G141,2)","v":560},0,{"$f":"F141*K141","v":0}]
["93",null,"979024441R00","Očištění vybour. obrubníků všech loží a výplní","m",16,15,{"$f":"ROUND(F142*AE142,2)","v":0},{"$f":"J142-H142","v":240},{"$f":"ROUND(F142*G142,2)","v":240},0,{"$f":"F142*K142","v":0}]
["94",null,"979071122R00","Očištění vybour.kostek drobných s výplní MC/živicí","m2",0.8,22,{"$f":"ROUND(F143*AE143,2)","v":0},{"$f":"J143-H143","v":17.600000000000001},{"$f":"ROUND(F143*G143,2)","v":17.600000000000001},0,{"$f":"F143*K143","v":0}]
[null,null,"979VD","979 - skládka",null,null,null,{"$f":"SUM(H145:H145)","v":0},{"$f":"SUM(I145:I145)","v":2483},{"$f":"H144+I144","v":2483},null,{"$f":"SUM(L145:L145)","v":0}]
["95",null,"979089998VD","poplatek za uložení suti na skládku","t",24.83,100,{"$f":"ROUND(F145*AE145,2)","v":0},{"$f":"J145-H145","v":2483},{"$f":"ROUND(F145*G145,2)","v":2483},0,{"$f":"F145*K145","v":0}]
[null,null,"999VD","999 - různé",null,null,null,{"$f":"SUM(H147:H147)","v":0},{"$f":"SUM(I147:I147)","v":3680},{"$f":"H146+I146","v":3680},null,{"$f":"SUM(L147:L147)","v":0}]
["96",null,"999001016VD","D+M  zábradlí v 1,1 m, vč. souvisejících prací","m",2.2999999999999998,1600,{"$f":"ROUND(F147*AE147,2)","v":0},{"$f":"J147-H147","v":3680},{"$f":"ROUND(F147*G147,2)","v":3680},0,{"$f":"F147*K147","v":0}]
[null,null,"H22","Komunikace pozemní a letiště",null,null,null,{"$f":"SUM(H149:H149)","v":0},{"$f":"SUM(I149:I149)","v":3825.02},{"$f":"H148+I148","v":3825.02},null,{"$f":"SUM(L149:L149)","v":0}]
["97",null,"998223011R00","Přesun hmot, pozemní komunikace, kryt dlážděný","t",{"$f":"L107+L116+L120+L122+L131+L133+L153","v":191.25111820000001},20,{"$f":"ROUND(F149*AE149,2)","v":0},{"$f":"J149-H149","v":3825.02},{"$f":"ROUND(F149*G149,2)","v":3825.02},0,{"$f":"F149*K149","v":0}]
[null,null,"S","Přesuny sutí",null,null,null,{"$f":"SUM(H151:H152)","v":0},{"$f":"SUM(I151:I152)","v":2929.94},{"$f":"H150+I150","v":2929.94},null,{"$f":"SUM(L151:L152)","v":0}]
["98",null,"979082213R00","Vodorovná doprava suti po suchu do 1 km","t",24.83,46,{"$f":"ROUND(F151*AE151,2)","v":0},{"$f":"J151-H151","v":1142.18},{"$f":"ROUND(F151*G151,2)","v":1142.18},0,{"$f":"F151*K151","v":0}]
["99",null,"979082219R00","Příplatek za dopravu suti po suchu za další 1 km","t",223.47,8,{"$f":"ROUND(F152*AE152,2)","v":0},{"$f":"J152-H152","v":1787.76},{"$f":"ROUND(F152*G152,2)","v":1787.76},0,{"$f":"F152*K152","v":0}]
[null,null,null,"Ostatní materiál",null,null,null,{"$f":"SUM(H154:H162)","v":67658.02},{"$f":"SUM(I154:I162)","v":0},{"$f":"H153+I153","v":67658.02},null,{"$f":"SUM(L154:L162)","v":51.406672999999998}]
["100",null,"592451101VD","Dlažba betonová zámková tl. 60 mm, přírodní","m2",105.04,120,{"$f":"F154*G154","v":12604.800000000001},{"$f":"J154-H154","v":0},{"$f":"ROUND(F154*G154,2)","v":12604.8},0.128,{"$f":"F154*K154","v":13.445120000000001}]
["101",null,"592451014VD","Dlažba betonová zámková  slepecká 200x100 tl. 60 mm , červená","m2",7.07,385,{"$f":"F155*G155","v":2721.9500000000003},0,2721.95,0.13650000000000001,0.96505500000000011]
["102",null,"592451104VD","Dlažba betonová zámková  tl. 80 mm, červená","m2",44.44,334,14842.96,0,14842.96,0.17749999999999999,7.8880999999999988]
["103",null,"592451015VD","Dlažba betonová zámková  slepecká 200x100 tl. 80 mm , přírodní","m2",6.06,240,1454.3999999999999,0,1454.4,0.18329999999999999,1.110798]
["104",null,"59217421","Obrubník chodníkový  14-10 1000/100/250","kus",67.67,73,4939.91,0,4939.91,0.06,4.0602]
["105",null,"58380211","Krajník silniční  KS 3 13x20x30 až 80 cm","m",56.56,400,22624,0,22624,6.5000000000000002E-2,3.6764000000000001]
["106",null,"58380120","Kostka dlažební drobná 8/10  tř.1","t",1.26,2500,3150,0,{"$f":"ROUND(F160*G160,2)","v":3150},1,{"$f":"F160*K160","v":1.26}]
["107",null,"583419023","Kamenivo drcené frakce  32/63 B Moravskosl. kraj","t",19,275,5225,0,{"$f":"ROUND(F161*G161,2)","v":5225},1,{"$f":"F161*K161","v":19}]
["108",null,"00572400","Směs travní parková I. běžná zátěž PROFI","kg",1,95,95,0,95,1E-3,1E-3]
[null,null,null,"u. Družební km 0,212 - km 0,260",null,null,null,"Celkem:",null,{"$f":"J94+J100+J105+J107+J110+J112+J116+J118+J120+J122+J131+J133+J140+J144+J146+J148+J150+J153","v":229195.08000000002}]
[]
[]
[null,null,null,"ul. Družební km 0,260 - km 0,317"]
[null,null,"11","Přípravné a přidružené práce",null,null,null,{"$f":"SUM(H168:H171)","v":0},{"$f":"SUM(I168:I171)","v":10680},{"$f":"H167+I167","v":10680},null,{"$f":"SUM(L168:L171)","v":33.480000000000004}]
["109",null,"113107131R00","Odstranění podkladu pl.200 m2, bet.prostý tl.15 cm","m2",21,120,{"$f":"ROUND(F168*AE168,2)","v":0},{"$f":"J168-H168","v":2520},{"$f":"ROUND(F168*G168,2)","v":2520},0.22500000000000001,{"$f":"F168*K168","v":4.7250000000000005}]
["110",null,"113107141R00","Odstranění podkladu pl. do 200 m2, živice tl. 5 cm","m2",40,50,{"$f":"ROUND(F169*AE169,2)","v":0},{"$f":"J169-H169","v":2000},{"$f":"ROUND(F169*G169,2)","v":2000},9.8000000000000004E-2,{"$f":"F169*K169","v":3.92}]
["111",null,"113107123R00","Odstranění podkladu pl. 200 m2,kam.drcené tl.30 cm","m2",61,100,{"$f":"ROUND(F170*AE170,2)","v":0},{"$f":"J170-H170","v":6100},{"$f":"ROUND(F170*G170,2)","v":6100},0.4,{"$f":"F170*K170","v":24.400000000000002}]
["112",null,"113202111R00","Vytrhání obrub z krajníků nebo obrubníků stojatých","m",3,20,{"$f":"ROUND(F171*AE171,2)","v":0},{"$f":"J171-H171","v":60},{"$f":"ROUND(F171*G171,2)","v":60},0.14499999999999999,{"$f":"F171*K171","v":0.43499999999999994}]
[null,null,"12","Odkopávky a prokopávky",null,null,null,{"$f":"SUM(H173:H175)","v":0},{"$f":"SUM(I173:I175)","v":7950},{"$f":"H172+I172","v":7950},null,{"$f":"SUM(L173:L175)","v":0}]
["113",null,"122201101R00","Odkopávky nezapažené v hor. 3 do 100 m3","m3",60,80,{"$f":"ROUND(F173*AE173,2)","v":0},{"$f":"J173-H173","v":4800},{"$f":"ROUND(F173*G173,2)","v":4800},0,{"$f":"F173*K173","v":0}]
["114",null,"122201109R00","Příplatek za lepivost - odkopávky v hor. 3","m3",30,5,{"$f":"ROUND(F174*AE174,2)","v":0},{"$f":"J174-H174","v":150},{"$f":"ROUND(F174*G174,2)","v":150},0,{"$f":"F174*K174","v":0}]
["115",null,"120001101R00","Příplatek za ztížení vykopávky v blízkosti vedení","m3",12,250,{"$f":"ROUND(F175*AE175,2)","v":0},{"$f":"J175-H175","v":3000},{"$f":"ROUND(F175*G175,2)","v":3000},0,{"$f":"F175*K175","v":0}]
[null,null,"16","Přemístění výkopku",null,null,null,{"$f":"SUM(H177:H177)","v":0},{"$f":"SUM(I177:I177)","v":9000},{"$f":"H176+I176","v":9000},null,{"$f":"SUM(L177:L177)","v":0}]
["116",null,"162701105R00","Vodorovné přemístění výkopku z hor.1-4 do 10000 m","m3",60,150,{"$f":"ROUND(F177*AE177,2)","v":0},{"$f":"J177-H177","v":9000},{"$f":"ROUND(F177*G177,2)","v":9000},0,{"$f":"F177*K177","v":0}]
[null,null,"17","Konstrukce ze zemin",null,null,null,{"$f":"SUM(H179:H179)","v":0},{"$f":"SUM(I179:I179)","v":600},{"$f":"H178+I178","v":600},null,{"$f":"SUM(L179:L179)","v":0}]
["117",null,"171201201R00","Uložení sypaniny na skl.-modelace na výšku přes 2m","m3",60,10,{"$f":"ROUND(F179*AE179,2)","v":0},{"$f":"J179-H179","v":600},{"$f":"ROUND(F179*G179,2)","v":600},0,{"$f":"F179*K179","v":0}]
[null,null,"171VD","17 konstrukce ze zemin",null,null,null,{"$f":"SUM(H181:H181)","v":0},{"$f":"SUM(I181:I181)","v":7200},{"$f":"H180+I180","v":7200},null,{"$f":"SUM(L181:L181)","v":0}]
["118",null,"171201299VD","poplatek za uložení zeminy na skládku","m3",60,120,{"$f":"ROUND(F181*AE181,2)","v":0},{"$f":"J181-H181","v":7200},{"$f":"ROUND(F181*G181,2)","v":7200},0,{"$f":"F181*K181","v":0}]
[null,null,"18","Povrchové úpravy terénu",null,null,null,{"$f":"SUM(H183:H183)","v":0},{"$f":"SUM(I183:I183)","v":1690},{"$f":"H182+I182","v":1690},null,{"$f":"SUM(L183:L183)","v":0}]
["119",null,"181101102R00","Úprava pláně v zářezech v hor. 1-4, se zhutněním","m2",169,10,{"$f":"ROUND(F183*AE183,2)","v":0},{"$f":"J183-H183","v":1690},{"$f":"ROUND(F183*G183,2)","v":1690},0,{"$f":"F183*K183","v":0}]
[null,null,"21","Úprava podloží a základové spáry",null,null,null,{"$f":"SUM(H185:H185)","v":0},{"$f":"SUM(I185:I185)","v":8835},{"$f":"H184+I184","v":8835},null,{"$f":"SUM(L185:L185)","v":15.0024}]
["120",null,"212752114R00","Trativody z drenážních trubek, lože, DN 210 mm","m",57,155,{"$f":"ROUND(F185*AE185,2)","v":0},{"$f":"J185-H185","v":8835},{"$f":"ROUND(F185*G185,2)","v":8835},0.26319999999999999,{"$f":"F185*K185","v":15.0024}]
[null,null,"212VD","212 - kanalizace",null,null,null,{"$f":"SUM(H187:H187)","v":0},{"$f":"SUM(I187:I187)","v":690},{"$f":"H186+I186","v":690},null,{"$f":"SUM(L187:L187)","v":0}]
["121",null,"212101008VD","Napojení odvodňovacího žlabu do drenáže  DN 200","ks",2,345,{"$f":"ROUND(F187*AE187,2)","v":0},{"$f":"J187-H187","v":690},{"$f":"ROUND(F187*G187,2)","v":690},0,{"$f":"F187*K187","v":0}]
[null,null,"56","Podkladní vrstvy komunikací a zpevněných ploch",null,null,null,{"$f":"SUM(H189:H189)","v":0},{"$f":"SUM(I189:I189)","v":21125},{"$f":"H188+I188","v":21125},null,{"$f":"SUM(L189:L189)","v":78.020539999999997}]
["122",null,"564871111R00","Podklad ze štěrkodrti po zhutnění tloušťky 25 cm","m2",169,125,{"$f":"ROUND(F189*AE189,2)","v":0},{"$f":"J189-H189","v":21125},{"$f":"ROUND(F189*G189,2)","v":21125},0.46166000000000001,{"$f":"F189*K189","v":78.020539999999997}]
[null,null,"59","Dlažby a předlažby pozemních komunikací a zpevněných ploch",null,null,null,{"$f":"SUM(H191:H198)","v":0},{"$f":"SUM(I191:I198)","v":53388},{"$f":"H190+I190","v":53388},null,{"$f":"SUM(L191:L198)","v":17.662829200000001}]
["123",null,"596215021R00","Kladení zámkové dlažby tl. 6 cm do drtě tl. 4 cm","m2",108,130,{"$f":"ROUND(F191*AE191,2)","v":0},{"$f":"J191-H191","v":14040},{"$f":"ROUND(F191*G191,2)","v":14040},7.3899999999999993E-2,{"$f":"F191*K191","v":7.9811999999999994}]
["124",null,"596215040R00","Kladení zámkové dlažby tl. 8 cm do drtě tl. 4 cm","m2",61,140,0,8540,8540,7.3899999999999993E-2,4.5078999999999994]
["125",null,"597101113R00","Montáž odvodňovacího žlabu - polymerbeton","m",14,400,0,5600,5600,0.24146999999999999,3.3805799999999997]
["126",null,"597091111R00","Žlab odvodňovací  dl. 1000 mm","kus",13,800,0,10400,10400,9.733E-2,1.26529]
["127",null,"597091112R00","Žlab odvodňovací  dl. 500 mm","kus",2,680,0,1360,1360,5.0860000000000002E-2,0.10172]
["128",null,"597091131R00","Čelo žlabu  plné typ 0-20","kus",4,58,0,232,232,1.42E-3,5.6800000000000002E-3]
["129",null,"597091153R00","Krycí rošt  zatížení C 250 dl.500 mm","kus",28,451.2,0,12633.6,12633.6,3.0500000000000002E-3,8.5400000000000004E-2]
["130",null,"596245041R00","Kladení zámkové dlažby tl. 8 cm do MC tl. 5 cm","m2",2.2400000000000002,260,0,582.4,582.4,0.14957999999999999,0.3350592]
[null,null,"89","Ostatní konstrukce a práce na trubním vedení",null,null,null,{"$f":"H200","v":0},{"$f":"I200","v":3250},{"$f":"H199+I199","v":3250},null,{"$f":"L200","v":1.5754000000000001}]
["131",null,"899431111R00","Výšková úprava do 20 cm, zvýšení krytu šoupěte","kus",5,650,{"$f":"ROUND(F200*AE200,2)","v":0},{"$f":"J200-H200","v":3250},{"$f":"ROUND(F200*G200,2)","v":3250},0.31508000000000003,{"$f":"F200*K200","v":1.5754000000000001}]
[null,null,"91","Doplňující konstrukce a práce na pozemních komunikacích a zpevněných plochách",null,null,null,{"$f":"SUM(H202:H206)","v":0},{"$f":"SUM(I202:I206)","v":31845},{"$f":"H201+I201","v":31845},null,{"$f":"SUM(L202:L206)","v":23.437080000000002}]
["132",null,"919735111R00","Řezání stávajícího živičného krytu tl. do 5 cm","m",57,40,{"$f":"ROUND(F202*AE202,2)","v":0},{"$f":"J202-H202","v":2280},{"$f":"ROUND(F202*G202,2)","v":2280},0,{"$f":"F202*K202","v":0}]
["133",null,"917461111R00","Osazení stoj.obrubníků, s opěrou, lože z BP 12,5","m",57,160,{"$f":"ROUND(F203*AE203,2)","v":0},{"$f":"J203-H203","v":9120},{"$f":"ROUND(F203*G203,2)","v":9120},0.1479,{"$f":"F203*K203","v":8.4303000000000008}]
["134",null,"916261111R00","Osazení obruby z kostek drobných, s boční opěrou","m",57,95,{"$f":"ROUND(F204*AE204,2)","v":0},{"$f":"J204-H204","v":5415},{"$f":"ROUND(F204*G204,2)","v":5415},9.4200000000000006E-2,{"$f":"F204*K204","v":5.3694000000000006}]
["135",null,"917862111R00","Osazení stojat. obrub. bet. s opěrou,lože z B 12,5","m",69,160,{"$f":"ROUND(F205*AE205,2)","v":0},{"$f":"J205-H205","v":11040},{"$f":"ROUND(F205*G205,2)","v":11040},0.13611999999999999,{"$f":"F205*K205","v":9.3922799999999995}]
["136",null,"919721211R00","Dilatační spáry vkládané vyplněné asfalt. zálivkou","m",57,70,{"$f":"ROUND(F206*AE206,2)","v":0},{"$f":"J206-H206","v":3990},{"$f":"ROUND(F206*G206,2)","v":3990},4.3E-3,{"$f":"F206*K206","v":0.24510000000000001}]
[null,null,"979VD","979 - skládka",null,null,null,{"$f":"SUM(H208:H209)","v":0},{"$f":"SUM(I208:I209)","v":3446},{"$f":"H207+I207","v":3446},null,{"$f":"SUM(L208:L209)","v":0}]
["137",null,"979089998VD","poplatek za uložení suti na skládku","t",29.56,100,{"$f":"ROUND(F208*AE208,2)","v":0},{"$f":"J208-H208","v":2956},{"$f":"ROUND(F208*G208,2)","v":2956},0,{"$f":"F208*K208","v":0}]
["138",null,"979089999VD","Poplatek za uložení živice na skládku","t",3.92,125,{"$f":"ROUND(F209*AE209,2)","v":0},{"$f":"J209-H209","v":490},{"$f":"ROUND(F209*G209,2)","v":490},0,{"$f":"F209*K209","v":0}]
[null,null,"H22","Komunikace pozemní a letiště",null,null,null,{"$f":"SUM(H211:H211)","v":0},{"$f":"SUM(I211:I211)","v":3365.93},{"$f":"H210+I210","v":3365.93},null,{"$f":"SUM(L211:L211)","v":0}]
["139",null,"998223011R00","Přesun hmot, pozemní komunikace, kryt dlážděný","t",{"$f":"L184+L188+L190+L201+L215","v":168.29673220000001},20,{"$f":"ROUND(F211*AE211,2)","v":0},{"$f":"J211-H211","v":3365.93},{"$f":"ROUND(F211*G211,2)","v":3365.93},0,{"$f":"F211*K211","v":0}]
[null,null,"S","Přesuny sutí",null,null,null,{"$f":"SUM(H213:H214)","v":0},{"$f":"SUM(I213:I214)","v":3950.64},{"$f":"H212+I212","v":3950.64},null,{"$f":"SUM(L213:L214)","v":0}]
["140",null,"979082213R00","Vodorovná doprava suti po suchu do 1 km","t",33.479999999999997,46,{"$f":"ROUND(F213*AE213,2)","v":0},{"$f":"J213-H213","v":1540.08},{"$f":"ROUND(F213*G213,2)","v":1540.08},0,{"$f":"F213*K213","v":0}]
["141",null,"979082219R00","Příplatek za dopravu suti po suchu za další 1 km","t",301.32,8,{"$f":"ROUND(F214*AE214,2)","v":0},{"$f":"J214-H214","v":2410.56},{"$f":"ROUND(F214*G214,2)","v":2410.56},0,{"$f":"F214*K214","v":0}]
[null,null,null,"Ostatní materiál",null,null,null,{"$f":"SUM(H216:H223)","v":61722.360000000008},{"$f":"SUM(I216:I223)","v":0},{"$f":"H215+I215","v":61722.360000000008},null,{"$f":"SUM(L216:L223)","v":34.173883000000004}]
["142",null,"592451101VD","Dlažba betonová zámková  tl. 60 mm, červená","m2",83.62,120,{"$f":"F216*G216","v":10034.400000000001},{"$f":"J216-H216","v":0},{"$f":"ROUND(F216*G216,2)","v":10034.4},0.128,{"$f":"F216*K216","v":10.70336}]
["143",null,"592451013VD","Dlažba betonová zámková  slepecká 200x100 tl. 60 mm , přírodní","m2",2.4,385,{"$f":"F217*G217","v":924},0,924,0.13650000000000001,0.3276]
["144",null,"592451104VD","Dlažba betonová zámková H- Profil MARKET tl. 80 mm, červená","m2",55.95,248,13875.6,0,13875.6,0.17749999999999999,9.9311249999999998]
["145",null,"592451015VD","Dlažba betonová zámková  slepecká 200x100 tl. 80 mm , přírodní","m2",5.66,240,1358.4,0,1358.4,0.18329999999999999,1.0374779999999999]
["146",null,"592451002","Dlažba betonová zámková  200x200 tl. 60 mm , písková","m2",23.03,233,5365.9900000000007,{"$f":"J220-H220","v":0},{"$f":"ROUND(F220*G220,2)","v":5365.99},0.129,{"$f":"F220*K220","v":2.9708700000000001}]
["147",null,"58380211","Krajník silniční  KS 3 13x20x30 až 80 cm","m",57.57,380,21876.6,{"$f":"J221-H221","v":0},{"$f":"ROUND(F221*G221,2)","v":21876.6},6.5000000000000002E-2,{"$f":"F221*K221","v":3.7420500000000003}]
["148",null,"58380120","Kostka dlažební drobná 8/10  tř.1","t",1.28,2500,3200,{"$f":"J222-H222","v":0},{"$f":"ROUND(F222*G222,2)","v":3200},1,{"$f":"F222*K222","v":1.28}]
["149",null,"59217421","Obrubník chodníkový ABO 14-10 1000/100/250","kus",69.69,73,5087.37,0,5087.37,0.06,4.1814]
[null,null,null,"ul. Družební km 0,260 - km 0,317",null,null,null,"Celkem:",null,{"$f":"J167+J172+J176+J178+J180+J182+J184+J186+J188+J190+J199+J201+J207+J210+J212+J215","v":228737.93000000002}]
[]
[]
[null,null,null,"Společné položky"]
[null,null,"11","Přípravné a přidružené práce",null,null,null,{"$f":"SUM(H229:H232)","v":0},{"$f":"SUM(I229:I232)","v":39497},{"$f":"H228+I228","v":39497},null,{"$f":"SUM(L229:L232)","v":2.9509000000000003}]
["150",null,"999001002VD","D+M chránička PVC DN 160 2x- OVANET","m",72,135,{"$f":"ROUND(F229*AE229,2)","v":0},{"$f":"J229-H229","v":9720},{"$f":"ROUND(F229*G229,2)","v":9720},0,{"$f":"F229*K229","v":0}]
["151",null,"914001111R00","Montáž svislých dopr.značek na sloupky, konzoly","kus",11,748,{"$f":"ROUND(F230*AE230,2)","v":0},{"$f":"J230-H230","v":8228},{"$f":"ROUND(F230*G230,2)","v":8228},0.24590000000000001,{"$f":"F230*K230","v":2.7049000000000003}]
["152",null,"913001111VD","piktogram DZ, symboly šipka, kolo, chodec","ks",58,363,{"$f":"ROUND(F231*AE231,2)","v":0},{"$f":"J231-H231","v":21054},{"$f":"ROUND(F231*G231,2)","v":21054},0,{"$f":"F231*K231","v":0}]
["153",null,"966006132R00","Odstranění doprav.značek se sloupky, s bet.patkami","kus",3,165,{"$f":"ROUND(F232*AE232,2)","v":0},{"$f":"J232-H232","v":495},{"$f":"ROUND(F232*G232,2)","v":495},8.2000000000000003E-2,{"$f":"F232*K232","v":0.246}]
["154",null,"40445024.A","Značka doprav zákazová B1-B34 700 fól 2, HIG10letá","kus",1,1078,{"$f":"ROUND(F233*AE233,2)","v":0},{"$f":"J233-H233","v":1078},{"$f":"ROUND(F233*G233,2)","v":1078},6.0000000000000001E-3,{"$f":"F233*K233","v":6.0000000000000001E-3}]
[155,null,"40444987.A","Značka uprav přednost P4 900  fólie 1, EG 7letá","kus",1,847,{"$f":"ROUND(F234*AE234,2)","v":0},{"$f":"J234-H234","v":847},{"$f":"ROUND(F234*G234,2)","v":847},6.0000000000000001E-3,{"$f":"F234*K234","v":6.0000000000000001E-3}]
[156,null,"40445033.A","Značka dopr příkazová C1-C14b 700 fól 2, HIG10letá","kus",6,1078,0,6468,6468,5.1000000000000004E-3,3.0600000000000002E-2]
[157,null,"40445120.A","Značka dopr inform IS 19a-d,850/200 fól1,EG 7letá","kus",1,572,0,572,572,4.0000000000000001E-3,4.0000000000000001E-3]
[158,null,"40445124.A","Značka dopr inform IS 21a-c,300/200 fól1,EG 7 letá","kus",1,258,0,258,258,3.0000000000000001E-3,3.0000000000000001E-3]
[159,null,"40445141.A","Značka dopr dodat E1,2a,b 500/500 fól 1, EG 7letá","kus",1,663,0,663,663,5.1000000000000004E-3,5.1000000000000004E-3]
[160,null,"40445961","Sloupek Al 60/5 hladký drážkový","m",24,158,0,3792,3792,1.2999999999999999E-3,3.1199999999999999E-2]
[161,null,"40445962.A","Dopravní příslušenství, patka AL 4 ks kot šroubů","kus",6,561,0,3366,3366,1.2600000000000001E-3,7.5600000000000007E-3]
[162,null,"40445976.A","Dopravní příslušenství, objímka Al-2c průměr 60","kus",19,55,0,1045,1045,1.2600000000000001E-3,2.3939999999999999E-2]
[null,null,null,"Společné položky",null,null,null,"Celkem:",null,{"$f":"J228","v":39497}]

{"sheet":"Stavební rozpočet - součet","index":1,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[[7,4,8,6],[1,1,2,2],[5,3,6,3],[3,3,4,3],[3,1,4,2],[76,1,76,2],[82,1,82,2],[7,3,8,3],[7,0,8,0],[7,1,8,2],[33,1,33,2],[55,1,55,2],[0,0,0,5],[1,0,2,0],[3,0,4,0],[5,0,6,0],[1,3,2,3],[5,1,6,2],[1,4,2,6],[3,4,4,6],[5,4,6,6]]}
["Stavební rozpočet - rekapitulace"]
["Název stavby:","Cyklostezka W Krásné Pole",null,"Objednatel:"]
[]
["Druh stavby:",null,null,"Projektant:"]
[]
["Lokalita:","úsek Nová kolonie - Zauliční",null,"Zhotovitel:"]
[]
["Zpracoval:",null,null,"Zpracováno dne:","2013-01-21"]
[]
["Objekt","Kód","Zkrácený popis","Náklady (Kč) - dodávka","Náklady (Kč) - Montáž","Náklady (Kč) - celkem","Celková hmotnost (t)"]
[null,"Ul. Hájkovická"]
[null,"11","Přípravné a přidružené práce",{"$f":"'Stavební rozpočet'!H14","v":0},{"$f":"'Stavební rozpočet'!I14","v":81815},{"$f":"D12+E12","v":81815},{"$f":"'Stavební rozpočet'!L14","v":183.20099999999999},"F",{"$f":"IF(H12=\"T\",0,F12)","v":81815}]
[null,"12","Odkopávky a prokopávky",{"$f":"'Stavební rozpočet'!H23","v":0},{"$f":"'Stavební rozpočet'!I23","v":14072.5},14072.5,{"$f":"'Stavební rozpočet'!L23","v":0},"F",14072.5]
[null,"16","Přemístění výkopku",{"$f":"'Stavební rozpočet'!H28","v":0},{"$f":"'Stavební rozpočet'!I28","v":14700},14700,{"$f":"'Stavební rozpočet'!L28","v":0},"F",14700]
[null,"17","Konstrukce ze zemin",{"$f":"'Stavební rozpočet'!H30","v":0},{"$f":"'Stavební rozpočet'!I30","v":980},980,{"$f":"'Stavební rozpočet'!L30","v":0},"F",980]
[null,"171VD","17 konstrukce ze zemin",{"$f":"'Stavební rozpočet'!H32","v":0},{"$f":"'Stavební rozpočet'!I32","v":11760},11760,{"$f":"'Stavební rozpočet'!L32","v":0},"F",11760]
[null,"18","Povrchové úpravy terénu",{"$f":"'Stavební rozpočet'!H34","v":161.77000000000001},{"$f":"'Stavební rozpočet'!I34","v":12578.23},12740,{"$f":"'Stavební rozpočet'!L34","v":0},"F",12740]
[null,"21","Úprava podloží a základové spáry",{"$f":"'Stavební rozpočet'!H38","v":23935.16},{"$f":"'Stavební rozpočet'!I38","v":5514.84},29450,{"$f":"'Stavební rozpočet'!L38","v":50.007999999999996},"F",29450]
[null,"212VD","212 - kanalizace",{"$f":"'Stavební rozpočet'!H40","v":1393.94},{"$f":"'Stavební rozpočet'!I40","v":28786.06},30180,{"$f":"'Stavební rozpočet'!L40","v":0},"F",30180]
[null,"56","Podkladní vrstvy komunikací a zpevněných ploch",{"$f":"'Stavební rozpočet'!H44","v":43134.29},{"$f":"'Stavební rozpočet'!I44","v":9240.7100000000009},52375,{"$f":"'Stavební rozpočet'!L44","v":189.00682},"F",52375]
[null,"59","Dlažby a předlažby pozemních komunikací a zpevněných ploch",{"$f":"'Stavební rozpočet'!H47","v":95183.1},{"$f":"'Stavební rozpočet'!I47","v":101120.90000000001},196304,{"$f":"'Stavební rozpočet'!L47","v":71.398323200000007},"F",196304]
[null,"89","Ostatní konstrukce a práce na trubním vedení",{"$f":"'Stavební rozpočet'!H56","v":0},{"$f":"'Stavební rozpočet'!I56","v":9750},{"$f":"D22+E22","v":9750},{"$f":"'Stavební rozpočet'!L56","v":4.7262000000000004}]
[null,"91","Doplňující konstrukce a práce na pozemních komunikacích a zpevněných plochách",{"$f":"'Stavební rozpočet'!H58","v":31295.969999999998},{"$f":"'Stavební rozpočet'!I58","v":15284.030000000002},46580,{"$f":"'Stavební rozpočet'!L58","v":39.493540000000003},"F",46580]
[null,"966","Ostatních stavebních konstrukcí",{"$f":"'Stavební rozpočet'!H65","v":0},{"$f":"'Stavební rozpočet'!I65","v":3800},3800,{"$f":"'Stavební rozpočet'!L65","v":0},"F",3800]
[null,"97","Prorážení otvorů a ostatní bourací práce",{"$f":"'Stavební rozpočet'!H67","v":0},{"$f":"'Stavební rozpočet'!I67","v":1785.8},1785.8,{"$f":"'Stavební rozpočet'!L67","v":0},"F",1785.8]
[null,"979VD","979 - skládka",{"$f":"'Stavební rozpočet'!H71","v":0},{"$f":"'Stavební rozpočet'!I71","v":21238.75},21238.75,{"$f":"'Stavební rozpočet'!L71","v":0},"F",21238.75]
[null,"999VD","999 - různé",{"$f":"'Stavební rozpočet'!H74","v":0},{"$f":"'Stavební rozpočet'!I74","v":8000},8000,{"$f":"'Stavební rozpočet'!L74","v":0},"F",8000]
[null,"H22","Komunikace pozemní a letiště",{"$f":"'Stavební rozpočet'!H76","v":0},{"$f":"'Stavební rozpočet'!I76","v":9393},9393,{"$f":"'Stavební rozpočet'!L76","v":0},"F",9393]
[null,"S","Přesuny sutí",{"$f":"'Stavební rozpočet'!H78","v":0},{"$f":"'Stavební rozpočet'!I78","v":21617.599999999999},21617.599999999999,{"$f":"'Stavební rozpočet'!L78","v":0},"F",21617.599999999999]
[null,null,"Ostatní materiál",{"$f":"'Stavební rozpočet'!H81","v":138504.29999999999},{"$f":"'Stavební rozpočet'!I81","v":0},138504.29999999999,{"$f":"'Stavební rozpočet'!L81","v":115.01704899999997},"F",138504.29999999999]
[null,null,null,null,null,null,null,null,null,null,{"$f":"E27","v":8000}]
[null,null,null,null,"Celkem:",{"$f":"SUM(F12:F31)","v":705045.95},null,null,null,null,{"$f":"SUM(E12:E25)","v":311188.07}]
[]
[null,"ul. Družební km 0,212 - km 0,260"]
[null,"11","Přípravné a přidružené práce",{"$f":"'Stavební rozpočet'!H94","v":0},{"$f":"'Stavební rozpočet'!I94","v":4276},{"$f":"D35+E35","v":4276},{"$f":"'Stavební rozpočet'!L94","v":24.832000000000004}]
[null,"12","Odkopávky a prokopávky",{"$f":"'Stavební rozpočet'!H100","v":0},{"$f":"'Stavební rozpočet'!I100","v":7977.5},7977.5,{"$f":"'Stavební rozpočet'!L100","v":0}]
[null,"16","Přemístění výkopku",{"$f":"'Stavební rozpočet'!H105","v":0},{"$f":"'Stavební rozpočet'!I105","v":9300},9300,{"$f":"'Stavební rozpočet'!L105","v":0}]
[null,"17","Konstrukce ze zemin",{"$f":"'Stavební rozpočet'!H107","v":0},{"$f":"'Stavební rozpočet'!I107","v":1920},1920,{"$f":"'Stavební rozpočet'!L107","v":10}]
[null,"171VD","17 konstrukce ze zemin",{"$f":"'Stavební rozpočet'!H110","v":0},{"$f":"'Stavební rozpočet'!I110","v":7440},7440,{"$f":"'Stavební rozpočet'!L110","v":0}]
[null,"18","Povrchové úpravy terénu",{"$f":"'Stavební rozpočet'!H112","v":0},{"$f":"'Stavební rozpočet'!I112","v":2620},2620,{"$f":"'Stavební rozpočet'!L112","v":0}]
[null,"21","Úprava podloží a základové spáry",{"$f":"'Stavební rozpočet'!H116","v":0},{"$f":"'Stavební rozpočet'!I116","v":7750},7750,{"$f":"'Stavební rozpočet'!L116","v":13.16}]
[null,"212VD","212 - kanalizace",{"$f":"'Stavební rozpočet'!H118","v":0},{"$f":"'Stavební rozpočet'!I118","v":690},690,{"$f":"'Stavební rozpočet'!L118","v":0}]
[null,"56","Podkladní vrstvy komunikací a zpevněných ploch",{"$f":"'Stavební rozpočet'!H120","v":0},{"$f":"'Stavební rozpočet'!I120","v":19750},19750,{"$f":"'Stavební rozpočet'!L120","v":72.942279999999997}]
[null,"59","Dlažby a předlažby pozemních komunikací a zpevněných ploch",{"$f":"'Stavební rozpočet'!H122","v":0},{"$f":"'Stavební rozpočet'!I122","v":43208},43208,{"$f":"'Stavební rozpočet'!L122","v":16.1881652}]
[null,"89","Ostatní konstrukce a práce na trubním vedení",{"$f":"'Stavební rozpočet'!H131","v":0},{"$f":"'Stavební rozpočet'!I131","v":3250},3250,{"$f":"'Stavební rozpočet'!L131","v":1.5754000000000001}]
[null,"91","Doplňující konstrukce a práce na pozemních komunikacích a zpevněných plochách",{"$f":"'Stavební rozpočet'!H133","v":0},{"$f":"'Stavební rozpočet'!I133","v":39620},39620,{"$f":"'Stavební rozpočet'!L133","v":25.978600000000004}]
[null,"97","Prorážení otvorů a ostatní bourací práce",{"$f":"'Stavební rozpočet'!H140","v":0},{"$f":"'Stavební rozpočet'!I140","v":817.6},817.6,{"$f":"'Stavební rozpočet'!L140","v":0}]
[null,"979VD","979 - skládka",{"$f":"'Stavební rozpočet'!H144","v":0},{"$f":"'Stavební rozpočet'!I144","v":2483},2483,{"$f":"'Stavební rozpočet'!L144","v":0}]
[null,"999VD","999 - různé",{"$f":"'Stavební rozpočet'!H146","v":0},{"$f":"'Stavební rozpočet'!I146","v":3680},3680,{"$f":"'Stavební rozpočet'!L146","v":0}]
[null,"H22","Komunikace pozemní a letiště",{"$f":"'Stavební rozpočet'!H148","v":0},{"$f":"'Stavební rozpočet'!I148","v":3825.02},3825.02,{"$f":"'Stavební rozpočet'!L148","v":0}]
[null,"S","Přesuny sutí",{"$f":"'Stavební rozpočet'!H150","v":0},{"$f":"'Stavební rozpočet'!I150","v":2929.94},2929.94,{"$f":"'Stavební rozpočet'!L150","v":0},null,null,null,{"$f":"SUM(E35:E47)","v":148619.1}]
[null,null,"Ostatní materiál",{"$f":"'Stavební rozpočet'!H153","v":67658.02},{"$f":"'Stavební rozpočet'!I153","v":0},67658.02,{"$f":"'Stavební rozpočet'!L153","v":51.406672999999998},null,null,null,{"$f":"E49","v":3680}]
[]
[null,null,null,null,"Celkem:",{"$f":"SUM(F35:F53)","v":229195.08000000002}]
[]
[null,"ul. Družební km 0,260 - km 0,317"]
[null,"11","Přípravné a přidružené práce",{"$f":"'Stavební rozpočet'!H167","v":0},{"$f":"'Stavební rozpočet'!I167","v":10680},{"$f":"D57+E57","v":10680},{"$f":"'Stavební rozpočet'!L167","v":33.480000000000004}]
[null,"12","Odkopávky a prokopávky",{"$f":"'Stavební rozpočet'!H172","v":0},{"$f":"'Stavební rozpočet'!I172","v":7950},7950,{"$f":"'Stavební rozpočet'!L172","v":0}]
[null,"16","Přemístění výkopku",{"$f":"'Stavební rozpočet'!H176","v":0},{"$f":"'Stavební rozpočet'!I176","v":9000},9000,{"$f":"'Stavební rozpočet'!L176","v":0}]
[null,"17","Konstrukce ze zemin",{"$f":"'Stavební rozpočet'!H178","v":0},{"$f":"'Stavební rozpočet'!I178","v":600},600,{"$f":"'Stavební rozpočet'!L178","v":0}]
[null,"171VD","17 konstrukce ze zemin",{"$f":"'Stavební rozpočet'!H180","v":0},{"$f":"'Stavební rozpočet'!I180","v":7200},7200,{"$f":"'Stavební rozpočet'!L180","v":0}]
[null,"18","Povrchové úpravy terénu",{"$f":"'Stavební rozpočet'!H182","v":0},{"$f":"'Stavební rozpočet'!I182","v":1690},1690,{"$f":"'Stavební rozpočet'!L182","v":0}]
[null,"21","Úprava podloží a základové spáry",{"$f":"'Stavební rozpočet'!H184","v":0},{"$f":"'Stavební rozpočet'!I184","v":8835},8835,{"$f":"'Stavební rozpočet'!L184","v":15.0024}]
[null,"212VD","212 - kanalizace",{"$f":"'Stavební rozpočet'!H186","v":0},{"$f":"'Stavební rozpočet'!I186","v":690},690,{"$f":"'Stavební rozpočet'!L186","v":0}]
[null,"56","Podkladní vrstvy komunikací a zpevněných ploch",{"$f":"'Stavební rozpočet'!H188","v":0},{"$f":"'Stavební rozpočet'!I188","v":21125},21125,{"$f":"'Stavební rozpočet'!L188","v":78.020539999999997}]
[null,"59","Dlažby a předlažby pozemních komunikací a zpevněných ploch",{"$f":"'Stavební rozpočet'!H190","v":0},{"$f":"'Stavební rozpočet'!I190","v":53388},53388,{"$f":"'Stavební rozpočet'!L190","v":17.662829200000001}]
[null,"89","Ostatní konstrukce a práce na trubním vedení",{"$f":"'Stavební rozpočet'!H199","v":0},{"$f":"'Stavební rozpočet'!I199","v":3250},3250,{"$f":"'Stavební rozpočet'!L199","v":1.5754000000000001}]
[null,"91","Doplňující konstrukce a práce na pozemních komunikacích a zpevněných plochách",{"$f":"'Stavební rozpočet'!H201","v":0},{"$f":"'Stavební rozpočet'!I201","v":31845},31845,{"$f":"'Stavební rozpočet'!L201","v":23.437080000000002}]
[null,"979VD","979 - skládka",{"$f":"'Stavební rozpočet'!H207","v":0},{"$f":"'Stavební rozpočet'!I207","v":3446},3446,{"$f":"'Stavební rozpočet'!L207","v":0}]
[null,"H22","Komunikace pozemní a letiště",{"$f":"'Stavební rozpočet'!H210","v":0},{"$f":"'Stavební rozpočet'!I210","v":3365.93},3365.93,{"$f":"'Stavební rozpočet'!L210","v":0}]
[null,"S","Přesuny sutí",{"$f":"'Stavební rozpočet'!H212","v":0},{"$f":"'Stavební rozpočet'!I212","v":3950.64},3950.64,{"$f":"'Stavební rozpočet'!L212","v":0},null,null,null,{"$f":"SUM(E57:E68)","v":156253}]
[null,null,"Ostatní materiál",{"$f":"'Stavební rozpočet'!H215","v":61722.360000000008},{"$f":"'Stavební rozpočet'!I215","v":0},61722.360000000008,{"$f":"'Stavební rozpočet'!L215","v":34.173883000000004}]
[]
[null,null,null,null,"Celkem:",{"$f":"SUM(F57:F73)","v":228737.93000000002}]
[]
[]
[null,"Společné položky"]
[null,"11","Přípravné a přidružené práce",{"$f":"'Stavební rozpočet'!H228","v":0},{"$f":"'Stavební rozpočet'!I228","v":39497},{"$f":"D78+E78","v":39497},{"$f":"'Stavební rozpočet'!L228","v":2.9509000000000003},null,null,null,{"$f":"E78","v":39497}]
[]
[null,null,null,null,"Celkem:",{"$f":"SUM(F78:F79)","v":39497}]
[]
[]
[null,"Celkový součet",null,null,null,{"$f":"F80+F74+F54+F32","v":1202475.96}]

{"sheet":"Krycí list rozpočtu","index":2,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,6,30,8],[24,6,24,7],[25,6,25,7],[31,0,31,2],[27,3,27,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[31,3,31,5],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,6,31,8],[27,6,27,8],[28,6,28,8],[29,6,29,8],[23,0,23,1],[24,0,24,1],[25,0,25,1],[24,3,24,4],[25,3,25,4],[19,6,19,7],[20,6,20,7],[18,6,18,7],[13,3,13,4],[21,6,21,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[19,0,19,1],[20,0,20,1],[21,0,21,1],[19,3,19,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[20,3,20,4],[21,3,21,4],[3,4,4,4],[5,4,6,4],[1,7,2,7],[7,5,8,6],[9,5,10,6],[12,1,12,2],[12,4,12,5],[12,7,12,8],[7,7,8,7],[9,7,10,7],[9,8,10,8],[7,4,8,4],[9,4,10,4],[9,2,10,3],[11,0,11,8],[7,8,8,8],[7,0,8,1],[9,0,10,1],[7,2,8,3],[0,0,0,8],[1,0,2,1],[3,0,4,1],[5,0,6,1],[1,4,2,4],[3,8,4,8],[5,8,6,8],[3,7,4,7],[5,7,6,7],[1,8,2,8],[1,2,2,3],[3,2,4,3],[5,2,6,3],[1,5,2,6],[3,5,4,6],[5,5,6,6]]}
["Krycí list rozpočtu"]
["Název stavby:",null,"Cyklostezka W Krásné Pole",null,"Objednatel:",null,null,"IČ/DIČ:"]
[]
["Druh stavby:",null,null,null,"Projektant:",null,null,"IČ/DIČ:"]
[]
["Lokalita:",null,"úsek Nová kolonie - Zauliční",null,"Zhotovitel:",null,null,"IČ/DIČ:"]
[]
["Začátek výstavby:",null,null,null,"Konec výstavby:",null,null,"Položek:","162"]
[]
["JKSO:",null,null,null,"Zpracoval:",null,null,"Datum:"]
[]
["Rozpočtové náklady v Kč"]
["A","Základní rozpočtové náklady",null,"B","Doplňkové náklady",null,"C","Náklady na umístění stavby (NUS)"]
["HSV","Dodávky",{"$f":"'Stavební rozpočet - součet'!D17+'Stavební rozpočet - součet'!D18+'Stavební rozpočet - součet'!D19+'Stavební rozpočet - součet'!D20+'Stavební rozpočet - součet'!D21+'Stavební rozpočet - součet'!D23","v":195104.23},"Práce přesčas",null,0,"Zařízení staveniště",null,{"$f":"C22*0.5%","v":6012.3797999999997}]
[null,"Montáž",{"$f":"'Stavební rozpočet - součet'!K31+'Stavební rozpočet - součet'!K32+'Stavební rozpočet - součet'!K51+'Stavební rozpočet - součet'!K52+'Stavební rozpočet - součet'!K71+'Stavební rozpočet - součet'!K78","v":667237.17000000004},"Bez pevné podl.",null,0,"Mimostav. doprava",null,0]
["PSV","Dodávky",{"$f":"SUM('Stavební rozpočet'!T14:T89)","v":0},"Kulturní památka",null,0,"Územní vlivy",null,0]
[null,"Montáž",{"$f":"SUM('Stavební rozpočet'!U14:U89)","v":0},null,null,null,"Provozní vlivy",null,0]
["\"M\"","Dodávky",{"$f":"SUM('Stavební rozpočet'!V14:V89)","v":0},null,null,null,"Ostatní",null,{"$f":"C22*0.01%","v":120.247596}]
[null,"Montáž",{"$f":"SUM('Stavební rozpočet'!W14:W89)","v":0},null,null,null,"NUS z rozpočtu",null,0]
["Ostatní materiál",null,{"$f":"'Stavební rozpočet - součet'!D30+'Stavební rozpočet - součet'!D52+'Stavební rozpočet - součet'!D72","v":267884.68}]
["Přesun hmot a sutí",null,{"$f":"'Stavební rozpočet - součet'!F26+'Stavební rozpočet - součet'!F28+'Stavební rozpočet - součet'!F29+'Stavební rozpočet - součet'!F48+'Stavební rozpočet - součet'!F50+'Stavební rozpočet - součet'!F51+'Stavební rozpočet - součet'!F69+'Stavební rozpočet - součet'!F70+'Stavební rozpočet - součet'!F71","v":72249.87999999999}]
["ZRN celkem",null,{"$f":"SUM(C14:C21)","v":1202475.96},"DN celkem",null,{"$f":"SUM(F14:F21)","v":0},"NUS celkem",null,{"$f":"SUM(I14:I21)","v":6132.6273959999999}]
[]
["Základ 0%",null,{"$f":"SUM('Stavební rozpočet'!Z14:Z89)","v":0}]
["Základ 14%",null,{"$f":"SUM('Stavební rozpočet'!AA14:AA89)","v":0},"DPH 14%",null,{"$f":"ROUND(C25*(14/100),2)","v":0},"Celkem bez DPH",null,{"$f":"C22+I22","v":1208608.587396}]
["Základ 21%",null,{"$f":"I25","v":1208608.587396},"DPH 21%",null,{"$f":"ROUND(C26*(21/100),2)","v":253807.8},"Celkem včetně DPH",null,{"$f":"SUM(F25:F26)+I25","v":1462416.3873960001}]
[]
["Projektant",null,null,"Objednatel",null,null,"Zhotovitel"]
[]
[]
[]
["Datum, razítko a podpis",null,null,"Datum, razítko a podpis",null,null,"Datum, razítko a podpis"]