Spreadsheet: 858741d1707309350-index-and-match-functions-with-sum-book1
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.04999999993 | 84978.79000000005 | 93821.56999999995 | 50003.61999999999 | 1258114.43 | 216530.7400000001 | 20420.32 | 1774577.52 |  |  | [NAME] | 32861.73760000001 |  | [NAME]
Haigla | 10523.51999999999 | 11995.08 | 8908.199999999997 | 627.8400000000001 | 108331.68 | 14006.04 |  | 154392.36 |  |  | Haigla | 2299.2518 |  | Haigla
HTM | 248062.9000000003 | 81908.19 |  | 51384.45000000003 | 3602487.619999999 | 1849634.26 |  | 5833477.42 |  |  | HTM | 606160.0121 |  | HTM
JuM | 403610.8000000003 | 1751928.449999999 | 322756.88 | 135073.54 | 17637166.4 | 6535941.029999993 | 1766.88 | 26788243.97999999 |  |  | JuM | 185339.7663 |  | JuM
KaM | 10088.04 | 11074.32 |  | 1401.24 | 157265.68 | 45510 |  | 225339.28 |  |  | KaM | 2147.6708 |  | KaM
KeM | 109002.63 | 229444.5999999998 | 11961.33999999999 | 11567.43000000002 | 1046718.489999999 | 528760.51 | 3370.22 | 1940825.219999999 |  |  | KeM | 23991.6198 |  | KeM
KOV | 15458.41 | 4589.769999999999 | 5817.820000000001 | 1672.48 | 43372.56 | 11777.64 |  | 82688.68 |  |  | KOV | 8839.882400000002 |  | KOV
KuM | 283769.4799999997 | 308133.0199999996 | 81356.87999999999 | 50858.13999999998 | 9701344.170000015 | 2419018.970000003 |  | 12844480.66000002 |  |  | KuM | 89328.9056 |  | KuM
MKM | 18655.25 | 28278.16999999999 | 2104.130000000001 | 3045.510000000001 | 641282.15 | 47045.24999999999 | 30000 | 770410.4600000001 |  |  | MeM | 74004.0099 |  | MeM
Muu | 359.76 | 227.1600000000001 | 889.9199999999997 | 18.96 | 124603.56 |  | 28.44000000000001 | 126127.8 |  |  | MKM | 4680.7697 |  | MKM
PõI | 17375.64 | 189437.3199999998 | 78813.33999999998 | 17236.59999999999 | 1008790.62 | 238117.4999999998 | 1699.82 | 1551470.84 |  |  | Muu | 1036.2 |  | Muu
Ram | 302775.8200000002 | 200627.3300000001 | 175802.33 | 150318.8299999999 | 8150758.090000003 | 921122.7200000007 | 69297.19999999998 | 9970702.320000004 |  |  | PõI | 12272.3548 |  | PõI
SiM | 814351.8999999999 | 1829322.170000005 | 314350.9899999996 | 145799.81 | 14547147.06999998 | 5840402.909999994 | 9577.460000000003 | 23500952.30999998 |  |  | Ram | 60555.52580000001 |  | Ram
Töötukassa | 15289.44 | 31232.54 | 6513.549999999998 | 4913.229999999999 | 508448.0600000002 | 88960.00000000006 | 23009.46000000001 | 678366.2800000003 |  |  | SiM | 309154.5182 |  | SiM
Grand Total | 2300031.64 | 4763176.910000004 | 1103096.949999999 | 623921.6799999999 | 58535830.58 | 18756827.56999999 | 159169.8 | 86242055.13 |  |  | SoM | 23051.31 |  | SoM
 |  |  |  |  |  |  |  |  |  |  | Töötukassa | 4806.027 |  | Töötukassa
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 1440529.5618
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
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.56000000003 | 72589.65999999997 | 91956.70999999999 | 50813.22000000001 | 1275691.170000001 | 203143.8200000001 | 17114.41 | 1758615.550000001 |  |  | [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.22 | 8301.750000000002 | 31736.93000000001 | 3190944.310000001 | 1838019.51 |  | 5379991.910000001 |  |  | HTM | 602701.6229 |  | HTM
JuM | 392288.74 | 1657597.439999999 | 307457.49 | 125332.5700000002 | 16424970.59000001 | 6656425.059999994 | 1581.3 | 25565653.19000001 |  |  | JuM | 182055.9775 |  | JuM
KaM | 7848.599999999999 | 10751.76 |  | 1360.44 | 157236.64 | 45510 |  | 222707.44 |  |  | KaM | 2147.6708 |  | KaM
KeM | 103960.86 | 213399.7199999999 | 13803.82999999999 | 11560.65 | 896274.8399999999 | 515772.9000000001 | 68.74000000000001 | 1754841.54 |  |  | KeM | 22068.0546 |  | KeM
KOV | 8014.750000000001 | 4245.289999999999 | 4560.209999999999 | 1080.89 | 9505.21 | 13287.33 | 9.959999999999999 | 40703.64000000001 |  |  | KOV | 5385.0824 |  | KOV
KuM | 252093.7399999999 | 262714.4800000001 | 121239.8500000001 | 49448.05000000007 | 13780331.43000001 | 2281470.52 | 2505.46 | 16749803.53000001 |  |  | KuM | 79807.31530000002 |  | KuM
MKM | 13631.5 | 23436.55 | 934.6400000000001 | 2415.7 | 267336.09 | 42328.04000000001 | 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.63 | 64119.24 | 16785.61 | 994130.3299999998 | 235331.84 | 1583.4 | 1492990.92 |  |  | Muu | 1036.2 |  | Muu
Ram | 243033.71 | 190429.5100000001 | 182886.4699999999 | 175255.9000000001 | 7742470.680000007 | 846466.6299999994 | 132495.6 | 9513038.500000007 |  |  | PõI | 12272.3548 |  | PõI
SiM | 717543.3699999999 | 1429473.649999999 | 601609.6100000001 | 111560.7900000001 | 13904174.85000004 | 5149701.209999992 | 18074.32999999998 | 21932137.81000003 |  |  | Ram | 55142.7873 |  | Ram
Töötukassa | 15275.23999999999 | 30614.23 | 8218.519999999997 | 4774.019999999999 | 501282.8599999998 | 88223.99000000002 | 16132.32 | 664521.1799999997 |  |  | SiM | 242466.3183000001 |  | SiM
Grand Total | 2074553.18 | 4136533.419999999 | 1415863.16 | 582983.9600000005 | 59373892.39000008 | 17929025.68999998 | 207280.32 | 85720132.12000003 |  |  | SoM | 21298.1719 |  | SoM
 |  |  |  |  |  |  |  |  |  |  | Töötukassa | 4550.2297 |  | Töötukassa
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 1341347.6088
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lehelt teenused_kulukohad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Haldamine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tehnohooldus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heakord
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maamaks ja kindlustus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kommunikatsioon ja tugiteenused
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soojus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vesi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vasakul päringust [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]