{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Исходный","Сводная","Собираемость"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"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":154,"n_cols":29,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Операция","Дата для сводной","Дата операции","Дата оплаты","Дата создания","Дата п/д","Дата начисления 20-е","Агент","Сумма","Год"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B2,$N$43:$O$49,2,),\"\")","v":""},{"$f":"IF(S2=\"оплата\",V2,IF(S2=\"пени\",W2,IF(S2=\"начисление\",U2,\"\")))","v":""},{"$f":"IFERROR(--(SUBSTITUTE(LEFT(C2,SEARCH(\" \",C2)+3),\"ая\",\"ай\")&\" \"&RIGHT(C2,4)),\"\")","v":""},{"$f":"IF(LEFT(B2,6)=\"Оплата\",F2,\"\")","v":""},{"$f":"IFERROR(--SUBSTITUTE(SUBSTITUTE(MID(H2,1,(FIND(\",\",H2,1))),\",\",),\"мая\",\"май\"),\"\")","v":""},{"$f":"IF(S2=\"начисление\",W2,\"\")","v":""},{"$f":"IF(S2=\"Начисление\",U2+19,\"\")","v":""},{"$f":"IF(S2=\"оплата\",IF(E2=\"\",\"Ручное\",E2),\"\")","v":""},{"$f":"IFERROR(IF(OR(S2=\"оплата\",S2=\"Начисление\",S2=\"перерасчет\",S2=\"Пени\",S2=\"Пени перерасчет\",S2=\"Начисление пени\"),SUBSTITUTE(LEFT(D2,LEN(D2)-5),\".\",\",\",1),\"\")+0,\"\")","v":""},{"$f":"IF(T2=\"\",\"\",IFERROR(YEAR(T2),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Номер лицевого счёта:",null,null,{"$f":"CONCATENATE(K6,\", кв.\",L8)","v":", кв.19"},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B3,$N$43:$O$49,2,),\"\")","v":""},{"$f":"IF(S3=\"оплата\",V3,IF(S3=\"пени\",W3,IF(S3=\"начисление\",U3,\"\")))","v":""},{"$f":"IFERROR(--(SUBSTITUTE(LEFT(C3,SEARCH(\" \",C3)+3),\"ая\",\"ай\")&\" \"&RIGHT(C3,4)),\"\")","v":""},{"$f":"IF(LEFT(B3,6)=\"Оплата\",F3,\"\")","v":""},{"$f":"IFERROR(--SUBSTITUTE(SUBSTITUTE(MID(H3,1,(FIND(\",\",H3,1))),\",\",),\"мая\",\"май\"),\"\")","v":""},{"$f":"IF(S3=\"начисление\",W3,\"\")","v":""},{"$f":"IF(S3=\"Начисление\",U3+19,\"\")","v":""},{"$f":"IF(S3=\"оплата\",IF(E3=\"\",\"Ручное\",E3),\"\")","v":""},{"$f":"IFERROR(IF(OR(S3=\"оплата\",S3=\"Начисление\",S3=\"перерасчет\",S3=\"Пени\",S3=\"Пени перерасчет\",S3=\"Начисление пени\"),SUBSTITUTE(LEFT(D3,LEN(D3)-5),\".\",\",\",1),\"\")+0,\"\")","v":""},""]
["2016-09-01",null,null,"349.64","178.61","0.00","0.00","0.00","855.15","-326.90","0000031795281",null,null,null,null,null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,"Адрес дома:",null,null,"Начисление",{"$f":"SUMIF(S:S,N5,AA:AA)","v":4339.1099999999997},null,null,null,"","","","","","","","","",""]
[34824840,"Оплата (За капитальный ремонт)","1 Сентября 2016","855.15 руб.","Сбербанк","2016-08-31","Банковская пачка","1 сен 2016, 04:56:44","Kira",null,null,null,null,"Оплата",{"$f":"SUMIF(S:S,N6,AA:AA)","v":4792.1499999999996},null,null,null,"Оплата","2016-08-31","2016-09-01","2016-08-31","2016-09-01","","","Сбербанк",855.15,2016,{"$f":"MAX(X:X)","v":"2016-09-21"}]
[35651494,"Начисление пени (Пени по минимальному взносу)","1 Сентября 2016","0.00 руб.",null,null,null,"21 сен 2016, 22:10:56","Kira",null,"Номер квартиры:",null,null,"Перерасчет",{"$f":"SUMIF(S:S,N7,AA:AA)","v":126.14000000000003},null,null,null,"Пени","2016-09-21","2016-09-01","","2016-09-21","","","",0,2016]
[35651495,"Начисление (По минимальному взносу)","1 Сентября 2016","178.61 руб.",null,null,null,"21 сен 2016, 22:10:56","Kira",null,"Номер квартиры:",19,null,"Пени перерасчет",{"$f":"SUMIF(S:S,N8,AA:AA)","v":0},null,null,null,"Начисление","2016-09-01","2016-09-01","","2016-09-21","2016-09-21","2016-09-20","",178.61,2016]
["[-] авг 2016",null,null,"171.03","178.61","0.00","0.00","0.00","0.00","349.64",null,null,null,"Пени",{"$f":"SUMIF(S:S,N9,AA:AA)","v":0},null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"Долг",{"$f":"O5-O6+O7","v":-326.89999999999992},null,null,null,"","","","","","","","","",""]
[34532004,"Начисление (По минимальному взносу)","1 Августа 2016","178.61 руб.",null,null,null,"22 авг 2016, 20:21:47","Kira",null,null,null,null,"Ежемесячно",{"$f":"VLOOKUP(\"начисление\",S:AA,9,)","v":178.61},null,null,null,"Начисление","2016-08-01","2016-08-01","","2016-08-22","2016-08-22","2016-08-20","",178.61,2016]
["[-] июл 2016",null,null,"-7.58","178.61","0.00","0.00","0.00","0.00","171.03",null,null,null,"колич месяцев",{"$f":"COUNTIF($S$1:$S$154,\"начисление\")","v":25},null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,null,null,null,null,null,"","","","","","","","","",""]
[33063397,"Начисление (По минимальному взносу)","1 Июля 2016","178.61 руб.",null,null,null,"22 июл 2016, 15:44:56","admin",null,null,null,null,"Собственник",{"$f":"O6-O19","v":4792.1499999999996},null,null,null,"Начисление","2016-07-01","2016-07-01","","2016-07-22","2016-07-22","2016-07-20","",178.61,2016]
["[-] июн 2016",null,null,"-186.19","178.61","0.00","0.00","0.00","0.00","-7.58",null,null,null,"Льгота",{"$f":"O19","v":0},null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"Долг+пени",{"$f":"O10+O9","v":-326.89999999999992},null,null,null,"","","","","","","","","",""]
[29540885,"Начисление пени (Пени по минимальному взносу)","1 Июня 2016","0.00 руб.",null,null,null,"22 июн 2016, 00:31:44","Kira",null,null,null,null,"Нач+пен+перер",{"$f":"O5+O7+O9","v":4465.25},null,null,null,"Пени","2016-06-22","2016-06-01","","2016-06-22","","","",0,2016]
[29540886,"Начисление (По минимальному взносу)","1 Июня 2016","178.61 руб.",null,null,null,"22 июн 2016, 00:31:44","Kira",null,null,null,null,"РКЦ Железногорск",{"$f":"SUMIF(Z:Z,N18,AA:AA)","v":0},null,null,null,"Начисление","2016-06-01","2016-06-01","","2016-06-22","2016-06-22","2016-06-20","",178.61,2016]
["[-] май 2016",null,null,"-195.20","178.61","0.00","0.00","0.00","169.60","-186.19",null,null,null,"ВСТКБ",{"$f":"SUMIF(Z:Z,N19,AA:AA)","v":0},null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"Сбербанк",{"$f":"SUMIF(Z:Z,N20,AA:AA)","v":4792.1499999999996},null,null,null,"","","","","","","","","",""]
[26626888,"Оплата (По минимальному взносу)","18 Мая 2016","169.60 руб.","Сбербанк","2016-05-17","Банковская пачка","18 мая 2016, 06:32:47","Kira",null,null,null,null,"Город",{"$f":"SUMIF(Z:Z,N21,AA:AA)","v":0},null,null,null,"Оплата","2016-05-17","2016-05-18","2016-05-17","2016-05-18","","","Сбербанк",169.6,2016]
[27608709,"Начисление пени (Пени по минимальному взносу)","1 Мая 2016","0.00 руб.",null,null,null,"23 мая 2016, 04:55:42","Kira",null,null,null,null,"ИПК",{"$f":"SUMIF(Z:Z,N22,AA:AA)","v":0},null,null,null,"Пени","2016-05-23","2016-05-01","","2016-05-23","","","",0,2016]
[27608710,"Начисление (По минимальному взносу)","1 Мая 2016","178.61 руб.",null,null,null,"23 мая 2016, 04:55:42","Kira",null,null,null,null,"ЖЭУ-6",{"$f":"SUMIF(Z:Z,N23,AA:AA)","v":0},null,null,null,"Начисление","2016-05-01","2016-05-01","","2016-05-23","2016-05-23","2016-05-20","",178.61,2016]
["[-] апр 2016",null,null,"-373.81","178.61","0.00","0.00","0.00","0.00","-195.20",null,null,null,"ВТБ24",{"$f":"SUMIF(Z:Z,N24,AA:AA)","v":0},null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"Почта",{"$f":"SUMIF(Z:Z,N25,AA:AA)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(B25,$N$43:$O$49,2,),\"\")","v":""},{"$f":"IF(S25=\"оплата\",V25,IF(S25=\"пени\",W25,IF(S25=\"начисление\",U25,\"\")))","v":""},{"$f":"IFERROR(--(SUBSTITUTE(LEFT(C25,SEARCH(\" \",C25)+3),\"ая\",\"ай\")&\" \"&RIGHT(C25,4)),\"\")","v":""},{"$f":"IF(LEFT(B25,6)=\"Оплата\",F25,\"\")","v":""},{"$f":"IFERROR(--SUBSTITUTE(SUBSTITUTE(MID(H25,1,(FIND(\",\",H25,1))),\",\",),\"мая\",\"май\"),\"\")","v":""},{"$f":"IF(S25=\"начисление\",W25,\"\")","v":""},{"$f":"IF(S25=\"Начисление\",U25+19,\"\")","v":""},{"$f":"IF(S25=\"оплата\",IF(E25=\"\",\"Ручное\",E25),\"\")","v":""},{"$f":"IFERROR(IF(OR(S25=\"оплата\",S25=\"Начисление\",S25=\"перерасчет\",S25=\"Пени\",S25=\"Пени перерасчет\",S25=\"Начисление пени\"),SUBSTITUTE(LEFT(D25,LEN(D25)-5),\".\",\",\",1),\"\")+0,\"\")","v":""},""]
[25847062,"Начисление (По минимальному взносу)","1 Апреля 2016","178.61 руб.",null,null,null,"22 апр 2016, 06:03:54","Kira",null,null,null,null,"Жилком",{"$f":"SUMIF(Z:Z,N26,AA:AA)","v":0},null,null,null,"Начисление","2016-04-01","2016-04-01","","2016-04-22","2016-04-22","2016-04-20","",178.61,2016]
["[-] мар 2016",null,null,"340.58","178.61","0.00","0.00","0.00","893.00","-373.81",null,null,null,"Салвент",{"$f":"SUMIF(Z:Z,N27,AA:AA)","v":0},null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,{"$f":"SMALL(IF(S1:S154=N5,T1:T154),1)","v":"2014-09-01"},{"$f":"LARGE(IF(S1:S154=N5,T1:T154),1)","v":"2016-09-01"},null,null,null,"","","","","","","","","",""]
[23953960,"Начисление (По минимальному взносу)","1 Марта 2016","178.61 руб.",null,null,null,"22 мар 2016, 19:49:54","Kira",null,null,null,null,{"$f":"\"Период: \"&TEXT(N28,\"ММММ ГГГГ\")& \" - \"&TEXT(O28,\"ММММ ГГГГ\")","v":"Период: Сентябрь 2014 - Сентябрь 2016"},null,null,null,null,"Начисление","2016-03-01","2016-03-01","","2016-03-22","2016-03-22","2016-03-20","",178.61,2016]
[24102038,"Оплата (За капитальный ремонт)","23 Марта 2016","893.00 руб.","Сбербанк","2016-03-23","Банковская пачка","24 мар 2016, 04:23:16","Kira",null,null,null,null,null,null,null,null,null,"Оплата","2016-03-23","2016-03-23","2016-03-23","2016-03-24","","","Сбербанк",893,2016]
["[-] фев 2016",null,null,"161.97","178.61","0.00","0.00","0.00","0.00","340.58",null,null,null,{"$f":"CONCATENATE(\"Начислено всего: \",ROUND(O5+O7+O9+O8,2),\" руб.\",IF(O5-O17=0,\"\",\", в т.ч.: \"),IF(O7=\"\",\"\",IF(O7=0,\"\",\"перерасчет \"&O7&\" руб.\"&IF(O9<>0,\", \",\"\"))),IF(O9=0,\"\",\"пени \"&O9+O8&\" руб.\"))","v":"Начислено всего: 4465,25 руб., в т.ч.: перерасчет 126,14 руб."},null,null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,{"$f":"\"Оплачено всего: \"&O6&\" руб.\"&IF(O15=0,\"\",\", в т.ч.: оплата \"&O14&\" руб., льгота \"&O15&\" руб.\")","v":"Оплачено всего: 4792,15 руб."},null,null,null,null,"","","","","","","","","",""]
[22648352,"Начисление (По минимальному взносу)","1 Февраля 2016","178.61 руб.",null,null,null,"25 фев 2016, 13:29:08","admin",null,null,null,null,null,null,null,null,null,"Начисление","2016-02-01","2016-02-01","","2016-02-25","2016-02-25","2016-02-20","",178.61,2016]
["[-] янв 2016",null,null,"-16.64","178.61","0.00","0.00","0.00","0.00","161.97",null,null,null,null,"Начисление","Оплата","Пени",null,"","","","","","","","","",{"$f":"IF(T34=\"\",\"\",IFERROR(YEAR(T34),\"\"))","v":""}]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,{"$f":"YEAR(TODAY())","v":2016},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,O$34,$AB$2:$AB$154,$N35)","v":1607.4900000000002},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,P$34,$AB$2:$AB$154,$N35)","v":1917.75},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,Q$34,$AB$2:$AB$154,$N35)","v":0},null,"","","","","","","","","",""]
[21388484,"Начисление (По минимальному взносу)","1 Января 2016","178.61 руб.",null,null,null,"22 янв 2016, 23:28:38","Dyn",null,null,null,null,{"$f":"IF(N$35-COUNT(N$35:N35)<2014,\"\",N$35-COUNT(N$35:N35))","v":2015},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,O$34,$AB$2:$AB$154,$N36)","v":2053.2199999999998},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,P$34,$AB$2:$AB$154,$N36)","v":2874.4},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,Q$34,$AB$2:$AB$154,$N36)","v":0},null,"Начисление","2016-01-01","2016-01-01","","2016-01-22","2016-01-22","2016-01-20","",178.61,2016]
["[-] дек 2015",null,null,"-195.25","178.61","0.00","0.00","0.00","0.00","-16.64",null,null,null,{"$f":"IF(N$35-COUNT(N$35:N36)<2014,\"\",N$35-COUNT(N$35:N36))","v":2014},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,O$34,$AB$2:$AB$154,$N37)","v":678.4},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,P$34,$AB$2:$AB$154,$N37)","v":0},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,Q$34,$AB$2:$AB$154,$N37)","v":0},null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,{"$f":"IF(N$35-COUNT(N$35:N37)<2014,\"\",N$35-COUNT(N$35:N37))","v":""},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,O$34,$AB$2:$AB$154,$N38)","v":0},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,P$34,$AB$2:$AB$154,$N38)","v":0},{"$f":"SUMIFS($AA$2:$AA$154,$S$2:$S$154,Q$34,$AB$2:$AB$154,$N38)","v":0},null,"","","","","","","","","",""]
[17144574,"Начисление (По минимальному взносу)","1 Декабря 2015","178.61 руб.",null,null,null,"6 ноя 2015, 10:47:58","Avi",null,null,null,{"$f":"IF(M$35-COUNT(M$35:M38)<2014,\"\",M$35-COUNT(M$35:M38))","v":""},null,null,null,null,null,"Начисление","2015-12-01","2015-12-01","","2015-11-06","2015-11-06","2015-12-20","",178.61,2015]
["[-] ноя 2015",null,null,"2 374.40","178.61","126.14","0.00","0.00","2 874.40","-195.25",null,null,null,null,null,null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,null,null,null,null,null,"","","","","","","","","",""]
[17144559,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.09.2014 - 30.09.2014)","6 ноя 2015, 10:47:44",null,null,null,null,null,null,null,null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144560,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.10.2014 - 31.10.2014)","6 ноя 2015, 10:47:44",null,null,null,null,null,"Начисление (По минимальному взносу)","Начисление",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144561,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.11.2014 - 30.11.2014)","6 ноя 2015, 10:47:44",null,null,null,null,null,"Перерасчёт (По минимальному взносу)","Перерасчет",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144562,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.12.2014 - 31.12.2014)","6 ноя 2015, 10:47:44",null,null,null,null,null,"Начисление пени (Пени по минимальному взносу)","Пени",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144563,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.01.2015 - 31.01.2015)","6 ноя 2015, 10:47:44",null,null,null,null,null,"Перерасчёт (Пени по минимальному взносу)","Пени перерасчет",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144564,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.02.2015 - 28.02.2015)","6 ноя 2015, 10:47:44",null,null,null,null,null,"Пени перерасчет","Пени перерасчет",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144565,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.03.2015 - 31.03.2015)","6 ноя 2015, 10:47:44",null,null,null,null,null,"Оплата (За капитальный ремонт)","Оплата",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144566,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.04.2015 - 30.04.2015)","6 ноя 2015, 10:47:44",null,null,null,null,null,"Оплата (По минимальному взносу)","Оплата",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144567,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.05.2015 - 31.05.2015)","6 ноя 2015, 10:47:44",null,null,null,null,null,"января","январь",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144568,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.06.2015 - 30.06.2015)","6 ноя 2015, 10:47:44",null,null,null,null,null,"февраля","февраль",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144569,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.07.2015 - 31.07.2015)","6 ноя 2015, 10:47:44",null,null,null,null,null,"марта","март",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144570,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.08.2015 - 31.08.2015)","6 ноя 2015, 10:47:45",null,null,null,null,null,"апреля","апрель",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144571,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.09.2015 - 30.09.2015)","6 ноя 2015, 10:47:45",null,null,null,null,null,"мая","май",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144572,"Перерасчёт (По минимальному взносу)","6 Ноября 2015","9.01 руб.",null,null,"изменение площади на значение 33.7 (01.10.2015 - 31.10.2015)","6 ноя 2015, 10:47:45",null,null,null,null,null,"июня","июнь",null,null,null,"Перерасчет","","2015-11-06","","2015-11-06","","","",9.01,""]
[17144573,"Начисление (По минимальному взносу)","1 Ноября 2015","178.61 руб.",null,null,null,"6 ноя 2015, 10:47:54","Avi",null,null,null,null,"июля","июль",null,null,null,"Начисление","2015-11-01","2015-11-01","","2015-11-06","2015-11-06","2015-11-20","",178.61,2015]
[17235373,"Оплата (По минимальному взносу)","9 Ноября 2015","2 374.40 руб.","Сбербанк","2015-11-06","Банковская пачка","9 ноя 2015, 12:09:06",null,null,null,null,null,"августа","август",null,null,null,"Оплата","2015-11-06","2015-11-09","2015-11-06","2015-11-09","","","Сбербанк",2374.4,2015]
[17575423,"Оплата (За капитальный ремонт)","20 Ноября 2015","500.00 руб.","Сбербанк","2015-11-19","Банковская пачка","20 ноя 2015, 10:02:52",null,null,null,null,null,"сентября","сентябрь",null,null,null,"Оплата","2015-11-19","2015-11-20","2015-11-19","2015-11-20","","","Сбербанк",500,2015]
["[-] окт 2015",null,null,"2 204.80","169.60","0.00","0.00","0.00","0.00","2 374.40",null,null,null,"октября","октябрь",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"ноября","ноябрь",null,null,null,"","","","","","","","","",""]
[16968323,"Начисление (По минимальному взносу)","1 Октября 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:13:13","Kam",null,null,null,null,"декабря","декабрь",null,null,null,"Начисление","2015-10-01","2015-10-01","","2015-10-26","2015-10-26","2015-10-20","",169.6,2015]
["[-] сен 2015",null,null,"2 035.20","169.60","0.00","0.00","0.00","0.00","2 204.80",null,null,null,"янв","январь",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"фев","февраль",null,null,null,"","","","","","","","","",""]
[16968322,"Начисление (По минимальному взносу)","1 Сентября 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:13:08","Kam",null,null,null,null,"мар","март",null,null,null,"Начисление","2015-09-01","2015-09-01","","2015-10-26","2015-10-26","2015-09-20","",169.6,2015]
["[-] авг 2015",null,null,"1 865.60","169.60","0.00","0.00","0.00","0.00","2 035.20",null,null,null,"апр","апрель",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"мая","май",null,null,null,"","","","","","","","","",{"$f":"IF(T66=\"\",\"\",IFERROR(YEAR(T66),\"\"))","v":""}]
[16968321,"Начисление (По минимальному взносу)","1 Августа 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:13:00","Kam",null,null,null,null,"июн","июнь",null,null,null,"Начисление","2015-08-01","2015-08-01","","2015-10-26","2015-10-26","2015-08-20","",169.6,2015]
["[-] июл 2015",null,null,"1 696.00","169.60","0.00","0.00","0.00","0.00","1 865.60",null,null,null,"июл","июль",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"авг","август",null,null,null,"","","","","","","","","",""]
[16968320,"Начисление (По минимальному взносу)","1 Июля 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:12:56","Kam",null,null,null,null,"сен","сентябрь",null,null,null,"Начисление","2015-07-01","2015-07-01","","2015-10-26","2015-10-26","2015-07-20","",169.6,2015]
["[-] июн 2015",null,null,"1 526.40","169.60","0.00","0.00","0.00","0.00","1 696.00",null,null,null,"окт","октябрь",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"ноя","ноябрь",null,null,null,"","","","","","","","","",""]
[16968319,"Начисление (По минимальному взносу)","1 Июня 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:12:52","Kam",null,null,null,null,"дек","декабрь",null,null,null,"Начисление","2015-06-01","2015-06-01","","2015-10-26","2015-10-26","2015-06-20","",169.6,2015]
["[-] май 2015",null,null,"1 356.80","169.60","0.00","0.00","0.00","0.00","1 526.40",null,null,null,1,"января",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,2,"февраля",null,null,null,"","","","","","","","","",""]
[16968318,"Начисление (По минимальному взносу)","1 Мая 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:12:48","Kam",null,null,null,null,3,"марта",null,null,null,"Начисление","2015-05-01","2015-05-01","","2015-10-26","2015-10-26","2015-05-20","",169.6,2015]
["[-] апр 2015",null,null,"1 187.20","169.60","0.00","0.00","0.00","0.00","1 356.80",null,null,null,4,"апреля",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,5,"мая",null,null,null,"","","","","","","","","",""]
[16968317,"Начисление (По минимальному взносу)","1 Апреля 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:12:43","Kam",null,null,null,null,6,"июня",null,null,null,"Начисление","2015-04-01","2015-04-01","","2015-10-26","2015-10-26","2015-04-20","",169.6,2015]
["[-] мар 2015",null,null,"1 017.60","169.60","0.00","0.00","0.00","0.00","1 187.20",null,null,null,7,"июля",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,8,"августа",null,null,null,"","","","","","","","","",""]
[16968316,"Начисление (По минимальному взносу)","1 Марта 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:12:39","Kam",null,null,null,null,9,"сентября",null,null,null,"Начисление","2015-03-01","2015-03-01","","2015-10-26","2015-10-26","2015-03-20","",169.6,2015]
["[-] фев 2015",null,null,"848.00","169.60","0.00","0.00","0.00","0.00","1 017.60",null,null,null,10,"октября",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,11,"ноября",null,null,null,"","","","","","","","","",""]
[16968315,"Начисление (По минимальному взносу)","1 Февраля 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:12:34","Kam",null,null,null,null,12,"декабря",null,null,null,"Начисление","2015-02-01","2015-02-01","","2015-10-26","2015-10-26","2015-02-20","",169.6,2015]
["[-] янв 2015",null,null,"678.40","169.60","0.00","0.00","0.00","0.00","848.00",null,null,null,"январь","января",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"февраль","февраля",null,null,null,"","","","","","","","","",""]
[16968314,"Начисление (По минимальному взносу)","1 Января 2015","169.60 руб.",null,null,null,"26 окт 2015, 06:12:29","Kam",null,null,null,null,"март","марта",null,null,null,"Начисление","2015-01-01","2015-01-01","","2015-10-26","2015-10-26","2015-01-20","",169.6,2015]
["[-] дек 2014",null,null,"508.80","169.60","0.00","0.00","0.00","0.00","678.40",null,null,null,"апрель","апреля",null,null,null,{"$f":"IFERROR(VLOOKUP(B89,$N$43:$O$49,2,),\"\")","v":""},{"$f":"IF(S89=\"оплата\",V89,IF(S89=\"пени\",W89,IF(S89=\"начисление\",U89,\"\")))","v":""},{"$f":"IFERROR(--(SUBSTITUTE(LEFT(C89,SEARCH(\" \",C89)+3),\"ая\",\"ай\")&\" \"&RIGHT(C89,4)),\"\")","v":""},{"$f":"IF(LEFT(B89,6)=\"Оплата\",F89,\"\")","v":""},{"$f":"IFERROR(--SUBSTITUTE(SUBSTITUTE(MID(H89,1,(FIND(\",\",H89,1))),\",\",),\"мая\",\"май\"),\"\")","v":""},{"$f":"IF(S89=\"начисление\",W89,\"\")","v":""},{"$f":"IF(S89=\"Начисление\",U89+19,\"\")","v":""},{"$f":"IF(S89=\"оплата\",IF(E89=\"\",\"Ручное\",E89),\"\")","v":""},{"$f":"IFERROR(IF(OR(S89=\"оплата\",S89=\"Начисление\",S89=\"перерасчет\",S89=\"Пени\",S89=\"Пени перерасчет\",S89=\"Начисление пени\"),SUBSTITUTE(LEFT(D89,LEN(D89)-5),\".\",\",\",1),\"\")+0,\"\")","v":""},""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"май","мая",null,null,null,"","","","","","","","","",""]
[16968313,"Начисление (По минимальному взносу)","1 Декабря 2014","169.60 руб.",null,null,null,"26 окт 2015, 06:12:25","Kam",null,null,null,null,"июнь","июня",null,null,null,"Начисление","2014-12-01","2014-12-01","","2015-10-26","2015-10-26","2014-12-20","",169.6,2014]
["[-] ноя 2014",null,null,"339.20","169.60","0.00","0.00","0.00","0.00","508.80",null,null,null,"июль","июля",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"август","августа",null,null,null,"","","","","","","","","",""]
[16968312,"Начисление (По минимальному взносу)","1 Ноября 2014","169.60 руб.",null,null,null,"26 окт 2015, 06:12:19","Kam",null,null,null,null,"сентябрь","сентября",null,null,null,"Начисление","2014-11-01","2014-11-01","","2015-10-26","2015-10-26","2014-11-20","",169.6,2014]
["[-] окт 2014",null,null,"169.60","169.60","0.00","0.00","0.00","0.00","339.20",null,null,null,"октябрь","октября",null,null,null,"","","","","","","","","",""]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,"ноябрь","ноября",null,null,null,"","","","","","","","","",""]
[16968311,"Начисление (По минимальному взносу)","1 Октября 2014","169.60 руб.",null,null,null,"26 окт 2015, 06:12:05","Kam",null,null,null,null,"декабрь","декабря",null,null,null,"Начисление","2014-10-01","2014-10-01","","2015-10-26","2015-10-26","2014-10-20","",169.6,2014]
["[-] сен 2014",null,null,"0.00","169.60","0.00","0.00","0.00","0.00","169.60",null,null,null,null,null,null,null,null,"","","","","","","","","",{"$f":"IF(T98=\"\",\"\",IFERROR(YEAR(T98),\"\"))","v":""}]
["№","Операция","Дата","Сумма","Источник","Дата оплаты","Дополнительно","Дата создания","Пользователь",null,null,null,null,1,"январь",null,null,null,"","","","","","","","","",""]
[16968310,"Начисление (По минимальному взносу)","1 Сентября 2014","169.60 руб.",null,null,null,"26 окт 2015, 06:11:58","Kam",null,null,null,null,2,"февраль",null,null,null,"Начисление","2014-09-01","2014-09-01","","2015-10-26","2015-10-26","2014-09-20","",169.6,2014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,"март",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4,"апрель",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,"май",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,"июнь",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7,"июль",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8,"август",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9,"сентябрь",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,10,"октябрь",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11,"ноябрь",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,"декабрь",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,"день",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,"дня",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,"дня",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4,"дня",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,10,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,13,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,14,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,16,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,17,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,19,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20,"дней",null,null,null,"","","","","","","","","",{"$f":"IF(T130=\"\",\"\",IFERROR(YEAR(T130),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,"день",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,22,"дня",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,23,"дня",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,24,"дня",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,25,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,28,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,29,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,"дней",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,31,"день",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,"январе",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,"феврале",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,"марте",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4,"апреле",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,"мае",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,"июне",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7,"июле",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8,"августе",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9,"сентябре",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,10,"октябре",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11,"ноябре",null,null,null,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,"декабре",null,null,null,{"$f":"IFERROR(VLOOKUP(B153,$N$43:$O$49,2,),\"\")","v":""},{"$f":"IF(S153=\"оплата\",V153,IF(S153=\"пени\",W153,IF(S153=\"начисление\",U153,\"\")))","v":""},{"$f":"IFERROR(--(SUBSTITUTE(LEFT(C153,SEARCH(\" \",C153)+3),\"ая\",\"ай\")&\" \"&RIGHT(C153,4)),\"\")","v":""},{"$f":"IF(LEFT(B153,6)=\"Оплата\",F153,\"\")","v":""},{"$f":"IFERROR(--SUBSTITUTE(SUBSTITUTE(MID(H153,1,(FIND(\",\",H153,1))),\",\",),\"мая\",\"май\"),\"\")","v":""},{"$f":"IF(S153=\"начисление\",W153,\"\")","v":""},{"$f":"IF(S153=\"Начисление\",U153+19,\"\")","v":""},{"$f":"IF(S153=\"оплата\",IF(E153=\"\",\"Ручное\",E153),\"\")","v":""},{"$f":"IFERROR(IF(OR(S153=\"оплата\",S153=\"Начисление\",S153=\"перерасчет\",S153=\"Пени\",S153=\"Пени перерасчет\",S153=\"Начисление пени\"),SUBSTITUTE(LEFT(D153,LEN(D153)-5),\".\",\",\",1),\"\")+0,\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",""]

{"sheet":"Сводная","index":1,"n_rows":25,"n_cols":68,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,2,0,7],[1,2,1,7],[3,2,3,5],[6,2,6,7],[7,2,7,7]]}
[null,{"$f":"IF(C1=\"\",0,C1)","v":"Сведения об оплатах и начислениях"},"Сведения об оплатах и начислениях",null,null,null,null,null,1]
[null,"Дата формирования: 17.10.2016","Дата формирования: 17.10.2016",null,null,null,null,null,{"$f":"IFERROR(IF((B1+B2)<1,\"\",B1+B2),1)","v":1}]
[null,0,null,null,null,null,null,null,1]
[null,"Адрес: , кв.19","Адрес: , кв.19",null,null,null,"Лицевой счет: 0000031795281",null,1]
[null,"Период: Сентябрь 2014 - Сентябрь 2016 (25 мес.)","Период: Сентябрь 2014 - Сентябрь 2016 (25 мес.)",null,null,null,"Переплата: -326,9",null,1]
[null,"Ежемесячный платеж: 178,61","Ежемесячный платеж: 178,61",null,null,null,null,null,1,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,{"$f":"IFERROR(VLOOKUP(#REF!,$BB$4:$BF$7,5,FALSE),\"\")","v":""}]
[null,"Начислено всего: 4465,25 руб., в т.ч.: перерасчет 126,14 руб.","Начислено всего: 4465,25 руб., в т.ч.: перерасчет 126,14 руб.",null,null,null,null,null,1,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,{"$f":"IFERROR(VLOOKUP(#REF!,$BB$4:$BF$7,5,FALSE),\"\")","v":""}]
[null,"Оплачено всего: 4792,15 руб.","Оплачено всего: 4792,15 руб.",null,null,null,null,null,1,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,{"$f":"IFERROR(VLOOKUP(BN8,$BB$4:$BF$7,5,FALSE),\"\")","v":""}]
[null,0,null,null,null,null,null,null,1,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,"Начисление за весь период","Начисление за весь период",4339.1099999999997,null,null,"",0,1,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,"Оплата за весь период","Оплата за весь период",4792.1499999999996,null,null,"--------------------------------",0,1,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,"","",1,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,"Всего в 2016 году","Всего в 2016 году","1607,49 / 1917,75",null,null,"","",1]
[null,"     31.08.2016 – Сбербанк","     31.08.2016 – Сбербанк",855.15,null,null,"","",1]
[null,"     17.05.2016 – Сбербанк","     17.05.2016 – Сбербанк",169.6,null,null,"","",1]
[null,"     23.03.2016 – Сбербанк","     23.03.2016 – Сбербанк",893,null,null,"","",1]
[null,"Всего в 2015 году","Всего в 2015 году","2053,22 / 2874,4",null,null,"","",1]
[null,"     06.11.2015 – Сбербанк","     06.11.2015 – Сбербанк",2374.4,null,null,"","",1]
[null,"     19.11.2015 – Сбербанк","     19.11.2015 – Сбербанк",500,null,null,"","",1]
[null,"Всего в 2014 году","Всего в 2014 году","678,4 / 0",null,null,"","",1]
[null,0,{"$f":"IF(AM11=\"\",\"\",IF(AND(AI11=2015,AM11=0),\"\",IF(AJ11=\"\",\"Всего в \"&AI11&\" году\",\"     \"&TEXT(AK11,\"ДД.ММ.ГГГГ\")&\" – \"&AL11)))","v":""},{"$f":"IF(C21=\"\",\"\",AM11)","v":""},null,null,{"$f":"IF(AV12=2015,\"\",IF(OR($H$10=0,$H$10=\"\"),\"\",IF(AY12=\"\",\"\",IF(AX12=\"\",\"Всего начислено в \"&AV12&\" г.\",\"     \"&TEXT(AX12,\"ДД.ММ.ГГГГ\")))))","v":""},{"$f":"IF(G21=\"\",\"\",AY12)","v":""},1]
[null,0,{"$f":"IF(AM12=\"\",\"\",IF(AND(AI12=2015,AM12=0),\"\",IF(AJ12=\"\",\"Всего в \"&AI12&\" году\",\"     \"&TEXT(AK12,\"ДД.ММ.ГГГГ\")&\" – \"&AL12)))","v":""},{"$f":"IF(C22=\"\",\"\",AM12)","v":""},null,null,{"$f":"IF(AV13=2015,\"\",IF(OR($H$10=0,$H$10=\"\"),\"\",IF(AY13=\"\",\"\",IF(AX13=\"\",\"Всего начислено в \"&AV13&\" г.\",\"     \"&TEXT(AX13,\"ДД.ММ.ГГГГ\")))))","v":""},{"$f":"IF(G22=\"\",\"\",AY13)","v":""},""]
[null,0,{"$f":"IF(AM13=\"\",\"\",IF(AND(AI13=2015,AM13=0),\"\",IF(AJ13=\"\",\"Всего в \"&AI13&\" году\",\"     \"&TEXT(AK13,\"ДД.ММ.ГГГГ\")&\" – \"&AL13)))","v":""},{"$f":"IF(C23=\"\",\"\",AM13)","v":""},null,null,{"$f":"IF(AV14=2015,\"\",IF(OR($H$10=0,$H$10=\"\"),\"\",IF(AY14=\"\",\"\",IF(AX14=\"\",\"Всего начислено в \"&AV14&\" г.\",\"     \"&TEXT(AX14,\"ДД.ММ.ГГГГ\")))))","v":""},{"$f":"IF(G23=\"\",\"\",AY14)","v":""},""]
[null,0,{"$f":"IF(AM14=\"\",\"\",IF(AND(AI14=2015,AM14=0),\"\",IF(AJ14=\"\",\"Всего в \"&AI14&\" году\",\"     \"&TEXT(AK14,\"ДД.ММ.ГГГГ\")&\" – \"&AL14)))","v":""},{"$f":"IF(C24=\"\",\"\",AM14)","v":""},null,null,{"$f":"IF(AV15=2015,\"\",IF(OR($H$10=0,$H$10=\"\"),\"\",IF(AY15=\"\",\"\",IF(AX15=\"\",\"Всего начислено в \"&AV15&\" г.\",\"     \"&TEXT(AX15,\"ДД.ММ.ГГГГ\")))))","v":""},{"$f":"IF(G24=\"\",\"\",AY15)","v":""},""]
[null,0,{"$f":"IF(AM15=\"\",\"\",IF(AND(AI15=2015,AM15=0),\"\",IF(AJ15=\"\",\"Всего в \"&AI15&\" году\",\"     \"&TEXT(AK15,\"ДД.ММ.ГГГГ\")&\" – \"&AL15)))","v":""},{"$f":"IF(C25=\"\",\"\",AM15)","v":""},null,null,{"$f":"IF(AV16=2015,\"\",IF(OR($H$10=0,$H$10=\"\"),\"\",IF(AY16=\"\",\"\",IF(AX16=\"\",\"Всего начислено в \"&AV16&\" г.\",\"     \"&TEXT(AX16,\"ДД.ММ.ГГГГ\")))))","v":""},{"$f":"IF(G25=\"\",\"\",AY16)","v":""},""]

{"sheet":"Собираемость","index":2,"n_rows":10,"n_cols":34,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,28,1,33]]}
[null,null,"Сюда -->>","Отчет по начислениям и оплате взносов на капитальный ремонт  собственников в разрезе лицевых счетов за период:  c 2014-09-01 по 2016-10-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"Собираемость!$AC$2:ИНДЕКС(Собираемость!$AH:$AH;СЧЁТ(Собираемость!$AH:$AHB)+3)"]
[null,null,null,"многоквартирного дома по адресу: г. Иркутск, Рябикова б-р., д. 22А. Минимальный размер ежемесячного взноса: 7.32 руб. за 1 кв.м.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,{"$f":"CONCATENATE(D1,\" \",D2)","v":"Отчет по начислениям и оплате взносов на капитальный ремонт  собственников в разрезе лицевых счетов за период:  c 2014-09-01 по 2016-10-14 многоквартирного дома по адресу: г. Иркутск, Рябикова б-р., д. 22А. Минимальный размер ежемесячного взноса: 7.32 руб. за 1 кв.м."}]
[null,null,null,"№ п/п","№ помещения","Наименование собственника","Статус собственника","№ лицевого счета","Статус лицевого счета","Общая площадь собственника кв/м","(+)Долг/(-)Переплата на начало периода, руб.","Начислено по тарифу, руб.","Начислено по пени, руб.","Итого начислено, руб","Перерасчет по тарифу, руб.","Перерасчет по пени, руб.","Итого перерасчет, руб.","Оплачено по тарифу, руб","Оплачено по пене, руб","Итого оплачено, руб.","(+)Долг/               (-)Переплата на конец периода, руб.","% собираемости",null,null,null,null,null,null,"№ пом.","Статус собственника","Итого начислено, руб.","Итого оплачено, руб.","(+)Долг/(-) Переплата на конец периода, руб.","% собираемости"]
[{"$f":"IF(E4=\"\",\"\",1)","v":1},{"$f":"IF(A4=\"\",\"\",SUM($A$3:A4))","v":1},null,1,28,"Горбунова Елена Александровна","Физическое лицо",31117949,"Открыт",66.7,0,12206,8.2100000000000009,12214.21,0,0,0,11234.71,0,11234.71,979.5,91.98,null,null,null,null,1,{"$f":"IFERROR(IF(D4<>\"\",IF(((D4/2)-INT(D4/2))=0,\"ч\",\"н\"),\"\"),\"\")","v":"н"},{"$f":"IFERROR(SUBSTITUTE(VLOOKUP($AA4,$B$4:$V$10,4,),\" по отчету:\",\"\"),\"\")","v":"28"},{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(VLOOKUP($AA4,$B$4:$V$10,6,),\"Физическое лицо\",\"Физ. лицо\"),\"Юридическое лицо\",\"Юр. лицо\"),\"\")","v":"Физ. лицо"},{"$f":"IFERROR(VLOOKUP($AA4,$B$4:$V$10,13,),\"\")","v":12214.21},{"$f":"IFERROR(VLOOKUP($AA4,$B$4:$V$10,19,),\"\")","v":11234.71},{"$f":"IFERROR(VLOOKUP($AA4,$B$4:$V$10,20,),\"\")","v":979.5},{"$f":"IFERROR(VLOOKUP($AA4,$B$4:$V$10,21,),\"\")","v":91.98}]
[1,{"$f":"IF(A5=\"\",\"\",SUM($A$3:A5))","v":2},null,2,29,"Маркина Элла Александровна","Физическое лицо",31116128,"Открыт",46.7,0,8546,281.66000000000003,8827.66,0,0,0,0,0,0,8827.66,0,null,null,null,null,2,{"$f":"IFERROR(IF(D5<>\"\",IF(((D5/2)-INT(D5/2))=0,\"ч\",\"н\"),\"\"),\"\")","v":"ч"},{"$f":"IFERROR(SUBSTITUTE(VLOOKUP($AA5,$B$4:$V$10,4,),\" по отчету:\",\"\"),\"\")","v":"29"},{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(VLOOKUP($AA5,$B$4:$V$10,6,),\"Физическое лицо\",\"Физ. лицо\"),\"Юридическое лицо\",\"Юр. лицо\"),\"\")","v":"Физ. лицо"},{"$f":"IFERROR(VLOOKUP($AA5,$B$4:$V$10,13,),\"\")","v":8827.66},{"$f":"IFERROR(VLOOKUP($AA5,$B$4:$V$10,19,),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($AA5,$B$4:$V$10,20,),\"\")","v":8827.66},{"$f":"IFERROR(VLOOKUP($AA5,$B$4:$V$10,21,),\"\")","v":0}]
[1,{"$f":"IF(A6=\"\",\"\",SUM($A$3:A6))","v":3},null,3,"29А","Мотоев Михаил Анатольвич","Физическое лицо",31113285,"Открыт",18.7,0,3422,0,3422,0,0,0,3427.6,0,3427.6,-5.6,100.16,null,null,null,null,3,"н",{"$f":"IFERROR(SUBSTITUTE(VLOOKUP($AA6,$B$4:$V$10,4,),\" по отчету:\",\"\"),\"\")","v":"29А"},{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(VLOOKUP($AA6,$B$4:$V$10,6,),\"Физическое лицо\",\"Физ. лицо\"),\"Юридическое лицо\",\"Юр. лицо\"),\"\")","v":"Физ. лицо"},{"$f":"IFERROR(VLOOKUP($AA6,$B$4:$V$10,13,),\"\")","v":3422},{"$f":"IFERROR(VLOOKUP($AA6,$B$4:$V$10,19,),\"\")","v":3427.6},{"$f":"IFERROR(VLOOKUP($AA6,$B$4:$V$10,20,),\"\")","v":-5.6},{"$f":"IFERROR(VLOOKUP($AA6,$B$4:$V$10,21,),\"\")","v":100.16}]
[1,{"$f":"IF(A7=\"\",\"\",SUM($A$3:A7))","v":4},null,4,30,"Комитет городского обустройства администрации города Иркутска","Юридическое лицо",31209783,"Открыт",66.599999999999994,0,12187.75,0,12187.75,0,0,0,12187.79,0,12187.79,-0.04,100,null,null,null,null,4,"ч",{"$f":"IFERROR(SUBSTITUTE(VLOOKUP($AA7,$B$4:$V$10,4,),\" по отчету:\",\"\"),\"\")","v":"30"},{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(VLOOKUP($AA7,$B$4:$V$10,6,),\"Физическое лицо\",\"Физ. лицо\"),\"Юридическое лицо\",\"Юр. лицо\"),\"\")","v":"Юр. лицо"},{"$f":"IFERROR(VLOOKUP($AA7,$B$4:$V$10,13,),\"\")","v":12187.75},{"$f":"IFERROR(VLOOKUP($AA7,$B$4:$V$10,19,),\"\")","v":12187.79},{"$f":"IFERROR(VLOOKUP($AA7,$B$4:$V$10,20,),\"\")","v":-0.04},{"$f":"IFERROR(VLOOKUP($AA7,$B$4:$V$10,21,),\"\")","v":100}]
["",{"$f":"IF(A8=\"\",\"\",SUM($A$3:A8))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"",{"$f":"IFERROR(SUBSTITUTE(VLOOKUP($AA8,$B$4:$V$10,4,),\" по отчету:\",\"\"),\"\")","v":""},{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(VLOOKUP($AA8,$B$4:$V$10,6,),\"Физическое лицо\",\"Физ. лицо\"),\"Юридическое лицо\",\"Юр. лицо\"),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA8,$B$4:$V$10,13,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA8,$B$4:$V$10,19,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA8,$B$4:$V$10,20,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA8,$B$4:$V$10,21,),\"\")","v":""}]
["",{"$f":"IF(A9=\"\",\"\",SUM($A$3:A9))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"",{"$f":"IFERROR(SUBSTITUTE(VLOOKUP($AA9,$B$4:$V$10,4,),\" по отчету:\",\"\"),\"\")","v":""},{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(VLOOKUP($AA9,$B$4:$V$10,6,),\"Физическое лицо\",\"Физ. лицо\"),\"Юридическое лицо\",\"Юр. лицо\"),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA9,$B$4:$V$10,13,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA9,$B$4:$V$10,19,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA9,$B$4:$V$10,20,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA9,$B$4:$V$10,21,),\"\")","v":""}]
["",{"$f":"IF(A10=\"\",\"\",SUM($A$3:A10))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"",{"$f":"IFERROR(SUBSTITUTE(VLOOKUP($AA10,$B$4:$V$10,4,),\" по отчету:\",\"\"),\"\")","v":""},{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(VLOOKUP($AA10,$B$4:$V$10,6,),\"Физическое лицо\",\"Физ. лицо\"),\"Юридическое лицо\",\"Юр. лицо\"),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA10,$B$4:$V$10,13,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA10,$B$4:$V$10,19,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA10,$B$4:$V$10,20,),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($AA10,$B$4:$V$10,21,),\"\")","v":""}]