#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Forecast Formula

Hi,

I have a table as per the appended below table. Now I want to forecast what
I am going to be doing on sales rate for the 10th of May or for a later date
based on the data provided in the table.

Date Eligibles Sales Sales Rate
5/1/2009 3618 222 6.14%
5/2/2009 1981 97 4.90%
5/3/2009 2396 122 5.09%
5/4/2009 4719 291 6.17%
5/5/2009 3981 258 6.48%
5/6/2009 3644 281 7.71%
5/7/2009 3081 235 7.63%
5/8/2009 2316 139 6.00%

Which formula should I use and how do I go about it?

Thanks,
Sam.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 89
Default Forecast Formula

What are you using for your forecasting modeling?

More info is required before anyone can recommend an approach to solving this.

Irie

"Sam" wrote:

Hi,

I have a table as per the appended below table. Now I want to forecast what
I am going to be doing on sales rate for the 10th of May or for a later date
based on the data provided in the table.

Date Eligibles Sales Sales Rate
5/1/2009 3618 222 6.14%
5/2/2009 1981 97 4.90%
5/3/2009 2396 122 5.09%
5/4/2009 4719 291 6.17%
5/5/2009 3981 258 6.48%
5/6/2009 3644 281 7.71%
5/7/2009 3081 235 7.63%
5/8/2009 2316 139 6.00%

Which formula should I use and how do I go about it?

Thanks,
Sam.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forecast Formula help Jason Hall Excel Discussion (Misc queries) 5 October 18th 09 03:37 AM
Forecast Formula Sam Excel Discussion (Misc queries) 1 May 12th 09 05:24 PM
Forecast Formula Help BBAL20 Excel Discussion (Misc queries) 1 July 24th 08 07:15 AM
Need help with formula to forecast revenue dj479794 Excel Discussion (Misc queries) 2 November 30th 07 10:35 PM
Forecast Formula Sandra Cummins Excel Discussion (Misc queries) 2 March 7th 05 01:41 PM


All times are GMT +1. The time now is 12:00 PM.

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

About Us

"It's about Microsoft Excel"