{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["I. - Plnění rozpočtu"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"I. - Plnění rozpočtu","index":0,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[[49,1,49,11],[0,1,0,11],[1,1,1,11],[3,2,3,4],[3,5,3,7],[3,9,3,11]]}
[null,"Název : OBEC OLDŘIŠ    IČ : 00277070    "]
[null,"Střednědobý rozpočtový výhled na roky 2019 - 2021"]
[]
[null,"ÚDAJE","Retrospektivní analýza","","","Analýza běžného roku","","",null,"Prospektivní analýza","",""]
["","Měsíc:",12,12,12,"Rozpoč.",11,"Oček.",null,"Oček.","Oček.","Oček.","Oček."]
[null,"Rozpočtový rok:",2014,2015,2016,2017,2017,2017,null,2018,2019,2020,2021]
[null,"1    DAŇOVÉ PŘÍJMY",7025.99,7216.11,7961.35,7659.875,7625.0031499999996,8588,null,8597,9321.06,9487.3811999999998,{"$f":"SUM(M8:M15)","v":9657}]
[null,"2  - DPH (podíl na výnosu)",3149.31,3171.1,3342.44,3300,3402.7014899999999,3729,null,4000,4260.54,4345.7507999999998,4433]
[null,"3  - DPFOZČ (podíl na výnosu)",1408.62,1429.69,1699.95,1710,1740.00197,1937,null,1920,2053.2600000000002,2094.3252000000002,2136]
[null,"4  - DPFOSVČ (podíl na výnosu)",14.14,34.409999999999997,62.68,44,32.391199999999998,50,null,44,66.3,67.626000000000005,69]
[null,"5  - Daň z příjmů PO (podíl na výnosu)",1549.07,1603.76,1824.27,1600,1513.7829099999999,1867,null,1600,1935.96,1974.6792,2014]
[null,"6 - Zúčtování DPPO za obec",39.33,59.85,82.84,59.47,59.47,59,null,100,59,59,59]
[null,"7  - Správní poplatky",7.07,6.62,5.34,6,3.08,4,null,6,4,4,4]
[null,"8  - Daň z nemovitostí",450.19,482.86,507.86,510,440.07294999999999,505,null,510,505,505,505]
[null,"9  - Místní daně a poplatky",408.26,427.82,435.97,430.40499999999997,433.50263000000001,437,null,417,437,437,437]
[null,"10   NEDAŇOVÉ BĚŽNÉ PŘÍJMY",369.79,543.78,333.23,407.22,331.18286999999998,407,null,358,420.19479999999999,426.96653600000002,428]
[null,"11 - Prodej zboží a služeb",55,129.94999999999999,28.17,66.3,54.584000000000003,66,null,34,68.666399999999996,70.039727999999997,71]
[null,"12 - Příjmy z pronájmů",230.77,225.64,175.79,180.7,141.64099999999999,181,null,184,188.3124,192.07864799999999,192.07864799999999]
[null,"13 - Ostatní nedaňové příjmy",84.02,188.19,129.27000000000001,160.22,134.95787000000001,160,null,140,163.21600000000001,164.84816000000001,164.84816000000001]
[null,"14  BĚŽNÉ PŘIJATÉ DOTACE",927.25,1126.72,723.87,1979.999,1924.3989999999999,1980,null,133,129.54,132.13079999999999,133]
[null,"15 - Řádné dotace",800.41,1091.6500000000001,713.87,1959.999,1904.3989999999999,1960,null,133,129.54,132.13079999999999,133]
[null,"16 - Mimořádné dotace",126.84,35.07,10,20,20,20,null,0,0,0,0]
[null,"17  BĚŽNÉ PŘÍJMY CELKEM",8323.0300000000007,8886.61,9018.4500000000007,10047.093999999999,9880.5850200000004,10975,null,9088,9870.7947999999997,10046.478536000001,10218]
[null,"18  BĚŽNÉ VÝDAJE",5871.41,5426.91,6695.63,4973.7610000000004,4045.84402,4825,null,5700,5041.3296,5142.1561920000004,5209]
[null,"19 - Personální výdaje",2005.45,2135.2199999999998,1867.55,1900.7329999999999,1574.5119999999999,1901,null,1986,1999.2,2039.184,2039.184]
[null,"20 - Opravy a udržování",999.35,171.55,2326.85,335.5,286.36178000000001,336,null,310,349.57440000000003,356.56588799999997,356.56588799999997]
[null,"22 - Leasingové splátky",0,0,0,0,0,0,null,0,0,0,0]
[null,"23 - Poskytnuté dotace",1380.21,1693.52,1186.55,1068.05,1014.9829999999999,1068,null,1089.3599999999999,1111.1472000000001,1133.370144,1200]
[null,"24 - Ostatní provozní výdaje",1486.4,1426.62,1314.68,1669.4780000000001,1169.9872399999999,1520,null,2315,1581.4079999999999,1613.0361600000001,1613.0361600000001]
[null,"25 - PROV. PŘEBYTEK PŘED ÚROKY",2451.62,3459.7,2322.8200000000002,5073.3329999999996,5834.741,6150,null,3388,4829.4651999999996,4904.3223440000002,5009]
[null,"26 - Úrokové výdaje",8.41,2.72,0,0,0,0,null,0,0,0,0]
[null,"27 - PROV. PŘEBYTEK PO ÚROCÍCH",2443.21,3456.98,2322.8200000000002,5073.3329999999996,5834.741,6150,null,3388,4829.4651999999996,4904.3223440000002,5009]
[null,"28 - KAPITÁLOVÉ PŘÍJMY",103.81,398.72,107.21,110,110,110,null,0,0,0,0]
[null,"29 - Prodej dlouhodobého majetku",0.84,5.07,7.21,0,0,0,null,0,0,0,0]
[null,"30 - Kapitálové dotace",102.97,393.65,100,110,110,110,null,6364,0,0,0]
[null,"31 - KAPITÁLOVÉ VÝDAJE",300.99,995.97,1785,5940.3689999999997,3155.75623,5940,null,8280,3000,4000,4000]
[null,"32 - Pořízení dlouhodobého majetku",263.55,995.97,1370.64,3887,1189.4870000000001,3887,null,7680,3000,4000,4000]
[null,"33 - Poskytnuté investiční granty",37.44,0,414.36,2053.3690000000001,1966.2692300000001,2053,null,600,0,0,0]
[null,"34 - KAPITÁLOVÝ VÝSLEDEK",-197.18,-597.25,-1677.79,-5830.3689999999997,-3045.75623,-5830,null,-1916,-3000,-4000,-4000]
[null,"35 - ROZPOČTOVÝ PŘEBYTEK/SCHODEK",2246.0300000000002,2859.73,645.03,-757.03599999999994,2788.98477,320,null,1472,1829.4652000000001,904.32234400000004,1009]
[null,"36 - FINANCUJÍCÍ POLOŽKY",-2246.0300000000002,-2859.75,-645.02,757.03599999999994,-2788.98477,-320,null,-1472,-1829.4652000000001,-904.32234400000004,-1009]
[null," 37 - Čerpání dlouhod. půjček ",0,0,0,0,0,0,null,0,0,0,0]
[null," 38 - Splátky jistin dl. půjček",-144,-135.4,0,0,0,0,null,0,0,0,0]
[null,"39 - Změna stavu krátk. půjček",0,0,0,0,0,0,null,0,0,0,0]
[null,"40 - Ostatní financování",0,0,0,0,0,0,null,0,0,0,0]
[null,"41 - Operace řízení likvidity",0,0,0,0,0,0,null,0,0,0,0]
[null,"42 - Změna stavu rozpočt. účtů",-2102.0300000000002,-2724.35,-645.02,757.03599999999994,-2788.98477,-320,null,-1472,-1829.4652000000001,-904.32234400000004,-1009]
[null,"43 - Zústatek rozpočtových účtů",3931.27,6655.62,7300.64,6543.6040000000003,10089.62477,7620.64,null,9093,10922,11826,12835]
[null,"44 - PENĚŽ. EKVIVALENTY OŘL",0,0,0,0,0,0,null,0,0,0,0]
[]
[null,"11a - Odvody přísp. organizací",0,0,0,0,0]
[null,"13a - Úrokové a ost. fin. příjmy",2.99,2.4500000000000002,1.2,1,0.70074000000000003]
[null,"13b - Přijaté splátky půjček",0,78.3,0,0,0]
[null,"16a - Převody z komerční činnosti",0,0,0,0,0]
[null,"23a - Poskytnuté půjčky",78.3,0,0,0,0]
[null,"23b - Platby daní a poplatků",40.39,60.12,1.04,63.57,63.587000000000003]
[null,"23c - Transfery do komerč. činnosti",0,0,0,0,0,null,null,null,null,null,null,null," "]
[null,"23d - Placené sankce a pokuty",0,0,0,0,0]
[null,"29a - Příspěvek na investice",0,0,0,0,0]
[null,"24a - Nespecifikované rozp. rezervy",0,0,0,10,0]
[]
[]
[null,"Zveřejněno na elektronické a úřední desce od 24.11.2017 do 11.12.2017"]
[]
[null,"Schváleno 11.12.2017  usnesením č. 25/2017"]