Six Sigma Calculator deluxe

Description

Six Sigma spreadsheets for your quality toolbox!

Reviews
Shared by: Jason Cardinal
Categories
Tags
Stats
views:
192
rating:
not rated
reviews:
0
posted:
8/15/2009
language:
English
pages:
0
Sigma Level Calculator Total 100 Current Numbers Good 50 Defects 50.00 Conversion 50.00000% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Current Sigma Level 50% 50.00% 0.500 500,000.0 1.5 $141 $141.00 $282.00 Good / Total Defects / Total (Total - Good) / Total DPU x 1,000,000 Refer to Sigma Chart Total 100 0.5 Sigma Improvement Good 66 Defects 34.46 Conversion 65.54220% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Sigma Level Opportunity 1 0.7 Good / Total 34.46% Defects / Total 34.46% (Total - Good) / Total 344,578.0 DPU x 1,000,000 2.0 Refer to Sigma Chart $185 $97.17 $282.00 Sigma Level Opportunity 2 0.8 Good / Total 15.87% Defects / Total 15.87% (Total - Good) / Total 158,655.0 DPU x 1,000,000 2.5 Refer to Sigma Chart $237 $44.74 $282.00 Sigma Level Opportunity 3 0.9 Good / Total 6.68% Defects / Total 0.1 (Total - Good) / Total 66,807.0 DPU x 1,000,000 3.0 Refer to Sigma Chart $263 $18.84 $282.00 Sigma Level Opportunity 4 1.0 Good / Total 2.28% Defects / Total 0.0 (Total - Good) / Total 22,750.0 DPU x 1,000,000 3.5 Refer to Sigma Chart $276 $6.42 $282.00 Sigma Level Opportunity 5 1.0 Good / Total 0.62% Defects / Total 0.0 (Total - Good) / Total 6,210.0 DPU x 1,000,000 4.0 Refer to Sigma Chart $280 $1.75 $282.00 Sigma Level Opportunity 6 1.0 Good / Total 0.14% Defects / Total 0.0 (Total - Good) / Total 1,350.0 DPU x 1,000,000 4.5 Refer to Sigma Chart $282 $0.38 $282.00 Sigma Level Opportunity 7 1.0 Good / Total 0.02% Defects / Total 0.0 (Total - Good) / Total 233.0 DPU x 1,000,000 5.0 Refer to Sigma Chart $282 $0.07 $282.00 Sigma Level Opportunity 8 1.0 Good / Total 0.003% Defects / Total 0.0 (Total - Good) / Total 32.0 DPU x 1,000,000 5.5 Refer to Sigma Chart $282 $0.01 $282.00 Sigma Level Opportunity 9 1.0 Good / Total 0.0003% Defects / Total 0.0 (Total - Good) / Total 3.4 DPU x 1,000,000 6.0 Refer to Sigma Chart $282 $0.00 $282.00 Total 100 1 Sigma Improvement Good 84 Defects 15.87 Conversion 84.13450% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Total 100 1.5 Sigma Improvement Good 93 Defects 6.68 Conversion 93.31930% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Total 100 2 Sigma Improvement Good 98 Defects 2.28 Conversion 97.72500% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Total 100 2.5 Sigma Improvement Good 99 Defects 0.62 Conversion 99.37900% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Total 100 3 Sigma Improvement Good 100 Defects 0.14 Conversion 99.86500% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Total 100 3.5 Sigma Improvement Good 100 Defects 0.02 Conversion 99.97670% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Total 100 4 Sigma Improvement Good 100 Defects 0.00 Conversion 99.99680% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Total 100 4.5 Sigma Improvement Good 100 Defects 0.00 Conversion 99.99966% Good Yield (%) DPU Defects (%) DPU DPM Sigma Level Revenue x Good: Revenue x Defects: Revenue x Total: Calculator provided by: Shawn Taylor Page 1 of 2 SIGMACALC-EN-XLS Yield Long - Term Sigma Short - Term Sigma Defects per MillionDefect per 100 100.00000% Over 6 0 0 99.99966% 4.5 6 3.4 0.00034 99.99946% 4.4 5.9 5.4 0.0005 99.99915% 4.3 5.8 8.5 0.008 99.99866% 4.2 5.7 13 0.001 99.99790% 4.1 5.6 21 0.002 99.99680% 4 5.5 32 0.003 99.99520% 3.9 5.4 48 0.004 99.99280% 3.8 5.3 72 0.007 99.98920% 3.7 5.2 108 0.01 99.98400% 3.6 5.1 159 0.015 99.97700% 3.5 5 233 0.023 99.96600% 3.4 4.9 337 0.033 99.95200% 3.3 4.8 483 0.048 99.93100% 3.2 4.7 687 0.068 99.90000% 3.1 4.6 968 0.096 99.87000% 3 4.5 1,350 0.135 99.81000% 2.9 4.4 1,866 0.186 99.74000% 2.8 4.3 2,555 0.255 99.65000% 2.7 4.2 3,467 0.346 99.53000% 2.6 4.1 4,661 0.466 99.38000% 2.5 4 6,210 0.621 99.18000% 2.4 3.9 8,198 0.819 98.90000% 2.3 3.8 10,724 1.07 98.60000% 2.2 3.7 13,903 1.39 98.20000% 2.1 3.6 17,864 1.78 97.70000% 2 3.5 22,750 2.27 97.10000% 1.9 3.4 28,716 2.87 96.40000% 1.8 3.3 35,930 3.59 95.50000% 1.7 3.2 44,565 4.46 94.50000% 1.6 3.1 54,799 5.48 93.30000% 1.5 3 66,807 6.68 91.90000% 1.4 2.9 80,757 8.08 90.30000% 1.3 2.8 96,801 9.68 88.50000% 1.2 2.7 115,070 11.5 86.40000% 1.1 2.6 135,666 13.5 84.10000% 1 2.5 158,655 15.8 81.60000% 0.9 2.4 184,060 18.4 78.80000% 0.8 2.3 211,855 21.2 75.80000% 0.7 2.2 241,964 24.2 72.60000% 0.6 2.1 274,253 27.4 69.10000% 0.5 2 308,538 30.8 65.50000% 0.4 1.9 344,578 34.4 61.80000% 0.3 1.8 382,089 38.2 57.90000% 0.2 1.7 420,740 42 54.00000% 0.1 1.6 460,172 46 1.5 -infinity Z 480,000 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 2.9 3 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4 4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 5 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9 6 Over 6 480,000 460,172 420,740 382,089 344,578 308,538 274,253 241,964 211,855 184,060 158,655 135,666 115,070 96,801 80,757 66,807 54,799 44,565 35,930 28,716 22,750 17,864 13,903 10,724 8,198 6,210 4,661 3,467 2,555 1,866 1,350 968 687 483 337 233 159 108 72 48 32 21 13 8.5 5.4 3.4 0 Page 2 of 2 SIGMACALC-EN-XLS

Related docs
Six Sigma Calculator
Views: 126  |  Downloads: 42
Six Sigma Calculator
Views: 77  |  Downloads: 12
Six Sigma Software Quality Matrix Deluxe
Views: 64  |  Downloads: 25
Six Sigma Sum Squares
Views: 80  |  Downloads: 18
Six Sigma
Views: 727  |  Downloads: 92
Six Sigma Template
Views: 2102  |  Downloads: 631
Six Sigma
Views: 204  |  Downloads: 64
Six_Sigma_Basic
Views: 212  |  Downloads: 27
Six Sigma Worksheets and Aids
Views: 17  |  Downloads: 7
Six Sigma DFMEA
Views: 139  |  Downloads: 40
premium docs
Other docs by Jason Cardinal
Six Sigma Z Table
Views: 87  |  Downloads: 11
Six Sigma Vendor Evaluation
Views: 119  |  Downloads: 19
Six Sigma Toll Gate Road Map
Views: 110  |  Downloads: 7
Six Sigma Toll Gate Checklist
Views: 260  |  Downloads: 25
Six Sigma Test Report
Views: 57  |  Downloads: 14
Six Sigma Test Case Checklist
Views: 159  |  Downloads: 10
Six Sigma Technical Training Plan
Views: 42  |  Downloads: 9
Six Sigma Supplier Evaluation Form
Views: 551  |  Downloads: 61
Six Sigma Sum Squares
Views: 80  |  Downloads: 18
Six Sigma Solution Tree
Views: 74  |  Downloads: 14
Six Sigma Software Quality Matrix Deluxe
Views: 64  |  Downloads: 25
Six Sigma Software Quality Matrix
Views: 111  |  Downloads: 27
Six Sigma Shift & Drift Table
Views: 57  |  Downloads: 14
Six Sigma Sales Report
Views: 69  |  Downloads: 24
Six Sigma Regression Sum
Views: 49  |  Downloads: 10