Spreadsheet: 157699d1337849380-calculation-from-a-data-set-staff-hours-to-value
Sheet: By staff

Staff number | Hours | Total cost
7406 | 37.5 | 32491.2408433735
7408 -1 | 19 | 51851.0757593985
7408-2 | 7 | 25242.8955295775
7408-3 | 1 | 0
7413 | 14 | 47495.152
7416-1 | 3 | 8536.56
7416-2 | 1 | 0
7419 | 1 | 1545.84
7422 | 23 | 12430.94413092551
7425 | 35 | 93288.76
7426 | 1 | 0
7427 | 32 | 21116.55125
7432 | 14 | 14046.78
7439 | 1 | 0
7443-1 | 10.5 | 22587.48782798733
7443-2 | 4.5 | 13097.35115332937
7447 | 3.5 | 6766.4
7448 - a | 26.19 | 33979.86011027328
7448 - b | 1 | 0
7459-1 | 10.5 | 19453.161
7459-2 | 1 | 0
7464-1 | 28 | 61029.20800000001
7464-3 | 1 | 0
7472 | 1 | 4866.48
7487-1 | 14 | 28095.07
7487-2 | 7 | 15729.73527058516
7488 | 35 | 55568.28
7502-1 | 10.5 | 19936.62
7502-2 | 1 | 0
7505 | 21 | 23789.92889993396
7510 | 32 | 37324.0975
7512-1 | 17.5 | 74968.04000000001
7512-2 | 1 | 0
7525 | 23 | 12424.19515850144
7526-1 | 17.5 | 49775.51
7526-2 | 1 | 0
7528 | 35 | 52076.32
7539 | 17.96 | 31835.16897550111
7546 | 7 | 14411.60347300429
7548 | 21 | 22920.2
7554 | 21 | 24136.2
7570 | 35 | 72558.65861082307
7574 - H | 9 | 18300.87700276562
7574 - L | 1.346153846153846 | 3947.371109630029
7574 - £ | 1 | 0
7574-1 | 1 | 0
7574-2 | 1 | 0
7575 | 21 | 24259.7365485472
7593 | 35 | 0
7604 | 35 | 29908.51
7607 | 0.5 | 702.88
7610 | 10.5 | 23937.76
7617 | 1.5 | 2187.3
7627 | 37.5 | 17685.498
7630 | 7 | 11985.8
7634 | 6.5 | 9224.862952043202
7635 | 1 | 0
7636 | 8.5 | 12076.85
7637-1 | 7.154 | 8384.082631906866
7637-2 | 1 | 0
7638 | 9.731 | 13438.56
7640 | 28 | 23001.49
7641 | 7 | 22796.75945586139
7648 | 15 | 20478.79
7654 - Permanent | 1 | 0
7654 - Temporary | 1 | 0
7666-2 | 8.515384615384615 | 25625.17429049184
7666-3 | 14 | 38114.27613149336
7666-4 | 1.5 | 2108.643428571429
7670-1 | 3.5 | 8586.12
7674 | 3.75 | 3230.96
7683 | 29 | 31471.81
7686 | 18.5 | 29939.35243243244
7690 | 35 | 33874.8
7697 | 28 | 18515.16
7710 | 5 | 6745.591898734177
7717 | 1.807692307692308 | 2541.19
7719 | 35 | 29692.68
7724 | 35 | 38165.24
7725 | 10.788 | 21990.95906698728
7728 | 14 | 24342.82
7732 | 35 | 46886.68
7733 | 14 | 9671.84
7735 | 3.5 | 6691.23
7736 | 35 | 36703.68
7738 | 35 | 36847.44
7739 | 35 | 25140.68
7743 | 35 | 25322.68
7744 | 35 | 25322.68
7753 | 7 | 7671.2
7755 | 5 | 1227
7757 | 5 | 1227
7760 | 1.346153846153846 | 1952.17
7761 | 2.884615384615385 | 3619.65
7762 | 35 | 24002.68
7763 | 35 | 26895.72
7766 | 1.5 | 2099.86
7767 | 35 | 34813.68
7768 | 14 | 0
7769 | 35 | 25729.58
7771 - 1 | 1.5 | 3804.62
7771 - 2 | 7 | 14670.2
7772 | 1.5 | 0
7774 | 35 | 25140.68
7776 | 15.75 | 37374.12
7777 | 35 | 40609.12
7780 | 1 | 0
7782 | 35 | 23402.34
7783 | 35 | 22864.68
7784 | 35 | 43917.68
7787 | 16 | 7040.189329706234
7788 | 35 | 43183.64
7789 | 24 | 51258.90105372208
7791 | 24 | 35154.27428571429
7793 | 28 | 21726.68
7796 | 24 | 32078.22961980776
7798 | 35 | 29220.32
7799 | 8 | 21180.95120540019
7800 | 3.5 | 2000
7801 | 24 | 33115.98857142857
7802 | 12.5 | 28709.47142857143
7805 | 35 | 25729.58
7806 | 35 | 20588.68
7807 | 35 | 20588.68
7808 | 35 | 20588.68
7809 | 35 | 20588.68
7810 | 35 | 26278.68
7811 | 35 | 25729.58
7812 | 17.5 | 22868.68
7813 | 22 | 30552.58
7814 | 5 | 1200
7816 | 5 | 5428.58
7817 | 35 | 76836.56
7818 | 10.5 | 12492.96
7819 | 35 | 22240.78
7820 | 35 | 22864.68
7821 | 35 | 33708.68
7822 | 1.528846153846154 | 2146.04
7823 | 3.076923076923077 | 4319.07
7824 | 3.076923076923077 | 4319.07
7825 | 21 | 16036.68
7827 | 35 | 42601.83
7828 | 21 | 12903.7392
7829 | 35 | 24723.68
7830 | 35 | 22238.72
7832 | 30 | 26922.39
7833 | 35 | 31968.68
7834 | 14 | 17241.52
7835 | 21 | 33271.2
7836 | 35 | 32040.42
7838 | 35 | 25729.58
7839 | 35 | 19911.48
7840 | 1 | 0
7841 | 35 | 19911.48
7842 | 14 | 5400
7843 | 3.09 | 4361.85
7844 | 6.14 | 8894.220000000001
7845 | 14 | 17893
7846 | 35 | 23465.72
7847 | 1.81 | 2199.718857142857
7848 | 7 | 7362
7849 | 4 | 2884
7850 | 14 | 15809.08
7851 | 3.09 | 4361.85
7852 | 21 | 18767.88
7853 | 1.346 | 2436.3
7854 | 28 | 44907.11
7855 | 35 | 21726.68
7856 | 1 | 0
7857 | 20 | 13923.21714285714
7858 | 35 | 5564
7859 | 14 | 44689.56
7860 | 1 | 0
7861 | 21 | 13305.48
7862 | 1 | 0
7863 | 5.5 | 5675.685714285713
7864 | 1 | 0
7865 | 1 | 0
7866 | 14 | 15383.19595742271
 |  | 3424497.00280874