| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How would I forecast something(sales) using excel | New Users to Excel | |||
| Forecast based on latest 26 weeks data | Excel Worksheet Functions | |||
| HOW DO YOU MAKE FORECAST FUNCTION WORK IN EXCEL? | Excel Worksheet Functions | |||
| how do I use the forecast function in Excel? | Excel Worksheet Functions | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
Threaded Mode
