A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

3 Weeks Forecast-Excel 2003



 
 
Thread Tools Display Modes
  #1  
Old June 18th, 2009, 07:45 AM posted to microsoft.public.excel.worksheet.functions
Denver
external usenet poster
 
Posts: 91
Default 3 Weeks Forecast-Excel 2003

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
  #2  
Old June 18th, 2009, 10:25 AM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default 3 Weeks Forecast-Excel 2003

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
---------------
Jacob Skaria


"Denver" wrote:

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

  #3  
Old June 18th, 2009, 10:58 AM posted to microsoft.public.excel.worksheet.functions
Lori
external usenet poster
 
Posts: 673
Default 3 Weeks Forecast-Excel 2003

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.


"Denver" wrote:

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

  #4  
Old June 18th, 2009, 12:04 PM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default 3 Weeks Forecast-Excel 2003

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
---------------
Jacob Skaria


"Denver" wrote:

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

  #5  
Old June 18th, 2009, 03:01 PM posted to microsoft.public.excel.worksheet.functions
Denver
external usenet poster
 
Posts: 91
Default 3 Weeks Forecast-Excel 2003

Thank you Lori and Jacob Skaria

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Denver" wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.