Validation of Spreadsheet Applications

Product Details

Includes detailed procedures on how to write requirement and design specifications.

• How to develop and document the code.
• Structural and functional testing.
• Installation and operational checks prior to routine use.
• Ongoing performance checks during routine use
• Change control
• Documents to be developed and how to archive the documents

Purpose:

• Quality standards, regulatory agencies and some company policies require software used for evaluation of critical data to be properly validated.
• Spreadsheet applications are considered as software and should be validated to demonstrate suitability for their intended use.
• The purpose of this operating procedure is to ensure that spreadsheet applications are validated during their development and periodically reevaluated during their development and installation and periodically reevaluated during operation.

Scope:

Validation of Spreadsheet applications used in regulated environments.Examples are Excel spreadsheets .The procedure applies whenever firm develop Spreadsheet applications with and without VBA scripts