{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["PivotTableSheet","SourceSheet","PivotTable2","TableData"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":2},"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":"PivotTableSheet","index":0,"n_rows":52,"n_cols":2,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Amount ($)"]
["T1000",179]
["Lucas King",179]
["Jacket",179]
["Vancouver",179]
["T1001",199]
["Jessica Davis",199]
["Hat",199]
["New York",199]
["T1002",25]
["Ruby Scott",25]
["Shoes",25]
["Glasgow",25]
["T1003",138]
["John Smith",138]
["Bag",138]
["Toronto",138]
["T1004",119]
["Emma Lee",119]
["Shoes",119]
["Glasgow",119]
["T1005",84]
["Emma Lee",84]
["Bag",84]
["Montreal",84]
["T1006",162]
["Michael Brown",162]
["Hat",162]
["Birmingham",162]
["T1007",35]
["Michael Brown",35]
["Hat",35]
["Birmingham",35]
["T1008",97]
["Liam Thompson",97]
["Bag",97]
["Sydney",97]
["T1009",136]
["Sophie Walker",136]
["Hat",136]
["Christchurch",136]
["T1010",31]
["Jessica Davis",31]
["Jacket",31]
["Sydney",31]
["T1011",139]
["Mason Hall",139]
["Bag",139]
["Chicago",139]
["Grand Total",1344]

{"sheet":"SourceSheet","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Transaction ID","Customer","Item","Amount ($)","City"]
["T1000","Lucas King","Jacket",179,"Vancouver"]
["T1001","Jessica Davis","Hat",199,"New York"]
["T1002","Ruby Scott","Shoes",25,"Glasgow"]
["T1003","John Smith","Bag",138,"Toronto"]
["T1004","Emma Lee","Shoes",119,"Glasgow"]
["T1005","Emma Lee","Bag",84,"Montreal"]
["T1006","Michael Brown","Hat",162,"Birmingham"]
["T1007","Michael Brown","Hat",35,"Birmingham"]
["T1008","Liam Thompson","Bag",97,"Sydney"]
["T1009","Sophie Walker","Hat",136,"Christchurch"]
["T1010","Jessica Davis","Jacket",31,"Sydney"]
["T1011","Mason Hall","Bag",139,"Chicago"]

{"sheet":"PivotTable2","index":2,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Amount ($)"]
["T1000",179]
["Lucas King",179]
["Jacket",179]
["Vancouver",179]
["T1001",199]
["Jessica Davis",199]
["Hat",199]
["New York",199]
["T1002",25]
["Ruby Scott",25]
["Shoes",25]
["Glasgow",25]
["T1003",138]
["John Smith",138]
["Bag",138]
["Toronto",138]
["T1004",119]
["Emma Lee",119]
["Shoes",119]
["Glasgow",119]
["T1005",84]
["Emma Lee",84]
["Bag",84]
["Montreal",84]
["T1006",162]
["Michael Brown",162]
["Hat",162]
["Birmingham",162]
["T1007",35]
["Michael Brown",35]
["Hat",35]
["Birmingham",35]
["T1008",97]
["Liam Thompson",97]
["Bag",97]
["Sydney",97]
["T1009",136]
["Sophie Walker",136]
["Hat",136]
["Christchurch",136]
["T1010",31]
["Jessica Davis",31]
["Jacket",31]
["Sydney",31]
["T1011",139]
["Mason Hall",139]
["Bag",139]
["Chicago",139]
["T1012",999]
["New Customer",999]
["New Item",999]
["Another City",999]
["Grand Total",2343]

{"sheet":"TableData","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Transaction ID","Customer","Item","Amount ($)","City"]
["T1000","Lucas King","Jacket",179,"Vancouver"]
["T1001","Jessica Davis","Hat",199,"New York"]
["T1002","Ruby Scott","Shoes",25,"Glasgow"]
["T1003","John Smith","Bag",138,"Toronto"]
["T1004","Emma Lee","Shoes",119,"Glasgow"]
["T1005","Emma Lee","Bag",84,"Montreal"]
["T1006","Michael Brown","Hat",162,"Birmingham"]
["T1007","Michael Brown","Hat",35,"Birmingham"]
["T1008","Liam Thompson","Bag",97,"Sydney"]
["T1009","Sophie Walker","Hat",136,"Christchurch"]
["T1010","Jessica Davis","Jacket",31,"Sydney"]
["T1011","Mason Hall","Bag",139,"Chicago"]
["T1012","New Customer","New Item",999,"Another City"]