Spreadsheet: 692239d1598213952-extrapolate-roll-existing-data-in-same-format-extrapolate-dummy
Sheet: SAP Forecast

A | B | Doc | Type | SG | DD | Clrng doc. | Text | CoCd | Doc. Date | Amount in doc. curr. | Curr. | Net due dt | Pmnt date | Disc.1 | Day1
A2 | B2 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -36 | EUR | 2020-08-24 00:00:00 | 2021-09-01 00:00:00 | 0 | 28
A3 | B3 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -37.03 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A4 | B4 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -37.03 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A5 | B5 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -62.07 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A6 | B6 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -89.25 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A7 | B7 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -131.65 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A8 | B8 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -227.37 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A9 | B9 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -338.8 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A10 | B10 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -473.55 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A11 | B11 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -605 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A12 | B12 | AA | RE |  |  |  |  | 0600 | 2020-08-10 00:00:00 | -629.2 | EUR | 2020-09-07 00:00:00 | 2020-08-24 00:00:00 | 1.5 | 14
A13 | B13 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -638.01 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A14 | B14 | AA | RE |  |  |  |  | 0706 | 2020-08-17 00:00:00 | -642.6 | EUR | 2020-09-14 00:00:00 | 2020-08-24 00:00:00 | 3 | 7
A15 | B15 | AA | RE |  |  |  |  | 0905 | 2020-07-27 00:00:00 | -704.32 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A16 | B16 | AA | RE |  |  |  |  | 0500 | 2020-08-10 00:00:00 | -738 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A17 | B17 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -845 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A18 | B18 | AA | RE |  |  |  |  | 0802 | 2020-07-27 00:00:00 | -915.63 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A19 | B19 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -929.25 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A20 | [NAME] | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -992 | USD | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A21 | B21 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -1016.4 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A22 | B22 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -1127.12 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A23 | B23 | AA | RE |  |  |  |  | 0500 | 2020-08-10 00:00:00 | -1505.52 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A24 | B24 | AA | RE |  |  |  |  | 0500 | 2020-07-27 00:00:00 | -1537.5 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A25 | B25 | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -1548.4 | USD | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A26 | B26 | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -1560 | USD | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A27 | B27 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -1584 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A28 | B28 | AA | RE |  |  |  |  | 0706 | 2020-08-17 00:00:00 | -1644.3 | EUR | 2020-09-14 00:00:00 | 2020-08-24 00:00:00 | 3 | 7
A29 | B29 | AA | RE |  |  |  |  | 0706 | 2020-08-10 00:00:00 | -1740 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A30 | B30 | AA | RE |  |  |  |  | 0496 | 2020-08-10 00:00:00 | -1748.25 | USD | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A31 | B31 | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -1800 | USD | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A32 | B32 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -1815 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A33 | B33 | AA | RE |  |  |  |  | 0600 | 2020-08-10 00:00:00 | -2880 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A34 | B34 | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -2900 | USD | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
[NAME] | B35 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -2904 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A36 | B36 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -2904 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A37 | B37 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -2904 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A38 | B38 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -2910 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A39 | [NAME] | AA | RE |  |  |  |  | 4000 | 2020-08-10 00:00:00 | -2992 | AUD | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A40 | B40 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -3000.8 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A41 | [NAME] | AA | RE |  |  |  |  | 0600 | 2020-08-17 00:00:00 | -3012.9 | EUR | 2020-09-14 00:00:00 | 2020-08-24 00:00:00 | 3 | 7
A42 | B42 | AA | RE |  |  |  |  | 0706 | 2020-08-10 00:00:00 | -4872 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A43 | B43 | AA | RE |  |  |  |  | 0600 | 2020-08-10 00:00:00 | -4896.87 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
[NAME] | B44 | AA | RE |  |  |  |  | 4000 | 2020-07-27 00:00:00 | -4950 | AUD | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A45 | B45 | AA | RE |  |  |  |  | 0560 | 2020-07-27 00:00:00 | -5009.4 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A46 | B46 | AA | RE |  |  |  |  | 0802 | 2020-07-27 00:00:00 | -10904.04 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A47 | B47 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -11006.48 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A48 | B48 | AA | RE |  |  |  |  | 0706 | 2020-07-10 00:00:00 | -11130.22 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 45
A49 | [NAME] | AA | RE |  |  |  |  | 0600 | 2020-08-10 00:00:00 | -11325.6 | EUR | 2020-09-07 00:00:00 | 2020-08-24 00:00:00 | 1.5 | 14
[NAME] | B50 | AA | RE |  |  |  |  | 0600 | 2020-08-03 00:00:00 | -11392.15 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 21
A51 | B51 | AA | RE |  |  |  |  | 0802 | 2020-07-27 00:00:00 | -11640 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A52 | B52 | AA | RE |  |  |  |  | 0902 | 2020-08-10 00:00:00 | -11899.54 | EUR | 2020-09-07 00:00:00 | 2020-08-24 00:00:00 | 1.5 | 14
A53 | B53 | AA | RE |  |  |  |  | 3400 | 2020-08-10 00:00:00 | -19314.4 | MYR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
[NAME] | B54 | AA | RE |  |  |  |  | 0706 | 2020-08-17 00:00:00 | -19395.2 | EUR | 2020-09-14 00:00:00 | 2020-08-24 00:00:00 | 3 | 7
A55 | B55 | AA | RE |  |  |  |  | 0706 | 2020-08-03 00:00:00 | -19488 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 21
[NAME] | B56 | AA | RE |  |  |  |  | 0706 | 2020-08-17 00:00:00 | -19778 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 7
A57 | B57 | AA | RE |  |  |  |  | 0802 | 2020-07-27 00:00:00 | -21000 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A58 | B58 | AA | RE |  |  |  |  | 0706 | 2020-08-10 00:00:00 | -21692 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 14
A59 | B59 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -22258.08 | EUR | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 28
A60 | B60 | AA | RE |  |  |  |  | 3300 | 2020-08-14 00:00:00 | -440000 | [NAME] | 2020-08-24 00:00:00 | 2020-08-24 00:00:00 | 0 | 10
A61 | B61 | AA | RE |  |  |  |  | 0100 | 2020-08-18 00:00:00 | -7.56 | GBP | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 7
A62 | B62 | AA | RE |  |  |  |  | 1102 | 2020-08-11 00:00:00 | -18 | USD | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A63 | B63 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -32.4 | USD | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A64 | B64 | AA | RE |  |  |  |  | 0100 | 2020-08-13 00:00:00 | -34 | EUR | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A65 | B65 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -57.22 | USD | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A66 | B66 | AA | RE |  |  |  |  | 0100 | 2020-07-28 00:00:00 | -81 | GBP | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 28
A67 | B67 | AA | RE |  |  |  |  | 0706 | 2020-08-11 00:00:00 | -91.53 | EUR | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A68 | B68 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -93.5 | USD | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A69 | B69 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -102.52 | GBP | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A70 | B70 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -128.47 | GBP | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
[NAME] | B71 | AA | KR |  |  |  |  | 0100 | 2020-08-18 00:00:00 | -155.95 | GBP | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 7
A72 | B72 | AA | RE |  |  |  |  | 0100 | 2020-07-28 00:00:00 | -166.32 | GBP | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 28
A73 | B73 | AA | RE |  |  |  |  | 0802 | 2020-07-28 00:00:00 | -179.87 | EUR | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 28
A74 | B74 | AA | RE |  |  |  |  | 0500 | 2020-07-28 00:00:00 | -180.99 | EUR | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 28
A75 | B75 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -187.2 | USD | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A76 | B76 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -198.72 | GBP | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A77 | B77 | AA | RE |  |  |  |  | 0706 | 2020-07-28 00:00:00 | -220.4 | EUR | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 28
A78 | B78 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -230 | GBP | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 14
A79 | B79 | AA | RE |  |  |  |  | 0100 | 2020-08-18 00:00:00 | -276.04 | GBP | 2020-08-25 00:00:00 | 2020-08-25 00:00:00 | 0 | 7