{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Filter Command","Conditional Formatting","Sheet1","Pivot Table","Formula","Macro Record","Macro Record (2)","Practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset Overview"]
[]
[null,"Salesmen","Date","Sales Amount"]
[null,"Paul","2022-08-23",800]
[null,"Alex","2021-06-22",750]
[null,"John","2020-04-15",670]
[null,"Smith","2021-09-18",860]
[null,"Peter","2022-02-14",700]
[null,"Sam","2020-07-12",780]
[null,"Tom","2021-03-21",850]

{"sheet":"Filter Command","index":1,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of Filter Command"]
[]
[null,"Salesmen","Date","Sales Amount"]
[null,"Paul","2022-08-23",800,null,null,null,null,null,"Paul","2022-08-23",800]
[null,"Alex","2021-06-22",750]
[null,"John","2020-04-15",670,null,null,null,null,null,"John","2020-04-15",670]
[null,"Smith","2021-09-18",860]
[null,"Peter","2022-02-14",700,null,null,null,null,null,"Peter","2022-02-14",700]
[null,"Sam","2020-07-12",780,null,null,null,null,null,"Sam","2020-07-12",780]
[null,"Tom","2021-03-21",850]

{"sheet":"Conditional Formatting","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Conditional Formatting"]
[]
[null,"Salesmen","Date","Sales Amount"]
[null,"Paul","2022-08-23",800,null,{"$f":"AND(C5>=$C$14,C5<=$D$14)","v":false}]
[null,"Alex","2021-06-22",750,null,{"$f":"AND(C6>=$C$14,C6<=$D$14)","v":true}]
[null,"John","2020-04-15",670,null,{"$f":"AND(C7>=$C$14,C7<=$D$14)","v":false}]
[null,"Smith","2021-09-18",860,null,true]
[null,"Peter","2022-02-14",700,null,false]
[null,"Sam","2020-07-12",780,null,false]
[null,"Tom","2021-03-21",850,null,true]
[]
[null,null,"From","To"]
[null,null,"2021-01-01","2021-12-31"]

{"sheet":"Sheet1","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Sales Amount","Column Labels"]
["Row Labels","Feb","Mar","Jun","Aug","Sep","Grand Total"]
["Alex",null,null,750,null,null,750]
["Paul",null,null,null,800,null,800]
["Peter",700,null,null,null,null,700]
["Smith",null,null,null,null,860,860]
["Tom",null,850,null,null,null,850]
["Grand Total",700,850,750,800,860,3960]

{"sheet":"Pivot Table","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Pivot Table"]
[]
[null,"Salesmen","Date","Sales Amount"]
[null,"Paul","2022-08-23",800]
[null,"Alex","2021-06-22",750]
[null,"John","2020-04-15",670]
[null,"Smith","2021-09-18",860]
[null,"Peter","2022-02-14",700]
[null,"Sam","2020-07-12",780]
[null,"Tom","2021-03-21",850]

{"sheet":"Formula","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Formula"]
[]
[null,"Salesmen","Date","Sales Amount"]
[null,"Paul","2022-08-23",800]
[null,"Alex","2021-06-22",750]
[null,"John","2020-04-15",670]
[null,"Smith","2021-09-18",860]
[null,"Peter","2022-08-14",700]
[null,"Sam","2020-07-12",780]
[null,"Tom","2021-03-21",850]
[]
[null,null,"Month","Sales"]
[null,null,"August",{"$f":"_xlfn._xlws.FILTER(D5:D11,MONTH(C5:C11)=8,\"Empty\")","v":800}]
[null,null,null,700]

{"sheet":"Macro Record","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Macro Record"]
[]
[null,"Salesmen","Date","Sales Amount"]
[null,"Paul","2022-08-23",800]
[null,"Alex","2021-06-22",750]
[null,"John","2020-04-15",670]
[null,"Smith","2021-09-18",860]
[null,"Peter","2022-02-14",700]
[null,"Sam","2020-07-12",780]
[null,"Tom","2021-03-21",850]

{"sheet":"Macro Record (2)","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Macro Record"]
[]
[null,"Salesmen","Date","Sales Amount"]
[null,"Paul","2022-08-23",800]
[null,"Alex","2021-06-22",750]
[null,"John","2020-04-15",670]
[null,"Smith","2021-09-18",860]
[null,"Peter","2022-02-14",700]
[null,"Sam","2020-07-12",780]
[null,"Tom","2021-03-21",850]

{"sheet":"Practice","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice Yourself"]
[]
[null,"Salesmen","Date","Sales Amount"]
[null,"Paul","2022-08-23",800]
[null,"Alex","2021-06-22",750]
[null,"John","2020-04-15",670]
[null,"Smith","2021-09-18",860]
[null,"Peter","2022-02-14",700]
[null,"Sam","2020-07-12",780]
[null,"Tom","2021-03-21",850]