Spreadsheet: 757100d1638018087-dynamic-array-solution-sought-for-totals-dynamic-array-sought
Sheet: RawData

 | Project | Labour Division | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22
 | PROJ01 | Bids | 5 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | Collaboration | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | Eng | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | H&S | 0.4386792452830188 | 0.4245283018867925 | 0.4386792452830188 | 0.4386792452830188 | 0.3962264150943396 | 0.4386792452830188 | 0.4245283018867925
 | PROJ01 | HR | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | IDE | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | Maint Field | 0.7311320754716981 | 0.7075471698113207 | 0.7311320754716981 | 0.7311320754716981 | 0.660377358490566 | 0.7311320754716981 | 0.7075471698113207
 | PROJ01 | Procurement | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | Project Management | 1.462264150943396 | 1.415094339622641 | 1.462264150943396 | 1.462264150943396 | 1.320754716981132 | 1.462264150943396 | 1.415094339622641
 | PROJ01 | Quality | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | Scheme Field | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | Security | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | Service Ops | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | Software | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ01 | Transformation | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PROJ02 | Bids | 10 | 0 | 0 | 0 | 0
 | PROJ02 | Collaboration | 0 | 0 | 0 | 0 | 0
 | PROJ02 | Eng | 2.198581560283688 | 2.127659574468085 | 2.198581560283688 | 2.198581560283688 | 1.276595744680851
 | PROJ02 | H&S | 0 | 0 | 0 | 0 | 0
 | PROJ02 | HR | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851
 | PROJ02 | IDE | 0 | 0 | 0 | 0 | 0
 | PROJ02 | Maint Field | 0 | 0 | 0 | 0 | 0
 | PROJ02 | Procurement | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851
 | PROJ02 | Project Management | 2.638297872340426 | 2.553191489361702 | 2.638297872340426 | 2.638297872340426 | 1.531914893617021
 | PROJ02 | Quality | 0 | 0 | 0 | 0 | 0
 | PROJ02 | Scheme Field | 0 | 0 | 0 | 0 | 0
 | PROJ02 | Security | 0.6595744680851064 | 0.6382978723404256 | 0.6595744680851064 | 0.6595744680851064 | 0.3829787234042553
 | PROJ02 | Service Ops | 4.397163120567376 | 4.25531914893617 | 4.397163120567376 | 4.397163120567376 | 2.553191489361702
 | PROJ02 | Software | 0 | 0 | 0 | 0 | 0
 | PROJ02 | Transformation | 1.099290780141844 | 1.063829787234043 | 1.099290780141844 | 1.099290780141844 | 0.6382978723404255
 |  | SUB-TOTAL
 |  | Labour Division | 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 |  | Labour Division | 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
 |  | Bids |  |  |  |  |  |  |  |  |  | Bids
 |  | Collaboration |  |  |  |  |  |  |  |  |  | Collaboration
 |  | Eng |  |  |  |  |  |  |  |  |  | Eng
 |  | H&S |  |  |  |  |  |  |  |  |  | H&S
 |  | HR |  |  |  |  |  |  |  |  |  | HR
 |  | IDE |  |  |  |  |  |  |  |  |  | IDE
 |  | Maint Field |  |  |  |  |  |  |  |  |  | Maint Field
 |  | Procurement |  |  |  |  |  |  |  |  |  | Procurement
 |  | Project Management |  |  |  |  |  |  |  |  |  | Project Management
 |  | Quality |  |  |  |  |  |  |  |  |  | Quality
 |  | Scheme Field |  |  |  |  |  |  |  |  |  | Scheme Field
 |  | Security |  |  |  |  |  |  |  |  |  | Security
 |  | Service Ops |  |  |  |  |  |  |  |  |  | Service Ops
 |  | Software |  |  |  |  |  |  |  |  |  | Software
 |  | Transformation |  |  |  |  |  |  |  |  |  | Transformation
 |  | TOTAL |  |  |  |  |  |  |  |  |  | TOTAL