Spreadsheet: 712929d1610479132-possible-vlookup-formula-fy21-resource-management
Sheet: Master Project List

Project Status | Project No | Project Description | Start Date | End Date | Category | PM | IT Lead | [NAME] | Nick | [NAME] | [NAME] | Will | Shaun | Charlotte | [NAME] | Chad | Tyler | Rachel | Niel
Completed | FY21-001 | 911 Installation - AL SRCV | 2020-09-17 00:00:00 | 2020-10-31 00:00:00 | Internal | Chad
Completed | FY21-002 | Access DX | 2020-09-01 00:00:00 | 2020-12-01 00:00:00 | External | Tyler
Not Applicable | Not Applicable | Ad Hoc Reporting/Scripting | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
 | FY21-003 | ASA Replacement | 2021-01-01 00:00:00 | 2021-02-28 00:00:00 | Internal | Tyler |  | 40
Completed | FY21-004 | Badge Printing | 2020-09-01 00:00:00 | 2020-09-30 00:00:00 | Internal | Rachel
In Process | FY21-005 | BI Year 2 - replace primeVIEW | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | External | Rachel
Completed | FY21-006 | CPCV ADT - GH | 2020-09-01 00:00:00 | 2020-10-30 00:00:00 | External | Chad
In Process | FY21-007 | CPCV Comcast - GH | 2020-09-01 00:00:00 | 2021-01-31 00:00:00 | External | Chad
Not Applicable | Not Applicable | Database Upgrades/Maintenance | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Not Started | FY21-008 | DMVPN Replacement - CLQ | 2021-06-01 00:00:00 | 2021-06-15 00:00:00 | Internal | Not Applicable | [NAME] | 16
Not Started | FY21-009 | Document Manager [NAME] | 2021-04-01 00:00:00 | 2021-06-30 00:00:00 | Internal | Chad
Completed | FY21-010 | Document Manager [NAME] | 2020-09-01 00:00:00 | 2020-10-22 00:00:00 | External | Chad
Postponed to FY22 | FY21-011 | E-Fax conversion |  |  | External | Tyler
In Process | FY12-012 | Electronic Associate/Visitor Log | 2020-09-01 00:00:00 | 2021-03-31 00:00:00 | External | Chad
Not Applicable | Not Applicable | FMLA | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Canceled | FY21-013 | Forecasting in Solver | 2021-04-01 00:00:00 | 2021-06-30 00:00:00 | External
In Process | FY21-014 | Framework Phase II | 2020-09-01 00:00:00 | 2021-03-31 00:00:00 | External | Tyler
Not Applicable | Not Applicable | Funeral Leave | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Not Applicable | Not Applicable | General [NAME] | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable |  | 365
Not Applicable | Not Applicable | General App | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable |  | 50
Not Applicable | Not Applicable | General [NAME] | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable |  | 510
Not Applicable | Not Applicable | General Servers | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable |  | 100
Not Applicable | Not Applicable | General [NAME] | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable |  | 100
Not Applicable | Not Applicable | General Telecommunications | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable |  | 410
Not Applicable | Not Applicable | Governance | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Not Applicable | Not Applicable | Governance - Pharmacy | 2021-01-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Not Started | FY21-015 | iPad Refresh | 2021-02-01 00:00:00 | 2021-06-30 00:00:00 | Internal | Rachel
Not Started | FY21-016 | iPod Refresh | 2021-02-01 00:00:00 | 2021-06-30 00:00:00 | Internal | Rachel
Not Applicable | Not Applicable | Invoicing | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Not Started | FY21-017 | [NAME] | 2021-03-01 00:00:00 | 2021-05-01 00:00:00 | Internal |  | [NAME] | 24
Not Applicable | Not Applicable | Maternity Leave | 2020-09-19 00:00:00 | 2020-12-06 00:00:00 | General | Not Applicable
Not Applicable | Not Applicable | Military Leave | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Not Applicable | Not Applicable | [NAME] Off | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
In Process | FY21-018 | National Lab connection to PCC | 2021-01-01 00:00:00 | 2021-06-30 00:00:00 | External | Tyler
Not Started | FY21-019 | O365 Applications | 2021-02-15 00:00:00 | 2021-06-30 00:00:00 | External | Tyler
In Process | FY21-020 | O365 Exchange | 2020-09-01 00:00:00 | 2021-02-28 00:00:00 | External | Tyler
Not Started | FY21-021 | [NAME] | 2021-03-01 00:00:00 | 2021-06-30 00:00:00 | External | Tyler
Not Applicable | Not Applicable | On Call Support | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
 | FY21-022 | PC Refresh | 2021-01-01 00:00:00 | 2021-06-30 00:00:00 | Internal | Rachel |  | 48
Not Started | FY21-023 | PCC AL/IL & Resident Event Calendar | 2021-04-01 00:00:00 | 2021-06-30 00:00:00 | External | Tyler
In Process | FY21-024 | Pharmacy Strategic Growth | 2020-11-02 00:00:00 | 2021-06-30 00:00:00 | External | Chad
Postponed to FY22 | FY21-025 | Phish Training |  |  | External | Chad | [NAME]
 | FY21-026 | Phone Refresh | 2021-01-01 00:00:00 | 2021-06-30 00:00:00 | Internal | Rachel |  | 40
Not Applicable | Not Applicable | Policies and Procedures | 2021-01-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Not Applicable | Not Applicable | PTO | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Completed | FY21-027 | Rapid POC COVID Testing | 2020-09-01 00:00:00 | 2020-11-06 00:00:00 | External | Chad
Completed | FY21-028 | RBCV Phone System | 2020-09-01 00:00:00 | 2020-11-06 00:00:00 | External | Chad
In Process | FY21-029 | RSCV Nurse Call | 2020-09-01 00:00:00 | 2021-01-31 00:00:00 | External | Chad
On Hold | FY21-030 | SCCM (MDM, Reporting, Inventory, [NAME]) | 2020-09-01 00:00:00 | 2021-03-31 00:00:00 | Internal | Not Applicable | [NAME]
In Process | FY21-031 | Security Systems (LMCV) | 2021-01-01 00:00:00 | 2021-02-28 00:00:00 | External | Chad |  | 24
In Process | FY21-032 | Security Systems (TELP) | 2021-01-01 00:00:00 | 2021-02-28 00:00:00 | External | Chad |  | 24
In Process | FY21-033 | Server Upgrades | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | Internal | Tyler
Completed | FY21-034 | Touchtown (LMCV) | 2020-10-01 00:00:00 | 2020-10-30 00:00:00 | External | Chad
In Process | FY21-035 | Touchtown (RSCV) | 2020-10-01 00:00:00 | 2021-01-31 00:00:00 | External | Chad
On Hold | FY21-036 | Track-It | 2020-09-01 00:00:00 | 2021-02-28 00:00:00 | External | Chad |  | 32
Not Applicable | Not Applicable | Training/Seminars | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Not Applicable | Not Applicable | Travel | 2020-09-01 00:00:00 | 2021-06-30 00:00:00 | General | Not Applicable
Not Started | FY21-037 | UAT Environment [NAME] | 2021-02-01 00:00:00 | 2021-06-30 00:00:00 | Internal | Not Applicable | [NAME]
Not Started | FY21-038 | Umbrella Revamp | 2021-02-01 00:00:00 | 2021-02-28 00:00:00 | Internal |  | [NAME] | 40
In Process | FY21-039 | Wireless Upgrade - Meraki ([NAME], LMCV, THCV, HPCV) | 2020-10-01 00:00:00 | 2021-02-15 00:00:00 | External | Tyler |  | 192
 | FY21-040 | WVEL on MPLS | 2021-01-01 00:00:00 | 2021-01-31 00:00:00 | Internal |  | [NAME] | 16
In Process | FY21-041 | WVEL Nurse Call | 2021-01-01 00:00:00 | 2021-01-31 00:00:00 | Internal | Chad
Total
Per FTE Calcs