Extra results columns are added to the
right of the forecasts. They are used to make additional
computations related to the forecasts or data. In the example
we have added a single column to compute the cumulative
values of column F. We have added a title and copied the
mean and standard deviation functions into Cells G4 and
G5. The initial cumulative value, 0, is placed in G18.
Into cell G19, we have placed the formula
=IF(F19="***","***",F19+G18)
The formula places *** in a cell when the F19 + G18
would return an error, and otherwise shows the sum in
the cell.
It is only necessary to place the formula in G19, in
period 1, because we will use the change command *Fill
Results* to create the remainder of the formulas
for this column. |