CHARTrunner Lean® vs QI Macros® Comparison
Trying to Decide Between CHARTrunner Lean and QI Macros?
Many customers are trying to decide if they should choose the QI Macros or CHARTrunner Lean®, but that should be a nobrainer. CHARTrunner Lean® 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 
$1290 + $395/yr maintenance 
$349 USD 
User Interface / Ease of Use: 
Fill in a form technology 
Pointandclick 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® Menus of Options
Chart Then Data: 
QI Macros Data then Chart: 
QI Macros Wizards to Do Much of the Work for You 


CHARTrunner Lean® 
QI Macros® 
Control Chart Wizard 
N 
Y 
Pivot Table Wizard 
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® 
QI Macros 
Variable Control Charts: Individuals, Moving Range, XmR, XbarR, XBarS  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 Whisker , Multi Vari, Dot Plot, Values Plot  N 
Y 
Scatter Plot, Matrix Plot, Hotelling T2 Charts, Radar, Spider Charts  N 
Y 
Pareto Chart 
CHARTrunner Lean® But its just a bar chart with no cumulative line 
QI Macros 
Multiple Pareto Charts at once  N 
Y 
Statistical Analysis Tools 


CHARTrunner Lean® 
QI Macros 
Test of Variances: Anova One Way, Anova Two Way Without Replication, Anova Two Way With Replication fTest, Levene's Test 
N 
Y 
Test of Means: ttest One Sample, ttest TwoSample Assuming Equal Variances, ttest TwoSample Assuming Unequal Variances, ttest Paired TwoSample for Means, ztest TwoSample for Means, Two OneSided Test for Equivalence 
N 
Y 
Tests of Relationships 
N 
Y 
NonParametric Tests 
N 
Y 
Other Statistical Tests and Info 
N 
Y 
FillintheBlank Templates 

SPC Chart Templates  N 
Y 
Lean Tools Value Stream Map, Flowchart, Lean Takt Time and NVA, Time Tracking Tool, ValueAdded 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  Gage R&R: ANOVA and XBarR methods 
Requires purchase of Gagepack® $1,490+$295/yr maintenance 
Y 
Design of Experiments PlackettBurman designs 
Requires purchase of DOEpack® $990+$245/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 + $295/yr maintenance 
$349 USD 
SQCpack® (additional) 
$990+$295 

Gagepack® (additional) 
$1,490+$295 

DOEpack® (additional) 
$990+$295 

Mikel Harry, the guru of Six Sigma, says that the next wave of Six Sigma benefits will come from white and yellow belts saving $1020,000 per year.
To do so, these people will need an easytouse 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?