Spreadsheet: 100873d1299094559-add-figures-based-on-3-criteria-from-test-data-sheet-bdm-test2
Sheet: Test

 |  | July | GP % | August | GP % | September | GP % | October | GP % | November | GP % | December | GP % | January | GP % | February | GP % | March | GP % | April | GP % | May | GP % | June | GP % | Total | GP%
 |  |  | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | Total
A | Budget | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  |  | 0.15
A | Actual | 0 | 0 | 199.2 | 0.1977911646586344 | 597.5999999999999 | 0.1977911646586344 | 991.4 | 0.1940689933427475 | 1890.6 | 0.1970273987094044 | 194.6 | 0.1788283658787255 | 199.2 | 0.1977911646586344 | 1198 | 0.1996661101836394
B | Budget | 200 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  |  | 0.28
B | Actual | 0 | 0 |  |  |  |  | 576.91 | 0.3748938309268343 | 705.3900000000001 | 0.2561278158181998 |  |  | 52.3 | 0.2829827915869981 | 654.99 | 0.410433747080108
C | Budget | 300 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  |  | 0.22
C | Actual | 2 | 0 | 137.21 | 0.3630347642300124 |  |  | 81.75 | 0 | 373.41 | 0 |  |  | 58.15000000000001 | 0.3331040412725709 | 80.97 | 0.6213412374953687
D | Budget | 400 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  |  | 0.25
D | Actual | 0 | 0 |  |  |  |  | 388.16 | 0.3328524319868096 | 810 | 0.1565 | 1626 | 0.1899 | 2006.34 | 0.2151 | 1808.28 | 0.223378016678833
Sub total | Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2379
 | Actual
E | Budget | 500 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  |  | 0
E | Actual | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 520.8199999999999 | 0.3373238354901886
F | Budget | 600 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  |  | 0.24
F | Actual | 1722.63 | 0.2665392452238727 | 1697.89 | 0.2542802537266842 | 1390.54 | 0.3444346800523537 | 3245.76 | 0.3033643892339544 | 1459.54 | 0.3264373021636954 | 3081.97 | 0.3363748187036213 | 2969.94 | 0.1863369630362904 | 2638.509999999999 | 0.3414065135246788
G | Budget | 700 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  |  | 0.25
G | Actual | 0 | 0 | 48 | 0.278125 |  |  |  |  | 47.2 | 0.2949152542372881 |  |  | 46.25 | 0.1098378378378378
H | Budget | 800 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  |  | 0.25
H | Actual | 15954.44 | 0.1169917590338489 | 5668.21 | 0.2664561475315841 | 13923.24 | 0.1233434171931246 | 4049.11 | 0.2565728518118797 | 3608.16 | 0.1678856536295508 | 1871.26 | 0.236083387663927 | 3459.06 | 0.2628758391007961 | 3570.5 | 0.104574009242403
I | Budget | 900 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  |  | 0
I | Actual | 989.6700000000001 | 0.1450584538280437 |  |  | 2964.95 | 0.08320882308301993 | -17.79000000000002 | -1.31759415401911 | 1056 | 0.1177367424242424 | 2614.05 | 0.09774105315506595 | 856.9 | 0.2910899754930564 | 851.6200000000001 | 0.2069467602921491
Sub total | Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2476
 | Actual
Total | Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2428
Total | Actual