{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Pea","Klassid","Korterid","Tariifid","Vesi","Arve","Korterite_kulud","Skeem"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":48,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pea","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Korteriühistu \"Kuldne Kodu\""]

{"sheet":"Klassid","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Rakenduse andmemudel (klassiskeem)"]

{"sheet":"Korterid","index":2,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"tiitel","v":"Korteriühistu \"Kuldne Kodu\""}]
[]
[null,"Üldandmed korterite kohta"]
[null,null,"Kokku:",{"$f":"SUM(Y_pind)","v":1065.1000000000001},{"$f":"SUM(K_pind)","v":1043.798},{"$f":"SUM(Elanike)","v":49}]
[]
[null,"Korter","Omanik","Üldine\npindala","Köetav\npindala","Elanike"]
[null,1,"A. Kask",69.599999999999994,68.207999999999998,2]
[null,2,"H. Tamm",48.6,47.628,3]
[null,3,"R. Paju",61.7,60.466000000000001,3]
[null,4,"V. Saar",84.2,82.516000000000005,5]
[null,5,"P. Kuusk",72.5,71.05,3]
[null,6,"T. Sirel",48.6,47.628,2]
[null,7,"M. Lepp",61.7,60.466000000000001,4]
[null,8,"P. Kukk",84.2,82.516000000000005,4]
[null,9,"K. Ilves",72.5,71.05,2]
[null,10,"O. Vaher",48.6,47.628,3]
[null,11,"U. Tamm",61.7,60.466000000000001,1]
[null,12,"K. Pärn",84.2,82.516000000000005,3]
[null,13,"S. Mägi",72.5,71.05,4]
[null,14,"A. Palk",48.6,47.628,4]
[null,15,"L. Mets",61.7,60.466000000000001,4]
[null,16,"T. Oks",84.2,82.516000000000005,2]

{"sheet":"Tariifid","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"tiitel","v":"Korteriühistu \"Kuldne Kodu\""}]
[]
[null,"Kulud ja tariifid","jaanuar",2015]
[]
[null,"Liik","Tariif","Summa"]
[null,"Haldus",1.37,{"$f":"t_haldus*Sum_Y_pind","v":1459.1870000000004}]
[null,"Hooldus",2.5,{"$f":"t_hooldus*Sum_Y_pind","v":2662.7500000000005}]
[null,"Üldelekter",{"$f":"El_sum / Sum_Y_pind","v":0.66284855882076787},706]
[null,"Küte",{"$f":"K_sum/Sum_K_Pind","v":11.473484333175577},11976]
[null,"Vee sojendamine",46.3,{"$f":"S_summa_S","v":1898.2999999999997}]
[null,"Vesi ja kanalisatsioon",21.15,{"$f":"S_Summ_V","v":1797.75}]
[null,"Remondifond",4,{"$f":"t_remont*Sum_Y_pind","v":4260.4000000000005}]
[]
[null,null,"Kokku",{"$f":"SUM(D7:D13)","v":24760.387000000002}]

{"sheet":"Vesi","index":4,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"tiitel","v":"Korteriühistu \"Kuldne Kodu\""}]
[]
[null,"Vesi",null,{"$f":"kuu","v":"jaanuar"},{"$f":"aasta","v":2015},null,"Kokku:",{"$f":"SUM(kulu_S)","v":41},{"$f":"SUM(Summa_S)","v":1898.2999999999997},{"$f":"SUM(kulu_V)","v":85},{"$f":"SUM(Summa_V)","v":1797.75}]
[]
[null,"Korter","algnäit_K","lõppnäit_K","kulu_K","algnäit_S","lõppnäit_S","kulu_S","Summa_S","kulu_V","Summa_V"]
[null,1,3,5,{"$f":"lõppnäit_K-algnäit_K","v":2},3,7,{"$f":"lõppnäit_S-algnäit_S","v":4},{"$f":"kulu_S*t_vesi_soe","v":185.2},{"$f":"kulu_K+kulu_S","v":6},{"$f":"kulu_V*t_vesi","v":126.89999999999999}]
[null,2,75,78,{"$f":"lõppnäit_K-algnäit_K","v":3},76,77,{"$f":"lõppnäit_S-algnäit_S","v":1},{"$f":"kulu_S*t_vesi_soe","v":46.3},{"$f":"kulu_K+kulu_S","v":4},{"$f":"kulu_V*t_vesi","v":84.6}]
[null,3,124,126,2,137,140,3,138.89999999999998,5,105.75]
[null,4,36,39,3,55,57,2,92.6,5,105.75]
[null,5,152,155,3,168,171,3,138.89999999999998,6,126.89999999999999]
[null,6,33,34,1,36,39,3,138.89999999999998,4,84.6]
[null,7,58,59,1,30,31,1,46.3,2,42.3]
[null,8,6,9,3,5,8,3,138.89999999999998,6,126.89999999999999]
[null,9,90,93,3,111,114,3,138.89999999999998,6,126.89999999999999]
[null,10,86,88,2,79,81,2,92.6,4,84.6]
[null,11,30,31,1,30,33,3,138.89999999999998,4,84.6]
[null,12,55,59,4,67,68,1,46.3,5,105.75]
[null,13,104,107,3,125,128,3,138.89999999999998,6,126.89999999999999]
[null,14,21,25,4,22,25,3,138.89999999999998,7,148.04999999999998]
[null,15,101,105,4,111,114,3,138.89999999999998,7,148.04999999999998]
[null,16,62,67,5,76,79,3,138.89999999999998,8,169.2]

{"sheet":"Arve","index":5,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,{"$f":"tiitel","v":"Korteriühistu \"Kuldne Kodu\""},null,null,1200]
[null,null,"Pank","Konto"]
[null,null,"Hansapank",20301871287]
[null,"KOMMUNAALTEENUSTE ARVE",null,{"$f":"baas+Korter","v":1201}]
[null,"Kuu",{"$f":"kuu","v":"jaanuar"},{"$f":"aasta","v":2015}]
[null,"Korter",1,"Üldpind",{"$f":"INDEX(Y_pind, Korter)","v":69.599999999999994}]
[null,"Omanik",{"$f":"INDEX(Omanik,Korter)","v":"A. Kask"},"Köetav pind",{"$f":"INDEX(K_pind, Korter)","v":68.207999999999998}]
[]
[null,"Kulu liik","Tariif","Kogus","Summa"]
[null,{"$f":"Tariifid!B7","v":"Haldus"},{"$f":"Tariifid!C7","v":1.37},{"$f":"Üldpind","v":69.599999999999994},{"$f":"Tariif*Kogus","v":95.352000000000004}]
[null,{"$f":"Tariifid!B8","v":"Hooldus"},{"$f":"Tariifid!C8","v":2.5},{"$f":"Üldpind","v":69.599999999999994},{"$f":"Tariif*Kogus","v":174}]
[null,{"$f":"Tariifid!B9","v":"Üldelekter"},{"$f":"Tariifid!C9","v":0.66284855882076787},{"$f":"Üldpind","v":69.599999999999994},46.134259693925443]
[null,{"$f":"Tariifid!B10","v":"Küte"},{"$f":"Tariifid!C10","v":11.473484333175577},{"$f":"Köetav_pind","v":68.207999999999998},782.58341939723971]
[null,{"$f":"Tariifid!B11","v":"Vee sojendamine"},{"$f":"Tariifid!C11","v":46.3},{"$f":"INDEX(kulu_S, Korter)","v":4},185.2]
[null,{"$f":"Tariifid!B12","v":"Vesi ja kanalisatsioon"},{"$f":"Tariifid!C12","v":21.15},{"$f":"INDEX(kulu_V, Korter)","v":6},126.89999999999999]
[null,{"$f":"Tariifid!B13","v":"Remondifond"},{"$f":"Tariifid!C13","v":4},{"$f":"Üldpind","v":69.599999999999994},278.39999999999998]
[]
[null,null,null,"Kokku",{"$f":"SUM(Summa)","v":1688.5696790911652}]

{"sheet":"Korterite_kulud","index":6,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"tiitel","v":"Korteriühistu \"Kuldne Kodu\""}]
[null,null,null,null,null,{"$f":"kuu","v":"jaanuar"},{"$f":"aasta","v":2015}]
[null,"Kulude jaotamine"]
[]
[null,"Kokku:",{"$f":"SUM(Pind)","v":1065.1000000000001},{"$f":"SUM(D9:D24)","v":1459.1870000000004},{"$f":"SUM(E9:E24)","v":2662.75},{"$f":"SUM(F9:F24)","v":706},{"$f":"SUM(G9:G24)","v":11976},{"$f":"SUM(H9:H24)","v":1898.2999999999997},{"$f":"SUM(D6:H6)","v":18702.236999999997},{"$f":"SUM(J9:J24)","v":4260.4000000000005},{"$f":"SUM(K9:K24)","v":24760.386999999999}]
[]
[null,"Korter","Pind","Haldus","Hooldus","Üld-\nelekter","Küte","Soe \nvesi","Külm \nvesi","Remont","Kokku"]
[null,1,{"$f":"Korterid!D8","v":69.599999999999994},{"$f":"t_haldus*Pind","v":95.352000000000004},{"$f":"t_hooldus*Pind","v":174},{"$f":"t_elek*Pind","v":46.134259693925443},{"$f":"t_küte*INDEX(K_pind, Korter)","v":782.58341939723971},{"$f":"INDEX(Summa_S, Korter)","v":185.2},{"$f":"INDEX(Summa_V, Korter)","v":126.89999999999999},{"$f":"t_remont*Pind","v":278.39999999999998},{"$f":"SUM(D9:J9)","v":1688.5696790911652}]
[null,2,{"$f":"Korterid!D9","v":48.6},{"$f":"t_haldus*Pind","v":66.582000000000008},{"$f":"t_hooldus*INDEX(Y_pind, Korter)","v":121.5},{"$f":"t_elek*Pind","v":32.214439958689319},{"$f":"t_küte*INDEX(K_pind, Korter)","v":546.45911182048633},{"$f":"INDEX(Summa_S, Korter)","v":46.3},{"$f":"INDEX(Summa_V, Korter)","v":84.6},{"$f":"t_remont*Pind","v":194.4},{"$f":"SUM(D10:J10)","v":1092.0555517791756}]
[null,3,{"$f":"Korterid!D10","v":61.7},84.529000000000011,154.25,40.897756079241383,693.75570368979447,138.89999999999998,105.75,246.8,1464.8824597690357]
[null,4,{"$f":"Korterid!D11","v":84.2},115.35400000000001,210.5,55.811848652708655,946.74603323631595,92.6,105.75,336.8,1863.5618818890246]
[null,5,{"$f":"Korterid!D12","v":72.5},99.325000000000003,181.25,48.056520514505671,815.19106187212469,138.89999999999998,126.89999999999999,290,1699.6225823866303]
[null,6,{"$f":"Korterid!D13","v":48.6},66.582000000000008,121.5,32.214439958689319,546.45911182048633,138.89999999999998,84.6,194.4,1184.6555517791758]
[null,7,{"$f":"Korterid!D14","v":61.7},84.529000000000011,154.25,40.897756079241383,693.75570368979447,46.3,42.3,246.8,1308.8324597690357]
[null,8,{"$f":"Korterid!D15","v":84.2},115.35400000000001,210.5,55.811848652708655,946.74603323631595,138.89999999999998,126.89999999999999,336.8,1931.0118818890248]
[null,9,{"$f":"Korterid!D16","v":72.5},99.325000000000003,181.25,48.056520514505671,815.19106187212469,138.89999999999998,126.89999999999999,290,1699.6225823866303]
[null,10,{"$f":"Korterid!D17","v":48.6},66.582000000000008,121.5,{"$f":"t_elek*Pind","v":32.214439958689319},546.45911182048633,92.6,84.6,194.4,1138.3555517791758]
[null,11,{"$f":"Korterid!D18","v":61.7},84.529000000000011,154.25,40.897756079241383,693.75570368979447,138.89999999999998,84.6,246.8,1443.7324597690356]
[null,12,{"$f":"Korterid!D19","v":84.2},115.35400000000001,210.5,55.811848652708655,946.74603323631595,46.3,105.75,336.8,1817.2618818890246]
[null,13,{"$f":"Korterid!D20","v":72.5},99.325000000000003,181.25,48.056520514505671,815.19106187212469,138.89999999999998,126.89999999999999,290,1699.6225823866303]
[null,14,{"$f":"Korterid!D21","v":48.6},66.582000000000008,121.5,32.214439958689319,546.45911182048633,138.89999999999998,148.04999999999998,194.4,1248.1055517791758]
[null,15,{"$f":"Korterid!D22","v":61.7},84.529000000000011,154.25,40.897756079241383,693.75570368979447,138.89999999999998,148.04999999999998,246.8,1507.1824597690356]
[null,16,{"$f":"Korterid!D23","v":84.2},115.35400000000001,210.5,55.811848652708655,946.74603323631595,138.89999999999998,169.2,336.8,1973.3118818890248]

{"sheet":"Skeem","index":7,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Rakenduse Klassid ja objektide omidused"]