{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","CreatePivotTable","CreatePivotTable_Output","PivotTables_Add","PivotTables_Add_Output","PivotTable_Data","Output Pivot Table","Pivot_from_Another_Workbook"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":5},"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":"Overview","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Overview of Creating Pivot Table with VBA"]
[]
[null,"Region","(Multiple Items)"]
[]
[null,"Sum of Sales","Column Labels"]
[null,"Row Labels","Microwave","Television","Grand Total"]
[null,"Michigan",1990,null,1990]
[null,"Nevada",null,1930,1930]
[null,"New York",null,1750,1750]
[null,"Washington",1840,null,1840]
[null,"Grand Total",3830,3680,7510]

{"sheet":"CreatePivotTable","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating Pivot Table with CreatPivotTable Command"]
[]
[null,"Employee ID","Name","State","Sales"]
[null,11021499,"Michael","Michigan",1300]
[null,13426745,"Scofield","Navada",1900]
[null,12454678,"Jonathan","New York",1750]
[null,16743625,"Wick","Wasington D.C",1250]
[null,12746538,"Pablo","Michigan",1620]
[null,16453623,"Escober","Navada",1190]
[null,12236465,"Miguel","California",1840]
[null,13453657,"Sherlock","New York",1720]
[null,14536745,"Watson","Chicago",1340]
[null,13786546,"David","Michigan",1110]
[null,13244567,"Samanta","Texas",1930]
[null,15345278,"Walter","New York",1990]

{"sheet":"CreatePivotTable_Output","index":2,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Output Pivot Table Using CreatePivot Command"]
[]
[null,"Row Labels","Total Sales"]
[null,"California",1840]
[null,12236465,1840]
[null,"Chicago",1340]
[null,14536745,1340]
[null,"Michigan",4030]
[null,11021499,1300]
[null,12746538,1620]
[null,13786546,1110]
[null,"Navada",3090]
[null,13426745,1900]
[null,16453623,1190]
[null,"New York",5460]
[null,12454678,1750]
[null,13453657,1720]
[null,15345278,1990]
[null,"Texas",1930]
[null,13244567,1930]
[null,"Wasington D.C",1250]
[null,16743625,1250]
[null,"Grand Total",18940]

{"sheet":"PivotTables_Add","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using PivotTables.Add Command to Create Pivot Table"]
[]
[null,"Employee ID","Name","State","Sales"]
[null,11021499,"Michael","Michigan",1300]
[null,13426745,"Scofield","Navada",1900]
[null,12454678,"Jonathan","New York",1750]
[null,16743625,"Wick","Wasington D.C",1250]
[null,12746538,"Pablo","Michigan",1620]
[null,16453623,"Escober","Navada",1190]
[null,12236465,"Miguel","California",1840]
[null,13453657,"Sherlock","New York",1720]
[null,14536745,"Watson","Chicago",1340]
[null,13786546,"David","Michigan",1110]
[null,13244567,"Samanta","Texas",1930]
[null,15345278,"Walter","New York",1990]

{"sheet":"PivotTables_Add_Output","index":4,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Output of Applying PivotTables.Add Command"]
[]
[null,"Row Labels","Total Sales"]
[null,"California",1840]
[null,12236465,1840]
[null,"Chicago",1340]
[null,14536745,1340]
[null,"Michigan",4030]
[null,11021499,1300]
[null,12746538,1620]
[null,13786546,1110]
[null,"Navada",3090]
[null,13426745,1900]
[null,16453623,1190]
[null,"New York",5460]
[null,12454678,1750]
[null,13453657,1720]
[null,15345278,1990]
[null,"Texas",1930]
[null,13244567,1930]
[null,"Wasington D.C",1250]
[null,16743625,1250]
[null,"Grand Total",18940]

{"sheet":"PivotTable_Data","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Employee ID","Name","Product","Region","State","Sales"]
[11021499,"Michael","Television","North","Nevada",1300]
[13426745,"Scofield","Refrigerator","West","Texas",1900]
[12454678,"Jonathan","Television","East","New York",1750]
[16743625,"Wick","Refrigerator","West","New York",1250]
[12746538,"Pablo","Microwave","North","Nevada",1620]
[16453623,"Escober","Refrigerator","West","Texas",1190]
[12236465,"Miguel","Microwave","South","Washington",1840]
[13453657,"Sherlock","Television","West","Washington",1720]
[14536745,"Watson","Refrigerator","North","Texas",1340]
[13786546,"David","Microwave","North","Michigan",1110]
[13244567,"Samanta","Television","East","Nevada",1930]
[15345278,"Walter","Microwave","South","Michigan",1990]

{"sheet":"Output Pivot Table","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Output Pivot Table with Filter"]
[]
[null,"Region","(Multiple Items)"]
[]
[null,"Sum of Sales","Column Labels"]
[null,"Row Labels","Microwave","Television","Grand Total"]
[null,"Michigan",1990,null,1990]
[null,"Nevada",null,1930,1930]
[null,"New York",null,1750,1750]
[null,"Washington",1840,null,1840]
[null,"Grand Total",3830,3680,7510]

{"sheet":"Pivot_from_Another_Workbook","index":7,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,14]]}
[]
[null,"Creating Pivot Table from Data of Another Workbook"]
[]
[null,"Total Sales","Column Labels"]
[null,"Row Labels",11021499,12236465,12454678,12746538,13244567,13426745,13453657,13786546,14536745,15345278,16453623,16743625,"Grand Total"]
[null,"California",null,1840,null,null,null,null,null,null,null,null,null,null,1840]
[null,"Chicago",null,null,null,null,null,null,null,null,1340,null,null,null,1340]
[null,"Michigan",1300,null,null,1620,null,null,null,1110,null,null,null,null,4030]
[null,"Navada",null,null,null,null,null,1900,null,null,null,null,1190,null,3090]
[null,"New York",null,null,1750,null,null,null,1720,null,null,1990,null,null,5460]
[null,"Texas",null,null,null,null,1930,null,null,null,null,null,null,null,1930]
[null,"Wasington D.C",null,null,null,null,null,null,null,null,null,null,null,1250,1250]
[null,"Grand Total",1300,1840,1750,1620,1930,1900,1720,1110,1340,1990,1190,1250,18940]