{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Consolidate Option","Subtotal","Use of Pivot Table ","Sheet5","Formula","formulas from Formula sheet","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":"Dataset","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Sales"]
[]
[null,"Sales Rep","Sales"]
[null,"Michael",100]
[null,"Jordan ",200]
[null,"Isaac",150]
[null,"Jordan ",160]
[null,"Michael",220]
[null,"Isaac",80]
[null,"Bill",180]
[null,"Edward",500]
[null,"Bill",320]
[null,"Edward",100]

{"sheet":"Consolidate Option","index":1,"n_rows":14,"n_cols":23,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,4,3,5],[1,1,1,5],[1,18,1,22],[3,21,3,22]]}
[]
[null,"Use of Consolidate Option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Sales Rep","Sales",null,"Consolidated Data",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Rep","Sales",null,"Consolidated Data"]
[null,"Michael",100,null,"Sales Rep","Sales",null,null,null,null,null,null,null,null,null,null,null,null,"Michael",100,null,"Sales Rep","Sales"]
[null,"Jordan ",200,null,"Michael",320,null,null,null,null,null,null,null,null,null,null,null,null,"Jordan ",200]
[null,"Isaac",150,null,"Jordan ",360,null,null,null,null,null,null,null,null,null,null,null,null,"Isaac",150]
[null,"Jordan ",160,null,"Isaac",230,null,null,null,null,null,null,null,null,null,null,null,null,"Jordan ",160]
[null,"Michael",220,null,"Bill",500,null,null,null,null,null,null,null,null,null,null,null,null,"Michael",220]
[null,"Isaac",80,null,"Edward",600,null,null,null,null,null,null,null,null,null,null,null,null,"Isaac",80]
[null,"Bill",180,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bill",180]
[null,"Edward",500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edward",500]
[null,"Bill",320,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bill",320]
[null,"Edward",100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edward",100]

{"sheet":"Subtotal","index":2,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,2],[22,15,22,16]]}
[]
[null,"Applying Subtotal Feature"]
[]
[null,"Sales Rep","Sales"]
[null,"Bill",180]
[null,"Bill",320]
[null,"Bill Total",{"$f":"SUBTOTAL(9,C5:C6)","v":500}]
[null,"Edward",500]
[null,"Edward",100]
[null,"Edward Total",{"$f":"SUBTOTAL(9,C8:C9)","v":600}]
[null,"Isaac",150]
[null,"Isaac",80]
[null,"Isaac Total",{"$f":"SUBTOTAL(9,C11:C12)","v":230}]
[null,"Jordan ",200]
[null,"Jordan ",160]
[null,"Jordan  Total",{"$f":"SUBTOTAL(9,C14:C15)","v":360}]
[null,"Michael",100,null,null,null,null,null,null,null,null,null,null,null,null,"Bill",320]
[null,"Michael",220,null,null,null,null,null,null,null,null,null,null,null,null,"Edward",100]
[null,"Michael Total",{"$f":"SUBTOTAL(9,C17:C18)","v":320}]
[null,"Grand Total",{"$f":"SUBTOTAL(9,C5:C18)","v":2010}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Rep","Sales"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Michael",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jordan ",200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isaac",150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jordan ",160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Michael",220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isaac",80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bill",180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edward",500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bill",320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edward",100]

{"sheet":"Use of Pivot Table ","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting Pivot Table"]
[]
[null,"Sales Rep","Sales"]
[null,"Michael",100]
[null,"Jordan ",200]
[null,"Isaac",150]
[null,"Jordan ",160]
[null,"Michael",220]
[null,"Isaac",80]
[null,"Bill",180]
[null,"Edward",500]
[null,"Bill",320]
[null,"Edward",100]

{"sheet":"Sheet5","index":4,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Sales"]
["Bill",500]
["Edward",600]
["Isaac",230]
["Jordan ",360]
["Michael",320]

{"sheet":"Formula","index":5,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,13]]}
[]
[null,"Applying Formula",null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Sales Rep","Helper 1",null,null,null,null,null,null,null,"Sales Rep","Sales","Helper 1","Helper 2"]
[null,"Bill",500,null,null,null,null,null,null,null,"Michael",100]
[null,"Edward",600,null,null,null,null,null,null,null,"Jordan ",200]
[null,"Isaac",230,null,null,null,null,null,null,null,"Isaac",150]
[null,"Jordan ",360,null,null,null,null,null,null,null,"Jordan ",160]
[null,"Michael",320,null,null,null,null,null,null,null,"Michael",220]
[null,null,null,null,null,null,null,null,null,null,"Isaac",80]
[null,null,null,null,null,null,null,null,null,null,"Bill",180]
[null,null,null,null,null,null,null,null,null,null,"Edward",500]
[null,null,null,null,null,null,null,null,null,null,"Bill",320]
[null,null,null,null,null,null,null,null,null,null,"Edward",100]

{"sheet":"formulas from Formula sheet","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying Formula"]
[]
[null,"Sales Rep","Sales","Helper 1","Helper 2"]
[null,"Bill",180,{"$f":"IF(B5=B4,D4+C5,C5)","v":180},{"$f":"IF(B6<>B5, \"Added Values\",\"\")","v":""}]
[null,"Bill",320,{"$f":"IF(B6=B5,D5+C6,C6)","v":500},{"$f":"IF(B7<>B6, \"Added Values\",\"\")","v":"Added Values"}]
[null,"Edward",500,500,""]
[null,"Edward",100,600,"Added Values"]
[null,"Isaac",150,150,""]
[null,"Isaac",80,230,"Added Values"]
[null,"Jordan ",200,200,""]
[null,"Jordan ",160,360,"Added Values"]
[null,"Michael",100,100,""]
[null,"Michael",220,320,"Added Values"]

{"sheet":"VBA","index":7,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,14,1,15]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Sales Rep","Sales",null,null,null,null,null,null,null,null,null,null,null,"Sales Rep","Sales"]
[null,"Michael",320,null,null,null,null,null,null,null,null,null,null,null,"Michael",100]
[null,"Jordan ",360,null,null,null,null,null,null,null,null,null,null,null,"Jordan ",200]
[null,"Isaac",230,null,null,null,null,null,null,null,null,null,null,null,"Isaac",150]
[null,"Bill",500,null,null,null,null,null,null,null,null,null,null,null,"Jordan ",160]
[null,"Edward",600,null,null,null,null,null,null,null,null,null,null,null,"Michael",220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isaac",80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bill",180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edward",500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bill",320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edward",100]