{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","Pv_Fields_List1","Sheet6","Pivot_FieldLoc_List","Sheet2","Return Field Name"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":3},"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":"Sheet1","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Creating Pivot Table Field Name List"]
[]
[null,"Order ID","Date","Product","Category","Quantity","Revenue"]
[null,1,"2023-01-05","Shirt","Apparel",10,200]
[null,2,"2023-01-07","Laptop","Electronics",2,1500]
[null,3,"2023-01-10","Book","Books",5,75]
[null,4,"2023-01-12","Smartphone","Electronics",3,900]
[null,5,"2023-01-15","Shoes","Apparel",8,400]
[null,6,"2023-01-18","Headphones","Electronics",5,250]
[null,7,"2023-01-20","T-shirt","Apparel",12,180]
[null,8,"2023-01-23","Backpack","Accessories",4,120]
[null,9,"2023-01-25","Camera","Electronics",1,800]
[null,10,"2023-01-28","Jeans","Apparel",6,300]
[null,11,"2023-02-02","Watch","Accessories",3,450]
[null,12,"2023-02-05","Tablet","Electronics",4,1200]
[null,13,"2023-02-08","Sunglasses","Accessories",2,180]
[null,14,"2023-02-10","Dress","Apparel",7,350]
[null,15,"2023-02-14","Speaker","Electronics",3,300]
[null,16,"2023-02-18","Hat","Accessories",10,100]
[null,17,"2023-02-20","Backpack","Accessories",5,150]
[null,18,"2023-02-25","Coat","Apparel",3,450]
[null,19,"2023-02-28","Earrings","Accessories",6,240]
[null,20,"2023-03-02","Printer","Electronics",1,500]
[]
[null,"Sum of Revenue","Category"]
[null,"Months","Accessories","Apparel","Books","Electronics","Grand Total"]
[null,"Jan",120,1080,75,3450,4725]
[null,"Feb",1120,800,null,1500,3420]
[null,"Mar",null,null,null,500,500]
[null,"Grand Total",1240,1880,75,5450,8645]

{"sheet":"Pv_Fields_List1","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Caption","Source Name","Location","Position","Sample Item","Formula","Notes"]
["Ticket ID","Ticket ID","Hidden",{"$error":"#N/A"},1]
["Date","Date","Row",2,"<1/5/2023"]
["Customer Name","Customer Name","Hidden",{"$error":"#N/A"},"Amanda White"]
["Category","Category","Row",3,"Billing"]
["Priority","Priority","Column",1,"High"]
["Status","Status","Data",{"$error":"#N/A"},"Closed"]
["Months","Months","Row",1,"<1/5/2023"]

{"sheet":"Sheet6","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Sheet","PT Name","PT Address","Caption","Heading","Source Name","Location","Position","Sample Item","Formula","OLAP"]
["Sheet1","PivotTable2","$B$26:$G$31","Date","$B$27","Date","1 - Row",1,"<1/5/2023",null,false]
["Sheet1","PivotTable2","$B$26:$G$31","Product","$B$27","Product","1 - Row",2,"Backpack",null,false]
["Sheet1","PivotTable2","$B$26:$G$31","Months","$B$27","Months","1 - Row",3,"<1/5/2023",null,false]
["Sheet1","PivotTable2","$B$26:$G$31","Category","$C$26","Category","2 - Column",1,"Accessories",null,false]
["Sheet1","PivotTable2","$B$26:$G$31","Revenue","$B$26","Revenue","4 - Data",1,null,null,false]
["Sheet2","PivotTable3","$B$26:$F$31","Date","$B$27","Date","1 - Row",1,"<1/5/2023",null,false]
["Sheet2","PivotTable3","$B$26:$F$31","Category","$B$27","Category","1 - Row",2,"Billing",null,false]
["Sheet2","PivotTable3","$B$26:$F$31","Months","$B$27","Months","1 - Row",3,"<1/5/2023",null,false]
["Sheet2","PivotTable3","$B$26:$F$31","Priority","$C$26","Priority","2 - Column",1,"High",null,false]
["Sheet2","PivotTable3","$B$26:$F$31","Status","$B$26","Status","4 - Data",1,null,null,false]

{"sheet":"Pivot_FieldLoc_List","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Caption","Source Name","Location","Position","Sample Item","Formula","Notes"]
["Date","Date","1 - Row",2,"<1/5/2023"]
["Category","Category","1 - Row",3,"Billing"]
["Months","Months","1 - Row",1,"<1/5/2023"]
["Priority","Priority","2 - Column",1,"High"]
["Status","Status","4 - Data",{"$error":"#N/A"}]
["Ticket ID","Ticket ID","0 - Hidden",{"$error":"#N/A"},1]
["Customer Name","Customer Name","0 - Hidden",{"$error":"#N/A"},"Amanda White"]

{"sheet":"Sheet2","index":4,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Creating Pivot Table Field Name List"]
[]
[null,"Ticket ID","Date","Customer Name","Category","Priority","Status"]
[null,1,"2023-01-05","John Smith","Technical","High","Open"]
[null,2,"2023-01-07","Sarah Johnson","Billing","Medium","Open"]
[null,3,"2023-01-10","David Brown","Technical","Low","Closed"]
[null,4,"2023-01-12","Lisa Davis","General","High","Open"]
[null,5,"2023-01-15","Michael Lee","Technical","Medium","Open"]
[null,6,"2023-01-18","Jessica Wang","Billing","Low","Closed"]
[null,7,"2023-01-20","Robert Miller","Technical","High","Open"]
[null,8,"2023-01-23","Emily Wilson","General","Medium","Open"]
[null,9,"2023-01-25","Brian Thompson","Technical","Low","Closed"]
[null,10,"2023-01-28","Samantha Chen","General","High","Open"]
[null,11,"2023-02-02","Daniel Clark","Billing","Medium","Open"]
[null,12,"2023-02-05","Jennifer Wong","Technical","Low","Closed"]
[null,13,"2023-02-08","Christopher","General","High","Open"]
[null,14,"2023-02-10","Amanda White","Technical","Medium","Open"]
[null,15,"2023-02-14","Andrew Lewis","Billing","Low","Closed"]
[null,16,"2023-02-18","Olivia Turner","Technical","High","Open"]
[null,17,"2023-02-20","Benjamin Hill","General","Medium","Open"]
[null,18,"2023-02-25","Lily Parker","Technical","Low","Closed"]
[null,19,"2023-02-28","Ethan Scott","General","High","Open"]
[null,20,"2023-03-02","Victoria Chen","Billing","Medium","Open"]
[]
[null,"Count of Status","Priority"]
[null,"Month","High","Low","Medium","Grand Total"]
[null,"Jan",4,3,3,10]
[null,"Feb",3,3,3,9]
[null,"Mar",null,null,1,1]
[null,"Grand Total",7,6,7,20]

{"sheet":"Return Field Name","index":5,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Return Field Name of Selected Cell in Pivot Table"]
[]
[null,"Order ID","Date","Product","Category","Quantity","Revenue"]
[null,1,"2023-01-05","Shirt","Apparel",10,200]
[null,2,"2023-01-07","Laptop","Electronics",2,1500]
[null,3,"2023-01-10","Book","Books",5,75]
[null,4,"2023-01-12","Smartphone","Electronics",3,900]
[null,5,"2023-01-15","Shoes","Apparel",8,400]
[null,6,"2023-01-18","Headphones","Electronics",5,250]
[null,7,"2023-01-20","T-shirt","Apparel",12,180]
[null,8,"2023-01-23","Backpack","Accessories",4,120]
[null,9,"2023-01-25","Camera","Electronics",1,800]
[null,10,"2023-01-28","Jeans","Apparel",6,300]
[null,11,"2023-02-02","Watch","Accessories",3,450]
[null,12,"2023-02-05","Tablet","Electronics",4,1200]
[null,13,"2023-02-08","Sunglasses","Accessories",2,180]
[null,14,"2023-02-10","Dress","Apparel",7,350]
[null,15,"2023-02-14","Speaker","Electronics",3,300]
[null,16,"2023-02-18","Hat","Accessories",10,100]
[null,17,"2023-02-20","Backpack","Accessories",5,150]
[null,18,"2023-02-25","Coat","Apparel",3,450]
[null,19,"2023-02-28","Earrings","Accessories",6,240]
[null,20,"2023-03-02","Printer","Electronics",1,500]
[]
[null,"Sum of Revenue","Category"]
[null,"Months","Accessories","Apparel","Books","Electronics","Grand Total"]
[null,"Jan",120,1080,75,3450,4725]
[null,"Feb",1120,800,null,1500,3420]
[null,"Mar",null,null,null,500,500]
[null,"Grand Total",1240,1880,75,5450,8645]