{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Using Conditional Formatting","Inserting Bar Chart","Dataset 2","Check Boxes & Circle Chart"],"not_rendered":{"charts":2,"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":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Name","Task Completed"]
[null,"Adam",0.76]
[null,"John",0.38]
[null,"Layla",0.55000000000000004]
[null,"Mary",0.95]
[null,"Jimmy",0.2]
[null,"David",0.62]
[null,"Natalie",0.88]
[null,"Chris",0.33]

{"sheet":"Using Conditional Formatting","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,8,2,9]]}
[]
[null,"Using Conditional Formatting"]
[null,null,null,null,null,null,null,null,"Do Yourself"]
[null,"Name","Task Completed"]
[null,"Adam",0.76,null,null,null,null,null,"Name","Task Completed"]
[null,"John",0.38,null,null,null,null,null,"Adam",0.76]
[null,"Layla",0.55000000000000004,null,null,null,null,null,"John",0.38]
[null,"Mary",0.95,null,null,null,null,null,"Layla",0.55000000000000004]
[null,"Jimmy",0.38,null,null,null,null,null,"Mary",0.95]
[null,"David",0.62,null,null,null,null,null,"Jimmy",0.2]
[null,"Natalie",0.88,null,null,null,null,null,"David",0.62]
[null,"Chris",0.2,null,null,null,null,null,"Natalie",0.88]
[null,null,null,null,null,null,null,null,"Chris",0.33]

{"sheet":"Inserting Bar Chart","index":2,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,9],[1,14,1,15]]}
[]
[null,"Inserting Bar Chart to Create a Progress Tracker",null,null,null,null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Task Completed",null,null,null,null,null,null,null,null,null,null,null,"Name","Task Completed"]
[null,"Adam",0.76,null,null,null,null,null,null,null,null,null,null,null,"Adam",0.76]
[null,"John",0.38,null,null,null,null,null,null,null,null,null,null,null,"John",0.38]
[null,"Layla",0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,"Layla",0.55000000000000004]
[null,"Mary",0.95,null,null,null,null,null,null,null,null,null,null,null,"Mary",0.95]
[null,"Jimmy",0.2,null,null,null,null,null,null,null,null,null,null,null,"Jimmy",0.2]
[null,"David",0.62,null,null,null,null,null,null,null,null,null,null,null,"David",0.62]
[null,"Natalie",0.88,null,null,null,null,null,null,null,null,null,null,null,"Natalie",0.88]
[null,"Chris",0.33,null,null,null,null,null,null,null,null,null,null,null,"Chris",0.33]

{"sheet":"Dataset 2","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dataset"]
[]
[null,"Tasks for the Week"]
[null,"Creating Outline for Project 1"]
[null,"Making Presentation for Project 2"]
[null,"Checking Accounts"]
[null,"Contacting Partners"]
[null,"Visiting Site"]
[null,"Making Presentation for Project 1"]
[null,"Meeting with Marketing Team"]
[null,"Meeting with Finance Team"]

{"sheet":"Check Boxes & Circle Chart","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,5,4,5],[3,6,4,6],[1,1,1,6]]}
[]
[null,"Utilizing Check Boxes and Circle Chart",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Tasks for the Week","Check Box","COUNTIF",null," Tasks Completed","Task Remaining",null,null,null,null,"Tasks for the Week"]
[null,"Creating Outline for Project 1",null,false,null,null,null,null,null,null,null,"Creating Outline for Project 1"]
[null,"Making Presentation for Project 2",null,true,null,{"$f":"COUNTIF(D5:D12,TRUE)/COUNTIF(B5:B12,\"*\")","v":0.625},{"$f":"1-F6","v":0.375},null,null,null,null,"Making Presentation for Project 2"]
[null,"Checking Accounts",null,true,null,null,null,null,null,null,null,"Checking Accounts"]
[null,"Contacting Partners",null,false,null,null,null,null,null,null,null,"Contacting Partners"]
[null,"Visiting Site",null,true,null,null,null,null,null,null,null,"Visiting Site"]
[null,"Making Presentation for Project 1",null,true,null,null,null,null,null,null,null,"Making Presentation for Project 1"]
[null,"Meeting with Marketing Team",null,false,null,null,null,null,null,null,null,"Meeting with Marketing Team"]
[null,"Meeting with Finance Team",null,true,null,null,null,null,null,null,null,"Meeting with Finance Team"]