{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Pivot Table-Automatically","Sheet7","Recommended PivotTables","Output Pivot Table","Sales Data"],"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":"Pivot Table-Automatically","index":0,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Creating Pivot Table Automatically"]
[]
[null,"Salesperson","Region","State","Product","Quantity Sold","Unit Price","Total"]
[null,"Marilyn Pittman","North","Nevada","Television",50,6057,{"$f":"F5*G5","v":302850}]
[null,"Samantha Carson","West","Texas","Refrigerator",40,5242,{"$f":"F6*G6","v":209680}]
[null,"Clinton Webster","East","New York","Television",29,5695,165155]
[null,"Chester Paul","West","New York","Refrigerator",42,5695,239190]
[null,"Rodney Gomez","North","Nevada","Microwave",45,6057,272565]
[null,"Jaime Schultz","West","Texas","Refrigerator",41,5242,214922]
[null,"Abel Alvarado","South","Washington","Microwave",84,6969,585396]
[null,"Rudy Palmer","West","Washington","Television",50,6969,348450]
[null,"Ryan Russell","North","Texas","Refrigerator",74,5242,387908]
[null,"Ramiro Harper","North","Michigan","Microwave",54,8955,483570]
[null,"Maggie Gilbert","East","Nevada","Television",89,6057,539073]
[null,"Jackie Berry","South","Michigan","Microwave",51,8955,456705]
[null,"Franklin Sanders","West","Michigan","Refrigerator",84,8955,752220]
[null,"Pablo Beck","North","Texas","Microwave",27,5242,141534]
[null,"Jeffrey Casey","East","Florida","Microwave",31,6701,207731]
[null,"Mona Cohen","South","Florida","Television",68,6701,455668]
[null,"Barry Francis","North","Nevada","Refrigerator",71,6057,430047]
[null,"Brad Turner","West","Austin","Microwave",58,7697,446426]
[null,"Darnell Underwood","East","Austin","Refrigerator",79,7697,608063]
[null,"Jeff Hunter","South","Nevada","Television",37,6057,224109]

{"sheet":"Sheet7","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Region","(All)"]
[]
["Sum of Total","Column Labels"]
["Row Labels","Microwave","Refrigerator","Television","Grand Total"]
["Austin",446426,608063,null,1054489]
["Florida",207731,null,455668,663399]
["Michigan",940275,752220,null,1692495]
["Nevada",272565,430047,1066032,1768644]
["New York",null,239190,165155,404345]
["Texas",141534,812510,null,954044]
["Washington",585396,null,348450,933846]
["Grand Total",2593927,2842030,2035305,7471262]

{"sheet":"Recommended PivotTables","index":2,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Recommended PivotTables Feature"]
[]
[null,"Salesperson","Region","State","Product","Quantity Sold","Unit Price","Total"]
[null,"Marilyn Pittman","North","Nevada","Television",50,6057,{"$f":"F5*G5","v":302850}]
[null,"Samantha Carson","West","Texas","Refrigerator",40,5242,{"$f":"F6*G6","v":209680}]
[null,"Clinton Webster","East","New York","Television",29,5695,165155]
[null,"Chester Paul","West","New York","Refrigerator",42,5695,239190]
[null,"Rodney Gomez","North","Nevada","Microwave",45,6057,272565]
[null,"Jaime Schultz","West","Texas","Refrigerator",41,5242,214922]
[null,"Abel Alvarado","South","Washington","Microwave",84,6969,585396]
[null,"Rudy Palmer","West","Washington","Television",50,6969,348450]
[null,"Ryan Russell","North","Texas","Refrigerator",74,5242,387908]
[null,"Ramiro Harper","North","Michigan","Microwave",54,8955,483570]
[null,"Maggie Gilbert","East","Nevada","Television",89,6057,539073]
[null,"Jackie Berry","South","Michigan","Microwave",51,8955,456705]
[null,"Franklin Sanders","West","Michigan","Refrigerator",84,8955,752220]
[null,"Pablo Beck","North","Texas","Microwave",27,5242,141534]
[null,"Jeffrey Casey","East","Florida","Microwave",31,6701,207731]
[null,"Mona Cohen","South","Florida","Television",68,6701,455668]
[null,"Barry Francis","North","Nevada","Refrigerator",71,6057,430047]
[null,"Brad Turner","West","Austin","Microwave",58,7697,446426]
[null,"Darnell Underwood","East","Austin","Refrigerator",79,7697,608063]
[null,"Jeff Hunter","South","Nevada","Television",37,6057,224109]

{"sheet":"Output Pivot Table","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Region","South"]
[]
[null,"Sum of Total","Column Labels"]
[null,"Row Labels","Microwave","Television","Grand Total"]
[null,"Florida",null,455668,455668]
[null,"Michigan",456705,null,456705]
[null,"Nevada",null,224109,224109]
[null,"Washington",585396,null,585396]
[null,"Grand Total",1042101,679777,1721878]

{"sheet":"Sales Data","index":4,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Salesperson","Region","State","Product","Quantity Sold","Unit Price","Total"]
["Marilyn Pittman","North","Nevada","Television",50,6057,{"$f":"E2*F2","v":302850}]
["Samantha Carson","West","Texas","Refrigerator",40,5242,{"$f":"E3*F3","v":209680}]
["Clinton Webster","East","New York","Television",29,5695,165155]
["Chester Paul","West","New York","Refrigerator",42,5695,239190]
["Rodney Gomez","North","Nevada","Microwave",45,6057,272565]
["Jaime Schultz","West","Texas","Refrigerator",41,5242,214922]
["Abel Alvarado","South","Washington","Microwave",84,6969,585396]
["Rudy Palmer","West","Washington","Television",50,6969,348450]
["Ryan Russell","North","Texas","Refrigerator",74,5242,387908]
["Ramiro Harper","North","Michigan","Microwave",54,8955,483570]
["Maggie Gilbert","East","Nevada","Television",89,6057,539073]
["Jackie Berry","South","Michigan","Microwave",51,8955,456705]
["Franklin Sanders","West","Michigan","Refrigerator",84,8955,752220]
["Pablo Beck","North","Texas","Microwave",27,5242,141534]
["Jeffrey Casey","East","Florida","Microwave",31,6701,207731]
["Mona Cohen","South","Florida","Television",68,6701,455668]
["Barry Francis","North","Nevada","Refrigerator",71,6057,430047]
["Brad Turner","West","Austin","Microwave",58,7697,446426]
["Darnell Underwood","East","Austin","Refrigerator",79,7697,608063]
["Jeff Hunter","South","Nevada","Television",37,6057,224109]