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

 |  |  |  |  |  |  |  |  |  |  |  |  | <<  Return to Summary view
 | Project B
 | Required Completion Date |  | [NAME]) | RDTE | Period of Availability |  |  |  | Agreement | 7600A
 | Status | On track | Contract | Letter Contract | Funding Status
 | TASKS | Lead / Assigned to | Milestone | Task Status
 | Proj B Task 1
 | Proj B Task 2
 | Proj B Task 3
 | Proj B Task 4
 | Proj B Task 5
 | Proj B Task 6
 | Proj B Task 7
 | Proj B Task 8
 | Proj B Task 9
 | Proj B Task 10
 | Proj B Task 11
 | Proj B Task 12
 |  |  |  |  |  |  |  |  |  |  |  |  | <<  Return to Summary view
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Input Area
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Milestone status | # | Rnk | Funding Summary | Amounts |  |  | Active Project
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete |  | 4 | Expenditures |  |  |  | PoP Start Date | 2024-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | In Progress |  | 3 | Obligations |  |  |  | PopP End Date | 2024-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Overdue |  | 2 | Planned Obligations |  |  |  | Funded date | 2024-01-01 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 | 1299000 |  | 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 |  | 225000 | 225000 | 225000 | 225000 | 225000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started |  |  |  |  |  |  | Plan Obs thru CM |  | [NAME] |  | 130000 | 130000 | 130000 | 130000 | 130000 | 130000 | 130000 | 130000 | 130000 | 130000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Obligations |  | Actual Obs |  | 117250 | 120000 | 115000 | 80000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Expenditures |  | Expenditures |  | 112000 | 120000 | 110000 | 79500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Task # | Tasks | Assigned To | MS? | Planned Start | Actual Start | Planned End | Actual End | Days | Status
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj B 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 B Task 2 | [NAME] | Yes | 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 B 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 B 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 B Task 5 | [NAME] |  | 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 B Task 6 | [NAME] | Yes | 2022-09-16 00:00:00 | 2022-09-17 00:00:00 | 2022-09-17 00:00:00 |  |  | In Progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj B Task 7 | [NAME] |  | 2022-09-17 00:00:00 | 2022-09-21 00:00:00 | 2022-09-21 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj B Task 8 | [NAME] |  | 2022-09-24 00:00:00 | 2022-10-02 00:00:00 | 2022-10-02 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj B Task 9 | [NAME] |  | 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 B Task 10 | [NAME] | Yes | 2022-10-05 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj B Task 11 | [NAME] |  | 2022-10-06 00:00:00 | 2022-10-09 00:00:00 | 2022-10-09 00:00:00 |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj B 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 B Del 5 | 2024-02-15 00:00:00 | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj B Del 6 | 2024-02-20 00:00:00