Spreadsheet: 856370d1705618783-distribute-data-in-a-bell-curve-format-automatically-across-numerous-months-cashflow-bell-curve-example-robbyf44-
Sheet: CASHFLOW Rev 1

CASHFLOW |  | Date |  |  |  |  |  |  | When I select the type of curve, I want the figures to be distributed per the months selected | Submitted means actual cost for that month which is entered manually | Remaining months are forecasted based on the start & finish times - Note this will be updated on a month by month basis
 |  |  |  |  |  |  |  |  |  | Submitted | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast |  |  |  |  |  |  |  |  |  | Distribution
Item | DESCRIPTION OF TASK | EXAMPLE FIGURES | Actuals to Date | Cost to [NAME] | Integrity Check | Start | Finish | Time (Months) | Type of Curve | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | Months | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6
1 | Example 1 | 100000 |  |  |  | 2024-01-01 00:00:00 | 2024-06-30 00:00:00 |  | Linear | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0.25 | 0.5 | 0.25
2 | Example 2 | 50000 |  |  |  | 2024-02-01 00:00:00 | 2024-06-30 00:00:00 |  | Bell Curve |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guessing> | 4 | 0.2 | 0.3 | 0.3 | 0.2
3 | Example 3 | 20000 |  |  |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | Linear | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 0.175 | 0.2 | 0.25 | 0.2 | 0.175
4 | Example 4 | 250000 |  |  |  | 2024-01-01 00:00:00 | 2024-05-31 00:00:00 |  | Manual | 150000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.13 | 0.1704 | 0.1996 | 0.1996 | 0.1704 | 0.13
5 | Example 5 | 300000 | 75000 |  |  | 2024-02-01 00:00:00 | 2024-06-30 00:00:00 |  | Bell Curve | 25000 | 50000 |  |  |  |  |  | On this particular row - I want to have the ability of entering figures manually where I want and once I change it to bell curve, I want it to fill in the remaining costs that are in the integrity check column as a bell curve in the remaining fields per the months selected.
6 | Example 6 | 30000 |  |  |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | Bell Curve
7 | Example 7 | 10000 |  |  |  | 2024-02-01 00:00:00 | 2024-05-31 00:00:00 |  | Linear
8 | Example 8 | 20000 |  |  |  | 2024-01-01 00:00:00 | 2024-05-31 00:00:00 |  | Linear
9 | Example 9 | 60000 |  |  |  | 2024-03-01 00:00:00 | 2024-05-31 00:00:00 |  | Linear
10 | Example 10 | 500000 |  |  |  | 2024-01-01 00:00:00 | 2024-06-30 00:00:00 |  | Bell Curve
 | TOTAL
 |  |  |  |  |  |  | Note - the tail end of the bell curve will vary for each item - Is there a way to make it flexible when selecting bell curve for a specific line item.
 |  |  |  |  |  |  | For example 5 above - it could also have a closer tail depending on the task. --->
 |  |  |  |  |  |  |  |  |  | 25000 | 50000 | - | 55250 | 57250 | 57250 | 55250
 |  |  |  |  |  |  |  | Linear | Equal number automatically distributes for the months
 |  |  |  |  |  |  |  | Manual | Manual numbers entered to zero (0) out the integrity check
 |  |  |  |  |  |  |  | Bell Curve | Bell curve data automatically distributes for the selected months. Should be flexible with entering manual figures and submitted figures
 |  |  |  |  |  |  |  | Note | This forecast should have the flexibility of adding additional months with the formulas being updated.