Compare SPC XL to QI Macros® for Excel

QI Macros Wins on Price, Ease of Use, and Features

QI Macros Wins on Price

SPC XL by itself and QI Macros prices are fairly similar. However, you will need to spend more to get these features with SPC XL.

  • Snapsheets XL - Starts at $49 to get Quality Function Deployment, FMEA, and Pugh Concept Generation
  • NPC XL - starts at $79 for nonparametric tests for non-normal data and small sample sizes.
  • DOE Pro XL - add $126 for design of experiments (may contain features not in QI Macros.)

Quantity

QI Macros®

SPC XL

SPC XL Bundle

with DOE Pro XL

Snapsheets XL and NPC XL

Total*

1

$249 USD

$249 USD

$375

$49 + 79 = $128

$503

2 to 4

$219

$249

$375

$49 + 79 = $128

$503

5 to 10

$219

$229

$375

$49 + 70 = $119

$494

11 to 20

$199

$209

$375

$45 + 65 = $110

$485

* Prices as of 08-10-2018

QI Macros is a technically reliable and very cost effective solution for our college; and very intuitive to use. The performance of this Excel add-in compares very well to other software that costs much more.

- Truett
Adjunct Instructor, Quality Manager


QI Macros is Easier to Use Than SPC XL - Here's Why:

 

QI Macros

SPC XL

Foundation it Was Built On

Clean Sheet

Mimics Minitab

First Step to Create a Chart:

Select the Data or the Chart?

 

Select Data

Analyze Data and Select Chart

qimacros Make Calculations and Draw Chart

Analyze Data and Select Chart

Point to Data

qimacros Make Calculations and Draw Chart

Why It Matters

Most users have data BUT don't know which chart to use.

qi macros is easy to use

choose control chart

QI Macros is a fantastic tool. It allows me to do things that once took 30-60 minutes down to 2-3 minutes. It's also very user-friendly and easy to operate.

- Wade Johnson
Carlson Craft Business Solutions

Ease of Use Step-by-Step Comparison

QI Macros

SPC XL

1. In Excel, select your data

create spc chart step 1

1. In Excel, select the chart you want.

spcxl select control chart

2. Click on QI Macros Menu and select the desired chart or the Control Chart Wizard if you are not sure.

qimacros-step2-xmr

2. Define the data range in your spreadsheet.

spcxl define data range

3. QI Macros will do the math and draw the chart for you.

create spc chart step 3


 

3. Here is where it gets ugly.

You have to define up to seven different items like numerator, denominator, data labels, chart title, etc. In comparison, the QI Macros contain code to determine most of this for you.

Here is where it gets ugly. You have to define various control chart options and how you want the control limits to be calculated.

 

4. QI Macros gives you more time to focus on the chart and what it tells you.

4. SPC XL will do the math and draw the chart for you.

As you can see, there is a complicated additional step to achieve the same result. And, as we know from Lean, extra steps mean additional chance for error and more importantly: delay.

Most people find step 3 confusing.
How do I select my data? What column do I select to do what? Does it really need to be this hard?

QI Macros Charts Look Better and Are More Comprehensive

QI Macros Chart Examples

Pareto Chart

Bars over 20% of the total are shaded.
Bars have no space between them.
Cumulative line shows percent from 0% - 100%

Box and Whisker Chart

Second and Third Quartiles are distinguished using colors.
Shows all outliers.

SPC XL Chart Examples

Pareto Chart

spc xl pareto chart

No special shading of bars. Bars have space between them.
Cumulative line doesn't show percentages
Cumulative line does not extend through the chart as it should.

Box and Whisker Chart

spc xl box plot

Second and Third Quartiles within the box are the same color.
Does not show outliers as suggested by most SPC texts.

QI Macros Features Not in SPC XL

Wizards to Automate Data Analysis and Select the Right Charts or Statistical Tests

Because QI Macros has you select your data first, it can help you analyze it and run the right chart or test. SPC XL and other competitors CANNOT do this since they make you select the chart first.

  • Data Mining Wizardcombines the power of the pivottable and control chart wizards to turn a table of raw data into the first steps of an improvement story with just one click
  • Chart Wizardchooses and runs all possible charts from your data
  • Control Chart Wizardchooses and runs the correct control chart from your data
  • Statisticschooses and runs all possible hypothesis tests
  • PivotTable - shortcut to Excel Pivottables - just select up to four columns of data and we organize your pivot table for you

I was very well impressed with the functionality of QI Macros Data Mining Wizard. This certainly saves time and cuts down the chart populating process substantially. I will be recommending this tool to my colleagues here at work and within the ASQ leadership community.

- Data Analyst
Medical Device Manufacturer 

Automated control chart dashboards: 

Just drop your data sets into the data input sheet and click on the "Create Charts" macro button to create a control chart dashboard for all of your measures.

Fill-in-the-blank chart templates: 

QI Macros contain more than 40 chart templates including all attribute and variable control charts, pareto, scatter, box whisker charts, histograms and more. Just drop your data into the yellow input area and your charts are built in the same spreadsheet.

Every two weeks I have to update 600 control charts for more than 30 hospitals in our system. I used to spend three days updating these charts. Once we created the charts using QI Macros Control Chart Dashboards, and utilized automation including stability analysis, we reduced the time it takes to update the charts to just three hours. QI Macros Control Chart Dashboards save me valuable time that I can use for other important projects. Thanks for making this process quicker and easier. 

- Mary Ayuso
Adventist Health System

No matter the criteria - QI Macros come out on top.

Purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!