Forecast Formula

[hughes4709]

Problems with the formula try to forecast future call
volumes.

# of calls 2003 vs # calls 2004.

The volume of calls is by day and trying to predict the
number of calls in advance for staffing needs.

Any Help or suggestions welcome

 

[Bob Phillips]

=A1*(1+n%)

where A1 is 2003 numbers, n is predicted growth rate?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Look at the Forcast worksheet function if you think the data is linear.
Generally data such as this has several components. This would give you the
trend component.