Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 20
Default 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
Attached Files
File Type: zip Spread Project Costs (2).zip (47.1 KB, 174 views)
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 829
Default 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


  #3   Report Post  
Junior Member
 
Posts: 20
Smile

Quote:
Originally Posted by joeu2004[_2_] View Post
"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.
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bell Curve RLind Excel Worksheet Functions 7 April 21st 23 02:55 PM
How do I create a bell curve? I have my z, p, std. dev., mean,etc Brian Charts and Charting in Excel 1 August 17th 08 04:28 AM
Bell Curve Todd Nelson Excel Discussion (Misc queries) 3 December 7th 07 02:36 PM
standard bell curve MrDonnellon Excel Discussion (Misc queries) 2 July 24th 07 06:46 PM
Bell Curve Graph GatorGirl Charts and Charting in Excel 2 March 24th 07 12:15 AM


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"