• Equable solutions bundle (The DMAIC Suite, VSM Calculator, DFSS Basic tools)

This bundle is made of three products: The DMAIC Suite, VSM Calculator and DFSS Basic tools.


The DMAIC Suite is a statistical multi-languages* 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: I-MR 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:
    • I-MR control card
    • Xbar-R control card
    • Xbar-S 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 pre-filled 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 pre-filled 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 pre-filled 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 pre-filled 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)

Write a review

Note: HTML is not translated!
    Bad           Good

Equable solutions bundle (The DMAIC Suite, VSM Calculator, DFSS Basic tools)

  • $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

The DMAIC Suite (Multi-language)

The DMAIC Suite (Multi-language)

The DMAIC Suite is a statistical multi-languages* application under the form of an Excel file with w..

$179.00 $199.00 Ex Tax: $179.00

VSM Calculator (English)

VSM Calculator (English)

The VSM Calculator is an Excel tool for lean green belt and black belt projects.Quickly calculate th..

$29.00 Ex Tax: $29.00

DFSS Basic tools (English)

DFSS Basic tools (English)

The DFSS Basic tools are an Excel set of DFSS tools for lean green belt and black belt projects.This..

$29.00 Ex Tax: $29.00

The DMAIC Suite (Multilanguage) demonstration version

The DMAIC Suite (Multilanguage) demonstration version

The DMAIC Suite is a statistical multi-languages* application under the form of an Excel file with w..

$0.00 Ex Tax: $0.00

Tags: DMAIC Suite Multi-language bundle license for a training class