Today’s event in Bedforshire was a chance to investigate tools and techniques to improve Forecasting and Financial Modelling in the NHS.
Comments on the evaluation forms included (reproduced with kind written permission):
“Very good interactive day.” – Sonya Carey, Bedford Hospitals NHS Trust
“Very good presenter.” – Layla Larham, Management Accountant, Bedford Hospital NHS Trust
“Lots of great and useful info. Great communication – enjoyed the day and learnt loads.” – Alan McClean, Management Accountant, Cambridgeshire Community Services
“Really enjoyed the course. David kept it interesting and funny / enjoyable.” – Steve Gill, Project Accountant, NHS Bedfordshire
“Really enjoyed today. Liked the friendly style of training.” – Luba Findrova, Assistant Financial Accountant, NHS Bedfordshire
“It was an excellent day. I have learnt a lot that I will be able to incorporate into my job. David was very easy to understand and explained everything brilliantly.” – Gina Manning, Management Accountant, NHS Bedfordshire
Here are the resources from the day – please use the Username and Password given to you to access them – thank you!
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
A simple Visual Basic Excel macro which will colour-code cells to highlight the contents of each cell with different formats:
Colour Coding Excel Macro
An Excel workbook containing some simple suggestions for spreadsheet design:
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
Forecasting and Financial Modelling Presentation Handout PDF
Please get in touch if you would like any further resources or information.