Spreadsheet: 35134d1232648398-getting-excel-to-increase-the-range-each-month-export-sales-comparisons-suggestion
Sheet: Middle 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 - 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 | Budget |  | [NAME]
Middle East
Fawaz |  |  | 0 |  |  | 413 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | 413 | -413 | -100 | 0 |  |  |  | 0 |  |  |  | 0
Saudi Ind Tools |  |  | 97 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 97 | 0 | 97 | #N/A | 97 |  |  |  | 97 |  |  |  | 97
Somatco |  |  | 1820 |  |  | 0 | 0 |  |  | 1662 | 913 |  |  | 0 | 0 |  |  | 9821 | 2733 | 11483 | -8750 | -76.19959940782024 | 2733 |  |  |  | 2733 |  |  |  | 2733
Others |  |  | 808 |  |  | 2968 | 6175 |  |  | 1460 | 0 |  |  | 0 | 0 |  |  | 4334 | 6983 | 8762 | -1779 | -20.30358365669938 | 6983 |  |  |  | 6983 |  |  |  | 6983
S.Arabia Total |  |  | 2726 | 3857.142857142857 | -1131.142857142857 | 3381 | 6175 | 3857.142857142857 | 2317.857142857143 | 3122 | 913 | 3428.571428571428 | -2515.571428571428 | 0 | 0 | 3857.142857142857 | -3857.142857142857 | 14155 | 9814 | 20658 | -10844 | -52.49298092748572 | 9814 | 15000 | -5186 | -34.57333333333333 | 9814 | 11142.85714285714 | -1328.857142857145 | -11.92564102564104 | 9814 | 9857.142857142859 | -43.1428571428587 | -0.4376811594203056
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
Qatar Total |  |  | 0 | 514.2857142857142 | -514.2857142857142 | 0 | 1009 | 514.2857142857142 | 494.7142857142858 | 0 | 98 | 457.1428571428571 | -359.1428571428571 | 0 | 0 | 514.2857142857142 | -514.2857142857142 | 775 | 1107 | 775 | 332 | 42.83870967741936 | 1107 | 2000 | -892.9999999999998 | -44.65 | 1107 | 1485.714285714285 | -378.7142857142853 | -25.4903846153846 | 1107 | 1314.285714285714 | -207.2857142857142 | -15.77173913043478
 |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
[NAME] |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 14395 | 0 |  |  | 0 | 0 | 14395 | -14395 | -100 | 0 |  |  |  | 0 |  |  |  | 0
AKA |  |  | 0 |  |  | 4564 | 0 |  |  | 0 | 1300 |  |  | 0 | 0 |  |  | 0 | 1300 | 4564 | -3264 |  | 1300 |  |  |  | 1300 |  |  |  | 1300
[NAME] |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 3308 | 0 | 3308 | -3308 | -100 | 0 |  |  |  | 0 |  |  |  | 0
Five Stars |  |  | 0 |  |  | 1677 | 0 |  |  | 0 | 0 |  |  | 137 | 0 |  |  | 0 | 0 | 1814 | -1814 |  | 0 |  |  |  | 0 |  |  |  | 0
[NAME] |  |  | 0 |  |  | 2924 | 12448 |  |  | 9035 | -223 |  |  | 7570 | 0 |  |  | 6854 | 12225 | 26383 | -14158 | -53.66334381988401 | 12225 |  |  |  | 12225 |  |  |  | 12225
[NAME] |  |  | 0 |  |  | 9399 | 0 |  |  | 0 | 0 |  |  | 3606 | 0 |  |  | 0 | 0 | 13005 | -13005 |  | 0 |  |  |  | 0 |  |  |  | 0
Saifee |  |  | 0 |  |  | 13782 | 0 |  |  | 0 | 0 |  |  | -268 | 0 |  |  | 10733 | 0 | 24247 | -24247 | -100 | 0 |  |  |  | 0 |  |  |  | 0
[NAME] |  |  | 0 |  |  | 0 | 7146 |  |  | 12521 | 0 |  |  | 0 | 0 |  |  | 0 | 7146 | 12521 | -5375 | -42.92788115965179 | 7146 |  |  |  | 7146 |  |  |  | 7146
Technical Parts |  |  | 0 |  |  | 0 | 0 |  |  | 180 | 870 |  |  | 0 | 0 |  |  | 0 | 870 | 180 | 690 | 383.3333333333334 | 870 |  |  |  | 870 |  |  |  | 870
Others |  |  | 3207 |  |  | -103 | 3754 |  |  | 972 | 21881 |  |  | 496 | 0 |  |  | 3052 | 28842 | 4417 | 24425 | 552.9771338012225 | 28842 |  |  |  | 28842 |  |  |  | 28842
UAE Total |  |  | 3207 | 28285.71428571428 | -25078.71428571428 | 32243 | 23348 | 28285.71428571428 | -4937.714285714283 | 22708 | 23828 | 25142.85714285714 | -1314.857142857141 | 25936 | 0 | 28285.71428571428 | -28285.71428571428 | 23947 | 50383 | 104834 | -54451 | -51.94021023713681 | 50383 | 110000 | -59617 | -54.19727272727273 | 50383 | 81714.28571428571 | -31331.28571428571 | -38.34248251748251 | 50383 | 72285.71428571428 | -21902.71428571428 | -30.30019762845849
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
Bahrain Total |  |  | 861 | 1285.714285714286 | -424.7142857142858 | 1159 | 1160 | 1285.714285714286 | -125.7142857142858 | 0 | 549 | 1142.857142857143 | -593.8571428571429 | 902 | 0 | 1285.714285714286 | -1285.714285714286 | 2188 | 2570 | 4249 | -1679 |  | 2570 | 5000 | -2430 | -48.6 | 2570 | 3428.571428571428 | -858.571428571428 | -25.04166666666666 | 2570 | 3285.714285714285 | -715.7142857142853 | -21.78260869565216
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
Other Total |  |  | 895 | 771.4285714285716 | 123.5714285714284 | 0 | 1502 | 771.4285714285716 | 730.5714285714284 | 680 | 1258 | 685.7142857142858 | 572.2857142857142 | 869 | 0 | 771.4285714285716 | -771.4285714285716 | 645 | 3655 | 2194 | 1461 | 66.59070191431175 | 3655 | 3000 | 654.9999999999995 | 21.83333333333331 | 3655 | 2228.571428571429 | 1426.428571428571 | 64.00641025641023 | 3655 | 1971.428571428571 | 1683.571428571429 | 85.39855072463769
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
M.East Total |  |  | 7689 | 34714.28571428571 | -27025.28571428571 | 36783 | 33194 | 34714.28571428571 | -1520.285714285711 | 26510 | 26646 | 30857.14285714286 | -4211.142857142855 | 27707 | 0 | 34714.28571428571 | -34714.28571428571 | 41710 | 67529 | 132710 | -65181 | -49.1153643282345 | 67529 | 135000 | -67471 | -49.97851851851852 | 67529 | 100000 | -32471.00000000001 | -32.47100000000001 | 67529 | 88714.2857142857 | -21185.2857142857 | -23.88035426731077