Spreadsheet: 35134d1232648398-getting-excel-to-increase-the-range-each-month-export-sales-comparisons-suggestion
Sheet: Africa

 |  |  | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 |  | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 |  | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00
 |  |  | Q1 |  |  |  | Q2 |  |  |  | Q3 |  |  |  | Q4 |  |  |  | YTD VS LAST YR |  |  |  | YTD VERSUS FULL YR BUDGET |  |  |  | YTD VERSUS YTD BUDGET |  |  |  | YTD VERSUS PREVIOUS YTD
Export Sales Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * |  |  |  | *
by Market |  |  | £ | £ | £ | Prev. | £ | £ | £ | Prev. | £ | £ | £ | Prev. | £ | £ | £ | Prev. | Year | Prev. | £ |  | Year | £ | £ |  | Year | Year | £ |  | Year | Previous | £
 |  |  | Q1 | Q1 | Budget | Year | Q2 | Q2 | Budget | Year | Q3 | Q3 | Budget | Year | Q4 | Q4 | Budget | Year | to date | [NAME] | YTD | %age | to date | Annual | YTD | %age | to date | to date | [NAME] | %age | to date | YTD | [NAME] | %age
Zone |  |  | Actual | Budget | [NAME] | Actual | Actual | Budget | [NAME] | Actual | Actual | Budget | [NAME] | Actual | Actual | Budget | [NAME] | Actual | Actual | Actual | [NAME] | [NAME] | Actual | Budget | [NAME] | [NAME] | Actual | Budget |  | [NAME] | Actual |  |  | [NAME]
Africa
Kenya Total |  |  | 839 | 2057.142857142857 | -1218.142857142857 | 0 | 2372 | 2057.142857142857 | 314.8571428571431 | 3478 | 5823 | 1828.571428571428 | 3994.428571428572 | 0 | 0 | 2057.142857142857 | -2057.142857142857 | 2971 | 9034 | 6449 | 2585 | 40.08373391223445 | 9034 | 7999.999999999999 | 1034.000000000001 | 12.92500000000001 | 9034 | 5942.857142857141 | 3091.142857142859 | 52.01442307692312 | 9034 | 5257.142857142857 | 3776.857142857143 | 71.84239130434783
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
CC Immelman |  |  | 3035 |  |  | 3961 | 0 |  |  | 517 | 3056 |  |  | 0 | 0 |  |  | 0 | 6091 | 4478 | 1613 | 36.02054488610987 | 6091 |  |  |  | 6091 |  |  |  | 6091
TGA International |  |  | 2169 |  |  | 735 | 0 |  |  | 0 | 0 |  |  | 1378 | 0 |  |  | 0 | 2169 | 2113 | 56 | 2.650260293421675 | 2169 |  |  |  | 2169 |  |  |  | 2169
Others |  |  | 5417 |  |  | 3666 | 1144 |  |  | 466 | 3625 |  |  | 1819 | 0 |  |  | 3001 | 10186 | 8952 | 1234 | 13.7846291331546 | 10186 |  |  |  | 10186 |  |  |  | 10186
South Africa Total |  |  | 10621 | 3857.142857142857 | 6763.857142857143 | 8362 | 1144 | 3857.142857142857 | -2713.142857142857 | 983 | 6680 | 3428.571428571428 | 3251.428571428572 | 3197 | 0 | 3857.142857142857 | -3857.142857142857 | 3001 | 18445 | 15543 | 2902 | 18.67078427587982 | 18445 | 15000 | 3445 | 22.96666666666667 | 18445 | 11142.85714285714 | 7302.142857142855 | 65.53205128205126 | 18445 | 9857.142857142859 | 8587.857142857141 | 87.12318840579707
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Morocco Total |  |  | 0 | 514.2857142857142 | -514.2857142857142 | 2112 | 0 | 514.2857142857142 | -514.2857142857142 | 0 | 1734 | 457.1428571428571 | 1276.857142857143 | 0 | 0 | 514.2857142857142 | -514.2857142857142 | 0 | 1734 | 2112 | -378 | -17.89772727272727 | 1734 | 2000 | -265.9999999999998 | -13.29999999999999 | 1734 | 1485.714285714285 | 248.2857142857147 | 16.71153846153849 | 1734 | 1314.285714285714 | 419.7142857142858 | 31.93478260869566
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Nigeria Total |  |  | 0 | 1285.714285714286 | -1285.714285714286 | 0 | 83 | 1285.714285714286 | -1202.714285714286 | 2916 | 0 | 1142.857142857143 | -1142.857142857143 | 0 | 0 | 1285.714285714286 | -1285.714285714286 | 1119 | 83 | 4035 | -3952 | -97.94299876084263 | 83 | 5000 | -4917 | -98.34 | 83 | 3714.285714285714 | -3631.285714285714 | -97.7653846153846 | 83 | 3285.714285714285 | -3202.714285714285 | -97.47391304347826
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Mauritius Total |  |  | 274 | 0 | 274 | 0 | 197 | 0 | 197 | 583 | 445 | 0 | 445 | 0 | 0 | 0 | 0 | 0 | 916 | 583 | 333 | 57.11835334476844 | 916 | 0 | 916 | #N/A | 916 | 0 | 916 | #N/A | 916 | 0 | 916 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Zimbabwe Total |  |  | 0 | 0 | 0 | 118 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 118 | -118 | -100 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Other Total |  |  | 562 | 1285.714285714286 | -723.7142857142858 | 732 | 0 | 1285.714285714286 | -1285.714285714286 | 0 | 0 | 1142.857142857143 | -1142.857142857143 | 0 | 0 | 1285.714285714286 | -1285.714285714286 | 0 | 562 | 732 | -170 | -23.224043715847 | 562 | 5000 | -4438 | -88.75999999999999 | 562 | 3714.285714285714 | -3152.285714285714 | -84.86923076923077 | 562 | 3285.714285714285 | -2723.714285714285 | -82.89565217391304
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Africa Total |  |  | 12296 | 9000 | 3296.000000000001 | 11324 | 3796 | 9000 | -5204 | 7960 | 14682 | 8000 | 6682 | 3197 | 0 | 9000 | -9000 | 7091 | 30774 | 29572 | 1202 | 4.064655755444339 | 30774 | 35000 | 4226 | -12.07428571428571 | 30774 | 26000 | 4774 | 18.36153846153846 | 30774 | 23000 | 7773.999999999996 | 33.79999999999998
 |  |  | * | This field must be updated in all areas at the beginning of each month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5943