Understanding why; how to write a superb Spreadsheet validator protocol - is often a difficult and neglected task that always attracts the attention of the regulators, simply because they are pretty certain that they will find problems in the use, or design, or in the actual spreadsheet validator and or qualification.
The standard operating system used throughout industry for spreadsheet applications is Excel. Excel is a well used and known system with millions of programs in use word-wide. As such, it does not require to be validated. However applications that run on Excel do require to be validated. Just like any other software program the degree and scope of spreadsheet validation or qualification depends entirely on the risk or possibility that the application can affect product quality, efficacy or records.
Regulators expect you to be able to demonstrate that your spreadsheets are functioning correctly and consistently produce accurate data. If you cannot show with documented test evidence that this is the case, then your regulators or auditors can stop you using your spreadsheets or worse still stop your operations until the situation is resolved.
Validation Online offer a complete suite of spreadsheet validation documents, from the Validation Plan (VP) to the User Requirements Specification (URS) Risk Assessment (VRA) and culminating in a combined Installation / Qualification / Performance Qualification (CSQ) protocol. These documents are newly and specifically designed not only to qualify your existing spreadsheets, but to ensure that all your future spreadsheet validation and qualification tasks are fully compliant.
The importance and criticality of spreadsheets and spreadsheet validation, to the pharmaceutical industry was recently reported on. The report indicated that the results of a survey of twenty three professionals in this multi billion pound industry revealed some extraordinary and at times worrisome problems.
The interviewees said that spreadsheets were pervasive, and many were key and product critical. Further to this, there is almost no spreadsheet validation software quality assurance and people who create or modify spreadsheets are almost entirely self-taught. Two; each disclosed a recent instance where material spreadsheet error had led to adverse effects involving many tens of millions of pounds.
In twenty years working within the regulatory compliance side of the drug and device industries, if I was asked to single out the single most abused process in use throughout these industries, I would have to nominate the design and use of spreadsheets. Why does something as simple as a spreadsheet figure in so many regulatory citations? Good question; and at times a difficult one to answer. When you ask a group of compliance personnel the same question you will be informed that Excel cannot be validated because it does not seal the original copy (of the spreadsheet), allows the original to be modified and has an audit trail that can be disabled. All true, but none of these problems interfere with your ability to validate that this spreadsheet validation is fit for purpose. They only preclude you from using the spread sheet as a compliant repository for any data that has to be stored in compliance with 21 CFR Part 11 . If the spreadsheet validation is signed off and dated by the user, their supervisor and QA, it becomes regulatory acceptable data stored in hard-copy, and Part 11 does not apply.
Having taken Part 11 out of the great debate; what remains. The same debaters might suggest that Excel will round up calculations, and has limitations as to its mathematical abilities. This also could be true. However it is very much up to the spreadsheet validation designer (and reviewer) to ensure that if number rounding is allowed; it does not meaningfully affect the accuracy of the spreadsheet calculations. how to write a superb Spreadsheet validation protocol Similarly the same persons must validate that the formula calculation is within the capabilities of the Excel software design.
SOP for Spreadsheet Creation. -- $125.00
Spreadsheet Validation Package. (Issue-1) -- $525.00
Spreadsheets and spreadsheet validators, are a potential source for the classical disaster. Companies run out of funding. Erroneous quality and efficacy statistics are produced and sometimes even stock levels are totally incorrect. On one audit, where the client stated they had four critical spreadsheets to be validated, their network was searched and 212 spreadsheets were found. One spreadsheet had 62 versions, all of which were active.
You must be ready for, and expect your regulator or auditor to review the quality, structure, scope, and or validation of your spreadsheets and review the following procedures and records for evidence of: