Need Help with Bell Curve Distribution

[Thomas7399]

Hi,

I work in contracting. I have 10 contracts I have bid on, each with a different probability of being awarded to me.

I know the start date, end date, and average manpower needed to complete each job. I want to plot a manpower chart for each job, weighted by the percentage of winning, with the correct start and end dates. Then, I want to plot the cumulative results across all ten jobs, and the entire date ranges, in order to be able to project my upcoming manpower needs.

Can someone please help me with this?

Thanks

 

[burns14hs]

I'm not exactly sure what this looks like in your head so it's difficult to tell you where to start. I believe you want a Gantt Chart... there are plenty free templates available through Google searches. I haven't used on in a while so I have no specific recommendations, but the images of your search results would show you what a complete one would look like.

 

[shg]

See the workbook at https://app.box.com/shared/ipkvdyc4bt, and in particular, the example on the UDFs tab.