Spreadsheet: 708248d1607694172-formula-for-targeting-a-closure-goal-samplesheet2
Sheet: Logger

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 | dateadded
 |  | Date | FY Cases Logged by Target Date | 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 | Number in FY Submitted for Closure | % in FY Submitted for Closure | Number in FY Closed by Review Date | % in FY Closed by Review Date
 |  | 2020-10-02 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 | Date Entry Added
FSA | 999 | A-123 | CAP Owner Changed | Significant Deficiency | Collections |  | LTS New | 56 | Implementation | Testing | LTS | In Progress | 1/6/2020 | 2/6/2020 | 1/6/2020 | 90 | 5/31/2020 | Closed |  |  | 5/12/2020 | 6/15/2020 | A | M | 12/11/2019
FSA | 10556 | OIG | New Test 1 | Significant Deficiency | [NAME] |  | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 5/6/2021 | 5/10/2021 | 5/15/2021 | 100 | 4/5/2021 | Closed |  |  | 6/1/2021 | 1/7/2021 | B | N | 9/11/2020
FSA | 89 | A-123 | Testing | Significant Deficiency | [NAME] |  | LTS | 56 | Implementation | Testing | LTS | Complete | 6/1/2020 | 6/2/2020 | 6/1/2020 | 100 | 5/31/2020 | Closed | 12/10/2020 | 12/16/2020 | 6/5/2020 | 6/15/2020 | A | O | 11/11/2020
FSA | 5 | OIG | New Test 1 | Significant Deficiency | [NAME] |  | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 5/6/2021 | 5/10/2021 | 5/15/2021 | 85 | 4/5/2021 | Closed |  |  | 6/1/2021 | 1/7/2021 |  |  | 12/11/2020
RD | 5 | OIG | New Test 1 | Significant Deficiency | [NAME] |  | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 5/6/2021 | 5/10/2021 | 5/15/2021 | 85 | 4/5/2021 | Closed |  |  | 6/1/2021 | 1/7/2021 |  |  | 3/11/2020
FSA | 5 | OIG | New Test 2 | Significant Deficiency | Collections |  | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 5/6/2021 | 5/10/2021 | 5/15/2021 | 85 | 4/5/2021 | Closed |  |  | 6/1/2021 | 1/7/2021 |  |  | 1/11/2020
FSA | 10 | OIG | New Test 1 | Significant Deficiency | Collections |  | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 5/6/2021 | 5/10/2021 | 5/15/2021 | 100 | 4/5/2021 | Closed |  |  | 6/1/2021 | 1/7/2021 |  |  | 9/11/2020
RD | 67889 | A-123 | Tester Test | Control Deficiency | Collections |  | TGH | 5 | Development |  | TGH |  | 11/10/2020 |  |  |  |  | In Progress | 12/10/2020 | 12/15/2020 |  |  |  |  | 7/11/2020
FSA | 10 | OIG | New Row was [NAME] this | Significant Deficiency | Collections |  | LTS | 1 | Monitoring | New Test 1 | LTS | Complete | 6/5/2021 | 5/10/2021 | 5/15/2021 | 100 | 5/4/2021 | Closed |  |  | 1/6/2021 | 1/7/2021 |  |  | 9/11/2019
FSA | 999 | A-123 | CAP Owner Changed | Significant Deficiency | Collections |  | LTS New | 56 | Implementation | Testing | LTS | In Progress | 6/1/2020 | 6/2/2020 | 1/6/2020 | 50 | 5/31/2020 | Closed |  |  | 6/15/2020 | 7/15/2020 |  |  | 7/17/2020
FSA | 111111 | A-123 |  | Significant Deficiency | Disbursements |  | Link | 1 | Development |  | Lincoln | Not Started | 11/3/2022 |  |  |  |  |  |  |  |  |  |  |  | 8/11/2020
RD | 123321123 | ICR | Test | Control Deficiency | Disbursements |  | LTS | 9 | Development | Test | LTS |  | 2/10/2021 | 3/10/2021 |  |  | 12/10/2020 | In Progress | 12/10/2021 | 12/15/2021 |  |  | RED | BLUE | 9/11/2020
RD | 000999888 | GAO | RDTEST | Material Weakness | Budgetary Authority |  | LTS | 1 | Development | RDTEST | LTS |  | 6/11/2021 |  |  |  |  | In Progress | 12/11/2021 |  |  |  | RDTEST | RDTEST | 12/11/2020