# Excel spreadsheet for Unilateral Tolerance Study wanted

#### kedarg6500

##### Quite Involved in Discussions
Does any one have excel sheet with PC study for unilateral tolerance

Kedar

maybe this helps

#### Attachments

• 126 KB Views: 686

#### bobdoering

Trusted Information Resource
maybe this helps
Cpk and Ppk are designed to determine if a normal distribution process output, with a target value in the middle of the tolerance is centered. Otherwise Cp or Pp identifies the probability of the normal distribution process output will make parts in spec. A unilateral tolerance cannot have a centered distribution, so Cpk and Ppk are not applicable. What this Cpk calculation gives you is a distance from the specification - which is not the typical use of the index.

If you want to know the capability of a process with a physical limitation as a lower limit (such as 0 for runout) and a max tolerance above, you need to run a curve fit (you might assume gamma distribution if you are not familiar with curve fitting. The easiest way is to use Distribution Analyzer at variation.com) and determine it probability of being in tolerance based on the correct distribution model.

Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R Is there any Excel .xls Spreadsheet available for DOE with 3 factors? Six Sigma 1
Excel Spreadsheet for AIAG Example wanted Excel .xls Spreadsheet Templates and Tools 3
A Tracking Calibration and Qualification in an MS Excel Spreadsheet Calibration and Metrology Software and Hardware 5
S Form and Form/Record Numbering in an Excel Spreadsheet Excel .xls Spreadsheet Templates and Tools 2
J Excel spreadsheet to use Basic and Mini MOST for Line Balancing Document Control Systems, Procedures, Forms and Templates 1
B How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
T Controlling an Excel Spreadsheet (Database) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
How do I create two different columns in Excel spreadsheet ? Excel .xls Spreadsheet Templates and Tools 5
L Auditing Tool (Excel spreadsheet) for VDA 6.3 to Audit a Service Provider VDA Standards - Germany's Automotive Standards 4
J Excel spreadsheet for Gage R&R study with 9 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
M Taguchi L4 Orthogonal Array Design of Experiments (DOE) in an Excel spreadsheet Excel .xls Spreadsheet Templates and Tools 3
F SPC Data Analysis - Excel Spreadsheet I can use for Diameters and Perpendicularity Capability, Accuracy and Stability - Processes, Machines, etc. 6
F SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 components Capability, Accuracy and Stability - Processes, Machines, etc. 8
V Excel Spreadsheet to Calculate Temperature Compensation of Gage Blocks wanted General Measurement Device and Calibration Topics 3
S Strange PT Ratio on an Excel spreadsheet for variable GRR ANOVA Method Excel .xls Spreadsheet Templates and Tools 2
A Excel Spreadsheet Validation - Customer Audit Finding Other US Medical Device Regulations 2
Calculation of PPM & Sigma Level in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
Excel (xlsx) spreadsheet for conducting Type 1 MSA Analysis. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 23
J ROI (Return on Investment) Excel Spreadsheet example Excel .xls Spreadsheet Templates and Tools 1
Medical Device Inspection Sheets - Excel Spreadsheet Validation US Food and Drug Administration (FDA) 2
T Controlled Documents - Can a word document and excel spreadsheet be controlled? Document Control Systems, Procedures, Forms and Templates 5
K Excel Spreadsheet Template to calculate Cmk (Machine Capability) wanted Capability, Accuracy and Stability - Processes, Machines, etc. 2
R Cpk & Ppk and Differences between Minitab and an Excel Spreadsheet Results Statistical Analysis Tools, Techniques and SPC 4
S Excel Spreadsheet Conditional Formatting help needed Excel .xls Spreadsheet Templates and Tools 12
J Excel Spreadsheet Validation for Calculating Data coming from our Instruments (LIMS) General Measurement Device and Calibration Topics 3
1 Defect Tracking Excel Spreadsheet Template Excel .xls Spreadsheet Templates and Tools 2
S Excel spreadsheet shows weird CPK outcome Quality Assurance and Compliance Software Tools and Solutions 10
R Export some dates from an excel spreadsheet - EXCEL Question Excel .xls Spreadsheet Templates and Tools 3
A Gantt Chart or Excel Spreadsheet for ISO 9001 Implementation ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
T Do I need to validate a basic Excel spreadsheet Quality Assurance and Compliance Software Tools and Solutions 10
R Supplier Quality Rating Scorecard Template (excel spreadsheet) Supplier Quality Assurance and other Supplier Issues 4
Q Can someone share an Excel spreadsheet to measure Cpk or Cp values. Excel .xls Spreadsheet Templates and Tools 15
A Validation of an Excel Spreadsheet used for Recording Test Results Qualification and Validation (including 21 CFR Part 11) 14
Process Capability for Attribute Data - Excel .xls spreadsheet wanted Capability, Accuracy and Stability - Processes, Machines, etc. 5
F ASTM F104 Callout Interpretation - .xls Excel Spreadsheet Various Other Specifications, Standards, and related Requirements 0
T Double-sided (USL, LSL) Variables sampling plan Z1.9 - Use in Excel spreadsheet? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
J Attribute Measurement System Analysis Excel spreadsheet Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 11
J CMM Accuracy - Formula for Excel or a spreadsheet Excel .xls Spreadsheet Templates and Tools 20
M Capacity Analysis or Calculations - Excel Spreadsheet needed Excel .xls Spreadsheet Templates and Tools 3
U Excel .xls spreadsheet for Line Balancing (Time and Motion Study) needed Excel .xls Spreadsheet Templates and Tools 1
Report Writer for Excel spreadsheet or CSV (Comma-Separated Values) Format Excel .xls Spreadsheet Templates and Tools 8
APQP Process Assessment Tool - Excel .xls Spreadsheet Excel .xls Spreadsheet Templates and Tools 1
P Small Business Spreadsheet Factory - a good site for excel, word ... Excel .xls Spreadsheet Templates and Tools 4
C Gage R&R Studies Excel .xls spreadsheet Excel .xls Spreadsheet Templates and Tools 7
A GR&R (Gage R&R) Calculation Excel .xls Spreadsheet Excel .xls Spreadsheet Templates and Tools 6
C Excel spreadsheet containing Gage R&R with Anova Method wanted Excel .xls Spreadsheet Templates and Tools 22
M Gage R&R Excel .xls Spreadsheet Problem Excel .xls Spreadsheet Templates and Tools 5