This function allows you to take a value and grow it by a factor among selected cells.
You can use the following features for trend modeling:
Screen Element |
Description |
---|---|
Source Value |
The initial value from which the trend begins. |
Destination Range |
A range of cells to which the results of the trend are written. |
By Percentage |
A specified percentage of the previous value (previous cell) in the destination range. To create an increasing trend, use a positive percentage. To create a declining trend, use a negative percentage. |
By Value |
A specified amount over the previous value (previous cell) in the destination range. To create an increasing trend, enter a positive value. To create a declining trend, enter a negative value. |
Add to Existing Values |
Select this checkbox to take the spread amount to each cell and add it to any existing values already in the destination range. If you leave it blank, the amount spread to each cell overwrites the amounts in the destination cells. |
To use trend modeling, open the input schedule and select Trend from the action pane.