Distribute data in a bell curve format automatically across numerous months

In columns AA:AG I made a table for the curve based on the amounts originally given in columns L:Q
Note that as no example for four months was given I guessed at that one.
The formula used to populate columns L:Q is:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Yes you would need to expand the columns to accommodate twenty months.
For example five I manually placed 50,000 in the January column. I also changed actuals to date from 25,000 to 75,000 and start from Jan-24 to Feb-24. The formula in columns M:Q seems to produce the correct result because the integrity check is $0.00
Let us know if you have any questions.

You're Welcome and thank you for the feedback. If, after further inspection, you find the solution works as expected then please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post.
I hope that you have a blessed day.

Sorry I have another query. So I have started implementing this formula on my actual document and have encountered one specific issue which you may be able to assist with.

Taking it back to the bell curve example spreadsheet where you manually placed the 50,000 in the January column in example 5. Say the $50k is not an actual cost but rather the forecast (meaning I don't want to update the actuals to date in column D to $75k as you have put) and leave it as $25k.
How would I leave 50k in January, while keeping the actuals to date at $25k and still use the bell curve function to balance out the cost to complete. As it is now, it shows a negative -50k in integrity check because the formula is taking the full amount in Column E and doubling up on the manual figure in January.

That should be it, otherwise, thanks for your help.

I have seen the query in post #7.
I have tried a couple of things but don't know how to accomplish it with 2019 version functions/formulas.
Someone might be able to help by using the functions of the 365 version of Excel or by writing VBA code.