Calculates Average rate of change (AARC or AROC) without the compounded
formula:
(end_value
/ baseline_value
)/(end_year
- baseline_year
)
Arguments
- baseline_year
year where the AARC starts
- baseline_value
value at start_year
- end_year
year where the AARC ends
- end_value
value at end_year
Details
This formula provides an absolute value change and not a proportional one
like calculate_aarc
. To forecast change it should be add to the baseline
value:
baseline_value
+ (aroc
*(current_year
- start_year
))
See also
General scenario functions
add_scenario()
,
calculate_aarc()
,
exec_scenario()
,
fill_cols_scenario()
,
flat_extrapolation()
,
get_aarr()
,
get_baseline_value()
,
get_baseline_year()
,
get_last_value()
,
get_last_year_scenario()
,
get_latest_aarc()
,
get_percent_change_aarc()
,
get_target_aarc()
,
remove_unwanted_scenarios()
,
trim_values()
,
trim_years()