+ Reply to Thread
Results 1 to 2 of 2

start-finish-cost+ bell curve

  1. #1
    Registered User
    Join Date
    07-11-2014
    Location
    Australia
    MS-Off Ver
    MS365 (2208)
    Posts
    48

    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. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    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.
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Bell curve cost projections with time and money variables
    By Hillmanengineering in forum Excel General
    Replies: 3
    Last Post: 06-16-2015, 03:34 PM
  2. Replies: 2
    Last Post: 02-19-2015, 02:00 PM
  3. How to make a bell curve/statistical curve????
    By pittstonacl in forum Excel General
    Replies: 1
    Last Post: 08-04-2014, 10:49 AM
  4. Replies: 3
    Last Post: 10-23-2012, 09:04 PM
  5. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  6. Replies: 5
    Last Post: 06-30-2011, 03:26 PM
  7. Bell Curve
    By uglymonky in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-06-2009, 09:25 AM

Bookmarks

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