{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Master Table","Jason","Steve","Emily","Aarav","Dwayne","Test_Example"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"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":"Master Table","index":0,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Master Table "]
[]
["Business Person","Task","Date Assigned","Date to Be Completed","Date Completed","Notes",null,"Business Person:"]
["Aarav","Make a cake","2021-12-28","2021-12-29","2021-12-30","Eggs",null,"Jason"]
["Aarav","Check Advanced filters","2023-01-01","2023-01-02","2021-12-30",null,null,"Steve"]
["Aarav","Auto Update Check ","2023-02-02","2023-02-03","2021-12-30",null,null,"Emily"]
["Jason","Test task 1","2023-01-01","2023-01-02","2021-12-29","Test",null,"Aarav"]
["Dwayne","Test task 3","2023-01-01","2023-01-02","2021-12-27","Go",null,"Dwayne"]
["Dwayne","Test task 6","2023-01-01","2023-01-02","2021-12-01","Forth",null,"Test_Example"]
["Dwayne","Test task 2","2023-01-01","2023-01-02","2021-12-01","Try"]
["Emily","Test task 5","2023-01-01","2023-01-02","2021-12-30","And "]
["Jason","Test task 4","2023-01-01","2023-01-02","2021-12-29","Back"]
["Jason","Bake Cookies 2","2023-01-01","2023-01-02","2021-12-25",42]
["Dwayne","Bake Cookies","2023-01-01","2023-01-02","2021-12-28","Eternity"]
["Steve","Bake Cookies 3","2023-01-01","2023-01-02","2021-12-25","Twelve"]
["Steve","Format Tables and cells Appropriately","2023-01-01","2023-01-02","2021-12-29","Pickle Rick "]
["Steve","Create Master Table for Project ","2023-01-01","2023-01-02","2021-12-28","Jaunuary"]
["Test_Example","Double check all formulas and logic","2023-01-01","2023-01-02","2021-12-30"]
[]
[]
[]
[null,null,null,null,null,null,null,"Business Person"]
[null,null,null,null,null,null,null,"Jason"]
[null,null,null,null,null,null,null,"Business Person"]
[null,null,null,null,null,null,null,"Steve"]
[null,null,null,null,null,null,null,"Business Person"]
[null,null,null,null,null,null,null,"Emily"]
[null,null,null,null,null,null,null,"Business Person"]
[null,null,null,null,null,null,null,"Aarav"]
[null,null,null,null,null,null,null,"Business Person"]
[null,null,null,null,null,null,null,"Dwayne"]
[null,null,null,null,null,null,null,"Business Person"]
[null,null,null,null,null,null,null,"Test_Example"]

{"sheet":"Jason","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["Business Contact",{"$f":"('Master Table'!H4)","v":"Jason"}]
[null,null,"CTRL-SHFT+Q TO UPDATE MANUALLY"]
["Task","Date Assigned","Date to Be Completed","Date Completed","5 Days Prior",null,null,null,"5 Days Prior"]
["Test task 1","2023-01-01","2023-01-02","2021-12-29",{"$f":"AND(Table5[[#This Row],[Date Completed]]>=TODAY()-5,Table5[[#This Row],[Date Completed]]<=TODAY())","v":true},null,null,null,true]
["Test task 4","2023-01-01","2023-01-02","2021-12-29",{"$f":"AND(Table5[[#This Row],[Date Completed]]>=TODAY()-5,Table5[[#This Row],[Date Completed]]<=TODAY())","v":true}]
["Bake Cookies 2","2023-01-01","2023-01-02","2021-12-25",{"$f":"AND(Table5[[#This Row],[Date Completed]]>=TODAY()-5,Table5[[#This Row],[Date Completed]]<=TODAY())","v":false}]
[null,null,null,null,{"$f":"AND(Table5[[#This Row],[Date Completed]]>=TODAY()-5,Table5[[#This Row],[Date Completed]]<=TODAY())","v":false}]
[null,null,null,null,{"$f":"AND(Table5[[#This Row],[Date Completed]]>=TODAY()-5,Table5[[#This Row],[Date Completed]]<=TODAY())","v":false},null,null,"CTRL-SHFT+J FOR UPDATE"]
[null,null,null,null,null,null,"Task","Date Completed","5 Days Prior"]
[null,null,null,null,null,null,"Test task 1","2021-12-29",true]
[null,null,null,null,null,null,"Test task 4","2021-12-29",true]
[null,null,null,null,null,null,"Bake Cookies","2021-12-28",true]

{"sheet":"Steve","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["Business Contact",{"$f":"('Master Table'!H5)","v":"Steve"}]
[null,null,"CTRL-SHFT+W TO UPDATE MANUALLY"]
["Task","Date Assigned","Date to Be Completed","Date Completed","5 Days Prior",null,null,null,"5 Days Prior"]
["Bake Cookies 3","2023-01-01","2023-01-02","2021-12-25",{"$f":"AND(Table7[[#This Row],[Date Completed]]>=TODAY()-5,Table7[[#This Row],[Date Completed]]<=TODAY())","v":false},null,null,null,true]
["Format Tables and cells Appropriately","2023-01-01","2023-01-02","2021-12-29",{"$f":"AND(Table7[[#This Row],[Date Completed]]>=TODAY()-5,Table7[[#This Row],[Date Completed]]<=TODAY())","v":true}]
["Create Master Table for Project ","2023-01-01","2023-01-02","2021-12-28",{"$f":"AND(Table7[[#This Row],[Date Completed]]>=TODAY()-5,Table7[[#This Row],[Date Completed]]<=TODAY())","v":true},null,null,"CTRL-SHFT+S TO RUN UPDATE"]
["Double check all formulas and logic","2023-01-01","2023-01-02","2021-12-25",{"$f":"AND(Table7[[#This Row],[Date Completed]]>=TODAY()-5,Table7[[#This Row],[Date Completed]]<=TODAY())","v":false},null,"Task","Date Completed","5 Days Prior"]
[null,null,null,null,null,null,"Format Tables and cells Appropriately","2021-12-29",true]
[null,null,null,null,null,null,"Create Master Table for Project ","2021-12-28",true]

{"sheet":"Emily","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["Business Contact",{"$f":"('Master Table'!H6)","v":"Emily"}]
[null,null,"CTRL-SHFT+R TO UPDATE MANUALLY",null,null,null,null,null,"5 Days Prior"]
["Task","Date Assigned","Date to Be Completed","Date Completed","5 Days Prior",null,null,null,true]
["Test task 5","2023-01-01","2023-01-02","2021-12-30",{"$f":"AND(Table8[[#This Row],[Date Completed]]>=TODAY()-5,Table8[[#This Row],[Date Completed]]<=TODAY())","v":true}]
[null,null,null,null,{"$f":"AND(Table8[[#This Row],[Date Completed]]>=TODAY()-5,Table8[[#This Row],[Date Completed]]<=TODAY())","v":false}]
[null,null,null,null,{"$f":"AND(Table8[[#This Row],[Date Completed]]>=TODAY()-5,Table8[[#This Row],[Date Completed]]<=TODAY())","v":false}]
[null,null,null,null,{"$f":"AND(Table8[[#This Row],[Date Completed]]>=TODAY()-5,Table8[[#This Row],[Date Completed]]<=TODAY())","v":false}]
[null,null,null,null,{"$f":"AND(Table8[[#This Row],[Date Completed]]>=TODAY()-5,Table8[[#This Row],[Date Completed]]<=TODAY())","v":false},null,null,"CTRL-SHFT+E FOR UPDATE"]
[null,null,null,null,null,null,"Task","Date Completed","5 Days Prior"]
[null,null,null,null,null,null,"Test task 5","2021-12-30",true]

{"sheet":"Aarav","index":4,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["Business Contact",{"$f":"('Master Table'!H7)","v":"Aarav"}]
[null,null,"CTRL-SHFT+T TO UPDATE MANUALLY",null,null,null,null,null,"5 Days Prior"]
["Task","Date Assigned","Date to Be Completed","Date Completed","5 Days Prior",null,null,null,true]
["Make a cake","2021-12-28","2021-12-29","2021-12-30",{"$f":"AND(Table10[[#This Row],[Date Completed]]>=TODAY()-5, Table10[[#This Row],[Date Completed]] <=TODAY())","v":true}]
["Check Advanced filters","2023-01-01","2023-01-02","2021-12-30",{"$f":"AND(Table10[[#This Row],[Date Completed]]>=TODAY()-5, Table10[[#This Row],[Date Completed]] <=TODAY())","v":true}]
["Auto Update Check ","2023-02-02","2023-02-03","2021-12-30",{"$f":"AND(Table10[[#This Row],[Date Completed]]>=TODAY()-5, Table10[[#This Row],[Date Completed]] <=TODAY())","v":true}]
[null,null,null,null,{"$f":"AND(Table10[[#This Row],[Date Completed]]>=TODAY()-5, Table10[[#This Row],[Date Completed]] <=TODAY())","v":false}]
[null,null,null,null,{"$f":"AND(Table10[[#This Row],[Date Completed]]>=TODAY()-5, Table10[[#This Row],[Date Completed]] <=TODAY())","v":false}]
[null,null,null,null,{"$f":"AND(Table10[[#This Row],[Date Completed]]>=TODAY()-5, Table10[[#This Row],[Date Completed]] <=TODAY())","v":false},null,null,"CTRL-SHFT+A TO UPDATE"]
[null,null,null,null,null,null,"Task","Date Completed","5 Days Prior"]
[null,null,null,null,null,null,"Make a cake","2021-12-30",true]
[null,null,null,null,null,null,"Check Advanced filters","2021-12-30",true]

{"sheet":"Dwayne","index":5,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["Business Contact",{"$f":"('Master Table'!H8)","v":"Dwayne"}]
[null," ","CTRL-SHFT+Y TO UPDATE MANUALLY",null,null,null,null,null,"5 Days Prior"]
["Task","Date Assigned","Date to Be Completed","Date Completed","5 Days Prior",null,null,null,true]
["Test task 3","2023-01-01","2023-01-02","2021-12-27",{"$f":"AND(Table20[[#This Row],[Date Completed]]>=TODAY()-5,Table20[[#This Row],[Date Completed]]<=TODAY())","v":true}]
["Test task 6","2023-01-01","2023-01-02","2021-12-01",{"$f":"AND(Table20[[#This Row],[Date Completed]]>=TODAY()-5,Table20[[#This Row],[Date Completed]]<=TODAY())","v":false}]
["Test task 2","2023-01-01","2023-01-02","2021-12-01",{"$f":"AND(Table20[[#This Row],[Date Completed]]>=TODAY()-5,Table20[[#This Row],[Date Completed]]<=TODAY())","v":false}]
["Bake Cookies","2023-01-01","2023-01-02","2021-12-28",{"$f":"AND(Table20[[#This Row],[Date Completed]]>=TODAY()-5,Table20[[#This Row],[Date Completed]]<=TODAY())","v":true}]
[null,null,null,null,null,null,null,"CTRL-SHFT+D FOR UPDATE"]
[null,null,null,null,null,null,"Task","Date Completed","5 Days Prior"]
[null,null,null,null,null,null,"Test task 3","2021-12-27",true]
[null,null,null,null,null,null,"Bake Cookies","2021-12-28",true]

{"sheet":"Test_Example","index":6,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Business Contact",{"$f":"('Master Table'!H9)","v":"Test_Example"},null,null,null,null,null,null,"5 Days Prior"]
[null,null,"CTRL-SHFT+P TO UPDATE",null,null,null,null,null,true]
["Task","Date Assigned","Date to Be Completed","Date Completed","5 Days Prior",null,null,"CTRL-SHFT+O TO UPDATE"]
["Double check all formulas and logic","2023-01-01","2023-01-02","2021-12-30",{"$f":"AND(Table3[[#This Row],[Date Completed]]>=TODAY()-5,Table3[[#This Row],[Date Completed]]<=TODAY())","v":true},null,"Task","Date Completed","5 Days Prior"]
[null,null,null,null,null,null,"Double check all formulas and logic","2021-12-30",true]