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

 |  |  | Q1 |  |  |  | Q2 |  |  |  | Q3 |  |  |  | Q4 |  |  |  |  | YTD VS LAST YR |  |  | YTD VERSUS FULL YR BUDGET |  |  |  | YTD VERSUS YTD BUDGET |  |  |  | YTD VERSUS PREVIOUS YTD
Export Sales Budget - Major Accounts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * |  |  |  | *
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]
N. America
Canada Total |  |  | 1428 | 2571.428571428572 | -1143.428571428572 | 1914 | 7563 | 2571.428571428572 | 4991.571428571428 | 2736 | 476 | 2285.714285714286 | -1809.714285714286 | 496 | 0 | 2571.428571428572 | -2571.428571428572 | 1825 | 9467 | 6971 | 2496 | 0.3580547984507244 | 9467 | 10000 | -533 | -5.33 | 9467 | 7428.571428571428 | 2038.428571428572 | 27.44038461538463 | 9467 | 6571.428571428571 | 2895.571428571429 | 44.06304347826089
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
Barnstead |  |  | 9781 |  |  | 10997 | 26968 |  |  | 23408 | 14946 |  |  | 18562 | 0 |  |  | 17094 | 51695 | 70061 | -18366 | -0.2621429896804213 | 51695 |  |  |  | 51695 |  |  |  | 51695
[NAME] |  |  | 0 |  |  | -75 | 0 |  |  | -46 | 0 |  |  | -10 | 0 |  |  | -164 | 0 | -295 | 295 | -1 | 0 |  |  |  | 0 |  |  |  | 0
[NAME] |  |  | 8076 |  |  | 2079 | 12019 |  |  | 9528 | 11450 |  |  | 12733 | 0 |  |  | 11826 | 31545 | 36166 | -4621 | -0.127771940496599 | 31545 |  |  |  | 31545 |  |  |  | 31545
[NAME] |  |  | 0 |  |  | 18495 | 4153 |  |  | 0 | 13832 |  |  | 4375 | 0 |  |  | 13585 | 17985 | 36455 | -18470 | -0.5066520367576464 | 17985 |  |  |  | 17985 |  |  |  | 17985
Others |  |  | 6765 |  |  | 2395 | 4246 |  |  | 988 | 5007 |  |  | 0 | 0 |  |  | 17720 | 16018 | 21103 | -5085 | -0.2409610008055727 | 16018 |  |  |  | 16018 |  |  |  | 16018
USA Total |  |  | 24622 | 38571.42857142857 | -13949.42857142857 | 33891 | 47386 | 38571.42857142857 | 8814.571428571428 | 33878 | 45235 | 34285.71428571428 | 10949.28571428572 | 35660 | 0 | 38571.42857142857 | -38571.42857142857 | 60061 | 117243 | 163490 | -46247 | -0.2828735702489449 | 117243 | 150000 | -32757 | -21.838 | 117243 | 111428.5714285714 | 5814.42857142858 | 5.21807692307693 | 117243 | 98571.42857142857 | 18671.57142857143 | 18.94217391304349
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] (MAT054) |  |  | 14910 |  |  | 8108 | 16992 |  |  | 17134 | 15909 |  |  | 14673 | 0 |  |  | 15408 | 47811 | 55323 | -7512 | -0.1357843934710699 | 47811 |  |  |  | 47811 |  |  |  | 47811
Others |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
Mexico Total |  |  | 14910 | 12857.14285714286 | 2052.857142857145 | 8108 | 16992 | 12857.14285714286 | 4134.857142857145 | 17134 | 15909 | 11428.57142857143 | 4480.428571428572 | 14673 | 0 | 12857.14285714286 | -12857.14285714286 | 15408 | 47811 | 55323 | -7512 | -0.1357843934710699 | 47811 | 49999.99999999999 | -2188.999999999993 | -4.377999999999986 | 47811 | 37142.85714285714 | 10668.14285714286 | 28.72192307692309 | 47811 | 32857.14285714286 | 14953.85714285714 | 45.51173913043479
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
N. America Total |  |  | 40960 | 54000 | -13040 | 43913 | 71941 | 54000 | 17941 | 53748 | 61620 | 48000 | 13620 | 50829 | 0 | 54000 | -54000 | 77294 | 174521 | 225784 | -51263 | -0.2270444318463664 | 174521 | 210000 | -35479 | -16.8947619047619 | 174521 | 156000 | 18521.00000000003 | 11.87243589743592 | 174521 | 138000 | 36521 | 26.46449275362319