Home » QI Macros » CHARTrunner Lean® Compare

CHARTrunner Lean / SQC Pack® vs QI Macros® Comparison

Trying to Decide Between CHARTrunner Lean / SQC Pack and QI Macros?

Many customers are trying to decide if they should choose the QI Macros or CHARTrunner Lean / SQC Pack®, but that should be a no-brainer. CHARTrunner Lean / SQC Pack® costs a lot more and does a lot less.

SPC Software Comparison Table (PDF, 304 KB)

Big Differences	CHARTrunner Lean® / SQC Pack®	QI Macros®
Price	$1,290 + $395/yr maintenance	$369 USD
User Interface / Ease of Use: See this step by step comparison	Fill in a form technology	Point-and-click technology.
Learning Curve	Days	Minutes
Application	Stand Alone you have to "retrieve" data from Excel or Other Data Sources	Excel Addin, which means you can work on your data directly in Excel.
Data and Chart Selection Most users have data BUT don't know which chart to use.	CHARTrunner Lean / SQC Pack® Menus of Options Chart Then Data: CHARTrunner Lean® requires users to choose a chart first then define the data source and fields.	QI Macros Select Data, then Wizard Data then Chart: QI Macros Wizards analyze the data and select the right chart for you.

QI Macros Wizards to Do Much of the Work for You
	CHARTrunner Lean / SQC Pack®	QI Macros®
Control Chart Wizard Chooses the Right Control Chart automatically	N	Y
Pivot Table Wizard Automates analyzing data	N	Y
Statistical Wizard runs all of the appropriate statistical tests for your data and interprets the results	N	Y
Statistical Process Control (SPC Charts)
	CHARTrunner Lean / SQC Pack®	QI Macros
Variable Control Charts: Individuals, Moving Range, XmR, Xbar-R, XBar-S	Y	Y
Capability Suite - Six Charts in One: X Chart, Range Chart, Histogram, Probability, Capability Plot, Values Plot	N	Y
Median Control Charts	N	Y
Levey Jennings Control Charts	N	Y
Short Run, Cusum, EWMA and Moving Average Charts	N	Y
Run Charts	Y	Y
Atrribute Control Charts: p, np, c, u	Y	Y
Rare Events Control Charts - g chart, t chart	Y	Y
Control Chart Dashboards to create multiple control charts at once	N	Y
Histograms with Cp, Cpk, Pp, Ppk	Y	Y
Other Variation Charts: Box and Whisker , Multi Vari, Dot Plot, Values Plot	N	Y
Scatter Plot, Matrix Plot, Hotelling T2 Charts, Radar, Spider Charts	N	Y

Pareto Chart

See larger comparison images

CHARTrunner Lean / SQC Pack®

chartrunner pareto chart

But its just a bar chart with no cumulative line

QI Macros

pareto chart excel

Multiple Pareto Charts at once

Statistical Analysis Tools
	CHARTrunner Lean / SQC Pack®	QI Macros
Test of Variances: Anova One Way, Anova Two Way Without Replication, Anova Two Way With Replication f-Test, Levene's Test	N	Y
Test of Means: t-test One Sample, t-test Two-Sample Assuming Equal Variances, t-test Two-Sample Assuming Unequal Variances, t-test Paired Two-Sample for Means, z-test Two-Sample for Means, Two One-Sided Test for Equivalence	N	Y
Tests of Relationships Chi-square Contingency Table, Chi-square Goodness of Fit, Correlation, Covariance, Descriptive Statistics,Exponential smoothing, Fisher Exact Test, Multiple Regression Analysis	N	Y
Non-Parametric Tests 1-sample sign test, Friedman test, Kolmogorov-Smirnov (K-S), Kruskal-Wallis test, NonParametric Tests Overview, Mann-Whitney test, Mood's Median, Sign Test, Spearman test, Tukey Quick Test, Wilcoxon Signed Rank Test, Wilcoxon Rank Sum Test	N	Y
Other Statistical Tests and Info Hypothesis testing, Moving average, Normality Test, Rank and percentile, Sample Size Calculator, Test of a Proportion, Test of Two Proportions	N	Y
Fill-in-the-Blank Templates
SPC Chart Templates	N	Y
Lean Tools Value Stream Map, Flowchart, Lean Takt Time and NVA, Time Tracking Tool, Value-Added Flow Analysis, Yamazumi Chart	N	Y
Lean Six Sigma Project Templates 8D Report (Ford), A3 Report (Toyota), Action Plan, Cost of Poor Quality Matrix, Countermeasures Matrix, Flowchart, Ishikawa Fishbone Diagram, Earned Value Management Formulas, Gantt Chart, Resource Matrix,ROI Calculator, SIPOC, Stakeholder Analysis, Voice of the Customer, Work Breakdown Structure	N	Y
MSA Gage R&R, DOE, FMEA etc
Measurement Systems Analysis - per AIAG MSA 4th Edition Gage R&R: ANOVA and XBar-R methods Attribute Gage Study - AIAG long method Gage linearity and bias	Requires purchase of Gagepack® $1,490+$395/yr maintenance	Y
Design of Experiments Plackett-Burman designs Taguchi designs General full factorial designs Fractional Factorial	Requires purchase of DOEpack® $990+$395/yr maintenance	Y
Failure Modes and Effects Analysis: FMEA, PFMEA, DFMEA, MFMEA	N	Y
APQP Checklists, Control Plan, PPAP Forms, QFD House of Quality	N	Y
Price	$990 + $395/yr maintenance	$369 USD
SQCpack® (additional)	$990+$395
Gagepack® (additional)	$1,490+$395
DOEpack® (additional)	$990+$395

Mikel Harry, the guru of Six Sigma, says that the next wave of Six Sigma benefits will come from white and yellow belts saving $10-20,000 per year.

To do so, these people will need an easy-to-use tool belt for data analysis. Don't miss this opportunity.

Isn't it time you gave all of your employees the benefits of the QI Macros for Excel?