ࡱ> X  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWRoot Entry F1՜WorkbookMBD000B1B36F ̜ ̜Ole R BF!$SSP SIGMA LEVEL CALCULATOR!Object 2 FMicrosoft Equation 3.0 DS Equation Equation.39qI\yI Sigmaqualitylevel=.8406+ 29.37"2.221xln(dpm) CompObjfEquation Native SummaryInformation(DocumentSummaryInformation8 A@`\p Glenn Byrnes Ba==hx}7t"8X@"1Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0                + ) , *   @  `@+  `+  `` +  ``@ +  `` +  ``` + !xa@ @ *  h@@+  h@+  h@+  h+  h` +  h@+ "x&@@  !p`& @  !|a`@  #x@@  #x`@  #x@+ !|+  h+ !x@+  h@@  h@  h&@   h&@   `&@   ``& @  83ffff̙3f3fff3f3f33333f33333\`"BSSP SIGMA LEVEL CALCULATOR`ig"_Rfy J)#g;l@=3Rfy J)#g柀"?v:xMlGߌmb%4Q 52II'Q.6Ni'ڨR9TP$Npsɕz@)f߬TDͼy;pxt@pG}45rF^C4s(/`Px]2}rN)Q;I!FHfR *͔l%_t;ko[_Ÿh6pzeU`ϥA퀊xHyG4JJGNht`h['FҸ|a.t'F)/㳷ʈB^K/7ҋU.,u:4T!DCj&O\n*d d+EI>|T˵F I;#ҬMggߣZkѾnn|G_\[)7ˌYpY{d%o̎Yj~i}k(jכ2./YX.y_#C|@vIU롚Tu6cAJRo%UĸڱS.|'AԔlK h}'ԫ ϋb0zZp<̾{u7 dtG'7n)a1PղOgO utC'FmUAJ`r7eԭVj5\~V`9ı*>"J{U9Nɴ^ݷ*Y9tvX^=@y,+8~x n}cA@\AO ֙_o _w%Oi=pp0ak$Nw-C{N&$CGGo ߰W32_IW (3C̜1O&H0ϔ{0]ͭ D]%X?fa^HFk7{}m=jLCO*ǸnO|xޕO&y+93Z0* ױ*_]AXUu>joEd&qt,}X丹lGYc#^Vi¿C%lkˌ0 .yuy6 g~>5ۀi Kbe"VE^oQ>{8{8¿Y=!_1)nh̉&-ft1giGn=ikm R+Uk]kѼͨ=̵1~k饡1jDv3  @@   DSIX SIGMA PARTNERING BLACKBELT TOOL: SIGMA QUALITY LEVEL CALCULATORSix Sigma Quality Level%Defects or parts per million (dpm) = Six Sigma quality level = *How to use the SSP sigma level calculator:g1. Determine the process performance in terms of defects per million (dpm) or parts per million (ppm).>2. Input the dpm or ppm figure in cell B4, green shaded area.s3. The SSP sigma level calculator automatically calculates the sigma level and is displayed in cell B5, blue font.S4. Reference: Implementing Six Sigma, by Forrest Breyfogle, page 137 and Table S.^5. Note: The SSP sigma level calculator assumes the typical 1.5 sigma shift in process mean.} q A@    dMbP?_*+%MEpson Stylus COLOR ESC/P 2z-0@nhhbm0 %@MSUDEpson Stylus COLOR ESC/P 2 d"dhh??U} I"} } $   0 0 0                ,-..../01****  #$ &~ @u@ '@%w>;@*Q^=@S㥛@DAA.1?()  ! " ! " ! "  ! "  ! "   !  +$,((4j(((((((  ~  DA /@Picture 2 +]J@l > H Equation.36 >@  7  ՜.+,0 PXx  Six Sigma Partnering  SSP SIGMA LEVEL CALCULATOR  Worksheets FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q Oh+'0 X` Sigma Level Calculator Sigma LevelGlenn F. Byrnes, CMfgE Glenn ByrnesnesMicrosoft Excel@D@TgGԇE! C &" WMFC] AaXBE! EMFat!" !" !" !C &% % 6Ml!??$% 6$Ml$$$!??7% 67Ml777!??J% 6JMlJJJ!??[% 6l[[[!??m% 6mMlmmm!??% 6Ml!??% 6Ml!??% 6Ml!??% 6Ml!??% 6Ml!??% 6Ml!??% 6CMlBB!?? % 6 Ml   !??&% 6&Ml&&&!??B% 6BMlBBB!?? % Ml!?? % ( &% % 6Ml!??% 6Ml!?? % ( &% % 6Ml!??% 6Ml!??   % RLArial% TT "AUuA LP1   % ( &% 6Ml!??   TT &5AUuA &LP2   %% 6%Ml%%%!??   TT 9HAUuA 9LP3   8% 68Ml888!??   TT KZAUuA KLP4   K% 6KMlKKK!??   TT \kAUuA \LP5   \% 6\Ml\\\!??   TT o~AUuA oLP6   n% 6nMlnnn!??   TT AUuA LP7   % 6Ml!??   TT AUuA LP8   % 6Ml!??   TT AUuA LP9   % 6Ml!??   TXAUuALP10   % 6Ml!??   TXAUuALP11   % 6Ml!??   TTAUuALPA    % 6Ml!??   TTAUuALPB     % 6 Ml   !??   TT08AUuA0LPC    '% 6'&" WMFC !aMl'''!??% % % " ! C  % MlB$i!?? '_2% Ml$B7$i!??% (  % Ml7&J7 !?? '_2% Ml&7BJ&7]!??% (  % MlJ [J!?? '_2% Ml J&[ J!??'_2% (  % Ml&JB[&J]!??% (  % Ml[&m[ !?? '_2% Ml&[Bm&[]!??MlmBmiy!??   RL Arial% TB"AUuADLSIX SIGMA PARTNERING BLACKBELT TOOL: SIGMA QUALITY LEVEL CALCULATOR                   TF9HAUuAF9L|Six Sigma Quality Level    RL Arial% T,'KZAUuA'K%LDefects or parts per million (dpm) =   % T` KZAUuA KLT3.4% Tg\kAUuAg\LSix Sigma quality level =    RL Arial% T` \kAUuA \LT6.0  TH-AUuA*LHow to use the SSP sigma level calculator:      RL Arial% TBAUuAgL1. Determine the process performance in terms of defects per million (dpm) or parts per million (ppm).          TBAUuA>L2. Input the dpm or ppm figure in cell B4, green shaded area.     TBAUuAsL43. The SSP sigma level calculator automatically calculates the sigma level and is displayed in cell B5, blue font.       T@BAUuASL4. Reference: Implementing Six Sigma, by Forrest Breyfogle, page 137 and Table S.         % % " !C% (   ( &% % 6Ml!??  % ( &% % 6Ml!??% 6Ml!&" WMFC a??#% 6$Ml###!??  % (  &% % 6 Ml   !??  % ( #&% % 6&#Ml#%## !??%% 6&%Ml%%%% !??  % ( &&% % 6&Ml&&&!??B% 6BMlBBB!??  % ( &% % 6#Ml"!??% 6#Ml"!??#% 6&Ml#%#!??%% 6&Ml%%%!??6% 67Ml666!??6% 66Ml666!??8% 68Ml888!??&% 66Ml&5&!??&% 66Ml&5&!??6% 69Ml686!??8% 69Ml888!??l% 6mMllll!??l% 6lMllll!??n% 6nMlnnn!??%8% 6%9Ml%8%8%8!??'6% 6'9Ml'6'8'6!??9% 6lMl9k93!??9% 6lMl9k93!??o% 6Mloog!??o% 6Mloog!??n% 6oMlnnn!??l% 6oMllnl!?? K% 6 lMl K k K!!??%9% 6%lMl%9%k%93!??'9% 6'lMl'9'k'93!??'l% 6'oMl'l'n'l!??%l% 6%mMl%l%l%l!??% 6DMlB(!??% 6DMlB(!??% 6Ml!??% 6Ml!??Ml'#B$'#!??%% 6%Ml%%%!??#% 6#Ml###!??6% 6%6Ml6$66 !??8% 6%8Ml8$88 !??%8% 6&8Ml%8%8%8!??%6% 6(6Ml%6'6%6!??MlI$JI !??[% 6%[Ml[$[[ !??l% 6%lMll$ll !??n% 6%nMln$nn !??%n% 6(nMl%n'n%n!??%l% 6&lMl%l%l%l!??% % % " !CC0  K@0 CC% % " !C&WMFCa% % 6CMlBC!??% 6Ml!??% % % "   C''',C -- @ !$-$ @ !$7-7 @ !7J-J @ !J[-[ @ ![m-m @ !m- @ !- @ !- @ !- @ !- @ !- @ !-C @ !B -  @ ! &-& @ !&B-B @ !B - @ ! --- @ !- @ ! --- @ !- @ ! - Arial- 2  1 -- @ !  2 & 2 %-% @ !%  2 9 3 8-8 @ !8  2 K 4 K-K @ !K  2 \ 5 \-\ @ !\  2 o 6 n-n @ !n  2 7 - @ !  2 8 - @ !  2 9 - @ !  2 10 - @ !  2 11 - @ !  2 A  - @ !  2 B   -  @ !   2 0C  '-' @ !'--"Systeḿ&Onbl~-' ,C - @ !i _2- @ !i$- - @ ! 7 _2- @ !]7&- - @ !J _2- @ !J _2- - @ !]J&- - @ ! [ _2- @ !][& @ !yim   Arial-m2 DSIX SIGMA PARTNERING BLACKBELT TOOL: SIGMA QUALITY LEVEL CALCULATOR                   *2 9FSix Sigma Quality Level      Arial- ?2 K'%Defects or parts per million (dpm) = a   - 2 K 3.4- .2 \gSix Sigma quality level =      Arial- 2 \ 6.0  F2 *How to use the SSP sigma level calculator:        Arial- 2 g1. Determine the process performance in terms of defects per million (dpm) or parts per million (ppm).,          d2 >2. Input the dpm or ppm figure in cell B4, green shaded area.     2 s3. The SSP sigma level calculator automatically calculates the sigma level and is displayed in cell B5, blue font.       2 S4. Reference: Implementing Six Sigma, by Forrest Breyfogle, page 137 and Table S.         --',C- -- @ ! --- @ !- @ !#-$ @ !# - --  @ !  -#--#& @ ! #%-%& @ ! % -&--& @ !&B-B @ !B ---# @ !-# @ !#-& @ !#%-& @ !%6-7 @ !66-6 @ !68-8 @ !8&-6 @ !&&-6 @ !&6-9 @ !68-9 @ !8l-m @ !ll-l @ !ln-n @ !n8%-9% @ !8%6'-9' @ !6'9-l @ !399-l @ !39o- @ !goo- @ !gon-o @ !nl-o @ !lK -l  @ !!K 9%-l% @ !39%9'-l' @ !39'-o' @ !l'l%-m% @ !l%-D @ !(-D @ !(- @ !- @ ! @ !#'%-% @ !%#-# @ !#6-6% @ ! 68-8% @ ! 8-8& @ !8%6%-6( @ !6% @ ! I[-[% @ ! [l-l% @ ! ln-n% @ ! n-n( @ !n%l%-l& @ !l%---',C,C,C--',C--C @ !C- @ !--- 'CompObj f