{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Данные","Таблица для заполнения","Списки"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":17,"n_cols":14,"rows_kept":17,"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,65,600,null,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":600}]
[4,"Сидоркин","Анжеро-судженск","А","Петров","б/н","2013-10-21",null,98,1000,null,800,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":1800}]
[5,"Панова","Анжеро-судженск","А","Петров","б/н","2013-10-21",null,22,500,null,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":500}]
[6,"Малова","Анжеро-судженск","А","Петров","б/н","2013-10-21",null,20,null,300,null,400,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":300}]
[7,"Сидоров","Киселевск","Ф","Пупкин","б/н","2013-10-21",null,23,null,500,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":500}]
[8,"Сидоров","Киселевск","Ф","Пупкин","б/н","2013-12-23",null,23,null,500,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":500}]
[9,"Сидоров","Киселевск","Ф","Пупкин","б/н","2013-12-23",null,23,null,500,190,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":690}]
[10,"Сидоров","Киселевск","Ф","Пупкин","б/н","2013-12-23",null,23,null,500,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":500}]
[11,"Сидоров","Киселевск","Ф","Пупкин","б/н","2013-12-23",null,23,null,500,null,500,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":500}]
[12,"Сидоров","Киселевск","Ф","Пупкин","б/н","2013-12-23",null,23,null,500,null,300,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":500}]
[13,"Андреенко","Киселевск","Ф","Пупкин","б/н","2013-12-23",null,23,2500,500,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":3000}]
[14,"Белогов","Киселевск","Ф","Пупкин","б/н","2013-12-23",null,23,650,500,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":1150}]
[15,"Недоделов","Киселевск","Ф","Пупкин","б/н","2013-12-23",null,23,544,500,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":1044}]
[16,"Пупкин","Киселевск","Ф","Пупкин","б/н","2013-12-23",null,23,null,500,null,null,{"$f":"Таблица1[[#This Row],[основной долг]]+Таблица1[[#This Row],[проценты]]+Таблица1[[#This Row],[пеня]]","v":500}]

{"sheet":"Таблица для заполнения","index":1,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,0,3,9],[4,0,4,9]]}
[]
[null,"Реестр за ",21,10,2013]
[]
["ООО \"Иванов и К\""]
["Реестр "]
[null,null,null,"с",{"$f":"DATE(E2,D2,C2)","v":"2013-10-21"},"по",{"$f":"E6","v":"2013-10-21"}]
["№ п/п","Наименование                  док-та","Дата                   док-та","Дата договора,  номер","Номер документа","Основной долг,                  руб.","Проценты,              руб.","Пени,         руб.","Штраф,          руб.","ФИО"]
[1,"ПКО","2013-10-21","21.10.2013, № 15",15,210000,15000,200,null,"Перышкин"]
[2,"ПКО","2013-10-21","21.10.2013, № 23",23,null,500,null,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":0}]
[null,null,null,null,null,null,null,null,null,null,null,"По процентам:",null,{"$f":"SUMIFS(Таблица1[проценты],Таблица1[дата],$M4)+SUMIFS(Таблица1[штраф],Таблица1[дата],$M4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Возврат госпошлины:",null,{"$f":"SUMIFS(Таблица1[пеня],Таблица1[дата],$M4)","v":0}]

{"sheet":"Списки","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Январь","Января"]
["Февраль","Февраля"]
["Март","Марта"]
["Апрель","Апреля"]
["Май","Мая"]
["Июнь","Июня"]
["Июль","Июля"]
["Август","Августа"]
["Сентябрь","Сентября"]
["Октябрь","Октября"]
["Ноябрь","Ноября"]
["Декабрь","Декабря"]