Excel based Gage R&R VS Minitab calculation

It Was I Who

SQA Supplier Quality Assurance Manager
#1
Hi
I have a problem :-( I have sent an Excel based Gage R&R to one of my suppliers and when i received it back it shows different numbers then in my Minitab program.

This is what i get from the Excel file ( That i found here and found be very good and usefull) but from the minitabe file i get a different "Total"
Excel file shows 40,6% and the Minitab file shows 30,81%

This makes me frustrating 1638201573577.png This is the calculation in the excel file.

Pleae help out i will not be able to sleep when it is like this :p


1638201398347.png

Minitab file
1638201476627.png

Br Tommy
 
Elsmar Forum Sponsor

Miner

Forum Moderator
Leader
Admin
#4
The Excel file is showing ndc, not the total R&R. Change the formatting in cells N31 and N40 from Percentage to Number to show the correct ndc. You will have to add a cell and calculation to obtain the total R&R.
 

It Was I Who

SQA Supplier Quality Assurance Manager
#5
The Excel file is showing ndc, not the total R&R. Change the formatting in cells N31 and N40 from Percentage to Number to show the correct ndc. You will have to add a cell and calculation to obtain the total R&R.
So how will add the cell and do which calculation so it end up with the result of 30,81% ?
 
Thread starter Similar threads Forum Replies Date
M IQRM Software - Transitioning from Excel based FMEA's FMEA and Control Plans 3
K How do I autofill cell color based on other cells' color in Excel? Excel .xls Spreadsheet Templates and Tools 11
I AQL Formula in Excel - Calculating Sample Size based on an AQL Chart AQL - Acceptable Quality Level 8
S Need help to test my excel worksheet based on ISO 3951 Excel .xls Spreadsheet Templates and Tools 1
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
Ashland78 Need IATF 16949 ISO Gap Analysis Excel File Internal Auditing 3
M List of FAA Part 145 Repair Stations in MS Excel format? Federal Aviation Administration (FAA) Standards and Requirements 0
V Csv, excel format - audit trail file of HPLC system ( Empower, openlab, EZchrom or any other ) Qualification and Validation (including 21 CFR Part 11) 0
J Incoming Inspection Records using Excel File ISO 13485:2016 - Medical Device Quality Management Systems 2
S 95% UCL - Attaching an excel for recovery study Statistical Analysis Tools, Techniques and SPC 0
T EXCEL - How do I make the cell stay blank until a date is entered in N7? Excel .xls Spreadsheet Templates and Tools 6
Ed Panek Validating Excel (XLS) formulas 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 7
C Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 6
R Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S Issuing of CoC to Customer in a Word or Excel format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Ajit Basrur Track audit findings on Excel tracker Excel .xls Spreadsheet Templates and Tools 10
J Does anyone have an excel IATF 16949 Internal Audit checklist I could use? IATF 16949 - Automotive Quality Systems Standard 7
S Anyone Familiar with "SPC for Excel" add-in? Lean in Manufacturing and Service Industries 4
P Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
I Cannot Export multiple sections from Excel to PDF without losing pagination Excel .xls Spreadsheet Templates and Tools 23
M Matching two matrices in Excel Excel .xls Spreadsheet Templates and Tools 5
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
GreatNate Excel PPAP Tracking templates or tool wanted APQP and PPAP 1
E Part 11 Compliance, Excel living documents (i.e. document master list, equipment list, approved supplier list) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
J ISO 9001:2015 Excel Gap Analysis wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
B AS9110 Audit Check Sheet wanted Excel or Word Document AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
G Excel report with pictures Excel .xls Spreadsheet Templates and Tools 5
A Query regarding MS Excel usage Excel .xls Spreadsheet Templates and Tools 2
A Excel OOT (Out of Tolerance) Formula Excel .xls Spreadsheet Templates and Tools 3
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
Y Excel Automation - Printing Word Documents from within Excel Excel .xls Spreadsheet Templates and Tools 0
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
P Template or example Excel list of ISO certificates issued to clients ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
M Medical Device Process validation, Validation of excel spreadsheets used for process Other Medical Device and Orthopedic Related Topics 4
C Excel date format from Denmark to USA Excel .xls Spreadsheet Templates and Tools 6
G ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
N Where I can find an Excel sample/template for recording Delivery Time and Cost Excel .xls Spreadsheet Templates and Tools 2
D How do I go about creating document logs and registers with the MS Excel Excel .xls Spreadsheet Templates and Tools 2
D Microsoft Excel database to Stand-alone software Calibration and Metrology Software and Hardware 3
Q Controlling Multi-Tab Microsoft Excel Forms Excel .xls Spreadsheet Templates and Tools 5
B Zeiss CMM Calypso output to Excel or CSV file Help Inspection, Prints (Drawings), Testing, Sampling and Related Topics 17
S used excel formula calculated the ARL's with Rule1&Rule2 for Shewhart control chart Statistical Analysis Tools, Techniques and SPC 0
N Gantt Chart / Time Tracker in Excel - Combining Tasks on the Same Line Excel .xls Spreadsheet Templates and Tools 2
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
1 KPI Dashboard Template in Excel Format wanted Excel .xls Spreadsheet Templates and Tools 9
Ajit Basrur MS Excel to study Correlation between Humidity & Differential Pressure Excel .xls Spreadsheet Templates and Tools 7

Similar threads

Top Bottom