Lean Six Sigma Tools and Templates in Excel

QI Macros Fill in the Blank Templates and Tools for Lean Six Sigma
home · products · services · search · view cart · contact

NAVIGATION

Shopping cart

0 Product(s) in cart

Total $0.00

> Checkout

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Does it seem too hard to draw the non-chart portions of your Lean Six Sigma Project such as:

Drawing flowcharts and ishikawa diagrams?
Adding data from month to month to control chart dashboards?
Advanced analysis like GageR&R, DOE, and so on?

The QI Macros Templates simplify all of these tasks.

The QI Macros Contain Over 80 Fill in the Blank Templates and Tools for all your Lean Six Sigma and SPC Needs.

To Open a Chart or other Template:

1) Choose "Fill-in-the-Blanks Templates" from the QI Macros pulldown menu and select from any of the charts (e.g., SPC-c Chart) tools or other templates listed (e.g., flowcharts, fishbones, etc.)

Fill in the blanks menu in Excel 2003 and earlier versions

Lean Six Sigma tools menu

Fill in the blanks menu in Excel 2007-2010

Lean Six Sigma tools menu Excel 07

2) Just type or paste data into the chart template. Most input areas are shaded in yellow.

3) Use Excel's drawing toolbar to insert boxes, arrows and other symbols onto templates like flowcharts and fishbones.

View Fill in the Blanks Templates Tutorial - 16 minutes

Here is a list of the Fill in the Blanks Templates, Tools and Charts in the QI Macros with links to more detailed articles.

Planning Tools	Improvement Tools
Action Plan Affinity Diagram Arrow Diagram Balanced Scorecard (Tree) Blue Ocean Strategy DPMO Six Sigma Calculator Gantt Chart L, T, X Shaped Matrix Mind Mapping Project Charter Rolled Throughput Yield Calculator ROI Calculator SIPOC Stakeholder Analysis Targets and Means Matrix Transition Planning Tree Diagram Voice of the Customer	8D Report (Ford) A3 Report (Toyota) Action Plan Block Diagram Checksheet Cost of Poor Quality Matrix Cost of Quality Countermeasures FMEA and EMEA Fault Tree Flowchart Force Field Analysis Hazard Analysis Ishikawa Fishbone Diagram Measurement Matrix Non-Parametric Tests Pareto Chart PDPC Chart Test of Proportion QI Story Relationship/Systems Diagram Risk Assessment Matrix Sample Size Calculator Time Tracking Tree Diagram
Flowcharts and Fishbones	AIAG and ISO
Block Diagram Fault Tree Flowchart Ishikawa Fishbone Diagram Tree Diagram Value Stream Map	Control Plans Failure Prevention Analysis Template FMEA , DFMEA and PFMEA Gage R&R with range method, anova method, bias, linearity, and attribute Gage R&R study PPAP Forms Pre Control Chart Uncertainty ISO 17025
DFSS, DOE, MSA	Lean Tools
Design of Experiments (Plackett-Burnham 2-3-4 Factor and Taguchi 4-8-16) FMEA , DFMEA and PFMEA Gage R&R range method, anova method, bias, linearity, and attribute Pugh Concept Selection Matrix QFD House of Quality	Lean Scorecard Lean Takt Time and NVA Time Tracking Tool Value-Added Analysis Value Stream Map Yamazumi Chart
SPC Control Charts	Project Management Tools
Attribute Control Charts c chart template np chart template p chart template u chart template g chart template c, p, u, np dashboard Variable Control Charts XmR dashboard XmR Four Pak XmR + USL, LSL, Target XmR 30000-foot X bar R X bar S X Median R Options within most control chart templates: Center Line Based on Average Center Line Based on Median Templates to Handle Rolling Data Short Run Control Charts Templates for Horizontal Data Control Chart with Fixed or Historical Control Limits	Action Plan Affinity Diagram Arrow Diagram Checksheet Cost of Poor Quality Matrix Cost of Quality Design of Experiments Flowchart FMEA and EMEA Earned Value Management Formulas Gantt Chart Ishikawa Fishbone Diagram Measurement Matrix Resource Matrix ROI Calculator SIPOC Stakeholder Analysis Time Tracking Tool Tree Diagram Voice of the Customer Work Breakdown Structure
SPC Charts Other Control Charts	SPC Charts - Other Charts
Cusum EWMA M Chart Moving Average Hotelling T2 Individuals Levey Jennings QC Chart PreControl Chart q chart Short Run Control Charts t chart template	Cp, Cpk Template Histogram Box and Whisker Plot Pareto Chart Probability Plot ROC Curve Run Chart Scatter Plot Diagram Speedometer Chart Target and Line Chart Tornado Chart Youden Plot

The QI Macros SPC Software for Excel has five parts:

Over 30 charts including histograms, pareto charts, scatter plots, box whisker plots and all variable and attribute control charts. Just select your data and then click on the QI Macros menu and select the chart you want to run.
Over 80 Fill-in-the-blank templates and tools including fishbones, FMEA, DOE, Gage R&R, PPAP forms and more.
Statistical tools including Anova, f-test, t-test, regression, data normality test, sample size calculator and more.
Data Transformation tools to help organize and analyze your data including stack and restack, and WordCount and PivotTable Wizards.
Automated Control Chart Dashboards - just drop your data into these pre-formatted templates.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Try QI Macros
FREE
For 30-Days

QI Macros Fill in the Blank Templates and Tools for Lean Six Sigma

Does it seem too hard to draw the non-chart portions of your Lean Six Sigma Project such as:

The QI Macros Contain Over 80 Fill in the Blank Templates and Tools for all your Lean Six Sigma and SPC Needs.

The QI Macros SPC Software for Excel has five parts: