{"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":9,"n_cols":16,"rows_kept":9,"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":"IF($K3=\"\",\"\",INDEX(A:A,MATCH($K3,$C:$C,)+ROW(L1)-1))","v":"Товар3"},{"$f":"IF($K3=\"\",\"\",INDEX(B:B,MATCH($K3,$C:$C,)+ROW(M1)-1))","v":"Клиент4"},{"$f":"IF($K3=\"\",\"\",INDEX(G:G,MATCH($K3,$C:$C,)+ROW(N1)-1))","v":85500},{"$f":"IF($K3=\"\",\"\",INDEX(E:E,MATCH($K3,$C:$C,)+ROW(O1)-1))","v":10},{"$f":"IF($K3=\"\",\"\",INDEX(D:D,MATCH($K3,$C:$C,)+ROW(P1)-1))","v":"2019-05-30"}]
["Товар2","Клиент2",102,"2019-04-22",12.75,8690,110797.5,null,null,null,{"$f":"IF(ROW(K1)<COUNTIF(C$3:C$8,K3),K3,\"\")","v":123},{"$f":"IF($K4=\"\",\"\",INDEX(A:A,MATCH($K4,$C:$C,)+ROW(L2)-1))","v":"Товар5"},"Клиент4",{"$f":"IF($K4=\"\",\"\",INDEX(G:G,MATCH($K4,$C:$C,)+ROW(N2)-1))","v":27840},{"$f":"IF($K4=\"\",\"\",INDEX(E:E,MATCH($K4,$C:$C,)+ROW(O2)-1))","v":2.4},{"$f":"IF($K4=\"\",\"\",INDEX(D:D,MATCH($K4,$C:$C,)+ROW(P2)-1))","v":"2019-05-30"}]
["Товар1","Клиент3","106","2019-04-23",50,8250,412500,null,null,null,{"$f":"IF(ROW(K2)<COUNTIF(C$3:C$8,K4),K4,\"\")","v":123},"Товар7","Клиент4",35750,5.5,"2019-05-30"]
["Товар3","Клиент4",123,"2019-05-30",10,8550,{"$f":"E6*F6","v":85500},null,null,null,98,"Товар3","Клиент4"]
["Товар5","Клиент4",123,"2019-05-30",2.4,11600,{"$f":"E7*F7","v":27840},null,null,null,124,0,0]
["Товар7","Клиент4",123,"2019-05-30",5.5,6500,{"$f":"E8*F8","v":35750},null,null,null,106,{"$error":"#N/A"},{"$error":"#N/A"}]
["Товар8","Клиент5",124,"2019-12-29",2,1500,{"$f":"E9*F9","v":3000}]