Spreadsheet: 858751d1707318329-index-and-match-functions-with-sum-book-dj
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 | 0.3814110311884933 | 0.4347457725160854 | 0.3228658992460068 | 0.0227552284617109 | 3.926338124428129 | 0.5076303517518177 | 0 | 5.595746407592244 |  | Haigla | 108331.68 | 14006.04 |  |  |  |  |  |  |  |  | 194301.52 |  |  | Haigla | 3.926338124428129 | 0.5076303517518177 | 0.3814110311884933 | 0.4347457725160854 | 0.3442311827989724 | 0.0227552284617109 | 0.1797860214063259 | 0.8199464422875883 | 0.2624922739359531 | 0.1628645747571739 | 7.04220100353225
HTM | 248062.9000000003 | 81908.19 |  | 51384.45000000003 | 3602487.619999999 | 1849634.26 |  | 5833477.42 |  |  | HTM | 606160.0121 |  | HTM | 0.03410305516808497 | 0.0112605291733991 | 0 | 0.007064203204637627 | 0.4952608150884432 | 0.254283003260705 | 0 | 0.80197160589527 |  | HTM | 3602487.619999999 | 1849634.26 |  |  |  |  |  |  |  |  | 16685646.11 |  |  | HTM | 0.4952608150884432 | 0.254283003260705 | 0.2475553998469819 | 0.3023581282303889 | 0.4596179657273476 | 0.02426377613128813 | 0.2402633717601738 | 0.2213667565573374 | 0.02036667533362463 | 0.02856420277546052 | 2.293900094711752
JuM | 403610.8000000003 | 1751928.449999999 | 322756.88 | 135073.54 | 17637166.4 | 6535941.029999993 | 1766.88 | 26788243.97999999 |  |  | JuM | 185339.7663 |  | JuM | 0.1814733772723731 | 0.7877102707882283 | 0.1451194592699056 | 0.06073239735887882 | 7.930105319587136 | 2.938720401850423 | 0.0007944328566901836 | 12.04465565898363 |  | JuM | 17637166.4 | 6535941.029999993 |  |  |  |  |  |  |  |  | 33701833.13 |  |  | JuM | 7.930105319587136 | 2.938720401850423 | 0.1821203871885967 | 0.7890683531452506 | 0.6004460423594836 | 0.06073239735887882 | 1.147835167345125 | 0.874944158345652 | 0.4260576215046192 | 0.2031461277035899 | 15.15317597638876
KaM | 10088.04 | 11074.32 |  | 1401.24 | 157265.68 | 45510 |  | 225339.28 |  |  | KaM | 2147.6708 |  | KaM | 0.3914333612022847 | 0.4297027272522401 | 0 | 0.05437053015760143 | 6.102179781618919 | 1.765866537832521 | 0 | 8.743552938063567 |  | KaM | 157265.68 | 45510 |  |  |  |  |  |  |  |  | 370978.4 |  |  | KaM | 6.102179781618919 | 1.765866537832521 | 1.020556005759045 | 0.6518022532441503 | 1.843178200308911 | 0.4287617854033619 | 1.447380032979605 | 0.6418453424053631 | 0.1273856775442493 | 0.3656465103186826 | 14.39460212741481
KeM | 109002.63 | 229444.5999999998 | 11961.33999999999 | 11567.43000000002 | 1046718.489999999 | 528760.51 | 3370.22 | 1940825.219999999 |  |  | KeM | 23991.6198 |  | KeM | 0.3786135565552769 | 0.7969609177173321 | 0.04154693770752955 | 0.04017871690347483 | 3.6357086999742 | 1.836615293200559 | 0.01170624030423601 | 6.741330362362608 |  | KeM | 1046718.489999999 | 528760.51 |  |  |  |  |  |  |  |  | 2941804.26 |  |  | KeM | 3.6357086999742 | 1.836615293200559 | 0.4003051584981631 | 0.8468358675251534 | 1.707450400382441 | 0.04017871690347483 | 1.125702720025043 | 0.4227318782369169 | 0.03601934788913252 | 0.1666179704965148 | 10.2181660531316
KOV | 15458.41 | 4589.769999999999 | 5817.820000000001 | 1672.48 | 43372.56 | 11777.64 |  | 82688.68 |  |  | KOV | 8839.882400000002 |  | KOV | 0.1457260147865013 | 0.04326763819090321 | 0.05484443247042894 | 0.01576642392135593 | 0.4088719551291768 | 0.1110274951169033 | 0 | 0.7795039596152694 |  | KOV | 43372.56 | 11777.64 |  |  |  |  |  |  |  |  | 259963.9 |  |  | KOV | 0.4088719551291768 | 0.1110274951169033 | 0.2167676838476191 | 0.1615196826600318 | 0.3280684669138433 | 0.01581223901047974 | 0.6751573603136012 | 0.478027192609108 | 0.04590002615117741 | 0.009520582913335284 | 2.450672684665276
KuM | 283769.4799999997 | 308133.0199999996 | 81356.87999999999 | 50858.13999999998 | 9701344.170000015 | 2419018.970000003 |  | 12844480.66000002 |  |  | KuM | 89328.9056 |  | KuM | 0.2647234566217124 | 0.2874517659675284 | 0.07589637368175704 | 0.04744464633106769 | 9.050209918837306 | 2.25665939611228 | 0 | 11.98238555755165 |  | KuM | 9701344.170000015 | 2419018.970000003 |  |  |  |  |  |  |  |  | 17850307.53000002 |  |  | KuM | 9.050209918837306 | 2.25665939611228 | 0.3290454973027974 | 0.8264181622303443 | 1.25002679797001 | 0.05981806744534884 | 1.524387103502889 | 0.6141825216763879 | 0.06381915194984768 | 0.6776650151489901 | 16.6522316321762
MKM | 18655.25 | 28278.16999999999 | 2104.130000000001 | 3045.510000000001 | 641282.15 | 47045.24999999999 | 30000 | 770410.4600000001 |  |  | MeM | 74004.0099 |  | MeM |  |  |  |  |  |  |  |  |  | MeM |  |  |  |  |  |  |  |  |  |  | 1374306.920000001 |  |  | MeM
Muu | 359.76 | 227.1600000000001 | 889.9199999999997 | 18.96 | 124603.56 |  | 28.44000000000001 | 126127.8 |  |  | MKM | 4680.7697 |  | MKM | 0.3321257541610447 | 0.5034458684576313 | 0.03746054130086057 | 0.05422024928934232 | 11.41696400202443 | 0.837562570104656 | 0.534100192966127 | 13.71587917830409 |  | MKM | 641282.15 | 47045.24999999999 |  |  |  |  |  |  |  |  | 844822.6100000001 |  |  | MKM |  |  |  |  |  |  | 12.39842900908655 | 11.24017666011925 | 0.8286473696836665 |  | 24.46725303888947
PõI | 17375.64 | 189437.3199999998 | 78813.33999999998 | 17236.59999999999 | 1008790.62 | 238117.4999999998 | 1699.82 | 1551470.84 |  |  | Muu | 1036.2 |  | Muu | 0.02893263848677862 | 0.01826867400115808 | 0.07156919513607408 | 0.001524802161744837 | 10.02087434858135 | 0 | 0.002287203242617256 | 10.14345686160972 |  | Muu | 124603.56 | 0 |  |  |  |  |  |  |  |  | 127970.88 |  |  | Muu | 51.57322830212957 | 3.783475680370584 | 1.500293540500547 | 2.343961107894228 | 2.020728784661906 | 0.2449261725535611 | 2.151048703596476 | 1.614757447082288 | 0.05969487872354115 | 2.650255742134723 | 67.94237035964743
Ram | 302775.8200000002 | 200627.3300000001 | 175802.33 | 150318.8299999999 | 8150758.090000003 | 921122.7200000007 | 69297.19999999998 | 9970702.320000004 |  |  | PõI | 12272.3548 |  | PõI | 0.1179863215819021 | 1.286341830121577 | 0.5351685508092817 | 0.1170421941625525 | 6.850020747444493 | 1.616896294425906 | 0.01154233796000313 | 10.53499827650572 |  | PõI | 1008790.62 | 238117.4999999998 |  |  |  |  |  |  |  |  | 2513199.549999999 |  |  | PõI | 0.8460992343539478 | 0 | 0.003108341250585965 | 0.001542491258482847 | 0.006042850064928044 | 0.0001287446480931272 | 0.0112142292365928 | 0 | 0.0006354390384258882 | 0.0001931169721396908 | 0.8689644468231963
SiM | 814351.8999999999 | 1829322.170000005 | 314350.9899999996 | 145799.81 | 14547147.06999998 | 5840402.909999994 | 9577.460000000003 | 23500952.30999998 |  |  | Ram | 60555.52580000001 |  | Ram | 0.4166641772159023 | 0.2760927916287149 | 0.2419299308052027 | 0.2068608768758582 | 11.21664508498634 | 1.267600696263242 | 0.09536316612524011 | 13.7211567239005 |  | Ram | 8150758.090000003 | 921122.7200000007 |  |  |  |  |  |  |  |  | 11720199.11 |  |  | Ram | 1.388244654627373 | 0.3276847940440141 | 0.0663614087552023 | 0.4998134978900084 | 0.5004533101310025 | 0.02477031033667726 | 0.3900199393529167 | 0.1818065159408898 | 0.009768403882529466 | 0.0696103553057856 | 3.458533190266399
Töötukassa | 15289.44 | 31232.54 | 6513.549999999998 | 4913.229999999999 | 508448.0600000002 | 88960.00000000006 | 23009.46000000001 | 678366.2800000003 |  |  | SiM | 309154.5182 |  | SiM | 0.2195104853341694 | 0.4930981279337068 | 0.0847340546269697 | 0.03930068445193004 | 3.921217981517863 | 1.574294450987582 | 0.002581627049520723 | 6.334737411901742 |  | SiM | 14547147.06999998 | 5840402.909999994 |  |  |  |  |  |  |  |  | 33221001.83999999 |  |  | SiM | 2.19705616721384 | 0.248290813000535 | 0.08201045973478087 | 0.09565168308770983 | 0.2345218379969753 | 0.04051879700675407 | 0.1513898705815517 | 0.07221267851207923 | 0.003867761145123495 | 0.03368738841007606 | 3.159207456689426
Grand Total | 2300031.64 | 4763176.910000004 | 1103096.949999999 | 623921.6799999999 | 58535830.58 | 18756827.56999999 | 159169.8 | 86242055.13 |  |  | SoM | 23051.31 |  | SoM |  |  |  |  |  |  |  |  |  | SoM |  |  |  |  |  |  |  |  |  |  | 658973.9499999996 |  |  | SoM
 |  |  |  |  |  |  |  |  |  |  | Töötukassa | 4806.027 |  | Töötukassa | 0.2651087894429224 | 0.5415516114800577 | 0.1129406541688869 | 0.08519216253536095 | 8.816153481174092 | 1.542507633297386 | 0.3989688364214352 | 11.76242316852014 |  | Töötukassa | 508448.0600000002 | 88960.00000000006 |  |  |  |  |  |  |  |  | 818868.7400000002 |  |  | Töötukassa | 252.2379203931505 | 101.2687283071858 | 15.48704747878722 | 34.70153413620032 | 64.86347160208071 | 2.67401067451348 | 53.57161868490018 | 35.07926696347449 | 4.640856678499721 | 11.50577129508427 | 576.0302262138766
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 1440529.5618 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [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]