{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Setup","Diagnostics","Compare","proj1_data","proj2_data","Controls","Calendar","Calendar2","NamedRanges"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":204,"comments":3,"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":"Setup","index":0,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,1,20],[9,8,9,9],[9,10,9,15],[6,19,6,20],[6,17,6,18],[6,1,6,16],[4,1,4,16],[5,1,5,16],[4,17,4,18],[5,17,5,18],[22,8,22,9],[22,10,22,15],[32,1,32,3],[4,19,4,20],[5,19,5,20],[31,18,31,19],[17,8,17,9],[18,8,18,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[16,8,16,9],[15,8,15,9],[14,8,14,9],[22,18,22,19],[28,18,28,19],[29,18,29,19],[30,18,30,19],[23,18,23,19],[24,18,24,19],[25,18,25,19],[26,18,26,19],[27,18,27,19]]}
[null,"Setup"]
[]
[null,"Project / File Selection"]
[]
[null," File Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date  Modified",null,"Status Date"]
[]
[]
[null,"Slider Values - Working Days (wd)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Setup"]
[]
[null,0," Slider Note",null,null,null,null,null,"Value",null,"Choose Value",null,null,null,null,null,null,"Field Options (Not Available in Beta)"]
[null," Near Critical",null,null,null,null,null,null,18,null,null,null,null,null,null,null,null," WBS Field",null,null,"WBS"]
[null," Baseline Duration Threshold",null,null,null,null,null,null,16,null,null,null,null,null,null,null,null," Alternative Split Task Field",null,null,"Choose One"]
[null," Standard Duration",null,null,null,null,null,null,41,null,null,null,null,null,null,null,null," Field Used for Comparing Projects",null,null,"Unique ID"]
[null," Excessive Duration",null,null,null,null,null,null,57]
[null," Excessive Total Slack",null,null,null,null,null,null,27,null,null,null,null,null,null,null,null,"Run Options"]
[null," % Complete < 100 & Duration >",null,null,null,null,null,null,22,null,null,null,null,null,null,null,null," Check for Risk+ BC/ML/WC rDur",null,null,"No"]
[null," % Complete < 100 & Duration <",null,null,null,null,null,null,5,null,null,null,null,null,null,null,null," Include External Tasks?",null,null,"No"]
[null," Excessive Duration & Total Slack <=",null,null,null,null,null,null,12,null,null,null,null,null,null,null,null," Compute Data/Analysis Run Time?",null,null,"Yes"]
[null," # of Significant Preds/Successors",null,null,null,null,null,null,6,null,null,null,null,null,null,null,null," Analysis Mode (Single / Compare)",null,null,"Single"]
[]
[null,"Slider Values - Percentages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quick Analysis Overview"]
[]
[null,null,null,null,null,null,null,null,"Percent",null,"Choose Value",null,null,null,null,null,null,"Analysis Tests","Results",null,"Chart if Applicable"]
[null,"Tasks w/ Total Slack < X% of rDur",null,null,null,null,null,null,5,"%",null,null,null,null,null,null,null," Baseline Set?",{"$f":"IF(COUNT(Proj1_UniqID)=0,\"\",IF(COUNTIF(Proj1_BStart,\"<>NA\")>0,\"Set\",\"Not Set\"))","v":""}]
[null," % of Tasks w/ Finish Var < Start Var",null,null,null,null,null,null,8,"%",null,null,null,null,null,null,null," Status Date Set?",{"$f":"IF(COUNTA(Proj1_UniqID)=0,\"\",IF(proj1_data_statusdate>0,\"Set\",\"Not Set\"))","v":""}]
[null," % of Tasks w/  Finish Var > Start Var",null,null,null,null,null,null,24,"%",null,null,null,null,null,null,null," Activities",{"$f":"IF(COUNT(Proj1_UniqID)=0,\"\",COUNTIFS(proj1_dur,\">0\",proj1_summary,\"FALSE\",proj1_pctcomplete,\"<1\"))","v":""},null,{"$f":"S26/S26","v":{"$error":"#VALUE!"}}]
[null," % of Tasks w/  Finish Var > Total Slack",null,null,null,null,null,null,3,"%",null,null,null,null,null,null,null," Near Critical",{"$f":"IF(COUNT(Proj1_UniqID)=0,\"\",COUNTIFS(proj1_dur,\">0\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,\"<=\"&(setup_NearCritical),proj1_pctcomplete,\"<100\"))","v":""},null,{"$f":"S27/S26","v":{"$error":"#VALUE!"}}]
[null," % of Tasks w/  Start Var > Total Slack",null,null,null,null,null,null,7,"%",null,null,null,null,null,null,null," Critical",{"$f":"IF(COUNT(Proj1_UniqID)=0,\"\",COUNTIFS(proj1_dur,\">0\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,0,proj1_pctcomplete,\"<100\"))","v":""},null,{"$f":"S28/S26","v":{"$error":"#VALUE!"}}]
[null," % of Tasks w/ Split Parts",null,null,null,null,null,null,6,"%",null,null,null,null,null,null,null,{"$f":"IF(COUNT(Proj1_UniqID)=0,\" DCMA Correct (of 14)\",\" DCMA Correct (of \"&14-COUNTIF(DCMA_Results,\"N/A\")&\")\")","v":" DCMA Correct (of 14)"},{"$f":"IF(COUNTA(Proj1_UniqID)=0,\"\",IF(Diag_RunTime=\"\",\"Analyze 1st\",COUNTIF(DCMA_Count,1)))","v":""},null,{"$f":"S29/(15-COUNTIF(DCMA_Results,\"N/A\"))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Std Set Correct (of 15)",{"$f":"IF(COUNT(Proj1_UniqID)=0,\"\",IF(Diag_RunTime=\"\",\"Analyze 1st\",COUNTIF(StandardSetContigCount,1)))","v":""},null,{"$f":"S30/15","v":{"$error":"#VALUE!"}}]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(Proj1_UniqID)=0,\" All Correct (of 70)\",\" All Correct (of \"&70-COUNTIF(DCMA_Results,\"N/A\")&\")\")","v":" All Correct (of 70)"},{"$f":"IF(COUNT(Proj1_UniqID)=0,\"\",IF(Diag_RunTime=\"\",\"Analyze 1st\",COUNTIF(AllTest_Count,\">=0\")))","v":""},null,{"$f":"S31/(70-COUNTIF(DCMA_Results,\"N/A\"))","v":{"$error":"#VALUE!"}}]

{"sheet":"Diagnostics","index":1,"n_rows":102,"n_cols":13,"rows_kept":102,"cut":false,"hidden":false,"merged":[[2,5,2,6]]}
[null,null,null,null,null,null,null,null,true]
[null,null,0,null,null,null,null,"* Stoplight calculations and links to MS Project refer to activities only \n  (not to milestones or summaries).\n* Click on Stoplight to move comment box up and out of the way.",true]
[null,null,"Diagnostics",null,null,{"$f":"\"(\"&IF(Controls_IgnoreExtTest=1,\"Without\",\"With\")&\" Externals) \"","v":"(Without Externals) "},null,null,true]
[null,null,"Project Settings",null,null,null,"Result",null,true]
[null,null,{"$f":"IF(G5=\"Set\",1,-1)","v":-1},"Project Baseline Set?",null,null,{"$f":"IF(COUNTIFS(Proj1_BStart,\"<>NA\",Proj1_BStart,\"<>\")>0,\"Set\",\"Not Set\")","v":"Not Set"},"USN: Not Set is Unfavorable",true]
[null,null,{"$f":"IF(G6=\"\",-1,1)","v":1},"Project Status Date",null,null,{"$f":"IF(proj1_data!A1>0,proj1_data!A1,\"Not Set\")","v":"Not Set"},"USN: Not Set is Cautionary",true]
[null,null,0,"Analysis Run Time (Seconds)",null,null,null,null,true]
[0,null,0,"All Risk+ Durations Set?",null,null,{"$f":"IF(COUNTIF(Proj1_Dur1,\">0\")+COUNTIF(Proj1_Dur2,\">0\")+COUNTIF(Proj1_Dur3,\">0\")=3*Diag_TotalTasks,\"Yes\",\"No\")","v":"Yes"},null,false]
[0,null,{"$f":"IF(Setup_TUCheck=\"Yes\",-1,1)","v":-1},"Do Activities Have Dissimilar Time Units?",null,null,null,"GAO: Dissimilar Time Units are Cautionary",true]
[null,null,"Project Span",null,"Baseline","Forecast","Delta",null,true]
[null,null,0,"Project Start",{"$f":"IF($G$5=\"Not Set\",\"Set BL\",MIN(Proj1_BStart))","v":"Set BL"},{"$f":"MIN(IF(Proj1_ExtTask=FALSE,IF(Proj1_Start<>0,IF(Proj1_Start<>\"\",Proj1_Start))))","v":"00:00:00"},{"$f":"IFERROR(NETWORKDAYS(E11,F11,Calendar1_HolidaysImported)-1,\"NA\")","v":"NA"},null,true]
[null,null,0,"Project Finish",{"$f":"IF($G$5=\"Not Set\",\"Set BL\",MAX(proj1_bfinish))","v":"Set BL"},{"$f":"MAX(IF(Proj1_ExtTask=FALSE,Proj1_Fin))","v":"00:00:00"},{"$f":"IFERROR(NETWORKDAYS(E12,F12,Calendar1_HolidaysImported)-1,\"NA\")","v":"NA"},null,true]
[null,null,0,"Project Duration (d)",{"$f":"IF($G$5=\"Not Set\",\"Set BL\",NETWORKDAYS(E11,E12,Calendar1_HolidaysImported))","v":"Set BL"},{"$f":"NETWORKDAYS(F11,F12,Calendar1_HolidaysImported)","v":0},{"$f":"IFERROR(E13-F13,\"NA\")","v":"NA"},null,true]
[null,null,null,null,null,null,null,null,true]
[null,null,"Test Results",null,null,null,{"$f":"\"(\"&IF(Controls_IgnoreExtTest=1,\"Without\",\"With\")&\" Externals) \"","v":"(Without Externals) "},null,true]
[null,null,"Project Overview",null,"Milestones","Activities","Summaries",{"$f":"SUM(E17:G17)","v":0},true]
[null,null,0,"All Tasks",{"$f":"COUNTIFS(Proj1_MStone,TRUE,proj1_summary,\"FALSE\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,proj1_summary,\"FALSE\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(proj1_summary,\"TRUE\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"F18","v":0},true]
[null,null,0,"Incomplete Tasks",{"$f":"COUNTIFS(Proj1_MStone,TRUE,proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(proj1_summary,\"TRUE\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},null,true]
[null,null,{"$f":"IF(OR(F19>0.04*Diag_FcstDur,F19<0),-1,IF(AND(F19<=0.04*Diag_FcstDur,F19>=0.02*Diag_FcstDur),0,IF(F19<0.02*Diag_FcstDur,1)))","v":-1},"Average Total Slack",{"$f":"_xlfn.SINGLE(IFERROR(SUMIFS(proj1_totalslack,Proj1_MStone,TRUE,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\")/$F$18,\"\"))","v":""},{"$f":"_xlfn.SINGLE(IFERROR(SUMIFS(proj1_totalslack,Proj1_MStone,FALSE,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\")/$F$18,\"\"))","v":""},{"$f":"_xlfn.SINGLE(IFERROR(SUMIFS(proj1_totalslack,Proj1_MStone,FALSE,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"True\")/$F$18,\"\"))","v":""},{"$f":"\"Re Activities: <2% (\" & 0.02*Diag_FcstDur &\") of Project Dur'n is Favorable; 2-4% is OK, >4% (\" & 0.04*Diag_FcstDur & \") or < 0d is Unfavorable\"","v":"Re Activities: <2% (0) of Project Dur'n is Favorable; 2-4% is OK, >4% (0) or < 0d is Unfavorable"},true]
[null,null,{"$f":"IF(F20>0.02*Diag_FcstDur,-1,IF(AND(F20<=0.02*Diag_FcstDur,F20>=0.01*Diag_FcstDur),0,IF(F20<0.01*Diag_FcstDur,1)))","v":-1},"Average Duration",null,{"$f":"_xlfn.SINGLE(IFERROR(AVERAGEIFS(proj1_dur,Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,\"FALSE\",proj1_dur,\"<>\"\"\"),\"\"))","v":""},{"$f":"_xlfn.SINGLE(IFERROR(AVERAGEIFS(proj1_dur,Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"True\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")),\"\"))","v":""},{"$f":"\"Re Activities: <1% (\" & 0.01*Diag_FcstDur &\") of Project Dur'n is Favorable; 1-2% is OK, >2% (\" & 0.02*Diag_FcstDur & \") is Unfavorable\"","v":"Re Activities: <1% (0) of Project Dur'n is Favorable; 1-2% is OK, >2% (0) is Unfavorable"},true]
[null,null,{"$f":"IF(AND(F21>=2,F21<=10),1,-1)","v":-1},"Ratio of Activities to Milestones",null,{"$f":"IFERROR(Diag_TotalTasks/E18,\"\")","v":""},null,"Re Activities:  GAO: Between 2-10 is Favorable",true]
[null,null,"Slack & Criticality",null,"Milestones","Activities","Summaries"]
[0,null,0,"Critical Tasks",{"$f":"COUNTIFS(Proj1_MStone,TRUE,proj1_summary,\"FALSE\",proj1_totalslack,0,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,0,proj1_pctcomplete,\"<100\")","v":0},null,null,null,null,null,null,{"$f":"C23","v":0}]
[null,null,{"$f":"IF(F24>0,-1,1)","v":1},"Critical with Duration Variance < 0",{"$f":"SUMPRODUCT((proj1_totalslack=0)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(Proj1_DurVar<0)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((proj1_totalslack=0)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(Proj1_DurVar<0)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,"Re Activities: > 0 is Cautionary",null,null,{"$f":"IF(F24>0,-1,1)","v":1},{"$f":"K24","v":1},{"$f":"C24","v":1}]
[0,null,{"$f":"IF(F25>0,-1,1)","v":1},"Critical with Duration Variance > 0",{"$f":"SUMPRODUCT((proj1_totalslack=0)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(Proj1_DurVar>0)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((proj1_totalslack=0)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(Proj1_DurVar>0)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,"Re Activities: > 0 is Cautionary",null,null,null,{"$f":"K34","v":1},1]
[null,null,1,"Critical with Negative Finish Variance",{"$f":"SUMPRODUCT((proj1_totalslack=0)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(Proj1_FinVar<0)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((proj1_totalslack=0)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(Proj1_FinVar<0)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,"Re Activities: > 0 is Cautionary",null,null,null,{"$f":"K39","v":1},1]
[null,null,0,{"$f":"\"Near Critical Tasks, TS <= Selected (\"&setup_NearCritical&\"d)\"","v":"Near Critical Tasks, TS <= Selected (18d)"},{"$f":"COUNTIFS(Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,\"<=\"&setup_NearCritical,proj1_pctcomplete,\"<100\")","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,\"<=\"&setup_NearCritical,proj1_pctcomplete,\"<100\")","v":0},null,null,null,null,null,{"$f":"K45","v":1},0]
[null,null,{"$f":"IFERROR(IF((F28/Diag_TotalTasks)>0.05,-1,1),1)","v":1},{"$f":"\"Excessive Total Slack, TS >= Selected (\"&Setup_ExcessSlack&\"d)\"","v":"Excessive Total Slack, TS >= Selected (27d)"},{"$f":"COUNTIFS(Proj1_MStone,TRUE,proj1_summary,\"FALSE\",proj1_totalslack,\">=\"&Setup_ExcessSlack,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,\">=\"&Setup_ExcessSlack,proj1_pctcomplete,\"<100\")","v":0},null,{"$f":"\"Re Activities: USN: > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"Re Activities: USN: > 5% (0) is Unfavorable"},null,null,null,{"$f":"K46","v":1},1]
[null,null,{"$f":"IFERROR(IF(F29/Diag_TotalTasks>0.05,-1,1),1)","v":1},{"$f":"\"Non-critical with TS < Selected % of rDur (\" & Setup_TSLessRemDur &\"%)\"","v":"Non-critical with TS < Selected % of rDur (5%)"},null,{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,\">=\"&Setup_TSLessRemDur,proj1_pctcomplete,\"<100\")","v":0},null,{"$f":"\"Re Activities: USN: > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"Re Activities: USN: > 5% (0) is Unfavorable"},null,null,null,{"$f":"K56","v":-1},1]
[null,null,"Constraints",null,"Milestones","Activities","Summaries",null,null,null,null,{"$f":"K57","v":-1},{"$f":"C31","v":0}]
[null,null,{"$f":"IFERROR(IF(F31/$F$18>0.05,-1,1),0)","v":0},"ALAP Tasks",{"$f":"SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=1)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=1)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,{"$f":"\"Re Activities: > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Cautionary\"","v":"Re Activities: > 5% (0) is Cautionary"},null,null,null,{"$f":"K64","v":-1},{"$f":"C32","v":0}]
[null,null,{"$f":"IFERROR(IF(F32/$F$18<0.95,-1,1),0)","v":0},"ASAP Tasks",{"$f":"SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,{"$f":"\"Re Activities: < 95% (\"&ROUND(Diag_TotalTasks*0.95,0)&\") is Cautionary\"","v":"Re Activities: < 95% (0) is Cautionary"},null,null,null,{"$f":"K70","v":1},0]
[0,null,{"$f":"IFERROR(IF(F33/$F$18>0.05,-1,1),0)","v":0},"FNET Tasks",{"$f":"SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=6)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=6)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=6)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))","v":0},{"$f":"\"Re Activities: USN: > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"Re Activities: USN: > 5% (0) is Unfavorable"},null,null,null,{"$f":"K78","v":1},1]
[0,null,{"$f":"IF(F34>0,-1,1)","v":1},"FNLT Tasks",{"$f":"SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=7)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=7)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=7)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))","v":0},"Re Activities:  > 0 is Cautionary",null,null,{"$f":"IF(F34>0,-1,1)","v":1},{"$f":"K79","v":1},1]
[0,null,{"$f":"IF(F35>0,-1,1)","v":1},"MFO Tasks",{"$f":"SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=3)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=3)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=3)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))","v":0},"Re Activities:  > 0 is Cautionary",null,null,null,1,1]
[null,null,{"$f":"IF(F36>0,-1,1)","v":1},"MSO Tasks",{"$f":"SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=2)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=2)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=2)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))","v":0},"Re Activities:  > 0 is Cautionary",null,null,null,1,1]
[null,null,{"$f":"IF(F37>0,-1,1)","v":1},"SNLT Tasks",{"$f":"SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=5)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=5)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=5)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))","v":0},"Re Activities:  > 0 is Cautionary",null,null,null,{"$f":"K82","v":1},0]
[null,null,{"$f":"IFERROR(IF(F38/$F$18>0.05,-1,1),0)","v":0},"SNET Tasks",{"$f":"SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=4)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=4)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=4)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))","v":0},{"$f":"\"Re Activities: USN: > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"Re Activities: USN: > 5% (0) is Unfavorable"},null,null,null,null,1]
[null,null,{"$f":"IF(F39>0,-1,1)","v":1},"Deadline Tasks",{"$f":"SUMPRODUCT((Proj1_MStone=TRUE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_deadline<>\"NA\")*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_deadline<>\"NA\")*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_deadline<>\"NA\")*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))","v":0},"Re Activities:  > 0 is Cautionary",null,null,{"$f":"IF(F39>0,-1,1)","v":1},null,{"$f":"C41","v":0}]
[null,null,"Relationships, Predecessors, Successors",null,"Milestones","Activities","Summaries",null,null,null,null,null,{"$f":"C42","v":0}]
[0,null,{"$f":"IFERROR(IF(F41/Diag_TotalTasks>0.1,-1,1),0)","v":0},"Finish-Finish Tasks",{"$f":"SUMPRODUCT(((LEN(proj1_succs)-LEN(SUBSTITUTE(proj1_succs,\"FF\",\"\")))*1>0)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT(((LEN(proj1_succs)-LEN(SUBSTITUTE(proj1_succs,\"FF\",\"\")))*1>0)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,{"$f":"\"Re Activities: > 10% (\"&ROUND(Diag_TotalTasks*0.1,0)&\")  is Cautionary\"","v":"Re Activities: > 10% (0)  is Cautionary"},null,null,null,null,0]
[null,null,{"$f":"IFERROR(IF(F42/Diag_TotalTasks>0.1,-1,1),0)","v":0},"Start-Start Tasks",{"$f":"SUMPRODUCT(((LEN(proj1_succs)-LEN(SUBSTITUTE(proj1_succs,\"SS\",\"\")))*1>0)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT(((LEN(proj1_succs)-LEN(SUBSTITUTE(proj1_succs,\"SS\",\"\")))*1>0)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,{"$f":"\"Re Activities: > 10% (\"&ROUND(Diag_TotalTasks*0.1,0)&\")  is Cautionary\"","v":"Re Activities: > 10% (0)  is Cautionary"},null,null,null,null,0]
[0,null,{"$f":"IFERROR(IF(F43/Diag_TotalTasks>0.9,1,-1),0)","v":0},"Finish-Start Tasks",{"$f":"(COUNTIFS(proj1_preds,\"<>*FF*\",proj1_preds,\"<>*SS*\",proj1_preds,\"<>*SF*\",proj1_preds,\"<>\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,FALSE,Proj1_MStone,TRUE))","v":0},{"$f":"(COUNTIFS(proj1_preds,\"<>*FF*\",proj1_preds,\"<>*SS*\",proj1_preds,\"<>*SF*\",proj1_preds,\"<>\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,FALSE,Proj1_MStone,FALSE))","v":0},null,{"$f":"\"Re Activities: > 90% (\"&ROUND(Diag_TotalTasks*0.9,0)&\")  is Favorable\"","v":"Re Activities: > 90% (0)  is Favorable"},null,null,null,null,{"$f":"C45","v":1}]
[0,null,{"$f":"IFERROR(IF(F44/Diag_TotalTasks>0.05,-1,1),0)","v":0},"Start-Finish Tasks",{"$f":"COUNTIFS(proj1_preds,\"*SF*\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,FALSE,Proj1_MStone,TRUE)","v":0},{"$f":"COUNTIFS(proj1_preds,\"*SF*\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,FALSE,Proj1_MStone,FALSE)","v":0},null,{"$f":"\"Re Activities: > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\")  is Unfavorable\"","v":"Re Activities: > 5% (0)  is Unfavorable"},null,null,null,null,{"$f":"C46","v":1}]
[0,null,{"$f":"IF(F45>0,-1,1)","v":1},"No Predecessor Tasks",{"$f":"SUMPRODUCT((proj1_preds=\"\")*(Proj1_MStone=TRUE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((proj1_preds=\"\")*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,"Re Activities: > 0 is Unfavorable",null,null,{"$f":"IF(F45>0,-1,1)","v":1},null,1]
[0,null,{"$f":"IF(F46>0,-1,1)","v":1},"No Successor Tasks",{"$f":"SUMPRODUCT((proj1_succs=\"\")*(Proj1_MStone=TRUE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((proj1_succs=\"\")*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,"Re Activities: > 0 is Unfavorable",null,null,{"$f":"IF(F46>0,-1,1)","v":1},null,{"$f":"C48","v":1}]
[0,null,{"$f":"IF(F47>0,-1,1)","v":1},{"$f":"\"Number of Predecessors > Selected (\"&setup_sigpredsucc&\")\"","v":"Number of Predecessors > Selected (6)"},{"$f":"COUNTIFS(Proj1_MStone,TRUE,proj1_predcount,\">\"&setup_sigpredsucc,proj1_summary,FALSE,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,proj1_predcount,\">\"&setup_sigpredsucc,proj1_summary,FALSE,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,proj1_predcount,\">\"&setup_sigpredsucc,proj1_summary,TRUE,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},"Re Activities: > 0 is Cautionary",null,null,null,null,{"$f":"C50","v":-1}]
[null,null,{"$f":"IF(F48>0,-1,1)","v":1},{"$f":"\"Number of Successors > Selected (\"&setup_sigpredsucc&\")\"","v":"Number of Successors > Selected (6)"},{"$f":"COUNTIFS(Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_succscount,\">\"&setup_sigpredsucc,proj1_summary,FALSE,proj1_pctcomplete,\"<100\")","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_succscount,\">\"&setup_sigpredsucc,proj1_summary,FALSE)","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_succscount,\">\"&setup_sigpredsucc,proj1_summary,TRUE)","v":0},"Re Activities: > 0 is Cautionary",null,null,null,null,{"$f":"C51","v":1}]
[null,null,"Start & Finish Related Tests",null,"Milestones","Activities","Summaries",null,null,null,null,null,{"$f":"C52","v":1}]
[null,null,{"$f":"IF(F50<=(Diag_TotalTasks*0.05),1,-1)","v":-1},"Finish > Baseline Finish",{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((Proj1_Fin>proj1_bfinish)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((Proj1_Fin>proj1_bfinish)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},null,{"$f":"\"Re Activities: <= 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Favorable\"","v":"Re Activities: <= 5% (0) is Favorable"},null,null,null,null,-1]
[null,null,{"$f":"IF(F51>=($F$18*0.95),1,-1)","v":1},"Finish < Baseline Finish",{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((Proj1_Fin<proj1_bfinish)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((Proj1_Fin<proj1_bfinish)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},null,{"$f":"\"Re Activities: >= 95% (\"&ROUND(Diag_TotalTasks*0.95,0)&\") is Favorable\"","v":"Re Activities: >= 95% (0) is Favorable"},null,null,null,null,-1]
[null,null,{"$f":"IF(F52>=($F$18*0.95),1,-1)","v":1},"Start < Baseline Start",{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((Proj1_Start<Proj1_BStart)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((Proj1_Start<Proj1_BStart)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},null,{"$f":"\"Re Activities: >= 95% (\"&ROUND(Diag_TotalTasks*0.95,0)&\") is Favorable\"","v":"Re Activities: >= 95% (0) is Favorable"},null,null,null,null,-1]
[null,null,{"$f":"IF(F53<=(F27*0.05),1,-1)","v":-1},"Start > Baseline Start",{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((Proj1_Start>Proj1_BStart)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((Proj1_Start>Proj1_BStart)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},null,{"$f":"\"Re Activities: <= 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Favorable\"","v":"Re Activities: <= 5% (0) is Favorable"},null,null,null,null,{"$f":"C58","v":1}]
[null,null,{"$f":"IF(F54>0,-1,1)","v":-1},{"$f":"\"Tasks with % Complete = 100 & Finish > \" &\nIF(Setup_StatusDateP1=\"\", \"No Status Date Set\", TEXT(Setup_StatusDateP1,\"mm-dd-yy\"))","v":"Tasks with % Complete = 100 & Finish > No Status Date Set"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete=100)*(Proj1_Fin>proj1_data_statusdate)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"No Stat Date"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete=100)*(Proj1_Fin>proj1_data_statusdate)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"No Stat Date"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete=100)*(Proj1_Fin>proj1_data_statusdate)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"true\",proj1_summary)))))","v":"No Stat Date"},"Re Activities:  > 0 is Cautionary",null,null,null,null,{"$f":"C59","v":1}]
[null,null,-1,{"$f":"\"Tasks with % Complete = 0 & Start < \" &\nIF(Setup_StatusDateP1=\"\", \"No Status Date Set\", TEXT(Setup_StatusDateP1,\"mm-dd-yy\"))","v":"Tasks with % Complete = 0 & Start < No Status Date Set"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete=0)*(Proj1_Start<proj1_data_statusdate)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"No Stat Date"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete=0)*(Proj1_Start<proj1_data_statusdate)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"No Stat Date"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete=0)*(Proj1_Start<proj1_data_statusdate)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"true\",proj1_summary)))))","v":"No Stat Date"},"Re Activities:  > 0 is Unfavorable",null,null,null,null,{"$f":"C60","v":0}]
[null,null,-1,{"$f":"\"Tasks with % Complete < 100 & Finish > \" &\nIF(Setup_StatusDateP1=\"\", \"No Status Date Set\", TEXT(Setup_StatusDateP1,\"mm-dd-yy\"))","v":"Tasks with % Complete < 100 & Finish > No Status Date Set"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete<100)*(Proj1_Fin>proj1_data_statusdate)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"No Stat Date"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete<100)*(Proj1_Fin>proj1_data_statusdate)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"No Stat Date"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete<100)*(proj1_pctcomplete<>0)*(Proj1_Fin>proj1_data_statusdate)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"true\",proj1_summary)))))","v":"No Stat Date"}," Re Activities: > 0 is Cautionary",null,null,{"$f":"IF(F56>0,-1,1)","v":-1},null,{"$f":"C66","v":-1}]
[null,null,-1,{"$f":"\"Tasks with % Complete > 0 & Start > \" &\nIF(Setup_StatusDateP1=\"\", \"No Status Date Set\", TEXT(Setup_StatusDateP1,\"mm-dd-yy\"))","v":"Tasks with % Complete > 0 & Start > No Status Date Set"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete>0)*(proj1_pctcomplete<100)*(Proj1_Start>proj1_data_statusdate)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"No Stat Date"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete>0)*(proj1_pctcomplete<100)*(Proj1_Start>proj1_data_statusdate)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"No Stat Date"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",SUMPRODUCT((proj1_pctcomplete>0)*(Proj1_Start>proj1_data_statusdate)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"true\",proj1_summary)))))","v":"No Stat Date"},"Re Activities:  > 0 is Cautionary",null,null,{"$f":"IF(F57>0,-1,1)","v":-1},null,{"$f":"C67","v":1}]
[null,null,1,{"$f":"\"Tasks with % Complete < 100 & Duration > Selected (\"&setup_PctLessDurGreater&\"d)\"","v":"Tasks with % Complete < 100 & Duration > Selected (22d)"},{"$f":"COUNTIFS(Proj1_MStone,TRUE,proj1_pctcomplete,\"<100\",proj1_summary,\"FALSE\",proj1_dur,\">\"&(setup_PctLessDurGreater),Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,\"FALSE\",proj1_dur,\">\"&(setup_PctLessDurGreater))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,\"true\",proj1_dur,\">\"&(setup_PctLessDurGreater))","v":0},"Re Activities: > 0 is Cautionary",null,null,null,null,0]
[null,null,1,{"$f":"\"Tasks with % Complete < 100 & Duration <= Selected (\"&setup_PctLessDurLess&\"d)\"","v":"Tasks with % Complete < 100 & Duration <= Selected (5d)"},{"$f":"COUNTIFS(Proj1_MStone,TRUE,proj1_pctcomplete,\"<100\",proj1_summary,\"FALSE\",proj1_dur,\"<=\"&(setup_PctLessDurLess),Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,\"FALSE\",proj1_dur,\"<=\"&(setup_PctLessDurLess))","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"TRUE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,\"FALSE\",proj1_dur,\"<=\"&(setup_PctLessDurLess))","v":0},"Re Activities: > 0 is Cautionary",null,null,null,null,0]
[null,null,{"$f":"IFERROR(IF((F60/F$18)>(FinVar_Less_StartVar/100),-1,1),0)","v":0},{"$f":"\"Tasks with Finish Variance < Start Variance\"","v":"Tasks with Finish Variance < Start Variance"},{"$f":"SUMPRODUCT((Proj1_FinVar<Proj1_StartVar)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_FinVar<Proj1_StartVar)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_FinVar<Proj1_StartVar)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"true\",proj1_summary))))","v":0},{"$f":"\"Re Activities: > \"&FinVar_Less_StartVar&\"% (\"&ROUND(Diag_TotalTasks*(FinVar_Less_StartVar/100),0)&\") is Unfavorable\"","v":"Re Activities: > 8% (0) is Unfavorable"},null,null,null,null,0]
[null,null,{"$f":"IFERROR(IF((F61/F$18)>FinVar_More_StartVar/100,-1,1),0)","v":0},{"$f":"\"Tasks with Finish Variance > Start Variance\"","v":"Tasks with Finish Variance > Start Variance"},{"$f":"SUMPRODUCT((Proj1_FinVar>Proj1_StartVar)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_FinVar>Proj1_StartVar)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_FinVar>Proj1_StartVar)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"true\",proj1_summary))))","v":0},{"$f":"\"Re Activities: > \"&FinVar_More_StartVar&\"% (\"&ROUND(Diag_TotalTasks*(FinVar_More_StartVar/100),0)&\") is Cautionary\"","v":"Re Activities: > 24% (0) is Cautionary"},null,null,null,null,{"$f":"C56","v":-1}]
[null,null,{"$f":"IFERROR(IF((F62/F$18)>(FInVar_More_TSlack/100),-1,1),0)","v":0},{"$f":"\"Tasks with Finish Variance > Total Slack\"","v":"Tasks with Finish Variance > Total Slack"},{"$f":"SUMPRODUCT((Proj1_FinVar>proj1_totalslack)*(Proj1_MStone=TRUE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_FinVar>proj1_totalslack)*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,{"$f":"\"Re Activities: > \"&FInVar_More_TSlack&\"% (\"&ROUND(Diag_TotalTasks*(FInVar_More_TSlack/100),0)&\") is Cautionary\"","v":"Re Activities: > 3% (0) is Cautionary"},null,null,null,null,{"$f":"C57","v":-1}]
[null,null,{"$f":"IFERROR(IF((F63/F$18)>(StartVar_More_TSlack/100),-1,1),0)","v":0},{"$f":"\"Tasks with Start Variance > Total Slack\"","v":"Tasks with Start Variance > Total Slack"},{"$f":"SUMPRODUCT((Proj1_StartVar>proj1_totalslack)*(Proj1_MStone=TRUE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj1_StartVar>proj1_totalslack)*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,{"$f":"\"Re Activities: > \"&StartVar_More_TSlack&\"% (\"&ROUND(Diag_TotalTasks*(StartVar_More_TSlack/100),0)&\") is Cautionary\"","v":"Re Activities: > 7% (0) is Cautionary"},null,null,null,null,{"$f":"C64","v":-1}]
[null,null,{"$f":"IF(F64>0,-1,1)","v":-1},"No Baseline Finish Set",{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((proj1_bfinish=\"NA\")*(Proj1_MStone=TRUE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((proj1_bfinish=\"NA\")*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((proj1_bfinish=\"NA\")*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"true\",proj1_summary)))))","v":"BL Not Set"},"Re Activities: > 0 is Cautionary",null,null,{"$f":"IF(F64>0,-1,1)","v":-1},null,{"$f":"C68","v":-1}]
[null,null,"Duration",null,"Milestones","Activities","Summaries",null,null,null,null,null,-1]
[null,null,{"$f":"IF(F66>0,-1,1)","v":-1},"Activities with Baseline Dur'n = 0",null,{"$f":"_xlfn.SINGLE(IF(SUM(proj1_bdur)=0,\"BL Not Set\",COUNTIFS(proj1_bdur,\"0\",proj1_summary,FALSE,proj1_pctcomplete,\"<100\",Proj1_MStone,FALSE,Proj1_ExtTask,FALSE)))","v":"BL Not Set"},null,"Re Activities: USN: > 0 is Unfavorable",null,null,null,null,0]
[0,null,{"$f":"IF(F67>0,-1,1)","v":1},"Estimated Durations",null,{"$f":"COUNTIFS(proj1_summary,FALSE,proj1_estdur,TRUE,Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\")","v":0},null,"Re Activities:  USN: > 0 is Cautionary",null,null,null,null,1]
[null,null,{"$f":"IF(F68>0,-1,1)","v":-1},"Duration > Baseline Duration",{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((proj1_dur>proj1_bdur)*(proj1_pctcomplete<100)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((proj1_dur>proj1_bdur)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((proj1_dur>proj1_bdur)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"true\",proj1_summary)))))","v":"BL Not Set"},"Re Activities:  > 0 is Cautionary",null,null,null,null,1]
[null,null,{"$f":"IF(F69=\"BL Not Set\",-1,IF(F69/$F$18>0.05,-1,1))","v":-1},{"$f":"\"Baseline Dur'n > Excessive Dur'n Selected (\"&Setup_DurExcess&\"d)\"","v":"Baseline Dur'n > Excessive Dur'n Selected (57d)"},null,{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",SUMPRODUCT((proj1_bdur>Setup_DurExcess)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))))","v":"BL Not Set"},null,{"$f":"\"Re Activities: USN: > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"Re Activities: USN: > 5% (0) is Unfavorable"},null,null,null,null,1]
[null,null,{"$f":"IFERROR(IF(F70/$F$18>0.25,-1,1),0)","v":0},{"$f":"\"Forecast Dur'n > Excessive Dur'n Selected (\"&Setup_DurExcess&\"d)\"","v":"Forecast Dur'n > Excessive Dur'n Selected (57d)"},null,{"$f":"SUMPRODUCT((proj1_dur>Setup_DurExcess)*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,{"$f":"\"Re Activities: USN: > 25% (\"&ROUND(Diag_TotalTasks*0.25,0)&\") is Unfavorable\"","v":"Re Activities: USN: > 25% (0) is Unfavorable"},null,null,{"$f":"IF(F70=0,1,IF((F70/$F$18)>0.25,-1,1))","v":1},null,1]
[null,null,{"$f":"IF(F71>0,-1,1)","v":1},{"$f":"\"Dur'n > Standard Dur'n Selected (\"&Setup_StdDur&\"d)\"","v":"Dur'n > Standard Dur'n Selected (41d)"},null,{"$f":"SUMPRODUCT((proj1_dur>Setup_StdDur)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null," Re Activities: > 0 is Cautionary",null,null,null,null,{"$f":"C75","v":-1}]
[0,null,{"$f":"IF(F72>0,-1,1)","v":1},{"$f":"\"Dur'n > 10% (\" & 0.1*Diag_FcstDur &\"d) of Project Forecast Dur'n\"","v":"Dur'n > 10% (0d) of Project Forecast Dur'n"},null,{"$f":"SUMPRODUCT((proj1_dur>Diag_FcstDur*0.1)*(proj1_pctcomplete<100)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,"Re Activities:  > 0 is Cautionary",null,null,null,null,{"$f":"C77","v":-1}]
[null,null,{"$f":"IF(E73<=0,1,-1)","v":1},"Milestone Dur'n > 0d",{"$f":"COUNTIFS(Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,FALSE,Proj1_MStone,TRUE,proj1_dur,\">0\")","v":0},null,null,"> 0 is Cautionary",null,null,null,null,{"$f":"C78","v":1}]
[null,null,{"$f":"IF(F74>0,-1,1)","v":1},{"$f":"\"Dur'n Excessive (>= \"&Setup_DurExcess&\"d) & (TS <= \"&Setup_DurExcessTSLess&\"d)\"","v":"Dur'n Excessive (>= 57d) & (TS <= 12d)"},null,{"$f":"COUNTIFS(proj1_dur,\">=\"&Setup_DurExcess,proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",proj1_totalslack,\"<=\"&Setup_DurExcessTSLess,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(proj1_dur,\">=\"&Setup_DurExcess,proj1_summary,\"True\",proj1_pctcomplete,\"<100\",proj1_totalslack,\"<=\"&Setup_DurExcessTSLess,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},"Re Activities: > 0 is Cautionary",null,null,null,null,{"$f":"C79","v":1}]
[0,null,{"$f":"IF(F75>0,-1,1)","v":-1},{"$f":"\"Baseline Dur'n > Selected (\"&Setup_BLDurThreshold&\"d)\"","v":"Baseline Dur'n > Selected (16d)"},null,{"$f":"_xlfn.SINGLE(IF(SUM(proj1_bdur)=0,\"BL Not Set\",COUNTIFS(proj1_bdur,\">\"&Setup_BLDurThreshold,Proj1_MStone,FALSE,proj1_summary,\"FALSE\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\")))","v":"BL Not Set"},{"$f":"_xlfn.SINGLE(IF(SUM(proj1_bdur)=0,\"BL Not Set\",COUNTIFS(proj1_bdur,\">\"&Setup_BLDurThreshold,Proj1_MStone,FALSE,proj1_summary,\"TRUE\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\")))","v":"BL Not Set"},"Re Activities: > 0 is Cautionary",null,null,null,null,1]
[null,null,"Other Tests",null,"Milestones","Activities","Summaries",null,null,null,null,null,1]
[0,null,{"$f":"IF(F77<=($F$18*0.05),1,-1)","v":-1},"Missed Tasks",{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",COUNTIFS(Proj1_MStone,TRUE,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",Proj1_Status,2))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",COUNTIFS(Proj1_MStone,FALSE,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",Proj1_Status,2))","v":"BL Not Set"},null,{"$f":"\"Re Activities: <= 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Favorable\"","v":"Re Activities: <= 5% (0) is Favorable"},null,null,null,null,{"$f":"C82","v":1}]
[null,null,{"$f":"IF(F78>0,-1,1)","v":1},"Duplicate Names (Longer Run Time)",{"$f":"COUNTIFS(Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,\"FALSE\",Proj1_Dups,\">1\")","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,\"FALSE\",Proj1_Dups,\">1\")","v":0},{"$f":"COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,\"TRUE\",Proj1_Dups,\">1\")","v":0},"Re Activities: USN: > 0 is Unfavorable",null,null,{"$f":"IF(F78>0,-1,1)","v":1},null,{"$f":"C83","v":0}]
[null,null,{"$f":"IF(F79>0,-1,1)","v":1},"Isolated Tasks",null,{"$f":"SUMPRODUCT((proj1_preds=\"\")*(proj1_succs=\"\")*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},null,"Re Activities: > 0 is Unfavorable",null,null,{"$f":"IF(F79>0,-1,1)","v":1},null,{"$f":"C87","v":-1}]
[null,null,{"$f":"IF(F80>0,-1,1)","v":1},"Missing WBS",{"$f":"SUMPRODUCT((OFFSET(OFFSET(proj1_data!$B$5,0,0,COUNTA(proj1_data!$B:$B)-1,1),,controls_proj1_wbsfield)=\"\")*(Proj1_MStone=TRUE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((OFFSET(OFFSET(proj1_data!$B$5,0,0,COUNTA(proj1_data!$B:$B)-1,1),,controls_proj1_wbsfield)=\"\")*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))+SUMPRODUCT((OFFSET(OFFSET(proj1_data!$B$5,0,0,COUNTA(proj1_data!$B:$B)-1,1),,controls_proj1_wbsfield)=\"<>*.*\")*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((OFFSET(OFFSET(proj1_data!$B$5,0,0,COUNTA(proj1_data!$B:$B)-1,1),,controls_proj1_wbsfield)=\"\")*(Proj1_MStone=FALSE)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))","v":0},"Re Activities: > 0 is Cautionary",null,null,{"$f":"IF(F80>0,-1,1)","v":1},null,{"$f":"C88","v":-1}]
[0,null,1,"Out of Sequence",{"$f":"SUMPRODUCT((proj1_totalslack<0)*(proj1_pctcomplete<100)*(proj1_pctcomplete>0)*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((proj1_totalslack<0)*(proj1_pctcomplete<100)*(proj1_pctcomplete>0)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((proj1_totalslack<0)*(proj1_pctcomplete<100)*(proj1_pctcomplete>0)*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"true\",proj1_summary))))","v":0},"Re Activities: > 0 is Unfavorable",null,null,1,null,{"$f":"C89","v":-1}]
[null,null,{"$f":"IF(G82>0,-1,1)","v":1},"Summary Tasks with Logic",null,null,{"$f":"SUMPRODUCT((proj1_preds<>\"\")*(proj1_succs=\"\")*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))+SUMPRODUCT((proj1_succs<>\"\")*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_preds=\"\")*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))+SUMPRODUCT((proj1_succs<>\"\")*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_preds<>\"\")*(ISNUMBER(SEARCH(\"TRUE\",proj1_summary))))","v":0},"USN: > 0 is Unfavorable",null,null,1,null,{"$f":"C90","v":1}]
[null,null,{"$f":"IFERROR(IF(F83=\"Not Chosen\",-1,IF((F83/F$18)>(setup_splittask_slider/100),-1,1)),0)","v":0},{"$f":"\"% of Tasks w/ Split Parts > Selected (\"&setup_splittask_slider&\"%)\"","v":"% of Tasks w/ Split Parts > Selected (6%)"},null,null,null,{"$f":"\"Re Activities: > \"&ROUND(Diag_TotalTasks*(setup_splittask_slider/100),0)&\" is Cautionary\"","v":"Re Activities: > 0 is Cautionary"},null,null,null,null,{"$f":"C91","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,-1]
[null,null,"DCMA Test Results",null,null,null,{"$f":"\"(\"&IF(Controls_IgnoreExtTest=1,\"Without\",\"With\")&\" Externals) \"","v":"(Without Externals) "},null,null,null,null,null,-1]
[null,null,"DCMA 14-Point Assessment Values (Re Activities)",null,"Milestones","Activities","% of Total",null,null,null,null,null,-1]
[null,null,{"$f":"IF(G87>0.05,-1,1)","v":-1},"DCMA Logic Check",{"$f":"IFERROR((SUMPRODUCT((proj1_preds=\"\")*(proj1_succs<>\"\")*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))+SUMPRODUCT((proj1_succs=\"\")*(proj1_preds<>\"\")*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))+SUMPRODUCT((proj1_preds=\"\")*(proj1_succs=\"\")*(Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))),\"\")","v":0},{"$f":"IFERROR((SUMPRODUCT((proj1_preds=\"\")*(proj1_succs<>\"\")*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))+SUMPRODUCT((proj1_succs=\"\")*(proj1_preds<>\"\")*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))+SUMPRODUCT((proj1_preds=\"\")*(proj1_succs=\"\")*(Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))),\"\")","v":0},{"$f":"IFERROR(F87/Diag_TotalTasks,\"\")","v":""},{"$f":"\"DCMA Check 1 of 14:  > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"DCMA Check 1 of 14:  > 5% (0) is Unfavorable"},null,null,{"$f":"IF(G87>0.05,-1,1)","v":-1},null,-1]
[null,null,{"$f":"IF(G88>0,-1,1)","v":-1},"DCMA Relationships with Lead",{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(proj1_summary,FALSE,Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_preds,\"*-*\"),\"\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(proj1_summary,FALSE,Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_preds,\"*-*\"),\"\"))","v":0},"","DCMA Check 2 of 14:  > 0% is Unfavorable",null,null,{"$f":"IF(G88>0,-1,1)","v":-1},null,-1]
[null,null,{"$f":"IF(G89>0.05,-1,1)","v":-1},"DCMA Relationships with Lag",{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(proj1_summary,FALSE,Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_preds,\"*+*\"),\"\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(proj1_summary,FALSE,Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_preds,\"*+*\"),\"\"))","v":0},"",{"$f":"\"DCMA Check 3 of 14:  > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"DCMA Check 3 of 14:  > 5% (0) is Unfavorable"},null,null,{"$f":"IF(G89>0.05,-1,1)","v":-1},null,-1]
[null,null,{"$f":"IFERROR(IF(G90>0.9,1,-1),0)","v":1},"DCMA Finish-Start Relationships",{"$f":"IFERROR((COUNTIFS(proj1_preds,\"<>*FF*\",proj1_preds,\"<>*SS*\",proj1_preds,\"<>*SF*\",proj1_preds,\"<>\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,FALSE,Proj1_MStone,TRUE)),\"\")","v":0},{"$f":"IFERROR((COUNTIFS(proj1_preds,\"<>*FF*\",proj1_preds,\"<>*SS*\",proj1_preds,\"<>*SF*\",proj1_preds,\"<>\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",proj1_summary,FALSE,Proj1_MStone,FALSE)),\"\")","v":0},"",{"$f":"\"DCMA Check 4 of 14:  >= 90% (\"&ROUND(Diag_TotalTasks*0.9,0)&\") is Favorable\"","v":"DCMA Check 4 of 14:  >= 90% (0) is Favorable"},null,null,-1,null,{"$f":"C99","v":-1}]
[0,null,{"$f":"IF(G91>0.05,-1,1)","v":-1},"DCMA Hard Constraints",{"$f":"IFERROR(SUM(E34:E37),\"\")","v":0},{"$f":"IFERROR(SUM(F34:F37),\"\")","v":0},"",{"$f":"\"DCMA Check 5 of 14:  > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"DCMA Check 5 of 14:  > 5% (0) is Unfavorable"},null,null,-1,null,{"$f":"C100","v":1}]
[null,null,-1,"DCMA High Total Slack (> 44d)",{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",proj1_totalslack,\">44\"),\"\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",proj1_totalslack,\">44\"),\"\"))","v":0},"",{"$f":"\"DCMA Check 6 of 14:  > 44d; > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"DCMA Check 6 of 14:  > 44d; > 5% (0) is Unfavorable"},null,null,-1,null,{"$f":"C101","v":1}]
[null,null,{"$f":"IF(G93>0,-1,1)","v":-1},"DCMA Negative Slack",{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",proj1_totalslack,\"<0\"),\"\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",proj1_totalslack,\"<0\"),\"\"))","v":0},"","DCMA Check 7 of 14:  > 0% is Unfavorable",null,null,-1]
[0,null,-1,"DCMA High Duration (>44d)",{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",proj1_dur,\">44\"),\"\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",proj1_dur,\">44\"),\"\"))","v":0},"",{"$f":"\"DCMA Check 8 of 14:  > 44d; > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"DCMA Check 8 of 14:  > 44d; > 5% (0) is Unfavorable"},null,null,-1]
[1,null,-1,"DCMA % Invalid Dates",{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",(SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))*(proj1_actualstart>proj1_data_statusdate)*(proj1_actualstart<>\"NA\")*(proj1_pctcomplete<100))))+SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))*(proj1_actualfin>proj1_data_statusdate)*(proj1_actualfin<>\"NA\")*(proj1_pctcomplete<100)))+SUMPRODUCT((Proj1_MStone=TRUE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))*(Proj1_EarlyStart<proj1_data_statusdate)*(proj1_pctcomplete<100))))","v":"No Stat Date"},{"$f":"IF(proj1_data_statusdate=0,\"No Stat Date\",(SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))*(proj1_actualstart>proj1_data_statusdate)*(proj1_actualstart<>\"NA\")*(proj1_pctcomplete<100))))+SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))*(proj1_actualfin>proj1_data_statusdate)*(proj1_actualfin<>\"NA\")*(proj1_pctcomplete<100)))+SUMPRODUCT((Proj1_MStone=FALSE)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))*(Proj1_EarlyStart<proj1_data_statusdate)*(proj1_pctcomplete<100))))","v":"No Stat Date"},"","DCMA Check 9 of 14:  > 0% is Unfavorable",null,null,-1]
[0,null,{"$f":"IF(G96>0,-1,1)","v":-1},"DCMA Missing Resource",{"$f":"_xlfn.SINGLE(IF(COUNTA(Proj1_Resources)=0,\"All\",COUNTIFS(Proj1_Resources,\"\",proj1_pctcomplete,\"<100\",Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\")))","v":"All"},{"$f":"_xlfn.SINGLE(IF(COUNTA(Proj1_Resources)=0,\"All\",COUNTIFS(Proj1_Resources,\"\",proj1_pctcomplete,\"<100\",Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\")))","v":"All"},"","DCMA Check 10 of 14:   > 0% is Unfavorable",null,null,{"$f":"IF(G96>0,-1,1)","v":-1}]
[0,null,{"$f":"IF(G97>0.05,-1,1)","v":-1},"DCMA Missed Tasks",{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",COUNTIFS(proj1_summary,FALSE,Proj1_MStone,TRUE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",Proj1_Status,2))","v":"BL Not Set"},{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",COUNTIFS(proj1_summary,FALSE,Proj1_MStone,FALSE,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_pctcomplete,\"<100\",Proj1_Status,2))","v":"BL Not Set"},"",{"$f":"\"DCMA Check 11 of 14:  > 5% (\"&ROUND(Diag_TotalTasks*0.05,0)&\") is Unfavorable\"","v":"DCMA Check 11 of 14:  > 5% (0) is Unfavorable"},null,null,{"$f":"IF(G97>0.05,-1,1)","v":-1}]
[null,null,null,null,null,null,"Index"]
[null,null,{"$f":"IF(G99>=1,1,-1)","v":-1},"DCMA Critical Path Test Index",null,null,{"$f":"CPTestOutput/-600","v":0},"DCMA Check 12 of 14:   >=1 is Favorable, <=1 is Unfavorable",null,null,{"$f":"IF(G99=1,1,-1)","v":-1}]
[null,null,{"$f":"IF(G100>0.95,1,-1)","v":1},"DCMA Critical Path Length Index",null,null,{"$f":"IFERROR((NETWORKDAYS(Proj1_CritMinStartDate,Proj1_CritMaxFinDate,Calendar1_HolidaysImported)+(MIN(IF((ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))),proj1_totalslack,\"\"))))/NETWORKDAYS(Proj1_CritMinStartDate,Proj1_CritMaxFinDate,Calendar1_HolidaysImported),\"N/A\")","v":"N/A"},"DCMA Check 13 of 14:   >= 0.95 is Favorable",null,null,{"$f":"IF(G100>0.95,1,-1)","v":1}]
[null,null,{"$f":"IF(G101<=0.95,-1,1)","v":1},"DCMA Baseline Execution Index",null,null,{"$f":"IF(SUM(proj1_bdur)=0,\"BL Not Set\",(Diag_TotalTasks-SUM(E97:F97))/Diag_TotalTasks)","v":"BL Not Set"},{"$f":"\"DCMA Check 14 of 14:  < 95% is Unfavorable\"","v":"DCMA Check 14 of 14:  < 95% is Unfavorable"},null,null,{"$f":"IF(E101>=0.95,1,-1)","v":-1}]
[null,null,null,null,null,null,null,null,true]

{"sheet":"Compare","index":2,"n_rows":100,"n_cols":20,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,true]
[null,null,0," Task Definitions",null,null,null,true]
[null,null,"Comparison Calculations",null,null,null,{"$f":"\"(\"&IF(Controls_IgnoreExtTest=1,\"Without\",\"With\")&\" Externals) \"","v":"(Without Externals) "},true]
[null,null,"Project Summary Fields",null,"Proj1","Proj2","Delta",true]
[null,null,"Duration"]
[null,null,{"$f":"IF(G6>0,\"p\",IF(G6=0,\"µ¶\",\"q\"))","v":"µ¶"},"Schedule Duration",{"$f":"IFERROR(NETWORKDAYS(MIN(IF(Proj1_ExtTask=FALSE,IF(Proj1_UniqID<>\"\",Proj1_Start))),MAX(IF(Proj1_ExtTask=FALSE,Proj1_Fin)),Calendar1_HolidaysImported),MIN(IF(Proj1_ExtTask=FALSE,IF(Proj1_Start<>0,IF(Proj1_Start<>\"\",Proj1_Start))))-MAX(IF(Proj1_ExtTask=FALSE,Proj1_Fin)))","v":0},{"$f":"IFERROR(NETWORKDAYS(MIN(IF(Proj2_ExtTask=FALSE,IF(Proj2_UniqID<>\"\",Proj2_Start))),MAX(IF(Proj2_ExtTask=FALSE,Proj2_Fin)),Calendar2_HolidaysImported),MIN(IF(Proj2_ExtTask=FALSE,IF(Proj2_Start<>0,IF(Proj2_Start<>\"\",Proj2_Start))))-MAX(IF(Proj2_ExtTask=FALSE,Proj2_Fin)))","v":0},{"$f":"F6-E6","v":0}]
[null,null,{"$error":"#VALUE!"},"Avg Activity Duration",{"$f":"_xlfn.SINGLE(IFERROR(AVERAGEIFS(proj1_dur,proj1_dur,\">0\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_dur,\"<>\"\"\"),\"\"))","v":""},{"$f":"_xlfn.SINGLE(IFERROR(AVERAGEIFS(Proj2_dur,Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"FALSE\",Proj2_dur,\"<>\"\"\"),\"\"))","v":""},{"$error":"#VALUE!"}]
[0,null,"µ¶","Activities with Duration > 44d",{"$f":"COUNTIFS(proj1_dur,\">44\",proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj2_dur,\">44\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},0]
[0,null,"µ¶","Activities with Duration > 100d",{"$f":"COUNTIFS(proj1_dur,\">100\",proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj2_dur,\">100\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},0]
[0,null,"µ¶",{"$f":"\"Activities with Duration > Excessive Duration (\"&Setup_DurExcess&\"d)\"","v":"Activities with Duration > Excessive Duration (57d)"},{"$f":"COUNTIFS(proj1_dur,\">\"&Setup_DurExcess,proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj2_dur,\">\"&Setup_DurExcess,Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},0]
[0,null,{"$f":"IF(G11>0,\"p\",IF(G11=0,\"µ¶\",\"q\"))","v":"µ¶"},"Milestones with Duration > 0",{"$f":"COUNTIFS(proj1_dur,\">0\",Proj1_MStone,TRUE,proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj2_dur,\">0\",Proj2_MStone,TRUE,Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},0]
[null,null,{"$f":"IF(G12>0,\"p\",IF(G12=0,\"µ¶\",\"q\"))","v":{"$error":"#VALUE!"}},"Avg Slack / Avg Dur Ratio",{"$f":"IFERROR(E18/E7,\"\")","v":""},{"$f":"IFERROR(F18/F7,\"\")","v":""},{"$error":"#VALUE!"}]
[0,null,"µ¶","Activities with Increased Duration",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_dur,\">\"&proj1_dur,Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_summary,\"FALSE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null,"µ¶","Activities with Decreased Duration",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_dur,\"<\"&proj1_dur,Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null,"µ¶","Activities with Increased Remaining Duration",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_remainingduration,\">\"&proj1_remainingduration,Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_summary,\"FALSE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null,"µ¶","Activities with Decreased Remaining Duration",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_remainingduration,\"<\"&proj1_remainingduration,Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_summary,\"FALSE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[null,null,"Activity Slack & Criticality",null,"P1","P2","Delta"]
[null,null,{"$f":"IF(G18>0,\"p\",IF(G18=0,\"µ¶\",\"q\"))","v":{"$error":"#VALUE!"}},"Total Slack per Activity",{"$f":"IFERROR(SUMIFS(proj1_totalslack,proj1_dur,\">0\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\")/Comp_tCount_p1,\"\")","v":""},{"$f":"IFERROR(SUMIFS(Proj2_totalslack,Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"FALSE\")/Comp_tCount_p2,\"\")","v":""},{"$f":"F18-E18","v":{"$error":"#VALUE!"}}]
[0,null,"µ¶","Activities with > 44d Total Slack",{"$f":"COUNTIFS(proj1_dur,\">0\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,\">44\")","v":0},{"$f":"COUNTIFS(Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"FALSE\",Proj2_totalslack,\">44\")","v":0},{"$f":"F19-E19","v":0}]
[0,null,"µ¶","Activities with > 100d Total Slack",{"$f":"COUNTIFS(proj1_dur,\">0\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,\">100\")","v":0},{"$f":"COUNTIFS(Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"FALSE\",Proj2_totalslack,\">100\")","v":0},{"$f":"F20-E20","v":0}]
[0,null,"µ¶",{"$f":"\"Activities with  Total Slack > Slider Selected \"& \"(\" &Setup_ExcessSlack&\")\"","v":"Activities with  Total Slack > Slider Selected (27)"},{"$f":"COUNTIFS(proj1_dur,\">0\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,\">\"&Setup_ExcessSlack)","v":0},{"$f":"COUNTIFS(Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"FALSE\",Proj2_totalslack,\">\"&Setup_ExcessSlack)","v":0},{"$f":"F21-E21","v":0}]
[0,null,"µ¶","Activities with Negative Slack",{"$f":"COUNTIFS(proj1_dur,\">0\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_totalslack,\"<0\")","v":0},{"$f":"COUNTIFS(Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"FALSE\",Proj2_totalslack,\"<0\")","v":0},{"$f":"F22-E22","v":0}]
[0,null," ","Activities with More Negative Slack",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_totalslack,\"<0\",Proj2_totalslack,\"<\"&proj1_totalslack,Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_summary,\"FALSE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_totalslack<0))","v":0}]
[0,null," ","Activities New to the Critical Path",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_totalslack,0, Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_summary,\"FALSE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_totalslack>0))","v":0}]
[0,null," ","Activities Retired from Critical Path",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_totalslack,\">0\",Proj2_dur, \">0\",Proj2_pctcomplete,\"<100\",Proj2_summary,\"FALSE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_totalslack=0))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(IF(COUNTA(Proj1_UniqID)=0,0,COUNTIFS(Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\"))))","v":0},{"$f":"_xlfn.SINGLE(IF(COUNTA(Proj2_UniqID)=0,0,COUNTIFS(Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\"))))","v":0}]
[0,null," ",{"$f":"\"Activities New to 'Near Critical' Path (TS <= \" & setup_NearCritical &\"d)\"","v":"Activities New to 'Near Critical' Path (TS <= 18d)"},null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_totalslack,\"<=\"&setup_NearCritical,Proj2_pctcomplete,\"<100\",Proj2_dur,\">0\",Proj2_summary,FALSE,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_totalslack>setup_NearCritical))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(IF(COUNTA(Proj1_UniqID)=0,0,IF(COUNTA(Proj1_Resources)=0,COUNTIFS(Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\")),(COUNTIFS(proj1_dur,\">0\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\"),proj1_summary,\"FALSE\")))))","v":0},{"$f":"_xlfn.SINGLE(IF(COUNTA(Proj2_UniqID)=0,0,IF(COUNTA(Proj2_Resources)=0,COUNTIFS(Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\")),(COUNTIFS(Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\"),Proj2_summary,\"FALSE\")))))","v":0}]
[0,null," ",{"$f":"\"Activities Retired From 'Near Critical' Path (TS <= \" & setup_NearCritical &\"d)\"","v":"Activities Retired From 'Near Critical' Path (TS <= 18d)"},null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_totalslack,\">\"&setup_NearCritical,Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_summary,FALSE,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_totalslack<=setup_NearCritical))","v":0}]
[null,null,"Overall Task Count",null,"P1","P2","Delta",null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(proj1_summary,FALSE,proj1_dur,\">0\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\"),proj1_preds,\"*-*\"),\"\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj2_summary,FALSE,Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\"),Proj2_preds,\"*-*\"),\"\"))","v":0}]
[null,null,{"$f":"IF(G29>0,\"p\",IF(G29=0,\"µ¶\",\"q\"))","v":"µ¶"},"Total Tasks",{"$f":"IF(COUNTA(Proj1_UniqID)=0,0,COUNTIFS(Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0},{"$f":"IF(COUNTA(Proj2_UniqID)=0,0,COUNTIFS(Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0},{"$f":"F29-E29","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(proj1_summary,FALSE,proj1_dur,\">0\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\"),proj1_preds,\"*+*\"),\"\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj2_summary,FALSE,Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"TRUE\"),Proj2_preds,\"*+*\"),\"\"))","v":0}]
[null,null,"µ¶","Summary Tasks",{"$f":"COUNTIFS(proj1_summary,\"TRUE\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj2_summary,\"TRUE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"F30-E30","v":0}]
[null,null,"µ¶","Activities",{"$f":"COUNTIFS(proj1_summary,\"FALSE\",proj1_dur,\">0\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"F31-E31","v":0}]
[null,null,"µ¶","Milestones (Duration = 0d)",{"$f":"COUNTIFS(Proj1_MStone,\"TRUE\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"COUNTIFS(Proj2_MStone,\"TRUE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))","v":0},{"$f":"F32-E32","v":0}]
[null,null,"Tasks Added",null,"P1","P2","Delta"]
[null,null," ","Total Tasks Added",null,null,{"$f":"SUM(G35:G37)","v":0}]
[0,null," ","Summary Tasks Added",null,null,{"$f":"COUNTIFS(Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"TRUE\")-SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"TRUE\"))*(proj1_summary=TRUE))","v":0}]
[0,null," ","Activities Added",null,null,{"$f":"COUNTIFS(Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"FALSE\",Proj2_MStone,\"FALSE\",Proj2_pctcomplete,\"<100\")-SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"FALSE\",Proj2_MStone,\"FALSE\",Proj2_pctcomplete,\"<100\"))*(proj1_summary=FALSE)*(Proj1_MStone=FALSE))","v":0}]
[0,null," ","Milestones Added",null,null,{"$f":"COUNTIFS(Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_MStone,\"TRUE\",Proj2_pctcomplete,\"<100\")-SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_MStone,\"TRUE\",Proj2_pctcomplete,\"<100\"))*(Proj1_MStone=TRUE))","v":0}]
[null,null,"Tasks Deleted",null,"P1","P2","Delta"]
[null,null," ","Total Tasks Deleted",null,null,{"$f":"SUM(G40:G42)","v":0}]
[0,null," ","Summary Tasks Deleted",null,null,{"$f":"COUNTIFS(Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"TRUE\")-SUMPRODUCT((COUNTIFS(Proj1_UniqID,Proj2_UniqID,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"TRUE\"))*(Proj2_summary=TRUE))","v":0}]
[0,null," ","Activities Deleted",null,null,{"$f":"COUNTIFS(Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",Proj1_MStone,\"FALSE\",proj1_pctcomplete,\"<100\")-SUMPRODUCT((COUNTIFS(Proj1_UniqID,Proj2_UniqID,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",Proj1_MStone,\"FALSE\",proj1_pctcomplete,\"<100\"))*(Proj2_summary=FALSE)*(Proj2_MStone=FALSE))","v":0}]
[0,null," ","Milestones Deleted",null,null,{"$f":"COUNTIFS(Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj1_MStone,\"TRUE\",proj1_pctcomplete,\"<100\",proj1_summary,\"False\")-SUMPRODUCT((COUNTIFS(Proj1_UniqID,Proj2_UniqID,Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj1_MStone,\"TRUE\",proj1_pctcomplete,\"<100\",proj1_summary,\"False\"))*(Proj2_MStone=TRUE))","v":0}]
[null,null,"Activity Resources",null,"P1","P2","Delta"]
[0,null,{"$f":"IF(G44>0,\"p\",IF(G44=0,\"µ¶\",\"q\"))","v":"µ¶"},"Activities without Resources [% Complete < 100]",{"$f":"COUNTIFS(Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_summary,\"FALSE\",proj1_pctcomplete,\"<100\",Proj1_ResourceCount,0,proj1_dur,\">0\")","v":0},{"$f":"COUNTIFS(Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ResourceCount,0,Proj2_dur,\">0\")","v":0},{"$f":"F44-E44","v":0}]
[0,null," ","Activities with Changes to Resources",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_dur,\">0\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_Resources,\"<>\"&Proj1_Resources,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))))","v":0}]
[0,null," ","Activities with Added Resources",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_dur,\">0\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ResourceCount,\">\"&Proj1_ResourceCount,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))))","v":0}]
[0,null," ","Activities with Deleted Resources",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_dur,\">0\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ResourceCount,\"<\"&Proj1_ResourceCount,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))))","v":0}]
[0,null," ","Activities with Changes to Resource Percents",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_summary,\"FALSE\",Proj2_AssgnGroupWork,\"<>\"&Proj1_AssgnGroupWork,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))))","v":0}]
[null,null,"Constraints",null,"P1","P2","Delta"]
[0,null,{"$f":"IF(G50>0,\"p\",IF(G50=0,\"µ¶\",\"q\"))","v":"µ¶"},"Tasks with Deadlines",{"$f":"SUMPRODUCT((proj1_dur>0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_deadline<>\"NA\")*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(Proj2_deadline<>\"NA\")*(Proj2_pctcomplete<100))","v":0},{"$f":"F50-E50","v":0}]
[0,null,"µ¶","Tasks with Hard Constraints",{"$f":"SUMPRODUCT((proj1_dur>0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*((proj1_constrainttype=2)+(proj1_constrainttype=3)+(proj1_constrainttype=5)+(proj1_constrainttype=6))*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj2_dur>0)*(Proj2_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*((Proj2_constrainttype=2)+(Proj2_constrainttype=3)+(Proj2_constrainttype=5)+(Proj2_constrainttype=6))*(Proj2_pctcomplete<100)*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary))))","v":0},{"$f":"F51-E51","v":0}]
[0,null,"µ¶","Activities with SNETs",{"$f":"SUMPRODUCT((proj1_dur>0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(proj1_constrainttype=4)*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj2_dur>0)*(Proj2_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(Proj2_constrainttype=4)*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary))))","v":0},{"$f":"F52-E52","v":0}]
[0,null," ","Activities with Changed Constraints",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_constrainttype,\"<>\"&proj1_constrainttype,Proj2_dur,\">0\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null," ","Milestones with Changed Constraints",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_constrainttype,\"<>\"&proj1_constrainttype,Proj2_MStone,\"TRUE\",Proj2_pctcomplete,\"<100\",Proj2_summary,\"FALSE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[null,null,"Relationships, Predecessors, Successors",null,"P1","P2","Delta"]
[0,null,{"$f":"IF(G56>0,\"p\",IF(G56=0,\"µ¶\",\"q\"))","v":"µ¶"},"Activities with Lead",{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(proj1_summary,FALSE,proj1_dur,\">0\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_preds,\"*-*\"),\"\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj2_summary,FALSE,Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_preds,\"*-*\"),\"\"))","v":0},{"$f":"F56-E56","v":0}]
[0,null,"µ¶","Activities with Lag",{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(proj1_summary,FALSE,proj1_dur,\">0\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_preds,\"*+*\"),\"\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(COUNTIFS(Proj2_summary,FALSE,Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_preds,\"*+*\"),\"\"))","v":0},0]
[0,null,"µ¶","Activities with Non-FS Relationships",{"$f":"SUMPRODUCT((SIGN(((LEN(proj1_succs)-LEN(SUBSTITUTE(proj1_succs,\"FF\",\"\")))>0)+((LEN(proj1_succs)-LEN(SUBSTITUTE(proj1_succs,\"SS\",\"\")))>0)+((LEN(proj1_succs)-LEN(SUBSTITUTE(proj1_succs,\"SF\",\"\")))>0)))*(proj1_dur>0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((SIGN(((LEN(Proj2_succs)-LEN(SUBSTITUTE(Proj2_succs,\"FF\",\"\")))>0)+((LEN(Proj2_succs)-LEN(SUBSTITUTE(Proj2_succs,\"SS\",\"\")))>0)+((LEN(Proj2_succs)-LEN(SUBSTITUTE(Proj2_succs,\"SF\",\"\")))>0)))*(Proj2_dur>0)*(Proj2_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary))))","v":0},0]
[0,null,"µ¶","Activities with FF Relationships",{"$f":"SUMPRODUCT(((LEN(proj1_succs)-LEN(SUBSTITUTE(proj1_succs,\"FF\",\"\")))*1>0)*(proj1_dur>0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT(((LEN(Proj2_succs)-LEN(SUBSTITUTE(Proj2_succs,\"FF\",\"\")))*1>0)*(Proj2_dur>0)*(Proj2_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary))))","v":0},0]
[0,null,"µ¶","Activities with SS Relationships",{"$f":"SUMPRODUCT(((LEN(proj1_succs)-LEN(SUBSTITUTE(proj1_succs,\"SS\",\"\")))*1>0)*(proj1_dur>0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT(((LEN(Proj2_succs)-LEN(SUBSTITUTE(Proj2_succs,\"SS\",\"\")))*1>0)*(Proj2_dur>0)*(Proj2_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary))))","v":0},0]
[0,null,"µ¶","Activities with Missing Predecessors",{"$f":"SUMPRODUCT((proj1_preds=\"\")*(proj1_dur>0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj2_preds=\"\")*(Proj2_dur>0)*(Proj2_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary))))","v":0},0]
[0,null,"µ¶","Activities with Missing Successors",{"$f":"SUMPRODUCT((proj1_succs=\"\")*(proj1_dur>0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj2_succs=\"\")*(Proj2_dur>0)*(Proj2_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary))))","v":0},0]
[0,null,"µ¶","Activities with Missing Pred's or Succ's",{"$f":"SUM(E61:E62)","v":0},{"$f":"SUM(F61:F62)","v":0},0]
[0,null," ","Activities with Predecessors Changed",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_MStone,\"FALSE\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))-SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,proj2_UIDpreds,proj1_UIDpreds,Proj2_MStone,\"FALSE\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null," ","Activities with Successors Changed",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_MStone,\"FALSE\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))-SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,proj2_UIDsuccs,proj1_UIDsuccs,Proj2_MStone,\"FALSE\",Proj2_summary,\"FALSE\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[null,null,"Start-related Changes",null,"P1","P2","Delta"]
[0,null,{"$f":"IF(G67>0,\"p\",IF(G67=0,\"µ¶\",\"q\"))","v":"µ¶"},"Activities Starting in the Past - 0% Complete",{"$f":"SUMPRODUCT((Proj1_Start<proj1_data_statusdateStart)*(proj1_dur>0)*(proj1_pctcomplete=0)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj2_Start<proj2_data_statusdateStart)*(Proj2_dur>0)*(Proj2_pctcomplete=0)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary))))","v":0},{"$f":"F67-E67","v":0},null,null,null,"`"]
[0,null,null,"Activities Newly Starting in the Past - 0% Complete",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_Start,\"<\"&proj2_data_statusdateStart,Proj2_summary,\"False\",Proj2_dur,\">0\",Proj2_pctcomplete,0,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(Proj1_Start>proj1_data_statusdateStart))","v":0}]
[0,null,null,"Activities No Longer Starting in the Past - 0% Complete",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_Start,\">\"&proj2_data_statusdateStart,Proj2_summary,\"False\",Proj2_dur,\">0\",Proj2_pctcomplete,0,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(Proj1_Start<proj1_data_statusdateStart))","v":0}]
[0,null," ","Tasks Started Since Last Schedule",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_pctcomplete=0))","v":0}]
[0,null," ","Summary Tasks Started Since Last Schedule",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\">0\",Proj2_summary,\"TRUE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_pctcomplete=0))","v":0}]
[0,null," ","Activities Started Since Last Schedule",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\">0\",Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_pctcomplete=0))","v":0}]
[0,null," ","Milestones Completed Since Last Schedule",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\">0\",Proj2_summary,\"FALSE\",Proj2_MStone,\"TRUE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_pctcomplete=0))","v":0}]
[0,null," ","Activities with Earlier Start",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\"<100\",Proj2_Start,\"<\"&Proj1_Start,Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null," ","Activities with Later Start",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\"<100\",Proj2_Start,\">\"&Proj1_Start,Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[null,null,"Finish-related Changes",null,"P1","P2","Delta"]
[0,null,{"$f":"IF(G77>0,\"p\",IF(G77=0,\"µ¶\",\"q\"))","v":"µ¶"},"Activities Finishing in the Past - Not Complete",{"$f":"SUMPRODUCT((Proj1_Fin<proj1_data_statusdate)*(proj1_dur>0)*(proj1_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary))))","v":0},{"$f":"SUMPRODUCT((Proj2_Fin<proj2_data_statusdate)*(Proj2_dur>0)*(Proj2_pctcomplete<100)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary))))","v":0},{"$f":"F77-E77","v":0}]
[0,null,null,"Activities Newly Finishing in the Past - Not Complete",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_Fin,\"<\"&proj2_data_statusdate,Proj2_summary,\"False\",Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(Proj1_Fin>proj1_data_statusdate))","v":0}]
[0,null,null,"Activities No Longer Finishing in the Past - Not Complete",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_Fin,\">\"&proj2_data_statusdateStart,Proj2_summary,\"False\",Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(Proj1_Fin<proj1_data_statusdateStart))","v":0}]
[0,null," ","Tasks Completed Since Last Schedule",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,100,Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_pctcomplete<100))","v":0}]
[0,null," ","Summary Tasks Completed Since Last Schedule",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\"=100\",Proj2_summary,\"TRUE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_pctcomplete<100))","v":0}]
[0,null," ","Activities Completed Since Last Schedule",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\"=100\",Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_pctcomplete<100))","v":0}]
[0,null," ","Milestones Completed Since Last Schedule",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\"=100\",Proj2_summary,\"FALSE\",Proj2_MStone,\"TRUE\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))*(proj1_pctcomplete<100))","v":0}]
[0,null," ","Activities with Earlier Finish",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_Fin,\"<\"&Proj1_Fin,Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null," ","Activities with Later Finish",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_Fin,\">\"&Proj1_Fin,Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null," ","Activities Previously Complete, Now Incomplete",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\"<100\",Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))*(proj1_pctcomplete=100))","v":0}]
[0,null," ","Activities with Increased % Complete",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\">\"&proj1_pctcomplete,Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null," ","Activities with Decreased % Complete",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_pctcomplete,\"<\"&proj1_pctcomplete,Proj2_summary,\"FALSE\",Proj2_dur,\">0\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[null,null,"Margin",null,"P1","P2","Delta"]
[0,null,{"$f":"IF(G90>0,\"p\",IF(G90=0,\"µ¶\",\"q\"))","v":"µ¶"},"Number of  Activities w/ Margin, Slack, or Float in Name",{"$f":"SUMPRODUCT(((ISNUMBER(SEARCH(\"Margin\",proj1_names)))+(ISNUMBER(SEARCH(\"Float\",proj1_names)))+(ISNUMBER(SEARCH(\"Slack\",proj1_names))))*(proj1_dur>0)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))*(proj1_pctcomplete<100))","v":0},{"$f":"SUMPRODUCT(((ISNUMBER(SEARCH(\"Margin\",Proj2_names)))+(ISNUMBER(SEARCH(\"Float\",Proj2_names)))+(ISNUMBER(SEARCH(\"Slack\",Proj2_names))))*(Proj2_dur>0)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary)))*(Proj2_pctcomplete<100))","v":0},{"$f":"F90-E90","v":0}]
[null,null,"µ¶","Total Days of Margin",{"$f":"SUMPRODUCT(((ISNUMBER(SEARCH(\"Margin\",proj1_names)))+(ISNUMBER(SEARCH(\"Float\",proj1_names)))+(ISNUMBER(SEARCH(\"Slack\",proj1_names))))*(proj1_dur)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))*(proj1_pctcomplete<100))","v":0},{"$f":"SUMPRODUCT(((ISNUMBER(SEARCH(\"Margin\",Proj2_names)))+(ISNUMBER(SEARCH(\"Float\",Proj2_names)))+(ISNUMBER(SEARCH(\"Slack\",Proj2_names))))*(Proj2_dur)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary)))*(Proj2_pctcomplete<100))","v":0},{"$f":"F91-E91","v":0}]
[null,null,"µ¶","Total Days of Margin Not on Critical Path",{"$f":"SUMPRODUCT(((ISNUMBER(SEARCH(\"Margin\",proj1_names)))+(ISNUMBER(SEARCH(\"Float\",proj1_names)))+(ISNUMBER(SEARCH(\"Slack\",proj1_names))))*(proj1_dur)*(proj1_totalslack>0)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))*(proj1_pctcomplete<100))","v":0},{"$f":"SUMPRODUCT(((ISNUMBER(SEARCH(\"Margin\",Proj2_names)))+(ISNUMBER(SEARCH(\"Float\",Proj2_names)))+(ISNUMBER(SEARCH(\"Slack\",Proj2_names))))*(Proj2_dur)*(Proj2_totalslack>0)*(ISNUMBER(SEARCH(IF(Controls_IgnoreExtTest=1,\"FALSE\",\"\"),Proj2_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",Proj2_summary)))*(Proj2_pctcomplete<100))","v":0},0]
[null,null,"Other Data",null,"P1","P2","Delta"]
[0,null,{"$f":"IF(G94>0,\"p\",IF(G94=0,\"µ¶\",\"q\"))","v":"µ¶"},"Duplicate Names - Total Count (Longer Run Time)",{"$f":"_xlfn.SINGLE(IFERROR(SUMPRODUCT((COUNTIFS(proj1_names,proj1_names,proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),proj1_names,\"<>\"&\"\")))-COUNTIFS(proj1_names,\"<>\"&\"\",proj1_pctcomplete,\"<100\",Proj1_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")),\"None\"))","v":0},{"$f":"_xlfn.SINGLE(IFERROR(SUMPRODUCT((COUNTIFS(Proj2_names,Proj2_names,Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"),Proj2_names,\"<>\"&\"\")))-COUNTIFS(Proj2_names,\"<>\"&\"\",Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")),\"None\"))","v":0},{"$f":"F94-E94","v":0}]
[0,null," ","Activities with Changes to the WBS Structure",null,null,{"$f":"SUMPRODUCT((COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_WBS,\"<>\"&Proj1_WBS,Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\"))))","v":0}]
[0,null," ","Activities with Changed Calendars",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_Calendar,\"<>\"&Proj1_Calendar,Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[0,null," ","Tasks with Name Changed",null,null,{"$f":"SUMPRODUCT(COUNTIFS(Proj2_UniqID,Proj1_UniqID,Proj2_names,\"<>\"&proj1_names,Proj2_pctcomplete,\"<100\",Proj2_ExtTask,IF(Controls_IgnoreExtTest=1,\"FALSE\",\"<>0\")))","v":0}]
[null,null," ","Last Modified Dates",{"$f":"Proj1_LastModDate","v":"00:00:00"},{"$f":"Proj2_LastModDate","v":"00:00:00"}]
[null,null," ","Last Modified Times",{"$f":"Proj1_LastModDate","v":"00:00:00"},{"$f":"Proj2_LastModDate","v":"00:00:00"}]
[null,null,null,null,null,null,null,true]

{"sheet":"proj1_data","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"proj2_data","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Controls","index":5,"n_rows":71,"n_cols":26,"rows_kept":71,"cut":false,"hidden":false,"merged":[[1,1,1,2],[10,1,10,2]]}
[]
["P1 Data Saved?","Yes / No Dropdowns",null,null,"Sliders (Working Days)","Default","Min","Max",null,"Fields","WBS Field","Split Task Field","Unique Comparison Field",null,"Time Units",null,null,null,null,"FNLT Test",null,"Registration Data",null,null,"User Settings"]
[null,"Inputs ","        Yes",1,"Near Critical",5,0,30,null,"Button Output",{"$f":"INDEX(J5:J35,MATCH(K4,K5:K35,0))-2","v":2},21,{"$f":"OFFSET(proj1_data!$DE$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)","v":0},null,"m",{"$f":"O3&\"_Count\"","v":"m_Count"},{"$f":"\"dim \"&P3&\" As Integer\"","v":"dim m_Count As Integer"},null,null,{"$f":"COUNTIF(proj1_constrainttype,7)","v":0},null,"Times Run:",null,null,true]
["P2 Data Saved?",null,"        No",2,"+/- Threshold for BL Check",20,0,30,null,"Default",{"$f":"Setup_WBSField","v":"WBS"},"Choose One",{"$f":"Setup_DVCompField","v":"Unique ID"},null,"em",{"$f":"O4&\"_Count\"","v":"em_Count"},{"$f":"\"dim \"&P4&\" As Integer\"","v":"dim em_Count As Integer"},null,null,null,null,"First Name:",null,null,true]
[null,"Check for Duplicates",1,null,"Standard Duration",20,0,44,null,80,"Text 1","   Flag 1","Unique ID",null,"h","h_Count","dim h_Count As Integer",null,null,null,null,"Last Name:",null,null,true]
[null,"Check for BC/ML/WC rDur",2,{"$f":"IF(Controls_RiskPlusCheck=1,\"Yes\",\"No\")","v":"No"},"Excessive Duration",44,44,120,null,81,"Text 2","   Flag 2","Text 1",null,"eh","eh_Count","dim eh_Count As Integer",null,null,null,null,"Email:",null,null,false]
[null,"Autocalculate @ Completion",1,null,"Excessive Total Slack",20,0,44,null,82,"Text 3","   Flag 3","Text 2",null,"d","d_Count","dim d_Count As Integer",null,null,null,null,"HDD No:",null,null,false]
[null,"Ignore External Tasks",1,null,"% Complete < 100 & Dur >",20,0,44,null,83,"Text 4","   Flag 4","Text 3",null,"ed","ed_Count","dim ed_Count As Integer",null,null,null,null,"Open HDD No:",217823250,null,-4135]
[null,"Run Time",1,null,"% Complete < 100 & Dur <",5,0,20,null,84,"Text 5","   Flag 5","Text 4",null,"w","w_Count","dim w_Count As Integer",null,null,null,null,"Count Items",{"$f":"COUNTA(W4:W7)","v":0},null,false]
[null,"Warnings",true,null,"Dur'n Excessive & TS <=",10,0,20,null,85,"Text 6","   Flag 6","Text 5",null,"ew","ew_Count","dim ew_Count As Integer",null,null,null,null,"Install ID:",{"$f":"IF(Controls_RegItemCount>0,TRIM(AI15&AI16&AI17&AI18&AI19&AI20&AI21&AI22&AI23&AI24),\"\")","v":""},null,false,"<-- Close Flag"]
[null,"Setup Drop Down (CPLI)",null,null,"# of Significant Preds/Succesors",5,5,25,10,86,"Text 7","   Flag 7","Text 6",null,"y","y_Count","dim y_Count As Integer",null,null,null,null,"User Entered ID:"]
[null,"proj1 name index",23,null,null,null,null,null,null,87,"Text 8","   Flag 8","Text 7",null,"ey","ey_Count","dim ey_Count As Integer",null,null,null,null,"Reverse HDD:",{"$f":"IFERROR(IF(Controls_UserEnteredRegID=\"\",\"\",TRIM(AC32&AC33&AC34&AC35&AC36&AC37&AC38&AC39&AC40&AC41)),9999)","v":""}]
[null,null,6,null,"Sliders (Percentages)","Default","Min","Max",null,88,"Text 9","   Flag 9","Text 8",null,"DC","DC_Count","dim DC_Count As Integer",null,null,null,{"$f":"LEN(W7)","v":0}]
[null,"Project 1 Filepath: ","Project 2 Filepath: ",null,"TS < x% of Remaining Dur'n",5,1,20,null,89,"Text 10","   Flag 10","Text 9",null,"eDC","eDC_Count","dim eDC_Count As Integer",null,null,null,null,"HDD","FS","Added"]
[null,null,null,null,"% Finish Var < Start Var Limit",5,1,10,null,90,"Text 11","   Flag 11","Text 10",null,"%","%_Count","dim %_Count As Integer"]
["External Tasks",{"$f":"COUNTIF(Proj1_ExtTask,TRUE)","v":0},{"$f":"COUNTIF(Proj2_ExtTask,TRUE)","v":0},null,"% Finish Var > Start Var Limit",25,5,50,null,91,"Text 12","   Flag 12","Text 11",null,"e%","e%_Count","dim e%_Count As Integer"]
[null,"Project 1 Last Mod Date","Project 2 Last Mod Date",null,"Finish Var > Total Slack Limit",5,1,10,null,92,"Text 13","   Flag 13","Text 12"]
[null,null,null,null,"% Start Var > Total Slack Limit",5,1,10,null,93,"Text 14","   Flag 14","Text 13"]
[null,"CPLI Inputs",null,null,"% Split Tasks Limit",5,1,10,null,94,"Text 15","   Flag 15","Text 14",null,"Date Format"]
[null,"FNLT on Crit Path?",{"$f":"IF(COUNTIFS(Proj1_Fin,D20,proj1_constrainttype,7)>0,\"Yes\",\"No\")","v":"No"},{"$f":"MAX(IF((ISNUMBER(SEARCH(\"FALSE\",Proj1_ExtTask)))*(ISNUMBER(SEARCH(\"FALSE\",proj1_summary)))*(proj1_totalslack=0),Proj1_Fin,\"\"))","v":{"$error":"#VALUE!"}},null,null,null,null,null,95,"Text 16","   Flag 16","Text 15",null,0,0,"with time"]
[null,null,"FNLT Dts","UID","Non-FNLT Dates","UID2",null,null,null,96,"Text 17","   Flag 17","Text 16",null,null,1,"w/0 time"]
[null,"UID of min start that is critical and <> summary",null,null,null,null,null,null,null,97,"Text 18","   Flag 18","Text 17"]
[null,"UID of max fin that is critical and <> summary",null,null,null,null,null,null,null,98,"Text 19","   Flag 19","Text 18"]
[null,"CpTestOutput",null,null,null,null,null,null,null,99,"Text 20","   Flag 20","Text 19"]
[null,"Text Field Selector Values",null,null,null,null,null,null,null,100,"Text 21","   Choose One","Text 20"]
[null,"# of Rows of Data",{"$f":"COUNTA(proj1_names)","v":0},null,null,null,null,null,null,101,"Text 22",null,"Text 21"]
[null,"Text 1","CB",80,"Crit Min UID",null,null,null,null,102,"Text 23",null,"Text 22"]
[null,"Text 2","CC",81,"MaxFin UID",null,null,null,null,103,"Text 24",null,"Text 23"]
[null,"Text 3","CD",82,"Crit Min Date",null,null,null,null,104,"Text 25",null,"Text 24"]
[null,"Text 4","CE",83,"Max Fin Date",null,null,null,null,105,"Text 26",null,"Text 25"]
[null,"Text 5","CF",84,null,null,null,null,null,106,"Text 27",null,"Text 26"]
[null,"Text 6","CG",85,null,null,null,null,null,107,"Text 28",null,"Text 27"]
[null,"Text 7","CH",86,null,null,null,null,null,108,"Text 29",null,"Text 28"]
[null,"Text 8","CI",87,null,null,null,null,null,109,"Text 30",null,"Text 29"]
[null,"Text 9","CJ",88,null,null,null,null,null,4,"WBS",null,"Text 30"]
[null,"Text 10","CK",89,null,null,null,null,null,null,"Choose One"]
[null,"Text 11","CL",90,null,null,null,null,null,"Project 1 Range","proj1_text3"]
[null,"Text 12","CM",91,null,null,null,null,null,"Project 2 Range",{"$f":"\"proj2_text\"&controls_proj1_wbsfield","v":"proj2_text2"}]
[null,"Text 13","CN",92,null,null,null,null,null,null,3]
[null,"Text 14","CO",93]
[null,"Text 15","CP",94]
[null,"Text 16","CQ",95]
[null,"Text 17","CR",96]
[null,"Text 18","CS",97]
[null,"Text 19","CT",98]
[null,"Text 20","CU",99]
[null,"Text 21","CV",100]
[null,"Text 22","CW",101]
[null,"Text 23","CX",102]
[null,"Text 24","CY",103]
[null,"Text 25","CZ",104]
[null,"Text 26","DA",105]
[null,"Text 27","DB",106]
[null,"Text 28","DC",107]
[null,"Text 29","DD",108]
[null,"Text 30","DE",109]
[null,"Column Picked",{"$f":"INDEX(C27:C56,controls_proj1_wbsfield)","v":"CC"}]
[null,"First Row",5]
[null,"Last Row",{"$f":"C58+C26-1","v":4}]
[null,"Range Start",{"$f":"C57&C58","v":"CC5"}]
[null,"Range End",{"$f":"C57&C59","v":"CC4"}]
[]
[]
[null,"Quick Overview Load Check"]
[null,"Baseline Set?"]
[null,"Status Date Set?"]
[null,"Events"]
[null,"Near Critical"]
[null,"Critical"]
[null,"DCMA Correct (# of 15)"]
[null,"Std Correct (# of 17)"]

{"sheet":"Calendar","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calendar2","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"NamedRanges","index":8,"n_rows":195,"n_cols":2,"rows_kept":195,"cut":false,"hidden":false,"merged":[]}
[]
["AllTest_Count","=Diagnostics!$M$23:$M$92"]
["Calendar1_HolidaysImported","=OFFSET(Calendar!$D$2,0,0,COUNTA(Calendar!$D:$D)-1)"]
["Calendar2_HolidaysImported","=OFFSET(Calendar2!$D$2,0,0,COUNTA(Calendar2!$D:$D)-1)"]
["CloseFlag","=Controls!$Y$10"]
["Comp_Comm1","=Compare!$B$2"]
["Comp_Comm1Cell","=Compare!$C$2"]
["Comp_tCount_p1","=Compare!$E$29"]
["Comp_tCount_p2","=Compare!$F$29"]
["Comp_TFAutoFilterRange","=Compare!$H$1:$H$101"]
["CompareLinkRng","=Compare!$B$8:$B$97"]
["CompLinkRng","=Compare!$A$1:$A$97"]
["Controls_FNLTTest","=Controls!$T$3"]
["Controls_HDDStartCheck","=Controls!$W$12"]
["Controls_IgnoreExtTest","=Controls!$C$8"]
["Controls_IgnoreExtTest_TF","=Controls!$D$8"]
["Controls_OpenHDDNo","=Controls!$W$8"]
["Controls_P1DataSaved","=Controls!$A$3"]
["Controls_P2DataSaved","=Controls!$A$5"]
["controls_proj1_splitfield","=Controls!$L$3"]
["controls_proj1_wbsfield","=Controls!$K$3"]
["Controls_RegHDDNo","=Controls!$W$7"]
["Controls_RegItemCount","=Controls!$W$9"]
["Controls_RegItems","=Controls!$W$4:$W$7"]
["Controls_RiskPlusCheck","=Controls!$C$6"]
["Controls_RiskPlusSelection","=Controls!$D$6"]
["Controls_RunCount","=Controls!$W$3"]
["Controls_Runtime","=Controls!$C$9"]
["Controls_ShowWarnings","=Controls!$C$10"]
["Controls_TUCheckRange","=Controls!$R$3:$R$16"]
["Controls_UserEnteredRegID","=Controls!$W$11"]
["Controls_VBRegID","=Controls!$W$10"]
["CPTestOutput","=Controls!$C$24"]
["DCMA_Count","=Diagnostics!$K$87:$K$100"]
["DCMA_Results","=Diagnostics!$G$87:$G$100"]
["Diag_CBShowRange","=Diagnostics!$I$22:$I$100"]
["Diag_CPTestCheck1","=Diagnostics!$I$98"]
["Diag_CPTestCheck2","=Diagnostics!$I$99"]
["Diag_CPTestsColERange","=Diagnostics!$E$98:$E$99"]
["Diag_CritMinMaxTable","=Controls!$C$22:$H$24"]
["Diag_DissTUResult","=Diagnostics!$G$9"]
["Diag_FcstDur","=Diagnostics!$F$13"]
["Diag_LinkRange","=Diagnostics!$A$9:$A$97"]
["Diag_LinkRangeAllRows","=Diagnostics!$A$1:$A$97"]
["Diag_RunTime","=Diagnostics!$G$7"]
["Diag_SplitTaskCheck","=Diagnostics!$I$83"]
["Diag_SplitTaskCount","=Diagnostics!$F$83"]
["Diag_TFAutoFilterRange","=Diagnostics!$I$1:$I$102"]
["Diag_TotalTasks","=Diagnostics!$F$18"]
["Diag_TSLessPctRDurAns","=Diagnostics!$F$29"]
["Diag_TSLessPctRemDurCheck","=Diagnostics!$I$29"]
["Diag_UnHideRowRng","=Diagnostics!$A$22:$A$100"]
["FinVar_Less_StartVar","=Setup!$I$25"]
["FinVar_More_StartVar","=Setup!$I$26"]
["FInVar_More_TSlack","=Setup!$I$27"]
["PostTestFinDate","=Controls!$E$24"]
["proj1_actualfin","=OFFSET(proj1_data!$Q$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_actualstart","=OFFSET(proj1_data!$R$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_AssgnGroupWork","=OFFSET(proj1_data!$BT$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_bdur","=OFFSET(proj1_data!$T$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_bfinish","=OFFSET(proj1_data!$U$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_blwork","=OFFSET(proj1_data!$W$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_BStart","=OFFSET(proj1_data!$V$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_Calendar","=OFFSET(proj1_data!$DP$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_CompTestYNRange","=OFFSET(proj1_data!$DS$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_constrainttype","=OFFSET(proj1_data!$Y$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_CritMaxFinDate","=Controls!$G$23"]
["Proj1_CritMaxFinUID","=Controls!$F$23"]
["Proj1_CritMinStartDate","=Controls!$C$22"]
["Proj1_CritMinStartUID","=Controls!$D$22"]
["Proj1_CritTF","=OFFSET(proj1_data!$AA$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_data_statusdate","=proj1_data!$A$1"]
["proj1_data_statusdateStart","=proj1_data!$A$2"]
["proj1_dateformat","=Controls!$O$20"]
["proj1_deadline","=OFFSET(proj1_data!$AB$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_DTColOldVals","=OFFSET(proj1_data!$DT$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_dur","=OFFSET(proj1_data!$G$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_Dur1","=OFFSET(proj1_data!$DM$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_Dur2","=OFFSET(proj1_data!$DN$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_Dur3","=OFFSET(proj1_data!$DO$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_DurVar","=OFFSET(proj1_data!$AC$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_EarlyFin","=OFFSET(proj1_data!$AD$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_EarlyStart","=OFFSET(proj1_data!$AE$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_estdur","=OFFSET(proj1_data!$AG$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_ExtTask","=OFFSET(proj1_data!$AH$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_FilePath","=Controls!$B$15"]
["Proj1_Fin","=OFFSET(proj1_data!$I$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_FinVar","=OFFSET(proj1_data!$AJ$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_ids","=OFFSET(proj1_data!$B$5,0,0,COUNTA(proj2_data!$B:$B)-1,1)"]
["Proj1_LastModDate","=Controls!$B$18"]
["Proj1_MaxFinDate","=Controls!$G$23"]
["Proj1_MaxFinUID","=Controls!$H$23"]
["Proj1_MinStartDate","=Controls!$C$22"]
["Proj1_MinStartUID","=Controls!$D$22"]
["Proj1_MStone","=OFFSET(proj1_data!$BL$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_names","=OFFSET(proj1_data!$E$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_OutlineLvl","=OFFSET(proj1_data!$BO$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_pctcomplete","=OFFSET(proj1_data!$F$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_predcount","=OFFSET(proj1_data!$L$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_preds","=OFFSET(proj1_data!$K$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_remainingduration","=OFFSET(proj1_data!$BU$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_ResourceCount","=OFFSET(proj1_data!$A$5,0,0,COUNTA(proj2_data!$B:$B)-1,1)"]
["Proj1_Resources","=OFFSET(proj1_data!$DL$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_Start","=OFFSET(proj1_data!$H$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_StartVar","=OFFSET(proj1_data!$BZ$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_Status","=OFFSET(proj1_data!$CA$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_succs","=OFFSET(proj1_data!$M$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_succscount","=OFFSET(proj1_data!$N$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_summary","=OFFSET(proj1_data!$O$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_timeunits","=OFFSET(proj1_data!$DR$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_totalslack","=OFFSET(proj1_data!$J$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_UniqID","=OFFSET(proj1_data!$C$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_VarSplitTaskField","=OFFSET(proj1_data!$AM$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_VarUniqCompareField","=OFFSET(proj1_data!$C$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_VarWBSField","=OFFSET(proj1_data!$D$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj1_WBS","=OFFSET(proj1_data!$D$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj1_Work","=OFFSET(proj1_data!$DQ$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_actualfin","=OFFSET(proj2_data!$Q$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_actualstart","=OFFSET(proj2_data!$R$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_AssgnGroupWork","=OFFSET(proj2_data!$BT$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_bdur","=OFFSET(proj2_data!$T$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_bfinish","=OFFSET(proj2_data!$U$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_blwork","=OFFSET(proj2_data!$W$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_BStart","=OFFSET(proj2_data!$V$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_Calendar","=OFFSET(proj2_data!$DP$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_CompTestYNRange","=OFFSET(proj2_data!$DS$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_constrainttype","=OFFSET(proj2_data!$Y$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["proj2_data_statusdate","=proj2_data!$A$1"]
["proj2_data_statusdateStart","=proj2_data!$A$2"]
["Proj2_deadline","=OFFSET(proj2_data!$AB$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_DTColOldVals","=OFFSET(proj2_data!$DT$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_dur","=OFFSET(proj2_data!$G$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_Dur1","=OFFSET(proj2_data!$DM$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_Dur2","=OFFSET(proj2_data!$DN$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_Dur3","=OFFSET(proj2_data!$DO$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_DurVar","=OFFSET(proj2_data!$AC$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_EarlyFin","=OFFSET(proj2_data!$AD$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_EarlyStart","=OFFSET(proj2_data!$AE$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_estdur","=OFFSET(proj2_data!$AG$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_ExtTask","=OFFSET(proj2_data!$AH$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_FilePath","=Controls!$C$15"]
["Proj2_Fin","=OFFSET(proj2_data!$I$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_FinVar","=OFFSET(proj2_data!$AJ$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_ids","=OFFSET(proj2_data!$B$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_LastModDate","=Controls!$C$18"]
["Proj2_MStone","=OFFSET(proj2_data!$BL$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_names","=OFFSET(proj2_data!$E$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_OutlineLvl","=OFFSET(proj2_data!$BO$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_pctcomplete","=OFFSET(proj2_data!$F$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_predcount","=OFFSET(proj2_data!$L$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_preds","=OFFSET(proj2_data!$K$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_remainingduration","=OFFSET(proj2_data!$BU$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_ResourceCount","=OFFSET(proj2_data!$A$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_Resources","=OFFSET(proj2_data!$DL$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_Start","=OFFSET(proj2_data!$H$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_StartVar","=OFFSET(proj2_data!$BZ$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_Status","=OFFSET(proj2_data!$CA$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_succs","=OFFSET(proj2_data!$M$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_succscount","=OFFSET(proj2_data!$N$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_summary","=OFFSET(proj2_data!$O$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_timeunits","=OFFSET(proj2_data!$DR$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_totalslack","=OFFSET(proj2_data!$J$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_UniqID","=OFFSET(proj2_data!$C$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_VarUniqCompareField","=OFFSET(proj2_data!$C$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_VarWBSField","=OFFSET(proj2_data!$D$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_WBS","=OFFSET(proj2_data!$D$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Proj2_Work","=OFFSET(proj2_data!$DQ$5,0,0,COUNTA(proj1_data!$B:$B)-1,1)"]
["Setup_AnalMode","=Setup!$U$19"]
["Setup_BLDurThreshold","=Setup!$I$12"]
["Setup_Comm1","=Setup!$W$10"]
["Setup_Comm1Cell","=Setup!$B$10"]
["Setup_Comm2","=Setup!$W$31"]
["Setup_Comm2Cell","=Setup!$B$31"]
["Setup_DurExcess","=Setup!$I$14"]
["Setup_DurExcessTSLess","=Setup!$I$18"]
["Setup_DVCompField","=Setup!$U$13"]
["Setup_ExcessSlack","=Setup!$I$15"]
["Setup_FileName","=Setup!$B$6"]
["Setup_FileName_P2","=Setup!$B$7"]
["Setup_GraphValues","=Setup!$U$26:$U$31"]
["setup_NearCritical","=Setup!$I$11"]
["setup_PctLessDurGreater","=Setup!$I$16"]
["setup_PctLessDurLess","=Setup!$I$17"]
["setup_sigpredsucc","=Setup!$I$19"]
["setup_splittask_slider","=Setup!$I$29"]
["Setup_SplitTaskField","=Setup!$U$12"]
["Setup_StatusDateP1","=Setup!$T$6"]
["Setup_StatusDateP2","=Setup!$T$7"]
["Setup_StdDur","=Setup!$I$13"]
["Setup_TSLessRemDur","=Setup!$I$24"]
["Setup_TUCheck","=Setup!$U$18"]
["Setup_WBSField","=Setup!$U$11"]
["StandardSetContigCount","=Diagnostics!$L$24:$L$37"]
["StartUpCB","=Controls!$Y$9"]
["StartVar_More_TSlack","=Setup!$I$28"]