22 ready-to-use Lean Six Sigma tools in one Excel file, from project charter to control plan. Gage R&R, capability, hypothesis tests and control charts calculate themselves. No Minitab license needed.
Instant download · Microsoft Excel · Includes a complete worked example project
Updates as you work: tick tollgate items and fill in each tab, and the dashboard tracks your project.
Each tab is colour-coded by phase, comes with filled-in sample data, and tells you exactly which cells to fill in.
The statistics run as ordinary Excel formulas, so you can see how every number is calculated.
Enter values in time order. Control limits calculate automatically and any point outside them is flagged in red.
| Sample size | 50 |
| Cp | 1.04 |
| Cpk | 0.79 |
| DPMO | 8,264 |
| Sigma level | 3.90 |
| Verdict | Not capable |
Paste up to 50 measurements and enter your spec limits. Short-term and long-term capability are both calculated for you.
| Failure mode | S | O | D | RPN |
|---|---|---|---|---|
| Required docs missing | 7 | 8 | 4 | 224 |
| App sits in queue | 8 | 5 | 6 | 240 |
| Wrong terms sent | 9 | 3 | 5 | 135 |
| After fix: docs missing | 7 | 3 | 2 | 42 |
Score severity, occurrence and detection from 1 to 10. Any RPN of 100 or more turns red until you act on it.
| Mean, before | 48.1 min |
| Mean, after | 38.5 min |
| t statistic | 4.66 |
| p-value | 0.00005 |
| Conclusion | Significant difference |
Paste two groups of data for a Welch t-test, plus a guide that tells you which test fits your question.
An AI coach that knows Lean Six Sigma and every tab of the toolkit. Ask it anything, from "where do I start?" to "is my measurement system good enough?"
DMAIC Coach runs in Claude and needs a Claude account.
22% is in the marginal zone (10–30%). You can proceed for now, but fix the measurement system before you rely on small differences.
Next step: which is larger in your study, %EV or %AV?
Running a first project and want a structure that keeps you on track at every tollgate.
Leading several projects and want one consistent template for every team you coach.
Doing real statistics with the Excel you already have.
Learning DMAIC by working through a complete example, with a coach to answer questions.
Map any process on one page in 30 minutes, and get your team to agree on where it starts and stops.
Enter your email on Gumroad and the Excel file is sent to you right away. You'll also get occasional Lean Six Sigma tips, and you can unsubscribe at any time.
Ready-to-teach PowerPoint courses with speaker notes, exercises and knowledge checks. Use them to learn on your own, or to train your team.
192 editable slides with speaker notes. $326 if bought separately.
A 1-hour live online session with Wes Dennis: 27 years of Lean Six Sigma in manufacturing, financial services and insurance. Bring your project, your data or your questions.
Use it on as many of your own projects as you like.
I'm Wes Dennis, a Lean Six Sigma Master Black Belt with 27 years of experience improving processes in manufacturing, financial services and insurance, including medical and group benefits insurance. I built this toolkit because I was tired of rebuilding the same templates for every project and every belt I coached. It's the set of tools I actually use, in the order I use them.
Wes Dennis · Master Black Belt · 27 years in manufacturing, insurance and financial services
Microsoft Excel. Every calculation uses standard Excel formulas, with no macros or add-ins, so there's nothing to install or enable.
No. Gage R&R, capability, Pareto, t-tests, regression and three types of control chart are built in. For advanced methods such as DOE or ANOVA, DMAIC Coach explains the approach and suggests a tool.
Every tab includes a filled-in example and tells you which cells to fill in. The bundle adds DMAIC Coach, which explains concepts in plain language at your level.
After purchase you get a link to the coach. It runs in Claude, so you need a Claude account. Pick your belt level and phase, then ask questions as you work.
Each course is an editable PowerPoint file with speaker notes on every slide, worked examples, exercises and knowledge checks with an answer key. They follow the same sample project as the toolkit, so learners can practice on each tab as they go.
Each license is for one person. If you want to run the training courses for a team or several copies of the toolkit, get in touch about a team license.
If the toolkit isn't right for you, ask for a refund within 30 days of purchase and you'll get your money back in full.