Spreadsheet: 862354d1710111565-data-validation-from-multiple-sheets-w-in-workbook-review_template-redesigned-example-2
Sheet: Project A

 |  |  |  |  |  |  |  |  |  |  |  |  | <<  Return to Summary view
 | Project A
 | Required Completion Date |  | [NAME]) | PROC | Period of Availability |  |  |  | Agreement | 7600A
 | Status | On track | Contract | Letter Contract | Funding Status
 | TASKS | Lead / Assigned to | Milestone | Task Status
 | Set kick-off meeting
 | Agree on objectives
 | [NAME].
 | [NAME].
 | Testing in hardware and software
 | Staffing
 | Techincal Reqs.
 | Testing
 | Testing of various stuff
 | [NAME].
 | System Testing
 | Lab testing of Rampart waveform
 |  |  |  |  |  |  |  |  |  |  |  |  | <<  Return to Summary view
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Input Area
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Milestone status | # | Rnk | Funding Summary | Amounts |  |  | Active Project
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete |  | 4 | Expenditures |  |  |  | PoP Start Date | 2023-03-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | In Progress |  | 3 | Obligations |  |  |  | PopP End Date | 2024-03-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Overdue |  | 2 | Planned Obligations |  |  |  | Funded date | 2023-12-15 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 | 270000 |  | 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 | 75000 |  |  | 75000 | 15000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started |  |  |  |  |  |  | Plan Obs thru CM |  | [NAME] | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 | 30000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Obligations |  | Actual Obs | 28000 | 29000 | 35000 | 15000 | 30000 | 29000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Expenditures |  | Expenditures | 25000 | 25000 | 25000 | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Task # | Tasks | Assigned To | MS? | Planned Start | Actual Start | Planned End | Actual End | Days | Status
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj A Task 1 | [NAME] | Yes | 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 A 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 A Task 3 | [NAME] |  | 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 A Task 4 | [NAME] | Yes | 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 A 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 A Task 6 | [NAME] |  | 2022-09-16 00:00:00 | 2022-09-17 00:00:00 | 2022-09-17 00:00:00 |  |  | In Progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj A Task 7 | [NAME] |  | 2022-09-17 00:00:00 | 2022-09-21 00:00:00 | 2022-09-21 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj A Task 8 | [NAME] |  | 2022-09-24 00:00:00 | 2022-10-02 00:00:00 | 2022-10-02 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj A 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 A Task 10 | [NAME] |  | 2022-10-05 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj A Task 11 | [NAME] |  | 2022-10-06 00:00:00 | 2022-10-09 00:00:00 | 2022-10-09 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj A 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Del # | Deliverable | Due | Delivered?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj A Del 1 | 2024-02-15 00:00:00 | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj A Del 2 | 2024-02-20 00:00:00