{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"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":"Лист1","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Текущая дата",{"$f":"TODAY()","v":"2019-12-08"}]
[]
[null,null,null,"Сумма по неполаченным счетам",{"$f":"SUMIFS(E7:E19,A7:A19,\"<\"&B1-15,G7:G19,\"<>х\")","v":26900}]
[null,null,null,"Кол-во  неполаченных счетов",{"$f":"COUNTIFS(A7:A19,\"<\"&B1-15,G7:G19,\"<>х\")","v":6}]
[]
["Дата","Название клиента","Номер счета","вес груза нетто","Сумма по счету","Оплата","оплачено"]
["2019-12-07",null,12,null,1000,10500]
["2019-11-23",null,10,null,500]
["2019-12-07",null,1,null,9000]
["2019-01-15",null,234,null,300]
["2019-11-18",null,23,null,5500]
["2019-01-18",null,65,null,900,null,"х"]
["2019-02-13",null,90,null,5500,11550]
["2019-03-01",null,56,null,600]
["2019-03-21",null,63,null,5500]
["2019-04-03",null,728,null,9500,null,"х"]
["2019-04-20",null,667,null,9500]
["2019-04-20",null,98,null,450,null,"х"]
["2019-04-26",null,124,null,700,null,"х"]
[null,null,null,null,null,{"$f":"SUM(F7:F19)","v":22050}]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}