This bundle is made of three products: The DMAIC Suite, VSM Calculator and DFSS Basic tools.
The DMAIC Suite is a statistical multilanguages* application under the form of an Excel file with worksheets which enables Lean Six Sigma Black Belts and Green Belts to achieve all their statistical, graphical measures and analysis for the DMAIC phases of their projects. Easy to use and intuitive, documented with examples. Just enter your data and let the software compute, display the graphs and interpret the results on the fly!!
It includes all statistical tools for DMAIC: Measure gage R&R study for both attribute and continuous data, Measure Performance, Stats and graphics for both attribute and continuous data, Analysis of continuous Y with continuous X and attribute X, Analysis of attribute Y with attribute X, Proof of improvement for both attribute and continuous Y, Control cards for SPC and for continuous Y and attribute Y.
Details:
*Available languages: English(default), Spanish, German, French, Chinese
Measure:
 gage R&R study for continuous Y (ANOVA method with % of study variation, % of tolerance, Number of distinct categories)
 gage R&R study for attribute Y (% of agreements of operators repeatability, % of agreements of operators reproducibility, % of agreements of operators repeatability versus a standard, % of agreements of operator reproducibility versus a standard, % of concordant agreements vs standard, % of OK evaluated KO, % of KO evaluated OK)
 Continuous Y performance: (sample max size is 20 000 data)
 graphs: IMR control cards, Histogram with specification limits, box plot with specification limits
 Sample size estimation
 Normality test with p_value calculation and test significance result/interpretation
 Basic statistics
 Process capability with Z long term and short term calculation for both normal and non normal data
 Attribute Y: PPM calculation with pie chart, DPMO calculation with pie chart, Rolled Throughput Yield calculation, OEE calculation, Sample size estimation, Defect categorization with Pareto chart and pie chart
Analysis:
 Continuous Y, Attribute X analysis:
 Up to 5 attribute values for X (5 subgroups of 5000 Y data max)
 Box plot with USL and LSL specification limits and mean line
 For each subgroup:
 Normality test
 Basic statistics
 Process capability with Z long term and short term calculation for both normal and non normal data
 5 subgroups means, medians and variances systematic hypothesis tests with p_value results and tests significance results/interpretations
 Continuous Y, continuous X analysis:
 Simple linear regression with Y=f(X) equation and R_square value displayed on regression graph
 Simple quadratic regression with Y=f(X) equation and R_square value displayed on regression graph
 Simple cubic regression with Y=f(X) equation and R_square value displayed on regression graph
 Y targeting with automatic equation resolution for X adjustment(s)  optional
 Y target and X adjustment(s) display on all regression graphs
 Attribute Y, Attribute X analysis:
 Chi square test with up to 5 attributes for Y and for X table
 Expected frequency and chi square contribution of each cell of the chi square table
 p_value calculation
 Chi square test significance result/interpretation
 Pareto tool and pie chart for attribute factor analysis
Improve:
 Y continuous proof of improvement:
 "Before" and "After" subgroups (20 000 Y data max per subgroup)
 Box plot with USL and LSL specification limits and mean line
 For each "before" and "after" subgroup:
 Normality test
 Basic statistics
 Process capability with Z long term and short term calculation for both normal and non normal data
"Before" and "After" subgroups means, medians and variances systematic hypothesis tests with p_value results and tests significance results/interpretations
 Y attribute proof of improvement:
 Chi square test with up to 5 attributes for Y and 2 attributes ("Before" and "After") for X
 Expected frequency and chi square contribution of each cell of the chi square table
 p_value calculation
 Chi square test significance result/interpretation
Control:
 Continuous Y:
 IMR control card
 XbarR control card
 XbarS control card
 Attribute Y:
 P control card
 U control card
What do you get when ordering the DMAIC Suite?
Once you order and pay the DMAIC Suite, you will be directed to a Download directory where you will find the DMAIC Suite zip file to download to your computer.
First download the file "DMAIC Suite V2 english.zip" to your computer.
Then you will need to unzip this downloaded zip file (usually done by double clicking on it).
Finally you will get an excel file named "DMAIC Suite V2 english.xlsx" on your computer.
You can open the file in Excel by double clicking on it or opening first Excel and then opening the DMAIC Suite V2 english.xlsx file in Excel. The DMAIC Suite contains 15 worksheets. All worksheets come with prefilled data provided for example.
What to do first when working with the DMAIC Suite?
First thing that we recommend you to do is to save as the DMAIC Suite file onto your computer under a different name and keep the original DMAIC Suite V2 english.xlsx file as a backup.
Then you will have to clear all the prefilled data and start to fill the columns with your data. In case of data existing in another excel file, we recommend to copy and paste special values these existing data in the DMAIC Suite model.
For your information, all the blue cells are protected cells. All the white cells are not protected and you can input your data in them. Protected blue cells cannot be erased but they can be formatted and for those which contain formulas, the formulas are visible.
VSM Calculator:
Quickly calculate the data from a VSM session. Value stream analysis is one of the easiest methods to analyze a process and identify areas that can be improved. Aside from the working template is a completed template to use as a sample illustration. It includes the associated graphs generated from the tool.
What do you get when ordering the VSM Calculator?
Once you order and pay the VSM Calculator, you will be directed to a Download directory where you will find the VSM Calculator v6 zip file to download to your computer.
First download the file "VSM Calculator v6.zip" to your computer.
Then you will need to unzip this downloaded zip file (usually done by double clicking on it).
Finally you will get one excel file named "VSM Calculator v6.xlsx"
You can open the VSM Calculator v6.xlsx file in Excel by double clicking on it or opening first Excel and then opening the VSM Calculator v6.xlsx file in Excel. VSM Calculator v6.xlsx comes with prefilled data provided for example and a blank template.
What to do first when working with the VSM Calculator v6.xlsx?
First thing that we recommend you to do is to "save as" the VSM Calculator v6.xlsx file onto your computer under a different name and keep the original files as a backup.
For your information, all the blue cells are protected cells. All the white cells are not protected and you can input your data in them. Protected blue cells cannot be erased but they can be formatted and for those which contain formulas, the formulas are visible.
DFSS Basic tools:
This set of excel tools will bring you a DFSS scorecard, a Quality Functional Deployment and a Pugh Matrix. Specially designed for Black Belts and Green Belts completing DFSS DMADV projects.
The DFSS Basic tools are an Excel set of DFSS tools for lean green belt and black belt projects.
This set of excel tools will bring you a DFSS scorecard, a Quality Functional Deployment and a Pugh Matrix. Specially designed for Black Belts and Green Belts completing DFSS DMADV projects.
What do you get when ordering the DFSS Basic tools?
Once you order and pay the DFSS Basic tools, you will be directed to a Download directory where you will find the DFSS Basic tools zip file to download to your computer.
First download the file "DFSS Basic tools.zip" to your computer.
Then you will need to unzip this downloaded zip file (usually done by double clicking on it).
Finally you will get three excel files named "DFSS scorecard V4.xlsx", "QFD v2.xlsx", "Pugh matrix v2.xlsx" on your computer in a DFSS Basic tools directory.
You can open one file in Excel by double clicking on it or opening first Excel and then opening the xlsx file in Excel. All files come with prefilled data provided for example and a blank template.
What to do first when working with the xlsx files?
First thing that we recommend you to do is to "save as" the xlsx files onto your computer under different names and keep the original xlsx files as a backup.
For your information, all the blue cells are protected cells. All the white cells are not protected and you can input your data in them. Protected blue cells cannot be erased but they can be formatted and for those which contain formulas, the formulas are visible.
OS Compatibility: Windows, OSX (Apple), Linux since 2012
Excel compatibility: with all excel supporting xlsx format (since 2010 version)
Equable solutions bundle (The DMAIC Suite, VSM Calculator, DFSS Basic tools)
 Brands Equable Solutions
 Product Code: sw_bdle_0002
 Availability: In Stock
 $257.00

$227.00
 Ex Tax: $227.00

 5 or more $207.00
 10 or more $197.00
 20 or more $187.00
 50 or more $177.00
 100 or more $167.00
 500 or more $157.00
Related Products
Tags: DMAIC Suite Multilanguage bundle license for a training class