|
The following example best practice models have been provided by BPM to demonstrate the implementation of the Best Practice Spreadsheet Modeling Standards. Whilst most of the models are financial models (i.e. spreadsheets which project financial statements), the implemented spreadsheet best practices remain equally applicable to other types of spreadsheet models which contain assumptions and outputs. Comments have been included within the relevant sheets of each model which indicate the implementation of particular standards and conventions. Each of the example models can be downloaded by right clicking on the right-hand logo corresponding to your version of Microsoft Excel©. Alternatively, all of the below models can be downloaded in a single zipped folder by right clicking on the following hyperlink: |
|
||
|
Best_Practice_Examples_6_1.zip | ||
|
To better understand how these example models were created, undertake the practical learning exercises provided on the Modano website or watch the Modano video tutorials. |
|||
| Spreadsheet Modeling Area | Description | Download | ||
|---|---|---|---|---|
| General/Overview | • | Includes a worksheet entitled 'Standards Illustration Sheet' which provides commentary and hyperlink direction to areas within the workbook in which each of the Standards have been implemented. |  |  |
|
| 1. | General Concepts | • | Fundamental concepts including workbook, sheet and cell purpose and content. | | |
| 2. | Workbook Structure | • | Workbook structure, sections, table of contents and navigation. | | |
| 3. | Sheet Structure | • | Sheet types, structure, consistency, titles and content. | | |
| 4. | Formats & Styles | • | Format and style purpose, consistency, identification, explanation and appearance. | | |
| 5. | Assumption Entry Interfaces | • | Assumption entry interface structure, rules, consistency, location and formats. | | |
| 6. | Sensitivity Analysis | • | Sensitivity analysis structure, location, rules and identification. | |
| - Example Model 1 - Single-output sensitivity analysis. | | |
|||
| - Example Model 2 - Dual-output sensitivity analysis. | | |
|||
| 7. | Outputs & Presentations | • | Output links, rules, separation and sections. | | |
| 8. | Calculation Formulae | • | Calculation formulae consistency, rules, diagrams and complexities. | | |
9. | Naming Principles | • | Workbook, sheet and range naming consistency, identification, rules and application. | | |
| 10. | Time Series Analysis | • | Time series analysis, assumptions, consistency, structure, periodicity, rules and output. | |
| - Example Model 1 - Projections-only time series analysis. | | |
|||
| - Example Model 2 - Historical & forecast time series analysis. | | |
|||
| 11. | Checks | • | Error checks, Sensitivity checks and Alert checks structure, rules, location, formats and identification. | | |
12. | Printing & Viewing | • | Printing and viewing consistency, rules, margins, page numbers and information. | | |
| 13. | Multiple Workbooks | • | Multiple workbook links, structure, location, rules and diagrams. | |
| - Example Model 1 - Model export example (download with model import example below). | | |
|||
| - Example Model 2 - Model import example (download with model export example above). | | |
|||
| 14. | Security & Protection | • | Workbook, sheet and cell protection and control. | | |
| 15. | Visual Basic Programming | • | The use of Visual Basic programming in spreadsheet models. | | |
| 16. | Miscellaneous | • | Various other areas. | | |