{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Pivot Table Wizard 1","Pivot chart wizard","Sum PT","Pivot Table","Pivot Table (3)","Table5","Power Query 1","Power Query 2","Power Query 3","VBA","Result VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"Pivot Table Wizard 1","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Row","Column","Value","Page1"]
["Emma","Week1",2354,"Item1"]
["Emma","Week2",1045,"Item1"]
["Emma","Week3",5613,"Item1"]
["Ellie","Week1",5627,"Item1"]
["Ellie","Week2",2745,"Item1"]
["Ellie","Week3",3762,"Item1"]
["Anne","Week1",4562,"Item1"]
["Anne","Week2",2754,"Item1"]
["Anne","Week3",7823,"Item1"]
["Dodd","Week1",7832,"Item1"]
["Dodd","Week2",2836,"Item1"]
["Dodd","Week3",1954,"Item1"]
["Sam","Week1",3782,"Item1"]
["Sam","Week2",9812,"Item1"]
["Sam","Week3",2735,"Item1"]
["Roth","Week1",4591,"Item1"]
["Roth","Week2",2367,"Item1"]
["Roth","Week3",1603,"Item1"]
["Bob","Week1",8723,"Item1"]
["Bob","Week2",7813,"Item1"]
["Bob","Week3",7821,"Item1"]

{"sheet":"Pivot chart wizard","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using PivotTable and PivotChart Wizard"]
[]
[null,"Row","Column","Value","Page1"]
[null,"Emma","Week1",2354,"Item1"]
[null,"Emma","Week2",1045,"Item1"]
[null,"Emma","Week3",5613,"Item1"]
[null,"Ellie","Week1",5627,"Item1"]
[null,"Ellie","Week2",2745,"Item1"]
[null,"Ellie","Week3",3762,"Item1"]
[null,"Anne","Week1",4562,"Item1"]
[null,"Anne","Week2",2754,"Item1"]
[null,"Anne","Week3",7823,"Item1"]
[null,"Dodd","Week1",7832,"Item1"]
[null,"Dodd","Week2",2836,"Item1"]
[null,"Dodd","Week3",1954,"Item1"]
[null,"Sam","Week1",3782,"Item1"]
[null,"Sam","Week2",9812,"Item1"]
[null,"Sam","Week3",2735,"Item1"]
[null,"Roth","Week1",4591,"Item1"]
[null,"Roth","Week2",2367,"Item1"]
[null,"Roth","Week3",1603,"Item1"]
[null,"Bob","Week1",8723,"Item1"]
[null,"Bob","Week2",7813,"Item1"]
[null,"Bob","Week3",7821,"Item1"]

{"sheet":"Sum PT","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Page1","(All)"]
[]
["Sum of Value"]
[98154]

{"sheet":"Pivot Table","index":3,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using PivotTable and PivotChart Wizard",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Salesperson","Week1","Week2","Week3",null,null,null,"Salesperson","Week1","Week2","Week3"]
[null,"Emma",2354,1045,5613,null,null,null,"Emma",2354,1045,5613]
[null,"Ellie",5627,2745,3762,null,null,null,"Ellie",5627,2745,3762]
[null,"Anne",4562,2754,7823,null,null,null,"Anne",4562,2754,7823]
[null,"Dodd",7832,2836,1954,null,null,null,"Dodd",7832,2836,1954]
[null,"Sam",3782,9812,2735,null,null,null,"Sam",3782,9812,2735]
[null,"Roth",4591,2367,1603,null,null,null,"Roth",4591,2367,1603]
[null,"Bob",8723,7813,7821,null,null,null,"Bob",8723,7813,7821]

{"sheet":"Pivot Table (3)","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sample Data Set"]
[]
[null,"Salesperson","Week1","Week2","Week3"]
[null,"Emma",2354,1045,5613]
[null,"Ellie",5627,2745,3762]
[null,"Anne",4562,2754,7823]
[null,"Dodd",7832,2836,1954]
[null,"Sam",3782,9812,2735]
[null,"Roth",4591,2367,1603]
[null,"Bob",8723,7813,7821]

{"sheet":"Table5","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Week1","Week2","Week3","Attribute","Value"]
[2354,1045,5613,"Salesperson","Emma"]
[5627,2745,3762,"Salesperson","Ellie"]
[4562,2754,7823,"Salesperson","Anne"]
[7832,2836,1954,"Salesperson","Dodd"]
[3782,9812,2735,"Salesperson","Sam"]
[4591,2367,1603,"Salesperson","Roth"]
[8723,7813,7821,"Salesperson","Bob"]

{"sheet":"Power Query 1","index":6,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Power Query",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Salesperson","Week1","Week2","Week3",null,null,null,"Salesperson","Week1","Week2","Week3"]
[null,"Emma",2354,1045,5613,null,null,null,"Emma",2354,1045,5613]
[null,"Ellie",5627,2745,3762,null,null,null,"Ellie",5627,2745,3762]
[null,"Anne",4562,2754,7823,null,null,null,"Anne",4562,2754,7823]
[null,"Dodd",7832,2836,1954,null,null,null,"Dodd",7832,2836,1954]
[null,"Sam",3782,9812,2735,null,null,null,"Sam",3782,9812,2735]
[null,"Roth",4591,2367,1603,null,null,null,"Roth",4591,2367,1603]
[null,"Bob",8723,7813,7821,null,null,null,"Bob",8723,7813,7821]

{"sheet":"Power Query 2","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Power Query"]
[]
[null,"Salesperson","Week1","Week2","Week3"]
[null,"Emma",2354,1045,5613]
[null,"Ellie",5627,2745,3762]
[null,"Anne",4562,2754,7823]
[null,"Dodd",7832,2836,1954]
[null,"Sam",3782,9812,2735]
[null,"Roth",4591,2367,1603]
[null,"Bob",8723,7813,7821]

{"sheet":"Power Query 3","index":8,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Power Query"]
[]
[null,"Salesperson","Attribute","Value"]
[null,"Emma","Week1",2354]
[null,"Emma","Week2",1045]
[null,"Emma","Week3",5613]
[null,"Ellie","Week1",5627]
[null,"Ellie","Week2",2745]
[null,"Ellie","Week3",3762]
[null,"Anne","Week1",4562]
[null,"Anne","Week2",2754]
[null,"Anne","Week3",7823]
[null,"Dodd","Week1",7832]
[null,"Dodd","Week2",2836]
[null,"Dodd","Week3",1954]
[null,"Sam","Week1",3782]
[null,"Sam","Week2",9812]
[null,"Sam","Week3",2735]
[null,"Roth","Week1",4591]
[null,"Roth","Week2",2367]
[null,"Roth","Week3",1603]
[null,"Bob","Week1",8723]
[null,"Bob","Week2",7813]
[null,"Bob","Week3",7821]

{"sheet":"VBA","index":9,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,"Try yourself"]
[]
[null,"Salesperson","Week1","Week2","Week3",null,null,null,null,"Salesperson","Week1","Week2","Week3"]
[null,"Emma",2354,1045,5613,null,null,null,null,"Emma",2354,1045,5613]
[null,"Ellie",5627,2745,3762,null,null,null,null,"Ellie",5627,2745,3762]
[null,"Anne",4562,2754,7823,null,null,null,null,"Anne",4562,2754,7823]
[null,"Dodd",7832,2836,1954,null,null,null,null,"Dodd",7832,2836,1954]
[null,"Sam",3782,9812,2735,null,null,null,null,"Sam",3782,9812,2735]
[null,"Roth",4591,2367,1603,null,null,null,null,"Roth",4591,2367,1603]
[null,"Bob",8723,7813,7821,null,null,null,null,"Bob",8723,7813,7821]

{"sheet":"Result VBA","index":10,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Emma",5613]
[null,"Ellie",5627]
[null,"Ellie",2745]
[null,"Ellie",3762]
[null,"Anne",4562]
[null,"Anne",2754]
[null,"Anne",7823]
[null,"Dodd",7832]
[null,"Dodd",2836]
[null,"Dodd",1954]
[null,"Sam",3782]
[null,"Sam",9812]
[null,"Sam",2735]
[null,"Roth",4591]
[null,"Roth",2367]
[null,"Roth",1603]
[null,"Bob",8723]
[null,"Bob",7813]
[null,"Bob",7821]
[null,"Bob",7813]
[null,"Bob",7821]