{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Данные","операции..."],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[14,1,14,2],[1,1,1,2],[2,0,3,0],[2,1,3,1],[2,2,3,2]]}
[]
[null,"Сводная таблица "]
["№ п/п","Название работы","Дата  "]
[]
[1,"Покупка 1","2023-08-25",{"$f":"_xlfn.ISOWEEKNUM(C5)","v":34}]
[2,"Покупка 2","2023-08-25",{"$f":"_xlfn.ISOWEEKNUM(C6)","v":34}]
[3,"Покупка 3","2023-08-26",34]
[4,"Покупка 4","2023-08-31",35]
[5,"Покупка 5","2023-09-02",35]
[6,"Покупка 6","2023-09-03",35]
[7,"Покупка 7","2023-09-04",36]
[8,"Покупка 8","2023-09-05",36]
[9,"Покупка 9","2023-09-06",36]

{"sheet":"операции...","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["№ п/п","Название работы","Дата ",{"$f":"_xlfn.ISOWEEKNUM(TODAY())","v":36}]
[1,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A1)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A1))))","v":"Покупка 7"},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A1)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A1))))","v":"2023-09-04"}]
[2,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A2)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A2))))","v":"Покупка 8"},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A2)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A2))))","v":"2023-09-05"}]
[3,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A3)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A3))))","v":"Покупка 9"},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A3)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A3))))","v":"2023-09-06"}]
[4,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A4)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A4))))","v":""},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A4)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A4))))","v":""}]
[5,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A5)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A5))))","v":""},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A5)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A5))))","v":""}]
[6,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A6)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A6))))","v":""},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A6)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A6))))","v":""}]
[7,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A7)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A7))))","v":""},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A7)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A7))))","v":""}]
[8,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A8)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A8))))","v":""},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A8)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A8))))","v":""}]
[9,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A9)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A9))))","v":""},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A9)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A9))))","v":""}]
[10,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A10)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A10))))","v":""},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A10)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A10))))","v":""}]
[11,{"$f":"IF(INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:C$1000),1000),ROW(A11)))=0,\"\",INDEX(Данные!B$1:B$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!B$5:B$1000),1000),ROW(A11))))","v":""},{"$f":"IF(INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A11)))=0,\"\",INDEX(Данные!C$1:C$1000,SMALL(IF((Данные!D$5:D$1000=операции...!D$1),ROW(Данные!C$5:C$1000),1000),ROW(A11))))","v":""}]