{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Project tracker","Setup"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Project tracker","index":0,"n_rows":13,"n_cols":13,"rows_kept":13}
[]
[null,"Project tracker",{"$nulls":3},"Percent over/under to highlighted numbers",{"v":0.25,"d":"25%"}]
[]
[null,"Project","Category","Assigned to","Estimated start","Estimated finish","Estimated work (in hours)","Estimated duration\n(in days)","Actual start","Actual finish","Actual work \n(in hours)","Actual duration (in days)","Notes"]
[null,"Project 1","Category 1","Employee 1",{"$f":"TODAY()-65","v":"2023-08-14"},{"$f":"TODAY()-5","v":"2023-10-13"},210,{"$f":"IF(COUNTA('Project tracker'!$E5,'Project tracker'!$F5)<>2,\"\",DAYS360('Project tracker'!$E5,'Project tracker'!$F5,FALSE))","v":59},{"$f":"TODAY()-65","v":"2023-08-14"},{"$f":"TODAY()","v":"2023-10-18"},300,{"$f":"IF(COUNTA('Project tracker'!$I5,'Project tracker'!$J5)<>2,\"\",DAYS360('Project tracker'!$I5,'Project tracker'!$J5,FALSE))","v":64}]
[null,"Project 2","Category 2","Employee 4",{"$f":"TODAY()-41","v":"2023-09-07"},{"$f":"TODAY()-10","v":"2023-10-08"},400,{"$f":"IF(COUNTA('Project tracker'!$E6,'Project tracker'!$F6)<>2,\"\",DAYS360('Project tracker'!$E6,'Project tracker'!$F6,FALSE))","v":31},{"$f":"TODAY()-41","v":"2023-09-07"},{"$f":"TODAY()-7","v":"2023-10-11"},390,{"$f":"IF(COUNTA('Project tracker'!$I6,'Project tracker'!$J6)<>2,\"\",DAYS360('Project tracker'!$I6,'Project tracker'!$J6,FALSE))","v":34}]
[null,"Project 3","Category 1","Employee 2",{"$f":"TODAY()-100","v":"2023-07-10"},{"$f":"TODAY()-40","v":"2023-09-08"},500,{"$f":"IF(COUNTA('Project tracker'!$E7,'Project tracker'!$F7)<>2,\"\",DAYS360('Project tracker'!$E7,'Project tracker'!$F7,FALSE))","v":58},{"$f":"TODAY()-100","v":"2023-07-10"},{"$f":"TODAY()-27","v":"2023-09-21"},500,{"$f":"IF(COUNTA('Project tracker'!$I7,'Project tracker'!$J7)<>2,\"\",DAYS360('Project tracker'!$I7,'Project tracker'!$J7,FALSE))","v":71}]
[null,"Project 4","Category 2","Employee 3",{"$f":"TODAY()-90","v":"2023-07-20"},{"$f":"TODAY()-80","v":"2023-07-30"},250,{"$f":"IF(COUNTA('Project tracker'!$E8,'Project tracker'!$F8)<>2,\"\",DAYS360('Project tracker'!$E8,'Project tracker'!$F8,FALSE))","v":10},{"$f":"TODAY()-90","v":"2023-07-20"},{"$f":"TODAY()-71","v":"2023-08-08"},276,{"$f":"IF(COUNTA('Project tracker'!$I8,'Project tracker'!$J8)<>2,\"\",DAYS360('Project tracker'!$I8,'Project tracker'!$J8,FALSE))","v":18}]
[null,"Project 5","Category 3","Employee 2",{"$f":"TODAY()-90","v":"2023-07-20"},{"$f":"TODAY()-50","v":"2023-08-29"},300,{"$f":"IF(COUNTA('Project tracker'!$E9,'Project tracker'!$F9)<>2,\"\",DAYS360('Project tracker'!$E9,'Project tracker'!$F9,FALSE))","v":39},{"$f":"TODAY()-90","v":"2023-07-20"},{"$f":"TODAY()-44","v":"2023-09-04"},310,{"$f":"IF(COUNTA('Project tracker'!$I9,'Project tracker'!$J9)<>2,\"\",DAYS360('Project tracker'!$I9,'Project tracker'!$J9,FALSE))","v":44}]
[null,"Project 6","Category 4","Employee 4",{"$f":"TODAY()-60","v":"2023-08-19"},{"$f":"TODAY()-50","v":"2023-08-29"},500,{"$f":"IF(COUNTA('Project tracker'!$E10,'Project tracker'!$F10)<>2,\"\",DAYS360('Project tracker'!$E10,'Project tracker'!$F10,FALSE))","v":10},{"$f":"TODAY()-60","v":"2023-08-19"},{"$f":"TODAY()-45","v":"2023-09-03"},510,{"$f":"IF(COUNTA('Project tracker'!$I10,'Project tracker'!$J10)<>2,\"\",DAYS360('Project tracker'!$I10,'Project tracker'!$J10,FALSE))","v":14}]
[null,"Project 7","Category 5","Employee 1",{"$f":"TODAY()-44","v":"2023-09-04"},{"$f":"TODAY()-20","v":"2023-09-28"},750,{"$f":"IF(COUNTA('Project tracker'!$E11,'Project tracker'!$F11)<>2,\"\",DAYS360('Project tracker'!$E11,'Project tracker'!$F11,FALSE))","v":24},{"$f":"TODAY()-44","v":"2023-09-04"},{"$f":"TODAY()-15","v":"2023-10-03"},790,{"$f":"IF(COUNTA('Project tracker'!$I11,'Project tracker'!$J11)<>2,\"\",DAYS360('Project tracker'!$I11,'Project tracker'!$J11,FALSE))","v":29}]
[null,"Project 8","Category 2","Employee 1",{"$f":"TODAY()-39","v":"2023-09-09"},{"$f":"TODAY()","v":"2023-10-18"},450,{"$f":"IF(COUNTA('Project tracker'!$E12,'Project tracker'!$F12)<>2,\"\",DAYS360('Project tracker'!$E12,'Project tracker'!$F12,FALSE))","v":39},{"$f":"TODAY()-45","v":"2023-09-03"},{"$f":"TODAY()-5","v":"2023-10-13"},430,{"$f":"IF(COUNTA('Project tracker'!$I12,'Project tracker'!$J12)<>2,\"\",DAYS360('Project tracker'!$I12,'Project tracker'!$J12,FALSE))","v":40}]
[null,"Project 9","Category 4","Employee 1",{"$f":"TODAY()-95","v":"2023-07-15"},{"$f":"TODAY()-75","v":"2023-08-04"},250,{"$f":"IF(COUNTA('Project tracker'!$E13,'Project tracker'!$F13)<>2,\"\",DAYS360('Project tracker'!$E13,'Project tracker'!$F13,FALSE))","v":19},{"$f":"TODAY()-90","v":"2023-07-20"},{"$f":"TODAY()-80","v":"2023-07-30"},200,{"$f":"IF(COUNTA('Project tracker'!$I13,'Project tracker'!$J13)<>2,\"\",DAYS360('Project tracker'!$I13,'Project tracker'!$J13,FALSE))","v":10}]

{"sheet":"Setup","index":1,"n_rows":10,"n_cols":3,"rows_kept":10}
[]
[null,"Setup"]
[]
[null,"Category Name","Employee Name"]
[null,"Category 1","Employee 1"]
[null,"Category 2","Employee 2"]
[null,"Category 3","Employee 3"]
[null,"Category 4","Employee 4"]
[null,"Category 5","Employee 5"]
[null,"Category 6","Employee 6"]