Validation of an Excel Spreadsheet used for Recording Test Results

A

achorste

#1
Good afternoon all,

I was wondering if anyone would be able to help - we recently had an audit from one of our customers. One non-conformity they raised was we were using an unvalidated spreadsheet.

This spreadsheet is used for recording test results and report numbers, no calculations are involved, no macros are used, the only restrictions are based upon the user access to the folder in which the spreadsheet is kept.

What strategy would you use for "validating" the use of such a spreadsheet?

I was going down the lines of developing a combined User Requirements Spec / Functional Spec with the spreadsheet structure etc, but what sort of functional testing can I do with a simple spreadhseet like this?

Yours confusedly,

Achorste
 
Elsmar Forum Sponsor
J

Jimmy the Brit

#2
Re: Validation of an excel spreadsheet?

Coincidentally I received this link to an on-line seminar concerning this very subject this morning and I was thinking of attending to find out the same thing - How do you validate a simple non-calculating spreadsheet? I have no idea if the course is any good, but I have attended a couple of their sessions before and found them to be pretty good value.

If you don't get the answer you need from the Cove maybe it is worth the £249 fee, although the session is tomorrow so probably a bit late! NB I am in no way affiliated with Compliance Online.

Regards,

Jimmy
 

yodon

Leader
Super Moderator
#3
Re: Validation of an excel spreadsheet?

I think about all you can do is show that the user restrictions are properly implemented. You should probably also show how the data is immutable, once entered (or if you can't go that far, show rationale for whatever protections that are in place are sufficient).
 
S

Sturmkind

#4
Re: Validation of an excel spreadsheet used for recording test results?

Hi! Was the non-conformance concern about the integrity of the data entered? If so, the only way to increase the chance of catching an error such as transposition (entering numbers or data 'backwards') is to deploy multiple visual inspections and/or to institute a reasonable High and Low limit for the cell values. :cool:
 

bio_subbu

Super Moderator
#6
Re: Validation of an excel spreadsheet used for recording test results?

Complianceonline is going to conduct a live online training on “Validation and use of Excel spreadsheets in FDA regulated environments”. The training date is scheduled on August 11, Tuesday at 10:00 AM PDT. For more information refer here
 
J

jscholen

#7
Re: Validation of an excel spreadsheet used for recording test results?

I had an ex-FDA investigator tell me she didn't care about the use of a spreadsheet if it didn't perform any calculation, so in your case, I would concern my validation around access and audit trails if the data is a part of your quality records.
 

raghu_1968

Involved In Discussions
#9
Re: Validation of an excel spreadsheet used for recording test results?

Hi Achorste,

If the spread sheet is not involved in any calculation, then it can be considered as a document. And if it is involved in the any official trade, the security access is to be validated. We can test the following;

1) Configuration of the base system,
2) Data source
3) Security of the data and the user
4) Application software specification
5) Functionality of the application software

By testing these parameters, we can declare that the data and functionality has been validated.

Document Methodology:
1) URS preparation
2) Validation Plan
3) Validation test scripts
4) Reporting
5) Testing the URS compliance

Regards / Raghu

 
A

achorste

#10
Re: Validation of an excel spreadsheet used for recording test results?

Thank you all for your help, I'm putting a generic protocol for spreadsheet validation together now - I will try to remember to post it up if anyone's interested :D

Thanks again.
 
Thread starter Similar threads Forum Replies Date
A Excel Spreadsheet Validation - Customer Audit Finding Other US Medical Device Regulations 2
R Medical Device Inspection Sheets - Excel Spreadsheet Validation US Food and Drug Administration (FDA) 2
J Excel Spreadsheet Validation for Calculating Data coming from our Instruments (LIMS) General Measurement Device and Calibration Topics 3
C Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 6
M Medical Device Process validation, Validation of excel spreadsheets used for process Other Medical Device and Orthopedic Related Topics 4
L Validation through Cgk Excel .xls file needed Excel .xls Spreadsheet Templates and Tools 4
K ISO 17025 Method Validation and Verification for Test Lab ISO 17025 related Discussions 4
S Environment Monitoring System Validation ISO 14001:2015 Specific Discussions 1
B Supplier Evaluation report - Validation required or not ISO 13485:2016 - Medical Device Quality Management Systems 2
M Cleaning Validation of components Manufacturing and Related Processes 2
P Validation Methods of Machine learning and Artificial intelligence Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 10
M How to respond to 483 validation finding we disagree with? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 33
I Cryogenic Container Closure Integrity for HCT/P, Validation Method US Food and Drug Administration (FDA) 0
G Mfr. Process Validation BEFORE Design Transfer? Other Medical Device and Orthopedic Related Topics 1
G Injection Molded Parts in Verification & Validation Other Medical Device and Orthopedic Related Topics 3
B Spreadsheet - Used for complaint investigation - Validation required or not ISO 13485:2016 - Medical Device Quality Management Systems 9
T Vacuum Heat Treatment Validation Manufacturing and Related Processes 1
M Root Cause and Corrective Action for CAPA's lacking validation/verification ISO 13485:2016 - Medical Device Quality Management Systems 19
M Software Validation SAP B1 for ERP ISO 13485:2016 - Medical Device Quality Management Systems 2
V Retrospective validation medical devices Qualification and Validation (including 21 CFR Part 11) 7
P Software validation for FPGA Software Quality Assurance 1
I Are suppliers required to hand over process validation reports? ISO 13485:2016 - Medical Device Quality Management Systems 20
N Computerized System Validation ISO 13485:2016 - Medical Device Quality Management Systems 12
M 3D Scanner Software validation ISO 13485:2016 - Medical Device Quality Management Systems 7
E Cybersecurity for Internal Tool Validation Medical Device and FDA Regulations and Standards News 1
B Transport Validation For Non-sterile Medical Devices ISO 13485:2016 - Medical Device Quality Management Systems 4
D Software Validation Question ISO 13485:2016 - Medical Device Quality Management Systems 10
G Pad Printing Validation OR Verification ISO 13485:2016 - Medical Device Quality Management Systems 4
A ETHYLENE OXIDE STERILIZATION VALIDATION Manufacturing and Related Processes 4
C. Tejeda Computer system validation approach for Minitab Statistical software Software Quality Assurance 9
D 8.5.1.2 Validation and control of special processes requirements for Heat Treat External Processor AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
S Performance Qualification and Process Validation ISO 13485:2016 - Medical Device Quality Management Systems 5
L ISO 11607-1 Packaging system validation Design and Development of Products and Processes 9
John C. Abnet ...validation of computer software ISO 13485:2016 - Medical Device Quality Management Systems 17
D Machine rebuilds versus process re-validation IATF 16949 - Automotive Quality Systems Standard 1
R Cloud-based SaMD Validation IEC 62304 - Medical Device Software Life Cycle Processes 8
G Process Validation Before/After Sterilization? Design and Development of Products and Processes 3
D Laboratory Refrigerator Validation ISO 13485:2016 - Medical Device Quality Management Systems 2
T SQL Server 2019 - Master Data Services - Validation needed? ISO 13485:2016 - Medical Device Quality Management Systems 4
G Shipping Validation of Non-Sterile Parts? Other Medical Device and Orthopedic Related Topics 9
J Hardware Validation Qualification and Validation (including 21 CFR Part 11) 1
B ERP software validation - risk assessment vs validation scope ISO 13485:2016 - Medical Device Quality Management Systems 11
blackholequasar Validation of new ERP system ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
G How to Record Informal Testing (Not Verification/Validation) Other Medical Device and Orthopedic Related Topics 15
B Clean room shut down and re-validation or re-qualification? Other Medical Device Related Standards 6
B Vision system process validation Manufacturing and Related Processes 1
R Validation of Software used in Verification Testing ISO 13485:2016 - Medical Device Quality Management Systems 2
D Glassware cleaning validation Qualification and Validation (including 21 CFR Part 11) 3
M Do i need to have equipment validation if 100% testing is completed? Qualification and Validation (including 21 CFR Part 11) 6
R SaMD Verification & Validation IEC 62304 - Medical Device Software Life Cycle Processes 6

Similar threads

Top Bottom