Spreadsheet: 690192d1596922752-extrapolating-existing-data-depending-on-where-in-month-and-terms-sample-3-month-methodology-design
Sheet: SAP Forecast

Sum of Sthree Bank A/c Amt | Column Labels
Row Labels | Mon | Tue | Wed | Thu | Fri | Grand Total
AEAED10 |  |  |  | 108.80625 |  | 108.80625
AEAED14 | 165.82839 | 161.06426 |  |  |  | 326.89265
AEAED7 | 62.7501 |  |  |  |  | 62.7501
[NAME] | 42.96102 |  |  | 2.76 |  | 45.72102
AEUSD7 | 2.56115 | 5.88 |  |  |  | 8.44115
ATEUR14 | 9.66 | 23.404 |  | 3.276 |  | 36.34
ATEUR28 | 172.43838 | 122.24128 |  | 143.96591 |  | 438.64557
ATEUR7 | 38.39614999999999 | 27.42126 |  |  |  | 65.81741
AUAUD14 | 20.3918 | 16.94687 |  | 16.39 |  | 53.72867
AUAUD21 | 9.9 |  |  |  |  | 9.9
AUAUD28 | 27.335 | 28.3415 |  | 145.95251 |  | 201.62901
AUAUD7 |  | 48.48195000000001 |  |  |  | 48.48195000000001
BEEUR14 | 50.06068 | 116.92517 |  | 69.04516 |  | 236.03101
BEEUR28 | 580.94059 | 587.82557 |  | 757.74299 |  | 1926.50915
BEEUR30 |  | 49.03866 |  | 78.8813 |  | 127.91996
BEEUR35 |  |  |  | 15.1008 |  | 15.1008
BEEUR7 | 38.3818 | 29.92585 |  | 88.61813999999998 |  | 156.92579
CAUSD14 |  | 9.2 |  | 4.6 |  | 13.8
CHCHF14 |  |  |  | 47.1726 |  | 47.1726
CHCHF28 | 139.43944 | 20.16144 |  | 26.56676 |  | 186.16764
CHCHF7 |  | 24.34693 |  |  |  | 24.34693
CHEUR28 |  | 15.4525 |  |  |  | 15.4525
DEEUR10 |  |  |  | 16.5416 |  | 16.5416
DEEUR14 | 1056.433120000001 | 609.9159399999999 |  | 540.24589 |  | 2206.594950000001
DEEUR21 | 39.16821 | 15.97017 |  | 18.5832 |  | 73.72157999999999
DEEUR24 |  |  |  | 88.69283999999999 |  | 88.69283999999999
DEEUR28 | 3139.194769999999 | 3114.830210000001 |  | 3403.347839999999 |  | 9657.372819999997
DEEUR45 | 11.13022 |  |  |  |  | 11.13022
DEEUR7 | 772.57392 | 463.36013 |  | 643.0494399999999 |  | 1878.98349
ESEUR14 | 16.92064 |  |  | 7.124479999999999 |  | 24.04512
ESEUR28 | 124.70231 | 78.0438 |  | 120.46738 |  | 323.21349
ESEUR30 |  | 10.0188 |  | 6.621119999999999 |  | 16.63992
FREUR10 | 17.892 |  |  |  |  | 17.892
FREUR14 | 40.9632 | 41.256 |  | 134.02644 |  | 216.24564
FREUR28 | 293.9722600000001 | 432.02913 |  | 725.5538899999999 |  | 1451.55528
FREUR30 | 57.73692 | 840.79233 |  | 2878.12253 |  | 3776.65178
FREUR7 | 42.246 | 39.036 |  | 81.461 |  | 162.743
HKHKD3 |  |  |  | 255.608 |  | 255.608
IEEUR14 | 23.46988 | 44.39495000000001 |  | 65.21101999999999 |  | 133.07585
IEEUR28 | 89.82043999999999 | 81.54276999999999 |  | 86.57363000000001 |  | 257.93684
IEEUR7 | 3.04 |  |  | 41.328 |  | 44.36799999999999
JPJPY10 |  |  |  | 3821.456 |  | 3821.456
LUEUR14 | 16.23375 | 20.82249 |  | 15.21 |  | 52.26624
LUEUR28 |  | 47.68278 |  |  |  | 47.68278
MYMYR14 |  | 27.3632 |  |  |  | 27.3632
MYMYR7 |  | 17.849 |  |  |  | 17.849
NLEUR14 | 185.85737 | 55.51501 |  | 113.19017 |  | 354.56255
NLEUR21 | 11.39215 |  |  |  |  | 11.39215
NLEUR28 | 4158.33455 | 2846.085530000003 |  | 4054.275919999999 |  | 11058.696
[NAME] |  |  |  | 16.352 |  | 16.352
NLEUR30 |  |  |  | 17.39375 |  | 17.39375
NLEUR45 |  |  |  | 17.2788 |  | 17.2788
NLEUR7 | 77.96031 | 65.5765 |  | 140.37355 |  | 283.91036
NLGBP28 |  |  |  |  | 9.8 | 9.8
NLGBP7 |  |  |  |  | 12.9 | 12.9
NLUSD14 |  | 3.4833 |  |  |  | 3.4833
NLUSD28 | 4.448 | 12.848 |  |  |  | 17.296
NLUSD7 |  |  |  | 12.88 |  | 12.88
UKEUR14 | 62.66930000000001 | 21.667 |  | 87.60600000000002 |  | 171.9423
UKEUR28 | 23.73 | 13.9579 |  | 16.0925 |  | 53.7804
UKEUR7 |  |  |  | 6.391999999999999 |  | 6.391999999999999
UKGBP14 |  | 77.06105000000001 | 75.60739000000001 |  | 433.29987 | 585.96831
UKGBP25 |  |  |  |  | 18.31774 | 18.31774
UKGBP28 |  | 1019.41935 | 868.6274299999993 |  | 4120.41269 | 6008.459469999999
UKGBP7 |  | 131.18981 | 20.6894 |  | 699.83047 | 851.70968
UKUSD14 | 10.577 | 5.502000000000001 |  | 2.1 |  | 18.179
UKUSD7 | 59.22217999999999 |  |  |  |  | 59.22217999999999
USUSD10 |  |  |  | 7.68 |  | 7.68
USUSD14 | 372.3432500000002 | 310.9653999999999 |  | 397.0872000000002 |  | 1080.39585
Grand Total | 12073.07625 | 11734.83579 | 964.9242199999993 | 19346.80461 | 5294.56077 | 49414.20164