{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Коммунальные платежи"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Коммунальные платежи","index":0,"n_rows":5,"n_cols":139,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,121,0,130],[0,64,0,70],[0,79,0,86],[0,111,0,120],[0,87,0,94],[0,103,0,110],[0,95,0,102],[0,0,1,0],[0,15,0,19],[0,20,0,23],[0,8,0,14],[0,48,0,52],[0,62,0,63],[0,53,0,61],[0,71,0,78],[0,24,0,47],[0,1,0,7]]}
["Месяц","Всего",null,null,null,null,null,null,"На кого начислено на текущий месяц",null,null,null,null,null,null,"Тарифы",null,null,null,null,"Показания счетчиков",null,null,null,"Начисления за расчетный период по услугам / взносам",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Начислено",null,null,null,null,"Расход",null,null,null,null,null,null,null,null,"ЖКУ ",null,"Сумма общ. раздел. на проживающих",null,null,null,null,null,null,"Сумма Вова",null,null,null,null,null,null,null,"Сумма Аня",null,null,null,null,null,null,null,"Сумма Вика",null,null,null,null,null,null,null,"Сумма Олег",null,null,null,null,null,null,null,"Сумма Алекс.В",null,null,null,null,null,null,null,"Сумма Нат.М.",null,null,null,null,null,null,null,null,null,"Сумма Миша",null,null,null,null,null,null,null,null,null,null,"Вова","Аня","Вика","Олег","Алекс.В","Нат.М","Миша"]
[null,"Вова         ","Аня     ","Вика   ","Олег        ","Алекс.В.       ","Нат.М.       ","Миша       ","Вова ","Аня","Вика","Олег","Алекс.В","Нат.М","Миша","Хол.вода","Гор.вода","Водоотв.","Газ","Эл-во","Хол.вода","Гор.вода","Газ","Эл-во","Взнос на капитальный ремонт","Электроснабжение","Обращение с ТКО","Водоотведение","Горячее водоснабжение","Отопление","Холодное водоснабжение","Домофон","Очистка мусоропроводов","Сод. и тек. рем. внутр. систем газосн.","Содержание и текущий ремонт лифтов","Содержание общего имущества в МКД","Текущий ремонт общего имущества в МКД","Уборка и сан. очистка земельного участка","Уборка лестничных клеток","Управление многоквартирным домом","Горячее водоснабжение СОИ","Отведение сточных вод ГВС СОИ","Отведение сточных вод ХВС СОИ","Холодное водоснабжение СОИ","Электроэнергия день СОИ","Электроэнергия ночь СОИ","Перерасчёт (-)","Перерасчёт (+)","Газ","Хоз.расходы","Доп. расходы","Ростелеком","Дом.ру","Хол.вода","Гор.вода","Водоотв.","Газ","Эл-во","Хол.вода","Гор.вода","Водоотв.","Эл-во","ЖКУ ","ЖКУ    минус вода минус перерасчёт","Вода\nвсего /5","Ком.услуги +отопление /5","Газ /5","Твёрдые отходы+домофон /5","Кап.рем. /5","Эл-во /5","Хоз.расх. /5","Вода\n","Ком.услуги","Газ","Твёрдые отходы+домофон","Кап.рем. ","Эл-во","Хоз.расходы ","Доп.расходы ","Вода\n","Ком.услуги","Газ","Твёрдые отходы+домофон","Кап.рем.","Эл-во ","Хоз.расходы ","Доп.расходы","Вода\n","Ком.услуги","Газ","Твёрдые отходы+домофон","Кап.рем.","Эл-во","Хоз.расходы ","Доп.расходы ","Вода\n","Ком.услуги","Газ","Твёрдые отходы+домофон","Кап.ремонт","Эл-во","Хоз.расходы ","Доп.расходы","Вода\n","Ком.услуги","Газ","Твёрдые отходы+домофон","Кап.рем.","Эл-во","Хоз.расходы ","Доп.расходы ","Вода\n","Ком.услуги","Газ","Твёрдые отходы+домофон","Кап.рем.","Эл-во ","Хоз.расходы ","Доп.расходы","Ростелеком","Dom.ru TV","Вода\n","Ком.услуги","Газ","Твёрдые отходы+домофон","Кап.рем.","Эл-во","Хоз.расходы ","Доп.расходы ","Ростелеком","Dom.ru TV"]
["2023-04-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.54,126.68,36.54,7.5599299999999996,5.7,206,333,1582,10830,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69.2,216.08,216.08,600,440,{"$f":"IF(U3<>0,U3-#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(V3<>0,V3-#REF!,0)","v":{"$error":"#REF!"}},{"$f":"SUM(BB3+BC3)","v":{"$error":"#REF!"}},{"$f":"IF(W3<>0,W3-#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(X3<>0,X3-#REF!,0)","v":{"$error":"#REF!"}},{"$f":"SUM(BB3*P3)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(T3*BF3)","v":{"$error":"#REF!"}}]
["2023-05-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.54,126.68,36.54,7.5599299999999996,5.7,209,335,1595,10950,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98.28,1224,1224,600,440,{"$f":"IF(U4<>0,U4-U3,0)","v":3},{"$f":"IF(V4<>0,V4-V3,0)","v":2},{"$f":"SUM(BB4+BC4)","v":5},{"$f":"IF(W4<>0,W4-W3,0)","v":13},{"$f":"IF(X4<>0,X4-X3,0)","v":120},109.62,253.36,182.7,{"$f":"SUM(T4*BF4)","v":684}]
["2023-06-01",{"$f":"I5","v":855.35200000000009},{"$f":"J5","v":370.37399999999997},{"$f":"K5","v":370.37399999999997},{"$f":"L5","v":484.97800000000007},{"$f":"M5","v":484.97800000000007},{"$f":"N5","v":1375.3520000000001},{"$f":"O5","v":1375.3520000000001},{"$f":"IF(EC5,SUM(BT5+BU5+BV5+BW5+BX5+BY5+BZ5),SUM(BU5+BX5))","v":855.35200000000009},{"$f":"IF(ED5,SUM(CB5+CC5+CD5+CE5+CF5+CG5+CH5),SUM(CC5+CF5))","v":370.37399999999997},{"$f":"IF(EE5,SUM(CJ5+CK5+CL5+CM5+CN5+CO5+CP5),0)","v":370.37399999999997},{"$f":"IF(EF5,SUM(CR5+CS5+CT5+CU5+CV5+CW5+CX5),SUM(CS5+CV5))","v":484.97800000000007},{"$f":"IF(EG5,SUM(CZ5+DA5+DB5+DC5+DD5+DE5),SUM(DA5+DD5))","v":484.97800000000007},{"$f":"IF(EH5,SUM(DH5+DI5+DJ5+DK5+DL5+DM5+DN5+DP5+DQ5),SUM(DI5+DL5))","v":1375.3520000000001},{"$f":"IF(EI5,SUM(DR5+DS5+DT5+DU5+DV5+DW5+DX5+DZ5+EA5),SUM(DS5+DV5))","v":1375.3520000000001},36.54,126.68,36.54,7.5599299999999996,5.7,212,336,1607,11060,731.75,627,521.70000000000005,146.16,126.68,0,109.62,50,101.73,58.38,286.69,347.38,369.92,134.66999999999999,128.88999999999999,228.31,29.48,8.5,13.76,13.76,39.53,13.14,81,null,90.72,179.99,4350,600,440,{"$f":"IF(U5<>0,U5-U4,0)","v":3},{"$f":"IF(V5<>0,V5-V4,0)","v":1},{"$f":"SUM(BB5+BC5)","v":4},{"$f":"IF(W5<>0,W5-W4,0)","v":12},{"$f":"IF(X5<>0,X5-X4,0)","v":110},109.62,126.68,146.16,{"$f":"SUM(T5*BF5)","v":627},{"$f":"(Y5+Z5+AA5+AB5+AC5+AD5+AE5+AF5+AG5+AH5+AI5+AJ5+AK5+AL5+AM5+AN5+AO5+AP5+AQ5+AR5+AS5+AT5-AU5+AV5)","v":4006.0500000000006},{"$f":"(BK5-Y5-Z5-AA5-AB5-AC5-AD5-AE5-AF5)","v":1693.1400000000003},{"$f":"SUM(BG5+BH5+BI5)/5","v":76.492000000000004},{"$f":"(BL5/5)","v":338.62800000000004},{"$f":"SUM(AW5/5)","v":18.143999999999998},{"$f":"(AA5+AF5)/5","v":114.34},{"$f":"SUM(Y5/5)","v":146.35},{"$f":"SUM(Z5/5)","v":125.4},{"$f":"(AX5/5)","v":35.998000000000005},{"$f":"(BM5)","v":76.492000000000004},338.62800000000004,18.143999999999998,114.34,146.35,125.4,{"$f":"(BS5)","v":35.998000000000005},{"$f":"(AY5/4)","v":1087.5},{"$f":"SUM(BM5)","v":76.492000000000004},null,{"$f":"(BO5)","v":18.143999999999998},{"$f":"(BP5)","v":114.34},null,{"$f":"(BR5)","v":125.4},{"$f":"(AX5/5)","v":35.998000000000005},{"$f":"(AY5/4)","v":1087.5},{"$f":"SUM(BM5)","v":76.492000000000004},null,{"$f":"(BO5)","v":18.143999999999998},{"$f":"(BP5)","v":114.34},null,{"$f":"(BR5)","v":125.4},{"$f":"(AX5/5)","v":35.998000000000005},null,null,{"$f":"(BN5)","v":338.62800000000004},null,null,{"$f":"(BQ5)","v":146.35},null,null,null,null,{"$f":"(BN5)","v":338.62800000000004},null,null,{"$f":"(BQ5)","v":146.35},null,null,null,{"$f":"(BM5)","v":76.492000000000004},338.62800000000004,18.143999999999998,114.34,146.35,125.4,{"$f":"(AX5/5)","v":35.998000000000005},{"$f":"(AY5/4)","v":1087.5},{"$f":"(AZ5/2)","v":300},{"$f":"SUM(BA5/2)","v":220},{"$f":"(BM5)","v":76.492000000000004},338.62800000000004,18.143999999999998,114.34,146.35,125.4,{"$f":"(AX5/5)","v":35.998000000000005},{"$f":"(AY5/4)","v":1087.5},{"$f":"SUM(AZ5/2)","v":300},{"$f":"SUM(BA5/2)","v":220},null,true,true,true,true,true,true,true]