{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Source Data","Right-Click","PivotTable Option","Analyze Option","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":4},"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":"Source Data","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset"]
[]
[null,"Car Model","Brand","Color","Price"]
[null,"Azera","Hyundai","Black",35000]
[null,"Altima","Nissan","Red",24550]
[null,"Sonata","Hyundai","Yellow",23400]
[null,"Swift","Suzuki","Red",46000]
[null,"Ciaz","Suzuki","Blue",14230]
[null,"Versa","Nissan","White",15080]
[null,"Palisade","Hyundai","Blue",17000]

{"sheet":"Right-Click","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Use of Right Mouse Button"]
[]
[null,"Column Labels"]
["Row Labels","Black","Blue","Red","White","Yellow","Grand Total"]
["Count of Car Model"]
["Hyundai",1,1,null,null,1,3]
["Nissan",null,null,1,1,null,2]
["Suzuki",null,1,1,null,null,2]
["Sum of Price"]
["Hyundai",35000,17000,null,null,23400,75400]
["Nissan",null,null,24550,15080,null,39630]
["Suzuki",null,14230,46000,null,null,60230]
["Total Count of Car Model",1,2,2,1,1,7]
["Total Sum of Price",35000,31230,70550,15080,23400,175260]

{"sheet":"PivotTable Option","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Use of PivotTable Options"]
[]
[null,"Column Labels"]
["Row Labels","Black","Blue","Red","White","Yellow","Grand Total"]
["Count of Car Model"]
["Hyundai",1,1,null,null,1,3]
["Nissan",null,null,1,1,null,2]
["Suzuki",null,1,1,null,null,2]
["Sum of Price"]
["Hyundai",35000,17000,null,null,23400,75400]
["Nissan",null,null,24550,15080,null,39630]
["Suzuki",null,14230,46000,null,null,60230]
["Total Count of Car Model",1,2,2,1,1,7]
["Total Sum of Price",35000,31230,70550,15080,23400,175260]

{"sheet":"Analyze Option","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Use of PivotTable Analyze Options"]
[]
[null,"Column Labels"]
["Row Labels","Black","Blue","Red","White","Yellow","Grand Total"]
["Count of Car Model"]
["Hyundai",1,1,null,null,1,3]
["Nissan",null,null,1,1,null,2]
["Suzuki",null,1,1,null,null,2]
["Sum of Price"]
["Hyundai",35000,17000,null,null,23400,75400]
["Nissan",null,null,24550,15080,null,39630]
["Suzuki",null,14230,46000,null,null,60230]
["Total Count of Car Model",1,2,2,1,1,7]
["Total Sum of Price",35000,31230,70550,15080,23400,175260]

{"sheet":"VBA","index":4,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Use of VBA Macro"]
[]
[null,"Column Labels"]
["Row Labels","Black","Blue","Red","White","Yellow","Grand Total"]
["Count of Car Model"]
["Hyundai",1,1,null,null,1,3]
["Nissan",null,null,1,1,null,2]
["Suzuki",null,1,1,null,null,2]
["Sum of Price"]
["Hyundai",35000,17000,null,null,23400,75400]
["Nissan",null,null,24550,15080,null,39630]
["Suzuki",null,14230,46000,null,null,60230]
["Total Count of Car Model",1,2,2,1,1,7]
["Total Sum of Price",35000,31230,70550,15080,23400,175260]