C
Cham
Hi,
I have a forecasting question.
I have a spreadsheet with 20 rows each having an actual value for each motnh
since a project start.
I want to get a forecast from the actuals, budgeted amount and the
remaining months.
But in the function i want to make sure it does it correct, i.e. i want it
to think that if any of the columns prior to this current months column has
value then take those values, distract it from the budgeted amount and take
what ever is left out of the budget and forecast it into all the months that
are left in the project.
is this possible?
example
ColA ColB ColC
100 Name X total Budget Month1 Month2 CurrentMonth Month3 Month4
101 Name X total Budget 1000 1000 [function] >>>
forecasted nr
102 Name X total Budget 2000
103 Name X total Budget 3200
104 Name X total Budget 5000
105 Name X total Budget 4000
I have a forecasting question.
I have a spreadsheet with 20 rows each having an actual value for each motnh
since a project start.
I want to get a forecast from the actuals, budgeted amount and the
remaining months.
But in the function i want to make sure it does it correct, i.e. i want it
to think that if any of the columns prior to this current months column has
value then take those values, distract it from the budgeted amount and take
what ever is left out of the budget and forecast it into all the months that
are left in the project.
is this possible?
example
ColA ColB ColC
100 Name X total Budget Month1 Month2 CurrentMonth Month3 Month4
101 Name X total Budget 1000 1000 [function] >>>
forecasted nr
102 Name X total Budget 2000
103 Name X total Budget 3200
104 Name X total Budget 5000
105 Name X total Budget 4000