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

{"sheet":"Project Tracker","index":0,"n_rows":13,"n_cols":15,"rows_kept":13}
[null,"Project Tracker"]
[null,null,"Percentage Over/Under to Flag: ",{"v":0.25,"d":"25%"}]
[]
[null,"Project","Category","Assigned To","Estimated\nStart","Estimated \nFinish","Estimated Work (in hours)","Estimated Duration (in days)","Actual \nStart","Actual\nFinish","Flag icon for Over/Under Actual Work (in hours)","Actual Work (in hours)","Flag icon for Over/Under Actual Duration (in days)","Actual Duration (in days)","Notes"]
[null,"Project 1","Category 1","Employee 1",{"$f":"TODAY()-65","v":"2017-08-29"},{"$f":"TODAY()-5","v":"2017-10-28"},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":"2017-08-29"},{"$f":"TODAY()","v":"2017-11-02"},{"$f":"IFERROR(IF(ProjectTracker[Actual Work (in hours)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Work (in hours)]]-ProjectTracker[[#This Row],[Estimated Work (in hours)]])/ProjectTracker[[#This Row],[Estimated Work (in hours)]])>FlagPercentage,1,0)),\"\")","v":1},300,{"$f":"IFERROR(IF(ProjectTracker[Actual Duration (in days)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Duration (in days)]]-ProjectTracker[[#This Row],[Estimated Duration (in days)]])/ProjectTracker[[#This Row],[Estimated Duration (in days)]])>FlagPercentage,1,0)),\"\")","v":0},{"$f":"IF(COUNTA('Project Tracker'!$I5,'Project Tracker'!$J5)<>2,\"\",DAYS360('Project Tracker'!$I5,'Project Tracker'!$J5,FALSE))","v":63}]
[null,"Project 2","Category 2","Employee 4",{"$f":"TODAY()-41","v":"2017-09-22"},{"$f":"TODAY()-10","v":"2017-10-23"},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":"2017-09-22"},{"$f":"TODAY()-7","v":"2017-10-26"},{"$f":"IFERROR(IF(ProjectTracker[Actual Work (in hours)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Work (in hours)]]-ProjectTracker[[#This Row],[Estimated Work (in hours)]])/ProjectTracker[[#This Row],[Estimated Work (in hours)]])>FlagPercentage,1,0)),\"\")","v":0},390,{"$f":"IFERROR(IF(ProjectTracker[Actual Duration (in days)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Duration (in days)]]-ProjectTracker[[#This Row],[Estimated Duration (in days)]])/ProjectTracker[[#This Row],[Estimated Duration (in days)]])>FlagPercentage,1,0)),\"\")","v":0},{"$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":"2017-07-25"},{"$f":"TODAY()-40","v":"2017-09-23"},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":"2017-07-25"},{"$f":"TODAY()-27","v":"2017-10-06"},{"$f":"IFERROR(IF(ProjectTracker[Actual Work (in hours)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Work (in hours)]]-ProjectTracker[[#This Row],[Estimated Work (in hours)]])/ProjectTracker[[#This Row],[Estimated Work (in hours)]])>FlagPercentage,1,0)),\"\")","v":0},500,{"$f":"IFERROR(IF(ProjectTracker[Actual Duration (in days)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Duration (in days)]]-ProjectTracker[[#This Row],[Estimated Duration (in days)]])/ProjectTracker[[#This Row],[Estimated Duration (in days)]])>FlagPercentage,1,0)),\"\")","v":0},{"$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":"2017-08-04"},{"$f":"TODAY()-80","v":"2017-08-14"},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":"2017-08-04"},{"$f":"TODAY()-71","v":"2017-08-23"},{"$f":"IFERROR(IF(ProjectTracker[Actual Work (in hours)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Work (in hours)]]-ProjectTracker[[#This Row],[Estimated Work (in hours)]])/ProjectTracker[[#This Row],[Estimated Work (in hours)]])>FlagPercentage,1,0)),\"\")","v":0},276,{"$f":"IFERROR(IF(ProjectTracker[Actual Duration (in days)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Duration (in days)]]-ProjectTracker[[#This Row],[Estimated Duration (in days)]])/ProjectTracker[[#This Row],[Estimated Duration (in days)]])>FlagPercentage,1,0)),\"\")","v":1},{"$f":"IF(COUNTA('Project Tracker'!$I8,'Project Tracker'!$J8)<>2,\"\",DAYS360('Project Tracker'!$I8,'Project Tracker'!$J8,FALSE))","v":19}]
[null,"Project 5","Category 3","Employee 2",{"$f":"TODAY()-90","v":"2017-08-04"},{"$f":"TODAY()-50","v":"2017-09-13"},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":"2017-08-04"},{"$f":"TODAY()-44","v":"2017-09-19"},{"$f":"IFERROR(IF(ProjectTracker[Actual Work (in hours)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Work (in hours)]]-ProjectTracker[[#This Row],[Estimated Work (in hours)]])/ProjectTracker[[#This Row],[Estimated Work (in hours)]])>FlagPercentage,1,0)),\"\")","v":0},310,{"$f":"IFERROR(IF(ProjectTracker[Actual Duration (in days)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Duration (in days)]]-ProjectTracker[[#This Row],[Estimated Duration (in days)]])/ProjectTracker[[#This Row],[Estimated Duration (in days)]])>FlagPercentage,1,0)),\"\")","v":0},{"$f":"IF(COUNTA('Project Tracker'!$I9,'Project Tracker'!$J9)<>2,\"\",DAYS360('Project Tracker'!$I9,'Project Tracker'!$J9,FALSE))","v":45}]
[null,"Project 6","Category 4","Employee 4",{"$f":"TODAY()-60","v":"2017-09-03"},{"$f":"TODAY()-50","v":"2017-09-13"},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":"2017-09-03"},{"$f":"TODAY()-45","v":"2017-09-18"},{"$f":"IFERROR(IF(ProjectTracker[Actual Work (in hours)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Work (in hours)]]-ProjectTracker[[#This Row],[Estimated Work (in hours)]])/ProjectTracker[[#This Row],[Estimated Work (in hours)]])>FlagPercentage,1,0)),\"\")","v":0},510,{"$f":"IFERROR(IF(ProjectTracker[Actual Duration (in days)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Duration (in days)]]-ProjectTracker[[#This Row],[Estimated Duration (in days)]])/ProjectTracker[[#This Row],[Estimated Duration (in days)]])>FlagPercentage,1,0)),\"\")","v":1},{"$f":"IF(COUNTA('Project Tracker'!$I10,'Project Tracker'!$J10)<>2,\"\",DAYS360('Project Tracker'!$I10,'Project Tracker'!$J10,FALSE))","v":15}]
[null,"Project 7","Category 5","Employee 1",{"$f":"TODAY()-44","v":"2017-09-19"},{"$f":"TODAY()-20","v":"2017-10-13"},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":"2017-09-19"},{"$f":"TODAY()-15","v":"2017-10-18"},{"$f":"IFERROR(IF(ProjectTracker[Actual Work (in hours)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Work (in hours)]]-ProjectTracker[[#This Row],[Estimated Work (in hours)]])/ProjectTracker[[#This Row],[Estimated Work (in hours)]])>FlagPercentage,1,0)),\"\")","v":0},790,{"$f":"IFERROR(IF(ProjectTracker[Actual Duration (in days)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Duration (in days)]]-ProjectTracker[[#This Row],[Estimated Duration (in days)]])/ProjectTracker[[#This Row],[Estimated Duration (in days)]])>FlagPercentage,1,0)),\"\")","v":0},{"$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":"2017-09-24"},{"$f":"TODAY()","v":"2017-11-02"},450,{"$f":"IF(COUNTA('Project Tracker'!$E12,'Project Tracker'!$F12)<>2,\"\",DAYS360('Project Tracker'!$E12,'Project Tracker'!$F12,FALSE))","v":38},{"$f":"TODAY()-45","v":"2017-09-18"},{"$f":"TODAY()-5","v":"2017-10-28"},{"$f":"IFERROR(IF(ProjectTracker[Actual Work (in hours)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Work (in hours)]]-ProjectTracker[[#This Row],[Estimated Work (in hours)]])/ProjectTracker[[#This Row],[Estimated Work (in hours)]])>FlagPercentage,1,0)),\"\")","v":0},430,{"$f":"IFERROR(IF(ProjectTracker[Actual Duration (in days)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Duration (in days)]]-ProjectTracker[[#This Row],[Estimated Duration (in days)]])/ProjectTracker[[#This Row],[Estimated Duration (in days)]])>FlagPercentage,1,0)),\"\")","v":0},{"$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","2016-02-05","2016-06-09",250,{"$f":"IF(COUNTA('Project Tracker'!$E13,'Project Tracker'!$F13)<>2,\"\",DAYS360('Project Tracker'!$E13,'Project Tracker'!$F13,FALSE))","v":124},"2016-03-05","2016-05-05",{"$f":"IFERROR(IF(ProjectTracker[Actual Work (in hours)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Work (in hours)]]-ProjectTracker[[#This Row],[Estimated Work (in hours)]])/ProjectTracker[[#This Row],[Estimated Work (in hours)]])>FlagPercentage,1,0)),\"\")","v":0},200,{"$f":"IFERROR(IF(ProjectTracker[Actual Duration (in days)]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[Actual Duration (in days)]]-ProjectTracker[[#This Row],[Estimated Duration (in days)]])/ProjectTracker[[#This Row],[Estimated Duration (in days)]])>FlagPercentage,1,0)),\"\")","v":1},{"$f":"IF(COUNTA('Project Tracker'!$I13,'Project Tracker'!$J13)<>2,\"\",DAYS360('Project Tracker'!$I13,'Project Tracker'!$J13,FALSE))","v":60}]

{"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"]