{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["ZDO - ROK 2003 ","ZDO - ROK 2002","RK-35-2003-20, př. 1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"ZDO - ROK 2003 ","index":0,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[42,9,42,10],[42,11,42,12],[42,1,42,2],[42,3,42,4],[42,5,42,6],[42,7,42,8],[14,3,14,4],[14,1,14,2],[4,9,4,10],[4,11,4,12],[14,11,14,12],[14,9,14,10],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[18,5,18,6],[18,7,18,8],[14,7,14,8],[14,5,14,6],[18,9,18,10],[18,11,18,12],[26,1,26,2],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[18,1,18,2],[18,3,18,4],[34,9,34,10],[34,11,34,12],[34,1,34,2],[34,3,34,4],[34,5,34,6],[34,7,34,8]],"flags":["formulas_cached_only"]}
[]
["ÚHRADY PROKAZATELNÉ ZTRÁTY VE VEŘEJNÉ LINKOVÉ OSOBNÍ DOPRAVĚ - ROK 2003 (PŘEDPOKLAD DLE STÁVAJÍCÍCH SMLUV O ZÁVAZKU VEŘEJNÉ SLUŽBY, UZAVŘENÝCH NA ROK 2003)"]
["ZÁKLADNÍ DOPRAVNÍ OBSLUŽNOST"]
[]
[null,"Kraj celkem",null,"Havlíčkův Brod",null,"Jihlava",null,"Pelhřimov",null,"Třebíč",null,"Žďár nad Sázavou"]
["Časový segment","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty"]
["Spoje v prac.dny s příj. do 6,00",2222.95,30768.18,425.56,6142.87,435.22,5835.97,352.03,6297.48,452.86,6887.35,557.28,5604.51]
["Spoje v prac dny s příj. mezi 6,01 a 8,00",3615.12,46911.16,695.75,8666.81,585.31,7646.6,471.96,8131.09,878.63,12595.98,983.47,9870.68]
["Spoje v prac. dny prov.mezi 8,01 a 15,30",6100.6,79848.25,966.8,12354.23,1042.54,14485.71,921.4,15592.69,1157.33,16752.23,2012.53,20663.39]
["Spoje v prac. dny s odj. po 15,30",2469.47,40482.49,568.81,9851.44,405.69,9427.89,427.11,6976.75,479.28,8257.53,588.58,5968.88]
["Spoje v prac.dny s odj. po 18,30",310.49,3316.63,35.4,188.01,35.51,426.45,32.17,512.38,33.06,501.23,174.35,1688.56]
["Spoje o nedělích a svátcích",0,0,0,0,0,0,0,0,0,0,0,0]
["Spoje provozované o sobotách",0,0,0,0,0,0,0,0,0,0,0,0]
["Spoje celkem",14718.63,201326.71,2692.3199999999997,37203.36,2504.27,37822.619999999995,2204.67,37510.39,3001.1599999999994,44994.32,4316.21,43796.02]
["Průměrná výše úhrady ztráty (Kč/km)",13.678359330997516,null,13.818327687644858,null,15.103251646188308,null,17.01406106129262,null,14.992309640272431,null,10.146869591609304]
[]
["CHARAKTERISTIKA - KRITÉRIUM"]
["1) DLE POČTU OBYVATEL"]
[null,"Kraj celkem",null,"Havlíčkův Brod",null,"Jihlava",null,"Pelhřimov",null,"Třebíč",null,"Žďár nad Sázavou"]
[null,"počet","%","počet","%","počet","%","počet","%","počet","%","počet","%"]
["Počet obyvatel",521212,100,95435,18.310207746559943,108884,20.89053974198599,73342,14.071433504984538,117603,22.563371526365476,125948,24.164447480104073]
[null,"ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka"]
["Ujeté km/počet obyvatel",28.239238544008963,0,28.211033687850367,-0.02820485615859525,22.999430586679402,-5.23980795732956,30.06012925745139,1.8208907134424273,25.519417021674613,-2.7198215223343496,34.269778003620544,6.030539459611582]
["Úhrada ztráty Kč/počet obyvatel",386.26645203870976,0,389.82930790590456,3.5628558671947985,347.36618786965937,-38.90026416905039,511.4448746966268,125.17842265791705,382.59500182818465,-3.6714502105251086,347.7309683361387,-38.53548370257107]
[]
["2) DLE POČTU OBCÍ"]
[null,"Kraj celkem",null,"Havlíčkův Brod",null,"Jihlava",null,"Pelhřimov",null,"Třebíč",null,"Žďár nad Sázavou"]
[null,"počet","%","počet","%","počet","%","počet","%","počet","%","počet","%"]
["Počet obcí",730,100,120,16.43835616438356,121,16.575342465753423,120,16.43835616438356,173,23.6986301369863,196,26.84931506849315]
[null,"ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka"]
["Ujeté tis.km/ 1 obec",20.16250684931507,0,22.435999999999996,2.273493150684928,20.696446280991736,0.5339394316766679,18.37225,-1.7902568493150675,17.347745664739882,-2.814761184575186,22.021479591836734,1.8589727425216651]
["Úhrada ztráty tis. Kč/ 1 obec",275.7900136986301,0,310.028,34.237986301369915,312.58363636363634,36.79362266500624,312.58658333333335,36.796569634703246,260.082774566474,-15.707239132156133,223.44908163265305,-52.34093206597706]
[]
["3) DLE ROZLOHY OKRESU"]
[null,"Kraj celkem",null,"Havlíčkův Brod",null,"Jihlava",null,"Pelhřimov",null,"Třebíč",null,"Žďár nad Sázavou"]
[null,"rozloha","%","rozloha","%","rozloha","%","rozloha","%","rozloha","%","rozloha","%"]
["Rozloha okresu km2",6925,100,1265,18.267148014440433,1180,17.03971119133574,1284,18.541516245487365,1519,21.935018050541515,1677,24.216606498194945]
[null,"ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka"]
["Ujeté km/km2 rozlohy",2125.4339350180503,0,2128.3162055335965,1.8822705155462245,2122.262711864407,-3.1712231536434956,1717.032710280374,-408.40122473767633,1975.7472021066487,-149.68673291140158,2573.7686344663093,448.334699448259]
["Úhrada ztráty Kč/ km2 rozlohy",29072.449097472923,0,29409.770750988144,337.32165351522053,32053.067796610165,2980.6186991372415,29213.69937694704,141.2502794741158,29621.01382488479,548.5647274118674,26115.694692903995,-2956.7544045689283]
[]
["4) DLE POČTU OBYVATEL S PRACOVIŠTĚM V JINÉ OBCI"]
[null,"Kraj celkem",null,"Havlíčkův Brod",null,"Jihlava",null,"Pelhřimov",null,"Třebíč",null,"Žďár nad Sázavou"]
[null,"počet","%","počet","%","počet","%","počet","%","počet","%","počet","%"]
["Počet obyvatel s pracovištěm v jiné obci",98830,100,18544,18.763533340078922,17540,17.747647475462916,13537,13.697257917636346,23085,23.358292016594152,26124,26.433269250227664]
[null,"ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka","ukazatel","odchylka"]
["Ujeté km/ počet obyv. s prac. v jiné obci",148.9287665688556,0,145.1855047454702,-3.7432618233853816,142.77480045610034,-6.153966112755256,162.8625249316688,13.933758362813194,130.00476499891704,-18.924001569938554,165.22010411881794,16.29133754996235]
["Úhrada ztráty Kč/ počet obyv. s prac. v jiné obci",2037.1011838510574,0,2006.220880069025,-30.880303782032342,2156.3637400228044,119.26255617174706,2770.952943783704,733.8517599326467,1949.0716915746157,-88.02949227644172,1676.466850405757,-360.6343334453004]

{"sheet":"ZDO - ROK 2002","index":1,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[13,5,13,6],[13,7,13,8],[3,5,3,6],[3,7,3,8],[3,1,3,2],[3,3,3,4],[13,1,13,2],[13,3,13,4],[3,9,3,10],[3,11,3,12],[13,9,13,10],[13,11,13,12]],"flags":["formulas_cached_only"]}
["ÚHRADY PROKAZATELNÉ ZTRÁTY VE VEŘEJNÉ LINKOVÉ OSOBNÍ DOPRAVĚ - ROK 2002 ( DLE STÁVAJÍCÍCH SMLUV O ZÁVAZKU VEŘEJNÉ SLUŽBY)"]
["ZÁKLADNÍ DOPRAVNÍ OBSLUŽNOST"]
[]
[null,"Kraj celkem",null,"Havlíčkův Brod",null,"Jihlava",null,"Pelhřimov",null,"Třebíč",null,"Žďár nad Sázavou"]
["Časový segment","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty","Ujeté km (tis. km/rok)","Úhrada ztráty"]
["Spoje v prac.dny s příj. do 6,00",1568.8200000000002,19711.87,367.54,4909.57,116.34,1625.65,90.31,1489.8,437.35,6259.45,557.28,5427.4]
["Spoje v prac dny s příj. mezi 6,01 a 8,00",3458.74,44966.81999999999,665.75,8380.49,503.98,7280.5,472.19,7782.65,859.27,12145.48,957.55,9377.7]
["Spoje v prac. dny prov.mezi 8,01 a 15,30",5976.47,76270.03,943.8,11988.68,961.8,13803.3,920.28,14834.05,1158.62,16181.4,1991.97,19462.6]
["Spoje v prac. dny s odj. po 15,30",1719.5500000000002,22030.06,337.02,4315.86,312.74,4458.35,303.68,5019.5,191.98,2617.65,574.13,5618.7]
["Spoje v prac.dny s odj. po 18,30",279.16999999999996,3234.97,17.4,181.7,31.51,417.2,27.57,501.45,33.06,531.02,169.63,1603.6]
["Spoje o nedělích a svátcích",19.8,270.55,16.37,215.4,0,0,3.43,55.15,0,0,0,0]
["Spoje provozované o sobotách",7.86,96.69999999999999,6.79,79.3,0,0,1.07,17.4,0,0,0,0]
["Spoje celkem",13030.41,166581,2354.6699999999996,30071,1926.37,27584.999999999996,1818.53,29700.000000000004,2680.2799999999997,37735,4250.56,41489.99999999999]
["Průměrná výše úhrady ztráty (Kč/km)",12.784018307942729,null,12.770791660827209,null,14.319678981711716,null,16.331872446426512,null,14.07875296610802,null,9.761066777083487]
[]
[]
[1.025,null,20204.666749999997,null,20204.666749999997]
[null,null,46090.990499999985,null,46090.990499999985]
[null,null,78176.78074999999,null,78176.78074999999]
[null,null,22580.8115,null,22580.8115]
[null,null,3315.8442499999996,null,3315.8442499999996]
[null,null,277.31374999999997,null,277.31375]
[null,null,99.11749999999998,null,99.1175]
[null,null,170745.52499999997,null,170745.52499999997]

{"sheet":"RK-35-2003-20, př. 1","index":2,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,6,3,7],[28,6,28,7],[5,0,11,0],[28,2,28,3],[28,0,28,1],[28,4,28,5],[3,22,3,23],[28,22,28,23],[2,2,2,23],[28,14,28,15],[3,16,3,17],[28,16,28,17],[3,2,3,3],[3,4,3,5],[3,10,3,11],[3,12,3,13],[30,0,30,1],[31,0,31,1],[0,0,0,1],[1,0,1,1],[2,0,4,1],[12,0,18,0],[19,0,25,0],[26,0,26,1],[27,0,27,1],[29,0,29,1],[3,20,3,21],[28,20,28,21],[28,8,28,9],[3,14,3,15],[3,18,3,19],[28,18,28,19],[28,10,28,11],[28,12,28,13],[3,8,3,9]],"flags":["formulas_cached_only"]}
["PŘEDPOKLAD PRO ROK 2004 "]
["Varianty rozsahu dopravní obslužnosti"]
["Časový segment",null,"Kraj celkem"]
[null,null,"Varianta 11. Maximální varianta",null,"Varianta 1.",null,"Varianta 2.",null,"Varianta 3.",null,"Varianta 4. , současný rozsah",null,"Varianta 5.",null,"Varianta 6.",null,"Varianta 7.",null,"Varianta 8.",null,"Varianta 9.",null,"Varianta 10."]
[null,null,"Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)","Ujeté km (tis. km/rok)","Úhrada ztráty (tis. Kč)"]
["Rozsah na počátku roku 2003","Spoje v prac.dny s příj. do 6,00",1568.82,20948.29,1568.82,20948.29,1568.82,20948.29,1568.82,20948.29,1568.82,20948.29,1568.82,20948.29,1568.82,20948.29,1568.82,20948.29,1568.82,20948.29,1568.82,20948.29,1568.82,20948.29]
[null,"Spoje v prac dny s příj. mezi 6,01 a 8,00",3458.74,47730.43,3458.74,47730.43,3458.74,47730.43,3458.74,47730.43,3458.74,47730.43,3458.74,47730.43,3458.74,47730.43,3458.74,47730.43,3458.74,47730.43,3458.74,47730.43,3458.74,47730.43]
[null,"Spoje v prac. dny prov.mezi 8,01 a 15,30",5976.47,81009.63,5976.47,81009.63,5976.47,81009.63,5976.47,81009.63,5976.47,81009.63,5976.47,81009.63,5976.47,81009.63,5976.47,81009.63,5976.47,81009.63,5976.47,81009.63,5976.47,81009.63]
[null,"Spoje v prac. dny s odj. po 15,30",1719.55,23395.88,1719.55,23395.88,1719.55,23395.88,1719.55,23395.88,1719.55,23395.88,1719.55,23395.88,1719.55,23395.88,1719.55,23395.88,1719.55,23395.88,1719.55,23395.88,1719.55,23395.88]
[null,"Spoje v prac.dny s odj. po 18,30",279.17,3448.17,279.17,3448.17,279.17,3448.17,279.17,3448.17,279.17,3448.17,279.17,3448.17,279.17,3448.17,279.17,3448.17,279.17,3448.17,279.17,3448.17,279.17,3448.17]
[null,"Spoje o nedělích a svátcích",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Spoje provozované o sobotách",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rozšíření  ZDO dle usnesení ZK","Spoje v prac.dny s příj. do 6,00",654.13,10873.57,null,null,654.13,10873.57,null,null,654.13,10873.57,654.13,10873.57,654.13,10873.57,654.13,10873.57,654.13,10873.57,654.13,10873.57,654.13,10873.57]
[null,"Spoje v prac dny s příj. mezi 6,01 a 8,00",156.38,894.3000000000029,null,null,156.38,894.3000000000029,156.38,894.3000000000029,156.38,894.3000000000029,156.38,894.3000000000029,156.38,894.3000000000029,156.38,894.3000000000029,156.38,894.3000000000029,156.38,894.3000000000029,156.38,894.3000000000029]
[null,"Spoje v prac. dny prov.mezi 8,01 a 15,30",124.13,1730.2999999999884,null,null,124.13,1730.2999999999884,124.13,1730.2999999999884,124.13,1730.2999999999884,124.13,1730.2999999999884,124.13,1730.2999999999884,124.13,1730.2999999999884,124.13,1730.2999999999884,124.13,1730.2999999999884,124.13,1730.2999999999884]
[null,"Spoje v prac. dny s odj. po 15,30",749.92,18257.14,{"$nulls":4},749.92,18257.14,749.92,18257.14,749.92,18257.14,749.92,18257.14,749.92,18257.14,749.92,18257.14,749.92,18257.14,749.92,18257.14]
[null,"Spoje v prac.dny s odj. po 18,30",31.32,15.63000000000011,null,null,31.32,15.63000000000011,31.32,15.63000000000011,31.32,15.63000000000011,31.32,15.63000000000011,31.32,15.63000000000011,31.32,15.63000000000011,31.32,15.63000000000011,31.32,15.63000000000011,31.32,15.63000000000011]
[null,"Spoje o nedělích a svátcích",0,0,null,null,0,null,0,null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Spoje provozované o sobotách",0,0,null,null,0,null,0,null,null,null,0,null,0,null,0,null,0,null,0,null,0]
["ODO - odhad 2004","Spoje v prac.dny s příj. do 6,00",0,0,{"$nulls":18},0,0]
[null,"Spoje v prac dny s příj. mezi 6,01 a 8,00",105.37,2297.03,{"$nulls":10},105.37,2297.03,null,null,105.37,2297.03,105.37,2297.03,105.37,2297.03]
[null,"Spoje v prac. dny prov.mezi 8,01 a 15,30",490.03,8457.5,{"$nulls":12},490.03,8457.5,null,null,490.03,8457.5,490.03,8457.5]
[null,"Spoje v prac. dny s odj. po 15,30",3.42,75.15,{"$nulls":18},3.42,75.15]
[null,"Spoje v prac.dny s odj. po 18,30",229.905,5360.48,{"$nulls":8},229.905,5360.48,{"$nulls":4},229.905,5360.48,null,null,229.905,5360.48]
[null,"Spoje o nedělích a svátcích",390.83,7653.97]
[null,"Spoje provozované o sobotách",166.149,3014.99]
["Spoje celkem",null,16104.333999999997,235162.46000000002,13002.749999999998,176532.40000000002,13968.709999999995,190046.2,14064.499999999996,197429.77000000002,14718.629999999996,208303.34000000003,14948.534999999996,213663.82000000004,14823.999999999996,210600.37000000002,15208.659999999996,216760.84000000003,15053.904999999997,215960.85000000003,15314.029999999997,219057.87000000002,15547.354999999998,224493.50000000003]
["Úhrada při zohlenění vlivu inflace",null,null,238101.99075,null,178739.05500000002,null,192421.7775,null,199897.642125,null,210907.13175000003,null,216334.61775000003,null,213232.87462500003,null,219470.35050000003,null,218660.36062500003,null,221796.09337500003,null,227299.66875]
["Průměrná výše úhrady ztráty (Kč/km)",null,14.784963522862855,null,13.746250216300401,null,13.775200251132715,null,14.21292204664226,null,14.329263779984965,null,14.4719611487012,null,14.384300770709665,null,14.430617194414241,null,14.525158796006755,null,14.483195695385216,null,14.619828822973428]
["Prostředky pro zajištění školních spojů",null,null,2000,null,2000,null,2000,null,2000,null,2000,null,2000,null,2000,null,2000,null,2000,null,2000,null,2000]
["Úhrada prokazatelné ztráty celkem",null,null,240101.99075,null,180739.05500000002,null,194421.7775,null,201897.642125,null,212907.13175000003,null,218334.61775000003,null,215232.87462500003,null,221470.35050000003,null,220660.36062500003,null,223796.09337500003,null,229299.66875]
["Předpokládané zatížení rozpočtů obcí při zájmu zachovat celkový rozsah spojů",null,null,0,null,59362.935749999975,null,45680.21325,null,38204.348624999984,null,27194.858999999968,null,21767.372999999963,null,24869.11612499997,null,18631.640249999968,null,19441.630124999967,null,16305.897374999971,null,10802.321999999986]