The Best DPMO Excel Template

This template calculates DPMO (defects per million opportunities) and sigma level. Also included are template instruction and training material tabs (download here).

Instruction Tab – DPMO Template

The first tab shows a customer service (order entry) example similar to our DPMO page.

DPMO and Sigma Level for a Process

The second tab shows a product example, in this case a shifter assembly for a power tool –

DPMO and Sigma Level for a Product

The last tab shows the four training images from the DPMO page –

Training Slides – DPMO