Spreadsheet: 858471d1707149869-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.04999999992 | 84978.79000000005 | 93821.56999999995 | 50003.61999999997 | 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 | 2695.0518 |  | Haigla
HTM | 248062.9000000003 | 81908.19 |  | 51384.45000000003 | 3602487.619999999 | 1849634.259999999 |  | 5833477.42 |  |  | HTM | 608487.6921 |  | HTM
JuM | 403610.8000000004 | 1751928.449999999 | 322756.88 | 135073.54 | 17637166.39999999 | 6535941.029999991 | 1766.88 | 26788243.97999998 |  |  | 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 | 23922.5198 |  | KeM
KOV | 15458.41 | 4589.769999999999 | 5817.820000000001 | 1672.48 | 43372.56000000001 | 11777.64 |  | 82688.68000000001 |  |  | KOV | 8839.882400000002 |  | KOV
KuM | 283769.4799999996 | 308133.0199999997 | 81356.88 | 50858.13999999998 | 9701344.170000017 | 2419018.970000003 |  | 12844480.66000002 |  |  | KuM | 89246.2458 |  | KuM
MeM | 260907.1500000002 | 445737.0400000006 | 133183.9399999999 | 20835.74999999999 | 2694838.789999997 | 1662343.160000002 |  | 5217845.83 |  |  | MeM | 74017.5099 |  | MeM
MKM | 18655.25 | 28278.16999999999 | 2104.130000000001 | 3045.510000000001 | 641282.1499999999 | 47045.24999999998 | 30000 | 770410.46 |  |  | MKM | 4680.7697 |  | MKM
Muu | 359.76 | 227.1600000000001 | 889.9199999999997 | 18.96 | 124603.56 |  | 28.44000000000001 | 126127.8 |  |  | Muu | 1036.2 |  | Muu
PõI | 17375.64 | 189437.3199999998 | 78813.33999999998 | 17236.59999999999 | 1008790.62 | 238117.4999999998 | 1699.82 | 1551470.84 |  |  | PõI | 12272.3548 |  | PõI
Ram | 302775.8200000002 | 200627.33 | 175802.33 | 150318.8299999999 | 8150758.090000003 | 921122.7200000006 | 69297.19999999998 | 9970702.320000004 |  |  | Ram | 60555.52580000001 |  | Ram
SiM | 814362.8100000004 | 1828836.540000007 | 314350.9899999996 | 145747.74 | 14526958.52999998 | 5839070.519999992 | 9577.460000000003 | 23478904.58999997 |  |  | SiM | 309154.5182 |  | SiM
SoM | 85729.87999999996 | 200460.9200000004 | 73880.10999999997 | 12178.58000000001 | 1827192.969999999 | 549385.7999999995 | 4453.240000000002 | 2753281.499999999 |  |  | SoM | 23034.1903 |  | SoM
Töötukassa | 15289.44 | 31232.54 | 6513.549999999998 | 4913.229999999999 | 508448.0600000003 | 88960.00000000006 | 23009.46000000001 | 678366.2800000003 |  |  | Töötukassa | 4806.027 |  | Töötukassa
Grand Total | 2646679.580000001 | 5408889.240000007 | 1310160.999999999 | 656883.94 | 63037673.79999999 | 20967224.13999999 | 163623.04 | 94191134.73999998 |  |  | Grand Total | 1443097.6623
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Kalender | 2022 |  |  |  | Tegelik 5340 = plaan 5300 + 5340 |  |  |  |  |  |  |  |  | Kuude arv | 12
Väärtus | Tegelik
FinSummaHaldus | Column Labels
 | 1 Tulud |  |  |  |  |  |  | Grand Total |  |  | Võtta välja füüsiline isik [NAME]
 | 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.56 | 72589.66000000003 | 91956.70999999996 | 50813.22000000001 | 1275691.17 | 203143.82 | 17114.41 | 1758615.55 |  |  | [NAME] | 32789.96110000001 |  | [NAME]
Haigla | 10393.73 | 11843.72 | 9910.839999999998 | 840.8299999999999 | 104995.02 | 13344.84 | 187.2 | 151516.18 |  |  | Füüsiline isik | 390.5279 |  | Füüsiline isik
HTM | 245822.1900000001 | 65167.22 | 8301.75 | 31736.93000000003 | 3190944.310000001 | 1838019.51 |  | 5379991.910000001 |  |  | Haigla | 2672.0993 |  | Haigla
JuM | 392288.7399999999 | 1657597.439999998 | 307457.4899999999 | 125332.5700000002 | 16424970.59000002 | 6656425.060000004 | 1581.3 | 25565653.19000002 |  |  | HTM | 611787.2029 |  | HTM
KaM | 7848.599999999997 | 10751.76 |  | 1360.44 | 157236.64 | 45510 |  | 222707.44 |  |  | JuM | 183269.662 |  | JuM
KeM | 103960.8599999999 | 213399.7200000002 | 13803.82999999999 | 11560.64999999999 | 896274.8400000001 | 515772.9000000001 | 68.73999999999998 | 1754841.54 |  |  | KaM | 2147.9929 |  | KaM
KOV | 8014.750000000002 | 4245.289999999999 | 4560.209999999998 | 1080.89 | 9505.21 | 13287.33 | 9.959999999999999 | 40703.64 |  |  | KeM | 38615.25840000001 |  | KeM
KuM | 252093.7399999998 | 262714.4800000003 | 121239.8500000001 | 49448.05000000002 | 13780331.43 | 2281470.52 | 2505.46 | 16749803.53 |  |  | KOV | 6315.6643 |  | KOV
MeM | 244073.6600000001 | 372734.45 | 133017.98 | 20636.96 | 1842920.250000002 | 1587971.339999999 |  | 4201354.640000002 |  |  | KuM | 98766.3711 |  | KuM
MKM | 13631.5 | 23436.55000000001 | 934.6399999999999 | 2415.7 | 267336.0899999999 | 42328.04 | 17500 | 367582.5199999999 |  |  | MeM | 60651.2095 |  | MeM
Muu | 349.3200000000001 | 220.56 | 864 | 18.36 | 124548.37 |  | 27.6 | 126028.21 |  |  | MKM | 4180.987499999999 |  | MKM
PõI | 16990.87 | 164049.6299999999 | 64119.23999999999 | 16785.61 | 994130.33 | 235331.8399999999 | 1583.4 | 1492990.92 |  |  | Muu | 1036.2 |  | Muu
Ram | 243033.7099999999 | 190429.5100000002 | 182886.4699999999 | 175255.9000000001 | 7742470.680000011 | 846466.6299999995 | 132495.6 | 9513038.500000011 |  |  | PõI | 12518.2944 |  | PõI
RROSA | 34.38 | 74.50000000000001 | 52.21999999999999 | 1.08 | 104.68 | 57.20000000000002 |  | 324.0600000000001 |  |  | Ram | 57116.50380000001 |  | Ram
SiM | 717543.3700000005 | 1429473.649999999 | 601609.6100000002 | 111560.7899999999 | 13904174.85000002 | 5149701.209999996 | 18074.32999999997 | 21932137.81000001 |  |  | RROSA | 34.2914 |  | RROSA
SoM | 102242.01 | 186257.9300000001 | 59190.45999999995 | 14594.72000000001 | 1518831.48 | 560994.6399999994 | 2495.27 | 2444606.509999999 |  |  | SiM | 257947.5523000001 |  | SiM
Töötukassa | 15275.24 | 30614.23 | 8218.519999999999 | 4774.02 | 501282.8600000001 | 88223.98999999998 | 16132.32 | 664521.18 |  |  | SoM | 31258.5131 |  | SoM
Grand Total | 2420903.230000001 | 4695600.299999998 | 1608123.82 | 618216.7200000002 | 62735748.80000006 | 20078048.87 | 209775.59 | 92366417.33000004 |  |  | Töötukassa | 5093.3452 |  | Töötukassa
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 1406591.637099999 |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lehelt teenused_kulukohad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Haldamine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tehnohooldus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heakord
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maamaks ja kindlustus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kommunikatsioon ja tugiteenused
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soojus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vesi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vasakul päringust [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]