I am trying to figure out how to recreate a function in Excel that exists in Project, number distribution. Specifically, hours...I am trying to create a model that one can plug in the number of hours of work, length of the project in months, and select the type of distribution such as flat, front loaded, back loaded, etc.

The tools in the data analysis pack do not seem to accomplish this.