Spreadsheet: 708070d1607608068-formula-for-targeting-a-closure-goal-samplesheet
Sheet: Log

ComboBoxAgency | txtboxCAPName | ComboBoxSourceDef | txtboxCAPDesc | ComboBoxDefSev | ComboBoxCycle | txtboxCFYCAP | txtboxCAPOwner | txtboxTaskNum | ComboBoxPhase | txtboxMilestone | txtboxICDCAPContact | ComboBoxTaskStatus | txtboxEstComp | txtboxRevComp | txtboxTaskComp | txtboxPctComp | txtboxLastUpdate | ComboBoxCAPStatus | txtboxestCAPdate | txtboxrevCAPdate | txtboxCAPComp | txtboxFinalClosure | txtboxBusinessArea | txtboxProgram
 |  | Start of FY |  |  |  |  |  | 11
 |  | Date | Total Cases Logged | Number in FY to Expected Completion Date | Percent Expected Complete to Date Selected | Number in FY to Revised Completion Date | Percent Revised Complete to Date Selected
 |  | 2021-12-30 00:00:00
Agency | CAP Name/Reference Number | Source of Deficiency | [NAME] | Deficiency Severity | Cycle/Business Process | Fiscal Year CAP Created | CAP Owner | Task Number | Phase | Milestone Description | ICD CAP Contact | Task Status | Estimated Task Completion Date | Revised Task Completion Date | Task Completion Date | Percentage Complete | Last Task Update | Overall CAP Status | Estimated CAP Completion Date | Revised CAP Completion Date | CAP Completion Date/Submitted for Closure | ACRT Closure Date | Business Area | Program
FSA | 999 | A-123 | CAP Owner Changed | Significant Deficiency | Collections | 2020 | LTS New | 56 | Implementation | Testing | LTS | In Progress | 2020-01-06 00:00:00 | 2020-02-06 00:00:00 | 2020-01-06 00:00:00 | 90 | 2020-05-31 00:00:00 | Closed |  |  | 2020-05-12 00:00:00 | 2020-06-15 00:00:00 | A | M
FSA | 10556 | OIG | New Test 1 | Significant Deficiency | [NAME] | 2020 | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 2021-05-06 00:00:00 | 2021-05-10 00:00:00 | 2021-05-15 00:00:00 | 100 | 2021-04-05 00:00:00 | Closed |  |  | 2021-06-01 00:00:00 | 2021-01-07 00:00:00 | B | N
FSA | 89 | A-123 | Testing | Significant Deficiency | [NAME] | 2020 | LTS | 56 | Implementation | Testing | LTS | Complete | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-01 00:00:00 | 100 | 2020-05-31 00:00:00 | Closed |  |  | 2020-06-05 00:00:00 | 2020-06-15 00:00:00 | A | O
FSA | 5 | OIG | New Test 1 | Significant Deficiency | [NAME] | 2020 | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 2021-05-06 00:00:00 | 2021-05-10 00:00:00 | 2021-05-15 00:00:00 | 85 | 2021-04-05 00:00:00 | Closed |  |  | 2021-06-01 00:00:00 | 2021-01-07 00:00:00
RD | 5 | OIG | New Test 1 | Significant Deficiency | [NAME] | 2020 | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 2021-05-06 00:00:00 | 2021-05-10 00:00:00 | 2021-05-15 00:00:00 | 85 | 2021-04-05 00:00:00 | Closed |  |  | 2021-06-01 00:00:00 | 2021-01-07 00:00:00
FSA | 5 | OIG | New Test 2 | Significant Deficiency | Collections | 2020 | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 2021-05-06 00:00:00 | 2021-05-10 00:00:00 | 2021-05-15 00:00:00 | 85 | 2021-04-05 00:00:00 | Closed |  |  | 2021-06-01 00:00:00 | 2021-01-07 00:00:00
FSA | 10 | OIG | New Test 1 | Significant Deficiency | Collections | 2020 | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 2021-05-06 00:00:00 | 2021-05-10 00:00:00 | 2021-05-15 00:00:00 | 100 | 2021-04-05 00:00:00 | Closed |  |  | 2021-06-01 00:00:00 | 2021-01-07 00:00:00
RD | 67889 | A-123 | Tester Test | Control Deficiency | Collections | 2019 | TGH | 5 | Development |  | TGH |  | 11/10/2020 |  |  |  |  | In Progress
FSA | 10 | OIG | New Row was [NAME] this | Significant Deficiency | Collections | 2020 | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 2021-06-05 00:00:00 | 2021-05-10 00:00:00 | 2021-05-15 00:00:00 | 100 | 2021-05-04 00:00:00 | Closed |  |  | 2021-01-06 00:00:00 | 2021-01-07 00:00:00
FSA | 999 | A-123 | CAP Owner Changed | Significant Deficiency | Collections | 2020 | LTS New | 56 | Implementation | Testing | LTS | In Progress | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-01-06 00:00:00 | 50 | 2020-05-31 00:00:00 | Closed |  |  | 2020-06-15 00:00:00 | 2020-07-15 00:00:00
FSA | 111111 | A-123 |  | Significant Deficiency | Disbursements | 2021 | Link | 1 | Development |  | Lincoln | Not Started | 11/3/2022
RD | 123321123 | ICR | Test | Control Deficiency | Disbursements | 2021 | LTS | 9 | Development | Test | LTS |  | 2/10/2021 | 3/10/2021 |  |  | 12/10/2020 | In Progress | 12/10/2021 | 12/15/2021 |  |  | RED | BLUE