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

 | As of: | 2023-09-30 00:00:00 | Column1 | Auth | Req | On Hand | Vacancies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APPR | Sponsor Funding
 | Program/Project: |  |  | 5 | 5 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APPR | [NAME] | Customer | Space Force | OSD | RCO | SCO | OUSD R&E | SOCOM | Army PEO-EIS/Hardware | A4S / LCMC | AFMC | A3 / SOCOM | DARPA | Navy PEO Ships | ONR / Multiple | Navy IWS
 | Sponsor/Customer: |  |  | 3 | 3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RDT&E
 | Directorate: |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O&M
 | Program Mgr: |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROC
 | PE: |  |  | 10 | 10 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FMS PROC
 | Overall Status: | On track | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Description:
 | Project | Customer | PoP Start | PoP End | Project Value  ($K) | Funds Rec'd  ($K) | % Funded | Planned Obligations  ($K) | Actual Obligations  ($K) | % Obligated | Plan to Actual Variance | OSD Ob Target | Funds Expended  ($K) | % Expended | OSD Expend Target | % Expend Variance | Active?
 | Project 4 |  | 2021-11-08 00:00:00 | 2022-10-08 00:00:00
 | Project 3 |  | 2022-01-03 00:00:00 | 2024-06-01 00:00:00
 | Total
 | Project | Customer | PoP Start | PoP End | Project Value  ($K) | Funds Rec'd  ($K) | % Funded | Planned Obligations  ($K) | Actual Obligations  ($K) | % Obligated | Plan to Actual Variance | OSD Ob Target | Funds Expended  ($K) | % Expended | OSD Expend Target | % Expend Variance | Active Projects
 | Project 4 | Multiple | 2021-11-08 00:00:00 | 2022-10-08 00:00:00
 | Project 3 | RCO | 2022-01-03 00:00:00 | 2024-06-01 00:00:00
 | Total
 | Project | Objectives | MS # | Milestones | Planned Completion | Actual Completion
 | Project 3 |  |  | Final Reqts
 | Project 3 |  |  | Dev. Complete | 2022-10-05 00:00:00
 | Project 3 |  |  | Launch | 2022-10-10 00:00:00
 | Project 4 |  |  | Task 8 | 2022-10-02 00:00:00
 | Objectives |  |  |  |  |  | M | Milestones (M) |  |  |  |  |  |  | Planned | Actual
 |  |  |  |  |  |  | M1 |  |  |  |  |  |  |  | 2023-09-30 00:00:00 | 2023-07-10 00:00:00
 |  |  |  |  |  |  | M2 |  |  |  |  |  |  |  | 2023-12-30 00:00:00
 |  |  |  |  |  |  | M3 |  |  |  |  |  |  |  | 2023-12-31 00:00:00
 |  |  |  |  |  |  | M4 |  |  |  |  |  |  |  | 2024-08-31 00:00:00 | 2024-08-31 00:00:00
 |  |  |  |  |  |  | M5 |  |  |  |  |  |  |  | 2023-10-01 00:00:00 | 2023-09-14 00:00:00
 |  |  |  |  |  |  | M6 |  |  |  |  |  |  |  | 2023-11-01 00:00:00
 |  |  |  |  |  |  | M7 |  |  |  |  |  |  |  | 2024-01-01 00:00:00
 |  |  |  |  |  |  | M8 |  |  |  |  |  |  |  | 2023-10-15 00:00:00
 |  |  |  |  |  |  | M9 |  |  |  |  |  |  |  | 2023-11-01 00:00:00
 |  |  |  |  |  |  | M10 |  |  |  |  |  |  |  | 2024-04-01 00:00:00
 |  |  |  |  |  |  | M11 |  |  |  |  |  |  |  | 2024-06-01 00:00:00
 |  |  |  |  |  |  | M12 |  |  |  |  |  |  |  | 2023-12-01 00:00:00
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | 2024-01-25 00:00:00
 |  |  |  |  |  |  | M14 |  |  |  |  |  |  |  | 2023-06-30 00:00:00
 |  |  |  |  |  |  | M15
 |  |  |  |  |  |  | M16
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | 2023-10-20 00:00:00
 |  |  |  |  |  |  | M18 |  |  |  |  |  |  |  | 2023-12-19 00:00:00
 |  |  |  |  |  |  | M19 |  |  |  |  |  |  |  | 2024-04-17 00:00:00
 |  |  |  |  |  |  | M20 |  |  |  |  |  |  |  | 2024-05-17 00:00:00
 |  |  |  |  |  |  | M21 |  |  |  |  |  |  |  | 2023-10-26 00:00:00
 |  |  |  |  |  |  | M22 |  |  |  |  |  |  |  | Nov '23 TBD
 | [NAME]
 | Significant Accomplishments |  |  |  |  | Risk (R) |  |  |  |  | Corrective Action (CA) / Mitigation Plan
 | M - Green - Met or Exceed Planned |  |  | M - Yellow - Within 30 days of Planned |  |  |  | M - Orange - Within 15 days of Planned |  |  | M - Red - Past Due