Home |
Search |
Today's Posts |
#1
|
|||
|
|||
forecast
I need help in forecasting. so any help will be highly
appreciated. I have a data as follows: Jan05 Feb05 Mar05 Apr05 May05 June05...... Dec05 Total 103 107 ... ... ... .... 1700 Based on Jan05 and Feb 05 data I need to fill up Mar 05 to Dec05 data to get a pre determined total of 1700. Is there any quick way or formula or function to solve this?? Thanks for your help. |
#2
|
|||
|
|||
One way:
Assuming your "Mar05" entry is in C1, and that you want the values in succeeding months to be equal: C2: =ROUND(($M2-SUM($A2:B2))/(COLUMN($M2)-COLUMN()),2) and copy across to L2. Then when you enter Mar05 data, the cells to the right will adjust. If you need a growth formula, rather than linear, what assumptions are you making about the rate of growth? In article , "Hella" wrote: I need help in forecasting. so any help will be highly appreciated. I have a data as follows: Jan05 Feb05 Mar05 Apr05 May05 June05...... Dec05 Total 103 107 ... ... ... .... 1700 Based on Jan05 and Feb 05 data I need to fill up Mar 05 to Dec05 data to get a pre determined total of 1700. Is there any quick way or formula or function to solve this?? Thanks for your help. |
#3
|
|||
|
|||
Thanks JE. I need to get 18% growth total for 05 compared
to 04 total so lets assume approx. 1.5% growth per months.or any growth to get it approx.18% for 2005.Any suggestion will be greatly appreciated.Thanks -----Original Message----- One way: Assuming your "Mar05" entry is in C1, and that you want the values in succeeding months to be equal: C2: =ROUND(($M2-SUM($A2:B2))/(COLUMN($M2)-COLUMN ()),2) and copy across to L2. Then when you enter Mar05 data, the cells to the right will adjust. If you need a growth formula, rather than linear, what assumptions are you making about the rate of growth? In article , "Hella" wrote: I need help in forecasting. so any help will be highly appreciated. I have a data as follows: Jan05 Feb05 Mar05 Apr05 May05 June05...... Dec05 Total 103 107 ... ... ... .... 1700 Based on Jan05 and Feb 05 data I need to fill up Mar 05 to Dec05 data to get a pre determined total of 1700. Is there any quick way or formula or function to solve this?? Thanks for your help. . |
#4
|
|||
|
|||
Does the 1700 number include the 18% growth?
|
#5
|
|||
|
|||
Dave,
Yes it includes 18% growth.Thanks -----Original Message----- Does the 1700 number include the 18% growth? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL LINK CELL FORMULA | Excel Worksheet Functions | |||
How do I forecast future payments by analyzing past payments? | Excel Worksheet Functions | |||
Forecast Formula | Excel Discussion (Misc queries) | |||
Best way to forecast individual sales territories? | Excel Discussion (Misc queries) | |||
How to make a forecast for a highly seasonal business? | Excel Discussion (Misc queries) |