{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Conditional Formatting","IF, TODAY Functions","IF, TOFAY, AND Functions","VBA","Customize Ribbon, and VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Create Notifications or Reminders"]
[]
[null,"Product","Supply Date"]
[null,"Laptop","2022-12-16"]
[null,"Monitor","2022-09-12"]
[null,"Mouse","2022-11-29"]
[null,"Printer","2022-12-18"]
[null,"Keyboard","2022-06-12"]

{"sheet":"Conditional Formatting","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Utilize Conditional Formatting",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Supply Date",null,null,null,null,null,"Product","Supply Date"]
[null,"Laptop","2022-12-29",null,null,null,null,null,"Laptop","2022-12-16"]
[null,"Monitor","2022-09-12",null,null,null,null,null,"Monitor","2022-09-12"]
[null,"Mouse","2022-11-29",null,null,null,null,null,"Mouse","2022-11-29"]
[null,"Printer","2023-01-18",null,null,null,null,null,"Printer","2022-12-18"]
[null,"Keyboard","2022-06-12",null,null,null,null,null,"Keyboard","2022-06-12"]

{"sheet":"IF, TODAY Functions","index":2,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Combine IF and TODAY Functions",null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Supply Date","Reminder",null,null,null,null,null,null,"Product","Supply Date","Reminder"]
[null,"Laptop","2022-12-02",{"$f":"IF(C5<TODAY(),\"Date Expire\",\"\")","v":"Date Expire"},null,null,null,null,null,null,"Laptop","2022-12-02"]
[null,"Monitor","2022-12-29",{"$f":"IF(C6<TODAY(),\"Date Expire\",\"\")","v":""},null,null,null,null,null,null,"Monitor","2022-12-29"]
[null,"Mouse","2022-11-29","Date Expire",null,null,null,null,null,null,"Mouse","2022-11-29"]
[null,"Printer","2023-01-18","",null,null,null,null,null,null,"Printer","2023-01-18"]
[null,"Keyboard","2022-06-12","Date Expire",null,null,null,null,null,null,"Keyboard","2022-06-12"]

{"sheet":"IF, TOFAY, AND Functions","index":3,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Merge IF, TODAY, and AND Functions",null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Supply Date","Notifications",null,null,null,null,null,null,"Product","Supply Date","Reminder"]
[null,"Laptop","2022-12-29",{"$f":"IF(AND(C5<>\"\",TODAY()+7>=C5),\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,"Laptop","2022-12-02"]
[null,"Monitor","2022-09-12",{"$f":"IF(AND(C6<>\"\",TODAY()+7>=C6),\"Yes\",\"No\")","v":"Yes"},null,null,null,null,null,null,"Monitor","2022-12-29"]
[null,"Mouse","2022-11-29","Yes",null,null,null,null,null,null,"Mouse","2022-11-29"]
[null,"Printer","2023-01-18","No",null,null,null,null,null,null,"Printer","2023-01-18"]
[null,"Keyboard","2022-06-12","Yes",null,null,null,null,null,null,"Keyboard","2022-06-12"]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Applying VBA",null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Buyer","Amount","Due Date",null,null,null,null,null,null,"Buyer","Amount","Due Date"]
[null,"Mike",45676,"2022-12-29",null,null,null,null,null,null,"Oliver",45676,"2022-03-25"]
[null,"Jack",89435,"2022-09-12",null,null,null,null,null,null,"Luka",89435,"2022-04-12"]
[null,"Ruth",78234,"2022-11-29",null,null,null,null,null,null,"Aron",78234,"2022-03-27"]
[null,"Lilly",55683,"2023-01-18",null,null,null,null,null,null,"Norman",55683,"2022-04-15"]
[null,"Steve",93245,"2022-06-12",null,null,null,null,null,null,"Brook",93245,"2022-03-29"]
[]
[null,"Days",7,null,null,null,null,null,null,null,"Days",7]

{"sheet":"Customize Ribbon, and VBA","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Add VBA and Customize Ribbon"]