Spreadsheet: 735066d1622671541-looking-for-a-formula-to-calc-planned-duration-vs-current-duration-of-a-task-status-report-test
Sheet: Sheet1

Task_Summary_Name | Planned Start | Planned Finish | Actual Start | Actual Finish | % [NAME] |  | Original Budget | Actual $ Spent | Remaining Budget | % Budget Spent | % Budget Remaining | Planned Duration | Current Duration |  | Comments
Task 1 - Mobilization Meetings | 2020-07-14 00:00:00 | 2020-09-21 00:00:00 | 2020-07-14 00:00:00 | 2020-09-21 00:00:00 |  |  | 13982 | 13497.25 |  |  |  |  |  |  | Task Closed
Task 2 - Implementation Planning Meeting | 2020-07-24 00:00:00 | 2020-11-20 00:00:00 | 2020-07-24 00:00:00 | 2020-11-20 00:00:00 |  |  | 59027 | 36403.25 |  |  |  |  |  |  | Task Closed
Task 3 - CRL Project Kickoff, Demo and Business Process Workshop | 2020-08-10 00:00:00 | 2020-08-14 00:00:00 | 2020-09-28 00:00:00 |  |  |  | 61175 | 43040.75 |  |  |  |  |  |  | Task is waiting on Acceptance Form before it can be closed
Task 4 - Construction and Materials Kickoff Implementation Team Training | 2020-11-09 00:00:00 | 2020-11-13 00:00:00 | 2020-11-09 00:00:00 |  |  |  | 64708 | 56643.75 |  |  |  |  |  |  | Task is waiting on Acceptance Form before it can be closed
Task 5 - Civil Rights Functionality Training for the Implementation Team – Generic | 2020-09-14 00:00:00 | 2020-09-18 00:00:00 | 2020-10-12 00:00:00 |  |  |  | 46212 | 28215.75 |  |  |  |  |  |  | Task is waiting on Acceptance Form before it can be closed
Task 6 - Pre-award: DBE Vendor Certification, [NAME], DBE Commitments Workshop | 2020-11-16 00:00:00 | 2020-11-20 00:00:00 | 2020-11-16 00:00:00 |  |  |  | 54710 | 40557.75 |  |  |  |  |  |  | Schedule and budget is impacted by evolving interface requirements and will be delayed.
Task 7 - Pre-Award: [NAME], OJT, Non Agency - [NAME], DBE Commitments & Good Faith Effort Workshop | 2021-01-11 00:00:00 | 2021-01-15 00:00:00 | 2020-11-01 00:00:00 |  |  |  | 71153 | 13657.5 |  |  |  |  |  |  | Schedule and budget is impacted by evolving interface requirements and will be delayed.
Task 8 - Post Award: DBE commitment revisions, Subcontract monitoring, and Subcontract payments Workshop | 2021-02-08 00:00:00 | 2021-02-12 00:00:00 | 2020-01-25 00:00:00 |  |  |  | 65392 | 17251 |  |  |  |  |  |  | Schedule and budget is impacted by evolving interface requirements and will be delayed.
Task 12 - Agency View Development Subcommittee | 2020-12-23 00:00:00 | 2023-04-28 00:00:00 | 2020-12-23 00:00:00 |  |  |  | 137597 | 26831.5
Task 13 - Report Development Subcommittee | 2020-11-16 00:00:00 | 2023-04-28 00:00:00 | 2020-11-16 00:00:00 |  |  |  | 135145 | 4532.5 |  |  |  |  |  |  | Report requirements have been delayed due to focus on data population efforts.
Task 14 - System Administration Subcommittee | 2021-01-07 00:00:00 | 2023-04-28 00:00:00 | 2021-01-07 00:00:00 |  |  |  | 243287 | 12070.25
Task 15 - Technical - Environment & Data Subcommittee | 2020-12-04 00:00:00 | 2023-04-28 00:00:00 | 2021-01-18 00:00:00 |  |  |  | 231881 | 555
Task 16 - Technical - Interfaces Subcommittee | 2021-01-15 00:00:00 | 2023-04-28 00:00:00 | 2021-01-15 00:00:00 |  |  |  | 103934 | 18144.25
Task 17 - Testing Subcommittee | 2020-07-07 00:00:00 | 2022-10-24 00:00:00 | 2020-07-07 00:00:00 |  |  |  | 213829 | 7757.75 |  |  |  |  |  |  | Testing committee has been slow to start, but are not currently on the critical path.
Task 18 - Training, Support, & Communications Subcommittee | 2020-09-21 00:00:00 | 2023-04-28 00:00:00 | 2020-09-21 00:00:00 |  |  |  | 238451 | 93515.75