{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Obsah","B2.1","B2.2","B2.3","B2.4","B2.5","B2.6","B2.7","GB1","GB2","GB3","GB4"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":66,"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":"Obsah","index":0,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"B2 Vývoj školství na regionální úrovni"]
[null,null,null,"Zdroje dat jsou uvedeny v zápatí jednotlivých tabulek"]
[]
[null,null,null,null,null,"Obsah"]
[]
[null,null,null,"Tabulka 1",null,{"$f":"'B2.1'!H4&\" \"&'B2.1'!D5","v":"Regionální školství – školy, děti, žáci, studenti/dívky, ženy  ve školním roce 2008/09 až 2018/19 – podle zřizovatele"}]
[]
[null,null,null,"Tabulka 2",null,{"$f":"'B2.2'!H4&\" \"&'B2.2'!D5","v":"Učitelé MŠ, ZŠ, SŠ, konzervatoří, VOŠ a škol pro žáky se SVP – struktura učitelů v letech 2011 až 2018 – podle nejvyššího dosaženého vzdělání"}]
[]
[null,null,null,"Tabulka 3",null,{"$f":"'B2.3'!H4&\" \"&'B2.3'!D5","v":"Učitelé MŠ, ZŠ, SŠ, konzervatoří, VOŠ a škol pro žáky se SVP – struktura učitelů v letech 2011 až 2018 – podle věku"}]
[]
[null,null,null,"Tabulka 4",null,{"$f":"'B2.4'!H4&\" \"&'B2.4'!D5","v":"Regionální školství – výdaje v běžných cenách  v letech 2008 až 2018"}]
[]
[null,null,null,"Tabulka 5",null,{"$f":"'B2.5'!H4&\" \"&'B2.5'!D5","v":"Regionální školství – týdenní rozsah hodin přímé pedagogické činnosti  (míra vyučovací povinnosti) učitelů v letech 2004 až 2018"}]
[]
[null,null,null,"Tabulka 6",null,{"$f":"'B2.6'!H4&\" \"&'B2.6'!D5","v":"Regionální školství – přepočtené počty zaměstnanců  v letech 2008 až 2018"}]
[]
[null,null,null,"Tabulka 7",null,{"$f":"'B2.7'!$H$4&\" \"&'B2.7'!$D$5","v":"Regionální školství – průměrné měsíční mzdy  v letech 2008 až 2018"}]
[null,null,null,null,"Obrazová příloha"]
[null,null,null,"Graf 1",null,{"$f":"'GB1'!$G$4&\" \"&'GB1'!$D$5","v":"Regionální školství – školy ve školním roce 2008/09 až 2018/19 – podle druhu školy  "}]
[]
[null,null,null,"Graf 2",null,{"$f":"'GB2'!$G$4&\" \"&'GB2'!$D$5","v":"Regionální školství – děti/žáci/studenti ve školním roce 2008/09 až 2018/19 – podle druhu školy "}]
[]
[null,null,null,"Graf 3",null,{"$f":"'GB3'!$H$4&\" \"&'GB3'!$D$5","v":"Regionální školství – děti/žáci/studenti ve školním roce 2008/09 a 2018/19 – podle zřizovatele "}]
[]
[null,null,null,"Graf 4",null,{"$f":"'GB4'!$G$4&\" \"&'GB4'!$D$5","v":"Regionální školství – všichni zřizovatelé – přepočtené počty zaměstnanců a učitelů, průměrné nominální a reálné mzdy v letech 2008 až 2018"}]

{"sheet":"B2.1","index":1,"n_rows":39,"n_cols":26,"rows_kept":39,"cut":false,"hidden":false,"merged":[[22,4,28,4],[6,23,9,23],[31,5,34,5],[6,22,9,22],[6,24,9,24],[14,5,17,5],[6,14,9,14],[6,11,9,11],[38,4,38,24],[13,4,19,4],[6,19,9,19],[6,18,9,18],[6,17,9,17],[6,16,9,16],[30,4,36,4],[6,21,9,21],[6,20,9,20],[6,15,9,15],[23,5,26,5],[6,9,9,9],[6,10,9,10],[6,13,9,13],[6,12,9,12],[6,3,10,8]]}
[]
[]
[]
[null,null,null,"Tab. B2.1:",null,null,null,"Regionální školství – školy, děti, žáci, studenti/dívky, ženy "]
[null,null,null,"ve školním roce 2008/09 až 2018/19 – podle zřizovatele"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Zřizovatel",null,null,null,null,null,"2003/04","2004/05","2005/06","2006/07","2007/08","2008/09","2009/10","2010/11","2011/12","2012/13","2013/14","2014/15","2015/16","2016/17","2017/18","2018/19"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"1)","1)"]
[null,null,null,"Školy"]
[null,null,null,null,"Celkem1)",null,null,null,null,". ",". ",8681,8591,8541,8493,8472,8474,8490,8426,8442,8475,8500,8496,8557,8558]
[null,null,null,null,"v tom"," veřejný",null,null,null,". ",". ",8140,8040,7978,7911,7880,7853,7843,7749,7718,7695,7688,7650,7655,7634]
[null,null,null,null,null,"v tom"," MŠMT",null,null,". ",". ",62,62,62,64,64,64,64,60,61,60,59,58,59,59]
[null,null,null,null,null,null," obec",null,null,". ",". ",6660,6613,6576,6537,6516,6506,6507,6500,6489,6489,6494,6466,6481,6479]
[null,null,null,null,null,null," jiný resort",null,null,". ",". ",9,6,8,8,8,8,8,8,6,6,6,5,6,6]
[null,null,null,null,null,null," kraj",null,null,". ",". ",1409,1359,1332,1302,1292,1275,1264,1181,1162,1140,1129,1121,1109,1090]
[null,null,null,null,null," privátní sektor",null,null,null,". ",". ",448,458,469,484,495,522,543,572,617,669,700,733,789,809]
[null,null,null,null,null," církev",null,null,null,". ",". ",93,93,94,98,97,99,104,105,107,111,112,113,113,115]
[null,null,null,"Děti/žáci/studenti"]
[null,null,null,null,"Celkem",null,null,null,null,1887775,1850642,1808650,1769701,1737704,1713523,1696911,1684376,1671275,1665679,1672036,1687998,1703238,1719487,1734063,1747747]
[null,null,null,null,"v tom"," veřejný",null,null,null,1780215,1741851,1698818,1658083,1625603,1600200,1583325,1575784,1569033,1567574,1574864,1588442,1601231,1613821,1624866,1635619]
[null,null,null,null,null,"v tom"," MŠMT",null,null,3335,3251,3267,3213,3323,3391,3467,3301,3182,2931,2815,2763,2903,2889,2813,2911]
[null,null,null,null,null,null," obec",null,null,1234243,1195949,1157785,1121825,1096645,1077575,1067854,1077462,1095653,1119660,1146572,1174507,1198133,1217638,1235311,1248266]
[null,null,null,null,null,null," jiný resort",null,null,2086,1903,1502,951,1226,1476,1803,1889,1853,1792,1782,1690,1762,1848,1941,2045]
[null,null,null,null,null,null," kraj",null,null,540551,540748,536264,532094,524409,517758,510201,493132,468345,443191,423695,409482,398433,391446,384801,382397]
[null,null,null,null,null," privátní sektor",null,null,null,91687,92665,93533,95009,95229,96051,96285,91105,84289,79647,78203,79832,81907,85082,88270,90976]
[null,null,null,null,null," církev",null,null,null,15873,16126,16299,16609,16872,17272,17301,17487,17953,18458,18969,19724,20100,20584,20927,21152]
[null,null,null,null,"Z toho dívky/ženy",null,null,null,null,924356,908094,886522,867709,852673,841083,831991,825353,819122,816918,819363,827646,835070,842251,848938,855724]
[null,null,null,null,"v tom"," veřejný",null,null,null,865022,847032,824351,804425,789099,776928,769193,766073,763712,764068,767296,773639,779955,785329,790272,795173]
[null,null,null,null,null,"v tom"," MŠMT",null,null,1088,1090,1087,1097,1100,1177,1205,1097,1078,1025,957,931,1011,996,963,993]
[null,null,null,null,null,null," obec",null,null,598406,579839,560695,543001,531342,521692,517546,522878,532117,544631,557811,571399,583241,592789,601451,607655]
[null,null,null,null,null,null," jiný resort",null,null,487,397,332,260,245,297,342,367,333,318,343,333,317,348,426,517]
[null,null,null,null,null,null," kraj",null,null,265041,265706,262237,260067,256412,253762,250100,241731,230184,218094,208185,200976,195386,191196,187432,186008]
[null,null,null,null,null," privátní sektor",null,null,null,49362,50935,51902,52902,53054,53451,52081,48477,44410,41552,40501,42014,43005,44504,46066,47864]
[null,null,null,null,null," církev",null,null,null,9972,10127,10269,10382,10520,10704,10717,10803,11000,11298,11566,11993,12110,12418,12600,12687]
[null,null,null,"Komentáře:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: databáze MŠMT",""]
[null,null,null,"1)","Počet právních subjektů vykonávajících činnost školy."]

{"sheet":"B2.2","index":2,"n_rows":19,"n_cols":19,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,17,9,17],[6,3,10,8],[6,9,9,9],[6,13,9,13],[6,14,9,14],[6,10,9,10],[6,11,9,11],[6,12,9,12],[6,15,9,15],[6,16,9,16]]}
[]
[]
[]
[null,null,null,"Tab. B2.2:",null,null,null,"Učitelé MŠ, ZŠ, SŠ, konzervatoří, VOŠ a škol pro žáky se SVP – struktura"]
[null,null,null,"učitelů v letech 2011 až 2018 – podle nejvyššího dosaženého vzdělání"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Nejvyšší dosažené vzdělání",null,null,null,null,null,2006,2011,2012,2013,2014,2015,2016,2017,2018]
[]
[]
[]
[]
[null,null,null,"Učitelé (bez ředitelů a zástupců ředitele/řídících pracovníků)"]
[null,null,null,null,"Střední a střední vzdělání s výučním listem",null,null,null,null,1.8174112103202876E-2,1.3269695272268159E-2,1.295039892330024E-2,1.1732494689864254E-2,1.066828782405058E-2,9.0499544630330397E-3,8.5199028564480212E-3,8.1240285107134873E-3,7.8731582488365051E-3]
[null,null,null,null,"Střední vzdělání s maturitní zkouškou",null,null,null,null,null,0.26950473406665759,0.26729097121438611,0.26351116022278981,0.25173767062118529,0.23905447804668348,0.23260015891359437,0.22789016949504412,0.22351217587274338]
[null,null,null,null,"Vyšší odborné vzdělání",null,null,null,null,null,3.9860368613913177E-2,4.0549008511417087E-2,4.1027582095564945E-2,4.2239374962516694E-2,4.2660488938016571E-2,4.3820893785423982E-2,4.4219302915043834E-2,4.3758813337713087E-2]
[null,null,null,null,"Vysokoškolské – bakalářské",null,null,null,null,0.30219129263794581,3.6770614645255106E-2,3.9581010862296408E-2,4.3382535309746173E-2,4.895223401662329E-2,5.2240023699064289E-2,5.5335816850527929E-2,5.8486397729235813E-2,6.0964959297983456E-2]
[null,null,null,null,"Vysokoškolské – magisterské",null,null,null,null,1.1322719787577144E-2,0.63215495358793317,0.63069245257245321,0.63105098421233885,0.63732902414443715,0.64751072214455085,0.64983574902385266,0.65098352522707204,0.6530111532785019]
[null,null,null,null,"Vysokoškolské – doktorské",null,null,null,null,0.66831187547127391,8.4396338139728078E-3,8.9361676753684019E-3,9.2952337521371216E-3,9.0734084311870269E-3,9.484342453973867E-3,9.8874691484728845E-3,1.0296576122890868E-2,1.0879739964221655E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: databáze MŠMT",""]

{"sheet":"B2.3","index":3,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,3,10,8],[6,9,9,9],[6,17,9,17],[6,13,9,13],[6,14,9,14],[6,10,9,10],[6,11,9,11],[6,12,9,12],[6,15,9,15],[6,16,9,16]]}
[]
[]
[]
[null,null,null,"Tab. B2.3:",null,null,null,"Učitelé MŠ, ZŠ, SŠ, konzervatoří, VOŠ a škol pro žáky se SVP – struktura"]
[null,null,null,"učitelů v letech 2011 až 2018 – podle věku"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Věk",null,null,null,null,null,2006,2011,2012,2013,2014,2015,2016,2017,2018]
[]
[]
[]
[]
[null,null,null,"Učitelé (bez ředitelů a zástupců ředitele/řídících pracovníků)"]
[null,null,null,null,"do 24 let",null,null,null,null,3.2822075127458016E-2,1.7514122527286579E-2,1.7012209027895298E-2,1.6388960986629501E-2,1.7528233056603774E-2,1.7612616545946622E-2,1.7347840674684742E-2,1.8170431869681297E-2,1.8332566066474879E-2]
[null,null,null,null,"25–29 let",null,null,null,null,null,7.6355943409581517E-2,7.3497479795476259E-2,7.1372443786148584E-2,6.8515096150943408E-2,6.8445273185485975E-2,6.8246433823595964E-2,6.9342977786753565E-2,6.8830626497756356E-2]
[null,null,null,null,"30–34 let",null,null,null,null,null,9.0699844191207205E-2,8.6608480324440379E-2,8.2872118235055039E-2,7.999313147169812E-2,7.8188017185237615E-2,7.5476832405155722E-2,7.1594132545768852E-2,6.9687333762606399E-2]
[null,null,null,null,"35–39 let",null,null,null,null,null,0.12240670759484623,0.12722679800898956,0.12978319978555564,0.13016601116981133,0.12646758768699645,0.11758338597225888,0.11080683980486286,0.10517468274974957]
[null,null,null,null,"40–44 let",null,null,null,null,null,0.13588426667583045,0.13115408158798422,0.13152759898289682,0.13520157947169811,0.1410985574665708,0.14803041400999201,0.15409293285629849,0.15591808905697024]
[null,null,null,null,"45–49 let",null,null,null,null,0.19813208629808846,0.18898250123654231,0.18314006672251024,0.17013642223889863,0.15584515864150944,0.14418797156379878,0.13680228988401463,0.13278385393989137,0.13473350230299785]
[null,null,null,null,"50–54 let",null,null,null,null,0.31287660149090313,0.17053831696295341,0.17265073257049507,0.17788699270220548,0.18312999607547167,0.18356453280861898,0.18186994306234999,0.17579295305184323,0.16286937449403113]
[null,null,null,null,"55–59 let",null,null,null,null,0.30274759901319293,0.13981693341639451,0.14577230325956647,0.15145503655274922,0.15485448694339624,0.15788321754350637,0.16163005926861146,0.1630243662026632,0.16851513435369159]
[null,null,null,null,"60–64 let",null,null,null,null,0.14329842138258633,4.4243137933786016E-2,4.8921585829503074E-2,5.3982178855780188E-2,5.9190948226415095E-2,6.5283988371473006E-2,7.340627263512492E-2,8.0673790073797103E-2,8.861804227597124E-2]
[null,null,null,null,"65 a více let",null,null,null,null,1.0123216687771124E-2,1.3558216249995625E-2,1.4016272577300214E-2,1.4595047874080816E-2,1.5575349132075471E-2,1.7268227956284975E-2,1.9606528264211602E-2,2.3716795467304524E-2,2.7320648439750614E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: databáze MŠMT"]

{"sheet":"B2.4","index":4,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,24,9,24],[6,17,9,17],[6,14,9,14],[6,15,9,15],[6,19,9,19],[6,20,9,20],[6,22,9,22],[6,23,9,23],[43,4,43,24],[42,4,42,24],[27,4,28,4],[31,4,32,4],[33,4,34,4],[41,4,41,24],[25,4,26,4],[15,4,16,4],[13,4,14,4],[6,3,10,8],[21,4,22,4],[19,4,20,4],[6,10,9,10],[6,9,9,9],[6,21,9,21],[6,11,9,11],[6,12,9,12],[6,13,9,13],[6,16,9,16],[6,18,9,18]]}
[]
[]
[]
[null,null,null,"Tab. B2.4:",null,null,null,"Regionální školství – výdaje v běžných cenách "]
[null,null,null,"v letech 2008 až 2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v tis. Kč",""]
[null,null,null,null,null,null,null,null,null,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018]
[]
[]
[]
[]
[null,null,null,"Výdaje na regionální školství z rozpočtů kapitoly 333-MŠMT; kapitoly 700-Obce a DSO, KÚ1)"]
[null,null,null,null,"Celkem",null,null,null,null,88719423.199999988,92959097.380000025,95531621.310000017,103098700.13000001,{"$f":"N19+N31+N25","v":105368849.89999999},109433676.92000002,120051447.63000003,118543695.65000001,120189926.85178001,118606446.85488994,{"$f":"T19+T31+T25","v":119727309.56750999},{"$f":"U19+U31+U25","v":130203527.95825},{"$f":"V19+V31+V25","v":130761114.78316},{"$f":"W19+W31+W25","v":128935541.38594998},{"$f":"X19+X31+X25","v":146282172.25455004},219776675.91880995]
[null,null,null,null,"v tom"," neinvestiční výdaje",null,null,null,82040858.399999991,84577281.350000024,87592340.970000014,92398846.950000003,{"$f":"N20+N26+N32","v":97025341.280000016},98871269.890000001,105673231.81000002,105114467.75999999,107893267.73833001,109674112.21864995,{"$f":"T20+T26+T32","v":109349783.84732002},115459580.75981002,116899895.65564001,120486983.02379999,134777977.45864004,189807319.00391993]
[null,null,null,null,null," investiční výdaje",null,null,null,6678564.7999999998,8381816.0299999993,7939280.3399999989,10699853.18,8343508.6199999982,10562407.029999996,14378215.820000004,13429227.889999999,12296659.113449998,8932334.6362399999,10377525.72019,14743947.198439999,13861219.127520004,8448558.3621500004,11504194.795910001,29969356.914889991]
[null,null,null,null,"v %"," neinvestiční výdaje",null,null,null,0.92472263052314341,0.90983328941182973,0.91689369204530669,0.89621738036941045,{"$f":"N14/N13","v":0.92081617453433007},{"$f":"O14/O13","v":0.90348120133328313},0.8802328826195096,0.88670895009688155,{"$f":"R14/R13","v":0.89768976955436186},0.92468929916458642,0.91332365391257331,0.88676230644712128,0.89399586298643952,{"$f":"W14/W13","v":0.93447455781908528},{"$f":"X14/X13","v":0.92135613917537951},0.86363722724625558]
[null,null,null,null,null," investiční výdaje",null,null,null,7.5277369476856565E-2,9.0166710588170274E-2,8.3106307954693259E-2,0.1037826196305895,{"$f":"N15/N13","v":7.9183825465670182E-2},{"$f":"O15/O13","v":9.6518798666716629E-2},0.11976711738049035,0.11329104990311842,{"$f":"R15/R13","v":0.10231023044563808},7.5310700835413608E-2,8.6676346087426942E-2,0.11323769355287878,0.1060041370135605,{"$f":"W15/W13","v":6.5525442180914703E-2},{"$f":"X15/X13","v":7.8643860824620535E-2},0.13636277275374431]
[null,null,null,"Výdaje na regionální školství z rozpočtu kapitoly 333-MŠMT"]
[null,null,null,null,"Celkem",null,null,null,null,67305642.530000001,69859440.230000004,72729690.350000009,76156420.430000007,79497225.909999996,82132513.409999996,88396466.660000026,85135869.570000008,{"$f":"R20+R21","v":90448214.586560011},90136726.176770002,{"$f":"T20+T21","v":90492763.299999997},92659141.914650008,95010793.036949992,98864186.807269976,112326043.92643,174949493.12529999]
[null,null,null,null,"v tom"," neinvestiční výdaje",null,null,null,66716406.410000004,69066812.590000004,72026925.720000014,75554469.659999996,79062285.829999998,81611233.890000001,87913952.100000024,84879289.090000004,90116536.073710009,90055275.642480001,90287013.700000003,92367817.790470004,94676537.457539991,98434734.184359983,111871931.77289,164344404.86361]
[null,null,null,null,null," investiční výdaje",null,null,null,589236.12,792627.64,702764.63,601950.77,434940.08,521279.52,482514.56,256580.48000000001,331678.51285000006,81450.534289999996,205749.6,291324.12417999998,334255.57940999995,429452.62290999992,454112.15354000003,10605088.261689998]
[null,null,null,null,"v %"," neinvestiční výdaje",null,null,null,0.99124536817641462,0.98865396519940019,0.99033730754774218,0.99209586313798326,0.99452886468651869,0.99365318923825208,0.99454147232088019,0.99698622353543898,{"$f":"R20/R19","v":0.99633294571522379},0.99909636684462821,0.9977263419471688,0.99685595918373227,0.9964819199090359,{"$f":"W20/W19","v":0.99565613558580934},{"$f":"X20/X19","v":0.99595719623280399},0.93938200064349686]
[null,null,null,null,null," investiční výdaje",null,null,null,8.7546318235853862E-3,1.1346034800599775E-2,9.6626924522579087E-3,7.9041368620166377E-3,5.4711353134812802E-3,6.3468107617480011E-3,5.458527679119792E-3,3.0137764645609879E-3,{"$f":"R21/R19","v":3.6670542847761778E-3},9.036331553718155E-4,2.273658052831281E-3,3.1440408162676904E-3,3.5180800909640542E-3,{"$f":"W21/W19","v":4.343864414190682E-3},{"$f":"X21/X19","v":4.0428037671960482E-3},6.0617999356503215E-2]
[null,null,null,"Transfery z kapitoly 333-MŠMT do místních rozpočtů1)"]
[null,null,null,null,"Celkem",null,null,null,null,-62873585.950000003,-65467664.939999998,-68546171.829999998,-72430196.849999994,-75098157.170000002,-78469683.449999988,-83397045.659999996,-80102122.590000004,{"$f":"R26+R27","v":-84823635.864779994},-84756049.611880019,-84956879.801289991,{"$f":"U26+U27","v":-86945909.665620014},{"$f":"V26+V27","v":-89266219.719260007},{"$f":"W26+W27","v":-93576750.537249997},{"$f":"X26+X27","v":-106254453.26748998},-120882985.38241]
[null,null,null,null,"v tom"," neinvestiční ",null,null,null,-62788596.859999999,-65433125.759999998,-68474409.010000005,-72362645.730000004,-75090241.689999998,-78252961.459999993,-83342793.920000002,-80084782.180000007,-84724903.77538,-84740360.173830017,-84956879.801289991,-86336160.60191001,-89044880.825010002,-93257808.47383,-105859375.95643999,-119998516.99234]
[null,null,null,null,null," investiční",null,null,null,-84989.09,-34539.18,-71762.820000000007,-67551.12,-7915.48,-216721.99,-54251.74,-17340.41,-98732.089399999997,-15689.438049999999,0,-609749.06371000002,-221338.89425000001,-318942.06341999996,-395077.31105000002,-884468.39006999996]
[null,null,null,null,"v %"," neinvestiční ",null,null,null,0.99864825445032523,0.99947242382889856,0.99895307326311422,0.99906736246844829,0.99989459821254889,0.99723814369484376,0.99934947647640693,0.99978352121717484,{"$f":"R26/R25","v":0.99883603091999751},0.99981488710101696,1,0.99298702991256282,0.9975204630044141,{"$f":"W26/W25","v":0.99659165271727368},{"$f":"X26/X25","v":0.99628178114986476},0.99268326814338659]
[null,null,null,null,null," investiční ",null,null,null,1.3517455496746642E-3,5.27576171101483E-4,1.0469267368858695E-3,9.3263753155186963E-4,1.0540178745107813E-4,2.7618563051562818E-3,6.5052352359312585E-4,2.16478782825223E-4,{"$f":"R27/R25","v":1.1639690800025586E-3},1.8511289898297541E-4,0,7.0129700874370839E-3,2.4795369955858465E-3,{"$f":"W27/W25","v":3.4083472827263757E-3},{"$f":"X27/X25","v":3.7182188501352852E-3},7.3167318566133063E-3]
[null,null,null,"Výdaje na regionální školství z rozpočtu kapitoly 700-Obce a DSO, KÚ"]
[null,null,null,null,"Celkem",null,null,null,null,84287366.619999975,88567322.089999989,91348102.790000007,99372476.550000012,{"$f":"N32+N33","v":100969781.16000001},{"$f":"O32+O33","v":105770846.95999999},115052026.63,{"$f":"Q32+Q33","v":113509948.66999999},{"$f":"R32+R33","v":114565348.13},113225770.28999996,114191426.0688,{"$f":"U32+U33","v":124490295.70922002},{"$f":"V32+V33","v":125016541.46547002},{"$f":"W32+W33","v":123648105.11593001},{"$f":"X32+X33","v":140210581.59561002},165710168.17591992]
[null,null,null,null,"v tom"," neinvestiční výdaje",null,null,null,78113048.849999979,80943594.519999996,84039824.260000005,89207023.020000026,{"$f":"93053729.65-1.02-431.49","v":93053297.140000015},{"$f":"95514531.99-36.78-1497.75","v":95512997.459999993},101102073.63,100319960.84999999,102501635.44,104359196.74999997,104019649.94861001,109427923.57125002,111268239.02311002,115310057.31327,128765421.64219002,145461431.13264993]
[null,null,null,null,null," investiční výdaje",null,null,null,6174317.7699999996,7623727.5699999984,7308278.5299999993,10165453.529999999,7916484.0199999986,10257849.499999996,13949953.000000004,13189987.819999998,12063712.689999998,8866573.5399999991,10171776.12019,15062372.137969999,13748302.442360004,8338047.8026599996,11445159.95342,20248737.043269992]
[null,null,null,null,"v %"," neinvestiční výdaje",null,null,null,0.92674681844271867,0.91392166557488386,0.91999528937343134,0.89770353036451533,0.89800766859234715,0.85577912179944071,0.8297943314980476,0.88379240630566669,{"$f":"R32/R31","v":0.89470016120135187},0.92169120583335007,0.91092346885954878,0.87900766037898925,0.89002813322781504,{"$f":"W32/W31","v":0.93256631151086045},{"$f":"X32/X31","v":0.91837163912186248},0.877806309255726]
[null,null,null,null,null," investiční výdaje",null,null,null,7.3253181557281416E-2,8.6078334425116171E-2,8.0004710626568651E-2,0.10229646963548478,0.10199233140765286,0.14422087820055929,0.17020566850195235,0.11620759369433332,{"$f":"R33/R31","v":0.10529983879864808},7.8308794166649973E-2,8.9076531140451248E-2,0.12099233962101069,0.10997186677218496,{"$f":"W33/W31","v":6.7433688489139498E-2},{"$f":"X33/X31","v":8.1628360878137504E-2},0.12219369074427398]
[null,null,null,"Podíl výdajů na regionální školství na celkových výdajích na školství z rozpočtu MŠMT; Obce a DSO, KÚ a podíl na HDP"]
[null,null,null,null,"Výdaje na školství celkem2),3)",null,null,null,null,114.24777249999998,121.34803966999998,128.55417447999997,141.24843944,151.58498969999997,149.79972682000005,162.80350399,161.87480193999997,172.76879587426001,170.37426544439001,171.72496276016,177.59063407748005,181.60898122443001,172.2724,193.64213354046001,221.50258083132999]
[null,null,null,null,"Podíl výdajů na RgŠ na celkových výdajích",null,null,null,null,{"$f":"J13/1000000/J37","v":0.77655276123654848},0.76605355663591868,0.74312344734369173,0.72991036601005876,0.69511400903568499,0.730533220874935,0.7374008831982759,0.73231716258061619,{"$f":"R13/1000000/R37","v":0.69566918171527603},0.69615235931040864,0.69720387556424968,0.7331666370504889,0.72001458243723704,{"$f":"W13/1000000/W37","v":0.7484399206486354},{"$f":"X13/1000000/X37","v":0.75542532805230389},{"$f":"Y13/1000000/Y37","v":0.99220819501947799}]
[null,null,null,null,"HDP v běžných cenách v mld. Kč",null,null,null,null,2688.107,3057.66,3257.9720000000002,3507.1309999999999,3840.1170000000002,4024.1170000000002,3930.4090000000001,3962.4639999999999,4033.7550000000001,4059.9119999999998,4098.1279999999997,4313.7889999999998,4595.7830000000004,4773.24,5055.0290000000005,5408.7659999999996]
[null,null,null,null,"Výdaje na RgŠ v % HDP",null,null,null,null,{"$f":"J13/1000000/J39","v":3.3004424005443234E-2},3.040203861122559E-2,2.9322419379294855E-2,2.9396877427732244E-2,2.7438968630382872E-2,2.71944570498323E-2,3.0544263365466551E-2,2.9916661867464285E-2,{"$f":"R13/1000000/R39","v":2.9796040377211806E-2},2.9214043766192455E-2,2.9215122018519186E-2,3.0183100740033879E-2,2.8452412740801729E-2,{"$f":"W13/1000000/W39","v":2.7012163936016204E-2},{"$f":"X13/1000000/X39","v":2.8937949169935528E-2},{"$f":"Y13/1000000/Y39","v":4.0633422839666193E-2}]
[null,null,null,"Komentáře:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: Státní závěrečný účet, ZÚ – kapitola 333-MŠMT; 700-Obce a DSO, KÚ; ČSÚ; monitor.statnipokladna.cz"]
[null,null,null,"1)","Výdaje (za část 31–32–vzdělávání) neobsahují finanční prostředky určené na mezinárodní spolupráci (paragraf RS 3291)."]
[null,null,null,"2)","Od roku 2004 celkové výdaje kapitoly 333-MŠMT a kapitoly 700-Obce a DSO; KÚ. Nejsou zahrnuty výdaje Ministerstva obrany. "]
[null,null,null,"3)","Meziroční snížení výdajů v roce 2008 je dáno aplikací zákona č. 26/2008 Sb. a z něj vyplývajícím nepřeváděním nevyčerpaných prostředků OSS do rezervních fondů, a tudíž jejich nezahrnutím do čerpání."]

{"sheet":"B2.5","index":5,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,4,17,10],[6,9,10,9],[6,10,10,10],[6,3,10,8],[16,4,16,10]]}
[]
[]
[]
[null,null,null,"Tab. B2.5:",null,null,null,"Regionální školství – týdenní rozsah hodin přímé pedagogické činnosti "]
[null,null,null,"(míra vyučovací povinnosti) učitelů v letech 2004 až 2018"]
[null,null,null,null,null,null,null,null,null,null,"hod/týdně",""]
[null,null,null,null,null,null,null,null,null,"20041)","2004–20182)"]
[]
[]
[]
[]
[null,null,null,null,"MŠ včetně speciálních",null,null,null,null,31,31]
[null,null,null,null,"ZŠ včetně speciálních škol – 1. stupeň",null,null,null,null,22,"20–22"]
[null,null,null,null,"ZŠ včetně speciálních škol – 2. stupeň a nižší ročníky víceletých G",null,null,null,null,22,22]
[null,null,null,null,"SŠ včetně speciálních, konzervatoře a VOŠ",null,null,null,null,21,21]
[null,null,null,"Komentáře:",null,null,null,null,null,null,"Zdroj: databáze MŠMT",""]
[null,null,null,"1) ","NV č. 153/1999 Sb., kterým se mění NV č. 68/1997 Sb., kterou se stanoví míra vyučovací povinnosti učitelů a míra povinnosti výchovné práce ostatních pedagogických pracovníků ve školství, a NV č. 400/2002 Sb., kterým se mění NV č. 68/1997 Sb., ve znění NV č. 153/99 Sb."]
[null,null,null,"2) ","Zákon č. 563/2004 Sb., o pedagogických pracovnících a  o změně některých zákonů, a NV č. 273/2009 Sb., kterým se mění NV č. 75/2005 Sb., o stanovení rozsahu přímé vyučovací, přímé výchovné, přímé speciálně pedagogické a přímé pedagogicko-psychologické činnosti pedagogických pracovníků."]

{"sheet":"B2.6","index":6,"n_rows":16,"n_cols":26,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,23,9,23],[6,22,9,22],[15,4,15,24],[6,24,9,24],[6,9,9,9],[6,10,9,10],[6,3,10,8],[6,11,9,11],[6,12,9,12],[6,13,9,13],[6,18,9,18],[6,21,9,21],[6,20,9,20],[6,19,9,19],[6,14,9,14],[6,15,9,15],[6,16,9,16],[6,17,9,17]]}
[]
[]
[]
[null,null,null,"Tab. B2.6:",null,null,null,"Regionální školství – přepočtené počty zaměstnanců "]
[null,null,null,"v letech 2008 až 2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018]
[]
[]
[]
[]
[null,null,null,"Všichni zřizovatelé (bez jiných resortů)"]
[null,null,null,null,"Zaměstnanci celkem",null,null,null,null,244248.25399999999,241290.158,238113.30000000054,236084.97400000016,234899.47899999999,233315.31700000333,232614.73,233147.79100000029,231528.71599999955,229787.50299999813,229649.45899999782,231920.14099999907,235149.15399999853,238449.1339999995,246237.87899999871,253506.63410000008]
[null,null,null,null,null,"z toho učitelé1)",null,null,null,137976.42000000001,136572.796,137676.68500000011,133792.54600000035,132876.32399999999,131875.70599999951,131449.14099999954,131867.99599999943,132046.23100000003,131718.65599999996,131368.38400000014,131912.93599999943,132950.68499999988,133582.20200000014,135609.4380000004,137773.42210000008]
[null,null,null,"Komentáře:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: databáze MŠMT",""]
[null,null,null,"1)","Včetně vedoucích zaměstnanců."]

{"sheet":"B2.7","index":7,"n_rows":23,"n_cols":26,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,11,9,11],[6,12,9,12],[6,18,9,18],[6,16,9,16],[6,15,9,15],[6,17,9,17],[22,4,22,24],[19,4,19,6],[6,3,10,8],[6,13,9,13],[6,24,9,24],[6,23,9,23],[6,21,9,21],[6,20,9,20],[6,14,9,14],[6,19,9,19],[6,22,9,22],[6,9,9,9],[6,10,9,10]]}
[]
[]
[]
[null,null,null,"Tab. B2.7:",null,null,null,"Regionální školství – průměrné měsíční mzdy "]
[null,null,null,"v letech 2008 až 2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018]
[]
[]
[]
[]
[null,null,null,"Všichni zřizovatelé (bez jiných resortů)"]
[null,null,null,"Nominální mzda (v běžných cenách)"]
[null,null,null,null,"Zaměstnanci celkem",null,null,null,null,15708,16699,17712.680593650053,18787,19842,20519.082443767049,21890.625309569397,21457.948217274818,22059.453305207786,22600.393453874563,22736.160423889331,23105.298815983475,23637.347321692072,24814.030370938806,26608.581841437241,29476]
[null,null,null,null,null,"z toho učitelé1)",null,null,null,18658,19996,21305.762701094493,22598,23858,24661.298237902916,26006.025776666727,25150.829181605844,26011.552765056589,26654.328590325251,26815.832769169177,27261.212713184505,27969.264789171051,29487.404484094175,31631.639671839443,35088.9]
[null,null,null,"Reálná mzda  (ve stálých cenách roku 2015)"]
[null,null,null,null,"Zaměstnanci celkem",null,null,null,null,{"$f":"J14/J$20*100","v":16448.167539267015},{"$f":"K14/K$20*100","v":17022.426095820592},17712.680593650053,22634.939759036144,23261.430246189921,22623.023642521555,23872.001428101852,23073.062599220233,{"$f":"R14/R$20*100","v":23269.46551182256},23085.182281792197,22896.435472194695,23174.823285840997,23637.347321692072,24641.53959378233,25808.517789948826,27992.402659069325]
[null,null,null,null,null,"z toho učitelé",null,null,null,{"$f":"J15/J$20*100","v":19537.172774869108},{"$f":"K15/K$20*100","v":20383.282364933744},21305.762701094493,27226.506024096387,27969.51934349355,27189.964981149853,28359.897248273421,27043.902345812734,27438.346798582897,27226.076190322012,27004.866837028378,27343.242440506019,27969.264789171051,29282.427491652605,30680.542843685202,33322.792022792026]
[null,null,null,"Index spotřebitelských cen a meziroční inflace"]
[null,null,null,null,"Index spotřebitelských cen\n(rok 2015 = 100)",null,null,null,null,95.5,98.1,100,83,85.3,90.7,91.7,93,94.8,97.9,99.3,99.7,100,100.7,103.1,105.3]
[null,null,null,null,"Meziroční inflace",null,null,null,null,1E-3,2.8000000000000001E-2,1.9E-2,2.5000000000000001E-2,2.8000000000000001E-2,6.3E-2,0.01,1.4999999999999999E-2,1.9E-2,3.3000000000000002E-2,1.4E-2,4.0000000000000001E-3,3.0000000000000001E-3,7.0000000000000001E-3,2.5000000000000001E-2,2.1000000000000001E-2]
[null,null,null,"Komentáře:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: databáze MŠMT, ČSÚ"," "]
[null,null,null,"1)","Včetně vedoucích zaměstnanců."]

{"sheet":"GB1","index":8,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Obr. B1:",null,null,"Regionální školství – školy ve školním roce 2008/09 až 2018/19 – podle druhu školy "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"2003/04","2004/05","2005/06","2007/08","2008/09","2009/10","2010/11","2011/12","2012/13","2013/14","2014/15","2015/16","2016/17","2017/18","2018/19"]
[null,null,null,null,null,null,null,null,"MŠ",5067,4994,4834,4808,4809,4826,4880,4931,5011,5085,5158,5209,5209,5269,5287]
[null,null,null,null,null,null,null,null,"ZŠ",4838,4765,4474,4155,4133,4125,4123,4111,4095,4095,4106,4115,4140,4155,4172]
[null,null,null,null,null,null,null,null,"SŠ",2006,1966,2004,1447,1438,1433,1423,1393,1347,1331,1310,1304,1307,1308,1290]
[null,null,null,null,null,null,null,null,"Konzervatoře",17,17,17,19,18,17,18,18,18,18,18,18,18,18,18]
[null,null,null,null,null,null,null,null,"VOŠ",169,174,176,177,184,184,182,180,178,174,174,171,168,166,166]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: databáze MŠMT"]

{"sheet":"GB2","index":9,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Obr. B2:",null,null,"Regionální školství – děti/žáci/studenti ve školním roce 2008/09 až 2018/19 – podle druhu školy"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"2003/04","2004/05","2005/06","2007/08","2008/09","2009/10","2010/11","2011/12","2012/13","2013/14","2014/15","2015/16","2016/17","2017/18","2018/19"]
[null,null,null,null,null,null,null,null,"MŠ",286340,286230,282183,291194,301620,314008,328612,342521,354340,363568,367603,367361,362653,362756,363776]
[null,null,null,null,null,null,null,null,"ZŠ",998026,958203,916575,844863,816015,794459,789486,794642,807950,827654,854137,880251,906188,926108,940928]
[null,null,null,null,null,null,null,null,"SŠ",576615,579505,577605,569267,564326,556260,532918,501220,470754,448792,435542,427107,425138,421535,420814]
[null,null,null,null,null,null,null,null,"Konzervatoře",3543,3505,3495,3606,3535,3435,3560,3557,3655,3690,3752,3733,3795,3781,3813]
[null,null,null,null,null,null,null,null,"VOŠ",30681,29759,28792,28774,28027,28749,29800,29335,28980,28332,26964,24786,22002,19883,18416]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: databáze MŠMT"]

{"sheet":"GB3","index":10,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Obr. B3:",null,null,null,"Regionální školství – děti/žáci/studenti ve školním roce 2008/09 a 2018/19 – podle zřizovatele"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"2008/09",null,null,"2018/19"]
[null,null,null,null,null,null,null,null,null,"veřejný",1600200,null,"veřejný",1635619]
[null,null,null,null,null,null,null,null,null,"privátní sektor",96051,null,"privátní sektor",90976]
[null,null,null,null,null,null,null,null,null,"církev",17272,null,"církev",21152]
[null,null,null,null,null,null,null,null,null,null,1713523,null,null,1747747]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: databáze MŠMT"]

{"sheet":"GB4","index":11,"n_rows":54,"n_cols":24,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Obr. B4:",null,null,"Regionální školství – všichni zřizovatelé – přepočtené počty zaměstnanců a učitelů,"]
[null,null,null,"průměrné nominální a reálné mzdy v letech 2008 až 2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Pracovníci"]
[null,null,null,null,null,null,null,null,null,2003,2004,2005,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018]
[null,null,null,null,null,null,null,null,"nominální mzdy ",15708,16699,17712.680593650053,19842,20519.082443767049,21890.625309569397,21457.948217274818,22059.453305207786,22600.393453874563,22736.160423889331,23105.298815983475,23637.347321692072,24814.030370938806,26608.581841437241,{"$f":"'B2.7'!Y14","v":29476}]
[null,null,null,null,null,null,null,null,"reálné mzdy",16448.167539267015,17022.426095820592,17712.680593650053,23261.430246189921,22623.023642521555,23872.001428101852,23073.062599220233,23269.46551182256,23085.182281792197,22896.435472194695,23174.823285840997,23637.347321692072,24641.53959378233,25808.517789948826,{"$f":"'B2.7'!Y17","v":27992.402659069325}]
[null,null,null,null,null,null,null,null,"počty ",244.248254,241.29015799999999,238.113300000001,234.89947900000001,233.31531700000301,232.61473000000001,233.14779100000001,231.528716,229.787502999998,229.64945899999799,231.92014099999901,235.14915399999899,238.44913399999899,246.237878999999,{"$f":"'B2.6'!Y13/1000","v":253.50663410000007}]
[]
[null,null,null,null,null,null,null,null,"Učitelé"]
[null,null,null,null,null,null,null,null,null,2003,2004,2005,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018]
[null,null,null,null,null,null,null,null,"nominální mzdy",18658,19996,21305.762701094493,23858,24661.298237902916,26006.025776666727,25150.829181605844,26011.552765056589,26654.328590325251,26815.832769169177,27261.212713184505,27969.264789171051,29487.404484094175,31631.639671839443,{"$f":"'B2.7'!Y15","v":35088.9}]
[null,null,null,null,null,null,null,null,"reálné mzdy ",19537.172774869108,20383.282364933744,21305.762701094493,27969.51934349355,27189.964981149853,28359.897248273421,27043.902345812734,27438.346798582897,27226.076190322012,27004.866837028378,27343.242440506019,27969.264789171051,29282.427491652605,30680.542843685202,{"$f":"'B2.7'!Y18","v":33322.792022792026}]
[null,null,null,null,null,null,null,null,"počty ",137.97641999999999,136.57279600000001,137.67668499999999,132.87632400000001,131.87570600000001,131.449141,131.86799599999901,132.04623100000001,131.71865600000001,131.36838399999999,131.91293599999901,132.95068499999999,133.582202,135.60943800000001,{"$f":"'B2.6'!Y14/1000","v":137.77342210000009}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Komentáře:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zdroj: databáze MŠMT"," "]
[null,null,null,null,"Průměrná reálná měsíční mzda ve stálých cenách roku 2015."]
[null,null,null,"1)","Učitelé včetně vedoucích zaměstnanců."]