3 Weeks Forecast-Excel 2003

D

Denver

Hi,
Jan3-8 Jan10-15 Jan17-22 Jan24-29
Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7
RcvdRL 6728 6732 7462 9034

I have this data in my excel, I want to make a forecast out of this data
in three weeks period.

I want to know what is my X, my Known_y's and known_x's? I'm not really
familiar
of any excel forecast fomula.

I appreciate for any help

thanks
 
J

Jacob Skaria

With the data arranged as below from Col A Row1 . Your figures in Row2..

Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7
6728 6732 9034 xx xx xx xx

In place of D2 you can try the below formula and copy that to right...
=FORECAST(COLUMN(),$A2:C2,COLUMN($A1:C1))

If this post helps click Yes
 
L

Lori

A quick way: Select your data and drag the fill handle (in the bottom right
corner of the selection) across to fill the blanks.

Otherwise use formulas like: =TREND(B2:E2,,5)

Both methods should agree and lie on the chart trendline.
 
J

Jacob Skaria

With the table in below format starting from ColA row1 with the week headers

Wk1 Wk2 Wk3 Wk4 Wk5 Wk6
6728 6732 9034 xx xx xx

the formul in D2 would be
=FORECAST(COLUMN(),$A2:C2,COLUMN($A1:C1))

Copy that to the right as required....

If this post helps click Yes
 
D

Denver

Thank you Lori and Jacob Skaria

Jacob Skaria said:
With the table in below format starting from ColA row1 with the week headers

Wk1 Wk2 Wk3 Wk4 Wk5 Wk6
6728 6732 9034 xx xx xx

the formul in D2 would be
=FORECAST(COLUMN(),$A2:C2,COLUMN($A1:C1))

Copy that to the right as required....

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top