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

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

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