{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Реестр"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Реестр","index":0,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Реестр счетов ",null,null,null,null,null,null,null,null,"Реестр ОПЛАТ"]
["Наименование товара","Клиент","номер счета","Дата счета","Кол-во","Цена,грн/тн","Сума, грн.",null,null,null,"номер счета","Наименование товара","Клиент","Оплачено, грн.","Оплачено,тн","Дата оплаты"]
["Товар1","Клиент1",98,"2019-04-17",72,10700,{"$f":"E3*F3","v":770400},null,null,null,123,{"$f":"IFERROR(INDEX($A$3:$A$8,SMALL(IF($K$3=$C$3:$C$8,ROW($A$3:$A$8),99999),ROW()-2)-2),\"\")","v":"Товар3"},{"$f":"IFERROR(INDEX($B$3:$B$8,SMALL(IF($K$3=$C$3:$C$8,ROW($B$3:$B$8),\"\"),ROW()-2)-2),\"\")","v":"Клиент4"}]
["Товар2","Клиент2",102,"2019-04-22",12.75,8690,{"$f":"E4*F4","v":110797.5},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$8,SMALL(IF($K$3=$C$3:$C$8,ROW($A$3:$A$8),99999),ROW()-2)-2),\"\")","v":"Товар5"},{"$f":"IFERROR(INDEX($B$3:$B$8,SMALL(IF($K$3=$C$3:$C$8,ROW($B$3:$B$8),\"\"),ROW()-2)-2),\"\")","v":"Клиент4"}]
["Товар1","Клиент3",106,"2019-04-23",50,8250,{"$f":"E5*F5","v":412500},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$8,SMALL(IF($K$3=$C$3:$C$8,ROW($A$3:$A$8),99999),ROW()-2)-2),\"\")","v":"Товар7"},{"$f":"IFERROR(INDEX($B$3:$B$8,SMALL(IF($K$3=$C$3:$C$8,ROW($B$3:$B$8),\"\"),ROW()-2)-2),\"\")","v":"Клиент4"}]
["Товар3","Клиент4",123,"2019-05-30",10,8550,{"$f":"E6*F6","v":85500},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$8,SMALL(IF($K$3=$C$3:$C$8,ROW($A$3:$A$8),99999),ROW()-2)-2),\"\")","v":""},{"$f":"IFERROR(INDEX($B$3:$B$8,SMALL(IF($K$3=$C$3:$C$8,ROW($B$3:$B$8),\"\"),ROW()-2)-2),\"\")","v":""}]
["Товар5","Клиент4",123,"2019-05-30",2.4,11600,{"$f":"E7*F7","v":27840},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$8,SMALL(IF($K$3=$C$3:$C$8,ROW($A$3:$A$8),99999),ROW()-2)-2),\"\")","v":""},{"$f":"IFERROR(INDEX($B$3:$B$8,SMALL(IF($K$3=$C$3:$C$8,ROW($B$3:$B$8),\"\"),ROW()-2)-2),\"\")","v":""}]
["Товар7","Клиент4",123,"2019-05-30",5.5,6500,{"$f":"E8*F8","v":35750}]