“The day was absolutely fantastic! David delivered the course beautifully and created an atmosphere where we all felt safe to ask questions and expand our knowledge.” – Advanced Forecasting and Financial Modelling – Kegworth

Advanced Forecasting

Today’s event in Kegworth was a chance to investigate tools and techniques to improve Advanced Forecasting and Financial Modelling in the NHS. Many thanks to everyone who came and made the day so interesting and challenging. It was a pleasure to have your company.

Evaluation Comments

Here are some of the evaluation comments (all reproduced with written permission):

“We thoroughly enjoyed the day and picked up lots of useful tips we can utilise in our jobs.”

“I really wasn’t sure what to expect today, but sincerely hoped I would leave with an understanding of forecasting, the methods used and the ability to do it. The day was absolutely fantastic! David delivered the course beautifully and created an atmosphere where we all felt safe to ask questions and expand our knowledge. I cannot wait to get back to work on Monday and crack on!! Thank you so much.”

“A useful, informative and practical course which really made you think about the different methods of looking at modelling.”

“I just wanted to say thanks for an excellent workshop today (Advanced Forecasting and Financial Modelling).  It was varied and had lots of opportunity to reflect on current practices in the NHS.  I’d recommend this to anyone who would like some time out to reflect on how well – and not so well too – their own organisation is doing.  Some useful practical tips, as well as a few advanced forecasting topics as well.  Thanks again.”

Resources

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:

BPSM Best Practice Spreadsheet Modelling Standards

Principles, Techniques and Practice of Spreadsheet Style by Philip L. Bewig — July 28, 2005:

How do you know your spreadsheet is right?

Spreadsheet Modelling Best Practice by Nick Read and Jonathan Batson – April 1999:

IBM Spreadsheet Modelling Best Practice

CIMA’s review of In-year Financial Forecasting in the NHS from 2007:

In-year Financial Forecasting in the NHS – CIMA

Presentation from the day:

Advanced Forecasting – presentation PDF

If you would like to leave a review of the day, please Leave A Reply below. Thanks.

Please get in touch if you would like any further resources or information.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.