{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["úvodní list","kalkulace(pro obec)","voda převzatá JVS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"úvodní list","index":0,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,0,22,10],[25,0,25,10],[28,0,28,10],[31,0,31,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Návrh ceny pro vodné"]
[]
[]
["rok 2023"]
[]
[]
["Zbelítov"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"do tohoto řádku (v úvodním listu) je možné doplnit další text (např. variantu)"]

{"sheet":"kalkulace(pro obec)","index":1,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":false,"merged":[[79,0,88,1],[79,2,79,3],[79,4,80,4],[79,5,79,6],[79,7,79,8],[88,2,88,6],[77,0,77,8],[64,1,64,3],[65,1,65,3],[66,1,66,3],[67,1,67,3],[68,1,68,3],[69,1,69,3],[70,1,70,3],[71,1,71,4],[73,1,73,3],[75,0,75,8],[76,0,76,8],[63,1,63,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[55,1,55,3],[56,1,56,3],[57,1,57,3],[59,0,59,8],[61,1,62,3],[61,4,62,4],[61,5,61,6],[61,7,61,8],[50,1,50,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[36,1,36,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[23,1,23,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[11,1,11,3],[1,0,1,8],[2,1,2,3],[2,5,2,8],[4,0,5,0],[4,1,5,3],[4,4,5,4],[4,5,4,6],[4,7,4,8],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3]]}
[]
["PLÁNOVANÁ KALKULACE CENY VODY (PITNÉ, ODPADNÍ) PRO KALENDÁŘNÍ ROK 2023"]
[null,"PRO OBLAST (LOKALITU) : ",null,null,"A48","Zbelítov"]
[]
["položka","kalkulační položky",null,null,"měrná jednotka","voda pitná",null,"voda odpadní"]
[null,null,null,null,null,2022,2023,2022,2023]
[1,2,null,null,"2a",3,3,4,4]
["1.","Materiál",null,null,"Kč",{"$f":"+F9+F10+F11+F12","v":121800},{"$f":"+G9+G10+G11+G12","v":139293},{"$f":"+H9+H10+H11+H12","v":0},{"$f":"+I9+I10+I11+I12","v":0}]
["1.1","surová voda podzemní + povrchová",null,null,"Kč",0,0,0,0]
["1.2","pitná voda převzatá + odpadní voda předaná k čištění",null,null,"Kč",113800,131293,0,0]
["1.3","chemikálie",null,null,"Kč",0,0,0,0]
["1.4","ostatní materiál",null,null,"Kč",8000,8000,0,0]
["2.","Energie",null,null,"Kč",{"$f":"+F14+F15","v":19000},{"$f":"+G14+G15","v":20000},0,0]
["2.1","elektrická energie",null,null,"Kč",14000,15000,0,0]
["2.2","Ostatní energie (plyn, pev. a kapal. ener., PHM)",null,null,"Kč",5000,5000,0,0]
["3.","Mzdy",null,null,"Kč",{"$f":"SUM(F17:F18)","v":0},{"$f":"SUM(G17:G18)","v":0},0,0]
["3.1","přímé mzdy",null,null,"Kč",0,0,0,0]
["3.2","ostatní osobní náklady",null,null,"Kč",0,0,0,0]
["4.","Ostatní přímé náklady",null,null,"Kč",{"$f":"+F20+F21+F22+F23","v":36120},{"$f":"+G20+G21+G22+G23","v":39260},{"$f":"+H20+H21+H22+H23","v":0},{"$f":"+I20+I21+I22+I23","v":0}]
["4.1","odpisy infrastrukturního majetku (smluvní investice)",null,null,"Kč",0,0,0,0]
["4.2","obnovující opravy infrastrukturního majetku",null,null,"Kč",0,0,0,0]
["4.3","opravy infrastrukturního majetku ostatní",null,null,"Kč",33620,36760,0,0]
["4.4","pachtovné / nájemné infrastrukturního majetku",null,null,"Kč",2500,2500,0,0]
["5.","Jiné provozní náklady",null,null,"Kč",{"$f":"+F25+F26+F27","v":18814},{"$f":"+G25+G26+G27","v":23514},{"$f":"+H25+H26+H27","v":0},{"$f":"+I25+I26+I27","v":0}]
["5.1","poplatky za vypouštění odpadních vod",null,null,"Kč",0,0,0,0]
["5.2","ostatní provozní náklady externí",null,null,"Kč",2900,4900,0,0]
["5.3","ostatní provozní náklady ve vlastní režii",null,null,"Kč",15914,18614,0,0]
["6.","finanční náklady",null,null,"Kč",0,0,0,0]
["7.","finanční výnosy",null,null,"Kč",0,0,0,0]
["8.","výrobní režie",null,null,"Kč",5252,6032,0,0]
["9.","správní režie",null,null,"Kč",8008,9204,0,0]
["10.","úplné vlastní náklady (ÚVN)",null,null,"Kč",{"$f":"+F8+F13+F16+F19+F24+F28+F29+F30+F31","v":208994},{"$f":"+G8+G13+G16+G19+G24+G28+G29+G30+G31","v":237303},{"$f":"+H8+H13+H16+H19+H24+H28+H29+H30+H31","v":0},{"$f":"+I8+I13+I16+I19+I24+I28+I29+I30+I31","v":0}]
[]
["A","počet pracovníků",null,null,"osob"]
["B","voda pitná fakturovaná",null,null,"m3",5200,5200]
["C","- z toho domácnosti",null,null,"m3"]
["D","voda odpadní odváděná fakturovaná",null,null,"m3",null,null,0,0]
["E","- z toho domácnosti",null,null,"m3"]
["F","voda srážková fakturovaná",null,null,"m3"]
["G","voda odpadní čištěná",null,null,"m3"]
["H","pitná nebo odpadní voda převzatá",null,null,"m3",6500,6500]
["I","pitná nebo odpadní voda předaná",null,null,"m3"]
[]
["11.","Jednotkové náklady na 1 m3",null,null,"Kč / m3",{"$f":"IFERROR(F32/F35,0)","v":40.191153846153846},{"$f":"IFERROR(G32/G35,0)","v":45.635192307692307},{"$f":"IFERROR(H32/(H37+H39),0)","v":0},{"$f":"IFERROR(I32/(I37+I39),0)","v":0}]
["12.","Vyrovnávací položky",null,null,"Kč",{"$f":"SUM(F46:F47)","v":0},{"$f":"SUM(G46:G47)","v":0},{"$f":"SUM(H46:H47)","v":0},{"$f":"SUM(I46:I47)","v":0}]
["12.1","Vyrovnávací položka z roku t-2 dle platných pravidel",null,null,"Kč",0,0,0,0]
["12.2","Finanční vyp. rozdílu kalkulací prováděných podle OPŽP",null,null,"Kč",0,0,0,0]
["13.","ÚVN + vyrovnávací položky",null,null,"Kč",{"$f":"F32+F45","v":208994},{"$f":"G32+G45","v":237303},0,0]
["14.","Kalkulační zisk ( ztráta )",null,null,"Kč",20899,22230.300000000003,0,0]
["15.","podíl zisku (ztrát) z ÚVN včetně vyrovnávacích položek",null,null,"%",{"$f":"IFERROR(F49/F48,0)","v":9.9998086069456538E-2},9.3678967396113838E-2,{"$f":"IFERROR(H49/H48,0)","v":0},{"$f":"IFERROR(I49/I48,0)","v":0}]
["18.","Celkem ÚVN + VP + zisk ( ztráta ) = Tržby",null,null,"Kč",{"$f":"F49+F48","v":229893},{"$f":"G49+G48","v":259533.3},0,0]
["19.","Fakturace v m3 celkem",null,null,"m3",{"$f":"F35","v":5200},{"$f":"G35","v":5200},{"$f":"H37+H39","v":0},{"$f":"I37+I39","v":0}]
["20.","UPLATŇOVANÁ CENA pro vodné, stočné",null,null,"Kč / m3",{"$f":"IFERROR(TRUNC(F51/F52,2),0)","v":44.21},{"$f":"IFERROR(TRUNC(G51/G52,2),0)","v":49.91},{"$f":"IFERROR(TRUNC(H51/H52,2),0)","v":0},{"$f":"IFERROR(TRUNC(I51/I52,2),0)","v":0}]
["21.","UPLATŇOVANÁ CENA pro vodné, stočné + DPH",null,null,"Kč / m3",{"$f":"F53*(1+10%)","v":48.631000000000007},{"$f":"G53*(1+10%)","v":54.901000000000003},{"$f":"H53*(1+10%)","v":0},{"$f":"I53*(1+10%)","v":0}]
[]
["x","meziroční změna ceny ( v Kč / m3 bez DPH )",null,null,"Kč / m3","x",{"$f":"G53-F53","v":5.6999999999999957},"x",{"$f":"I53-H53","v":0}]
["x","meziroční změna ceny ( v % )",null,null,"%","x",{"$f":"IFERROR(G56/F53,0)","v":0.12893010631078933},"x",{"$f":"IFERROR(I56/H53,0)","v":0}]
["x","Porovnání celkové ceny (2022/2023) bez DPH",null,null,null,{"$f":"+F53+H53","v":44.21},{"$f":"+G53+I53","v":49.91},{"$f":"+G58-F58","v":5.6999999999999957},{"$f":"+IFERROR(H58/F58,0)","v":0.12893010631078933}]
[]
["PLÁNOVANÁ CENA PRO VODNÉ A PRO STOČNÉ PŘI DVOUSLOŽKOVÉ FORMĚ PRO KALENDÁŘNÍ ROK 2023"]
[]
[null,"text",null,null,"měrná jednotka","voda pitná",null,"voda odpadní"]
[null,null,null,null,null,2022,2023,2022,2023]
[1,2,null,null,"2a",3,3,4,4]
["23.","pevná složka - (ÚVN + vyrovnávací položky + kalkulační zisk / ztráta)",null,null,"Kč",25200,29483.999999999996,0,0]
["23a.","- podíl z celkových ÚVN včetně vyrovnávací položky a kalkulačního zisku / ztráty",null,null,"%",{"$f":"IFERROR(+(F65/F51)*100,\"\")","v":10.961621275984914},{"$f":"IFERROR(+(G65/G51)*100,\"\")","v":11.360391903466722},{"$f":"IFERROR(+(H65/H51)*100,\"  \")","v":"  "},{"$f":"IFERROR(+(I65/I51)*100,\"\")","v":""}]
["24.","pohyblivá složka - (ÚVN + vyrovnávací položky + kalkulační zisk / ztráta)",null,null,"Kč",{"$f":"IF(F65<>0,F51-F65,\"\")","v":204693},{"$f":"IF(G65<>0,G51-G65,\"\")","v":230049.3},{"$f":"IF(H65<>0,H51-H65,0)","v":0},{"$f":"IF(I65<>0,I51-I65,\"\")","v":""}]
["24a.","- z toho: ÚVN + vyrovnávací položky",null,null,"Kč",{"$f":"IFERROR(IF(F66<>0,F48*(1-(F66/100)),\"\"),\"\")","v":186084.86923046809},{"$f":"IFERROR(IF(G66<>0,G48*(1-(G66/100)),\"\"),\"\")","v":210344.44920131637},{"$f":"IFERROR(IF(H66<>0,H48*(1-(H66/100)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I66<>0,I48*(1-(I66/100)),\"\"),\"\")","v":""}]
["24b.","kalkulační zisk / ztráta",null,null,"Kč",{"$f":"IFERROR(+F67-F68,\"\")","v":18608.130769531912},{"$f":"IFERROR(+G67-G68,\"\")","v":19704.850798683619},{"$f":"IFERROR(+H67-H68,\"\")","v":""},{"$f":"IFERROR(+I67-I68,\"\")","v":""}]
["25.","uplatňovaná cena pohyblivé složky",null,null,"Kč / m3",{"$f":"IFERROR(TRUNC(+F67/F52,2),0)","v":39.36},{"$f":"IFERROR(TRUNC(+G67/G52,2),0)","v":44.24},{"$f":"IFERROR(TRUNC(+H67/H52,2),0)","v":0},{"$f":"IFERROR(TRUNC(+I67/I52,2),0)","v":0}]
["26.","uplatňovaná cena pohyblivé složky + DPH",null,null,"Kč / m3",{"$f":"IFERROR(F70*(1+#REF!),\"\")","v":""},{"$f":"IFERROR(G70*(1+#REF!),\"\")","v":""},{"$f":"IFERROR(H70*(1+#REF!),\"\")","v":""},{"$f":"IFERROR(I70*(1+#REF!),\"\")","v":""}]
["27.","technické parametry pevné složky podle § 33 odst. 1 vyhlášky č. 428/2001 Sb. ( a, b, c)",null,null,null,"a","a","a","a"]
[]
["x","Porovnání celkové ceny (2022/2023) bez DPH",null,null,null,{"$f":"+F70+H70","v":39.36},{"$f":"+G70+I70","v":44.24},{"$f":"+G74-F74","v":4.8800000000000026},{"$f":"+IFERROR(H74/F74,0)","v":0.12398373983739844}]
[]
["PLÁNOVANÉ PEVNÉ SLOŽKY PRO VODNÉ A PRO STOČNÉ DLE JEDNOTLIVÝCH KATEGORIÍ"]
["PODLE HODNOTY PRŮTOKU VODOMĚRU Q3 ( m3 / h ) v Kč bez DPH"]
[{"$f":"CONCATENATE(\"PRO \", \"OBEC \",$F$3)","v":"PRO OBEC Zbelítov"}]
[]
["Vodoměry jsou členěny dle kategorií (skupin).  Převážná část VDM (A) v síti je bez speciálních požadavků na množství odebrané vody a požární zabezpečení. S každou další kategorií je specifikace upravena dle daných podmínek.",null,"platba celkem",null,"kategorie VDM","voda pitná",null,"voda odpadní"]
[null,null,2022,2023,null,2022,2023,2022,2023]
[null,null,{"$f":"F82+H82","v":252},{"$f":"G82+I82","v":252},"A",252,252,0,0]
[null,null,{"$f":"F83+H83","v":0},0,"B",0,0,0,0]
[null,null,0,0,"C",0,0,0,0]
[null,null,0,0,"D",0,0,0,0]
[null,null,0,0,"E",0,0,0,0]
[null,null,0,0,"G"]
[null,null,0,0,"CH"]
[null,null,"pevná složka stočného z jiných zdrojů v Kč / m3",null,null,null,null,{"$f":"+H53-H70","v":0},{"$f":"+I53-I70","v":0}]

{"sheet":"voda převzatá JVS","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Vliv nárůstu ceny vody převzaté z JVS:"]
[null,2022,2023,"rozdíl"]
["voda převzatá v m3",6500,6500,{"$f":"C3-B3","v":0}]
["cena pohyblivé složky",15.04,17.23,{"$f":"C4-B4","v":2.1900000000000013}]
["pohyblivá složka celkem",{"$f":"B3*B4","v":97760},{"$f":"C3*C4","v":111995},{"$f":"C5-B5","v":14235}]
["pevná složka",16043,19298,{"$f":"C6-B6","v":3255}]
["voda převzatá v Kč celkem",{"$f":"B6+B5","v":113803},{"$f":"C6+C5","v":131293},{"$f":"C7-B7","v":17490}]