SBS - The best value in QMS software

Validation of an Excel Spreadsheet used for Recording Test Results

Elsmar Forum Sponsor
Z

zancky

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

I have only some experience with excel and one of the problem I have seen about non calculating sheet is the input format
if You insert special characher like ^ @ or something that looks like a date and press enter the cell is formatted. You can go back and edit the results but it may happen You have not corrected the format. The worst case is: if You enter @+something, then You You go back to the cell and overwrite a number, You will see the number but for excel is a string!
I have seen an excel spreadsheet at one of my customer (pharmaceutical) and it was protected against any special characheter, invalid date format (only DD/MM/AAAA was allowed), invalid entry (if is required a number only a number can be written) etc.
 
G

gar4guv

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

achorste said:
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?
Click to expand...
one way we get around validation of non-calculating spreadsheets (or word docs, or pdfs for that matter) is to print out the file and sign it. then we can argue that 100% verification is being performed.
 
A

achorste

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

zancky said:
I have remembered that someone once addressed me to http://www.npl.co.uk
Under http://resource.npl.co.uk/docs/science_technology/scientific_computing/ssfm/documents/ssfmbpg7.pdf You can find some useful informations
Click to expand...
Nice find - that's going straight in my reference docs folder!

Am I the only sad one here who has a folder on his PC crammed with virtually every guidance doc / open standard / sample doc etc he comes across? It's all useful at some point :D
 
You must log in or register to reply here.
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
mustomutlu Process Validation Final Report Other Medical Device and Orthopedic Related Topics 2
P Software verification and validation procedure IEC 62304 - Medical Device Software Life Cycle Processes 4
Y SaMD Verification and Validation SOP and Plan IEC 62304 - Medical Device Software Life Cycle Processes 3
C Spreadsheet Validation and Release Qualification and Validation (including 21 CFR Part 11) 2
M Packing Validation & Accelerated Aging Test ISO 13485:2016 - Medical Device Quality Management Systems 2
M Sterile packing validation tests to be performed and protocol Other Medical Device and Orthopedic Related Topics 1
S OEM full range calibrations vs Validation special test points Medical Device and FDA Regulations and Standards News 0
H Software Validation for FFS Packaging Machine Qualification and Validation (including 21 CFR Part 11) 1
Q ISO 13485 7.5.6 Validation - Off the shelf Software ISO 13485:2016 - Medical Device Quality Management Systems 3
M ERP / QMS related software standards for Validation IEC 62304 - Medical Device Software Life Cycle Processes 6
C ISO 19227 Validation Cost Other Medical Device Related Standards 2
A CNC Mill and Lathe - Validation Manufacturing and Related Processes 2
N Example for design and development planning,input,output,review,verification,validation and transfer Misc. Quality Assurance and Business Systems Related Topics 4
N Sterilization Protocol Change in Validation Process and further impacts ISO 13485:2016 - Medical Device Quality Management Systems 1
B Oracle Cloud ERP Validation during Quarterly Patch ISO 13485:2016 - Medical Device Quality Management Systems 1
D Software validation team Misc. Quality Assurance and Business Systems Related Topics 3
W LTPD, AQL, Ppk and Cpk validation sampling plan table Inspection, Prints (Drawings), Testing, Sampling and Related Topics 0
J Validation Sample Size for Tray Seal Qualification and Validation (including 21 CFR Part 11) 3
F AS9100 - Validation, FAIR's, ITAR and Sub-Contracting AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
R PCBA process validation Qualification and Validation (including 21 CFR Part 11) 2
A ISO 17025 - Methods validation and clients ISO 17025 related Discussions 3
S Sterilization validation after changing sterilization process provider Qualification and Validation (including 21 CFR Part 11) 3
B Sterilization Validation Plan Other Medical Device Related Standards 3
D Difference between Test Method Validation and Gage R&R Qualification and Validation (including 21 CFR Part 11) 18
T Laboratory Verification after validation ISO 17025 related Discussions 3
silentmonkey Rationalising the level of effort and depth of software validation based on risk ISO 13485:2016 - Medical Device Quality Management Systems 10
D Questions regarding process validation ISO 13485:2016 - Medical Device Quality Management Systems 6
Y We found out we have been using a equipment without validation for past 4 years Quality Manager and Management Related Issues 6
Z Is IQ necessary for laser marking validation? EU Medical Device Regulations 3
E 13485:2016, Sections 4.1.6, 7.5.6 and 7.6 - Validation of Software - Need some Advice please ISO 13485:2016 - Medical Device Quality Management Systems 3
A Validation of Forced Aeration Process ISO 13485:2016 - Medical Device Quality Management Systems 3
E Mentor for Test Method Validation (TMV) Design and Development of Products and Processes 2
M API 4F/7K/8C Design Package Validation Oil and Gas Industry Standards and Regulations 2
I ISO 2233:2000 Question - Medical Device Shipping/Transportation Validation Other ISO and International Standards and European Regulations 1
T Annual Validation as a detection mode on a PFMEA? FMEA and Control Plans 5
B TMV - Selection of TM's for Validation ISO 13485:2016 - Medical Device Quality Management Systems 5
S Forced ServiceNow validation - No change in our current user and functional requirements IT (Information Technology) Service Management 4
P Human Factors / Usability validation in the time of COVID Human Factors and Ergonomics in Engineering 17
M IT validation for a paper based MD repair company QMS ISO 13485:2016 - Medical Device Quality Management Systems 6
P Unrealistic Packaging Validation Sample Size 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 41
D Test summary report example for design validation wanted - ISO 13485 ISO 13485:2016 - Medical Device Quality Management Systems 1
M Is Validation of Plating Processes required and who is responsible? Qualification and Validation (including 21 CFR Part 11) 11
T ISO 13485 - Process validation at critical suppliers ISO 13485:2016 - Medical Device Quality Management Systems 7
K Software Validation for Measurement Tools used in Process Validation ISO 13485:2016 - Medical Device Quality Management Systems 2

Similar threads

Top Bottom