The Best Practice Spreadsheet Modelling Standards ("the Standards") are the highest professional standards in spreadsheet development, maintenance and usage available in the world.
 The Standards are the result of many years of experience at the forefront of the Microsoft Excel based spreadsheet modelling sector, combined with a detailed understanding of the needs of both spreadsheet model developers and spreadsheet model users.
The primary objectives of the Standards are to:
- Improve quality & transparency
- Ensure user-friendliness
- Decrease spreadsheet model development time & cost
- Minimise risk of errors
- Allow efficient sharing of model development methodologies
- Prevent model redundancy
- Align model developers & model users
The Standards are comprehensive and cover every area of the spreadsheet development, maintenance and usage process.
|
 |
The Standards are split into 16 Spreadsheet Modelling Areas:
- General Concepts
- Workbook Structure
- Sheet Structure
- Formats & Styles
- Assumption Entry Interfaces
- Sensitivity Analysis
- Outputs & Presentations
- Calculation Formulae
- Naming Principles
- Time Series Analysis
- Error Checks
- Printing & Viewing
- Multiple Workbooks
- Security & Protection
- Visual Basic Programming
- Miscellaneous
BPM have made its universally applicable Best Practice Spreadsheet Modelling Standards freely and publicly available.
Any party may participate in the further development of the Standards, by submitting a Proposal Form to the SSRB.
|
