Spreadsheet Validation and Release

contigo123

Involved In Discussions
#1
Hi All,

We are jumping in to spreadsheet validations and I have a question regarding when to perform it. So we build our spreadsheet, and then need to do a change order (CO) to release it into our doc control system (essentially, load it to a secure location for employees to access). We can't load it into the secure location until after the CO is complete.

So, would you perform your spreadsheet validation before starting the CO (to validate the spreadsheet is correct before uploading), or after the CO is complete and you have loaded the spreadsheet to the secure location (to also be able to test accessibility)? Or maybe some combination, where you validate the functions before the CO is complete, then do a "transfer" check after the CO?

Just curious how others are handling this.

Thank you!
 
Elsmar Forum Sponsor
#2
Option A
1. Preliminary validation check prior to CO.
2. CO approved but not released.
3. Perform validation.
4. Approve validation report.
5. Release CO to implement change.

Option B
1. Preliminary validation check prior to CO.
2. CO approved and released, but spreadsheet not implemented into any process.
3. Second CO that implements spreadsheet use with a process.

Option C
1. R&D level spreadsheet and process approved and released.
2. Validation performed on R&D level spreadsheet.
3. CO approved and released that transfers R&D level spreadsheet and process to production level.

See how in all of these, the software is validated prior to use in a production process.
 

contigo123

Involved In Discussions
#3
Option A
1. Preliminary validation check prior to CO.
2. CO approved but not released.
3. Perform validation.
4. Approve validation report.
5. Release CO to implement change.

Option B
1. Preliminary validation check prior to CO.
2. CO approved and released, but spreadsheet not implemented into any process.
3. Second CO that implements spreadsheet use with a process.

Option C
1. R&D level spreadsheet and process approved and released.
2. Validation performed on R&D level spreadsheet.
3. CO approved and released that transfers R&D level spreadsheet and process to production level.

See how in all of these, the software is validated prior to use in a production process.

That makes sense, thank you!
 
Thread starter Similar threads Forum Replies Date
B Spreadsheet - Used for complaint investigation - Validation required or not ISO 13485:2016 - Medical Device Quality Management Systems 9
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
A Validation of an Excel Spreadsheet used for Recording Test Results Qualification and Validation (including 21 CFR Part 11) 14
John Predmore Informational Can you find the error in the spreadsheet? Misc. Quality Assurance and Business Systems Related Topics 3
qualprod Sheets into a spreadsheet document control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
U Spreadsheet Context, interested parties ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
rob73 EU Medical Device Classification Spreadsheet EU Medical Device Regulations 4
S VDA 5 Variables Data GR&R Spreadsheet wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R Is there any Excel .xls Spreadsheet available for DOE with 3 factors? Six Sigma 1
kedarg6500 Excel spreadsheet for Unilateral Tolerance Study wanted Excel .xls Spreadsheet Templates and Tools 2
kedarg6500 Excel Spreadsheet for AIAG Example wanted Excel .xls Spreadsheet Templates and Tools 3
C Visual Presentation of Supplier Score - .xls Spreadsheet Excel .xls Spreadsheet Templates and Tools 1
A Tracking Calibration and Qualification in an MS Excel Spreadsheet Calibration and Metrology Software and Hardware 5
S Form and Form/Record Numbering in an Excel Spreadsheet Excel .xls Spreadsheet Templates and Tools 2
J Excel spreadsheet to use Basic and Mini MOST for Line Balancing Document Control Systems, Procedures, Forms and Templates 1
6 Spreadsheet for Health and Safety Reporting - Template Occupational Health & Safety Management Standards 6
B How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
D Is a separate spreadsheet required for the ASL (Approved Supplier List)? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
T Controlling an Excel Spreadsheet (Database) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
Ajit Basrur How do I create two different columns in Excel spreadsheet ? Excel .xls Spreadsheet Templates and Tools 5
L Auditing Tool (Excel spreadsheet) for VDA 6.3 to Audit a Service Provider VDA Standards - Germany's Automotive Standards 4
M Spreadsheet on How to Calculate SMT Capacity wanted Manufacturing and Related Processes 2
M Dimension Report Formula .xlsx Editable Spreadsheet Form Excel .xls Spreadsheet Templates and Tools 24
B Third Party Service Provider Risk Rating Spreadsheet Risk Management Principles and Generic Guidelines 1
K Taguchi School Assignment using an L8 Orthogonal spreadsheet tool Statistical Analysis Tools, Techniques and SPC 1
S Spreadsheet that will Calculate Audit Duration times based on IAF MD5 and MD11 Excel .xls Spreadsheet Templates and Tools 8
J Excel spreadsheet for Gage R&R study with 9 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
M Taguchi L4 Orthogonal Array Design of Experiments (DOE) in an Excel spreadsheet Excel .xls Spreadsheet Templates and Tools 3
R Creating a c-chart spreadsheet to use in my department Excel .xls Spreadsheet Templates and Tools 5
R XBar & R Chart Spreadsheet to apply a Control Process Statistical Analysis Tools, Techniques and SPC 1
A ECR & ECN - Looking for advice and Spreadsheet Example Document Control Systems, Procedures, Forms and Templates 1
F SPC Data Analysis - Excel Spreadsheet I can use for Diameters and Perpendicularity Capability, Accuracy and Stability - Processes, Machines, etc. 6
M Venture Capital Valuation Spreadsheet question Manufacturing and Related Processes 1
F SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 components Capability, Accuracy and Stability - Processes, Machines, etc. 8
V Excel Spreadsheet to Calculate Temperature Compensation of Gage Blocks wanted General Measurement Device and Calibration Topics 3
S Strange PT Ratio on an Excel spreadsheet for variable GRR ANOVA Method Excel .xls Spreadsheet Templates and Tools 2
V Calculation of PPM & Sigma Level in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
P Calculating Process Capability from Data of attached spreadsheet Statistical Analysis Tools, Techniques and SPC 4
A How to create a Multiple Operations Specifications Comparison Spreadsheet? Excel .xls Spreadsheet Templates and Tools 3
6 Maintenance Spreadsheet to Monitor the Maintenance Process of a Fleet wanted IATF 16949 - Automotive Quality Systems Standard 8
H Is my MSA Study Spreadsheet okay to AIAG MSA Manual 4th Edition? Using Minitab Software 18
automoto Excel (xlsx) spreadsheet for conducting Type 1 MSA Analysis. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 23
J ROI (Return on Investment) Excel Spreadsheet example Excel .xls Spreadsheet Templates and Tools 1
L OEM Customer Specific Requirements - Spreadsheet wanted Customer and Company Specific Requirements 14
P Measurement Uncertainty Calculations Spreadsheet help General Measurement Device and Calibration Topics 4

Similar threads

Top Bottom