+ Reply to Thread
Results 1 to 4 of 4

Bell curve cost projections with time and money variables

  1. #1
    Registered User
    Join Date
    06-15-2015
    Location
    South Florida
    MS-Off Ver
    2007
    Posts
    2

    Bell curve cost projections with time and money variables

    Hello to all,

    While trying to find a way through excel for what I thought might be a template I was lucky enough to find this forum and a small spread sheet attached. My need is to show cost projections for construction projects based on linear, front loaded, end loaded and bell curve. The bell curve is most representitive of actual. I have attached the template I have found. My need is to be able to alter this to show a change in durations and costs distributed over the different methods of projection. This particular sheet would be perfect for a 12 month project as the data page is limited to that.

    I will admit this forum is way over my head in expertise. Any help on this is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Bell curve cost projections with time and money variables

    There's a workbook at https://app.box.com/shared/ipkvdyc4bt that implements NASA's Beta polynomial for project loading curves.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-15-2015
    Location
    South Florida
    MS-Off Ver
    2007
    Posts
    2

    Re: Bell curve cost projections with time and money variables

    Wow, See that's golden. Rocket scientists, who knew? Thank you SHG for the link.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Bell curve cost projections with time and money variables

    You're welcome.

+ 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. Replies: 2
    Last Post: 02-19-2015, 02:00 PM
  2. How to make a bell curve/statistical curve????
    By pittstonacl in forum Excel General
    Replies: 1
    Last Post: 08-04-2014, 10:49 AM
  3. Cost projections
    By ldurham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2014, 09:03 AM
  4. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  5. Bell Curve
    By Girish H Tandon in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-05-2011, 11:44 PM

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