Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numeric representation of curve/distribution for resource forecasting
I am creating a resource forecast report, based on input from 2
sources, both outputting numeric data being fed into a single spreadsheet. What I am trying to achieve is a "curve" effect but with numeric values instead of a graph, to show the resource requirements, based upon a single value (number of days), an indicator showing whether the "curve" should be front, mid or back-end loaded (F, M, B) and the number of months (cells) this data should be spread over. So, for example, I have 45 as the number of days and 7 as the number of months, resulting in Jan Feb Mar Apr May Jun Jul F 5 12 12 8 5 2 1 M 1 3.5 11 14 11 3.5 1 B 1 2 5 8 12 12 5 Is there a function or method of achieving this ? Regards Fred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numeric representation of curve/distribution for resource forecast
Maybe you could use the Frequency function:
http://www.ozgrid.com/News/excel-histogram.htm http://www.handyexceltips.com/2007/1...-simple-logic/ Or, you could consider using the Histogram tool, under Tools Analysis ToolPak: http://www.treeplan.com/BetterHistog...41117_1555.htm http://office.microsoft.com/en-us/ex...109481033.aspx http://www.vertex42.com/ExcelArticles/mc/Histogram.html You should probably consider applying a graph to your final results... Regards, Ryan--- -- RyGuy "Fred" wrote: I am creating a resource forecast report, based on input from 2 sources, both outputting numeric data being fed into a single spreadsheet. What I am trying to achieve is a "curve" effect but with numeric values instead of a graph, to show the resource requirements, based upon a single value (number of days), an indicator showing whether the "curve" should be front, mid or back-end loaded (F, M, B) and the number of months (cells) this data should be spread over. So, for example, I have 45 as the number of days and 7 as the number of months, resulting in Jan Feb Mar Apr May Jun Jul F 5 12 12 8 5 2 1 M 1 3.5 11 14 11 3.5 1 B 1 2 5 8 12 12 5 Is there a function or method of achieving this ? Regards Fred |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numeric representation of curve/distribution for resourceforecast
Thanks for the suggested sites, I have had a quick look, before
heading for the hills for the weekend. The problem I face is that I am trying to generate the numbers that would go to make up the histogram from the single entry, in my example I have a total effort of 45 to be spread over 7 months(entries), rather than doing it the other way around. But, having looked at the sites, the fianl one you mention, Histogram.html, looks promising. Thanks and regards Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Normal distribution curve | Excel Worksheet Functions | |||
distribution curve (skewness) | Charts and Charting in Excel | |||
normal distribution curve | Charts and Charting in Excel | |||
area under curve and bilinear representation | Excel Programming | |||
distribution curve | Excel Programming |