{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Buttons","SumData","CountData","AvgData"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Single Pivot Catche\n Multiple Pivot Tables"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Buttons","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Date","Items","Transaction","Price","Quantity","Location"]
["2020-07-14","Apple","Sales",110,800,"East"]
["2020-07-14","Grapes","Purchase",25,48,"West"]
["2020-07-14","Papaya","Sales",2,3665,"South"]
["2020-07-05","Banana","Purchase",24,6547,"South"]
["2020-07-06","Grapes","Sales",483,800,"East"]
["2020-07-14","Papaya","Purchase",32,7255,"West"]
["2000-07-18","Apple","Purchase",15,365,"North"]
["2020-01-01","Papaya","Sales",36,487,"West"]
["2020-06-30","Orange","Purchase",45,982,"East"]
["2020-07-14","Orange","Purchase",11,542,"East"]
["2020-07-14","Banana","Sales",48,1424,"North"]
["2020-07-15","Banana","Purchase",11,542,"North"]

{"sheet":"SumData","index":2,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Location","(All)"]
[]
["Sum of Price","Column Labels"]
["Row Labels","Apple","Banana","Orange","Grapes","Papaya","Grand Total"]
["2000-07-18",15,null,null,null,null,15]
["2020-01-01",null,null,null,null,36,36]
["2020-06-30",null,null,45,null,null,45]
["2020-07-05",null,24,null,null,null,24]
["2020-07-06",null,null,null,483,null,483]
["2020-07-14",110,48,11,25,34,228]
["2020-07-15",null,11,null,null,null,11]
["Grand Total",125,83,56,508,70,842]

{"sheet":"CountData","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Location","(All)"]
[]
["Count of Price","Column Labels"]
["Row Labels","Apple","Banana","Orange","Grapes","Papaya","Grand Total"]
["2000-07-18",1,null,null,null,null,1]
["2020-01-01",null,null,null,null,1,1]
["2020-06-30",null,null,1,null,null,1]
["2020-07-05",null,1,null,null,null,1]
["2020-07-06",null,null,null,1,null,1]
["2020-07-14",1,null,1,1,2,5]
["Grand Total",2,1,2,2,3,10]

{"sheet":"AvgData","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Location","(All)"]
[]
["Average of Quantity","Column Labels"]
["Row Labels","2000-07-18","2020-01-01","2020-06-30","2020-07-05","2020-07-06","2020-07-14","Grand Total"]
["Apple",365,null,null,null,null,800,582.5]
["Banana",null,null,null,6547,null,null,6547]
["Orange",null,null,982,null,null,542,762]
["Grapes",null,null,null,null,800,48,424]
["Papaya",null,487,null,null,null,5460,3802.3333333333335]
["Grand Total",365,487,982,6547,800,2462,2149.1]