Spreadsheet: 100724d1298995213-add-figures-based-on-3-criteria-from-test-data-sheet-bdm-add-test
Sheet: Test Data

Depot |  | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | Total
A | Budget | 5483 | 0.1 | 5046 | 0.11 | 5723 | 0.11 | 5445 | 0.11 | 5505 | 0.11 | 3866 | 0.11 | 4096 | 0.11 | 3997 | 0.11 | 5166 |  | 4896 |  | 5126 |  | 5651 |  | 60000
A | Actual | 2716.76 | 0.1 | 8891.660000000002 | 0.11 | 4140.95 | 0.11 | 4419.419999999999 | 0.11 | 3392.08 | 0.11 | 33079.92 | 0.11 | 2602.85 | 0.11 | 6090.900000000001 | 0.11 |  |  |  |  |  |  |  |  | 65334.54
B | Budget | 7665 | 0.1 | 7053 | 0.11 | 8000 | 0.11 | 7612 | 0.11 | 7696 | 0.11 | 5404 | 0.11 | 5726 | 0.11 | 5587 | 0.11 | 12222 |  | 11844 |  | 12165 |  | 12898 |  | 103872
B | Actual | 2017.810000000001 | 0.1 | 685.41 | 0.11 | 5169.870000000002 | 0.11 | 1414.16 | 0.11 | 3039.25 | 0.11 | 1541 | 0.11 | 1969.17 | 0.11 | 840.5 | 0.11 |  |  |  |  |  |  |  |  | 16677.17
C | Budget | 4817 | 0.1 | 4433 | 0.11 | 5028 | 0.11 | 4784 | 0.11 | 4836 | 0.11 | 3396 | 0.11 | 3598 | 0.11 | 3511 | 0.11 | 4538 |  | 4301 |  | 4503 |  | 4965 |  | 52710
C | Actual | 5197.54 | 0.1 | -439.4099999999999 | 0.11 | 2964.72 | 0.11 | 959 | 0.11 | 315.49 | 0.11 | 59.75999999999999 | 0.11 | 2553.34 | 0.11 | 60 | 0.11 |  |  |  |  |  |  |  |  | 11670.44
D | Budget | 8682 | 0.1 | 7989 | 0.11 | 9062 | 0.11 | 8622 | 0.11 | 8717 | 0.11 | 6121 | 0.11 | 6485 | 0.11 | 6328 | 0.11 | 8180 |  | 7752 |  | 8116 |  | 8946 |  | 95000
D | Actual | 2166.26 | 0.1 | 11780.79 | 0.11 | 3586.11 | 0.11 | 878.87 | 0.11 | 3978.370000000001 | 0.11 | 6613.900000000001 | 0.11 | 11093.8 | 0.11 | 15702.08 | 0.11 |  |  |  |  |  |  |  |  | 55800.18000000001
E | Budget | 5026 | 0.1 | 4625 | 0.11 | 5246 | 0.11 | 4991 | 0.11 | 5046 | 0.11 | 3544 | 0.11 | 3755 | 0.11 | 3664 | 0.11 | 4736 |  | 4488 |  | 4698 |  | 5181 |  | 55000
E | Actual | 3361.27 | 0.1 | 3906.65 | 0.11 | 9851.960000000001 | 0.11 | 5809.659999999999 | 0.11 | 3853.6 | 0.11 | 5195.08 | 0.11 | 1174.2 | 0.11 | 3660.7 | 0.11 |  |  |  |  |  |  |  |  | 36813.12
F | Budget | 4250 | 0.1 | 3910 | 0.11 | 4436 | 0.11 | 4220 | 0.11 | 4267 | 0.11 | 2996 | 0.11 | 3174 | 0.11 | 3098 | 0.11 | 9004 |  | 8794 |  | 8972 |  | 9379 |  | 66500
F | Actual | 317.84 | 0.1 | 807.6 | 0.11 | 9811.150000000001 | 0.11 | 1749.63 | 0.11 | 940.14 | 0.11 | 636.9000000000001 | 0.11 | 1235.6 | 0.11 | 90.74 | 0.11 |  |  |  |  |  |  |  |  | 15589.6
G | Budget | 11424 | 0.1 | 10512 | 0.11 | 11923 | 0.11 | 11344 | 0.11 | 11469 | 0.11 | 8054 | 0.11 | 8533 | 0.11 | 8327 | 0.11 | 15763 |  | 15200 |  | 15678 |  | 16773 |  | 145000
G | Actual | 30599 | 0.1 | 3029.349999999999 | 0.11 | 8604.81 | 0.11 | 7921.859999999999 | 0.11 | 19617.94 | 0.11 | 5831.759999999999 | 0.11 | 7841.549999999998 | 0.11 | 6739.48 | 0.11 |  |  |  |  |  |  |  |  | 90185.75
H | Budget | 4965 | 0.1 | 4539 | 0.11 | 5152 | 0.11 | 4971 | 0.11 | 5132 | 0.11 | 3552 | 0.11 | 3630 | 0.11 | 4112 | 0.11 | 4788 |  | 4443 |  | 4656 |  | 5060 |  | 55000
H | Actual | 9156.35 | 0.1 | 7745.05 | 0.11 | 5775.24 | 0.11 | 9049.67 | 0.11 | 5184.410000000001 | 0.11 | 3220.24 | 0.11 | 5294.040000000001 | 0.11 | 7839.329999999999 | 0.11 |  |  |  |  |  |  |  |  | 53264.33
I | Budget | 2708 | 0.1 | 2476 | 0.11 | 2810 | 0.11 | 2712 | 0.11 | 2800 | 0.11 | 1938 | 0.11 | 1980 | 0.11 | 2243 | 0.11 | 2611 |  | 2424 |  | 2540 |  | 2758 |  | 30000
I | Actual | 1184.94 | 0.1 | 1515.76 | 0.11 | 2731.04 | 0.11 | 4484.12 | 0.11 | 1509.42 | 0.11 | 2197.85 | 0.11 | 616.72 | 0.11 | 2236.92 | 0.11 |  |  |  |  |  |  |  |  | 16476.77