software

Not only trouble with Excel, but with Maths I fear.

I am currently tracking the number of hours worked on Field Advisors. And
these are currently being stored in a [h].mm format. While this is important
the real importance comes from the average over a 17 week period, this
information is in row 3, and works on the last 17 weeks (so in V3, the
formula is AVERAGE(F2:V2) )

Also set up, is an =FORECAST() that looks at these overall averages to
predict what the advisors average will be in 1 month, 3 months and 6 months.
Here is where I start to have trouble, since FORECAST takes an average of the
values, does this mean i'm taking an average of an average, which isn't
correct?

What I want though is some way of entering a number of values, these being
quot;Hours per weekquot;, quot;Datequot; and quot;Target Averagequot; and getting returned any I
haven't entered. The Target Average will more than likely be fixed. So if I
enter say 01/09/06 the quot;Hours per weekquot; might say -2, indicating that that
advisor should 2 less hours a week to reach the Target Average. Or I could
enter -3 in the Hours per week, the date might say 19/07/06, telling me the
target would be reached by then.

I have a feeling there is some function in Excel to do this for me, but my
Maths is limited, so I don't understand half the functions in the list, even
looking at the help file.

Cheers for any help!


The hours worked will always vary week by week, and there will be a near
infinite number of data patterns, each of which will give a different
future forecast. You cannot predict random variation. You can determine
the average hours worked, and the extent to which quot;performancequot; varies.

look on the WEB under control charts or process behaviour charts.--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=536359