Copyright © Johansson Consulting 1996-2014. All rights reserved.
The Six Sigma Toolbox

The Six Sigma Toolbox for Microsoft® Excel is a free suite of Six Sigma tools designed to assist and support Six Sigma Black Belts and Green Belts in their operational excellence projects. The toolbox is a true add-in to Microsoft Excel, integrating completely with your spreadsheet. Browse, define, analyze - while never leaving Excel. All Six Sigma tool functions are true Excel functions, and behave exactly as native Excel functions do.

The tool is currently featuring the following tools: 

A tool for identifying an appropriate distribution or transformation for a sample
A high-quality random generator which can produce random numbers from 30+ different statistical distributions
A simple-to-use, yet powerful Monte Carlo simulation tool

The aim is to add more statistical and Six Sigma/Lean related tools over time. Feel free to download and use the software for personal and/or academic work.

Download links

System requirements: Windows 2000 or higher and Microsoft® Excel 2007 or higher.
Video 1
The impact of uncertainty on a profit forecast is investigated using Monte Carlo simulation.
Excel file: MCexample.xlsx
Video 2
Demonstrating the birthday paradox using Monte Carlo simulation.
Excel file: MCBirthdayParadox.xlsm
Video 3
Tolerance design of a piston pump.
Excel file: MCPistonPump.xlsx
Received awards: