Spread Project Costs Over Months Using Bell Curve
 

I need help developing and understanding how to distribute project costs over time (i.e. by month). I would also like to change the distribution and skew of the costs. For example say the costs are spread over 8 months based on a normal distribution curve, I would like to:

one: change the number of months say from 8 to 12, using start and end dates/periods

two: change the skewness (I think this is the right terminology!) so that the project costs are 'front' loaded (i.e. skewed to the left) or 'back' loaded (i.e. skewed to the right).

Any assistance would be appreciated

I have attahced a file of what I have done so far:

Table 1: represents % spread of project cost over 1 to 60 periods (i.e. months) using a normal distribution NOTE due to file upload size I have deleted this section

Table 2: represents $ spread of project cost over 1 to 60 periods (i.e. months) using a normal distribution NOTE due to file upload size I have deleted this section

Table 3; is my attempt to 'skew' the spread of project costs by changing column A and B values and display them as barred/bell curve. NOTE I have deleted the bell curve due to file upload size.

Hope I have provided enough for someone to help.

Thanks

Spread Project Costs Over Months Using Bell Curve
 

"Gizzmo" wrote:
I have attahced a file of what I have done so far:
Table 1: [....] NOTE due to file upload size I have
deleted this section

Table 2: [....] NOTE due to file upload size I have
deleted this section

Table 3; [....] NOTE I have
deleted the bell curve due to file upload size.

There is no reason to delete parts due to ExcelBanter file limitations.

You can upload the entire Excel file to a file-sharing website.

Then post the "shared", "public" or "view-only" link (aka URL; http://...)
in a response here.

The following is a list of some free file-sharing websites; or use your own.

Box.Net: http://www.box.net/files
Windows Live Skydrive: http://skydrive.live.com
MediaFi http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
RapidSha http://www.rapidshare.com

Thanks for the information, however as I am posting from work our IT Policy does not allow me to use these sites.

Spread Project Costs Over Months Using Bell Curve
 

Looks like this will do the trick..

http://www.excelville.com/file/1785/...eclining+Curve

https://youtu.be/DPjvIIXrCEU

On Friday, February 22, 2013 at 1:00:55 AM UTC-7, Gizzmo wrote:
'joeu2004[_2_ Wrote:
;1609596']"Gizzmo" wrote:-
I have attahced a file of what I have done so far:
Table 1: [....] NOTE due to file upload size I have
deleted this section

Table 2: [....] NOTE due to file upload size I have
deleted this section

Table 3; [....] NOTE I have
deleted the bell curve due to file upload size.-

There is no reason to delete parts due to ExcelBanter file limitations.

You can upload the entire Excel file to a file-sharing website.

Then post the "shared", "public" or "view-only" link (aka URL;
http://...)
in a response here.

The following is a list of some free file-sharing websites; or use your
own.

Box.Net: http://www.box.net/files
Windows Live Skydrive: http://skydrive.live.com
MediaFi http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
RapidSha http://www.rapidshare.com

Thanks for the information, however as I am posting from work our IT
Policy does not allow me to use these sites.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Gizzmo