# start-finish-cost+ bell curve

1. ## start-finish-cost+ bell curve

Hi,

Does anybody have a spread sheet which would do something similar to the below:

Look at a cells start, look at a cells finish and then spread this cost over the timeline of days in a bell curve way (costs ramping up over time and then down over time to the end).

Thanks.

2. ## Re: start-finish-cost+ bell curve

With the cost in A1, the starting date in A2, the ending date in A3, and the number 4 (as an intial guess) in A4, enter this formula

=NORM.DIST(\$A\$2+ROW(A1)-1,AVERAGE(\$A\$2:\$A\$3),\$A\$4,FALSE)*\$A\$1

and copy down until it starts returning 0. Label those cells with your dates. Change the number in cell A4 to get the shape of the curve that you like.

Note that you may need to increase the value in A1 to get the sum of the Norm.Dist cells to work out, since you may be truncating the curve (missing values) depending on the value in A4.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1