Today’s event in Newmarket was a chance to investigate tools and techniques to improve Advanced Forecasting and Financial Modelling in the NHS. Many thanks to everyone who made it despite the weather and travel disruption and made the day so interesting and challenging.
Comments on the evaluation forms included (reproduced with kind written permission):
“There was very good group interaction and working to discuss a wide range of forecasting techniques. I am looking forward to trying out these newly learned techniques in my workplace and passing this on to my work colleagues.” – David Lamb, Senior Management Accountant, Central Essex Community Services
“Good table working. Useful to hear others’ opinions.” – Sarah Brisbane, System Finance Lead, Cambridge and Peterborough CCG
Here are the resources from the day – please use the Username and Password given to you to access them – thank you!
The Linear Exponential Smoothing Forecasting Spreadsheet model – Advanced Forecasting Model – davidbaileyfcca – production v2 XLSX file
10 Step Method for Forecasting using Linear Exponential Smoothing PDF file
A copy of the authorised version of the Best Practice Spreadsheet Modelling Standards. The Spreadsheet Standards Review Board is the body that develops and maintains the Best Practice Spreadsheet Modelling Standards. The SSRB was established by BPM Analytical Empowerment Pty Ltd to bring together the best spreadsheet modelling skills from around the world in order to develop and gain general acceptance for comprehensive and universally applicable Best Practice Spreadsheet Modelling Standards:
Principles, Techniques and Practice of Spreadsheet Style by Philip L. Bewig — July 28, 2005:
Spreadsheet Modelling Best Practice by Nick Read and Jonathan Batson – April 1999:
CIMA’s review of In-year Financial Forecasting in the NHS from 2007:
Presentation from the day
Please get in touch if you would like any further resources or information.