Spreadsheet: 858490d1707159081-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 | 2299.2518 |  | Haigla
HTM | 248062.9000000003 | 81908.19 |  | 51384.45000000003 | 3602487.619999999 | 1849634.259999999 |  | 5833477.42 |  |  | HTM | 606160.0121 |  | 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 | 23991.6198 |  | 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 | 89328.9056 |  | KuM
MeM | 262483.8500000004 | 463379.0400000002 | 133183.9399999999 | 20835.74999999999 | 2703817.589999995 | 1673402.760000004 |  | 5257102.929999999 |  |  | MeM | 74004.0099 |  | 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 | 814351.9000000005 | 1829322.170000007 | 314350.9899999996 | 145799.8100000001 | 14547147.06999998 | 5840402.909999992 | 9577.460000000003 | 23500952.30999998 |  |  | SiM | 309154.5182 |  | SiM
SoM | 85605.98999999996 | 200171.2000000004 | 73725.89999999998 | 12149.77000000001 | 1823770.689999998 | 548855.3199999994 | 4453.240000000002 | 2748732.109999998 |  |  | SoM | 23051.31 |  | 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 | 2648121.480000001 | 5426727.150000006 | 1310006.789999999 | 656907.2 | 63063418.85999998 | 20979085.64999999 | 163623.04 | 94247890.16999999 |  |  | 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 |  |  | 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.66000000002 | 91956.70999999995 | 50813.22000000001 | 1275691.17 | 203143.8200000001 | 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.1900000001 | 65167.22 | 8301.750000000002 | 31736.93000000002 | 3190944.310000001 | 1838019.51 |  | 5379991.910000001 |  |  | HTM | 602701.6229 |  | HTM
JuM | 392288.7399999999 | 1657597.439999998 | 307457.4899999999 | 125332.5700000002 | 16424970.59000002 | 6656425.060000002 | 1581.3 | 25565653.19000002 |  |  | JuM | 182055.9775 |  | JuM
KaM | 7848.599999999998 | 10751.76 |  | 1360.44 | 157236.64 | 45510 |  | 222707.44 |  |  | KaM | 2147.6708 |  | KaM
KeM | 103960.8599999999 | 213399.7200000001 | 13803.82999999999 | 11560.65 | 896274.8400000001 | 515772.9000000001 | 68.74 | 1754841.54 |  |  | KeM | 22068.0546 |  | KeM
KOV | 8014.75 | 4245.289999999999 | 4560.209999999999 | 1080.89 | 9505.21 | 13287.33 | 9.959999999999999 | 40703.64 |  |  | KOV | 5385.0824 |  | KOV
KuM | 252093.7399999999 | 262714.4800000003 | 121239.8500000001 | 49448.05000000002 | 13780331.43000001 | 2281470.52 | 2505.46 | 16749803.53000001 |  |  | KuM | 79807.31530000002 |  | KuM
MeM | 244073.6600000001 | 372734.45 | 133017.98 | 20636.95999999999 | 1842920.250000002 | 1587971.339999999 |  | 4201354.640000001 |  |  | MeM | 72074.9678 |  | MeM
MKM | 13631.5 | 23436.55 | 934.6399999999999 | 2415.7 | 267336.09 | 42328.04000000001 | 17500 | 367582.52 |  |  | MKM | 4267.17 |  | MKM
Muu | 349.3200000000001 | 220.56 | 864 | 18.36 | 124548.37 |  | 27.6 | 126028.21 |  |  | Muu | 1036.2 |  | Muu
PõI | 16990.87 | 164049.63 | 64119.24 | 16785.61 | 994130.3299999998 | 235331.8399999999 | 1583.4 | 1492990.92 |  |  | PõI | 12272.3548 |  | PõI
Ram | 243033.7099999998 | 190429.5100000002 | 182886.4699999999 | 175255.9 | 7742470.680000013 | 846466.6299999994 | 132495.6 | 9513038.500000013 |  |  | Ram | 55142.7873 |  | Ram
RROSA | 34.38 | 74.50000000000001 | 52.21999999999999 | 1.08 | 104.68 | 57.20000000000002 |  | 324.0600000000001 |  |  | SiM | 242466.3183000001 |  | SiM
SiM | 717543.3700000002 | 1429473.649999999 | 601609.6100000002 | 111560.79 | 13904174.85000001 | 5149701.209999999 | 18074.32999999998 | 21932137.81 |  |  | SoM | 21298.1719 |  | SoM
SoM | 102242.01 | 186257.9300000001 | 59190.45999999996 | 14594.72000000001 | 1518831.479999999 | 560994.6399999994 | 2495.27 | 2444606.509999999 |  |  | Töötukassa | 4550.2297 |  | Töötukassa
Töötukassa | 15275.24 | 30614.23 | 8218.519999999999 | 4774.02 | 501282.8600000001 | 88223.98999999998 | 16132.32 | 664521.18 |  |  | Grand Total | 1341347.6088
Grand Total | 2420903.23 | 4695600.299999998 | 1608123.82 | 618216.7200000002 | 62735748.80000006 | 20078048.87 | 209775.59 | 92366417.33000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lehelt teenused_kulukohad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Haldamine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tehnohooldus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heakord
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maamaks ja kindlustus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kommunikatsioon ja tugiteenused
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soojus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vesi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vasakul päringust [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]