|
© 2007 KnowWare
International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224
Jay Arthur
888-468-1537
303-756-9144
Email Us
We help people think!
|
|
Excel macros for Six Sigma, SPC and ISO
The QI Macros for Excel includes 20 excel macros. Excel macros
include pareto charts, control charts (c, np, p, u, XmR, XbarR, XbarS),
/qiws, scatter plot diagrams, box and whisker plots and more. The control
chart excel macros calculate stability analysis and the /qiw excel
macros calculate Cp and Cpk for capability analysis.
The QI Macros installs a new pull down menu on your Excel toolbar. To
run an excel macro simply click and drag over your data to select it,
and then select the excel macro you want to run from the QI Macros pull
down menu.
In addition to excel macros, the QI Macros for Excel also includes over
60 fill-in-the blanks excel templates.
Here's what you get for $139:
You get all these Charts
|
Plus 70+ "Fill in the Blank" Templates |
Plus Statistical Tools |
|
Control Chart Wizard: Selects the correct
chart based on your data.
Control Charts with
Stability Analysis
Histograms with Capability
Analysis - Cp, Cpk
Box & Whisker Plot
Multivari Chart
Dot Plots
Multivariate Analysis
Other Charts
Run Chart - average and median
Pareto Chart
Line Graph
Bar Chart
Pie Chart
Includes QI Macros
Help File for each chart and tool.
|
- Action Plan
- Affinity Diagram
- APQP tools for AIAG ISO/TS 16949: Control
Plan, PFMEA, DFMEA
- Arrow Diagram
- Balanced Scorecard
(Tree)
- Block Diagram
- Checksheet
- Control Plans for ISO/TS
16949 APQP
- Control Charts for SPC requirements
(e.g., ISO/TS 16949)
- Attribute:
c, np,
p, u,
g, q
charts
- Variable:
Cusum, EWMA,
Moving Average,
XmR (individuals), XbarR,
XbarS and XMedianR
charts with histogram and
normal probability plot (also includes short run templates).
- Histogram
- Cost of Quality
- Countermeasures
- Cp, Cpk Template
- Design
of Experiments (Plackett-Burnham 2-3-4 Factor and Taguchi 4-8-16)
- Failure Prevention
Analysis Template
- Fault Tree
- Ishikawa Fishbone
Diagram
- Flowchart
- Force Field Analysis
- FMEA , DFMEA
and PFMEA for APQP
- Gage
R&R (for ISO/TS 16949 MSA) with range method, anova method,
bias, linearity, and attribute Gage
R&R
- Gantt Chart
- MSA -
Measurement Systems Analysis using Gage R&R
- Non-Parametric Testing
- PFMEA
- PPAP Templates for AIAG ISO/TS 16949
- PDPC Chart
- Pre Control Chart
- Pugh Concept Selection Matrix
- QFD
House of Quality
- Relationship/Systems Diagram
- ROC Curve
- ROI Analysis
- Targets and Means
- Time Tracking
- Transition Planning
- Tree Diagram
- Value-Added Analysis
- Value Stream Map
- Voice of the Customer
|
|
|
Plus Data Analysis Tools
|
|
QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H
© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home
| Lean Six Sigma
| QI Macros
| KnowWare
| Site Map
|
Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee
The QI Macros for Excel $139,
is an inexpensive easy to use set of Excel add-ins for statistical process control
and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp,
Cpk), scatter and control charts (with stability analysis).
It contains over 70 fill in the blank templates such as the Ishikawa diagram,
QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test,
and regression analysis.
Quantity Discounts
Customer Testimonials
Minitab Comparison
QI Macros FAQs
|
