{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["списки","приход","расход","аналитика"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Контрагент","Объект\nработ","Выполняемая\nработа","Статья\nрасхода","Группа\nстатей расхода"]
[null,"Иванов","Детский сад","монтаж","бензин Иванов","бензин"]
[null,"Петров ","Музей","демонтаж","бензин Петров","зп"]
[null,"Сидоров","Школа","строительство","зп Иванов","то "]
[null,null,null,null,"то ","Иванов"]
[null,null,null,null,"зп","петров"]

{"sheet":"приход","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"ИТОГО остаток",null,{"$f":"SUM(H5:H10000)","v":450}]
[]
[null,"Дата","Контрагент","Объект\nработ","Выполняемая\nработа","Сумма ","Валюта","Остаток по контракту"]
[null,"2016-01-01","Петров ","Детский сад","монтаж",100,"USD",80]
[null,"2016-01-02","Петров ","Музей","демонтаж",100,"USD",80]
[null,"2016-01-03","Сидоров","Школа","строительство",100,"RUB",80]
[null,"2016-01-04","Иванов","Детский сад","монтаж",100,"RUB",80]
[null,"2016-01-05","Петров ","Музей","демонтаж",100,"EUR",80]
[null,"2016-03-10","Иванов","Музей","демонтаж",50,"RUB",50]

{"sheet":"расход","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"приход!H2","v":450},null,null,null,null,"ИТОГО расход",{"$f":"SUM(H5:H10000)","v":3498},null,null,{"$f":"B2-H2","v":-3048}]
[]
[null,"Входящий\nостаток",null,null,"Дата","Контрагент","Статья\nрасхода","Сумма","Валюта",null,"Исходящий\nостаток"]
[null,null,null,null,"2016-03-08","Сидоров","бензин Петров",253,"RUB"]
[null,null,null,null,"2016-03-01","Петров ","петров",122,"USD"]
[null,null,null,null,"2016-03-01",null,"зп Иванов",255,"USD"]
[null,null,null,null,"2016-03-06","Иванов","бензин Иванов",235,"EUR"]
[null,null,null,null,"2016-03-05",null,"зп Иванов",268,"RUB"]
[null,null,null,null,"2016-03-01","Петров ","то ",1565,"RUB"]
[null,null,null,null,"2016-03-07","Петров ","зп",200,"RUB"]
[null,null,null,null,"2016-03-01","Петров ","то ",600,"RUB"]

{"sheet":"аналитика","index":3,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,12,3,13]]}
[]
[null,"Период с",null,null,"ПРИХОД","Всего остаток",{"$f":"SUMIF(H$7:H$1048576,\"<>0\")","v":550},null,null,null,"Период с","2016-03-01",{"$f":"\"РАСХОД всего:   \"&TEXT(SUMIF(O$7:O$1048576,\"<>0\"),\"0,00\")","v":"РАСХОД всего:   723,00"}]
[]
[null,"по",null,null,null,null,null,null,null,null,"по","2016-03-10","зп",null,true]
[]
[null,null,null,"Дата","Контрагент","Объект\nработ","Выполняемая\nработа","Сумма ","Валюта","Остаток по контракту",null,"Дата","Контрагент","Статья (группа статей) расхода","Сумма","Валюта"]
[null,null,null,"2016-01-01","Петров ","Детский сад","монтаж",100,"USD",80,null,"2016-03-01",null,"зп Иванов",255,"USD"]
[null,null,null,"2016-01-02","Петров ","Музей","демонтаж",100,"USD",80,null,"2016-03-05",null,"зп Иванов",268,"RUB"]
[null,null,null,"2016-01-03","Сидоров","Школа","строительство",100,"RUB",80,null,"2016-03-07","Петров ","зп",200,"RUB"]
[null,null,null,"2016-01-04","Иванов","Детский сад","монтаж",100,"RUB",80]
[null,null,null,"2016-01-05","Петров ","Музей","демонтаж",100,"EUR",80]
[null,null,null,"2016-03-10","Иванов","Музей","демонтаж",50,"RUB",50]