Spread Project Costs Over Months Using Bell Curve

[Gizzmo]

I need help developing and understanding how to distribute project cost
over time (i.e. by month). I would also like to change the distributio
and skew of the costs. For example say the costs are spread over
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 en
dates/periods

two: change the skewness (I think this is the right terminology!) s
that the project costs are 'front' loaded (i.e. skewed to the left) o
'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 hav
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 hav
deleted this section

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

Hope I have provided enough for someone to help.

Thank

+-------------------------------------------------------------------
|Filename: Spread Project Costs (2).zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=770
+-------------------------------------------------------------------

 

[joeu2004]

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
MediaFire: http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
RapidShare: http://www.rapidshare.com

 

[Gizzmo]

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 you
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 I
Policy does not allow me to use these sites

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