SBS - The best value in QMS software

Template for Excel Validation

Carol2015

Starting to get Involved
#1
Hi

Does anyone here have a standard template to use to validate Excel as OTS? Also, how do I create a template to validate Excel using specific formulas in a technical protocol?
 
Elsmar Forum Sponsor

Jen

Starting to get Involved
#2
We don't have a standard template. I only validated those formulae or functions that we used. For example, we use plus formula routinely in our process. I will use at least three test cases such as 1+1, 1+123, 22+67 to make sure the plus formula in excel is able to churn out the correct answers. I usually use another device such as a calculator to verify the answer.
 

yodon

Staff member
Super Moderator
#3
In addition to what @Jen posted, there are likely other considerations. (The depth of validation should be risk based, of course.) The main thing with spreadsheets is data integrity. Consider range checking and data validation for each value entered. Precision of the calculation may also be important. Are you locking down everything except where there is data entry? What controls are in place to ensure the data isn't changed after the original entry? Even taking a step further back, is the spreadsheet itself being controlled (could someone unknowingly change the formulae)?
 

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#5
Also, how do I create a template to validate Excel using specific formulas in a technical protocol?

Generally speaking, one usually builds several test cases reflective of the work they are doing that they need validated. The test case is calculated using an independent means, generally a person with a calculator, and then run the same problem through your Excel spreadsheet and see if you get the same answer. Screen shots help record the result for posterity.
 

Ninja

Looking for Reality
Staff member
Super Moderator
#6
We always validated our XL tools using a calculator and paper...9th grade algebra test with "show your work" required.
Then we put that paper(s) on file as validation.

Standing rule on the floor was "if you drag and drop anything, ever, you get {what we called} a green card"
The green card was not a nice thing that I won't post here...it was a very visible way for any operator on the line to call out someone acting stupidly, with perhaps dangerous outcomes.
 
Thread starter Similar threads Forum Replies Date
J Level 3 KPI Excel Template Manufacturing and Related Processes 1
bobdoering Informational New AIAG PFMEA Process - Excel Template Attached FMEA and Control Plans 23
P Template or example Excel list of ISO certificates issued to clients ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
N Where I can find an Excel sample/template for recording Delivery Time and Cost Excel .xls Spreadsheet Templates and Tools 2
1 KPI Dashboard Template in Excel Format wanted Excel .xls Spreadsheet Templates and Tools 9
L Excel Template for Cgk Study wanted (Capability Gauges Study) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
B Looking for a Y-Shaped / 3-way Matrix Template (Excel or Visio) Quality Assurance and Compliance Software Tools and Solutions 7
P "House of Quality" Excel template wanted Document Control Systems, Procedures, Forms and Templates 6
C GR&R MSA-4 ANOVA Excel Template Verification Check wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
C Excel Dashboard form or template wanted Manufacturing and Related Processes 4
N Looking For Excel Template for Tracking & Trending Rejections Quality Tools, Improvement and Analysis 7
D Excel .xls Template for Document Control Master Register Document Control Systems, Procedures, Forms and Templates 1
K Excel Spreadsheet Template to calculate Cmk (Machine Capability) wanted Capability, Accuracy and Stability - Processes, Machines, etc. 2
1 Defect Tracking Excel Spreadsheet Template Excel .xls Spreadsheet Templates and Tools 2
W Type 1 Gauge (Gage) R&R Excel Template anyone? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 21
A Supplier Lead Time and Cost - excel template wanted Document Control Systems, Procedures, Forms and Templates 2
R AS9016 - Notice of Change template in either Word or Excel AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
D Excel Project Gantt Chart Template - Data dissapears at certain timeline Excel .xls Spreadsheet Templates and Tools 15
D Template in excel (xls) on Attrition for daily manpower reporting Excel .xls Spreadsheet Templates and Tools 1
R Supplier Quality Rating Scorecard Template (excel spreadsheet) Supplier Quality Assurance and other Supplier Issues 4
J ISO 9001 Audit Checklist Excel .xls Template Excel .xls Spreadsheet Templates and Tools 15
A Alternative Selection Excel .xls Template - ISO 9001 and CMMI (DAR Process Area) Excel .xls Spreadsheet Templates and Tools 1
G Need template for Non Conforming Report to Supplier (Excel/MS Access format) Supplier Quality Assurance and other Supplier Issues 2
J Type 1 Gage Study Excel Template Excel .xls Spreadsheet Templates and Tools 5
M MS Excel Applications Template Excel .xls Spreadsheet Templates and Tools 3
M Excel .xls Template for Attribute Gage R&R with ORDINAL Data needed Excel .xls Spreadsheet Templates and Tools 10
J 5 Whys Template - Excel .xls Spreadsheet IATF 16949 - Automotive Quality Systems Standard 10
B Does anyone have a standard VDA 6.3 excel .xls template / form? Excel .xls Spreadsheet Templates and Tools 8
A Action Plans Template - Anyone have a good template for an action plan in excel .xls? Excel .xls Spreadsheet Templates and Tools 1
W Ford Dynamic Control Plan (DCP) template in Excel .xls Excel .xls Spreadsheet Templates and Tools 14
R X bar s chart template / form for Excel .xls Excel .xls Spreadsheet Templates and Tools 2
T Gage R&R Excel .xls form and SPC Xbar and R template (lost it.. ) Excel .xls Spreadsheet Templates and Tools 13
M Where to find an acceptance sampling excel macro or .xls template? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 6
A CMM Uncertainty Level analysis - Seeking EXCEL .xls template or worksheet Excel .xls Spreadsheet Templates and Tools 2
bryan willemot Looking for an Approved vendors list template Document Control Systems, Procedures, Forms and Templates 11
S ISO9001:2015 Implementation / update plan template ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
H SOP Template for seeking regulatory clearance - MDSAP Document Control Systems, Procedures, Forms and Templates 6
M Data Protection and Privacy Policy - looking for a template/example EU Medical Device Regulations 1
H Need MSA 4th ed. compliant attribute MSA template General Measurement Device and Calibration Topics 4
G Where to buy Template / sample SCSMS Manual, checklist Supply Chain Security Management Systems 1
J Need Change Control Yes/No Decision Tree Template ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
Z Rapid audit template for plastic parts manufacturing process Manufacturing and Related Processes 12
CharlieUK Informational ADCO MED EU DECLARATION OF CONFORMITY TEMPLATE CE Marking (Conformité Européene) / CB Scheme 0
Tagin Template or Checklist for Process Change Document Control Systems, Procedures, Forms and Templates 5
J Process FMEA Template with examples - Cold and Hot Forged components FMEA and Control Plans 4
F MDR GSPR Checklist template EU Medical Device Regulations 7
M Email Template that go to a customer and then get returned to us for RMA/Warranty Document Control Systems, Procedures, Forms and Templates 1
C Ford's MMOG/le Template wanted Manufacturing and Related Processes 0
C SOP Template needed for ISO 13485 6.3 Infrastructure ISO 13485:2016 - Medical Device Quality Management Systems 9
Q Example of the Risk Template Document Control Systems, Procedures, Forms and Templates 1

Similar threads

Top Bottom