Spreadsheet: 859984d1708217718-xlookup-maybe-nested-indirect-and-excel-tables-to-get-value-example_template-redesigned
Sheet: Project 3

 | Project 3
 | Project Dashboard
 | Required Completion Date |  |  | [NAME]) | RDTE | Period of Availability
 | Status | On track |  | Agreement | 7600A | Funding Status
 | TASKS | Lead / Assigned to | Milestone | Task Status
 | Set kick-off meeting
 | Agree on objectives
 | [NAME].
 | [NAME].
 | Final Reqts
 | Staffing
 | Techincal Reqs.
 | Testing
 | Dev. Complete
 | [NAME].
 | System Testing
 | Launch
Task # | Tasks | Assigned To | MS? | Planned Start | Actual Start | Planned End | Actual End | Days | Status |  |  | Task Status | % |  |  | Funded date | 2022-12-15 00:00:00
 | Set kick-off meeting | [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 |  |  | Complete |  |  |  | Fiscal Year (FY)
 | Agree on objectives | [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 |  |  | In progress |  |  |  | APPN Life
 | [NAME]. | [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 |  |  | Overdue |  |  |  | Ob [NAME]
 | [NAME]. | [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 |  |  | Not Started |  |  |  | Expend Goal
 | Final Reqts | [NAME] | Y | 2022-09-11 00:00:00 | 2022-09-12 00:00:00 | 2022-09-15 00:00:00 |  |  | In Progress
 | Staffing | [NAME] |  | 2022-09-16 00:00:00 | 2022-09-17 00:00:00 | 2022-09-17 00:00:00 |  |  | In Progress |  |  | Items status | # |  |  |  |  |  | Q1 FY## |  |  | Q2 FY## |  |  | Q3 FY## |  |  | Q4 FY##
 | Techincal Reqs. | [NAME] |  | 2022-09-17 00:00:00 | 2022-09-21 00:00:00 | 2022-09-21 00:00:00 |  |  | Not Started |  |  | Decision |  |  |  | Project Value | 163549 |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
 | Testing | [NAME] |  | 2022-09-24 00:00:00 | 2022-10-02 00:00:00 | 2022-10-02 00:00:00 |  |  | Not Started |  |  | Action |  |  |  | Total Funds Rec'd |  | Fund Rec'd | 0 | 135500
 | Dev. Complete | [NAME] | Y | 2022-10-02 00:00:00 | 2022-10-05 00:00:00 | 2022-10-05 00:00:00 |  |  | Not Started |  |  | [NAME] |  |  |  | Total Planned Obs |  | [NAME] |  | 135500
 | [NAME]. | [NAME] |  | 2022-10-05 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 |  |  | Not Started |  |  |  |  |  |  | Total Obligations |  | Actual Obs |  | 117250
 | System Testing | [NAME] |  | 2022-10-06 00:00:00 | 2022-10-09 00:00:00 | 2022-10-09 00:00:00 |  |  | Not Started |  | Rnk | Funding Summary | Amounts |  |  | Total Expenditures |  | Expenditures |  | 112000
 | Launch |  | Y | 2022-10-09 00:00:00 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 |  |  |  |  | 4 | Total Expenditures
 |  |  |  |  |  |  |  |  |  |  | 3 | Total Obligations
 |  |  |  |  |  |  |  |  |  |  | 2 | Total Planned Obs
 |  |  |  |  |  |  |  |  |  |  | 1 | Total Funds Rec'd
 |  |  |  |  |  |  |  |  |  |  |  | Pending Items | Status
 |  |  |  |  |  |  |  |  |  |  |  | Item 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Item 2 | Action
 |  |  |  |  |  |  |  |  |  |  |  | Item 3 | Decision
 |  |  |  |  |  |  |  |  |  |  |  | Item 4 | Decision
 |  |  |  |  |  |  |  |  |  |  |  | Item 5 | Action
 |  |  |  |  |  |  |  |  |  |  |  | Item 6 | Action
 |  |  |  |  |  |  |  |  |  |  |  | Item 7 | Action