SBS - The best value in QMS software

Strange PT Ratio on an Excel spreadsheet for variable GRR ANOVA Method

S

stefano.larghi

#1
Hi to everybody.

I've got from a customer an Excel spreadsheet for variable GRR ANOVA Method.

It shows, between many known indexes, a value quite strange: that is in "gage results" it compares:
sigmaRR vs design tolerances (named IT) / 27.

Clearly it belongs (it seems to me) to a P/T ratio family, but I can't understand the factor 27.

Would it be :
a) 6*sigmaRR vs IT/4.5
b) 4,5 *sigmaRR vs IT/6

but why are using different sigma spread coefficients (6 and 4,5)?
Usually P/T = 6*sigmaRR / IT
Does anybody managed it?
thanks
 
Elsmar Forum Sponsor
N

NumberCruncher

#2
Hi Stefano

Try asking your customer. Someone put it in, presumably they had a reason.

NC
 
S

stefano.larghi

#3
Thanks NC! I thought so but before I wanted to check any missing concept in my reasoning (about indexes or acceptability criteria).
bye
 
Thread starter Similar threads Forum Replies Date
Marc The Strange & Curious Tale of the Last True Hermit Coffee Break and Water Cooler Discussions 0
P Strange Gage R&R results for a Caliper (Tolerance Method) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
AnaMariaVR2 Mars-Inspired Art, Commissioned by NASA, Births Strange Sci-Fi Photos Coffee Break and Water Cooler Discussions 1
Claes Gefvenberg Those strange forum dwellers... Coffee Break and Water Cooler Discussions 2
C Strange test result form - CFG-1003 form Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
Ajit Basrur Strange "Manufactured in China with US and China Materials" Coffee Break and Water Cooler Discussions 12
Marc Five Strange Materials including Liquids you can Walk on Coffee Break and Water Cooler Discussions 3
Wes Bucey GM/Renault/Nissan? Strange bedfellows? World News 4
L Strange facts about states Coffee Break and Water Cooler Discussions 26
L Strange letter from Underwriters Laboratories (UL) Promising Change Misc. Quality Assurance and Business Systems Related Topics 10
Ron Rompen Surface Finish Correlation between Ra, Rz and Tp (bearing surface ratio) General Measurement Device and Calibration Topics 3
Z Is Op Amp Common-Mode Rejection Ratio (CMRR) test applicable to battery operated devices? Other Medical Device Related Standards 0
R The term "Benefit Risk Ratio" in EU MDR, do I need to present benefit risk analysis as a RATIO Risk Management Principles and Generic Guidelines 4
F What to do when you don't meet the 1:10 ratio Measurement Uncertainty (MU) 3
J Question on very low NDC number with tolerable GRR ratio's Capability, Accuracy and Stability - Processes, Machines, etc. 7
V Clarification of Injection part shrinkage ratio Manufacturing and Related Processes 1
L Signal-to-Noise (S/N) Ratio formula check Design and Development of Products and Processes 2
P Ratio of Supplier with a nonconformance vs. Supplier without a nonconfomance Supplier Quality Assurance and other Supplier Issues 10
E How does Non-Linear UUT affect TAR (Test Accuracy Ratio) Calculation? Measurement Uncertainty (MU) 3
M ANOVA for S/N ratio gives different results Statistical Analysis Tools, Techniques and SPC 5
C Maximum acceptable Tolerance - Uncertainty Ratio (TUR) General Measurement Device and Calibration Topics 2
B Calculating Precision to Tolerance Ratio Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
C Test Uncertainty Ratio (TUR) for Ring Gage Calibration Measurement Uncertainty (MU) 7
A Change Ratio [Guideline in Control Limit Update] Statistical Analysis Tools, Techniques and SPC 3
T Taguchi DOE Analysis - What S/N ratio (Nominal is best or smaller is better) to use? Quality Tools, Improvement and Analysis 5
C Part Tolerance and TAR (Test Accuracy Ratio) - Non-Fixed Gaging General Measurement Device and Calibration Topics 2
T In-House Calibration of Thread Plugs/Rings to achieve a 4:1 Ratio Measurement Uncertainty (MU) 4
T 4:1 Test Accuracy Ratio (TAR) or Stated Measurement Uncertainty (MU) General Measurement Device and Calibration Topics 21
C Calculating Percentage Contribution Ratio (PCR) in Minitab Using Minitab Software 13
J What is ratio or reciprocity-type measurements in ISO15189 General Measurement Device and Calibration Topics 2
B Study Variation and Discrimination Ratio in Gage R&R ANOVA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
L Proper Personnel Ratio - Quality to Manufacturing Manufacturing and Related Processes 6
P Ratio of Quality Personnel to Normal Personnel in your Company? Quality Manager and Management Related Issues 12
D Ideal Ratio of Turnover (Sales), Employees & Departments Quality Manager and Management Related Issues 6
P Early versus Late delivery from suppliers - what's the acceptable ratio? Quality Tools, Improvement and Analysis 6
S TUR (test uncertainty ratio) based on Standard or Expanded Measurement Uncertainty? Measurement Uncertainty (MU) 2
gard2372 Inspector to Technician Staffing Ratio Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
B Inventory Turn Over Ratio Human Factors and Ergonomics in Engineering 8
O Man to Machine Ratio - Knitting (socks) Industry Misc. Quality Assurance and Business Systems Related Topics 2
A Quality Personnel Deployment Ratio to Sales Turnover Misc. Quality Assurance and Business Systems Related Topics 6
S The Logic behind Tolerance vs. Least Count 1/10 Ratio General Measurement Device and Calibration Topics 11
Govind What is a Proof Reading Ratio? Japanese Customer Questionnaire General Measurement Device and Calibration Topics 10
A Calibration Accuracy Ratio - An explanation of the 10:1 or 4:1 rule General Measurement Device and Calibration Topics 4
J Test Uncertainty Ratio TUR (UUT Tolerance / STD Uncertainty) Question General Measurement Device and Calibration Topics 8
D The Origin of the 10:1 Resolution Ratio for Measurement Equipment General Measurement Device and Calibration Topics 17
S P/T (Precision/Tolerance) ratio for off-center processes? Process capability ratio? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
J Normal Ratio for QA to Total Hourly Labour? Quality Tools, Improvement and Analysis 10
samer Hit ratio of customer satisfaction process? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 27
A Can I use the S/N ratio analysis? Injection molding process Quality Tools, Improvement and Analysis 2
R What does the P/t ratio (Precision/Tolerance) =RR/(USL-LSL) say about my gage study? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9

Similar threads

Top Bottom