Spreadsheet: 692614d1598463491-extrapolate-roll-existing-data-in-same-format-extrap-dummy-losincog-
Sheet: SAP Forecast

A | B | Doc | Type | SG | DD | Clrng doc. | Text | CoCd | Doc. Date | Amount in doc. curr. | Curr. | Pmnt date | Day1
A2 | B2 | AA | RE | A3 | Z4 | XL1 | ZZZZZZ3 | 0706 | 2020-07-27 00:00:00 | -36 | EUR | 2021-09-01 00:00:00 | 28
A3 | B3 | AA | RE | A4 | [NAME] | XL2 | ZZZZZZ4 | 0600 | 2020-07-27 00:00:00 | -37.03 | EUR |  | 28
A4 | B4 | AA | RE | A5 | Z6 | XL3 | ZZZZZZ5 | 0600 | 2020-07-29 00:00:00 | -37.03 | EUR |  | 28
A5 | B5 | AA | RE | A6 | Z7 | XL4 | ZZZZZZ6 | 0600 | 2020-07-27 00:00:00 | -62.07 | EUR |  | 28
A6 | B6 | AA | RE | A7 | Z8 | XL5 | ZZZZZZ7 | 0706 | 2020-08-08 00:00:00 | -89.25 | EUR |  | 28
A7 | B7 | AA | RE | A8 | Z9 | XL6 | ZZZZZZ8 | 0630 | 2020-07-27 00:00:00 | -131.65 | EUR |  | 28
A8 | B8 | AA | RE | A9 | [NAME] | XL7 | ZZZZZZ9 | 0600 | 2020-07-29 00:00:00 | -227.37 | EUR |  | 28
A9 | B9 | AA | RE | A10 | Z11 | XL8 | ZZZZZZ10 | 0600 | 2020-07-27 00:00:00 | -338.8 | EUR |  | 28
A10 | B10 | AA | RE | A11 | Z12 | XL9 | ZZZZZZ11 | 0600 | 2020-08-08 00:00:00 | -473.55 | EUR |  | 28
A11 | B11 | AA | RE | A12 | Z13 | XL10 | ZZZZZZ12 | 0630 | 2020-07-27 00:00:00 | -605 | EUR |  | 28
A12 | B12 | AA | RE | A13 | Z14 | XL11 | ZZZZZZ13 | 0600 | 2020-07-29 00:00:00 | -629.2 | EUR |  | 14
A13 | B13 | AA | RE | A14 | Z15 | XL12 | ZZZZZZ16 | 0630 | 2020-07-27 00:00:00 | -638.01 | EUR |  | 28
A14 | B14 | AA | RE | A15 | Z16 | [NAME] | ZZZZZZ15 | 0706 | 2020-08-08 00:00:00 | -642.6 | EUR |  | 7
A15 | B15 | AA | RE | A16 | Z17 | XL14 | ZZZZZZ16 | 0905 | 2020-07-27 00:00:00 | -704.32 | EUR |  | 28
A16 | B16 | AA | RE | A17 | Z18 | XL15 | ZZZZZZ17 | 0500 | 2020-07-29 00:00:00 | -738 | EUR |  | 14
A17 | B17 | AA | RE | A18 | Z19 | XL16 | ZZZZZZ18 | 0706 | 2020-07-27 00:00:00 | -845 | EUR |  | 28
A18 | B18 | AA | RE | A19 | Z20 | [NAME] | ZZZZZZ16 | 0802 | 2020-08-08 00:00:00 | -915.63 | EUR |  | 28
A19 | B19 | AA | RE | A20 | Z21 | XL18 | ZZZZZZ20 | 0706 | 2020-07-27 00:00:00 | -929.25 | EUR |  | 28
A20 | [NAME] | AA | RE | A21 | [NAME] | XL19 | ZZZZZZ21 | 1102 | 2020-07-29 00:00:00 | -992 | USD |  | 14
A21 | B21 | AA | RE | A22 | Z23 | XL20 | ZZZZZZ22 | 0630 | 2020-07-27 00:00:00 | -1016.4 | EUR |  | 28
A22 | B22 | AA | RE | A23 | Z24 | [NAME] | ZZZZZZ23 | 0630 | 2020-08-08 00:00:00 | -1127.12 | EUR |  | 28
A23 | B23 | AA | RE | A24 | Z25 | XL22 | ZZZZZZ24 | 0500 | 2020-07-27 00:00:00 | -1505.52 | EUR |  | 14
A24 | B24 | AA | RE | A25 | Z26 | XL23 | ZZZZZZ20 | 0500 | 2020-07-29 00:00:00 | -1537.5 | EUR |  | 28
A25 | B25 | AA | RE | A26 | Z27 | XL24 | [NAME] | 1102 | 2020-07-27 00:00:00 | -1548.4 | USD |  | 55
A26 | B26 | AA | RE | A27 | Z28 | XL25 | ZZZZZZ27 | 1102 | 2020-08-08 00:00:00 | -1560 | USD |  | 14
A27 | B27 | AA | RE | A28 | Z29 | XL26 | ZZZZZZ20 | 0600 | 2020-07-27 00:00:00 | -1584 | EUR |  | 28
A28 | B28 | AA | RE | A29 | Z30 | XL27 | ZZZZZZ29 | 0706 | 2020-07-29 00:00:00 | -1644.3 | EUR |  | 7
A29 | B29 | AA | RE | A30 | Z31 | XL28 | ZZZZZZ31 | 0706 | 2020-08-10 00:00:00 | -1740 | EUR |  | 14
A30 | B30 | AA | RE | A31 | Z32 | XL29 | ZZZZZZ31 | 0496 | 2020-08-10 00:00:00 | -1748.25 | USD |  | 14
A31 | B31 | AA | RE | A32 | Z33 | XL30 | ZZZZZZ32 | 1102 | 2020-08-10 00:00:00 | -1800 | USD |  | 3
A32 | B32 | AA | RE | A33 | Z34 | [NAME] | ZZZZZZ20 | 0630 | 2020-07-27 00:00:00 | -1815 | EUR |  | 28
A33 | B33 | AA | RE | A34 | Z35 | XL32 | ZZZZZZ34 | 0600 | 2020-07-29 00:00:00 | -2880 | EUR |  | 14
A34 | B34 | AA | RE | [NAME] | Z36 | [NAME] | ZZZZZZ31 | 1102 | 2020-08-10 00:00:00 | -2900 | USD |  | 14
[NAME] | B35 | AA | RE | A36 | Z37 | XL34 | ZZZZZZ31 | 0600 | 2020-08-10 00:00:00 | -2904 | EUR |  | 28
A36 | B36 | AA | RE | A37 | Z38 | XL35 | ZZZZZZ37 | 0600 | 2020-08-10 00:00:00 | -2904 | EUR |  | 21
A37 | B37 | AA | RE | A38 | Z39 | XL36 | [NAME] | 0600 | 2020-07-27 00:00:00 | -2904 | EUR |  | 21
A38 | B38 | AA | RE | A39 | Z40 | XL37 | ZZZZZZ39 | 0600 | 2020-07-29 00:00:00 | -2910 | EUR |  | 28
A39 | [NAME] | AA | RE | A40 | Z41 | XL38 | [NAME] | 4000 | 2020-08-10 00:00:00 | -2992 | AUD |  | 14
A40 | B40 | AA | RE | A41 | Z42 | XL39 | ZZZZZZ41 | 0630 | 2020-08-10 00:00:00 | -3000.8 | EUR |  | 28
A41 | [NAME] | AA | RE | A42 | Z43 | [NAME] | ZZZZZZ42 | 0600 | 2020-08-10 00:00:00 | -3012.9 | EUR |  | 7
A42 | B42 | AA | RE | A43 | Z44 | XL41 | ZZZZZZ43 | 0706 | 2020-07-27 00:00:00 | -4872 | EUR |  | 14
A43 | B43 | AA | RE | [NAME] | Z45 | XL42 | ZZZZZZ44 | 0600 | 2020-07-29 00:00:00 | -4896.87 | EUR |  | 14
[NAME] | B44 | AA | RE | A45 | Z46 | XL43 | ZZZZZZ45 | 4000 | 2020-08-10 00:00:00 | -4950 | AUD |  | 28
A45 | B45 | AA | RE | A46 | Z47 | [NAME] | [NAME] | 0560 | 2020-08-10 00:00:00 | -5009.4 | EUR |  | 28
A46 | B46 | AA | RE | A47 | Z48 | XL45 | ZZZZZZ47 | 0802 | 2020-08-10 00:00:00 | -10904.04 | EUR |  | 28
A47 | B47 | AA | RE | A48 | Z49 | XL46 | ZZZZZZ48 | 0706 | 2020-07-27 00:00:00 | -11006.48 | EUR |  | 28
A48 | B48 | AA | RE | A49 | Z50 | [NAME] | ZZZZZZ49 | 0706 | 2020-07-29 00:00:00 | -11130.22 | EUR |  | 45
A49 | [NAME] | AA | RE | [NAME] | Z51 | XL48 | ZZZZZZ50 | 0600 | 2020-08-10 00:00:00 | -11325.6 | EUR |  | 55
[NAME] | B50 | AA | RE | A51 | Z52 | XL49 | ZZZZZZ51 | 0600 | 2020-08-10 00:00:00 | -11392.15 | EUR |  | 21
A51 | B51 | AA | RE | A52 | Z53 | XL50 | ZZZZZZ52 | 0802 | 2020-08-10 00:00:00 | -11640 | EUR |  | 28
A52 | B52 | AA | RE | A53 | Z54 | XL51 | ZZZZZZ53 | 0902 | 2020-07-27 00:00:00 | -11899.54 | EUR |  | 14
A53 | B53 | AA | RE | [NAME] | Z55 | XL52 | ZZZZZZ54 | 3400 | 2020-07-29 00:00:00 | -19314.4 | MYR |  | 3
[NAME] | B54 | AA | RE | A55 | Z56 | [NAME] | ZZZZZZ55 | 0706 | 2020-08-10 00:00:00 | -19395.2 | EUR |  | 7
A55 | B55 | AA | RE | [NAME] | Z57 | XL54 | ZZZZZZ56 | 0706 | 2020-08-10 00:00:00 | -19488 | EUR |  | 21
[NAME] | B56 | AA | RE | A57 | [NAME] | XL55 | ZZZZZZ57 | 0706 | 2020-08-10 00:00:00 | -19778 | EUR |  | 7
A57 | B57 | AA | RE | A58 | [NAME] | XL56 | ZZZZZZ58 | 0802 | 2020-07-27 00:00:00 | -21000 | EUR |  | 28
A58 | B58 | AA | RE | A59 | Z60 | XL57 | [NAME] | 0706 | 2020-07-29 00:00:00 | -21692 | EUR |  | 14
A59 | B59 | AA | RE | A60 | Z61 | XL58 | ZZZZZZ60 | 0706 | 2020-08-10 00:00:00 | -22258.08 | EUR |  | 28
A60 | B60 | AA | RE | A61 | Z62 | XL59 | ZZZZZZ61 | 3300 | 2020-08-10 00:00:00 | -440000 | [NAME] |  | 10
A61 | B61 | AA | RE | A62 | Z63 | XL60 | ZZZZZZ62 | 0100 | 2020-08-10 00:00:00 | -7.56 | GBP |  | 7
A62 | B62 | AA | RE | A63 | Z64 | XL61 | ZZZZZZ63 | 1102 | 2020-07-27 00:00:00 | -18 | USD |  | 14
A63 | B63 | AA | RE | A64 | Z65 | XL62 | ZZZZZZ64 | 0100 | 2020-08-11 00:00:00 | -32.4 | USD |  | 14
A64 | B64 | AA | RE | A65 | Z66 | XL63 | ZZZZZZ65 | 0100 | 2020-08-13 00:00:00 | -34 | EUR |  | 14
A65 | B65 | AA | RE | A66 | Z67 | XL64 | ZZZZZZ66 | 0100 | 2020-08-11 00:00:00 | -57.22 | USD |  | 14
A66 | B66 | AA | RE | A67 | Z68 | XL65 | ZZZZZZ67 | 0100 | 2020-07-28 00:00:00 | -81 | GBP |  | 28
A67 | B67 | AA | RE | A68 | Z69 | XL66 | ZZZZZZ68 | 0706 | 2020-07-29 00:00:00 | -91.53 | EUR |  | 14
A68 | B68 | AA | RE | A69 | Z70 | XL67 | ZZZZZZ69 | 0100 | 2020-08-10 00:00:00 | -93.5 | USD |  | 14
A69 | B69 | AA | RE | A70 | Z71 | XL68 | ZZZZZZ70 | 0100 | 2020-08-10 00:00:00 | -102.52 | GBP |  | 14
A70 | B70 | AA | RE | [NAME] | [NAME] | XL69 | ZZZZZZ71 | 0100 | 2020-08-10 00:00:00 | -128.47 | GBP |  | 14
[NAME] | B71 | AA | KR | A72 | Z73 | XL70 | [NAME] | 0100 | 2020-07-27 00:00:00 | -155.95 | GBP |  | 7
A72 | B72 | AA | RE | A73 | Z74 | [NAME] | ZZZZZZ73 | 0100 | 2020-07-28 00:00:00 | -166.32 | GBP |  | 28
A73 | B73 | AA | RE | A74 | Z75 | [NAME] | ZZZZZZ74 | 0802 | 2020-07-29 00:00:00 | -179.87 | EUR |  | 28
A74 | B74 | AA | RE | A75 | Z76 | XL73 | ZZZZZZ75 | 0500 | 2020-08-10 00:00:00 | -180.99 | EUR |  | 28
A75 | B75 | AA | RE | A76 | Z77 | [NAME] | ZZZZZZ76 | 0100 | 2020-08-10 00:00:00 | -187.2 | USD |  | 14
A76 | B76 | AA | RE | A77 | Z78 | XL75 | ZZZZZZ77 | 0100 | 2020-07-29 00:00:00 | -198.72 | GBP |  | 14
A77 | B77 | AA | RE | A78 | Z79 | XL76 | ZZZZZZ78 | 0706 | 2020-08-10 00:00:00 | -220.4 | EUR |  | 28
A78 | B78 | AA | RE | A79 | Z80 | XL77 | ZZZZZZ79 | 0100 | 2020-08-10 00:00:00 | -230 | HKD |  | 14
A79 | B79 | AA | RE | A80 | Z81 | XL78 | ZZZZZZ80 | 0100 | 2020-08-10 00:00:00 | -276.04 | GBP |  | 7