Growth rate tool
Version 1.0.5
The growth rate tool automates the calculation of future values based on prior cell values and user-defined percentage growth rates.
Growth rates can be set for each cell covered by the date range, allowing the user to enter percentages that are used to calculate subsequent cell values according to the formula below. If no value is entered into a cell, a growth rate of 0% is assumed and the values in subsequent cells will equal that of the reference cell – making this a quick tool to set an entire row equal to one value.
Version 1.0.6
See Applying tools for an explanation of how tools are used in Parfera.
Note: The interval of the growth rate inputs matches the sheet time interval set when the rate tool is applied to a row (e.g., quarterly sheet interval results in quarterly rate tool growth rates). If a different growth rate interval is desired, delete and reapply the growth rate tool after changing the sheet time interval.