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
Trusted Information Resource
#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 22
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 9100, Nadcap and related Aerospace 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
C SOP Template needed for ISO 13485 6.3 Infrastructure ISO 13485:2016 - Medical Device Quality Management Systems 5
Q Example of the Risk Template Document Control Systems, Procedures, Forms and Templates 1
dgrainger Informational MDCG 2020:13 - Clinical evaluation assessment report template EU Medical Device Regulations 0
Q Internal audit plan template Internal Auditing 5
D New Equipment form / template Document Control Systems, Procedures, Forms and Templates 5
M Supplier Audit Report - Template for second party audit wanted Lean in Manufacturing and Service Industries 1
D Design Transfer Template capturing Customer Specific Requirements Other Medical Device Related Standards 3
Anerol C Gage R&R Template AIAG 4th Edition IATF 16949 - Automotive Quality Systems Standard 3
J Looking for a EU MDR Gap Analysis template EU Medical Device Regulations 4
J Looking for a template SOP for UDI implementation for EU Medical Devices EU Medical Device Regulations 0
M Is there any pre-defined Control plan format/template acc. VDA? VDA Standards - Germany's Automotive Standards 0
W ISO 9001:2015 Management Review Input Template wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
M Informational EU – Manufacturer incident report (MIR) for serious incident- template 2020 (Directives and new regulations) version 7.2 and related documents Medical Device and FDA Regulations and Standards News 2
pashah Looking for Usability File Template acc. IEC 62366-1 and IEC 60601-1-6 IEC 62366 - Medical Device Usability Engineering 4
M PMS template for FDA submission (De novo submission for a Class II IVD) 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 8
M Template for Attribute Gage R & R wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Similar threads


















































Top Bottom