Want a DPMO Six Sigma Calculator in Excel?

QI Macros has a Ready-Made DPMO Calculator Template!


Go Deeper: Instructions for Use

dpmo and six sigma calculator

Input areas are shaded in yellow and represent the following:

  • Opportunities = the number of defects possible per unit
  • Defects = # of defects
  • Units = # of units in a sample

When you input these three items, the template performs the calculations and displays these metrics in cells B5:11

  • DPMO: defects per million opportunities
  • % defects: percent of total opportunities that were defective
  • % yield: percent that is not defective (1-% defects)
  • Sigma: sigma level associated the the calculated DPMO (see reference table in columns D1:E9)
  • Zst: Z short term
  • Zlt: Z long term
  • DPMU: defects per million units
  • Cp: process capability metric = Sigma/3

Further definitions:

Defects and units are fairly straightforward but some folks struggle with the number of opportunities. The number of opportunities is based on how you choose to count defects. Here are some examples:

  • One opportunity: an item is either wrong or right, good or bad.
  • Two opportunities: A package could have the wrong product or the wrong # products in it.
  • Example of three opportunities: a shirt you order could be the wrong: size, style or color.

QI Macros DPMO Six Sigma Calculator

To access the DPMO calculator, click on the QI Macros menu > Calculators > DPMO | Yield | Cp/PPM | OEE:

calculators menu

A template will open with the following worksheet tabs.

dpmo calculator worksheets

Haven't you waited long enough?
Start creating your DPMO Calculations in just minutes.

Download a free 30-day trial. Get the DPMO Calculations now!

The DPMO Calculations is one of many tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. If you can't locate a tool, use the find tools feature on the far right side of QI Macros menu.

find tools on QI Macros menu

Learn More...

Other charts in QI Macros add-in