Spreadsheet: 859016d1707488344-index-and-match-functions-with-sum-book4-3-
Sheet: Üür_kulukohad

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Kuude arv | 12
Kalender | 2023
FinSummaHaldus | Column Labels
 | 1 Tulud |  |  |  |  |  |  | Grand Total
 | 01 Üüritulu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ÜÜR, ÜÜRITEENUSED JA KÕRVALTEENUSED |  |  |  |  |  |  |  |  |  |  |  |  |  | ÜÜR, ÜÜRITEENUSED JA KÕRVALTEENUSED
 | 1000 Haldamine | 2000 Tehnohooldus | 3000 Heakorratööd | 5000 Omanikukohustused |  |  | 7000 Tugiteenused |  |  |  | Kalender | 2023 |  |  |  | 2000 Tehnohooldus | 3000 Heakorratööd | 5000 Omanikukohustused | 5340 Üür | 5350 Sihtotstarbelised maksed | 7000 Tugiteenused |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  | [NAME]
 |  |  |  | 5000 Omanikukohustused | 5300 [NAME] otsused ja kohustused |  |  |  |  |  |  |  |  |  | Haldamine | Tehnohooldus | Heakord | Maamaks ja kindlustus | Üür (kapitalikomponent) | Remondikomponent | Tugiteenused | Üür ja üüriteenused [NAME] |  |  | Üür (kapitalikomponent) | Remondikomponent | Haldamine | Tehnohooldus | Heakord | Maamaks ja kindlustus | [NAME] | Soojus | Vesi | Kommunikatsioon ja tugiteenused | ÜÜR, ÜÜRI- [NAME] KOKKU |  |  |  | Üür (kapitalikomponent) | Remondikomponent | Haldamine | Tehnohooldus | Heakord | Maamaks ja kindlustus | [NAME] | Soojus | Vesi | Kommunikatsioon ja tugiteenused | ÜÜR, ÜÜRI- [NAME] KOKKU
Row Labels |  |  |  |  | 5340 Üür | 5350 Sihtotstarbelised maksed |  |  |  |  | Row Labels | PndKogus |  | Ministeeriumid | 1000 Haldamine | 2000 Tehnohooldus | 3000 Heakorratööd | 5000 Omanikukohustused | 5340 Üür | 5350 Sihtotstarbelised maksed | 7000 Tugiteenused | Üür ja üüriteenused [NAME] |  | Ministeeriumid | 5340 Üür | 5350 Sihtotstarbelised maksed | 1000 Haldamine | 2000 Tehnohooldus | 3000 Heakorratööd | 5000 Omanikukohustused | 6100 Elektrienergia | 6200 Soojusenergia | 6300 Vesi ja kanalisatsioon | 6400 Kommunikatsioon | ÜÜR, ÜÜRI- [NAME] KOKKU |  |  | Ministeeriumid | 5340 Üür | 5350 Sihtotstarbelised maksed | 1000 Haldamine | 2000 Tehnohooldus | 3000 Heakorratööd | 5000 Omanikukohustused | 6100 Elektrienergia | 6200 Soojusenergia | 6300 Vesi ja kanalisatsioon | 6400 Kommunikatsioon | ÜÜR, ÜÜRI- [NAME] KOKKU
[NAME] | 50708.04999999998 | 84978.79000000005 | 93821.57000000002 | 50003.61999999998 | 1258114.430000001 | 216530.7400000001 | 20420.32 | 1774577.520000001 |  |  | [NAME] | 32861.73760000001 |  | [NAME]
Haigla | 10523.52 | 11995.08 | 8908.199999999997 | 627.8400000000003 | 108331.68 | 14006.04 |  | 154392.36 |  |  | Haigla | 2299.2518 |  | Haigla | 0.3814110311884935 | 0.4347457725160854 | 0.3228658992460068 | 0.0227552284617109 | 3.926338124428129 | 0.5076303517518177 | 0
HTM | 248062.9000000002 | 81908.19 |  | 51384.45000000004 | 3602487.62 | 1849634.26 |  | 5833477.42 |  |  | JuM | 185339.7663 |  | HTM | NB! | NB! | NB! | NB! | NB! | NB! | NB!
JuM | 403610.8000000004 | 1751928.449999999 | 322756.8799999999 | 135073.54 | 17637166.40000001 | 6535941.029999994 | 1766.88 | 26788243.98 |  |  | KaM | 2147.6708 |  | JuM | 0.1814733772723731 | 0.7877102707882281 | 0.1451194592699055 | 0.06073239735887881 | 7.930105319587138 | 2.938720401850423 | 0.0007944328566901835
KaM | 10088.04 | 11074.32 |  | 1401.24 | 157265.6799999999 | 45510 |  | 225339.2799999999 |  |  | KeM | 23991.6198 |  | KaM | 0.3914333612022848 | 0.42970272725224 | 0 | 0.05437053015760143 | 6.102179781618918 | 1.765866537832521 | 0
KeM | 109002.63 | 229444.5999999999 | 11961.33999999999 | 11567.43000000001 | 1046718.489999999 | 528760.51 | 3370.22 | 1940825.219999999 |  |  | KOV | 8839.882400000002 |  | KeM | 0.3786135565552768 | 0.7969609177173327 | 0.04154693770752956 | 0.04017871690347481 | 3.635708699974201 | 1.836615293200559 | 0.01170624030423601
KOV | 15458.41 | 4589.769999999999 | 5817.820000000001 | 1672.48 | 43372.55999999999 | 11777.64 |  | 82688.68 |  |  | KuM | 89328.9056 |  | KOV | 0.1457260147865014 | 0.04326763819090321 | 0.05484443247042894 | 0.01576642392135593 | 0.4088719551291766 | 0.1110274951169033 | 0
KuM | 283769.4799999999 | 308133.0199999997 | 81356.88000000002 | 50858.13999999999 | 9701344.170000011 | 2419018.970000001 |  | 12844480.66000001 |  |  | MeM | 74004.0099 |  | KuM | 0.2647234566217126 | 0.2874517659675284 | 0.07589637368175707 | 0.0474446463310677 | 9.050209918837302 | 2.256659396112279 | 0
MeM | 262483.8500000002 | 463379.0400000003 | 133183.9399999999 | 20835.74999999999 | 2703817.589999998 | 1673402.760000001 |  | 5257102.929999999 |  |  | MKM | 4680.7697 |  | MeM | 0.2955739046603565 | 0.5217949683021167 | 0.1499737876591287 | 0.02346241105510688 | 3.044674644042496 | 1.884360458148634 | 0
MKM | 18655.25000000001 | 28278.17 | 2104.130000000001 | 3045.51 | 641282.1499999999 | 47045.24999999999 | 30000 | 770410.46 |  |  | Muu | 1036.2 |  | MKM | 0.3321257541610448 | 0.5034458684576314 | 0.03746054130086057 | 0.05422024928934231 | 11.41696400202442 | 0.837562570104656 | 0.534100192966127
Muu | 359.76 | 227.16 | 889.9199999999998 | 18.96 | 124603.56 |  | 28.44 | 126127.8 |  |  | PõI | 12272.3548 |  | Muu | 0.02893263848677861 | 0.01826867400115808 | 0.0715691951360741 | 0.001524802161744837 | 10.02087434858135 | 0 | 0.002287203242617256
PõI | 17375.64 | 189437.3199999999 | 78813.34 | 17236.59999999999 | 1008790.62 | 238117.4999999999 | 1699.82 | 1551470.84 |  |  | Ram | 60555.52580000001 |  | PõI | 0.1179863215819021 | 1.286341830121577 | 0.5351685508092818 | 0.1170421941625525 | 6.850020747444493 | 1.616896294425907 | 0.01154233796000313
Ram | 302775.8200000002 | 200627.3300000002 | 175802.33 | 150318.8299999999 | 8150758.090000001 | 921122.7200000004 | 69297.19999999998 | 9970702.320000002 |  |  | SiM | 309154.5182 |  | Ram | 0.4166641772159023 | 0.276092791628715 | 0.2419299308052027 | 0.2068608768758582 | 11.21664508498634 | 1.267600696263242 | 0.09536316612524011
SiM | 814351.900000001 | 1829322.170000004 | 314350.9899999997 | 145799.8100000001 | 14547147.06999999 | 5840402.909999989 | 9577.460000000003 | 23500952.30999998 |  |  | SoM | 23051.31 |  | SiM | 0.2195104853341697 | 0.4930981279337064 | 0.08473405462696972 | 0.03930068445193006 | 3.921217981517865 | 1.574294450987581 | 0.002581627049520723
SoM | 85627.18999999999 | 200277.2400000003 | 73725.89999999998 | 12151.81000000001 | 1824337.449999999 | 549059.3599999995 | 4453.240000000001 | 2749632.189999999 |  |  | Töötukassa | 4806.027 |  | SoM | 0.3095528699525826 | 0.724026964194227 | 0.2665282363561984 | 0.04393029434480444 | 6.595205254422994 | 1.984917415394901 | 0.01609901273868311
Töötukassa | 15289.44 | 31232.54 | 6513.549999999998 | 4913.229999999999 | 508448.0600000002 | 88960.00000000004 | 23009.46000000001 | 678366.2800000003 |  |  | Grand Total | 834369.5496999995 |  | Töötukassa | 0.2651087894429224 | 0.5415516114800576 | 0.1129406541688869 | 0.08519216253536095 | 8.816153481174092 | 1.542507633297386 | 0.3989688364214352
Grand Total | 2648142.680000002 | 5426833.190000004 | 1310006.79 | 656909.24 | 63063985.62 | 20979289.68999998 | 163623.04 | 94248790.25000001 |  |  |  |  |  |  | NB! | NB! | NB! | NB! | NB! | NB! | NB!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB! | NB! | NB! | NB! | NB! | NB! | NB!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Keskmine |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Keskmine
Kalender | 2022 |  |  |  | Tegelik 5340 = plaan 5300 + 5340 |  |  |  |  |  |  |  |  | Kuude arv | 12
Väärtus | Tegelik
FinSummaHaldus | Column Labels
 | 1 Tulud |  |  |  |  |  |  | Grand Total
 | 01 Üüritulu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ÜÜR, ÜÜRITEENUSED JA KÕRVALTEENUSED |  |  |  |  |  |  |  |  |  |  |  |  |  | ÜÜR, ÜÜRITEENUSED JA KÕRVALTEENUSED
 | 1000 Haldamine | 2000 Tehnohooldus | 3000 Heakorratööd | 5000 Omanikukohustused |  |  | 7000 Tugiteenused |  |  |  | Kalender | 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | võtab ainult lehelt Teenused_kulukohad | võtab ainult lehelt Teenused_kulukohad | võtab ainult lehelt Teenused_kulukohad | [NAME]
 |  |  |  | 5000 Omanikukohustused | 5300 [NAME] otsused ja kohustused |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Üür (kapitalikomponent) | Remondikomponent | Haldamine | Tehnohooldus | Heakord | Maamaks ja kindlustus | [NAME] | Soojus | Vesi | Kommunikatsioon ja tugiteenused | ÜÜR, ÜÜRI- [NAME] KOKKU |  |  |  | Üür (kapitalikomponent) | Remondikomponent | Haldamine | Tehnohooldus | Heakord | Maamaks ja kindlustus | [NAME] | Soojus | Vesi | Kommunikatsioon ja tugiteenused | ÜÜR, ÜÜRI- [NAME] KOKKU
Row Labels |  |  |  |  | 5340 Üür | 5350 Sihtotstarbelised maksed |  |  |  |  | Row Labels | PndKogus |  | Ministeeriumid | 1000 Haldamine | 2000 Tehnohooldus | 3000 Heakorratööd | 5000 Omanikukohustused | 5340 Üür | 5350 Sihtotstarbelised maksed | 7000 Tugiteenused | Üür ja üüriteenused [NAME] |  | Ministeeriumid | 5340 Üür | 5350 Sihtotstarbelised maksed | 1000 Haldamine | 2000 Tehnohooldus | 3000 Heakorratööd | 5000 Omanikukohustused | 6100 Elektrienergia | 6200 Soojusenergia | 6300 Vesi ja kanalisatsioon | 6400 Kommunikatsioon | ÜÜR, ÜÜRI- [NAME] KOKKU |  |  | Ministeeriumid | 5340 Üür | 5350 Sihtotstarbelised maksed | 1000 Haldamine | 2000 Tehnohooldus | 3000 Heakorratööd | 5000 Omanikukohustused | 6100 Elektrienergia | 6200 Soojusenergia | 6300 Vesi ja kanalisatsioon | 6400 Kommunikatsioon | ÜÜR, ÜÜRI- [NAME] KOKKU
Haigla | 10393.73 | 11843.72 | 9910.839999999998 | 840.8299999999998 | 104995.02 | 13344.84 | 187.2 | 151516.18 |  |  | [NAME] | 31774.43370000001 |  | [NAME]
HTM | 245822.1900000001 | 65167.22000000002 | 8301.75 | 31736.93000000001 | 3190944.310000001 | 1838019.51 |  | 5379991.910000001 |  |  | Haigla | 2299.2518 |  | Haigla
JuM | 392288.7400000002 | 1657597.439999998 | 307457.4900000001 | 125332.5700000002 | 16424970.59000002 | 6656425.060000005 | 1581.3 | 25565653.19000003 |  |  | HTM | 585743.4228999999 |  | HTM
KaM | 7848.599999999997 | 10751.76 |  | 1360.44 | 157236.64 | 45510 |  | 222707.44 |  |  | JuM | 182055.9775 |  | JuM
KeM | 103960.86 | 213399.7200000001 | 13803.82999999999 | 11560.65 | 896274.8399999999 | 515772.9000000001 | 68.74 | 1754841.54 |  |  | KaM | 2147.6708 |  | KaM
KOV | 8014.750000000002 | 4245.29 | 4560.209999999998 | 1080.89 | 9505.209999999997 | 13287.33 | 9.959999999999999 | 40703.64 |  |  | KeM | 22068.0546 |  | KeM
KuM | 252093.74 | 262714.4800000003 | 121239.8500000001 | 49448.05000000002 | 13780331.43000001 | 2281470.519999999 | 2505.46 | 16749803.53000001 |  |  | KOV | 5385.0824 |  | KOV
MeM | 244073.66 | 372734.4499999997 | 133017.98 | 20636.96 | 1842920.25 | 1587971.340000001 |  | 4201354.640000001 |  |  | KuM | 79807.31530000002 |  | KuM
MKM | 13631.5 | 23436.55 | 934.64 | 2415.7 | 267336.09 | 42328.04 | 17500 | 367582.52 |  |  | MeM | 72074.9678 |  | MeM
Muu | 349.3200000000001 | 220.56 | 864 | 18.36 | 124548.37 |  | 27.6 | 126028.21 |  |  | MKM | 4267.17 |  | MKM
PõI | 16990.87 | 164049.6299999999 | 64119.23999999999 | 16785.61 | 994130.3300000001 | 235331.8399999999 | 1583.4 | 1492990.92 |  |  | Muu | 1036.2 |  | Muu
Ram | 243033.7100000001 | 190429.5100000002 | 182886.4699999999 | 175255.9000000001 | 7742470.680000001 | 846466.6299999994 | 132495.6 | 9513038.5 |  |  | PõI | 12272.3548 |  | PõI
SiM | 717543.3700000014 | 1429473.649999999 | 601609.6100000001 | 111560.7900000001 | 13904174.85000004 | 5149701.20999999 | 18074.32999999998 | 21932137.81000002 |  |  | Ram | 55142.7873 |  | Ram
SoM | 102242.01 | 186257.9300000001 | 59190.45999999997 | 14594.72000000001 | 1518831.479999999 | 560994.6399999994 | 2495.27 | 2444606.509999998 |  |  | SiM | 242466.3183000001 |  | SiM
Töötukassa | 15275.23999999999 | 30614.23 | 8218.51999999999 | 4774.019999999998 | 501282.8599999999 | 88223.99000000003 | 16132.32 | 664521.1799999999 |  |  | SoM | 21298.1719 |  | SoM
Grand Total | 2373562.290000002 | 4622936.139999996 | 1516114.89 | 567402.4200000004 | 61459952.95000007 | 19874847.84999999 | 192661.18 | 90607477.72000004 |  |  | Töötukassa | 4550.2297 |  | Töötukassa
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 1324389.4088
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Keskmine |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lehelt teenused_kulukohad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Haldamine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tehnohooldus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heakord
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maamaks ja kindlustus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kommunikatsioon ja tugiteenused
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soojus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vesi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vasakul päringust [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]