{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["РП с 01_07","Получается так","А надо так"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"РП с 01_07","index":0,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["к-во","Клиент","Город","Букв. Об.","Агент","операция","дата","время","№ договора","основной долг","проценты","пеня","штраф","Итого"]
[1,"Перышкин","Киселевск","Ф","Пупкин","б/н","2013-10-21",null,15,210000,15000,200,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":225200}]
[2,"Иванов","Анжеро-судженск","А","Петров","б/н","2013-10-21",null,20,2000,150,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":2150}]
[3,"Сидоров","Киселевск","Ф","Пупкин","б/н","2013-10-21",null,23,null,500,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":500}]

{"sheet":"Получается так","index":1,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,0,3,9],[4,0,4,9]]}
[]
[null,"Реестр за ",21,null,2013,null,null,null,null,null,null,10,{"$f":"IF(L2<10,\"0\"&L2,L2)","v":10}]
[]
["ООО \"Иванов и К\"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C2<10,0&C2&\".\"&M2&\".\"&E2,C2&\".\"&M2&\".\"&E2)","v":"21.10.2013"}]
["Реестр ",null,null,null,null,null,null,null,null,null,null,null,"основной долг","пени","штраф"]
[null,null,null,"с",{"$f":"M4","v":"21.10.2013"},"по",{"$f":"E6","v":"21.10.2013"}]
["№ п/п","Наименование                  док-та","Дата                   док-та","Дата договора,  номер","Номер документа","Основной долг,                  руб.","Проценты,              руб.","Пени,         руб.","Штраф,          руб.","ФИО",null,null,"Января"]
[1,"ПКО","2013-10-21","21.10.2013, № 15",15,210000,15000,200,null,"Перышкин",null,null,"Февраль"]
[2,"ПКО","2013-10-21","21.10.2013, № 20",20,2000,150,null,null,"Иванов",null,null,"Март"]
[3,"ПКО","2013-10-21","21.10.2013, № 23",23,null,500,null,null,"Сидоров",null,null,"Апрель"]
["Итого документов:",null,3,null,null,212000,null,null,null,null,null,null,"Май"]
["Отчет составил:",null,null,null,null,null,null,null,null,null,null,null,"Июнь"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Июль"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Август"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Сентябрь"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Октябрь"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ноябрь"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Декабрь"]

{"sheet":"А надо так","index":2,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,0,3,9],[4,0,4,9]]}
[]
[null,"Реестр за ",21,null,2013,null,null,null,null,null,null,10,{"$f":"IF(L2<10,\"0\"&L2,L2)","v":10}]
[]
["ООО \"Иванов и К\"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C2<10,0&C2&\".\"&M2&\".\"&E2,C2&\".\"&M2&\".\"&E2)","v":"21.10.2013"}]
["Реестр ",null,null,null,null,null,null,null,null,null,null,null,"основной долг","пени","штраф"]
[null,null,null,"с",{"$f":"M4","v":"21.10.2013"},"по",{"$f":"E6","v":"21.10.2013"}]
["№ п/п","Наименование                  док-та","Дата                   док-та","Дата договора,  номер","Номер документа","Основной долг,                  руб.","Проценты,              руб.","Пени,         руб.","Штраф,          руб.","ФИО",null,null,"Января"]
[1,"ПКО","2013-10-21","21.10.2013, № 15",15,210000,15000,200,null,"Перышкин",null,null,"Февраль"]
[2,"ПКО","2013-10-21","21.10.2013, № 20",20,2000,150,null,null,"Иванов",null,null,"Март"]
[3,"ПКО","2013-10-21","21.10.2013, № 23",23,null,500,null,null,"Сидоров",null,null,"Апрель"]
["Итого документов:",null,3,null,null,212000,{"$f":"SUM(G8:G10)","v":15650},{"$f":"SUM(H8:H10)","v":200},{"$f":"I8+I9+I10","v":0},null,null,null,"Май"]
["Отчет составил:",null,null,null,null,null,null,null,null,null,null,null,"Июнь"]
["Итого поступило:",null,{"$f":"C14+C15+C16","v":227850},null,null,null,null,null,null,null,null,null,"Июль"]
["По основному долгу:",null,{"$f":"F11","v":212000},null,null,null,null,null,null,null,null,null,"Август"]
["По процентам:",null,{"$f":"G11","v":15650},null,null,null,null,null,null,null,null,null,"Сентябрь"]
["Пени и штрафы:",null,{"$f":"H11+I11","v":200},null,null,null,null,null,null,null,null,null,"Октябрь"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ноябрь"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Декабрь"]
[null,"(должность)",null,"(подпись)",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":"SUMIFS(Таблица1[основной долг],Таблица1[дата],$M4)","v":212000}]
[null,null,null,null,null,null,null,null,null,null,null,"По процентам:",null,{"$f":"SUMIFS(Таблица1[проценты],Таблица1[дата],$M4)+SUMIFS(Таблица1[штраф],Таблица1[дата],$M4)","v":15650}]
[null,null,null,null,null,null,null,null,null,null,null,"Возврат госпошлины:",null,{"$f":"SUMIFS(Таблица1[пеня],Таблица1[дата],$M4)","v":200}]