{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet2","HideFieldsList","HideData","ProtectData","Practice","Source Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":4},"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":"Sheet2","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Amount"]
["2020-06-06",500]
["2020-06-07",700]
["2020-06-08",300]
["2020-06-09",200]
["Grand Total",1700]

{"sheet":"HideFieldsList","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Amount"]
["2020-06-06",500]
["2020-06-07",700]
["2020-06-08",300]
["2020-06-09",200]
["Grand Total",1700]

{"sheet":"HideData","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Amount","Count of Payment"]
["2020-06-06",500,1]
["Bob",500,1]
["2020-06-08",300,1]
["Lily",300,1]
["2020-06-09",200,1]
["Rob",200,1]
["Grand Total",1000,3]

{"sheet":"ProtectData","index":3,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Amount"]
["2020-06-06",500]
["Bob",500]
["Cash",500]
["2020-06-07",700]
["Tom",700]
["Card",700]
["2020-06-08",300]
["Lily",300]
["Card",300]
["2020-06-09",200]
["Rob",200]
["Cash",200]
["Grand Total",1700]

{"sheet":"Practice","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Try Yourself"]
[]
[null,"Date","Customer","Payment","Amount"]
[null,"2020-06-06","Bob","Cash",500]
[null,"2020-06-07","Tom","Card",700]
[null,"2020-06-08","Lily","Card",300]
[null,"2020-06-09","Rob","Cash",200]

{"sheet":"Source Data","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[[1,1,1,4]]}
[]
[null,"Hiding Source Data in Pivot Table"]
[]
[null,"Date","Customer","Payment","Amount"]
[null,"2020-06-06","Bob","Cash",500]
[null,"2020-06-07","Tom","Card",700]
[null,"2020-06-08","Lily","Card",300]
[null,"2020-06-09","Rob","Cash",200]