# Excel (xlsx) spreadsheet for conducting Type 1 MSA Analysis.

#### automoto

##### Involved In Discussions
Hello,

I prepare excel file for conducting Type 1 MSA analysis.

Enjoy....

#### Attachments

• 183.9 KB Views: 5,650

#### Rameshwar25

##### Quite Involved in Discussions
Re: Type 1 MSA

Mr Automoto
Can you please tell us the page # of MSA fourth manual which depicts formula given in your sheet. You have given reference of 4th manual.

Regards
Rameshwar

#### automoto

##### Involved In Discussions
Re: Type 1 MSA

You will found formulas for calculating in ANFIA (Associazione Nazionale Fra Industrie Automobilistiche) MSA Manual or in MINTAB.
However, it is strange that this method is not included in AIAG Manual. In my opinion it is useful tool to asses inherent variation of the gage. Type 1 study is first step in a complete MSA. Also a lot of customers require it….

Regards

S

#### supreecha

Re: Type 1 MSA

Cgk = K/200* Tolerance – [ Xg (Bar) – Xm ]
L * s

where K is a percentage of the tolerance (20 is typical),

X is the mean of all measurements,
s is the standard deviation of the measurements,
L is the number of standard deviations you want to represent half the process spread (3 is typical) .​

I need to know :How to use Shainin ISOPlot(sm) Type I gauge test is Minitab Release 16 ?​

Last edited by a moderator:
B

#### Barbara B

Hello,

I prepare excel file for conducting Type 1 MSA analysis.

Enjoy....
These formulas are also used in VDA 5.2 ("Prüfprozesseignung", actually only available in German but I suppose they will translate the 2nd edition eventually).

B

#### Barbara B

Re: Type 1 MSA

I need to know :How to use Shainin ISOPlot(sm) Type I gauge test is Minitab Release 16 ?
AFAIK Shainins Isoplot couldn't be made directly from the menus in Minitab R16, but maybe the (more common) method of a type I study (incl. a plot and bias test) is an alternative?

Stat > Quality Tools > Gage Study > Type 1 Gage Study

#### Rameshwar25

##### Quite Involved in Discussions
Can someone define what is Type 1 and what is Type 2 study please?

B

#### Barbara B

Type 1:
1 part with known reference value
take 25-50 repeated measurements
calculate bias and capability of measurement Cg, Cgk (g: gage)

Type 2:
Gage R&R, MSA crossed
5-10 parts, 2-3 operators, 2-3 repeated measurements for each part & operator combination
assign variation to part (part variation, PV), operator (appraiser variation, AV) and equipment (equipment variation, EV) to total variation, calculate GRR% based on the GRR= SQRT(EV²+AV²) and a reference value (6*study variation, 6*process variation or tolerance width):
GRR% = GRR / (reference value)

Hope this helps

Barbara

#### automoto

##### Involved In Discussions
Can someone define what is Type 1 and what is Type 2 study please?

Regards

Last edited by a moderator:
S

#### supreecha

Type 1:
1 part with known reference value
take 25-50 repeated measurements
calculate bias and capability of measurement Cg, Cgk (g: gage)

Type 2:
Gage R&R, MSA crossed
5-10 parts, 2-3 operators, 2-3 repeated measurements for each part & operator combination
assign variation to part (part variation, PV), operator (appraiser variation, AV) and equipment (equipment variation, EV) to total variation, calculate GRR% based on the GRR= SQRT(EV²+AV²) and a reference value (6*study variation, 6*process variation or tolerance width):
GRR% = GRR / (reference value)

Hope this helps

Barbara
Regression原點45 ๐Sam[leXY144.00.354150.2896197.8100.4151.3-2.61630.76335298.2113.8150.6-4.950395.4107.7147.1-4.1724109103.4157.0-6.9305108.9101.3152.9-0.2836115.7104.6154.00.2837111.2109.5152.17.5668108106.8159.5-15.9819112.4106.8153.9-2.26310116.7109.5165.14.66711110.9114.5158.64.80812113108.9163.32.75813112113.3172.2-1.76814118.6118.7162.71.48515121.1112.6160.0-0.07116112.6107170.9-3.96017116.7116.3167.7-7.99018116.4121.2168.2-5.02019114.7125.9167.86.15220128.9116.8174.29.89921115.8116.3174.1-1.13122127.5121.7174.6-4.73823130.9126.6184.74.59624126.8129.8183.5-3.25325122.4131.3178.7-6.29326123.3125.4179.36.64727121.3126.3186.4-5.72828123.4133.8182.3-6.36429130126.8180.81.62630119.3128.9

What does it mean at blue alphabet ? ( 150.2896 ,30.76335 ) after i used menu :
Calc > Matrices > Eigen Analysis
Calculates eigenvalues (also called characteristic values or latent roots) and eigenvectors for a symmetric matrix.

Kanban Excel template Lean in Manufacturing and Service Industries 1
Excel based Gage R&R VS Minitab calculation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
Need IATF 16949 ISO Gap Analysis Excel File Internal Auditing 3
List of FAA Part 145 Repair Stations in MS Excel format? Federal Aviation Administration (FAA) Standards and Requirements 0
Csv, excel format - audit trail file of HPLC system ( Empower, openlab, EZchrom or any other ) Qualification and Validation (including 21 CFR Part 11) 0
Incoming Inspection Records using Excel File ISO 13485:2016 - Medical Device Quality Management Systems 2
95% UCL - Attaching an excel for recovery study Statistical Analysis Tools, Techniques and SPC 0
EXCEL - How do I make the cell stay blank until a date is entered in N7? Excel .xls Spreadsheet Templates and Tools 6
Validating Excel (XLS) formulas 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 7
Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 6
Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Issuing of CoC to Customer in a Word or Excel format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Track audit findings on Excel tracker Excel .xls Spreadsheet Templates and Tools 10
Does anyone have an excel IATF 16949 Internal Audit checklist I could use? IATF 16949 - Automotive Quality Systems Standard 7
Anyone Familiar with "SPC for Excel" add-in? Lean in Manufacturing and Service Industries 4
Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
Cannot Export multiple sections from Excel to PDF without losing pagination Excel .xls Spreadsheet Templates and Tools 23
Matching two matrices in Excel Excel .xls Spreadsheet Templates and Tools 5
Level 3 KPI Excel Template Manufacturing and Related Processes 1
Informational New AIAG PFMEA Process - Excel Template Attached FMEA and Control Plans 28
Excel PPAP Tracking templates or tool wanted APQP and PPAP 1
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
ISO 9001:2015 Excel Gap Analysis wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
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
Query regarding MS Excel usage Excel .xls Spreadsheet Templates and Tools 2
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
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
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
MS Excel to study Correlation between Humidity & Differential Pressure Excel .xls Spreadsheet Templates and Tools 7
D Gage Calibration Tracking in MS Excel Calibration and Metrology Software and Hardware 9
Where can I get a PPAP workbook in Excel .xls with links? APQP and PPAP 1
L Excel Template for Cgk Study wanted (Capability Gauges Study) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
V Looking for advice on Pooled Standard Deviation between Minitab and MS Excel Statistical Analysis Tools, Techniques and SPC 1
P Recommendations on SPC Software or Excel SPC add-in(s) Quality Assurance and Compliance Software Tools and Solutions 6
Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3