Scribd
Upload
882 views2 pages

Cpk and Ppk Excel Template Guide

This document appears to be a capability study report for a manufacturing process. It includes data from subgroups on a characteristic, including individual readings, means, ranges and calculations of metrics like Cp, Cpk, PPM and control limits. Charts are presented showing the average and range of readings over time. However, much of the data and calculations are incomplete or contain errors, as indicated by "#DIV/0!" values.

Uploaded by

my.nafi.pmp5283
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
882 views2 pages

Cpk and Ppk Excel Template Guide

This document appears to be a capability study report for a manufacturing process. It includes data from subgroups on a characteristic, including individual readings, means, ranges and calculations of metrics like Cp, Cpk, PPM and control limits. Charts are presented showing the average and range of readings over time. However, much of the data and calculations are incomplete or contain errors, as indicated by "#DIV/0!" values.

Uploaded by

my.nafi.pmp5283
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Place Cursor Here to View Instructions

PART NUMBER

Your Company Name Here


CAPABILITY STUDY No:
DESCRIPTION OPERATION DATE: MACHINE DEPARTMENT

Place Mouse Cursor over red mark to view important comment Name of Characteristic: USL LSL

n n

NOMINAL
TOTAL TOLERANCE Individual Readings

0 0

Target Value

Data is from: Sub-groups


1 1 2 3 4 5 SUM AVG RANGE Mean #DIV/0! 0.0000 . . . . . . 2 3

Must indicate source of data


6 7 8 9 10

. #DIV/0! #DIV/0!

Cp Pp

#DIV/0! #DIV/0!

Cpk Ppk Cpmk

#DIV/0! #DIV/0!
#DIV/0!

Ppm Ppm

/R

AVERAGE CHART
1. .9 .8
AVE

.7 .6 .5 .4 .3 .2 .1 .

USL LSL UCL LCL MEAN

1.000 0.500 0.000 0 0 0 0

RANGE CHART
Average UCLr

AVE USL LSL UCL LCL MEAN UCLr Average

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

. .0 #DIV/0! #DIV/0! #DIV/0! 0.000 0

STANDARD DEVIATION OR SIGMA - R Bar METHOD AVERAGE OF RANGES CONSTANT 0.0000 0.000 = #DIV/0! 1 SD = 3 SD = 6 SD = 4 2.059 5 2.326 #DIV/0! #DIV/0! #DIV/0!

Subgroup Size = SUBGROUP SIZE CONSTANT 2 1.128

0 3 1.693

STANDARD DEVIATION - POPULATION ( n-1 )

1 SD = 3 SD = 6 SD =

#DIV/0! #DIV/0! #DIV/0!

CONTROL LIMIT CALCULATION RANGE UCLr = Average of Range * Constant RANGE LCLr = "NONE" = = UCLr LCLr UCL LCL 0.0000 NONE #DIV/0! #DIV/0!

= PROCESS AVERAGE UCL = Ave of Averages + (Ave of Ranges * Constant) PROCESS AVERAGE LCL = Ave of Averages - (Ave of Ranges * Constant)= CONSTANTS FOR CONTROL LIMITS SUB GROUP 2 3 4 PROCESS 1.88 1.02 0.73 RANGE 3.27 2.57 2.28

5 0.58 2.11

0.00 0.00

CAPABILITY (CP) CAPABILITY (Cpk - Ppk)

(CP) indicates the probable overall spread of the results (Cpk - Ppk) is the probable distribution of results relative to the MEAN

Cp Cpk Pp Ppk

#DIV/0! #DIV/0!

#DIV/0! #DIV/0!

Z-USL Z-LSL Z-USL Z-LSL

#DIV/0! #DIV/0!

Ppm Ppm Ppm Ppm

#DIV/0! #DIV/0!

#DIV/0! #DIV/0!

#DIV/0! #DIV/0!

#DIV/0! #DIV/0!

#DIV/0! #DIV/0!

DATE: PART NUMBER DESCRIPTION OPERATION MACHINE USL n 0 LSL n 0 Sub-groups 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 SUM . . . . . . . .
AVE USL . . . . . . . . . . LSL .0 .0 .0 .0 .0 .0 .0 .0 .0 .0 UCL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DI

You might also like