Spreadsheet: 702347d1604311107-formula-that-refernces-resource-to-give-a-monthly-total-resourcing1-v3
Sheet: Sheet 2

 | Resource Name | Project Name | Role | Project Status | Start Date | End Date | Planned Hours Per Day | 1-Mar-19 | 1-Apr-19 | 1-May-19 | 1-Jun-19 | 1-Jul-19 | 1-Aug-19 | 1-Sep-19 | 1-Oct-19 | 1-Nov-19 | 1-Dec-19 | 1-Jan-20 | 1-Feb-20 | 1-Mar-20 | 1-Apr-20 | 1-May-20 | 1-Jun-20 | 1-Jul-20 | 1-Aug-20 | 1-Sep-20 | 1-Oct-20 | 1-Nov-20 | 1-Dec-20 | 1-Jan-21 | 1-Feb-21 | 1-Mar-21 | 1-Apr-21 | 1-May-21 | 1-Jun-21 | 1-Jul-21 | 1-Aug-21 | 1-Sep-21 | 1-Oct-21 | 1-Nov-21 | 1-Dec-21 | 1/01/2022
 | [NAME] |  |  |  | 2019-05-31 00:00:00 | 2021-06-30 00:00:00
 | [NAME] |  |  |  | 2019-05-31 00:00:00 | 2020-12-12 00:00:00
 | [NAME] |  |  |  | 2019-05-31 00:00:00 | 2021-06-30 00:00:00
 | [NAME] |  |  |  | 2019-05-31 00:00:00 | 2021-06-30 00:00:00
 | Nicci Mclean |  |  |  | 2019-05-31 00:00:00 | 2021-06-30 00:00:00
 | [NAME] |  |  |  | 2020-04-27 00:00:00 | 2021-03-09 00:00:00 | 0.88
 | [NAME] |  |  |  | 2020-04-27 00:00:00 | 2021-03-09 00:00:00 | 0.13
 | [NAME] |  |  |  | 2020-04-27 00:00:00 | 2021-03-09 00:00:00 | 1.1
 | [NAME] |  |  |  | 2020-07-02 00:00:00 | 2020-07-06 00:00:00 | 2.5
 | [NAME] |  |  |  | 2020-07-02 00:00:00 | 2020-07-06 00:00:00 | 2.5
 | [NAME] |  |  |  | 2020-04-27 00:00:00 | 2021-03-09 00:00:00 | 0.75
 | Information Services officer |  |  |  | 2020-11-30 00:00:00 | 2021-02-19 00:00:00 | 1.5
 | [NAME] |  |  |  | 2021-03-08 00:00:00 | 2021-03-09 00:00:00 | 7
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2021-03-16 00:00:00 | 0.29
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2021-03-16 00:00:00 | 0.59
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2021-03-16 00:00:00 | 2.5
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2020-05-08 00:00:00 | 2.5
 | [NAME] |  |  |  | 2020-05-26 00:00:00 | 2020-06-01 00:00:00 | 0.59
 | [NAME] |  |  |  | 2021-03-29 00:00:00 | 2021-05-21 00:00:00 | 0.13
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2021-03-16 00:00:00
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2021-01-08 00:00:00 | 3.5
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2020-11-23 00:00:00
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2020-11-23 00:00:00 | 3.92
 | [NAME] |  |  |  | 2020-11-09 00:00:00 | 2020-12-02 00:00:00 | 1.63
 | [NAME] |  |  |  | 2020-11-09 00:00:00 | 2020-12-16 00:00:00 | 5.15
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2020-06-10 00:00:00 | 0.8
 | [NAME] |  |  |  | 2021-01-11 00:00:00 | 2021-02-05 00:00:00 | 4
 | [NAME] |  |  |  | 2020-04-20 00:00:00 | 2021-02-05 00:00:00 | 4
 | [NAME] |  |  |  | 2021-03-29 00:00:00 | 2021-05-21 00:00:00 | 3.5
 | [NAME] |  |  |  | 2021-03-29 00:00:00 | 2021-12-03 00:00:00
 | [NAME] |  |  |  | 2021-03-29 00:00:00 | 2021-06-18 00:00:00 | 1.75
 | [NAME] |  |  |  | 2021-03-29 00:00:00 | 2021-05-21 00:00:00 | 1.63
 | [NAME] |  |  |  | 2021-03-30 00:00:00 | 2021-05-03 00:00:00 | 1.63
 | [NAME] |  |  |  | 2021-03-29 00:00:00 | 2021-12-03 00:00:00 | 1.33
 | [NAME] |  |  |  | 2021-06-21 00:00:00 | 2021-07-02 00:00:00 | 8
 | [NAME] |  |  |  | 2021-03-29 00:00:00 | 2021-12-03 00:00:00 | 8
 | Business SME |  |  |  | 2021-06-21 00:00:00 | 2021-12-03 00:00:00 | 1.63
 | [NAME] |  |  |  | 2021-02-15 00:00:00 | 2021-03-26 00:00:00
 | [NAME] |  |  |  | 2021-02-15 00:00:00 | 2021-03-26 00:00:00
 | [NAME] |  |  |  | 2021-02-15 00:00:00 | 2021-03-26 00:00:00 | 1.63
 | [NAME] |  |  |  | 2021-02-15 00:00:00 | 2021-03-26 00:00:00 | 1.8
 | [NAME] |  |  |  | 2021-03-01 00:00:00 | 2021-03-26 00:00:00 | 2.35
 | [NAME] |  |  |  | 2021-03-22 00:00:00 | 2021-03-26 00:00:00 | 1.63
 | Trainers |  |  |  | 2021-03-08 00:00:00 | 2021-03-17 00:00:00 | 3.5
 | [NAME] |  |  |  | 2021-03-29 00:00:00 | 2021-07-16 00:00:00 | 8
 | [NAME] |  |  |  | 2021-02-15 00:00:00 | 2021-03-26 00:00:00
 | [NAME] |  |  |  | 2021-02-15 00:00:00 | 2021-03-19 00:00:00 | 2.17
 | [NAME] |  |  |  | 2021-02-15 00:00:00 | 2021-02-19 00:00:00 | 7.14
 | [NAME] |  |  |  | 2021-03-08 00:00:00 | 2021-03-19 00:00:00 | 4
 | [NAME] |  |  |  | 2021-03-08 00:00:00 | 2021-03-19 00:00:00 | 4
 | Information Services officer |  |  |  | 2021-03-22 00:00:00 | 2021-03-26 00:00:00 | 5.6
 | [NAME] |  |  |  | 2021-02-15 00:00:00 | 2021-03-26 00:00:00 | 5.6
 | [NAME] |  |  |  | 2021-02-22 00:00:00 | 2021-07-16 00:00:00 | 2
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 1.75
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 0.13
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 1
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 0.25
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 0.4
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 0.25
 | Meagan Geary |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 0.75
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 0.25
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 0.75
 | Vernia Blundell |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 0.25
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 0.25
 | [NAME] |  |  |  | 2020-01-18 00:00:00 | 2021-01-29 00:00:00 | 1
 | [NAME] |  |  |  | 2020-08-31 00:00:00 | 2020-10-31 00:00:00
 | [NAME] |  |  |  | 2020-08-31 00:00:00 | 2020-10-31 00:00:00
 | [NAME] |  |  |  | 2020-08-31 00:00:00 | 2020-10-31 00:00:00
 | [NAME] |  |  |  | 2020-05-18 00:00:00 | 2021-04-12 00:00:00 | 5.5
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Albion Park Staff
 | Albion Park Staff
 | Albion Park Staff
 | Albion Park Staff
 | Albion Park Staff
 | Albion Park Staff
 | Albion Park Staff
 | Albion Park Staff
 | [NAME]
 | [NAME] | G217 - COVID -Safe Plan | PM | On Hold | 2020-06-10 00:00:00 |  | 2
 | [NAME] |  | [NAME]
 | [NAME] |  | Business Owner
 | Person 3
 | Person 4
 | Person 5
 | [NAME] | I218 - DocuSign | PM | Active | 2020-03-01 00:00:00 | 2020-12-31 00:00:00
 | [NAME] |  | [NAME] | Active | 2020-03-01 00:00:00 | 2020-12-31 00:00:00
 | [NAME] |  | Business Owner | Active
 | Person 9
 | Person 10
 | [NAME] | G219 - Project Connect-19 | PM | Active | 2020-05-30 00:00:00 | 2021-02-28 00:00:00
 | [NAME] |  | SME | Active | 2020-05-30 00:00:00 | 2021-02-28 00:00:00
 | [NAME] |  | SME | Active | 2020-05-30 00:00:00 | 2021-02-28 00:00:00
 | Person 10
 | Person 11
 | Person 12
 | [NAME] | I22.1 - Paperless Options - Docstar App | PM | Active |  | 2020-12-30 00:00:00
 | [NAME] |  | [NAME] | Active
 | [NAME] |  | Business Owner | Active
 | Person 16
 | [NAME] | I223.1 - Checked in Care Pilot (Village Portal Solution) | PM | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 2
 | [NAME] | I223.1 - Checked in Care Pilot (Village Portal Solution) | SME | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 2
 | [NAME] | I223.1 - Checked in Care Pilot (Village Portal Solution) | SME | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 2
 | [NAME] | I223.1 - Checked in Care Pilot (Village Portal Solution) | SME | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 3.17
 | [NAME] | I223.1 - Checked in Care Pilot (Village Portal Solution) | SME | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 3.17
 | [NAME] | I223.1 - Checked in Care Pilot (Village Portal Solution) | SME | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 3.17
 | [NAME] | I223.1 - Checked in Care Pilot (Village Portal Solution) | SME | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 3.17
 | Belinda McClelland | I223.1 - Checked in Care Pilot (Village Portal Solution) | SME | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 3.17
 | [NAME] | I223.1 - Checked in Care Pilot (Village Portal Solution) | SME | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 3.17
 | Lachlan McDonald | I223.1 - Checked in Care Pilot (Village Portal Solution) | SME | Active | 2020-09-01 00:00:00 | 2021-05-30 00:00:00 | 2
 | [NAME] | I224  - IT Design Standard | PM | Active | 2020-07-01 00:00:00 | 2021-07-31 00:00:00
 | Person 7
 | Person 8
 | Person 25
 | Person 1
 | [NAME] | I225 - Disaster Recovery Strategy | PM | Active | 2020-09-25 00:00:00 | 2020-10-26 00:00:00
 | Person 3
 | Person 4
 | Person 5
 | [NAME] | B226 - Bundanoon Surplus Land Sale | PM | Active | 2020-08-01 00:00:00 | 2021-12-15 00:00:00 | 2
 | [NAME] |  | [NAME] | Active | 2020-08-01 00:00:00 | 2021-12-15 00:00:00 | 0.13
 | Person 8
 | Person 9
 | Person 10
 | Person 11
 | Person 12
 | Person 13
 | Person 14
 | Person 15
 | Person 16
 | Person 17
 | Person 18
 | Person 19
 | Person 20
 | Person 21
 | Person 22
 | Person 23
 | Person 3
 | Person 4
 | Person 5
 | Person 6
 | Person 7
 | Person 8
 | Person 25
 | Person 1
 | Person 2
 | Person 3
 | Person 4
 | Person 5
 | Person 6
 | Person 7
 | Person 8
 | Person 9
 | Person 10
 | Person 11
 | Person 12
 | Person 13
 | Person 14
 | Person 15
 | Person 16
 | Person 17
 | Person 18
 | Person 19
 | Person 20
 | Person 21
 | Person 22
 | Person 23
 | Person 3
 | Person 4
 | Person 5
 | Person 6
 | Person 7
 | Person 8
 | Person 25
 | Person 1
 | Person 2
 | Person 3
 | Person 4
 | Person 5
 | Person 6
 | Person 7
 | Person 8
 | Person 9
 | Person 10
 | Person 11
 | Person 12
 | Person 13
 | Person 14
 | Person 15
 | Person 16
 | Person 17
 | Person 18
 | Person 19
 | Person 20
 | Person 21
 | Person 22
 | Person 23
 | Person 3
 | Person 4
 | Person 5
 | Person 6
 | Person 7
 | Person 8
 | Person 25