Spreadsheet: 731381d1620313753-help-with-building-a-revenue-cost-spreadheet-fdg-test-file-jlambas-
Sheet: Main Sheet

 |  |  |  |  |  |  | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 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 |  | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 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
Role | [NAME] | End Date | Daily Rate | Contractor first Payment Date | Contractor first Payment Fortnight |  | When Candidates are Working
Apps/Integration Tester (Scripting skills) | 2021-09-01 00:00:00 | 2022-09-30 00:00:00 | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
Apps/Integration Tester (Scripting skills) | 2021-09-01 00:00:00 | 2022-09-30 00:00:00 | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
AWS Integration Dev | 2021-07-01 00:00:00 | 2022-03-31 00:00:00 | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
AWS Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
AWS Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
AWS Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Business Analyst |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Business Analyst |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Business Analyst |  |  | 100 |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
Business Analyst |  |  | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Change Manager |  |  | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DevOps Engineer |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Licensing Analysis |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1
Scrum Lead |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Security Engineer |  |  | 100 |  |  |  | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4
Solution Architect |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
[NAME] (Win/Lin) |  |  | 100 |  |  |  |  |  | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.5 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6
Test Analyst (Scritpting skills) |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Test Analyst (Scritpting skills) |  |  | 100 |  |  |  |  | 0.6 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Test Analyst (Scritpting skills) |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Transition Support (Change Mngt) |  |  | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
Transition Support (Change Mngt) |  |  | 100 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
Transition Support (Change Mngt) |  |  | 100 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1