{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["To-Do List","Dataset","Conditional Formatting","Bar Chart","Using VBA"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"To-Do List","index":0,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"To-Do List"]
[null,"TASK","PRIORITY ","STATUS ","START DATE ","DUE DATE ","% COMPLETE","DONE?","NOTES"]
[null,"First Thing I Need To Do","Normal","Not Started",{"$f":"TODAY()","v":"2022-07-03"},{"$f":"ToDoList[[#This Row],[START DATE ]]+7","v":"2022-07-10"},0,{"$f":"--(ToDoList[[#This Row],[% COMPLETE]]>=1)","v":0}]
[null,"Other Thing I Need To Finish","High","In Progress",{"$f":"TODAY()-30","v":"2022-06-03"},{"$f":"ToDoList[[#This Row],[START DATE ]]+35","v":"2022-07-08"},0.5,{"$f":"--(ToDoList[[#This Row],[% COMPLETE]]>=1)","v":0}]
[null,"Something Else To Get Done","Low","Complete",{"$f":"TODAY()-23","v":"2022-06-10"},{"$f":"ToDoList[[#This Row],[START DATE ]]+10","v":"2022-06-20"},1,{"$f":"--(ToDoList[[#This Row],[% COMPLETE]]>=1)","v":1}]
[null,"More Errands And Things","Normal","In Progress",{"$f":"TODAY()-15","v":"2022-06-18"},{"$f":"ToDoList[[#This Row],[START DATE ]]+36","v":"2022-07-24"},0.75,{"$f":"--(ToDoList[[#This Row],[% COMPLETE]]>=1)","v":0}]
[null,"So Much To Get Done This Week","High","In Progress",{"$f":"TODAY()-5","v":"2022-06-28"},{"$f":"ToDoList[[#This Row],[START DATE ]]+14","v":"2022-07-12"},0.25,{"$f":"--(ToDoList[[#This Row],[% COMPLETE]]>=1)","v":0}]

{"sheet":"Dataset","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Excel To Do List with Progress Tracker "]
[]
[null,"Due Date","Task"]
[null,"2022-01-02","Attending Arts Class"]
[null,"2022-01-03","Join a Meeting"]
[null,"2022-01-06","Completing Homework"]
[null,"2022-01-10","Completing Science Project"]
[null,"2022-01-12","Giving Tuition Fees"]
[null,"2022-01-15","Attending Dance Class"]

{"sheet":"Conditional Formatting","index":2,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,14]]}
[]
[null,"Use of Conditional formatting",null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Due Date","Task","Status","Condition",null,null,null,null,null,"Date","Task","Status","Condition","Percent Complete"]
[null,"2022-01-02","Attending Arts Class",null,true,null,null,null,null,null,"2022-01-02","Attending Arts Class"]
[null,"2022-01-03","Join a Meeting",null,true,null,null,null,null,null,"2022-01-03","Join a Metting"]
[null,"2022-01-06","Completing Homework",null,false,null,"Progress",null,null,null,"2022-01-06","Completing Homework"]
[null,"2022-01-10","Completing Science Project",null,false,null,{"$f":"COUNTIF(E5:E10,TRUE)/COUNTIF(C5:C10,\"*\")","v":0.66666666666666663},null,null,null,"2022-01-10","Completing Science Project"]
[null,"2022-01-12","Giving Tuition Fees",null,true,null,null,null,null,null,"2022-01-12","Giving Tuition Fees"]
[null,"2022-01-15","Attending Dance Class",null,true,null,null,null,null,null,"2022-01-15","Attending Dance Class"]

{"sheet":"Bar Chart","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Inserting Bar Chart",null,null,null,null,">>> Do Yourself <<<"]
[null,null,null,null,null,{"$f":"COUNTIF(D5:D10,\"Complete\")/COUNTA(D5:D10)","v":0.33333333333333331}]
[null,"Due Date","Task","Status",null,null,"Due Date","Task","Status"]
[null,"2022-01-02","Attending Arts Class","In Progress",null,null,"2022-01-02","Attending Arts Class","In Progress"]
[null,"2022-01-03","Join a Meeting","In Progress",null,null,"2022-01-03","Join a Meeting","In Progress"]
[null,"2022-01-06","Completing Homework","Complete",null,null,"2022-01-06","Completing Homework","Complete"]
[null,"2022-01-10","Completing Science Project","In Progress",null,null,"2022-01-10","Completing Science Project","In Progress"]
[null,"2022-01-12","Giving Tuition Fees","In Progress",null,null,"2022-01-12","Giving Tuition Fees","In Progress"]
[null,"2022-01-15","Attending Dance Class","Complete",null,null,"2022-01-15","Attending Dance Class","Complete"]
[]
[null,"Status"]
[null,"Complete"]
[null,"In Progress"]

{"sheet":"Using VBA","index":4,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,10,3,13],[1,10,1,13]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Date","Task","Priority","Status",null,"Total Activities",{"$f":"COUNTIF($C$5:$C$10,\"<>\")","v":6},null,null,"Using VBA"]
[null,"2022-01-02","Attending Arts Class","High","ü",null,"Completed Score",{"$f":"IFERROR(COUNTIFS($D$5:$D$10,$B$14,$E$5:$E$10,$C$18)*$C$14+COUNTIFS($D$5:$D$10,$B$15,$E$5:$E$10,$C$18)*$C$15+COUNTIFS($D$5:$D$10,$B$16,$E$5:$E$10,$C$18)*$C$16,0)","v":10}]
[null,"2022-01-03","Join a Meeting","Medium",null,null,"Total Score",{"$f":"COUNTIF($D$5:$D$10,$B$14)*$C$14+COUNTIF($D$5:$D$10,$B$15)*$C$15+COUNTIF($D$5:$D$10,$B$16)*$C$16","v":18},null,null,"Date","Task","Priority","Status"]
[null,"2022-01-06","Completing Homework","Medium","ü",null,"Percent Completed",{"$f":"IFERROR(H5/H6,0)","v":0.55555555555555558},null,null,"2022-01-02","Attending Arts Class"]
[null,"2022-01-10","Completing Science Project","Low","ü",null,null,null,null,null,"2022-01-03","Join a Meeting"]
[null,"2022-01-12","Giving Tuition Fees","Low","ü",null,null,null,null,null,"2022-01-06","Completing Homework"]
[null,"2022-01-15","Attending Dance Class","High",null,null,null,null,null,null,"2022-01-10","Completing Science Project"]
[null,null,null,null,null,null,null,null,null,null,"2022-01-12","Giving Tuition Fees"]
[null,null,null,null,null,null,null,null,null,null,"2022-01-15","Attending Dance Class"]
[null,"Priority","Weightage"]
[null,"High",5]
[null,"Medium",3]
[null,"Low",1]
[]
[null,"Status Sign","ü"]