Spreadsheet: 806481d1669331869-calculate-the-cost-over-a-period-but-with-multiple-variables-sample
Sheet: Data Sheet

 | Resource Allocation |  |  |  |  |  |  |  |  |  |  |  | Resources and Annual Salary |  |  |  |  |  |  |  |  | 1.025
 | ID | Resource Name | Project Name | Activity | Start Date | End Date | Hours per Day | Hours | Weekdays | Hours in total | Cost per activity |  | Resources | FY2022-23 | 2022-23 Salary | FY2023-24 | 2023-24 Salary | FY2024-25 | 2024-25 Salary | FY2025-26 | 2025-26 Salary
 | 1 | [NAME] | Pulse PM | IT Business Analyst | 2022-05-30 00:00:00 | 2026-10-14 00:00:00 | 8 |  |  |  |  |  | [NAME] |  | 123682
 | 2 | [NAME] | Pulse PM | IT Business Analyst | 2022-10-17 00:00:00 | 2022-12-30 00:00:00 | 1 |  |  |  |  |  | Rostering Vendor |  | 139410
 | 3 | [NAME] | Rostering | Business Analyst | 2022-10-17 00:00:00 | 2022-12-30 00:00:00 | 2 |  |  |  |  |  | Core Vendor 1 |  | 139410
 | 4 | [NAME] | Core Systems | Business Analyst | 2022-10-17 00:00:00 | 2022-12-30 00:00:00 | 5 |  |  |  |  |  | Core Vendor 2 |  | 139410
 | 5 | [NAME] | Pulse PM | IT Business Analyst | 2023-02-01 00:00:00 | 2023-06-30 00:00:00 | 2.5 |  |  |  |  |  | Rostering PM |  | 143843
 | 6 | [NAME] | Rostering | Business Analyst | 2023-01-01 00:00:00 | 2024-01-19 00:00:00 | 1 |  |  |  |  |  | Rostering CM |  | 123682
 | 7 | [NAME] | Core Systems | Business Analyst | 2023-01-01 00:00:00 | 2023-06-30 00:00:00 | 4 |  |  |  |  |  | Rostering BA |  | 123682
 | 8 | Rostering Vendor | Rostering | Vendor | 2022-12-05 00:00:00 | 2023-04-28 00:00:00 | 8 |  |  |  |  |  | Person 8
 | 9 | Rostering PM | Rostering | Project Manager | 2023-04-28 00:00:00 | 2024-01-19 00:00:00 | 8 |  |  |  |  |  | Person 9
 | 10 | Rostering CM | Rostering | Change Manager | 2023-04-28 00:00:00 | 2024-01-19 00:00:00 | 8 |  |  |  |  |  | Person 10
 | 11 | Rostering BA | Rostering | Business Analyst | 2023-04-28 00:00:00 | 2024-01-19 00:00:00 | 8 |  |  |  |  |  | Person 11
 | 12 | Rostering Vendor | Rostering | Vendor | 2023-04-28 00:00:00 | 2024-01-19 00:00:00 | 0.5 |  |  |  |  |  | Person 12
 | 13 | Core Vendor 1 | Core Systems | Vendor Interviews | 2022-12-19 00:00:00 | 2023-02-23 00:00:00 | 8 |  |  |  |  |  | Person 13
 | 14 | Core Vendor 2 | Core Systems | Vendor IT Review | 2022-12-19 00:00:00 | 2023-02-23 00:00:00 | 8 |  |  |  |  |  | Person 14
 | 15 | [NAME] | Test | Test | 2025-01-01 00:00:00 | 2025-12-12 00:00:00 | 1 |  |  |  |  |  | Person 15
 | 16 |  |  |  |  |  |  |  |  |  |  |  | Person 16
 | 17 |  |  |  |  |  |  |  |  |  |  |  | Person 17
 | 18 |  |  |  |  |  |  |  |  |  |  |  | Person 18
 | 19 |  |  |  |  |  |  |  |  |  |  |  | Person 19
 | 20 |  |  |  |  |  |  |  |  |  |  |  | Person 20
 | 21 |  |  |  |  |  |  |  |  |  |  |  | Person 21
 | 22 |  |  |  |  |  |  |  |  |  |  |  | Person 22
 | 23 |  |  |  |  |  |  |  |  |  |  |  | Person 23
 | 24 |  |  |  |  |  |  |  |  |  |  |  | Person 24
 | 25 |  |  |  |  |  |  |  |  |  |  |  | Person 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31 |  |  |  |  |  |  |  |  |  |  |  |  | Annual cost converter
 | 32 |  |  |  |  |  |  |  |  |  |  |  |  | Start Date | End Date | Cost | Annual Cost
 | 33 |  |  |  |  |  |  |  |  |  |  |  | Enter data here >> | 2022-12-05 00:00:00 | 2023-04-28 00:00:00 | 55000 |  | << Copy this amount into the relevent salary field above
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48 |  |  |  |  |  |  |  |  |  |  |  | Holiday | 2022 | 2023 | 2024 | 2025
 | 49 |  |  |  |  |  |  |  |  |  |  |  | New Year's Day |  | 2023-01-02 00:00:00 | 2024-01-01 00:00:00 | 2025-01-01 00:00:00
 | 50 |  |  |  |  |  |  |  |  |  |  |  | Australia Day |  | 2023-01-26 00:00:00 | 2024-01-26 00:00:00 | 2025-01-26 00:00:00
 | 51 |  |  |  |  |  |  |  |  |  |  |  | Labour Day |  | 2023-03-13 00:00:00 | 2024-03-11 00:00:00 | 2025-03-10 00:00:00
 | 52 |  |  |  |  |  |  |  |  |  |  |  | Good Friday |  | 2023-04-07 00:00:00 | 2024-03-29 00:00:00 | 2025-04-18 00:00:00
 | 53 |  |  |  |  |  |  |  |  |  |  |  | Easter Monday |  | 2023-04-10 00:00:00 | 2024-04-01 00:00:00 | 2025-04-21 00:00:00
 | 54 |  |  |  |  |  |  |  |  |  |  |  | ANZAC Day |  | 2023-04-25 00:00:00 | 2024-04-25 00:00:00 | 2025-04-25 00:00:00
 | 55 |  |  |  |  |  |  |  |  |  |  |  | King's Birthday |  | 2023-06-12 00:00:00 | 2024-06-10 00:00:00 | 2025-06-09 00:00:00
 | 56 |  |  |  |  |  |  |  |  |  |  |  | Friday before the AFL Grand Final
 | 57 |  |  |  |  |  |  |  |  |  |  |  | Melbourne Cup |  | 2023-11-07 00:00:00 | 2024-11-05 00:00:00 | 2025-11-04 00:00:00
 | 58 |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2022-12-27 00:00:00 | 2023-12-25 00:00:00 | 2024-12-25 00:00:00 | 2025-12-25 00:00:00
 | 59 |  |  |  |  |  |  |  |  |  |  |  | Boxing Day | 2022-12-26 00:00:00 | 2023-12-26 00:00:00 | 2024-12-26 00:00:00 | 2025-12-26 00:00:00
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151