Unequal Bilateral Tolerance spreadsheet wanted

rnsvasan

Involved In Discussions
#1
Can someone provide the formula / sheet for unequal bilateral tolerance. Is it different from the one we use for equal bilateral tolerance ? pl. clarify.

Thanks in advance
 
Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#2
Please provide some additional context. It is unclear what type of worksheet you desire.
 

bobdoering

Stop X-bar/R Madness!!
Trusted Information Resource
#3
Also, you specify the type of tolerance, which is one of the least important aspects of an SPC chart (which I assume you are looking for, since you posted in the SPC forum.) We need to know the process you have an the type of characteristic - length, diameter, form (roundness, parallelism). The distribution of the process - not the tolerance - is the most key question to answer. Tolerance only comes into play in SPC if you have a continuous uniform distribution. It also relates to capability - not control.
 

Ronen E

Problem Solver
Staff member
Moderator
#4
Can someone provide the formula / sheet for unequal bilateral tolerance. Is it different from the one we use for equal bilateral tolerance ? pl. clarify.

Thanks in advance
When the two sides of the tolerance are unequal, use the smaller one for Cpk calculations.
 

bobdoering

Stop X-bar/R Madness!!
Trusted Information Resource
#5
When the two sides of the tolerance are unequal, use the smaller one for Cpk calculations.
Be careful that is not always true. In fact in metric tolerances it is rarely true, as the nominal can be simply the closest whole number rather than a "target". I recommend reading this thread.
 

rnsvasan

Involved In Discussions
#6
Also, you specify the type of tolerance, which is one of the least important aspects of an SPC chart (which I assume you are looking for, since you posted in the SPC forum.) We need to know the process you have an the type of characteristic - length, diameter, form (roundness, parallelism). The distribution of the process - not the tolerance - is the most key question to answer. Tolerance only comes into play in SPC if you have a continuous uniform distribution. It also relates to capability - not control.
Sorry, I couldn't reply immediately as i was out of station.
Yes for your question, we need to plot for Outer diameter of the piston having tolerance of 50 + 0.10 / -0.15. The target value is 50 - acceptable error on plus side is 0.10 and minus side is 0.15. Then which method is to be used for calculating Cpk value.
 

Miner

Forum Moderator
Staff member
Admin
#7
The Cp/Cpk indices do not take off-center targets into consideration. They are based solely on the specifications, not the target. You simply calculate both the upper (Cpku) and lower (Cpkl) values and use the smaller of the two as Cpk.

In your situation, the Cpm index may be more relevant as it takes the actual target value into consideration.

There are also a lot of discussions on the relative merits and failings of capability indices in general if you search the cove.
 

bobdoering

Stop X-bar/R Madness!!
Trusted Information Resource
#8
The Cp/Cpk indices do not take off-center targets into consideration. They are based solely on the specifications, not the target. You simply calculate both the upper (Cpku) and lower (Cpkl) values and use the smaller of the two as Cpk.

In your situation, the Cpm index may be more relevant as it takes the actual target value into consideration.

There are also a lot of discussions on the relative merits and failings of capability indices in general if you search the cove.
I agree, using Cpk is likely what a customer will want to see, Cpm may be academically more beneficial. My guess is if you are doing precision machining of piston ODs (grinding, CNC turning, etc.), neither is applicable - as if you are correctly controlling the process, it should not be normal - and normality is an important basis for Cpk and Cpm (see 2.2.11.5 Processes with One-Sided Specifications or Non-Normal Distributions). I recommend reading Statistical process control for precision machining. When properly controlled, you should find the the capability to be (USL-LSL)/(UCL-LCL).
 
Thread starter Similar threads Forum Replies Date
L Capability calculation on unequal bilateral tolerances? Capability, Accuracy and Stability - Processes, Machines, etc. 5
Proud Liberal Power Query to combine multiple tables of unequal number of columns Statistical Analysis Tools, Techniques and SPC 1
M Unequal Sample Sizes - F-Test & T-Test Statistical Analysis Tools, Techniques and SPC 5
K Flow of Descriptive Stats Analysis and Unequal Variances Help (Minitab) Using Minitab Software 3
G Stabilized (Normalized) S Chart for Unequal Sample Sizes Statistical Analysis Tools, Techniques and SPC 5
S Single-Stage Cluster Sample of Unequal Sizes & Confidence Limits Statistical Analysis Tools, Techniques and SPC 1
S Data have unequal variances Six Sigma 4
Q Ppk and Pp on unilateral or unequal tolerance - DCx says Pp can not be calculated Capability, Accuracy and Stability - Processes, Machines, etc. 19
M Transport Canada - EASA Part 145 (Bilateral) EASA and JAA Aviation Standards and Requirements 0
S CMDCAS ISO13485 - Bilateral agreement with SAI global to conduct Certification Audits ISO 13485:2016 - Medical Device Quality Management Systems 7
R Capability for CMM Scanned Profiles on a feature with a Bilateral Profile Tolerance Capability, Accuracy and Stability - Processes, Machines, etc. 26
X EASA Part 145 / FAA Bilateral Agreement vs. Manufacturing under EASA Part 21 EASA and JAA Aviation Standards and Requirements 2
A Converting 1-Sided Design Tolerance to a Bilateral Tolerance Statistical Analysis Tools, Techniques and SPC 8
kedarg6500 Process Capability - Bilateral vs. Unilateral Tolerances Capability, Accuracy and Stability - Processes, Machines, etc. 1
D Unilateral / Bilateral Tolerances for dimensions with Double Plus or Minus Tolerance Statistical Analysis Tools, Techniques and SPC 12
D Tolerance symbol Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
D Calibration tolerance question using Pipettes Medical Device and FDA Regulations and Standards News 1
M Determining a tolerance value for Measuring devices in-house inspection General Measurement Device and Calibration Topics 12
G 0.00005" tolerance on micrometer with 0.0005" resolution? General Measurement Device and Calibration Topics 4
N Drawing tolerance vs. Measurement device General Measurement Device and Calibration Topics 7
I Control Plan (Product/Process specification/ Tolerance) acceptance FMEA and Control Plans 27
J Mechanical inspection techniques of close tolerance parts Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
Proud Liberal Small radius with tight tolerance on a torus General Measurement Device and Calibration Topics 4
L GRR for a tolerance that has changed Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
T How to justify this High %Tolerance Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
D Tolerance definition based on expected Cp/cpk Reliability Analysis - Predictions, Testing and Standards 14
N % Tolerance - Type 1 study on the gages, then a gage R&R (ANOVA) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
S Tolerance limits for micro balance General Measurement Device and Calibration Topics 1
J Determining SPC tolerance Statistical Analysis Tools, Techniques and SPC 21
Q % Study variation low, % tolerance high - GR&R Interpretation help Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
R Uncertainty in measurement larger than tolerance Measurement Uncertainty (MU) 2
WEAVER Electronic Weighing Scale Calibration Tolerance Manufacturing and Related Processes 1
I Determining Calibration Tolerance of a Measurement Device General Measurement Device and Calibration Topics 2
Ronen E Tolerance intervals (?) question - Flow Rate Probability Range Statistical Analysis Tools, Techniques and SPC 6
D Tolerance when verifying an analytical balance General Measurement Device and Calibration Topics 3
E Discussion between co-worker on tolerance and uncertainty and how to apply it. Thoughts? 17025 ISO 17025 related Discussions 1
C Thread Tolerance - Can I use a 3A Ring on a part that the drawing calls out for a 2A? Manufacturing and Related Processes 5
T GRR based on part tolerance or process variation. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
A Excel OOT (Out of Tolerance) Formula Excel .xls Spreadsheet Templates and Tools 3
N Tolerance Interval plots in Minitab Statistical Analysis Tools, Techniques and SPC 0
S Question about a basic additive variance/tolerance example Quality Tools, Improvement and Analysis 2
G Assigning a calibration tolerance - An x-y coordinate machine - Uncertainty as my verification tolerance General Measurement Device and Calibration Topics 4
R Feeler Gauge Calibration - What tolerance is used for calibrating feeler gauges? General Measurement Device and Calibration Topics 4
S SPC (Statistical Process Control) for Unilateral Tolerance - Questions Statistical Analysis Tools, Techniques and SPC 6
B Gage R&R Acceptable (10-30%), deduct Total Variation from Tolerance Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
Y How to fix weight tolerance for plastic injection molded part? Does it vary with material groups? Manufacturing and Related Processes 1
F Position tolerance check gage manufacturing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
M GD&T tolerance or band? Using a symbol like parallelism // Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
J What is the difference between Process Variation and Tolerance? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
J Gage R&R without tolerance Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8

Similar threads

Top Bottom