≡ Menu

Models

Annual Growth rates from Linear Trendlines

Annual Growth rates from Linear Trendlines Thumbnail

In this post I’ll demonstrate how to generate annual growth rates based on historic linear trends. It effectively adds the % annual growth rate to a linear trendline produced on an excel chart. I’ve previously published a post sharing a model I used to produce linear forecasts from historic activity data, so I could generate [...]

{ 2 comments }
Using Ramp-Up Profiles for QIPP Savings and Expenditure Thumbnail

You can use this ramp up trick to apply a phasing profile to planned expenditure but I am illustrating it here to model the monthly delivery of planned savings. In the NHS we tend to refer to savings as either QIPP (Quality, Innovation, Productivity and Prevention) or CIP (Cost Improvement Program) depending on whether you [...]

{ 2 comments }