{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Intro","Kalkulačka","Analýza_citlivosti","CMA","Predpoklady","OPEX","Diesel","Ceny_listkov"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Intro","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,0,11,6],[6,0,6,6],[7,0,7,6],[8,0,8,6],[9,0,9,6],[10,0,10,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[5,0,5,6]]}
["Zavedenie školských autobusov v okresoch Senica a Zlaté Moravce a zrušenie malých škôl"]
["Ex- ante hodnotenie politiky"]
["Autori: Martin Haluš, Daniela Zápražná"]
["Riešený problém: Finančne neefektívna alokácia žiakov v malých školách, ktorých možno dopraviť do najbližšej väčšej školy do 25 minút (bez uvažovania s časom potrebným na nástup/výstup žiakov)"]
["Alternatívy riešenia problému:"]
["Z nasledujúcich alternatív boli uvažované: "]
["1.    „Nerobiť nič“"]
["2.    „Preplácané lístky“: využitie súčasnej prímestskej dopravy na prepravu žiakov a preplácanie lístkov "]
["3.    „Prenájom“: outsourcing služby súkromnému prevádzkovateľovi a zavedenie školských autobusov "]
["4.    „Vlastné autobusy“ nákup a prevádzka školských autobusov v rámci okresu "]
["Efekty: Monetárne efekty podľa variantu predstavujú náklady na lístky, platbu súkromníkovi alebo náklady na nákup a prevádzku autobusov. Projekt prinesie úsporu na prevádzke zatvorených malých škôl a kompenzačnom príspevku pre malé školy."]
["Analýza citlivosti: Boli testované alternatívne scenáre s rôznou výškou diskontu, inflácie, ceny za km pri prenájme súkromníkovi, miere zachádzok a teda najazdených kilometrov, a nárastu či poklesu kapitálových a prevádzkových nákladov. Na kompletnú analýzu citlivosti bola priložená kalkulačka v Exceli kde možno navoliť ľubovoľnú kombináciu vstupov a kontrolovať všetky výpočty."]

{"sheet":"Kalkulačka","index":1,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[49,3,57,3],[43,3,44,3],[45,3,48,3],[0,0,0,4],[6,0,9,0],[6,3,9,3],[10,0,20,0],[10,3,20,3],[1,4,2,4],[4,4,5,4],[6,4,9,4],[10,4,20,4],[1,3,2,3],[4,0,5,0],[4,3,5,3]]}
["Zlaté Moravce"]
[null,"Diskontná sadzba",0.02,"NPV","Diskontovaná úspora"]
[null,"Indexácia",0.02]
["Nerobiť nič","Ročné náklady na malé školy",{"$f":"VLOOKUP(A1,Predpoklady!A1:J3,10,0)","v":4477465},{"$f":"XNPV($C$2,CMA!C4:V4,CMA!C2:V2)","v":-89539584.015846699},{"$f":"$D$4-D4","v":0}]
["Preplácané lístky","Ročné náklady na lístky",{"$f":"IF(A26=TRUE,VLOOKUP(A1,Predpoklady!$A$1:$I$3,4,0)*C6,VLOOKUP(A1,Predpoklady!$A$1:$I$3,5,0)*C6)","v":31756.294085779158},{"$f":"XNPV($C$2,CMA!C14:V14,CMA!C7:V7)","v":-86731466.160592392},{"$f":"D5-D4","v":2808117.8552543074}]
[null,"Počet školských dní",190]
["Prenájom","Náklad na kilometer",{"$f":"1.3","v":1.3},{"$f":"XNPV($C$2,CMA!C27:V27,CMA!C7:V7)","v":-86770482.136034191},{"$f":"D7-D4","v":2769101.8798125088}]
[null,"Marža",0.05]
[null,"Počet kilometrov vrátane zachádzok",{"$f":"VLOOKUP(A1,Predpoklady!A1:H3,2,0)*(1+C10)*C6","v":24209.8}]
[null,"Zachádzky",0.15]
["Vlastné autobusy","Kapitálové náklady",{"$f":"VLOOKUP(A1,Predpoklady!$A$1:$I$3,6,0)*C12","v":393000},{"$f":"XNPV($C$2,CMA!C50:V50,CMA!C30:V30)","v":-88824011.640717536},{"$f":"D11-D4","v":715572.37512916327}]
[null,"Zmena CAPEX",1]
[null,"Prevádzkové náklady (prvý rok)",{"$f":"SUM(C14:C15,C17)","v":14749.836677862399}]
[null,"Diesel",{"$f":"IF(A1=\"Senica\",Diesel!G6,Diesel!G13)","v":5905.4366778623989}]
[null,"Údržba a opravy",{"$f":"-CMA!C41","v":6781.9}]
[null,"Zmena udržby a opravy",1]
[null,"Poistné",{"$f":"IF(B26=TRUE,VLOOKUP(A1,Predpoklady!$A$1:$I$3,8,0),VLOOKUP(A1,Predpoklady!$A$1:$I$3,9,0))","v":2062.5}]
[null,"Cena za liter (eur)",0.96099999999999997]
[null,"Hrubá mzda vodiča s odmenami",714]
[null,"Nominálny rast miezd",0.04]
[null,"Počet vodičov",{"$f":"VLOOKUP(A1,Predpoklady!A1:H3,7,0)","v":5}]
[]
[]
[]
[]
[true,false]

{"sheet":"Analýza_citlivosti","index":2,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,2,1,3],[1,1,2,1],[8,2,8,3],[8,1,9,1],[8,4,8,5],[1,4,1,5],[1,12,1,13],[8,12,8,13],[1,6,1,7],[1,8,1,9],[1,10,1,11],[8,6,8,7],[8,8,8,9],[8,10,8,11]]}
[]
[null,"BASELINE","Diskont",null,"Inflácia",null,"Cena za km (prenájom)",null,"Zachádzky (prenájom a vlastné autobusy)",null,"CAPEX (vlastné autobusy)",null,"OPEX (vlastné autobusy)"]
[null,null,3.3000000000000002E-2,0.05,0,0.05,1,2,0.05,0.25,1.1000000000000001,0.9,1.1000000000000001,0.6]
["Nerobiť nič",-89539584.015846699,-79596661.219627261,-68930710.002956614,-74669767.565723717,-119579388.63559046,-89539584.015846699,-89539584.015846699,-89539584.015846699,-89539584.015846699,-89539584.015846699,-89539584.015846699,-89539584.015846699,-89539584.015846699]
["Preplácané lístky",-86731466.160592392,-77101959.855762109,-66772216.118136577,-72330369.602488533,-115824369.11380446,-86731466.160592392,-86731466.160592392,-86731466.160592392,-86731466.160592392,-86731466.160592392,-86731466.160592392,-86731466.160592392,-86731466.160592392]
["Prenájom",-86770482.136034191,-77136643.302346408,-66802251.983482845,-72351884.051254839,-115902951.66086753,-86614926.840615541,-87133444.492011011,-86711867.097180784,-86829097.174887568,-86770482.136034191,-86770482.136034191,-86770482.136034191,-86770482.136034191]
["Vlastné busy",-88824011.640717536,-78977849.545961127,-68417684.756615922,-74513447.027906448,-117731413.17376827,-88824011.640717536,-88824011.640717536,-88814813.004550606,-88833210.276884392,-88863311.640717536,-88784711.640717536,-88902603.931884184,-88509642.476050913]
[]
[null,null,"Diskont",null,"Inflácia",null,"Cena za km",null,"Zachádzky (celkovo)",null,"CAPEX (vlastné autobusy)",null,"OPEX (vlastné autobusy)"]
[null,null,{"$f":"C3","v":3.3000000000000002E-2},{"$f":"D3","v":0.05},0,0.05,1,2,0.05,0.25,1.1000000000000001,0.9,1.1000000000000001,0.6]
["Nerobiť nič",{"$f":"-($B4-B4)","v":0},{"$f":"-($B4-C4)","v":9942922.7962194383},20608874.012890086,{"$f":"-($B4-E4)","v":14869816.450122982},-30039804.619743764,{"$f":"-($B4-G4)","v":0},0,0,0,0,0,0,0]
["Preplácané lístky",0,9629506.3048302829,19959250.042455815,{"$f":"-($B5-E5)","v":14401096.558103859},-29092902.953212067,{"$f":"-($B5-G5)","v":0},0,0,0,0,0,0,0]
["Prenájom",0,9633838.8336877823,19968230.152551346,{"$f":"-($B6-E6)","v":14418598.084779352},-29132469.524833336,{"$f":"-($B6-G6)","v":155555.29541864991},-362962.35597681999,58615.038853406906,-58615.038853377104,0,0,0,0]
["Vlastné busy",0,9846162.0947564095,20406326.884101614,{"$f":"-($B7-E7)","v":14310564.612811089},-28907401.533050731,{"$f":"-($B7-G7)","v":0},0,9198.6361669301987,-9198.6361668556929,-39300,39300,-78592.291166648269,314369.16466662288]
[]
["Preplácané lístky",{"$f":"B5-B$4","v":2808117.8552543074},{"$f":"C5-C$4","v":2494701.363865152},{"$f":"D5-D$4","v":2158493.8848200366},{"$f":"E5-E$4","v":2339397.9632351846},3755019.5217860043,2808117.8552543074,2808117.8552543074,2808117.8552543074,2808117.8552543074,2808117.8552543074,2808117.8552543074,2808117.8552543074,2808117.8552543074]
["Prenájom",{"$f":"B6-B$4","v":2769101.8798125088},2460017.9172808528,2128458.0194737688,{"$f":"E6-E$4","v":2317883.5144688785},3676436.9747229367,2924657.1752311587,2406139.5238356888,2827716.9186659157,2710486.8409591317,2769101.8798125088,2769101.8798125088,2769101.8798125088,2769101.8798125088]
["Vlastné busy",{"$f":"B7-B$4","v":715572.37512916327},618811.67366613448,513025.24634069204,{"$f":"E7-E$4","v":156320.53781726956},1847975.4618221968,715572.37512916327,715572.37512916327,724771.01129609346,706373.73896230757,676272.37512916327,754872.37512916327,636980.083962515,1029941.5397957861]

{"sheet":"CMA","index":3,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
["Nulový scenár",null,"2017-01-01","2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01"]
[]
["Ročné náklady (CF)",null,{"$f":"-Kalkulačka!C4","v":-4477465},{"$f":"C4*(1+Kalkulačka!$C$3)","v":-4567014.3},{"$f":"D4*(1+Kalkulačka!$C$3)","v":-4658354.5860000001},{"$f":"E4*(1+Kalkulačka!$C$3)","v":-4751521.67772},{"$f":"F4*(1+Kalkulačka!$C$3)","v":-4846552.1112743998},{"$f":"G4*(1+Kalkulačka!$C$3)","v":-4943483.1534998883},{"$f":"H4*(1+Kalkulačka!$C$3)","v":-5042352.8165698862},{"$f":"I4*(1+Kalkulačka!$C$3)","v":-5143199.8729012841},{"$f":"J4*(1+Kalkulačka!$C$3)","v":-5246063.8703593099},{"$f":"K4*(1+Kalkulačka!$C$3)","v":-5350985.1477664961},{"$f":"L4*(1+Kalkulačka!$C$3)","v":-5458004.8507218258},{"$f":"M4*(1+Kalkulačka!$C$3)","v":-5567164.9477362623},{"$f":"N4*(1+Kalkulačka!$C$3)","v":-5678508.2466909876},{"$f":"O4*(1+Kalkulačka!$C$3)","v":-5792078.4116248079},{"$f":"P4*(1+Kalkulačka!$C$3)","v":-5907919.9798573041},{"$f":"Q4*(1+Kalkulačka!$C$3)","v":-6026078.3794544507},{"$f":"R4*(1+Kalkulačka!$C$3)","v":-6146599.94704354},{"$f":"S4*(1+Kalkulačka!$C$3)","v":-6269531.9459844111},{"$f":"T4*(1+Kalkulačka!$C$3)","v":-6394922.5849040998},{"$f":"U4*(1+Kalkulačka!$C$3)","v":-6522821.0366021823}]
[{"$f":"XNPV(Kalkulačka!C2,C5:V5,C2:V2)","v":12096344419.737463},null,{"$f":"Predpoklady!L2","v":604882850},{"$f":"C5*(1+Kalkulačka!$C$3)","v":616980507},{"$f":"D5*(1+Kalkulačka!$C$3)","v":629320117.13999999},{"$f":"E5*(1+Kalkulačka!$C$3)","v":641906519.48280001},{"$f":"F5*(1+Kalkulačka!$C$3)","v":654744649.87245607},{"$f":"G5*(1+Kalkulačka!$C$3)","v":667839542.86990523},{"$f":"H5*(1+Kalkulačka!$C$3)","v":681196333.72730339},{"$f":"I5*(1+Kalkulačka!$C$3)","v":694820260.40184951},{"$f":"J5*(1+Kalkulačka!$C$3)","v":708716665.60988653},{"$f":"K5*(1+Kalkulačka!$C$3)","v":722890998.92208421},{"$f":"L5*(1+Kalkulačka!$C$3)","v":737348818.90052593},{"$f":"M5*(1+Kalkulačka!$C$3)","v":752095795.27853644},{"$f":"N5*(1+Kalkulačka!$C$3)","v":767137711.18410718},{"$f":"O5*(1+Kalkulačka!$C$3)","v":782480465.40778935},{"$f":"P5*(1+Kalkulačka!$C$3)","v":798130074.71594512},{"$f":"Q5*(1+Kalkulačka!$C$3)","v":814092676.21026409},{"$f":"R5*(1+Kalkulačka!$C$3)","v":830374529.73446941},{"$f":"S5*(1+Kalkulačka!$C$3)","v":846982020.32915878},{"$f":"T5*(1+Kalkulačka!$C$3)","v":863921660.73574197},{"$f":"U5*(1+Kalkulačka!$C$3)","v":881200093.95045686}]
[{"$f":"A5*0.02/20","v":12096344.419737462}]
["Preplácané lístky",null,"2017-01-01","2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01"]
[]
["Ročné náklady na malé školy",null,{"$f":"C4","v":-4477465},{"$f":"D4","v":-4567014.3},-4658354.5860000001,-4751521.67772,-4846552.1112743998,-4943483.1534998883,-5042352.8165698862,-5143199.8729012841,-5246063.8703593099,-5350985.1477664961,-5458004.8507218258,-5567164.9477362623,-5678508.2466909876,-5792078.4116248079,-5907919.9798573041,-6026078.3794544507,-6146599.94704354,-6269531.9459844111,-6394922.5849040998,-6522821.0366021823]
["Úspora pri zavretí škôl",null,{"$f":"IF(Kalkulačka!A1=\"Senica\",Predpoklady!C3,Predpoklady!C2)","v":172893},{"$f":"C10*(1+Kalkulačka!$C$3)","v":176350.86000000002},{"$f":"D10*(1+Kalkulačka!$C$3)","v":179877.87720000002},{"$f":"E10*(1+Kalkulačka!$C$3)","v":183475.43474400003},{"$f":"F10*(1+Kalkulačka!$C$3)","v":187144.94343888003},{"$f":"G10*(1+Kalkulačka!$C$3)","v":190887.84230765764},{"$f":"H10*(1+Kalkulačka!$C$3)","v":194705.59915381079},{"$f":"I10*(1+Kalkulačka!$C$3)","v":198599.71113688702},{"$f":"J10*(1+Kalkulačka!$C$3)","v":202571.70535962476},{"$f":"K10*(1+Kalkulačka!$C$3)","v":206623.13946681726},{"$f":"L10*(1+Kalkulačka!$C$3)","v":210755.60225615359},{"$f":"M10*(1+Kalkulačka!$C$3)","v":214970.71430127666},{"$f":"N10*(1+Kalkulačka!$C$3)","v":219270.1285873022},{"$f":"O10*(1+Kalkulačka!$C$3)","v":223655.53115904826},{"$f":"P10*(1+Kalkulačka!$C$3)","v":228128.64178222924},{"$f":"Q10*(1+Kalkulačka!$C$3)","v":232691.21461787383},{"$f":"R10*(1+Kalkulačka!$C$3)","v":237345.03891023132},{"$f":"S10*(1+Kalkulačka!$C$3)","v":242091.93968843596},{"$f":"T10*(1+Kalkulačka!$C$3)","v":246933.77848220468},{"$f":"U10*(1+Kalkulačka!$C$3)","v":251872.45405184879}]
["Ročné náklady na lístky",null,{"$f":"-Kalkulačka!C5","v":-31756.294085779158},{"$f":"C11*(1+Kalkulačka!$C$3)","v":-32391.419967494741},{"$f":"D11*(1+Kalkulačka!$C$3)","v":-33039.248366844637},{"$f":"E11*(1+Kalkulačka!$C$3)","v":-33700.033334181528},{"$f":"F11*(1+Kalkulačka!$C$3)","v":-34374.034000865162},{"$f":"G11*(1+Kalkulačka!$C$3)","v":-35061.514680882465},{"$f":"H11*(1+Kalkulačka!$C$3)","v":-35762.744974500114},{"$f":"I11*(1+Kalkulačka!$C$3)","v":-36477.99987399012},{"$f":"J11*(1+Kalkulačka!$C$3)","v":-37207.559871469923},{"$f":"K11*(1+Kalkulačka!$C$3)","v":-37951.71106889932},{"$f":"L11*(1+Kalkulačka!$C$3)","v":-38710.745290277308},{"$f":"M11*(1+Kalkulačka!$C$3)","v":-39484.960196082851},{"$f":"N11*(1+Kalkulačka!$C$3)","v":-40274.659400004508},{"$f":"O11*(1+Kalkulačka!$C$3)","v":-41080.152588004596},{"$f":"P11*(1+Kalkulačka!$C$3)","v":-41901.755639764691},{"$f":"Q11*(1+Kalkulačka!$C$3)","v":-42739.790752559988},{"$f":"R11*(1+Kalkulačka!$C$3)","v":-43594.586567611186},{"$f":"S11*(1+Kalkulačka!$C$3)","v":-44466.478298963411},{"$f":"T11*(1+Kalkulačka!$C$3)","v":-45355.807864942682},{"$f":"U11*(1+Kalkulačka!$C$3)","v":-46262.924022241539}]
["Náklady na dovybavenie škôl",null,{"$f":"-VLOOKUP(Kalkulačka!A1,Predpoklady!A1:K3,11,0)","v":-14310}]
[]
["CF",null,{"$f":"C9+C10+C11+C12","v":-4350638.2940857792},{"$f":"D9+D10+D11","v":-4423054.8599674944},-4511515.957166845,-4601746.2763101812,-4693781.2018363848,-4787656.8258731132,-4883409.9623905756,-4981078.1616383875,-5080699.7248711549,-5182313.7193685779,-5285959.9937559497,-5391679.1936310679,-5499512.7775036907,-5609503.0330537641,-5721693.0937148398,-5836126.955589137,-5952849.4947009198,-6071906.4845949383,-6193344.6142868381,-6317211.5065725753]
[]
[]
["Prenájom",null,"2017-01-01","2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01"]
[]
["Ročné náklady na malé školy",null,{"$f":"C9","v":-4477465},{"$f":"D9","v":-4567014.3},-4658354.5860000001,-4751521.67772,-4846552.1112743998,-4943483.1534998883,-5042352.8165698862,-5143199.8729012841,-5246063.8703593099,-5350985.1477664961,-5458004.8507218258,-5567164.9477362623,-5678508.2466909876,-5792078.4116248079,-5907919.9798573041,-6026078.3794544507,-6146599.94704354,-6269531.9459844111,-6394922.5849040998,-6522821.0366021823]
["Úspora pri zavretí škôl",null,{"$f":"C10","v":172893},{"$f":"D10","v":176350.86000000002},179877.87720000002,183475.43474400003,187144.94343888003,190887.84230765764,194705.59915381079,198599.71113688702,202571.70535962476,206623.13946681726,210755.60225615359,214970.71430127666,219270.1285873022,223655.53115904826,228128.64178222924,232691.21461787383,237345.03891023132,242091.93968843596,246933.77848220468,251872.45405184879]
["Náklady na dovybavenie škôl",null,{"$f":"C12","v":-14310}]
[]
["Cena za km",null,{"$f":"OPEX!G37","v":1.3923000000000001},{"$f":"OPEX!H37","v":1.4201460000000001},{"$f":"OPEX!I37","v":1.4485489200000001},{"$f":"OPEX!J37","v":1.4775198984000002},{"$f":"OPEX!K37","v":1.5070702963680003},{"$f":"OPEX!L37","v":1.5372117022953604},{"$f":"OPEX!M37","v":1.5679559363412676},{"$f":"OPEX!N37","v":1.599315055068093},{"$f":"OPEX!O37","v":1.6313013561694549},{"$f":"OPEX!P37","v":1.6639273832928441},{"$f":"OPEX!Q37","v":1.6972059309587009},{"$f":"OPEX!R37","v":1.7311500495778749},{"$f":"OPEX!S37","v":1.7657730505694325},{"$f":"OPEX!T37","v":1.8010885115808211},{"$f":"OPEX!U37","v":1.8371102818124374},{"$f":"OPEX!V37","v":1.8738524874486862},{"$f":"OPEX!W37","v":1.91132953719766},{"$f":"OPEX!X37","v":1.9495561279416131},{"$f":"OPEX!Y37","v":1.9885472505004453},{"$f":"OPEX!Z37","v":2.0283181955104541}]
["Počet km",null,{"$f":"Kalkulačka!C9","v":24209.8},{"$f":"C24","v":24209.8},{"$f":"D24","v":24209.8},24209.8,24209.8,24209.8,24209.8,24209.8,24209.8,24209.8,24209.8,24209.8,24209.8,24209.8,24209.8,24209.8,{"$f":"R24","v":24209.8},24209.8,24209.8,24209.8]
["Ročná platba súkromníkovi",null,{"$f":"-C23*C24","v":-33707.304540000005},-34381.450630800005,-35069.079643416,-35770.461236284325,-36485.87046101001,-37215.587870230214,-37959.899627634819,-38719.097620187516,-39493.47957259127,-40283.349164043095,-41089.016147323957,-41910.796470270434,-42749.012399675841,-43603.992647669358,-44476.072500622744,-45365.593950635201,-46272.905829647905,-47198.363946240861,-48142.331225165683,-49105.177849668988]
[]
["CF",null,{"$f":"C19+C20+C25+C21","v":-4352589.3045399999},{"$f":"D19+D20+D25","v":-4425044.8906307993},-4513545.7884434164,-4603816.7042122837,-4695893.03829653,-4789810.8990624603,-4885607.1170437103,-4983319.2593845846,-5082985.6445722766,-5184645.3574637221,-5288338.264612996,-5394105.0299052559,-5501987.130503362,-5612026.8731134292,-5724267.4105756981,-5838752.758787212,-5955527.813962956,-6074638.3702422157,-6196131.1376470616,-6320053.7604000028]
[]
[null,null,{"$f":"DATE(C30,1,1)","v":{"$error":"#NUM!"}},{"$f":"DATE(D30,1,1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Vlastné autobusy",null,"2017-01-01","2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01"]
[]
["Ročné náklady na malé školy",null,{"$f":"C19","v":-4477465},{"$f":"D19","v":-4567014.3},-4658354.5860000001,-4751521.67772,-4846552.1112743998,-4943483.1534998883,-5042352.8165698862,-5143199.8729012841,-5246063.8703593099,-5350985.1477664961,-5458004.8507218258,-5567164.9477362623,-5678508.2466909876,-5792078.4116248079,-5907919.9798573041,-6026078.3794544507,-6146599.94704354,-6269531.9459844111,-6394922.5849040998,-6522821.0366021823]
["Úspora pri zavretí škôl",null,{"$f":"C20","v":172893},176350.86000000002,179877.87720000002,183475.43474400003,187144.94343888003,190887.84230765764,194705.59915381079,198599.71113688702,202571.70535962476,206623.13946681726,210755.60225615359,214970.71430127666,219270.1285873022,223655.53115904826,228128.64178222924,232691.21461787383,237345.03891023132,242091.93968843596,246933.77848220468,251872.45405184879]
["Náklady na dovybavenie škôl",null,-14310]
[]
["Kapitálové nákaldy",null,{"$f":"-Kalkulačka!C11","v":-393000}]
[]
["Prevádzkové náklady",null,{"$f":"C41+C46+C47+C48","v":-72669.516677862412},{"$f":"D41+D46+D47+D48","v":-75074.797371285298},-88817.552500655584,-96184.808449076838,-100741.34022822208,-106006.87741610262,-113320.11033220918,-127664.59645951811,-152043.06712323404,-155913.33443653578,-159976.29852400301,-164108.05503382749,-168442.90295035794,-172921.85271898843,-177550.6346958807,-182350.4079355117,-187296.96932955456,-192420.86311114463,-197717.29073914158,-203198.42117758427]
["Odpisy",null,{"$f":"$C$36*0.25","v":-98250},{"$f":"$C$36*0.25","v":-98250},{"$f":"$C$36*0.25","v":-98250},{"$f":"$C$36*0.25","v":-98250}]
[]
["Údržba a opravy",null,{"$f":"-SUM(C42:C44)","v":-6781.9},-6781.9,-18025.5,-22796,-24654.3,-27116.1,-31515.9,-42832.9,-64065.299999999988,-64666.2,-65331.6,-65932.5,-66597.899999999994,-67263.3,-67928.7,-68609.3,-69274.7,-69949,-70620.7,-71295]
["Typ 1",null,{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!G25,OPEX!G30)*Kalkulačka!$C$16","v":333.9},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!H25,OPEX!H30)*Kalkulačka!$C$16","v":333.9},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!I25,OPEX!I30)*Kalkulačka!$C$16","v":894.6},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!J25,OPEX!J30)*Kalkulačka!$C$16","v":1127.7},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!K25,OPEX!K30)*Kalkulačka!$C$16","v":1222.2},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!L25,OPEX!L30)*Kalkulačka!$C$16","v":1341.8999999999999},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!M25,OPEX!M30)*Kalkulačka!$C$16","v":1562.3999999999999},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!N25,OPEX!N30)*Kalkulačka!$C$16","v":2123.1},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!O25,OPEX!O30)*Kalkulačka!$C$16","v":3175.2},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!P25,OPEX!P30)*Kalkulačka!$C$16","v":3206.7000000000003},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!Q25,OPEX!Q30)*Kalkulačka!$C$16","v":3238.2000000000003},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!R25,OPEX!R30)*Kalkulačka!$C$16","v":3269.7000000000003},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!S25,OPEX!S30)*Kalkulačka!$C$16","v":3301.2000000000003},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!T25,OPEX!T30)*Kalkulačka!$C$16","v":3332.7000000000003},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!U25,OPEX!U30)*Kalkulačka!$C$16","v":3364.2000000000003},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!V25,OPEX!V30)*Kalkulačka!$C$16","v":3402},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!W25,OPEX!W30)*Kalkulačka!$C$16","v":3433.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!X25,OPEX!X30)*Kalkulačka!$C$16","v":3465},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!Y25,OPEX!Y30)*Kalkulačka!$C$16","v":3502.7999999999997},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!Z25,OPEX!Z30)*Kalkulačka!$C$16","v":3534.2999999999997}]
["Typ 2",null,{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!G26,OPEX!G31)*Kalkulačka!$C$16","v":578.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!H26,OPEX!H31)*Kalkulačka!$C$16","v":578.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!I26,OPEX!I31)*Kalkulačka!$C$16","v":1521.9},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!J26,OPEX!J31)*Kalkulačka!$C$16","v":1931.3},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!K26,OPEX!K31)*Kalkulačka!$C$16","v":2082.6},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!L26,OPEX!L31)*Kalkulačka!$C$16","v":2296.1999999999998},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!M26,OPEX!M31)*Kalkulačka!$C$16","v":2670},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!N26,OPEX!N31)*Kalkulačka!$C$16","v":3622.3},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!O26,OPEX!O31)*Kalkulačka!$C$16","v":5420.1},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!P26,OPEX!P31)*Kalkulačka!$C$16","v":5473.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!Q26,OPEX!Q31)*Kalkulačka!$C$16","v":5526.9000000000005},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!R26,OPEX!R31)*Kalkulačka!$C$16","v":5580.3},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!S26,OPEX!S31)*Kalkulačka!$C$16","v":5633.7},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!T26,OPEX!T31)*Kalkulačka!$C$16","v":5687.0999999999995},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!U26,OPEX!U31)*Kalkulačka!$C$16","v":5740.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!V26,OPEX!V31)*Kalkulačka!$C$16","v":5802.7999999999993},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!W26,OPEX!W31)*Kalkulačka!$C$16","v":5856.2},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!X26,OPEX!X31)*Kalkulačka!$C$16","v":5918.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!Y26,OPEX!Y31)*Kalkulačka!$C$16","v":5971.9000000000005},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!Z26,OPEX!Z31)*Kalkulačka!$C$16","v":6034.2}]
["Typ 3",null,{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!G27,OPEX!G32)*Kalkulačka!$C$16","v":5869.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!H27,OPEX!H32)*Kalkulačka!$C$16","v":5869.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!I27,OPEX!I32)*Kalkulačka!$C$16","v":15609},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!J27,OPEX!J32)*Kalkulačka!$C$16","v":19737},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!K27,OPEX!K32)*Kalkulačka!$C$16","v":21349.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!L27,OPEX!L32)*Kalkulačka!$C$16","v":23478},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!M27,OPEX!M32)*Kalkulačka!$C$16","v":27283.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!N27,OPEX!N32)*Kalkulačka!$C$16","v":37087.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!O27,OPEX!O32)*Kalkulačka!$C$16","v":55469.999999999993},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!P27,OPEX!P32)*Kalkulačka!$C$16","v":55986},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!Q27,OPEX!Q32)*Kalkulačka!$C$16","v":56566.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!R27,OPEX!R32)*Kalkulačka!$C$16","v":57082.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!S27,OPEX!S32)*Kalkulačka!$C$16","v":57662.999999999993},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!T27,OPEX!T32)*Kalkulačka!$C$16","v":58243.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!U27,OPEX!U32)*Kalkulačka!$C$16","v":58824},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!V27,OPEX!V32)*Kalkulačka!$C$16","v":59404.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!W27,OPEX!W32)*Kalkulačka!$C$16","v":59985},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!X27,OPEX!X32)*Kalkulačka!$C$16","v":60565.5},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!Y27,OPEX!Y32)*Kalkulačka!$C$16","v":61146},{"$f":"IF(Kalkulačka!$A$1=\"Senica\",OPEX!Z27,OPEX!Z32)*Kalkulačka!$C$16","v":61726.499999999993}]
[]
["Diesel",null,{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!G6,Diesel!G13)","v":-5905.4366778623989},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!H6,Diesel!H13)","v":-5952.6801712852985},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!I6,Diesel!I13)","v":-6000.3016126555804},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!J6,Diesel!J13)","v":-6048.3040255568258},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!K6,Diesel!K13)","v":-6096.6904577612804},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!L6,Diesel!L13)","v":-6145.4639814233706},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!M6,Diesel!M13)","v":-6194.6276932747569},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!N6,Diesel!N13)","v":-6244.1847148209554},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!O6,Diesel!O13)","v":-6294.1381925395235},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!P6,Diesel!P13)","v":-6344.491298079839},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!Q6,Diesel!Q13)","v":-6395.2472284644773},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!R6,Diesel!R13)","v":-6446.4092062921936},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!S6,Diesel!S13)","v":-6497.9804799425319},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!T6,Diesel!T13)","v":-6549.964323782071},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!U6,Diesel!U13)","v":-6602.3640383723287},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!V6,Diesel!V13)","v":-6655.1829506793074},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!W6,Diesel!W13)","v":-6708.4244142847419},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!X6,Diesel!X13)","v":-6762.0918095990191},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!Y6,Diesel!Y13)","v":-6816.1885440758124},{"$f":"-IF(Kalkulačka!$A$1=\"Senica\",Diesel!Z6,Diesel!Z13)","v":-6870.7180524284195}]
["Poistenie",null,{"$f":"-Kalkulačka!C17","v":-2062.5},{"$f":"C47*(1+Kalkulačka!$C$3)","v":-2103.75},{"$f":"D47*(1+Kalkulačka!$C$3)","v":-2145.8249999999998},{"$f":"E47*(1+Kalkulačka!$C$3)","v":-2188.7414999999996},{"$f":"F47*(1+Kalkulačka!$C$3)","v":-2232.5163299999995},{"$f":"G47*(1+Kalkulačka!$C$3)","v":-2277.1666565999994},{"$f":"H47*(1+Kalkulačka!$C$3)","v":-2322.7099897319995},{"$f":"I47*(1+Kalkulačka!$C$3)","v":-2369.1641895266393},{"$f":"J47*(1+Kalkulačka!$C$3)","v":-2416.5474733171723},{"$f":"K47*(1+Kalkulačka!$C$3)","v":-2464.8784227835158},{"$f":"L47*(1+Kalkulačka!$C$3)","v":-2514.1759912391863},{"$f":"M47*(1+Kalkulačka!$C$3)","v":-2564.4595110639702},{"$f":"N47*(1+Kalkulačka!$C$3)","v":-2615.7487012852498},{"$f":"O47*(1+Kalkulačka!$C$3)","v":-2668.0636753109547},{"$f":"P47*(1+Kalkulačka!$C$3)","v":-2721.424948817174},{"$f":"Q47*(1+Kalkulačka!$C$3)","v":-2775.8534477935177},{"$f":"R47*(1+Kalkulačka!$C$3)","v":-2831.3705167493881},{"$f":"S47*(1+Kalkulačka!$C$3)","v":-2887.997927084376},{"$f":"T47*(1+Kalkulačka!$C$3)","v":-2945.7578856260634},{"$f":"U47*(1+Kalkulačka!$C$3)","v":-3004.6730433385846}]
["Mzdové náklady",null,{"$f":"-Kalkulačka!$C$19*1.352*Kalkulačka!$C$21*12","v":-57919.680000000008},{"$f":"C48*(1+Kalkulačka!$C$20)","v":-60236.467200000006},{"$f":"D48*(1+Kalkulačka!$C$20)","v":-62645.925888000005},{"$f":"E48*(1+Kalkulačka!$C$20)","v":-65151.762923520007},{"$f":"F48*(1+Kalkulačka!$C$20)","v":-67757.833440460803},{"$f":"G48*(1+Kalkulačka!$C$20)","v":-70468.146778079245},{"$f":"H48*(1+Kalkulačka!$C$20)","v":-73286.872649202414},{"$f":"I48*(1+Kalkulačka!$C$20)","v":-76218.34755517052},{"$f":"J48*(1+Kalkulačka!$C$20)","v":-79267.081457377339},{"$f":"K48*(1+Kalkulačka!$C$20)","v":-82437.764715672442},{"$f":"L48*(1+Kalkulačka!$C$20)","v":-85735.275304299343},{"$f":"M48*(1+Kalkulačka!$C$20)","v":-89164.686316471314},{"$f":"N48*(1+Kalkulačka!$C$20)","v":-92731.273769130174},{"$f":"O48*(1+Kalkulačka!$C$20)","v":-96440.524719895388},{"$f":"P48*(1+Kalkulačka!$C$20)","v":-100298.14570869121},{"$f":"Q48*(1+Kalkulačka!$C$20)","v":-104310.07153703886},{"$f":"R48*(1+Kalkulačka!$C$20)","v":-108482.47439852043},{"$f":"S48*(1+Kalkulačka!$C$20)","v":-112821.77337446125},{"$f":"T48*(1+Kalkulačka!$C$20)","v":-117334.6443094397},{"$f":"U48*(1+Kalkulačka!$C$20)","v":-122028.03008181728}]
[]
["CF",null,{"$f":"C32+C33+C34+C38+C36","v":-4784551.516677862},{"$f":"D32+D33+D34+D38+D36","v":-4465738.2373712845},-4567294.261300656,-4664231.0514250761,-4760148.508063742,-4858602.1886083325,-4960967.3277482847,-5072264.7582239155,-5195535.2321229195,-5300275.3427362144,-5407225.5469896756,-5516302.2884688126,-5627681.0210540434,-5741344.7331847483,-5857341.9727709563,-5975737.5727720885,-6096551.877462863,-6219860.8694071202,-6345706.0971610369,-6474147.0037279185]

{"sheet":"Predpoklady","index":4,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,5,9,5],[1,11,2,11]]}
["Okres","Počet km","Úspora"," Cena lístkov s dotáciou (eur)"," Cena lístkov denne (eur)","CAPEX","Počet vodičov","PZP + Havaríjne","PZP","Celkové náklady na malé školy","Náklady na dovybavenie","Celkové náklady na školy"]
["Zlaté Moravce",{"$f":"Diesel!C13/Kalkulačka!C6","v":110.8},172893,{"$f":"Ceny_listkov!J24*2/1.2","v":167.13838992515346},{"$f":"Ceny_listkov!G24*2/1.2","v":79.500000000000014},{"$f":"B8*D8+B9*D9+B10*D10","v":393000},{"$f":"SUM(B8:B10)","v":5},{"$f":"(I8+K8)*B8+(I9+K9)*B9+(I10+K10)*B10","v":6005.8000000000011},{"$f":"B8*I8+B9*I9+B10*I10","v":2062.5},4477465,{"$f":"90*Ceny_listkov!F36","v":14310},604882850]
["Senica",{"$f":"Diesel!C6/Kalkulačka!C6","v":272},255279,{"$f":"Ceny_listkov!J14*2/1.2","v":263.95251390066693},{"$f":"Ceny_listkov!G14*2/1.2","v":125.55},{"$f":"C8*D8+C9*D9+C10*D10","v":886000},{"$f":"SUM(C8:C10)","v":8},{"$f":"(I8+K8)*C8+(I9+K9)*C9+(I10+K10)*C10","v":12802.89},{"$f":"C8*I8+C9*I9+C10*I10","v":3315},7314756,{"$f":"90*Ceny_listkov!B41","v":23940}]
[]
[]
[]
["Veľkosť autobusu","Zlaté Moravce (počet)","Senica \n(počet)","Jednotková cena bez DPH","Spotreba (l na 100 mk)","Podiel ceny ropy na cene nafty","Model","Počet miest na sedenie","PZP","Havarijné  - bez krádeže","Havaríjne - s krádežou","Kwh","HP","Objem","Váha"]
["Veľký bus",0,2,215000,28,0.6,"Mercedes Benz Tourismo                      ",50,442.5,2331.7399999999998,2590.83,260.2,365,11980]
["Stredný bus",3,3,89000,19,null,"ISUZU Novo Ultra                                  ",25,442.5,965.23,1072.48,140,null,null,9800]
["Malý bus",2,3,63000,10.1,null,"Mercedes Benz Sprinter 519 CDI          ",20,367.5,326.64,362.93,120,163,2143,2268]
[null,{"$f":"SUM(B8:B10)","v":5},{"$f":"SUM(C8:C10)","v":8}]
[]
[]
[null,"SAD Trenčín 2014","Arriva Trnava 2013"]
["Tržby z dopravy",9279,8407870]
["Náhrada straty",12681,{"$f":"8421948+846633","v":9268581}]
[null,{"$f":"C17","v":2.1023696845931252},{"$f":"(C15+C16)/C15","v":2.1023696845931252}]

{"sheet":"OPEX","index":5,"n_rows":37,"n_cols":26,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,25],[23,0,23,25],[28,0,28,25]]}
["Výdavky na údržbu a opravy ako % z obstarávacej ceny autobusu"]
["Typ","Kapacita","Okres","Počet km za rok",null,null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[1,"20 osôb","Zlaté Moravce",1672.0000000000002,null,null,0.01,0.01,0.01,{"$f":"I3+0.01","v":0.02},0.03,0.04,0.05,6.0000000000000005E-2,7.0000000000000007E-2,0.08,0.09,9.9999999999999992E-2,0.10999999999999999,0.11999999999999998,0.12999999999999998,0.13999999999999999,0.15,0.16,0.17,0.18000000000000002]
[2,"20 osôb","Senica",3192,null,null,0.02,0.02,0.02,{"$f":"I4+0.01","v":0.03},0.04,0.05,6.0000000000000005E-2,7.0000000000000007E-2,0.08,0.09,9.9999999999999992E-2,0.10999999999999999,0.11999999999999998,0.12999999999999998,0.13999999999999999,0.15,0.16,0.17,0.18000000000000002,0.19000000000000003]
[2,"20 osôb","Senica",5396,null,null,0.02,0.02,0.02,{"$f":"I5+0.01","v":0.03},0.04,0.05,6.0000000000000005E-2,7.0000000000000007E-2,0.08,0.09,9.9999999999999992E-2,0.10999999999999999,0.11999999999999998,0.12999999999999998,0.13999999999999999,0.15,0.16,0.17,0.18000000000000002,0.19000000000000003]
[3,"25 osôb","Zlaté Moravce",3268,null,null,0.02,0.02,0.02,{"$f":"I6+0.01","v":0.03},0.04,0.05,6.0000000000000005E-2,7.0000000000000007E-2,0.08,0.09,9.9999999999999992E-2,0.10999999999999999,0.11999999999999998,0.12999999999999998,0.13999999999999999,0.15,0.16,0.17,0.18000000000000002,0.19000000000000003]
[3,"25 osôb","Senica",4636,null,null,0.02,0.02,0.02,{"$f":"I7+0.01","v":0.03},0.04,0.05,6.0000000000000005E-2,7.0000000000000007E-2,0.08,0.09,9.9999999999999992E-2,0.10999999999999999,0.11999999999999998,0.12999999999999998,0.13999999999999999,0.15,0.16,0.17,0.18000000000000002,0.19000000000000003]
[3,"25 osôb","Senica",6460,null,null,0.02,0.02,0.02,{"$f":"I8+0.01","v":0.03},0.04,0.05,6.0000000000000005E-2,7.0000000000000007E-2,0.08,0.09,9.9999999999999992E-2,0.10999999999999999,0.11999999999999998,0.12999999999999998,0.13999999999999999,0.15,0.16,0.17,0.18000000000000002,0.19000000000000003]
[4,"50 osôb","Zlaté Moravce",3724.0000000000005,null,null,0.02,0.02,0.02,{"$f":"I9+0.015","v":3.5000000000000003E-2},0.05,6.5000000000000002E-2,0.08,9.5000000000000001E-2,0.11,0.125,0.14000000000000001,0.15500000000000003,0.17000000000000004,0.18500000000000005,0.20000000000000007,0.21500000000000008,0.23000000000000009,0.24500000000000011,0.26000000000000012,0.27500000000000013]
[4,"50 osôb","Zlaté Moravce",4408,null,null,0.02,0.02,0.02,{"$f":"I10+0.015","v":3.5000000000000003E-2},0.05,6.5000000000000002E-2,0.08,9.5000000000000001E-2,0.11,0.125,0.14000000000000001,0.15500000000000003,0.17000000000000004,0.18500000000000005,0.20000000000000007,0.21500000000000008,0.23000000000000009,0.24500000000000011,0.26000000000000012,0.27500000000000013]
[4,"50 osôb","Senica",5776,null,null,0.02,0.02,0.02,{"$f":"I11+0.015","v":3.5000000000000003E-2},0.05,6.5000000000000002E-2,0.08,9.5000000000000001E-2,0.11,0.125,0.14000000000000001,0.15500000000000003,0.17000000000000004,0.18500000000000005,0.20000000000000007,0.21500000000000008,0.23000000000000009,0.24500000000000011,0.26000000000000012,0.27500000000000013]
[4,"50 osôb","Senica",6916,null,null,0.02,0.02,0.02,{"$f":"I12+0.015","v":3.5000000000000003E-2},0.05,6.5000000000000002E-2,0.08,9.5000000000000001E-2,0.11,0.125,0.14000000000000001,0.15500000000000003,0.17000000000000004,0.18500000000000005,0.20000000000000007,0.21500000000000008,0.23000000000000009,0.24500000000000011,0.26000000000000012,0.27500000000000013]
[4,"50 osôb","Senica",7144,null,null,0.02,0.02,0.02,{"$f":"I13+0.015","v":3.5000000000000003E-2},0.05,6.5000000000000002E-2,0.08,9.5000000000000001E-2,0.11,0.125,0.14000000000000001,0.15500000000000003,0.17000000000000004,0.18500000000000005,0.20000000000000007,0.21500000000000008,0.23000000000000009,0.24500000000000011,0.26000000000000012,0.27500000000000013]
[4,"50 osôb","Zlaté Moravce",7980,null,null,0.02,0.02,0.02,{"$f":"I14+0.015","v":3.5000000000000003E-2},0.05,6.5000000000000002E-2,0.08,9.5000000000000001E-2,0.11,0.125,0.14000000000000001,0.15500000000000003,0.17000000000000004,0.18500000000000005,0.20000000000000007,0.21500000000000008,0.23000000000000009,0.24500000000000011,0.26000000000000012,0.27500000000000013]
[5,"50 osôb","Senica",12160,null,null,0.03,0.03,0.03,{"$f":"I15+0.02","v":0.05},7.0000000000000007E-2,9.0000000000000011E-2,0.11000000000000001,0.13,0.15,0.16999999999999998,0.18999999999999997,0.20999999999999996,0.22999999999999995,0.24999999999999994,0.26999999999999996,0.28999999999999998,0.31,0.33,0.35000000000000003,0.37000000000000005]
[]
[null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
["Typ",null,null,"Senica (počet)","Zlaté Moravce","2016-01-01","2017-01-01","2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01"]
[1,null,null,2,1,{"$f":"Predpoklady!D10","v":63000},5.3E-3,5.3E-3,1.4200000000000001E-2,1.7899999999999999E-2,1.9400000000000001E-2,2.1299999999999999E-2,2.4799999999999999E-2,3.3700000000000001E-2,5.04E-2,5.0900000000000001E-2,5.1400000000000001E-2,5.1900000000000002E-2,5.2400000000000002E-2,5.2900000000000003E-2,5.3400000000000003E-2,5.3999999999999999E-2,5.45E-2,5.5E-2,5.5599999999999997E-2,5.6099999999999997E-2]
[2,null,null,2,1,{"$f":"Predpoklady!D9","v":89000},6.4999999999999997E-3,6.4999999999999997E-3,1.7100000000000001E-2,2.1700000000000001E-2,2.3400000000000001E-2,2.58E-2,0.03,4.07E-2,6.0900000000000003E-2,6.1499999999999999E-2,6.2100000000000002E-2,6.2700000000000006E-2,6.3299999999999995E-2,6.3899999999999998E-2,6.4500000000000002E-2,6.5199999999999994E-2,6.5799999999999997E-2,6.6500000000000004E-2,6.7100000000000007E-2,6.7799999999999999E-2]
[3,null,null,4,3,{"$f":"Predpoklady!D8","v":215000},9.1000000000000004E-3,9.1000000000000004E-3,2.4199999999999999E-2,3.0599999999999999E-2,3.3099999999999997E-2,3.6400000000000002E-2,4.2299999999999997E-2,5.7500000000000002E-2,8.5999999999999993E-2,8.6800000000000002E-2,8.77E-2,8.8499999999999995E-2,8.9399999999999993E-2,9.0300000000000005E-2,9.1200000000000003E-2,9.2100000000000001E-2,9.2999999999999999E-2,9.3899999999999997E-2,9.4799999999999995E-2,9.5699999999999993E-2]
[null,null,null,{"$f":"SUM(D19:D21)","v":8},{"$f":"SUM(E19:E21)","v":5}]
[]
["Senica - výdavky na údržbu a opravu"]
[1,null,null,null,null,null,{"$f":"$D19*$F19*G19","v":667.8},{"$f":"$D19*$F19*H19","v":667.8},1789.2,2255.4,2444.4,2683.7999999999997,3124.7999999999997,4246.2,6350.4,6413.4000000000005,6476.4000000000005,6539.4000000000005,6602.4000000000005,6665.4000000000005,6728.4000000000005,6804,6867,6930,7005.5999999999995,7068.5999999999995]
[2,null,null,null,null,null,{"$f":"$D20*$F20*G20","v":1157},{"$f":"$D20*$F20*H20","v":1157},3043.8,3862.6,4165.2,4592.3999999999996,5340,7244.6,10840.2,10947,11053.800000000001,11160.6,11267.4,11374.199999999999,11481,11605.599999999999,11712.4,11837,11943.800000000001,12068.4]
[3,null,null,null,null,null,{"$f":"$D21*$F21*G21","v":7826},{"$f":"$D21*$F21*H21","v":7826},20812,26316,28465.999999999996,31304,36378,49450,73960,74648,75422,76110,76884,77658,78432,79206,79980,80754,81528,82302]
[null,null,null,null,null,null,{"$f":"SUM(G25:G27)","v":9650.7999999999993},{"$f":"SUM(H25:H27)","v":9650.7999999999993},25645,32434,35075.599999999999,38580.199999999997,44842.8,60940.800000000003,91150.6,92008.4,92952.2,93810,94753.8,95697.600000000006,96641.4,97615.6,98559.4,99521,100477.4,101439]
["Zlaté Morave - výdavky na údržbu a opravu"]
[1,null,null,null,null,null,{"$f":"$E19*$F19*G19","v":333.9},{"$f":"$E19*$F19*H19","v":333.9},894.6,1127.7,1222.2,1341.8999999999999,1562.3999999999999,2123.1,3175.2,3206.7000000000003,3238.2000000000003,3269.7000000000003,3301.2000000000003,3332.7000000000003,3364.2000000000003,3402,3433.5,3465,3502.7999999999997,3534.2999999999997]
[2,null,null,null,null,null,{"$f":"$E20*$F20*G20","v":578.5},578.5,1521.9,1931.3,2082.6,2296.1999999999998,2670,3622.3,5420.1,5473.5,5526.9000000000005,5580.3,5633.7,5687.0999999999995,5740.5,5802.7999999999993,5856.2,5918.5,5971.9000000000005,6034.2]
[3,null,null,null,null,null,5869.5,5869.5,15609,19737,21349.5,23478,27283.5,37087.5,55469.999999999993,55986,56566.5,57082.5,57662.999999999993,58243.5,58824,59404.5,59985,60565.5,61146,61726.499999999993]
[null,null,null,null,null,null,{"$f":"SUM(G30:G32)","v":6781.9},{"$f":"SUM(H30:H32)","v":6781.9},18025.5,22796,24654.3,27116.1,31515.9,42832.9,64065.299999999988,64666.2,65331.6,65932.5,66597.899999999994,67263.3,67928.7,68609.3,69274.7,69949,70620.7,71295]
[]
["Výdavky na km"]
[null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
["Náklady na celkovú prevádzku s maržou",null,null,null,null,{"$f":"Kalkulačka!C7","v":1.3},{"$f":"F37*(1+Kalkulačka!$C$3)*(1+Kalkulačka!C8)","v":1.3923000000000001},{"$f":"G37*(1+Kalkulačka!$C$3)","v":1.4201460000000001},{"$f":"H37*(1+Kalkulačka!$C$3)","v":1.4485489200000001},{"$f":"I37*(1+Kalkulačka!$C$3)","v":1.4775198984000002},{"$f":"J37*(1+Kalkulačka!$C$3)","v":1.5070702963680003},{"$f":"K37*(1+Kalkulačka!$C$3)","v":1.5372117022953604},{"$f":"L37*(1+Kalkulačka!$C$3)","v":1.5679559363412676},{"$f":"M37*(1+Kalkulačka!$C$3)","v":1.599315055068093},{"$f":"N37*(1+Kalkulačka!$C$3)","v":1.6313013561694549},{"$f":"O37*(1+Kalkulačka!$C$3)","v":1.6639273832928441},{"$f":"P37*(1+Kalkulačka!$C$3)","v":1.6972059309587009},{"$f":"Q37*(1+Kalkulačka!$C$3)","v":1.7311500495778749},{"$f":"R37*(1+Kalkulačka!$C$3)","v":1.7657730505694325},{"$f":"S37*(1+Kalkulačka!$C$3)","v":1.8010885115808211},{"$f":"T37*(1+Kalkulačka!$C$3)","v":1.8371102818124374},{"$f":"U37*(1+Kalkulačka!$C$3)","v":1.8738524874486862},{"$f":"V37*(1+Kalkulačka!$C$3)","v":1.91132953719766},{"$f":"W37*(1+Kalkulačka!$C$3)","v":1.9495561279416131},{"$f":"X37*(1+Kalkulačka!$C$3)","v":1.9885472505004453},{"$f":"Y37*(1+Kalkulačka!$C$3)","v":2.0283181955104541}]

{"sheet":"Diesel","index":6,"n_rows":13,"n_cols":26,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,25],[7,0,7,25]]}
["Senica"]
["Typ autobusu","Počet km deň","Počet km","Prepočítaný počet km","Spotreba",null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[20,45.2,{"$f":"B3*Kalkulačka!$C$6","v":8588},{"$f":"C3*(1+Kalkulačka!$C$10)","v":9876.1999999999989},{"$f":"Predpoklady!E10","v":10.1},null,{"$f":"$D3*$E3/100*Kalkulačka!$C$18*(1+Kalkulačka!$C$3*(1-Predpoklady!F8))","v":966.26259898559977},{"$f":"G3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":973.99269977748452},{"$f":"H3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":981.78464137570438},{"$f":"I3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":989.63891850671007},{"$f":"J3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":997.55602985476378},{"$f":"K3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1005.5364780936019},{"$f":"L3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1013.5807699183507},{"$f":"M3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1021.6894160776975},{"$f":"N3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1029.8629314063191},{"$f":"O3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1038.1018348575697},{"$f":"P3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1046.4066495364302},{"$f":"Q3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1054.7779027327217},{"$f":"R3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1063.2161259545835},{"$f":"S3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1071.7218549622203},{"$f":"T3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1080.295629801918},{"$f":"U3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1088.9379948403334},{"$f":"V3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1097.6494987990561},{"$f":"W3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1106.4306947894486},{"$f":"X3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1115.2821403477642},{"$f":"Y3*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":1124.2043974705464}]
[25,58.4,{"$f":"B4*Kalkulačka!$C$6","v":11096},{"$f":"C4*(1+Kalkulačka!$C$10)","v":12760.4},{"$f":"Predpoklady!E9","v":19},null,{"$f":"$D4*$E4/100*Kalkulačka!$C$18*(1+Kalkulačka!$C$3*(1-Predpoklady!F8))","v":2348.5608074880001},{"$f":"G4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2367.3492939479042},{"$f":"H4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2386.2880882994873},{"$f":"I4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2405.378393005883},{"$f":"J4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2424.6214201499301},{"$f":"K4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2444.0183915111297},{"$f":"L4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2463.5705386432187},{"$f":"M4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2483.2791029523646},{"$f":"N4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2503.1453357759838},{"$f":"O4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2523.1704984621915},{"$f":"P4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2543.3558624498892},{"$f":"Q4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2563.7027093494885},{"$f":"R4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2584.2123310242846},{"$f":"S4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2604.8860296724788},{"$f":"T4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2625.7251179098585},{"$f":"U4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2646.7309188531372},{"$f":"V4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2667.9047662039625},{"$f":"W4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2689.2480043335941},{"$f":"X4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2710.7619883682628},{"$f":"Y4*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":2732.4480842752091}]
[50,168.4,{"$f":"B5*Kalkulačka!$C$6","v":31996},{"$f":"C5*(1+Kalkulačka!$C$10)","v":36795.399999999994},{"$f":"Predpoklady!E8","v":28},null,{"$f":"$D5*$E5/100*Kalkulačka!$C$18*(1+Kalkulačka!$C$3*(1-Predpoklady!F8))","v":9980.1134818559967},{"$f":"G5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10059.954389710845},{"$f":"H5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10140.434024828532},{"$f":"I5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10221.557497027159},{"$f":"J5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10303.329957003376},{"$f":"K5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10385.756596659403},{"$f":"L5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10468.842649432678},{"$f":"M5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10552.593390628139},{"$f":"N5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10637.014137753164},{"$f":"O5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10722.110250855188},{"$f":"P5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10807.88713286203},{"$f":"Q5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10894.350229924927},{"$f":"R5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":10981.505031764325},{"$f":"S5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":11069.35707201844},{"$f":"T5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":11157.911928594587},{"$f":"U5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":11247.175224023344},{"$f":"V5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":11337.15262581553},{"$f":"W5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":11427.849846822055},{"$f":"X5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":11519.272645596631},{"$f":"Y5*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":11611.426826761404}]
[null,{"$f":"SUM(B3:B5)","v":272},{"$f":"SUM(C3:C5)","v":51680},{"$f":"SUM(D3:D5)","v":59431.999999999993},null,null,{"$f":"SUM(G3:G5)","v":13294.936888329597},{"$f":"SUM(H3:H5)","v":13401.296383436234},13508.506754503724,13616.574808539752,13725.50740700807,13835.311466264135,13945.993957994247,14057.561909658201,14170.022404935466,14283.382584174949,14397.649644848349,14512.830842007137,{"$f":"SUM(S3:S5)","v":14628.933488743194},14745.964956653139,14863.932676306364,14982.844137716815,15102.706890818548,15223.528545945097,15345.316774312658,15468.07930850716]
[]
["Zlaté Moravce "]
["Typ autobusu","Počet km deň","Počet km","Prepočítaný počet km","Spotreba",null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[20,8.8000000000000007,{"$f":"B10*Kalkulačka!$C$6","v":1672.0000000000002},{"$f":"C10*(1+Kalkulačka!$C$10)","v":1922.8000000000002},{"$f":"Predpoklady!E10","v":10.1},null,{"$f":"$D10*$E10/100*Kalkulačka!$C$18*(1+Kalkulačka!$C$3*(1-Predpoklady!F8))","v":188.12192192640003},{"$f":"G10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":189.62689730181123},{"$f":"H10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":191.14391248022571},{"$f":"I10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":192.67306378006751},{"$f":"J10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":194.21444829030804},{"$f":"K10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":195.7681638766305},{"$f":"L10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":197.33430918764356},{"$f":"M10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":198.91298366114469},{"$f":"N10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":200.50428753043386},{"$f":"O10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":202.10832183067734},{"$f":"P10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":203.72518840532277},{"$f":"Q10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":205.35498991256534},{"$f":"R10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":206.99782983186586},{"$f":"S10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":208.65381247052079},{"$f":"T10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":210.32304297028494},{"$f":"U10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":212.00562731404722},{"$f":"V10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":213.70167233255961},{"$f":"W10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":215.4112857112201},{"$f":"X10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":217.13457599690986},{"$f":"Y10*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":218.87165260488513}]
[25,17.2,{"$f":"B11*Kalkulačka!$C$6","v":3268},{"$f":"C11*(1+Kalkulačka!$C$10)","v":3758.2},{"$f":"Predpoklady!E9","v":19},null,{"$f":"$D11*$E11/100*Kalkulačka!$C$18*(1+Kalkulačka!$C$3*(1-Predpoklady!F8))","v":691.69941590400003},{"$f":"G11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":697.23301123123201},{"$f":"H11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":702.81087532108188},{"$f":"I11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":708.4333623236505},{"$f":"J11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":714.10082922223967},{"$f":"K11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":719.81363585601764},{"$f":"L11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":725.57214494286575},{"$f":"M11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":731.37672210240873},{"$f":"N11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":737.22773587922802},{"$f":"O11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":743.12555776626186},{"$f":"P11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":749.07056222839196},{"$f":"Q11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":755.06312672621914},{"$f":"R11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":761.10363174002885},{"$f":"S11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":767.19246079394907},{"$f":"T11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":773.33000048030067},{"$f":"U11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":779.51664048414307},{"$f":"V11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":785.75277360801624},{"$f":"W11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":792.03879579688032},{"$f":"X11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":798.3751061632554},{"$f":"Y11*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":804.7621070125615}]
[50,84.8,{"$f":"B12*Kalkulačka!$C$6","v":16112},{"$f":"C12*(1+Kalkulačka!$C$10)","v":18528.8},{"$f":"Predpoklady!E8","v":28},null,{"$f":"$D12*$E12/100*Kalkulačka!$C$18*(1+Kalkulačka!$C$3*(1-Predpoklady!F8))","v":5025.615340031999},{"$f":"G12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5065.8202627522551},{"$f":"H12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5106.3468248542731},{"$f":"I12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5147.1975994531076},{"$f":"J12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5188.3751802487322},{"$f":"K12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5229.8821816907221},{"$f":"L12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5271.7212391442481},{"$f":"M12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5313.8950090574017},{"$f":"N12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5356.4061691298612},{"$f":"O12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5399.2574184829},{"$f":"P12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5442.451477830763},{"$f":"Q12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5485.9910896534093},{"$f":"R12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5529.8790183706369},{"$f":"S12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5574.1180505176017},{"$f":"T12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5618.7109949217429},{"$f":"U12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5663.6606828811173},{"$f":"V12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5708.9699683441659},{"$f":"W12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5754.6417280909191},{"$f":"X12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5800.6788619156468},{"$f":"Y12*(1+Kalkulačka!$C$3*(1-Predpoklady!$F$8))","v":5847.0842928109723}]
[null,{"$f":"SUM(B10:B12)","v":110.8},{"$f":"SUM(C10:C12)","v":21052},{"$f":"SUM(D10:D12)","v":24209.8},null,null,{"$f":"SUM(G10:G12)","v":5905.4366778623989},{"$f":"SUM(H10:H12)","v":5952.6801712852985},6000.3016126555804,6048.3040255568258,6096.6904577612804,6145.4639814233706,6194.6276932747569,6244.1847148209554,6294.1381925395235,6344.491298079839,6395.2472284644773,6446.4092062921936,6497.9804799425319,6549.964323782071,6602.3640383723287,6655.1829506793074,6708.4244142847419,6762.0918095990191,6816.1885440758124,6870.7180524284195]

{"sheet":"Ceny_listkov","index":7,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,2,37,2],[38,2,39,2],[26,4,26,6],[26,0,26,2],[28,6,30,6],[28,2,29,2],[30,2,31,2]]}
["Od","Kam","km","Cena v hotovosti","Cena z čipovej karty","Počet detí",null,null,null,"Zohľadnenie dotácie pre deti ktore pojdu novymi busmi (nad 20)"]
["Kuklov","Šaštín-Stráže",6,0.4,0.25,23,{"$f":"F2*E2","v":5.75},{"$f":"F2*D2","v":9.2000000000000011},null,{"$f":"IF(F2<0,E2*F2,K2)","v":12.08862568641047},{"$f":"G2*Predpoklady!$B$17","v":12.08862568641047}]
["Smolinské","Šaštín-Stráže",4,0.35,0.22,33,{"$f":"F3*E3","v":7.26},{"$f":"F3*D3","v":11.549999999999999},null,{"$f":"IF(F3<0,E3*F3,K3)","v":15.263203910146089},{"$f":"G3*Predpoklady!$B$17","v":15.263203910146089}]
["Koválov","Dojč",5,0.4,0.25,22,5.5,8.8000000000000007,null,11.563033265262188,{"$f":"G4*Predpoklady!$B$17","v":11.563033265262188}]
["Šajdíkove Humence","Dojč",5,0.4,0.25,30,7.5,12,"malo spojeni",15.767772634448439,{"$f":"G5*Predpoklady!$B$17","v":15.767772634448439}]
["Smrdáky","Senica",7,0.4,0.25,22,5.5,8.8000000000000007,null,11.563033265262188,{"$f":"G6*Predpoklady!$B$17","v":11.563033265262188}]
["Častkov","Sobotište","10+9",0.9,0.66,23,15.180000000000001,20.7,"prestup v Senici",31.913971812123645,{"$f":"G7*Predpoklady!$B$17","v":31.913971812123645}]
["Prietrž","Senica",7,0.4,0.25,13,3.25,5.2,null,6.8327014749276573,{"$f":"G8*Predpoklady!$B$17","v":6.8327014749276573}]
["Hlboké","Senica",5,0.4,0.25,13,3.25,5.2,null,6.8327014749276573,{"$f":"G9*Predpoklady!$B$17","v":6.8327014749276573}]
["Hradište pod Vrátnom","Jablonica",5,0.4,0.25,10,2.5,4,null,5.2559242114828129,{"$f":"G10*Predpoklady!$B$17","v":5.2559242114828129}]
["Osuské","Jablonica",2,0.35,0.22,27,5.94,9.4499999999999993,null,12.488075926483164,{"$f":"G11*Predpoklady!$B$17","v":12.488075926483164}]
["Plavecký Peter","Cerová",9,0.45,0.33,15,4.95,6.75,null,10.406729938735971,{"$f":"G12*Predpoklady!$B$17","v":10.406729938735971}]
["Prievaly","Cerová",6,0.4,0.25,35,8.75,14,null,18.395734740189845,{"$f":"G13*Predpoklady!$B$17","v":18.395734740189845}]
[null,null,{"$f":"SUM(C2:C13)+19","v":80},null,{"$f":"SUM(E2:E13)*Predpoklady!B17","v":7.2111280181544197},null,{"$f":"SUM(G2:G13)","v":75.33},{"$f":"SUM(H2:H13)","v":115.65},null,{"$f":"SUM(J2:J13)","v":158.37150834040014},{"$f":"SUM(K2:K13)","v":158.37150834040014},null,{"$f":"E14/C14","v":9.0139100226930252E-2}]
[]
["Od","Kam","km","Cena v hotovosti","Cena z čipovej karty","Počet detí",null,null,null,"Zohľadnenie dotácie pre deti ktore pojdu novymi busmi (nad 20)"]
["Mankovce","Sľažany",7,0.4,0.3,8,{"$f":"F17*E17","v":2.4},{"$f":"F17*D17","v":3.2},"malo spojeni",{"$f":"IF(F17<0,E17*F17,K17)","v":5.0456872430235},{"$f":"G17*Predpoklady!$B$17","v":5.0456872430235}]
["Martin nad Žitavou","Sľažany",3,0.4,0.3,17,{"$f":"F18*E18","v":5.0999999999999996},{"$f":"F18*D18","v":6.8000000000000007},null,{"$f":"IF(F18<0,E18*F18,K18)","v":10.722085391424939},{"$f":"G18*Predpoklady!$B$17","v":10.722085391424939}]
["Velčice","Sľažany",4,0.4,0.3,20,6,8,null,12.614218107558752,{"$f":"G19*Predpoklady!$B$17","v":12.614218107558752}]
["Hostie","Topoľčianky",4,0.4,0.3,45,13.5,18,null,28.38199074200719,{"$f":"G20*Predpoklady!$B$17","v":28.38199074200719}]
["Slepčany","Tesárske Mlyňany",5,0.4,0.3,25,7.5,10,null,15.767772634448439,{"$f":"G21*Predpoklady!$B$17","v":15.767772634448439}]
["Čierne Kľačany","Zlaté Moravce",5,0.4,0.3,32,9.6,12.8,null,20.182748972094,{"$f":"G22*Predpoklady!$B$17","v":20.182748972094}]
["Čaradice","Tekovské Nemce",2,0.4,0.3,12,3.5999999999999996,4.8000000000000007,null,7.5685308645352505,{"$f":"G23*Predpoklady!$B$17","v":7.5685308645352505}]
[null,null,{"$f":"SUM(C17:C23)","v":30},null,{"$f":"SUM(E17:E23)*Predpoklady!B17","v":4.4149763376455633},null,{"$f":"SUM(G17:G23)","v":47.7},{"$f":"SUM(H17:H23)","v":63.599999999999994},null,{"$f":"SUM(J17:J23)","v":100.28303395509207},{"$f":"SUM(K17:K23)","v":100.28303395509207},null,{"$f":"E24/C24","v":0.14716587792151878}]
[]
[]
["Senica a okolie",null,null,null,"Zlate Moravce"]
["Východzia stanica","Počet detí","Cieľová stanica",null,"Východzia stanica","Počet detí","Cieľová stanica"]
["Nová 203, Kuklov",23,"Štúrova 1115,Šaštín Stráže",null,"Mankovce 102",8,"Sľažany 122"]
["Smolinské 407",33,null,null,"Martin nad Žitavou 110",17]
["Koválov 216",22,"Dojč 137",null,"Velčice",20]
["Šajdíkove Humence 102",30,null,null,"Hostie 86",45,"Litoměřická 32, Topoľčianky"]
["Školská 33, Smrdáky",22,"V. P. Tótha 32, Senica",null,"Školská 232, Slepčany ",25,"Školská 608, Tesárske Mlyňany"]
["Častkov 130",23,"Sobotište 317",null,"Školská 2, Čierne Kľačany",32,"Pribinova 1,Zlaté Moravce"]
["Prietrž 138",13,"Sadová 620,Senica",null,"Čaradice 156",12,"Školská 416, Tekovské Nemce"]
["Športová 259, Hlboké",13,"Komenského 959, Senica",null,null,{"$f":"SUM(F29:F35)","v":159}]
["Hradište pod Vrátnom 44",10,"Školská 1, Jablonica"]
["Výhony 11, Osuské",27]
["Plavecký Peter 89",15,"Cerová 277"]
["Prievaly 187",35]
[null,{"$f":"SUM(B29:B40)","v":266}]