The DMAIC Template
Define · Measure · Analyse · Improve · Control
A structured problem-solving template aligned to ISO 13053. Six tabs. Twenty tools. Every phase has a gate — you cannot advance until the conditions are met.
Two versions: one blank for your own projects, one filled with the worked example from Statistics Don't Cough — a complete DMAIC investigation of Modena's air quality crisis using real data.
Blank Template
Start With Structure
Fill in your own data. Every tool has a description explaining what it does and why. The structure does the thinking.
Worked Example
See It Applied
The Modena air quality investigation from the book. PM2.5 at 4.7× the WHO guideline. Three source sectors, five DMAIC phases, all completed with real data.
What's Inside
Dashboard — Project information, phase status tracker, executive summary, navigation to all phases.
Phase 1: Define — Problem Definition (5W2H + Is/Is Not), VOC → CTQ Tree, SIPOC, Project Charter.
Phase 2: Measure — Data Collection Plan, Process Map, Measurement Validation, Process Capability and Sigma Score.
Phase 3: Analyse — Cause and Effect (Fishbone), Five Whys, Pareto Analysis.
Phase 4: Improve — Action Strength Matrix, Pilot Testing, Cost-Benefit Analysis, FMEA.
Phase 5: Control — Control Plan, Specification Limits, SOPs and Training, Effectiveness Verification, Poka-Yoke.
Excel format (.xlsx) · Compatible with Excel, Google Sheets, LibreOffice · No email required