Spreadsheet: 757123d1638029907-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 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Bids
 |  | Collaboration | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Collaboration | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Eng | 2.198581560283688 | 2.127659574468085 | 2.198581560283688 | 2.198581560283688 | 1.276595744680851 | 0 | 0 | 0 |  | Eng | 2.198581560283688 | 2.127659574468085 | 2.198581560283688 | 2.198581560283688 | 1.276595744680851 | 0 | 0 | 0
 |  | H&S | 0.4386792452830188 | 0.4245283018867925 | 0.4386792452830188 | 0.4386792452830188 | 0.3962264150943396 | 0.4386792452830188 | 0.4245283018867925 | 0 |  | H&S | 0.4386792452830188 | 0.4245283018867925 | 0.4386792452830188 | 0.4386792452830188 | 0.3962264150943396 | 0.4386792452830188 | 0.4245283018867925 | 0
 |  | HR | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851 | 0 | 0 | 0 |  | HR | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851 | 0 | 0 | 0
 |  | IDE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | IDE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Maint Field | 0.7311320754716981 | 0.7075471698113207 | 0.7311320754716981 | 0.7311320754716981 | 0.660377358490566 | 0.7311320754716981 | 0.7075471698113207 | 0 |  | Maint Field | 0.7311320754716981 | 0.7075471698113207 | 0.7311320754716981 | 0.7311320754716981 | 0.660377358490566 | 0.7311320754716981 | 0.7075471698113207 | 0
 |  | Procurement | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851 | 0 | 0 | 0 |  | Procurement | 0.2198581560283688 | 0.2127659574468085 | 0.2198581560283688 | 0.2198581560283688 | 0.1276595744680851 | 0 | 0 | 0
 |  | Project Management | 4.100562023283822 | 3.968285828984344 | 4.100562023283822 | 4.100562023283822 | 2.852669610598153 | 1.462264150943396 | 1.415094339622641 | 0 |  | Project Management | 4.100562023283822 | 3.968285828984344 | 4.100562023283822 | 4.100562023283822 | 2.852669610598153 | 1.462264150943396 | 1.415094339622641 | 0
 |  | Quality | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Quality | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Scheme Field | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Scheme Field | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Security | 0.6595744680851064 | 0.6382978723404256 | 0.6595744680851064 | 0.6595744680851064 | 0.3829787234042553 | 0 | 0 | 0 |  | Security | 0.6595744680851064 | 0.6382978723404256 | 0.6595744680851064 | 0.6595744680851064 | 0.3829787234042553 | 0 | 0 | 0
 |  | Service Ops | 4.397163120567376 | 4.25531914893617 | 4.397163120567376 | 4.397163120567376 | 2.553191489361702 | 0 | 0 | 0 |  | Service Ops | 4.397163120567376 | 4.25531914893617 | 4.397163120567376 | 4.397163120567376 | 2.553191489361702 | 0 | 0 | 0
 |  | Software | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Software | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Transformation | 1.099290780141844 | 1.063829787234043 | 1.099290780141844 | 1.099290780141844 | 0.6382978723404255 | 0 | 0 | 0 |  | Transformation | 1.099290780141844 | 1.063829787234043 | 1.099290780141844 | 1.099290780141844 | 0.6382978723404255 | 0 | 0 | 0
 |  | TOTAL |  | 13.6109995985548 | 14.06469958517329 | 14.06469958517329 | 9.015656362906462 | 2.632075471698113 | 2.547169811320755 | 0 |  | TOTAL