Spreadsheet: 858948d1707418398-index-and-match-functions-with-sum-book2
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [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.04999999997 | 84978.79000000004 | 93821.57 | 50003.61999999999 | 1258114.43 | 216530.7400000001 | 20420.32 | 1774577.520000001 |  |  | [NAME] | 32861.73760000001 |  | [NAME]
Haigla | 10523.52 | 11995.08 | 8908.199999999997 | 627.8400000000001 | 108331.68 | 14006.04 |  | 154392.36 |  |  | Haigla | 2299.2518 |  | Haigla
HTM | 248062.9000000002 | 81908.19 |  | 51384.45000000003 | 3602487.62 | 1849634.26 |  | 5833477.420000001 |  |  | HTM | 606160.0121 |  | HTM
JuM | 403610.8000000003 | 1751928.449999999 | 322756.8799999999 | 135073.54 | 17637166.4 | 6535941.029999995 | 1766.88 | 26788243.97999999 |  |  | JuM | 185339.7663 |  | JuM
KeM | 109002.63 | 229444.5999999999 | 11961.33999999999 | 11567.43000000001 | 1046718.489999999 | 528760.5099999999 | 3370.22 | 1940825.219999999 |  |  | KaM | 2147.6708 |  | KaM
KOV | 15458.41 | 4589.769999999999 | 5817.820000000001 | 1672.48 | 43372.55999999999 | 11777.64 |  | 82688.68 |  |  | KeM | 23991.6198 |  | KeM
KuM | 283769.4799999999 | 308133.0199999996 | 81356.88000000002 | 50858.13999999999 | 9701344.170000013 | 2419018.970000001 |  | 12844480.66000002 |  |  | KOV | 8839.882400000002 |  | KOV
MKM | 18655.25 | 28278.17 | 2104.130000000001 | 3045.510000000001 | 641282.1499999999 | 47045.24999999999 | 30000 | 770410.46 |  |  | KuM | 89328.9056 |  | KuM
Muu | 359.76 | 227.16 | 889.9199999999998 | 18.96 | 124603.56 |  | 28.44 | 126127.8 |  |  | MeM | 74004.0099 |  | MeM
PõI | 17375.64 | 189437.3199999999 | 78813.34 | 17236.59999999999 | 1008790.62 | 238117.4999999999 | 1699.82 | 1551470.84 |  |  | MKM | 4680.7697 |  | MKM
Ram | 302775.8200000002 | 200627.3300000001 | 175802.33 | 150318.8299999999 | 8150758.090000002 | 921122.7200000004 | 69297.19999999998 | 9970702.320000002 |  |  | Muu | 1036.2 |  | Muu
SiM | 814351.9000000007 | 1829322.170000004 | 314350.9899999998 | 145799.8100000001 | 14547147.06999999 | 5840402.909999988 | 9577.460000000003 | 23500952.30999998 |  |  | PõI | 12272.3548 |  | PõI
SoM | 85627.18999999997 | 200277.2400000003 | 73725.89999999998 | 12151.81000000001 | 1824337.449999999 | 549059.3599999994 | 4453.240000000001 | 2749632.189999999 |  |  | Ram | 60555.52580000001 |  | Ram
Töötukassa | 15289.44 | 31232.54 | 6513.549999999998 | 4913.23 | 508448.0600000002 | 88960.00000000004 | 23009.46000000001 | 678366.2800000003 |  |  | SiM | 309154.5182 |  | SiM
Grand Total | 2375570.790000001 | 4952379.830000004 | 1176822.85 | 634672.25 | 60202902.35 | 19260376.92999998 | 163623.04 | 88766348.04 |  |  | SoM | 23051.31 |  | SoM
 |  |  |  |  |  |  |  |  |  |  | Töötukassa | 4806.027 |  | Töötukassa
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 1440529.5618
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
[NAME] | 47306.56000000002 | 72589.65999999999 | 91956.70999999999 | 50813.22000000001 | 1275691.17 | 203143.82 | 17114.41 | 1758615.55 |  |  | [NAME] | 31774.43370000001 |  | [NAME]
Haigla | 10393.73 | 11843.72 | 9910.839999999998 | 840.8299999999999 | 104995.02 | 13344.84 | 187.2 | 151516.18 |  |  | Haigla | 2299.2518 |  | Haigla
HTM | 245822.19 | 65167.22000000002 | 8301.75 | 31736.93000000001 | 3190944.310000001 | 1838019.51 |  | 5379991.910000001 |  |  | JuM | 182055.9775 |  | HTM
JuM | 392288.74 | 1657597.439999998 | 307457.4900000001 | 125332.5700000002 | 16424970.59000003 | 6656425.060000005 | 1581.3 | 25565653.19000003 |  |  | KaM | 2147.6708 |  | JuM
KaM | 7848.599999999997 | 10751.76 |  | 1360.44 | 157236.64 | 45510 |  | 222707.44 |  |  | KeM | 22068.0546 |  | KaM
KeM | 103960.86 | 213399.7200000001 | 13803.82999999999 | 11560.65 | 896274.8399999999 | 515772.9000000003 | 68.74 | 1754841.54 |  |  | KOV | 5385.0824 |  | KeM
KOV | 8014.750000000002 | 4245.29 | 4560.209999999999 | 1080.89 | 9505.209999999997 | 13287.33 | 9.959999999999999 | 40703.64 |  |  | KuM | 79807.31530000002 |  | KOV
KuM | 252093.7399999999 | 262714.4800000002 | 121239.8500000001 | 49448.05000000001 | 13780331.43000001 | 2281470.52 | 2505.46 | 16749803.53000001 |  |  | MKM | 4267.17 |  | KuM
MeM | 244073.66 | 372734.4499999997 | 133017.98 | 20636.96 | 1842920.25 | 1587971.340000001 |  | 4201354.640000001 |  |  | Muu | 1036.2 |  | MeM
MKM | 13631.5 | 23436.55 | 934.64 | 2415.7 | 267336.09 | 42328.04 | 17500 | 367582.52 |  |  | PõI | 12272.3548 |  | MKM
Muu | 349.3200000000001 | 220.56 | 864 | 18.36 | 124548.37 |  | 27.6 | 126028.21 |  |  | Ram | 55142.7873 |  | Muu
PõI | 16990.87 | 164049.6299999999 | 64119.23999999999 | 16785.61 | 994130.3300000001 | 235331.8399999999 | 1583.4 | 1492990.92 |  |  | SiM | 242466.3183000001 |  | PõI
Ram | 243033.7100000001 | 190429.5100000002 | 182886.4699999999 | 175255.9000000001 | 7742470.680000002 | 846466.6299999994 | 132495.6 | 9513038.500000002 |  |  | SoM | 21298.1719 |  | Ram
SiM | 717543.370000001 | 1429473.649999999 | 601609.61 | 111560.7900000001 | 13904174.85000004 | 5149701.209999989 | 18074.32999999998 | 21932137.81000003 |  |  | Töötukassa | 4550.2297 |  | SiM
SoM | 102242.01 | 186257.9300000001 | 59190.45999999998 | 14594.72000000001 | 1518831.479999999 | 560994.6399999998 | 2495.27 | 2444606.509999999 |  |  | Grand Total | 666571.0180999996 |  | SoM
Töötukassa | 15275.23999999999 | 30614.23 | 8218.519999999993 | 4774.019999999998 | 501282.8599999999 | 88223.99000000003 | 16132.32 | 664521.1799999998 |  |  |  |  |  | Töötukassa
Grand Total | 2420868.850000002 | 4695525.799999997 | 1608071.6 | 618215.6400000002 | 62735644.12000009 | 20077991.66999999 | 209775.59 | 92366093.27000007
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Keskmine |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lehelt teenused_kulukohad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Haldamine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tehnohooldus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heakord
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maamaks ja kindlustus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kommunikatsioon ja tugiteenused
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soojus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vesi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vasakul päringust [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]