The attached workbook has one worksheet, "Forecast" it uses numerous statistical formula to produce various bell curves.
I am trying to figure out how to:
A) Change the starting point from 0 to a given number. Thereby allowing it to be truly used to forecast. with the total still being the same.
B) Change the number of periods from 41 to 20 or even to 80 as required. Also allowing for forecasting to final completion.
I don't even know where to start to figure this out. Any ideas, or even a solution would be appreciated. Maybe it can be done in formulas, maybe it needs VBA, not really sure yet.