Spreadsheet: 156550d1337344204-automatic-sort-using-a-formula-ef97_automatic-sort
Sheet: Summary

 |  |  | April
 |  |  |  | Actual | Budget |  | Actual | Budget |  | Actual | Budget |  | Actual | Budget |  | Actual | Budget |  | Revenue Affect on...
 |  | [NAME] | Customer Name | Units | Units | B/(W) Budget | M2 | M2 | B/(W) Budget | Revenue £'000 | Revenue £'000 | B/(W) Budget | Avg Unit Size | Avg Unit Size | B/(W) Budget | Avg Selling Price | Avg Selling Price | B/(W) Budget | M2 | Selling Price | Unit [NAME]
 |  | 1001 | Customer 1 | 50 | 60 | -10 | 40 | 48 | -8 | 2000 | 2400 | -400 | 0.8 | 0.8 | 0 | 50000 | 50000 | 0 | -400000 | 0 | 0 |  | Customer 6 | 100 |  |  |  | Top 5
 |  | 1002 | Customer 2 | 60 | 72 | -12 | 48 | 57.59999999999999 | -9.599999999999994 | 2400 | 2880 | -480 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000.00000000001 | 0 | -479999.9999999995 | 0 | 3.33066907387547e-10 |  | Customer 11 | 100 |  |  |  | Customer 6 | 100
 |  | 1003 | Customer 3 | 70 | 84 | -14 | 56 | 67.2 | -11.2 | 2800 | 3360 | -560 | 0.8 | 0.8 | 0 | 50000 | 50000 | 0 | -560000 | 0 | 0 |  | Customer 5 | 90 |  |  |  | Customer 11 | 100
 |  | 1004 | Customer 4 | 80 | 96 | -16 | 64 | 76.8 | -12.8 | 3200 | 3840 | -640 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000 | 0 | -640000 | 0 | 4.440892098500626e-10 |  | Customer 4 | 80 |  |  |  | Customer 5 | 90
 |  | 1005 | Customer 5 | 90 | 108 | -18 | 72 | 86.39999999999999 | -14.39999999999999 | 3600 | 4320 | -720 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000.00000000001 | 0 | -719999.9999999995 | 0 | 4.996003610813205e-10 |  | Customer 10 | 80 |  |  |  | Customer 4 | 80
 |  | 1006 | Customer 6 | 100 | 120 | -20 | 80 | 96 | -16 | 4000 | 4800 | -800 | 0.8 | 0.8 | 0 | 50000 | 50000 | 0 | -800000 | 0 | 0 |  | Customer 3 | 70 |  |  |  | Customer 10 | 80
 |  | 1007 | Customer 7 | 50 | 60 | -10 | 40 | 48 | -8 | 2000 | 2400 | -400 | 0.8 | 0.8 | 0 | 50000 | 50000 | 0 | -400000 | 0 | 0 |  | Customer 9 | 70
 |  | 1008 | Customer 8 | 60 | 72 | -12 | 48 | 57.59999999999999 | -9.599999999999994 | 2400 | 2880 | -480 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000.00000000001 | 0 | -479999.9999999995 | 0 | 3.33066907387547e-10 |  | Customer 17 | 70
 |  | 1009 | Customer 9 | 70 | 84 | -14 | 56 | 67.2 | -11.2 | 2800 | 3360 | -560 | 0.8 | 0.8 | 0 | 50000 | 50000 | 0 | -560000 | 0 | 0 |  | Customer 19 | 65
 |  | 1010 | Customer 10 | 80 | 96 | -16 | 64 | 76.8 | -12.8 | 3200 | 3840 | -640 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000 | 0 | -640000 | 0 | 4.440892098500626e-10 |  | Customer 2 | 60 |  |  |  | Bottom 5
 |  | 1011 | Customer 11 | 100 | 120 | -20 | 80 | 96 | -16 | 4000 | 4800 | -800 | 0.8 | 0.8 | 0 | 50000 | 50000 | 0 | -800000 | 0 | 0 |  | Customer 8 | 60 |  |  |  | Customer 7 | 50
 |  | 1012 | Customer 12 | 10 | 12 | -2 | 8 | 9.6 | -1.6 | 400 | 480 | -80 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000 | 0 | -80000 | 0 | 5.551115123125783e-11 |  | Customer 16 | 60 |  |  |  | Customer 15 | 50
 |  | 1013 | Customer 13 | 20 | 24 | -4 | 16 | 19.2 | -3.199999999999999 | 800 | 960 | -160 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000 | 0 | -160000 | 0 | 1.110223024625157e-10 |  | Customer 18 | 60 |  |  |  | Customer 13 | 20
 |  | 1014 | Customer 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Customer 1 | 50 |  |  |  | Customer 12 | 10
 |  | 1015 | Customer 15 | 50 | 60 | -10 | 40 | 48 | -8 | 2000 | 2400 | -400 | 0.8 | 0.8 | 0 | 50000 | 50000 | 0 | -400000 | 0 | 0 |  | Customer 7 | 50 |  |  |  | Customer 20 | 10
 |  | 1016 | Customer 16 | 60 | 72 | -12 | 48 | 57.59999999999999 | -9.599999999999994 | 2400 | 2880 | -480 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000.00000000001 | 0 | -479999.9999999995 | 0 | 3.33066907387547e-10 |  | Customer 15 | 50
 |  | 1017 | Customer 17 | 70 | 84 | -14 | 56 | 67.2 | -11.2 | 2800 | 3360 | -560 | 0.8 | 0.8 | 0 | 50000 | 50000 | 0 | -560000 | 0 | 0 |  | Customer 13 | 20
 |  | 1018 | Customer 18 | 60 | 72 | -12 | 48 | 57.59999999999999 | -9.599999999999994 | 2400 | 2880 | -480 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000.00000000001 | 0 | -479999.9999999995 | 0 | 3.33066907387547e-10 |  | Customer 12 | 10
 |  | 1019 | Customer 19 | 65 | 78 | -13 | 52 | 62.4 | -10.4 | 2600 | 3120 | -520 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000 | 0 | -520000 | 0 | 3.608224830031759e-10 |  | Customer 20 | 10
 |  | 1020 | Customer 20 | 10 | 12 | -2 | 8 | 9.6 | -1.6 | 400 | 480 | -80 | 0.8 | 0.7999999999999999 | 0 | 50000 | 50000 | 0 | -80000 | 0 | 5.551115123125783e-11 |  | Customer 14 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19