Validating MS Excel Spreadsheets

Overview

The FDA and other regulatory bodies require spreadsheets to be validated and compliant with 21 CFR 11. During compliance audits, the FDA has recently focused more attention on the use of spreadsheets. (View sample warning letters relating to spreadsheets.) Ofni Systems, a leader in spreadsheet validation, can ensure that your spreadsheets are compliant with all regulatory requirements.

Spreadsheet Validation Methodology

Step 1: Gather Requirements. Document the spreadsheet Functional Requirements. Functional requirements describe what the spreadsheet must be able to do. This includes:

Step 2: Document design requirements. Design Requirements describe how the spreadsheet accomplishes the functional requirements. Ofni Systems uses proprietary tools to analyze spreadsheets to create comprehensive design specifications. Design specifications include:

Step 3: Develop and Execute Test Plans. Test plans are developed to demonstrate that all required spreadsheet functionality is met and the spreadsheet is properly secured.

Ofni Systems uses FastVal to perform spreadsheet validations, which allows us to complete validation projects in 70% less time than traditional validation methods.

Excel compliance with 21 CFR 11

A key validation requirement is compliance with 21 CFR Part 11. We use ExcelSafe, which provides MS Excel with audit trails, limited system access, password controls, and other technological tools.

Special Trial Validation Offer

Ofni Systems will perform a free spreadsheet validation of one of your spreadsheets for qualified purchasers to demonstrate our validation method.

Contact us for more information.