{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["List1","RK-31-2001-17, př. 3, str. 1","RK-31-2001-17, př. 3, str. 2","RK-31-2001-17, př. 3, str. 3"],"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":"List1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"RK-31-2001-17, př. 3, str. 1","index":1,"n_rows":41,"n_cols":19,"rows_kept":41,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Rozbor účetního odpisování majetku SÚS kraje Vysočina - stav k 31.7.2001 ",{"$nulls":15},"RK-31-2001-17, př. 3"]
[{"$nulls":16},"počet stran: 3"]
[{"$nulls":16},"Tabulka č. 1"]
["Organizace","Pořizovací cena majetku dle odpisových skupinx)",{"$nulls":5},"Podíl poř. ceny k celkové poř.ceně majetku",{"$nulls":5},"Podíl poř.ceny k poř.ceně SÚS celkem"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["SÚS celkem",27463,505353,13407,12414,139192,697829,3.9354913596310848,72.41788461069976,1.9212443163009847,1.7789458448989652,19.94643386846921,100.00000000000001,3.935491359631084,72.41788461069974,1.9212443163009845,1.7789458448989648,19.946433868469207,100]
["z toho: Havl. Brod",6224,114341,1536,1641,26380,150122,4.145961284821678,76.16538548647101,1.0231678235035504,1.0931109364383633,17.572374468765403,100.00000000000001,{"$nulls":5},21.512720164968783]
["           Jihlava",7053,102613,6612,2821,29797,148896,4.736863313990973,68.91588759939825,4.440683430045132,1.8946110036535568,20.011954652912102,100,{"$nulls":5},21.337032424849067]
["           Pelhřimov",1415,92340,271,0,22776,116802,1.2114518587010497,79.05686546463245,0.23201657505864626,0,19.49966610160785,100,{"$nulls":5},16.737911436755994]
["           Třebíč",6626,86336,2001,4554,35500,135017,4.90753016286838,63.94454031714525,1.4820355955176014,3.372908596695231,26.29298532777354,99.99999999999999,{"$nulls":5},19.348149761617815]
["          Žďár n. S.",6145,109723,2987,3398,24739,146992,4.180499619026886,74.64555894198324,2.0320833786872754,2.311690432132361,16.83016762817024,100.00000000000001,{"$nulls":5},21.064186211808337]
["x) - bez hodnoty silničních těles a mostů"]
[]
["Organizace","Oprávky dle odpisových skupin",{"$nulls":5},"Podíl oprávek k poř.ceně majetku organizace",{"$nulls":5},"Podíl oprávek k poř.ceně majetku odpis.skupiny"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["SÚS celkem",21765,305542,9577,4870,40157,381911,3.1189589426636037,43.78465211391329,1.3723992554049773,0.6978787066745578,5.754561647624275,54.7284506662807,79.25208462294724,60.461103426713606,71.43283359439098,39.22990172386015,28.850077590666128,54.7284506662807]
["z toho: Havl. Brod",4814,68720,1306,982,7146,82968,3.206725196839903,45.776102103622385,0.8699590999320552,0.6541346371617751,4.760128428877846,55.267049466433974,77.34575835475579,60.1009261769619,85.02604166666666,59.84156002437538,27.088703563305533,55.267049466433974]
["           Jihlava",5930,71742,4604,1370,7547,91193,3.982645604986031,48.18262411347518,3.0920911240060174,0.9201053084031808,5.068638512787449,61.24610466365785,84.07769743371615,69.91511796750899,69.63097398669088,48.564338886919536,25.328053159714063,61.24610466365785]
["           Pelhřimov",963,52334,258,0,7889,61444,0.8244721836954847,44.8057396277461,0.22088662865361897,0,6.754165168404651,52.605263608499854,68.0565371024735,56.6753303010613,95.20295202952029,0,34.63733754829646,52.605263608499854]
["           Třebíč",4493,49320,1585,1906,8935,66239,3.327729100779902,36.528733418754676,1.173926246324537,1.4116740854855314,6.617685180384693,49.05974803172934,67.80863265922125,57.12564862861379,79.2103948025987,41.853315766359245,25.16901408450704,49.05974803172934]
["          Žďár n. S.",5565,63426,1824,612,8640,80067,3.7859203221944053,43.14928703602917,1.2408838576249046,0.4163491890715141,5.877870904539022,54.47031130945902,90.56143205858422,57.805564922577766,61.064613324405755,18.010594467333725,34.92461295929504,54.47031130945902]
[]
[]
["Organizace","Zůstatková cena dle odpisových skupin",{"$nulls":5},"Podíl zůst.ceny k poř.ceně majetku organizace",{"$nulls":5},"Podíl zůst.ceny k poř.ceně majetku odpis.skupiny"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["SÚS celkem",5698,199811,3829,7543,99036,315917,0.8165324169674806,28.63323249678646,0.548701759313528,1.080923836641928,14.192015522427415,45.27140603213681,20.747915377052763,39.538896573286394,28.559707615424777,60.762042854841305,71.15064084142767,45.27140603213681]
["z toho: Havl. Brod",1410,45621,230,659,19234,67154,0.9392360879817749,30.389283382848614,0.15320872357149518,0.4389762992765884,12.81224603988756,44.73295053356603,22.654241645244216,39.89907382303811,14.973958333333334,40.158439975624624,72.91129643669446,44.73295053356603]
["           Jihlava",1123,30871,2008,1450,22251,57703,0.754217709004943,20.73326348592306,1.3485923060391145,0.9738340855362132,14.943987749838813,38.75389533634215,15.92230256628385,30.084882032491013,30.369026013309135,51.40021269053528,74.67530288284055,38.75389533634214]
["           Pelhřimov",452,40006,12,0,14887,55357,0.38697967500556496,34.25112583688635,0.010273796681563672,0,12.7455009332032,47.393880241776685,31.943462897526505,43.324669698938706,4.428044280442804,0,65.36266245170354,47.39388024177668]
["           Třebíč",2133,37016,416,2648,26565,68778,1.579801062088478,27.41580689839057,0.3081093491930646,1.9612345112096994,19.675300147388846,50.94025196827066,32.19136734077875,42.87435137138621,20.789605197401297,58.146684233640755,74.83098591549296,50.940251968270665]
["          Žďár n. S.",580,46297,1163,2786,16099,66925,0.39457929683248066,31.496271905954064,0.7911995210623708,1.8953412430608467,10.952296723631218,45.52968869054098,9.438567941415785,42.194435077422234,38.935386675594245,81.98940553266627,65.07538704070495,45.52968869054098]
[]
[]
["Organizace","Hodnota silničních těles a mostů (5 odp.sk.)",{"$nulls":5},"Podíl sil.těles a mostů na",null,null,"1,0 %"]
[null,"silnice","mosty",null,null,null,"Celkem","majetku organizace bez pozemků",null,null,"odpisů"]
["SÚS celkem",3827061,570681,0,0,0,4397742,null,86.30518542475416,null,43977.42]
["z toho: Havl. Brod",813574,99332,null,null,null,912906,null,85.87788844696472,null,9129.06]
["           Jihlava",803560,187747,null,null,null,991307,null,86.94127273827556,null,9913.07]
["           Pelhřimov",347378,84140,null,null,null,431518,null,78.6982054274876,null,4315.18]
["           Třebíč",910688,118829,null,null,null,1029517,null,88.40592030803738,null,10295.17]
["          Žďár n. S.",951861,80633,null,null,null,1032494,null,87.53762232023101,null,10324.94]

{"sheet":"RK-31-2001-17, př. 3, str. 2","index":2,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Rozbor účetního odpisování majetku galerií kraje Vysočina a DÚSP Černovice - stav k 31.7.2001 "]
[]
[{"$nulls":16},"Tabulka č. 2"]
["Organizace","Pořizovací cena majetku dle odpisových skupin",{"$nulls":5},"Podíl poř. ceny k celkové poř.ceně majetku",{"$nulls":5},"Podíl poř.ceny k poř.ceně galerie celkem"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["Galerie celkem",2437,3694,434,0,0,6565,37.12109672505712,56.26808834729626,6.610814927646611,0,0,100,37.1,56.3,6.6,0,0,100]
["z toho: Havl. Brod",342,1889,218,0,0,2449,13.964883625969785,77.13352388730094,8.901592486729278,0,0,100,{"$nulls":5},37.3]
["           Jihlava",1106,867,216,0,0,2189,50.525354042941984,39.60712654179991,9.867519415258108,0,0,100,{"$nulls":5},33.3]
["           Nové Město",989,938,0,0,0,1927,51.323300467047225,48.676699532952775,0,0,0,100,{"$nulls":5},29.4]
[]
["DÚSP Černovice",8756,14019,573,19659,91087,134094,6.529747788864528,10.454606470088148,0.4273121839903351,14.660611213029664,67.92772234402732,100,{"$nulls":5},"x"]
[]
[]
[]
["Organizace","Oprávky dle odpisových skupin",{"$nulls":5},"Podíl oprávek k poř.ceně majetku organizace",{"$nulls":5},"Podíl oprávek k poř.ceně majetku odpis.skupiny"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["Galerie celkem",1890,1775,84,0,0,3749,28.789032749428788,27.037319116527037,1.2795125666412797,0,0,57.10586443259711,77.55437012720559,48.05089334055225,19.35483870967742,0,0,57.10586443259711]
["z toho: Havl. Brod",342,732,19,0,0,1093,13.964883625969785,29.88975091874234,0.7758268681094325,0,0,44.63046141282156,100,38.75066172578084,8.715596330275229,0,0,44.63046141282156]
["           Jihlava",922,354,65,0,0,1341,42.11968935587026,16.171767930561902,2.9693924166285974,0,0,61.26084970306076,83.3634719710669,40.830449826989614,30.09259259259259,0,0,61.26084970306076]
["           Nové Město",626,689,0,0,0,1315,32.48572911261027,35.75505967825636,0,0,0,68.24078879086663,63.29625884732053,73.45415778251599,0,0,0,68.24078879086663]
[]
["DÚSP Černovice",5174,5818,247,4753,6215,22207,3.8584873297835847,4.338747445821587,0.18419914388414096,3.5445284651065667,4.63480841797545,16.56077080257133,59.09090909090909,41.5008203152864,43.1064572425829,24.177221628770535,6.8231471011231015,16.56077080257133]
[]
[]
[]
["Organizace","Zůstatková cena dle odpisových skupin",{"$nulls":5},"Podíl zůst.ceny k poř.ceně majetku organizace",{"$nulls":5},"Podíl zůst.ceny k poř.ceně majetku odpis.skupiny"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["Galerie celkem",546,1919,350,0,0,2815,8.316831683168317,29.230769230769234,5.331302361005331,0,0,42.878903274942886,22.404595814526058,51.94910665944775,80.64516129032258,0,0,42.87890327494288]
["z toho: Havl. Brod",0,1157,199,0,0,1356,0,47.243772968558595,8.125765618619845,0,0,55.36953858717844,0,61.24933827421917,91.28440366972477,0,0,55.36953858717843]
["           Jihlava",183,513,151,0,0,847,8.359981726815898,23.43535861123801,6.898126998629511,0,0,38.69346733668341,16.54611211573237,59.16955017301038,69.9074074074074,0,0,38.69346733668342]
["           Nové Město",363,249,0,0,0,612,18.83757135443695,12.921639854696421,0,0,0,31.75921120913337,36.70374115267948,26.545842217484005,0,0,0,31.75921120913337]
[]
["DÚSP Černovice",3581,8200,326,14906,84872,111885,2.670514713559145,6.1151132787447615,0.24311304010619417,11.1160827479231,63.292913926051874,83.43773770638508,40.89767016902695,58.492046508310146,56.8935427574171,75.82277837122946,93.17685289887689,83.43773770638508]

{"sheet":"RK-31-2001-17, př. 3, str. 3","index":3,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,0,2,4],[27,0,27,2]],"flags":["formulas_cached_only"]}
["Tvorba účetních odpisů v roce 2001 u organizací kraje Vysočina - skutečnost a variantní propočty"]
[]
["I. Organizace silničního hospodářství"]
[{"$nulls":11},"Tabulka č. 3"]
["Organizace","Roční odpisyx) - skutečnost 2001 = varianta č. 1",{"$nulls":5},"Podíl odpisů podle odpisových skupin"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["SÚS celkem",2617,42184,501,367,2976,48645,5.379792373316888,86.7180594100113,1.0299105766265804,0.7544454722993114,6.117792167745914,100]
["z toho: Havl. Brod",635,8801,28,34,520,10018,6.3385905370333395,87.85186664004792,0.27949690556997403,0.33938909962068275,5.190656817728089,100]
["           Jihlava",618,8331,256,80,659,9944,6.214802896218825,83.77916331456154,2.574416733708769,0.8045052292839904,6.627111826226871,100]
["           Pelhřimov",131,8397,5,0,489,9022,1.4520062070494346,93.072489470184,0.05542008423852804,0,5.420084238528043,100.00000000000001]
["           Třebíč",848,7443,66,146,779,9282,9.135962077138547,80.18745959922431,0.7110536522301228,1.572936867054514,8.392587804352509,100]
["          Žďár n. S.",385,9212,146,107,529,10379,3.709413238269583,88.7561422102322,1.406686578668465,1.0309278350515463,5.096830137778206,100]
["% roč.sazba odpisů",25,12.5,6.66,3.33,2.22,"x"]
["Doba odpisování - rok",4,8,15.015015015015015,30.03003003003003,45.04504504504504,"x"]
["x) - bez hodnoty silnic+A26 a mostů"]
[]
["Organizace","Roční odpisy - návrh 2002 = varianta č. 2",{"$nulls":5},"Podíl odpisů podle odp. skupin na variantu č. 1"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["SÚS celkem",1570.2,26997.760000000002,376.1261261261261,275.52552552552555,1340.5405405405404,30560.152192192192,3.227875423990133,55.499558022407236,0.7732061386085437,0.5664005047292128,2.7557622377233844,62.822802327458504]
["z toho: Havl. Brod",381,5632.64,21.02102102102102,25.525525525525524,234.2342342342342,6294.420780780781,3.8031543222200037,56.22519464963067,0.20983251168916972,0.25479662133684894,2.3381337016793196,62.83111180655602]
["           Jihlava",370.79999999999995,5331.84,192.19219219219218,60.06006006006005,296.8468468468468,6251.739099099099,3.7288817377312946,53.618664521319396,1.932745295577154,0.6039829048678605,2.9851855073094007,62.86945996680511]
["           Pelhřimov",78.60000000000001,5374.08,3.7537537537537533,0,220.27027027027026,5676.704024024024,0.7904263877715206,59.56639326091776,0.041606669848744775,0,2.4414793867243434,62.839905705262375]
["           Třebíč",508.8,4763.52,49.54954954954955,109.6096096096096,350.90090090090087,5782.380060060061,5.481577246283129,51.31997414350356,0.533824063235828,1.1808835338247103,3.7804449569155447,62.29670394376277]
["          Žďár n. S.",231,5895.68,109.6096096096096,80.33033033033034,238.28828828828827,6554.908228228229,2.2256479429617495,56.80393101454862,1.056071005006355,0.7739698461347947,2.2958694314316244,63.15548924008314]
["% roč.sazba odpisů",15,8,5,2.5,1,"x"]
["Doba odpisování - rok",6.666666666666667,12.5,20,40,100,"x"]
[]
["II. Galerie a DÚSP Černovice"]
[]
["Organizace","Roční tvorba odpisů - skutečnost 2001",{"$nulls":5},"Podíl odpisů podle odpisových skupin"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["Galerie celkem",299,558,48,0,0,905,33.03867403314917,61.65745856353592,5.303867403314917,0,0,100]
["z toho: Havl. Brod",0,460,19,0,0,479,0,50.82872928176796,2.0994475138121547,0,0,52.928176795580114]
["           % sazby odpisů",25,11.11,8.33,0,0,"x"]
["           Jihlava",96,9,29,0,0,134,10.607734806629834,0.9944751381215469,3.2044198895027622,0,0,14.806629834254144]
["           % sazby odpisů",20,10,6.66,4,2.85,"x"]
["           Nové Město",203,89,0,0,0,292,22.430939226519335,9.83425414364641,0,0,0,32.26519337016575]
["          % sazby odpisů","1 rok 14,2","1 rok 8,5",0,0,0,"x"]
[null,"ost.28,6","ost. 18,3"]
["DÚSP Černovice",861,1011,23,491,1184,3570,24.11764705882353,28.319327731092436,0.6442577030812324,13.753501400560225,33.16526610644257,100]
["% roč.sazba odpisů",12,8,5,2.5,1.3,"x"]
["Doba odpisování - rok",8.333333333333334,12.5,20,40,76.92307692307692,"x"]
[]
[]
["Organizace","Roční odpisy - návrh 2002 ",{"$nulls":5},"Podíl odpisů podle odp. skupin na skut. 2001"]
[null,1,2,3,4,5,"Celkem",1,2,3,4,5,"Celkem"]
["Galerie celkem",193.79999999999998,374.03312331233127,33.176333596501664,0,0,601.0094569088329,21.414364640883974,41.32962688534047,3.6658932150830568,0,0,66.40988474130751]
["z toho: Havl. Brod",0,331.23312331233126,11.40456182472989,0,0,342.63768513706117,0,69.15096520090422,2.3809106105907913,0,0,71.53187581149501]
["           Jihlava",72,7.2,21.771771771771775,0,0,100.97177177177178,53.73134328358209,5.3731343283582085,16.24759087445655,0,0,75.35206848639685]
["           Nové Město",121.79999999999998,35.6,0,0,0,157.39999999999998,41.71232876712328,12.191780821917808,0,0,0,53.90410958904109]
[]
["DÚSP Černovice",1076.25,1011,23,491,910.7692307692307,3512.0192307692305,30.14705882352941,28.319327731092436,0.6442577030812324,13.753501400560225,25.51174315880198,98.37588881706529]
["% roč.sazba odpisů",15,8,5,2.5,1,"x"]
["Doba odpisování - rok",6.666666666666667,12.5,20,40,100,"x"]