How do I validate spreadsheets?.
ABB Engineering Services investigated the available options and developed an efficient and effective method to validate spreadsheets. To find out more see the Overview presentation, available for viewing or download from here.
The ABB approach to validating spreadsheets
Spreadsheet Validation essentially breaks into two separate projects.
- Validation of your individual spreadsheets.
Validation of your individual spreadsheets
The validation approach involves the following key stages.
- Understand the issues with spreadsheet validation and your spreadsheet inventory
- Choosing an approach that allows efficient validation
- Project planning and resourcing
- Spreadsheet specifications
- Spreadsheet qualification
- Maintaining compliance
Click here for an overview of the ABB Spreadsheet Validation Training Course. This course offers you the whole process, including the generic document sets in MS Word format. It provides everything you need to know in a 2 day course, and can be delivered at your site and tailored to your spreadsheets. See here for a detailed breakdown of the course content.
