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

 |  |  | 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]
Far East
Hopwell |  |  | 2209 |  |  | 3233 | 2869 |  |  | 0 | 630 |  |  | 3792 | 0 |  |  | 3909 | 5708 | 10934 | -5226 | -47.79586610572526 | 5708 |  |  |  | 5708 |  |  |  | 5708
[NAME] |  |  | 1367 |  |  | -51 | 0 |  |  | 7769 | 4508 |  |  | 6556 | 0 |  |  | 0 | 5875 | 14274 | -8399 | -58.84124982485638 | 5875 |  |  |  | 5875 |  |  |  | 5875
Others |  |  | 4021 |  |  | 8174 | 14883 |  |  | 3016 | 8180 |  |  | 1008 | 0 |  |  | 217 | 27084 | 12415 | 14669 | 118.1554571083367 | 27084 |  |  |  | 27084 |  |  |  | 27084
Hong Kong Total |  |  | 7597 | 10285.71428571429 | -2688.714285714286 | 11356 | 17752 | 10285.71428571429 | 7466.285714285714 | 10785 | 13318 | 9142.857142857143 | 4175.142857142857 | 11356 | 0 | 10285.71428571429 | -10285.71428571429 | 4126 | 38667 | 37623 | 1044 | 2.77489833346623 | 38667 | 40000 | -1333 | -3.3325 | 38667 | 29714.28571428571 | 8952.71428571429 | 30.12932692307694 | 38667 | 26285.71428571428 | 12381.28571428572 | 47.10271739130437
Indonesia Total |  |  | 0 | 514.2857142857142 | -514.2857142857142 | 0 | 1968 | 514.2857142857142 | 1453.714285714286 | 844 | 0 | 457.1428571428571 | -457.1428571428571 | 768 | 0 | 514.2857142857142 | -514.2857142857142 | 0 | 1968 | 1612 | 356 | 22.08436724565757 | 1968 | 2000 | -31.99999999999977 | -1.599999999999989 | 1968 | 1485.714285714285 | 482.2857142857147 | 32.4615384615385 | 1968 | 1314.285714285714 | 653.7142857142858 | 49.73913043478262
[NAME] |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
Others |  |  | 3416 |  |  | 3018 | 445 |  |  | 2037 | 208 |  |  | 4018 | 0 |  |  | 1603 | 4069 | 10676 | -6607 | -61.88647433495691 | 4069 |  |  |  | 4069 |  |  |  | 4069
Malaysia Total |  |  | 3416 | 3085.714285714286 | 330.2857142857138 | 3018 | 445 | 3085.714285714286 | -2640.714285714286 | 2037 | 208 | 2742.857142857143 | -2534.857142857143 | 4018 | 0 | 3085.714285714286 | -3085.714285714286 | 1603 | 4069 | 10676 | -6607 | -61.88647433495691 | 4069 | 12000 | -7931.000000000002 | -66.09166666666667 | 4069 | 8914.285714285716 | -4845.285714285716 | -54.35416666666667 | 4069 | 7885.714285714285 | -3816.714285714285 | -48.40036231884058
Gateway Ent. |  |  | 0 |  |  | 0 | 0 |  |  | 2485 | 0 |  |  | 0 | 0 |  |  | 1993 | 0 | 4478 | -4478 | -100 | 0 |  |  |  | 0 |  |  |  | 0
Others |  |  | 0 |  |  | 0 | 0 |  |  | 2105 | 0 |  |  | 0 | 0 |  |  | 5852 | 0 | 7957 | -7957 |  | 0 |  |  |  | 0 |  |  |  | 0
Philipines Total |  |  | 3185 | 2571.428571428572 | 613.5714285714284 | 0 | 0 | 2571.428571428572 | -2571.428571428572 | 4590 | 470 | 2285.714285714286 | -1815.714285714286 | -1184 | 0 | 2571.428571428572 | -2571.428571428572 | 7845 | 3655 | 11251 | -7596 | -67.51399875566617 | 3655 | 10000 | -6345 | -63.45 | 3655 | 7428.571428571428 | -3773.571428571428 | -50.79807692307692 | 3655 | 6571.428571428571 | -2916.428571428571 | -44.38043478260869
Far East Trading |  |  | 0 |  |  | 3305 | 9252 |  |  | 0 | 5098 |  |  | 0 | 0 |  |  | 0 | 14350 | 3305 | 11045 | 334.1906202723147 | 14350 |  |  |  | 14350 |  |  |  | 14350
Flowline |  |  | 4476 |  |  | 4147 | 10283 |  |  | 431 | 0 |  |  | 0 | 0 |  |  | 0 | 14759 | 4578 | 10181 | 222.3896898208825 | 14759 |  |  |  | 14759 |  |  |  | 14759
Hup Gee |  |  | 6921 |  |  | 6256 | 3031 |  |  | 4438 | 0 |  |  | 0 | 0 |  |  | 0 | 9952 | 10694 | -742 | -6.938470170188891 | 9952 |  |  |  | 9952 |  |  |  | 9952
J & J Inst. |  |  | 428 |  |  | 9832 | 0 |  |  | 0 | 800 |  |  | 0 | 0 |  |  | 6649 | 1228 | 16481 | -15253 | -92.54899581336083 | 1228 |  |  |  | 1228 |  |  |  | 1228
Matrix |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | #N/A | 0 |  |  |  | 0 |  |  |  | 0
[NAME] |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | #N/A | 0 |  |  |  | 0 |  |  |  | 0
[NAME] |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | #N/A | 0 |  |  |  | 0 |  |  |  | 0
Triton Marine |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 10134 | 0 |  |  | 0 | 0 | 10134 | -10134 | -100 | 0 |  |  |  | 0 |  |  |  | 0
Unimix |  |  | 1312 |  |  | 4690 | 8943 |  |  | 695 | 0 |  |  | 11989 | 0 |  |  | 6941 | 10255 | 24315 | -14060 | -57.82438823771334 | 10255 |  |  |  | 10255 |  |  |  | 10255
Others |  |  | 2847 |  |  | 125 | 513 |  |  | 1266 | 0 |  |  | 2646 | 0 |  |  | 2506 | 3360 | 6543 | -3183 | -48.64740944520862 | 3360 |  |  |  | 3360 |  |  |  | 3360
Singapore Total |  |  | 15984 | 21857.14285714286 | -5873.142857142855 | 28355 | 32022 | 21857.14285714286 | 10164.85714285714 | 6830 | 5898 | 19428.57142857143 | -13530.57142857143 | 24769 | 0 | 21857.14285714286 | -21857.14285714286 | 16096 | 53904 | 76050 | -22146 | -29.12031558185404 | 53904 | 85000 | -31096 | -36.5835294117647 | 53904 | 63142.85714285713 | -9238.85714285713 | -14.63167420814478 | 53904 | 55857.14285714285 | -1953.142857142848 | -3.496675191815841
Taiwan Total |  |  | 0 | 1285.714285714286 | -1285.714285714286 | 0 | 0 | 1285.714285714286 | -1285.714285714286 | 0 | 0 | 1142.857142857143 | -1142.857142857143 | 0 | 0 | 1285.714285714286 | -1285.714285714286 | 4851 | 0 | 4851 | -4851 |  | 0 | 5000 | -5000 | -100 | 0 | 3714.285714285714 | -3714.285714285714 | -100 | 0 | 3285.714285714285 | -3285.714285714285 | -100
Arsom |  |  | 4809 |  |  | 3563 | 5699 |  |  | 4522 | -85 |  |  | 4271 | 0 |  |  | 2110 | 10423 | 14466 | -4043 | -27.94829254804369 | 10423 |  |  |  | 10423 |  |  |  | 10423
[NAME] |  |  | 0 |  |  | 8056 | 6269 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 6269 | 8056 | -1787 | -22.18222442899702 | 6269 |  |  |  | 6269 |  |  |  | 6269
Tech Instruments |  |  | 2051 |  |  | 88 | 836 |  |  | 2898 | 888 |  |  | 0 | 0 |  |  | 1210 | 3775 | 4196 | -421 | -10.03336510962822 | 3775 |  |  |  | 3775 |  |  |  | 3775
Others |  |  | -14 |  |  | 0 | 0 |  |  | 50 | 659 |  |  | 2340 | 0 |  |  | 0 | 645 | 2390 | -1745 | -73.01255230125523 | 645 |  |  |  | 645 |  |  |  | 645
Thailand Total |  |  | 6846 | 7714.285714285715 | -868.2857142857147 | 11707 | 12804 | 7714.285714285715 | 5089.714285714285 | 7470 | 1462 | 6857.142857142857 | -5395.142857142857 | 6611 | 0 | 7714.285714285715 | -7714.285714285715 | 3320 | 21112 | 29108 | -7996 | -27.47011130960561 | 21112 | 30000 | -8888 | -29.62666666666667 | 21112 | 22285.71428571429 | -1173.71428571429 | -5.266666666666684 | 21112 | 19714.28571428572 | 1397.714285714283 | 7.089855072463751
Vietnam Total |  |  | 0 | 1285.714285714286 | -1285.714285714286 | 2887 | 0 | 1285.714285714286 | -1285.714285714286 | 0 | 0 | 1142.857142857143 | -1142.857142857143 | 0 | 0 | 1285.714285714286 | -1285.714285714286 | 653 | 0 | 3540 | -3540 | -100 | 0 | 5000 | -5000 | -100 | 0 | 3714.285714285714 | -3714.285714285714 | -100 | 0 | 3285.714285714285 | -3285.714285714285 | -100
Japan Total |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Other Total |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 137 | 0 | 137 | 0 | 0 | 0 | 0 | 0 | 137 | 0 | 137 |  | 137 | 0 | 137 |  | 137 | 0 | 137 |  | 137 | 0 | 137
India/Pakistan/Sri Lanka |  |  | 2939 | 2571.428571428572 | 367.5714285714284 | 958 | 1341 | 2571.428571428572 | -1230.428571428572 | 2729 | 2001 | 2285.714285714286 | -284.7142857142858 | 2337 | 0 | 2571.428571428572 | -2571.428571428572 | 1688 | 6281 | 7712 | -1431 | -18.5554979253112 | 6281 | 10000 | -3719 | -37.19 | 6281 | 7428.571428571428 | -1147.571428571428 | -15.44807692307691 | 6281 | 6571.428571428571 | -290.4285714285706 | -4.419565217391293
 | Far East Total |  | 39967 | 51171.42857142857 | -11204.42857142857 | 58281 | 66332 | 51171.42857142857 | 15160.57142857143 | 35285 | 23494 | 45485.71428571428 | -21991.71428571428 | 48675 | 0 | 51171.42857142857 | -51171.42857142857 | 40182 | 129793 | 182423 | -52630 | -28.85052871622548 | 129793 | 199000 | -69207 | -34.77738693467337 | 129793 | 147828.5714285714 | -18035.57142857139 | -12.20032856590643 | 129793 | 130771.4285714286 | -978.4285714285652 | -0.7481975092855535
Asia Total |  |  | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | -632.5714285714289 | 0 | #N/A | #N/A | #N/A | #N/A