Best Practice Modelling Standards

Overview

The Best Practice Spreadsheet Modelling Standards ('Standards') are the foundation upon which BPM provides its best practice modelling products and services. The standards are available in two editions:

  1. Best Practice Spreadsheet Modelling Standards; and
  2. Best Practice Spreadsheet Modelling Standards - Commentary & Examples.

The first edition is maintained by the independent Spreadsheet Standards Review Board (discussed below) and contains a listing of the standards and conventions. The Commentary & Examples edition takes these standards and conventions and contains a detailed discussion of the justification for each of them with examples of their implementation. Both editions of the standards can be freely downloaded by clicking here.

Spreadsheet Standardisation

The standards are the highest professional standards in spreadsheet development, maintenance and usage available in the world, and provide a comprehensive framework for:

    Download the Best Practice Spreadsheet Modelling Standards

Download Free Download

View Online View Online

  • Developing any spreadsheet in accordance with best practice; and
  • Reducing the time and cost associated with spreadsheet development, maintenance and use.

The standards were originally developed by BPM and first publicly released in July 2003. Since then, they have rapidly gained general market acceptance and have been implemented by companies, investment banks, commercial banks, accounting firms, government bodies, advisors and stockbrokers all over the world.

The standards are now governed by the Spreadsheet Standards Review Board ('SSRB'), a body established to facilitate participation in the Standards by the business community, with the charter to assess submissions to modify standards, as well as maintain and develop the standards.

The standards can easily be implemented within any organisation using BPM's best practice modelling software, training courses or consulting services.

For more information in relation to the SSRB, visit http://www.ssrb.org.

Implementation

BPM has developed bpmToolbox to facilitate the ultra-efficient implementation of the Best Practice Spreadsheet Modelling Standards in Microsoft Excel® - i.e. to allow best practice spreadsheet models to be developed in less time than it would otherwise take to develop non-best practice spreadsheet models. bpmToolbox achieves this by providing a complete range of 'best practice' implementation tools, including:

  • Automated formats & styles;
  • Workbook & sheet structuring tools;
  • Comprehensive hyperlink navigation systems; and
  • Assumption entry interface development tools.

bpmToolbox also contains a range of tools designed to accelerate common modelling tasks, including formula development and model reviewing. Click here to learn more about implementing best practice with bpmToolbox.