{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Таблицы","ИТОГО 2019-2020-2021"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,14,0,22],[28,0,28,6],[30,0,30,6]]}
[]
["ТАБЛИЦА2019"]
["ИМЯ","Дата","Важное","Значение","Сумма1","Сумма2","Сумма3"]
["Вася","2019-01-01",10000,40,10,10,30]
["Вася","2019-02-01",10001,60,10,20,30]
["Петя ","2019-05-02",10002,60,10,20,30]
["Степа","2019-06-02",10003,70,20,20,30]
[null,null,null,{"$f":"SUM(D4:D7)","v":230},{"$f":"SUM(E4:E7)","v":50},{"$f":"SUM(F4:F7)","v":70},{"$f":"SUM(G4:G7)","v":120}]
[]
["ТАБЛИЦА2020"]
["ИМЯ","Дата","Важное","Значение","Сумма1","Сумма2","Сумма3"]
["Вася","2020-01-01",10004,90,30,20,30]
["Петя ","2020-02-02",10005,100,20,30,50]
["Степа","2020-03-03",10006,30,10,10,10]
[null,null,null,{"$f":"SUM(D12:D14)","v":220},{"$f":"SUM(E12:E14)","v":60},{"$f":"SUM(F12:F14)","v":60},{"$f":"SUM(G12:G14)","v":90}]
[]
["ТАБЛИЦА2021"]
["ИМЯ","Дата","Важное","Значение","Сумма1","Сумма2","Сумма3"]
["Вася","2021-01-01",10007,30,10,10,10]
["Петя ","2021-01-02",10008,40,10,20,10]
["Степа","2021-02-02",10009,50,20,10,20]
["Маша","2021-03-03",10010,80,20,30,30]
["Даша","2021-03-05",10011,100,40,10,50]
["Миша","2021-03-05",10012,120,50,50,20]
["Валя","2021-03-05",10013,90,50,20,20]
[null,null,null,{"$f":"SUM(D19:D25)","v":510},{"$f":"SUM(E19:E25)","v":200},{"$f":"SUM(F19:F25)","v":150},{"$f":"SUM(G19:G25)","v":160}]
[]
[]
["Столбец \"D\" должен равнятся сумме столбцов \"E\"+\"F\"+\"G\""]
[]
["Ворос на листе \"сводная таблица\""]

{"sheet":"ИТОГО 2019-2020-2021","index":1,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"ИМЯ","Дата","Важное"," Значение"," Сумма1"," Сумма2"," Сумма3","Разница"]
[null,null,"Вася",null,null,100,20,30,60,0]
[null,null,null,"2019-01-01",10000,40,10,10,30,10]
[null,null,null,"2019-02-01",10001,60,10,20,30,0]
[null,null,"Общий итог",null,null,100,20,30,60,0]