Template for Excel Validation

Carol2015

Involved In Discussions
#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

Leader
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
Leader
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
Q Three year audit program template excel Internal Auditing 1
T Control Excel template Document Control Systems, Procedures, Forms and Templates 5
bryan willemot Looking for NADCAP audit Excel spreadsheets template for vendors, specifically heat treat (Vacuum Furnace) AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 10
A Kanban Excel template Lean in Manufacturing and Service Industries 1
J Level 3 KPI Excel Template Manufacturing and Related Processes 0
bobdoering Informational New AIAG PFMEA Process - Excel Template Attached FMEA and Control Plans 28
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 9
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
C EN 61010 Template Recommendations CE Marking (Conformité Européene) / CB Scheme 1
Q Combining Validation Protocol & Report into 1 template Document Control Systems, Procedures, Forms and Templates 4
B A template for a injection molding process sheet with upper/lower- mean value tolerances Manufacturing and Related Processes 0
C Document Record/Template Minimum Requirements ISO 13485:2016 - Medical Device Quality Management Systems 3
M Signature Authority Matrix Template Document Control Systems, Procedures, Forms and Templates 7
L Looking for SOP Template for UDI under MDR EU Medical Device Regulations 4
F EU MDR Quality Plan template CE Marking (Conformité Européene) / CB Scheme 3
G Similarities between format of technical file for CE and ASEAN common submission dossier template (CSDT) CE Marking (Conformité Européene) / CB Scheme 2
Steve Prevette I need a template to solve world hunger, a world class Quality Program, and make lots of money Coffee Break and Water Cooler Discussions 5
D Guidance for Medical records software/template ISO 13485:2016 - Medical Device Quality Management Systems 1
H Any template available to use for SQP? Oil and Gas Industry Standards and Regulations 0
C Mock recall template/procedure ISO 13485:2016 - Medical Device Quality Management Systems 1

Similar threads

Top Bottom