{"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],[4,3,7,4],[8,3,12,4],[1,1,1,2],[2,0,3,0],[2,1,3,1],[2,2,3,2]]}
[]
[null,"Сводная таблица "]
["№ п/п","Название работы","Дата  "]
[]
[1,"Покупка 1","2023-08-25","Все данные, которые вошли в недельный период"]
[2,"Покупка 2","2023-08-25"]
[3,"Покупка 3","2023-08-26"]
[4,"Покупка 4","2023-08-31"]
[5,"Покупка 5","2023-09-02","Данные, которые вошли в последующий недельный период"]
[6,"Покупка 6","2023-09-03"]
[7,"Покупка 7","2023-09-04"]
[8,"Покупка 8","2023-09-05"]
[9,"Покупка 9","2023-09-06"]

{"sheet":"операции...","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["№ п/п","Название работы","Дата ",null,{"$f":"TODAY()","v":"2023-09-04"}]
[1,{"$f":"IF($A2<=$E$5,INDEX(Данные!B:B,$A2+$E$6),\"\")","v":"Покупка 5"},{"$f":"IF($A2<=$E$5,INDEX(Данные!C:C,$A2+$E$6),\"\")","v":"2023-09-02"},null,{"$f":"E1-MOD(WEEKDAY(E1,2)+2,7)","v":"2023-09-01"}]
[2,{"$f":"IF($A3<=$E$5,INDEX(Данные!B:B,$A3+$E$6),\"\")","v":"Покупка 6"},{"$f":"IF($A3<=$E$5,INDEX(Данные!C:C,$A3+$E$6),\"\")","v":"2023-09-03"},null,{"$f":"E2+6","v":"2023-09-07"}]
[3,{"$f":"IF($A4<=$E$5,INDEX(Данные!B:B,$A4+$E$6),\"\")","v":"Покупка 7"},{"$f":"IF($A4<=$E$5,INDEX(Данные!C:C,$A4+$E$6),\"\")","v":"2023-09-04"},null,{"$f":"MATCH(E3,Данные!C:C)","v":13}]
[4,{"$f":"IF($A5<=$E$5,INDEX(Данные!B:B,$A5+$E$6),\"\")","v":"Покупка 8"},{"$f":"IF($A5<=$E$5,INDEX(Данные!C:C,$A5+$E$6),\"\")","v":"2023-09-05"},null,{"$f":"COUNTIFS(Данные!C:C,\">=\"&E2,Данные!C:C,\"<=\"&E3)","v":5}]
[5,{"$f":"IF($A6<=$E$5,INDEX(Данные!B:B,$A6+$E$6),\"\")","v":"Покупка 9"},{"$f":"IF($A6<=$E$5,INDEX(Данные!C:C,$A6+$E$6),\"\")","v":"2023-09-06"},null,{"$f":"E4-E5","v":8}]
[6,{"$f":"IF($A7<=$E$5,INDEX(Данные!B:B,$A7+$E$6),\"\")","v":""},{"$f":"IF($A7<=$E$5,INDEX(Данные!C:C,$A7+$E$6),\"\")","v":""}]
[7,{"$f":"IF($A8<=$E$5,INDEX(Данные!B:B,$A8+$E$6),\"\")","v":""},{"$f":"IF($A8<=$E$5,INDEX(Данные!C:C,$A8+$E$6),\"\")","v":""}]
[8,{"$f":"IF($A9<=$E$5,INDEX(Данные!B:B,$A9+$E$6),\"\")","v":""},{"$f":"IF($A9<=$E$5,INDEX(Данные!C:C,$A9+$E$6),\"\")","v":""}]
[9,{"$f":"IF($A10<=$E$5,INDEX(Данные!B:B,$A10+$E$6),\"\")","v":""},{"$f":"IF($A10<=$E$5,INDEX(Данные!C:C,$A10+$E$6),\"\")","v":""}]
[10,{"$f":"IF($A11<=$E$5,INDEX(Данные!B:B,$A11+$E$6),\"\")","v":""},{"$f":"IF($A11<=$E$5,INDEX(Данные!C:C,$A11+$E$6),\"\")","v":""}]
[11,{"$f":"IF($A12<=$E$5,INDEX(Данные!B:B,$A12+$E$6),\"\")","v":""},{"$f":"IF($A12<=$E$5,INDEX(Данные!C:C,$A12+$E$6),\"\")","v":""}]