Spreadsheet: 761841d1641249706-if-formula-with-multiple-conditions-resource-allocatoin-2022-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 176 |  |  | 160 |  |  | 176
 |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 |  |  | 2022-02-01 00:00:00 |  |  | 2022-03-01 00:00:00 |  |  | 2022-04-01 00:00:00 |  |  | 2022-05-01 00:00:00 |  |  | 2022-06-01 00:00:00 |  |  | 2022-07-01 00:00:00 |  |  | 2022-08-01 00:00:00 |  |  | 2022-09-01 00:00:00 |  |  | 2022-10-01 00:00:00 |  |  | 2022-11-01 00:00:00 |  |  | 2022-12-01 00:00:00
Project | Name | Start | Finish | Resource | Work | Date | Use |  | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul | [NAME] | [NAME] | Raul
 | Total Resource Commitment by Resource and Month
Client | O&M Data Migration
Client | Data Conversion | 2022-01-13 00:00:00 | 2022-01-21 00:00:00 | [NAME] | 40
Client | Initial Data Review | 2022-01-21 00:00:00 | 2022-01-24 00:00:00 | [NAME] | 8
Client | Data Revisions based on client feedback | 2022-01-31 00:00:00 | 2022-02-01 00:00:00 | [NAME] | 8
Client | Work Order Cost BIRT Report Spec and Dev | 2022-02-07 00:00:00 | 2022-02-14 00:00:00 | [NAME] | 40
Client | Workflow Test (Quick Start Verification) | 2022-02-01 00:00:00 | 2022-02-07 00:00:00 | [NAME] | 32
Client | Revise Configuration as needed | 2022-02-07 00:00:00 | 2022-02-09 00:00:00 | [NAME] | 16
Client | Final Workflow Test | 2022-02-09 00:00:00 | 2022-02-11 00:00:00 | [NAME] | 16
Client | Revise and finalize SOP | 2022-02-16 00:00:00 | 2022-02-18 00:00:00 | [NAME] | 24
Client | O&M Training
Client | Training Materials Preparation | 2022-02-22 00:00:00 | 2022-02-28 00:00:00 | [NAME] | 40
Client | Updates to training materials based on client feedback | 2022-03-03 00:00:00 | 2022-03-03 00:00:00 | [NAME] | 8
Client | O&M Training (Train-the-Trainer) | 2022-03-11 00:00:00 | 2022-03-17 00:00:00 | [NAME] | 40
Client | Go Work Management | 2022-03-18 00:00:00 | 2022-03-23 00:00:00 | [NAME] | 16
Client | Go Asset Management | 2022-03-24 00:00:00 | 2022-03-25 00:00:00 | [NAME] | 16
Client | IQ
Client | Training Prep | 2022-03-11 00:00:00 | 2022-03-11 00:00:00 | [NAME] | 8
Client | Training Delivery | 2022-03-14 00:00:00 | 2022-03-16 00:00:00 | [NAME] | 24
Client | Go Live
Client | Data Cutover | 2022-04-15 00:00:00 | 2022-04-18 00:00:00 | [NAME] | 16
Client | Go Live Support | 2022-04-19 00:00:00 | 2022-04-21 00:00:00 | [NAME] | 20
Client | ENGAGE Request (up to 4 templates)
Client | Project Implementation Management | 2022-01-20 00:00:00 | 2022-01-25 00:00:00 | [NAME] | 24
Client | Technical Installation Services
Client | ReADY Deployment | 2022-01-20 00:00:00 | 2022-01-31 00:00:00 | [NAME] | 30
Client | Authentication Services (LDAP, CAS or [NAME] only) | 2022-01-20 00:00:00 | 2022-01-28 00:00:00 | [NAME] | 24
Client | Initial Training / Kickoff / Process Review
Client | Kickoff & Conceptual Training | 2022-02-14 00:00:00 | 2022-02-15 00:00:00 | [NAME] | 4
Client | Existing Request Process Review | 2022-02-15 00:00:00 | 2022-02-16 00:00:00 | [NAME] | 4
Client | BI Resource Cardinal Reports | 2022-02-16 00:00:00 | 2022-03-10 00:00:00 | [NAME] | 0
Client | Template Design and Testing
Client | Shop Interviews | 2022-02-16 00:00:00 | 2022-02-23 00:00:00 | [NAME] | 16
Client | Template Requirements Documentation | 2022-03-02 00:00:00 | 2022-03-09 00:00:00 | [NAME] | 20
Client | Template Requirements Review / Edits | 2022-03-02 00:00:00 | 2022-03-07 00:00:00 | [NAME] | 12
Client | Setup Hierarchy / Access Plan | 2022-03-07 00:00:00 | 2022-03-08 00:00:00 | [NAME] | 4
Client | Form Builder – Request Templates (Roles, Responsibilities, & Permissions, Groups, Templates, & Template Properties, Dynamic Data Widget Configuration, Users, Employees, Contact Profiles, Workflow Editor) | 2022-02-22 00:00:00 | 2022-03-10 00:00:00 | [NAME] | 48
Client | Notification Templates | 2022-03-10 00:00:00 | 2022-03-11 00:00:00 | [NAME] | 4
Client | Adjustment Documentation and Testing
Client | Test Script / SOP Creation | 2022-03-11 00:00:00 | 2022-03-15 00:00:00 | [NAME] | 8
Client | Request Test / Testing | 2022-03-15 00:00:00 | 2022-03-17 00:00:00 | [NAME] | 6
Client | Adjustments / Final Testing / Approval | 2022-03-24 00:00:00 | 2022-03-28 00:00:00 | [NAME] | 8
Client | Finalize SOP Documentation / Approval | 2022-04-19 00:00:00 | 2022-04-19 00:00:00 | [NAME] | 4
Client | Go-Live Support and Training / Handoff to Customer Care | 2022-04-20 00:00:00 | 2022-04-21 00:00:00 | [NAME] | 8
Client | Training / Adjustments | 2022-04-20 00:00:00 | 2022-04-20 00:00:00 | [NAME] | 4
Client | Professional Services Review / Client Transition to Customer Care | 2022-04-21 00:00:00 | 2022-04-21 00:00:00 | [NAME] | 4
Client | Space & Property Implementation
Client | Project Management
Client | Project Implementation Management | 2022-02-14 00:00:00 | 2022-02-22 00:00:00 | [NAME] | 30
Client | Executive Sponsor Meetings (Ongoing) | 2022-02-22 00:00:00 | 2022-02-24 00:00:00 | [NAME] | 16
Client | Application Installation
Client | CAD Installation | 2022-02-22 00:00:00 | 2022-02-23 00:00:00 | [NAME] | 8
Client | Implementation Planning
Client | Kickoff Call with Client Project Manager | 2022-03-01 00:00:00 | 2022-03-01 00:00:00 | [NAME] | 2
Client | Roles and Responsibilities | 2022-03-02 00:00:00 | 2022-03-02 00:00:00 | [NAME] | 2
Client | Review Statement of Work | 2022-03-02 00:00:00 | 2022-03-02 00:00:00 | [NAME] | 2
Client | Resource Requirements | 2022-03-02 00:00:00 | 2022-03-02 00:00:00 | [NAME] | 2
Client | Implementation Timeline | 2022-03-02 00:00:00 | 2022-03-03 00:00:00 | [NAME] | 4
Client | Assignment of Deliverables | 2022-03-03 00:00:00 | 2022-03-03 00:00:00 | [NAME] | 2
Client | Prepare Preliminary Implementation Plan | 2022-03-03 00:00:00 | 2022-03-03 00:00:00 | [NAME] | 2
Client | Prepare Project Documentation (i.e. communication plans) | 2022-03-03 00:00:00 | 2022-03-03 00:00:00 | [NAME] | 2
Client | Training: Initial Data Load Template Review | 2022-03-04 00:00:00 | 2022-03-04 00:00:00 | [NAME] | 3
Client | Client Prepares/Submits Sample Data | 2022-03-04 00:00:00 | 2022-03-09 00:00:00 | [NAME] | 0
Client | Load Sample Institutional Data | 2022-03-09 00:00:00 | 2022-03-10 00:00:00 | [NAME] | 6
Client | Initial Training
Client | Conceptual Overview Training | 2022-03-10 00:00:00 | 2022-03-14 00:00:00 | [NAME] | 16
Client | Application SysAdmin Training | 2022-03-14 00:00:00 | 2022-03-15 00:00:00 | [NAME] | 8
Client | CAD Initial Training | 2022-04-07 00:00:00 | 2022-04-11 00:00:00 | [NAME] | 16
Client | Business Process Analysis, SOP, & Initial System Setup |  |  | [NAME]
Client | As-Is (Summary Review) | 2022-03-17 00:00:00 | 2022-03-17 00:00:00 | [NAME] | 4
Client | To-Be Process Definition | 2022-03-18 00:00:00 | 2022-03-22 00:00:00 | [NAME] | 20
Client | Finalize BPA documentation | 2022-03-22 00:00:00 | 2022-03-24 00:00:00 | [NAME] | 16
Client | SOP Revisions Based on Client Feedback | 2022-03-29 00:00:00 | 2022-03-30 00:00:00 | [NAME] | 8
Client | System Setup | 2022-04-04 00:00:00 | 2022-04-07 00:00:00 | [NAME] | 24
Client | Data Migration
Client | Data Mapping | 2022-03-22 00:00:00 | 2022-03-23 00:00:00 | [NAME] | 8
Client | Data Conversion 1 | 2022-03-30 00:00:00 | 2022-03-31 00:00:00 | [NAME] | 8
Client | Initial Data Review | 2022-03-31 00:00:00 | 2022-03-31 00:00:00 | [NAME] | 4
Client | Data Revisions based on client feedback | 2022-04-06 00:00:00 | 2022-04-06 00:00:00 | [NAME] | 4
Client | Data Conversion 2 | 2022-04-19 00:00:00 | 2022-04-19 00:00:00 | [NAME] | 8
Client | Initial Data Review | 2022-04-20 00:00:00 | 2022-04-20 00:00:00 | [NAME] | 4
Client | Data Revisions based on client feedback | 2022-04-22 00:00:00 | 2022-04-22 00:00:00 | [NAME] | 4
Client | Workflow Test & System Setup Finalization
Client | Create script for Workflow Test (UAT) | 2022-04-11 00:00:00 | 2022-04-13 00:00:00 | [NAME] | 16
Client | Updates to WW script based on client feedback | 2022-04-15 00:00:00 | 2022-04-15 00:00:00 | [NAME] | 4
Client | Workflow Test (System Verification) | 2022-04-27 00:00:00 | 2022-04-28 00:00:00 | [NAME] | 16
Client | Revise Configuration as needed | 2022-04-29 00:00:00 | 2022-04-29 00:00:00 | [NAME] | 8
Client | CAD UAT Test | 2022-05-02 00:00:00 | 2022-05-02 00:00:00 | [NAME] | 4
Client | Final Workflow Test | 2022-05-04 00:00:00 | 2022-05-04 00:00:00 | [NAME] | 8
Client | Revise and finalize SOP | 2022-05-06 00:00:00 | 2022-05-06 00:00:00 | [NAME] | 8
Client | Training
Client | Training Materials Preparation | 2022-05-11 00:00:00 | 2022-05-12 00:00:00 | [NAME] | 16
Client | Updates to training materials based on client feedback | 2022-05-17 00:00:00 | 2022-05-17 00:00:00 | [NAME] | 4
Client | Space End User Training | 2022-05-24 00:00:00 | 2022-05-26 00:00:00 | [NAME] | 16
Client | CAD User Training | 2022-05-26 00:00:00 | 2022-05-31 00:00:00 | [NAME] | 16
Client | Go Live
Client | Data Cutover | 2022-06-07 00:00:00 | 2022-06-08 00:00:00 | [NAME] | 8
Client | Go Live Support | 2022-06-08 00:00:00 | 2022-06-10 00:00:00 | [NAME] | 16
Client | ACAD Go Live Support | 2022-06-08 00:00:00 | 2022-06-09 00:00:00 | [NAME] | 8
Client | Post Go-Live Follow-up | 2022-06-10 00:00:00 | 2022-06-14 00:00:00 | [NAME] | 16
Client | Real Estate and Lease Management Implementation
Client | Project Management
Client | Project Implementation Management | 2022-05-18 00:00:00 | 2022-05-24 00:00:00 | [NAME] | 24
Client | Implementation Planning
Client | Kickoff Call with Client Project Manager | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | [NAME] | 1
Client | Roles and Responsibilities | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | [NAME] | 1
Client | Review Statement of Work | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | [NAME] | 1
Client | Resource Requirements | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | [NAME] | 1
Client | Implementation Timeline | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | [NAME] | 2
Client | Assignment of Deliverables | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | [NAME] | 1
Client | Prepare Preliminary Implementation Plan | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | [NAME] | 2
Client | Prepare Project Documentation (i.e. communication plans) | 2022-05-26 00:00:00 | 2022-05-26 00:00:00 | [NAME] | 2
Client | Training: Initial Data Load Template Review | 2022-05-26 00:00:00 | 2022-05-26 00:00:00 | [NAME] | 3
Client | Load Sample Institutional Data | 2022-06-02 00:00:00 | 2022-06-02 00:00:00 | [NAME] | 6
Client | Initial Training
Client | Conceptual Overview Training | 2022-06-02 00:00:00 | 2022-06-06 00:00:00 | [NAME] | 12
Client | Application SysAdmin Training | 2022-06-06 00:00:00 | 2022-06-07 00:00:00 | [NAME] | 8
Client | Business Process Analysis, SOP, & Initial System Setup
Client | As-Is (Summary Review) | 2022-06-09 00:00:00 | 2022-06-09 00:00:00 | [NAME] | 4
Client | To-Be Process Definition | 2022-06-09 00:00:00 | 2022-06-13 00:00:00 | [NAME] | 16
Client | Finalize BPA documentation | 2022-06-13 00:00:00 | 2022-06-15 00:00:00 | [NAME] | 16
Client | Initial Standard Operating Procedures Documentation
Client | SOP Revisions Based on Client Feedback | 2022-06-21 00:00:00 | 2022-06-22 00:00:00 | [NAME] | 8
Client | System Setup | 2022-07-20 00:00:00 | 2022-07-25 00:00:00 | [NAME] | 24
Client | Data Migration
Client | Data Mapping | 2022-06-13 00:00:00 | 2022-06-14 00:00:00 | [NAME] | 8
Client | Data Conversion 1 | 2022-06-22 00:00:00 | 2022-06-24 00:00:00 | [NAME] | 16
Client | Initial Data Review | 2022-06-24 00:00:00 | 2022-06-27 00:00:00 | [NAME] | 4
Client | Data Revisions based on client feedback | 2022-06-30 00:00:00 | 2022-07-01 00:00:00 | [NAME] | 4
Client | Data Conversion 2 | 2022-07-14 00:00:00 | 2022-07-15 00:00:00 | [NAME] | 8
Client | Initial Data Review | 2022-07-15 00:00:00 | 2022-07-15 00:00:00 | [NAME] | 4
Client | Data Revisions based on client feedback | 2022-07-19 00:00:00 | 2022-07-20 00:00:00 | [NAME] | 4
Client | Workflow Test & System Setup Finalization
Client | Create script for Workflow Test (UAT) | 2022-07-27 00:00:00 | 2022-07-29 00:00:00 | [NAME] | 8
Client | Updates to WW script based on client feedback | 2022-08-02 00:00:00 | 2022-08-02 00:00:00 | [NAME] | 4
Client | Workflow Test (System Verification) | 2022-08-04 00:00:00 | 2022-08-08 00:00:00 | [NAME] | 12
Client | Revise Configuration as needed | 2022-08-08 00:00:00 | 2022-08-08 00:00:00 | [NAME] | 4
Client | Final Workflow Test | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 | [NAME] | 8
Client | Revise and finalize SOP | 2022-08-12 00:00:00 | 2022-08-15 00:00:00 | [NAME] | 8
Client | Training
Client | Training Materials Preparation | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | [NAME] | 8
Client | Updates to training materials based on client feedback | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | [NAME] | 4
Client | Real Estate End User Training | 2022-08-30 00:00:00 | 2022-09-01 00:00:00 | [NAME] | 16
Client | Go Live | 2022-09-09 00:00:00 | 2022-09-16 00:00:00 | [NAME] | 0
Client | Data Cutover | 2022-09-09 00:00:00 | 2022-09-12 00:00:00 | [NAME] | 8
Client | Go Live Support | 2022-09-12 00:00:00 | 2022-09-14 00:00:00 | [NAME] | 16
Client | Post Go-Live Follow-up | 2022-09-14 00:00:00 | 2022-09-16 00:00:00 | [NAME] | 16