{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["1. kolo rozdělení dotací na PS ","2. kolo rozdělení dotací na PS"],"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":"1. kolo rozdělení dotací na PS ","index":0,"n_rows":155,"n_cols":6,"rows_kept":155,"cut":false,"hidden":false,"merged":[[150,0,150,2],[151,0,151,2],[152,0,152,2]],"flags":["formulas_cached_only"]}
[" Demonstrativní výpočet rozdělení dotací na PS v prvním kole",null,null,null,"RK-36-2003-40, př. 1"]
[{"$nulls":4},"počet stran: 4"]
[{"$nulls":4},"List sešitu 1"]
["Okres","Muži","Ženy","Celkem ( 65 let a více)"]
["Pelhřimov",5476,7945,13421]
["Jihlava",7412,11072,18484]
["Havlíčkův Brod",6781,9857,16638]
["Třebíč",7712,11106,18818]
["Žďár nad Sázavou",8459,11819,20278]
["Celkem občanú nad 65 let",35840,51799,87639]
[]
[null,"Příspěvek KV",15250000]
[null,"Koeficient úpravy příspěvku KV",0.9090094421725097]
[null,"Upravený příspěvek KV",13862393.993130773]
[null,"Příspěvek na osobu",158]
[]
[]
[]
[]
["Žďár nad Sázavou","Počet obyvatel nad 65 let","Dotace bez úpravy koeficientem","Počet obyvatel nad 65 let upravený koeficientem","Koeficient finanční náročnosti PS","Výsledná dotace pro obec"]
["Ujčov",86,13588,86,1,13588]
["V. Janovice",18,2844,18,1,2844]
["Zvole",100,15800,100,1,15800]
["Vír",100,15800,100,1,15800]
["Chlum-Korouhvice",10,1580,10,1,1580]
["Koroužné",70,11060,70,1,11060]
["Štěpánov",143,22594,143,1,22594]
["Věstín",49,7742,49,1,7742]
["Polnička",106,16748,106,1,16748]
["Doubravník",120,18960,120,1,18960]
["Černvír",35,5530,35,1,5530]
["Vojnův Městec",130,20540,130,1,20540]
["Radostín",43,6794,43,1,6794]
["Nedvědice",245,38710,245,1,38710]
["Skorotice",44,6952,44,1,6952]
["Cikháj",26,4108,26,1,4108]
["Světnov",76,12008,76,1,12008]
["Věžná",67,10586,67,1,10586]
["Dolní Loučky",162,25596,162,1,25596]
["Rovečné",123,19434,123,1,19434]
["Nové Město na Moravě",1438,227204,1438,1,227204]
["Velká Bíteš",645,101910,645,1,101910]
["Velké Meziříčí",1669,263702,1669,1,263702]
["Žďár nad Sázavou",3310,522980,3310,1,522980]
["Škrdlovice",84,13272,84,1,13272]
["Sněžné",110,17380,110,1,17380]
["Měřín",254,40132,254,1,40132]
["Nížkov",114,18012,114,1,18012]
["Hamry nad Sázavou",193,30494,193,1,30494]
["Býšovec",32,5056,32,1,5056]
["D.Rožínka",116,18328,116,1,18328]
["Rožná",106,16748,106,1,16748]
["Lísek",51,8058,51,1,8058]
["Milasín",5,790,5,1,790]
["Písečné",35,5530,35,1,5530]
["Jimramov",240,37920,240,1,37920]
["Dalečín",111,17538,111,1,17538]
["Daňkovice",25,3950,25,1,3950]
["Lišná",22,3476,22,1,3476]
["Nov. Jimramov",16,2528,16,1,2528]
["Unčín",29,4582,29,1,4582]
["Věcov",79,12482,79,1,12482]
["Herálec",190,30020,190,1,30020]
["Fryšava",55,8690,55,1,8690]
["Chlumětín",37,5846,37,1,5846]
["Křižánky",79,12482,79,1,12482]
["Svratka",288,45504,288,1,45504]
["Křížanov",233,36814,233,1,36814]
["Bobrová",157,24806,157,1,24806]
["Dobrá Voda",60,9480,60,1,9480]
["Heřmanov",35,5530,35,1,5530]
["Jívoví",57,9006,57,1,9006]
["H. Libochová",39,6162,39,1,6162]
["Kozlov",45,7110,45,1,7110]
["Moravec",126,19908,126,1,19908]
["Obyčtov",48,7584,48,1,7584]
["Ořechov",60,9480,60,1,9480]
["Radenice",33,5214,33,1,5214]
["Radešín",22,3476,22,1,3476]
["Rad. Svratka",79,12482,79,1,12482]
["Sklenné",38,6004,38,1,6004]
["Skřinářov",37,5846,37,1,5846]
["Bystřice",1156,182648,1156,1,182648]
["Blažkov",43,6794,43,1,6794]
["Bukov",38,6004,38,1,6004]
["Pikárec",50,7900,50,1,7900]
["Rodkov",17,2686,17,1,2686]
["Rozsochy",137,21646,137,1,21646]
["Střítež",17,2686,17,1,2686]
["Strážek",211,33338,211,1,33338]
["Celkem",13824,2184192,13824,null,2184192]
["Použitá částka na 1 obyvatele",158]
[]
["Havlíčkův Brod","Počet obyvatel nad 65 let","Dotace bez úpravy koeficientem","Počet obyvatel nad 65 let upravený koeficientem","Koeficient finanční náročnosti PS","Výsledná dotace pro obec"]
["Chotěboř",1512,238896,1965.6000000000001,1.3,310564.8]
["Havlíčkův Brod",3757,593606,5259.799999999999,1.4,831048.3999999999]
["Ledeč",1023,161634,1023,1,161634]
["Světlá nad Sázavou",868,137144,954.8000000000001,1.1,150858.40000000002]
["Pribyslav",629,99382,629,1,99382]
["Krucemburk",279,44082,279,1,44082]
["Úsobí",109,17222,141.70000000000002,1.3,22388.600000000002]
["Ždírec nad Doubravou",446,70468,446,1,70468]
["Herálec",198,31284,198,1,31284]
["Celkem",8821,1393718,10896.9,null,1721710.2000000002]
["Použitá částka na 1 obyvatele",158]
[]
["Třebíč","Počet obyvatel nad 65 let","Dotace bez úpravy koeficientem","Počet obyvatel nad 65 let upravený koeficientem","Koeficient finanční náročnosti PS","Výsledná dotace pro obec"]
["Třebíč",4855,767090,4855,1,767090]
["Jaroměřice",622,98276,622,1,98276]
["Moravské Budějovice",1287,203346,1287,1,203346]
["Jemnice",648,102384,648,1,102384]
["Kralice",139,21962,139,1,21962]
["Želetava",221,34918,221,1,34918]
["Mohelno",266,42028,266,1,42028]
["Okříšky",301,47558,301,1,47558]
["Hrotovice",224,35392,224,1,35392]
["Náměšť",870,137460,870,1,137460]
["Celkem",9433,1490414,9433,null,1490414]
["Použitá částka na 1 obyvatele",158]
[]
[]
["Jihlava","Počet obyvatel nad 65 let","Dotace bez úpravy koeficientem","Počet obyvatel nad 65 let upravený koeficientem","Koeficient finanční náročnosti PS","Výsledná dotace pro obec"]
["Stonařov",131,20698,131,1,20698]
["Batelov",398,62884,398,1,62884]
["Třešť",867,136986,867,1,136986]
["Jihlava",8010,1265580,11214,1.4,1771812]
["Polná",731,115498,731,1,115498]
["Brtnice",519,82002,519,1,82002]
["Telč",984,155472,984,1,155472]
["Luka nad Jihlavou",429,67782,429,1,67782]
["Kněžice",196,30968,196,1,30968]
["Kamenice",278,43924,278,1,43924]
["Celkem",12543,1981794,15747,null,2488026]
["Použitá částka na 1 obyvatele",158]
[]
["Pelhřimov","Počet obyvatel nad 65 let","Dotace bez úpravy koeficientem","Počet obyvatel nad 65 let upravený koeficientem","Koeficient finanční náročnosti PS","Výsledná dotace pro obec"]
["Horní Cerekev",312,49296,312,1,49296]
["Humpolec",1987,313946,1987,1,313946]
["Pacov",921,145518,921,1,145518]
["Pelhřimov",2384,376672,2384,1,376672]
["Žirovnice",569,89902,569,1,89902]
["Želiv",205,32390,205,1,32390]
["Počátky",460,72680,460,1,72680]
["Hořepník",113,17854,113,1,17854]
["Černovice",335,52930,335,1,52930]
["Červená Řečice",211,33338,211,1,33338]
["Kamenice nad Lipou",629,99382,629,1,99382]
["Celkem",8126,1283908,8126,null,1283908]
["Použitá částka na 1 obyvatele",158]
[]
["Skutečný počet obyvatel nad 65 let, na něž bylo požádáno",null,null,52747]
["Skutečný počet obyvatel nad 65 let, na něž bylo požádáno, upravený koeficientem",null,null,58026.9]
["Koeficient úpravy příspěvku KV",null,null,0.9090094421725097]
[]
["Celkem k vyplacení pro dosud evidované pečovatelské služby",null,null,9168250.2]

{"sheet":"2. kolo rozdělení dotací na PS","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,3]],"flags":["formulas_cached_only"]}
["Demonstrativní výpočet rozdělení příspěvku na PS ve druhém kole ",null,null,null,"RK-36-2003-40, př. 1"]
[{"$nulls":4},"List sešitu 2"]
[]
[null,"Příspěvek z rozpočtu pro rok 2003","Dotace poskytnuta v prvním kole","Hodnota příspěvku pro přerozdělení","Koeficient pro přepočet","Příspěvek pro 2004 po přepočtu koeficientem"]
["Jemnice",418000,102384,315616,0.00900143316884495,54744.464374336145]
["Batelov",246366,62884,183482,0.005232944339596247,31825.45819075061]
["Telč",800000,155472,644528,0.01838207098958639,111795.15656450283]
["Luka nad Jihlavou",195700,67782,127918,0.0036482476429975296,22187.7293731507]
["Nové Město na Moravě",4636000,227204,4408796,0.12573976778449425,764717.8075753944]
["Stonařov",247653,20698,226955,0.006472803231886867,39365.96976096732]
["Bobrová",200000,24806,175194,0.004996568876681227,30387.88176644228]
["Přibyslav",1295000,99382,1195618,0.03409927102069623,207383.23471026513]
["Pacov",2050000,145518,1904482,0.05431621794924265,330337.6476495629]
["Třešť",1122000,136986,985014,0.028092801668409204,170853.39092828735]
["Počátky",464300,72680,391620,0.011169082865200304,67927.56748161539]
["Havlíčkův Brod",6002449,593606,5408843,0.15426131370169707,938178.7137530335]
["Želiv",427254,32390,394864,0.011261602411737022,68490.24821526116]
["Hamry nad Sázavou",61725,30494,31231,0.0008907145369569243,5417.102956994868]
["Ždírec nad Doubravou",520000,70468,449532,0.012820745004236819,77972.56336536829]
["Velká Bíteš",600000,101910,498090,0.01420562914132991,86395.08218915737]
["Kralice nad Oslavou",100000,21962,78038,0.0022256597942763427,13535.90600870819]
["Chotěboř",1379000,238896,1140104,0.03251600033437089,197754.1785303601]
["Kněžice",125000,30968,94032,0.002681811960524271,16310.109354556094]
["Náměšť nad Oslavou",137000,137460,-460,-1.311929451507109e-05,-79.7882667931747]
["Krucemburk",307000,44082,262918,0.0074984753811162186,45603.85114940849]
["Žďár nad Sázavou",3579000,522980,3056020,0.08715831831292946,530075.0849679952]
["Herálec",90000,30020,59980,0.0017106419239433998,10403.696178814389]
["V. Meziříčí",2804000,263702,2540298,0.07244982090879577,440621.6838221046]
["Jihlava",5750000,1265580,4484420,0.12789657980277194,777834.9986361924]
["Světlá nad Sázavou",1790000,137144,1652856,0.047139792728265954,286692.42499717296]
["Ledeč nad Sázavou",2535000,161634,2373366,0.06768888596968742,411666.8687083693]
["Skrdlovice",460200,13272,446928,0.01274647838919933,77520.89239421736]
["Polná",1392000,115498,1276502,0.03640609931973321,221412.78725656762]
["Kamenice u Jihlavy",300000,43924,256076,0.00730334013530727,44417.08740723697]
["Celkem",40034647,4971786,35062861,1,6081749.800000002]
["Příspěvek pro přerozdělení na rok 2004",15250000]
["Výše celkové podpory poskytnuté v prvním kole",9168250.2]
["Zůstatek úhrnné částky na podporu PS po prvním kole",6081749.800000001]