REQ: I need help working out this function.
 

I have a sheet with sales, stock and wks cover by 2 wks forward average
sales(asuming I don't get any more stock).

N.B. figures are actual and estimated.


Date Sales Stock wks cover
(K) (K)
wk1 200 800 3.5
wk2 220 750 2.9
wk3 240 720 2.4
wk4 280 760 2.2
wk5 310 790 2.1
wk6 390 840 2.5
wk7 350 890 2.9
wk8 320 940 -
wk9 300 900 -

What I need is to take away my sales estimates from my actual current
stock cover to give a better figure because I have big sales peeks.

Is this possible? Thanks

--
Matt

I need help working out this function.
 

Two answers already in you multipost to Misc. Please stay in one newsgroup
to reduce wasted effort in people preparing duplicate answers.

--
Regards,
Tom Ogilvy

Matthew Webb wrote in message
...
I have a sheet with sales, stock and wks cover by 2 wks forward average
sales(asuming I don't get any more stock).

N.B. figures are actual and estimated.


Date Sales Stock wks cover
(K) (K)
wk1 200 800 3.5
wk2 220 750 2.9
wk3 240 720 2.4
wk4 280 760 2.2
wk5 310 790 2.1
wk6 390 840 2.5
wk7 350 890 2.9
wk8 320 940 -
wk9 300 900 -

What I need is to take away my sales estimates from my actual current
stock cover to give a better figure because I have big sales peeks.

Is this possible? Thanks

--
Matt