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

 |  |  | 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]
Oceania
Crown Scientific |  |  | 1093 |  |  | 2423 | 1311 |  |  | 1635 | 553 |  |  | 168 | 0 |  |  | 3068 | 2957 | 7294 | -4337 | -59.45982999725802 | 2957 |  |  |  | 2957 |  |  |  | 4821
Serrata |  |  | 0 |  |  | 7978 | 2165 |  |  | 7641 | 0 |  |  | 0 | 0 |  |  | 0 | 2165 | 15619 | -13454 | -86.13867725206478 | 2165 |  |  |  | 2165 |  |  |  | 4330
Technos |  |  | 3943 |  |  | 935 | 2189 |  |  | 0 | 0 |  |  | 1275 | 0 |  |  | 1531 | 6132 | 3741 | 2391 | 63.91339214113874 | 6132 |  |  |  | 6132 |  |  |  | 8321
Others |  |  | 257 |  |  | 911 | 4215 |  |  | 0 | 703 |  |  | 2576 | 0 |  |  | 451 | 5175 | 3938 | 1237 | 31.4118842051803 | 5175 |  |  |  | 5175 |  |  |  | 10093
Australia Total |  |  | 5293 | 7714.285714285715 | -2421.285714285715 | 12247 | 9880 | 7714.285714285715 | 2165.714285714285 | 9276 | 1256 | 6857.142857142857 | -5601.142857142857 | 4019 | 0 | 7714.285714285715 | -7714.285714285715 | 5050 | 16429 | 30592 | -14163 | -46.29641736401673 | 16429 | 30000 | -13571 | -45.23666666666666 | 16429 | 22285.71428571429 | -5856.71428571429 | -26.28012820512822 | 27565 | 19714.28571428572 | 7850.714285714283 | 39.82246376811592
Amalgamated H/W |  |  | 4959 |  |  | 4765 | 4207 |  |  | 2498 | 1600 |  |  | 5979 | 0 |  |  | 8015 | 10766 | 21257 | -10491 | -49.35315425506892 | 10766 |  |  |  | 10766 |  |  |  | 16573
[NAME] NZ |  |  | 3169 |  |  | 1350 | 1195 |  |  | 5063 | 1317 |  |  | 1507 | 0 |  |  | 2157 | 5681 | 10077 | -4396 | -43.62409447256127 | 5681 |  |  |  | 5681 |  |  |  | 8193
Others |  |  | 157 |  |  | 2159 | 0 |  |  | 1242 | 198 |  |  | 0 | 0 |  |  | 1872 | 355 | 5273 | -4918 | -93.2675896074341 | 355 |  |  |  | 355 |  |  |  | 553
NZ Total |  |  | 8285 | 7714.285714285715 | 570.7142857142853 | 8274 | 5402 | 7714.285714285715 | -2312.285714285715 | 8803 | 3115 | 6857.142857142857 | -3742.142857142857 | 7486 | 0 | 7714.285714285715 | -7714.285714285715 | 12044 | 16802 | 36607 | -19805 | -54.10167454312017 | 16802 | 30000 | -13198 | -43.99333333333333 | 16802 | 22285.71428571429 | -5483.71428571429 | -24.60641025641027 | 25319 | 19714.28571428572 | 5604.714285714283 | 28.42971014492752
Oceania Total |  |  | 13578 | 15428.57142857143 | -1850.571428571429 | 20521 | 15282 | 15428.57142857143 | -146.5714285714294 | 18079 | 4371 | 13714.28571428571 | -9343.285714285714 | 11505 | 0 | 15428.57142857143 | -15428.57142857143 | 17094 | 33231 | 67199 | -33968 | -50.54837125552464 | 33231 | 60000 | -26769 | -44.615 | 33231 | 44571.42857142858 | -11340.42857142858 | -25.44326923076924 | 52884 | 39428.57142857143 | 13455.42857142857 | 34.12608695652172