The Apply Linear Growth Rate calculation allows you to apply a specified fixed monthly growth amount to values for the selected cells using the previous period as a base.
To apply a Linear Growth Rate:
- Select the range of cells to be amended (this option is not available for periods that start in January as no base period would be available)
- Select Data > Apply Calculations from the tool-bar.
- Select the Apply Linear Growth Rate option
- Enter the monthly growth amount (positive or negative) that you wish to use (e.g. 200)
- Click Apply
A growth amount of 200 is then added to the value of the previous month for all of the selected cells, using the month before the first selected month as the base.