Spreadsheet: 862366d1710124339-data-validation-from-multiple-sheets-w-in-workbook-indirect-data-val-bvj-
Sheet: Project C

 |  |  |  |  |  |  |  |  |  |  |  |  | <<  Return to Summary view
 | Project C
 | Required Completion Date |  | [NAME]) | O&M | Period of Availability |  |  |  | Agreement | 7600A
 | Status | On track | Contract | FFP | Funding Status
 | TASKS | Lead / Assigned to | Milestone | Task Status
 | Proj C Task 1
 | Proj C Task 2
 | Proj C Task 3
 | Proj C Task 4
 | Proj C Task 5
 | Proj C Task 6
 | Proj C Task 7
 | Proj C Task 8
 | Proj C Task 9
 | Proj C Task 10
 | Proj C Task 11
 | Proj C Task 12
 |  |  |  |  |  |  |  |  |  |  |  |  | <<  Return to Summary view
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Input Area
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Milestone status | # | Rnk | Funding Summary | Amounts |  |  | Active Project
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete |  | 4 | Expenditures |  |  |  | PoP Start Date | 2023-09-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | In Progress |  | 3 | Obligations |  |  |  | PopP End Date | 2024-09-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Overdue |  | 2 | Planned Obligations |  |  |  | Funded date | 2023-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started |  | 1 | Funds Rec'd |  |  |  | Fiscal Year (FY)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APPN Life
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OSD Ob Goal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OSD Expend Goal
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Task Status | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete |  |  |  |  |  |  | Total Planned Obs |  |  | Q1 FY## |  |  | Q2 FY## |  |  | Q3 FY## |  |  | Q4 FY## |  |  | Q1 FY## |  |  | Q2 FY## |  |  | Q3 FY## |  |  | Q4 FY## |  |  | Q1 FY## |  |  | Q2 FY## |  |  | Q3 FY## |  |  | Q4 FY##
 |  |  |  |  |  |  |  |  |  |  |  |  |  | In progress |  |  |  |  |  |  | Project Value | 559000 |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Overdue |  |  |  |  |  |  | Total Funds Rec'd |  | Fund Rec'd | 559000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started |  |  |  |  |  |  | Plan Obs thru CM |  | [NAME] | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 59000 | 20000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Obligations |  | Actual Obs | 60000 | 60000 | 60000 | 58000 | 59000 | 60000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Expenditures |  | Expenditures | 55000 | 58000 | 58000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Task # | Tasks | Assigned To | MS? | Planned Start | Actual Start | Planned End | Actual End | Days | Status
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 1 | [NAME] |  | 2022-09-02 00:00:00 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00 | 2022-09-03 00:00:00 |  | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 2 | [NAME] |  | 2022-09-03 00:00:00 | 2022-09-03 00:00:00 | 2022-09-07 00:00:00 | 2022-09-07 00:00:00 |  | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 3 | [NAME] | Yes | 2022-09-07 00:00:00 | 2022-09-07 00:00:00 | 2022-09-12 00:00:00 | 2022-09-12 00:00:00 |  | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 4 | [NAME] |  | 2022-09-09 00:00:00 | 2022-09-11 00:00:00 | 2022-09-11 00:00:00 | 2022-09-14 00:00:00 |  | Overdue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 5 | [NAME] | Yes | 2022-09-11 00:00:00 | 2022-09-12 00:00:00 | 2024-02-17 00:00:00 | 2024-02-18 00:00:00 |  | In Progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 6 | [NAME] |  | 2022-09-16 00:00:00 | 2022-09-17 00:00:00 | 2022-09-17 00:00:00 |  |  | In Progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 7 | [NAME] |  | 2022-09-17 00:00:00 | 2022-09-21 00:00:00 | 2022-09-21 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 8 | [NAME] |  | 2022-09-24 00:00:00 | 2022-10-02 00:00:00 | 2022-10-02 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 9 | [NAME] | Yes | 2022-10-02 00:00:00 | 2022-10-05 00:00:00 | 2022-10-05 00:00:00 | 2022-10-16 00:00:00 |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 10 | [NAME] |  | 2022-10-05 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 11 | [NAME] |  | 2022-10-06 00:00:00 | 2022-10-09 00:00:00 | 2022-10-09 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 12 |  | Yes | 2024-03-01 00:00:00 | 2024-03-01 00:00:00 | 2024-03-15 00:00:00 | 2024-03-14 00:00:00 |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Del # | Proj C Task 15 | Due | Delivered?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 16 | 2024-02-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 17 | 2024-02-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Task 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Deliverable
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Del 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj C Del 4