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.

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.

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.
.

Does the 1700 number include the 18% growth?

Dave,
Yes it includes 18% growth.Thanks

-----Original Message-----
Does the 1700 number include the 18% growth?

.