Download.com Shuttlecock
  • Navigation
  • open search
Close

PLATFORMS

POPULAR LINKS

CATEGORIES

HELP & SETTINGS

QI Macros SPC for Excel

$229
Download Editors' Rating:
Editors' Rating:
Spectacular
Average User Rating:
out of 5 votes out of 0 votes

Quick Specs

  • Version:
    2016.09
  • Total Downloads:
    45,880
  • Date Added:
    Sep. 21, 2016
  • Price:
    Free to try (30-day trial); $229.00 to buy (Buy it now)
  • File Size:
    10.83MB
  • Downloads Last Week:
    47
  • Platform:
    Windows
  • Product ranking:

Editors' Review

+

QI Macros SPC Software for Excel allows you to analyze data in a variety of formats, including histograms with Cp and Cpk, Pareto charts, scatter plots, box whisker plots, and all variable and attribute control charts.

Since this program integrates itself into Microsoft Excel's interface, you should have no problem using it. It appears as an extra tab at the top of your Excel window. The tab itself is broken into seven categories: Statistical Tools, Fill-in-the-Blanks Templates, Data Transformation, Capability Charts, Control Charts, Improvement Charts, and Other Charts. Each transforms your inputted data for the best analysis. We entered random numbers into the cells of our spreadsheet and tested the macros by clicking through the options. The g chart function quickly placed our random numbers into a chart, complete with built-in macros and a graph that changed with our data. We then took those same numbers and clicked the Box Whisker chart option. Again, the program placed our numbers into an attractive chart that graphed our entered data. The program doesn't include a Help feature through its interface, but it does offer assistance through its Web site, should you need it. Despite not being too familiar with some of the chart concepts, we were still able to quickly jump in and see our data come to life.

QI Macros SPC Software for Excel installs and uninstalls cleanly. We highly recommend this handy macros program for anyone in need of a way to display and analyze data.

 
read more +

Publisher's Description

+
 
read more +
User Reviews
+

Results 1–5 of 5

5 stars

"Excellent quality analysis tool for Excel"

April 10, 2015  |  By lmconsulting

2015-04-10 11:08:40  |  By lmconsulting

 |  Version: QI Macros SPC for Excel 2015.01

Pros

Integrated with Excel
Reasonable cost
Lots of features
Easy to use (once you understand the terminology)
On line training and tutorials

Cons

Doesn't replace the need to understand quality metrics.
Can be a little overwhelming for quality newcomers, but there are tutorials to help.

Summary

I have been using QI Macros for over 10 years at multiple companies. For Excel users the tool creates multiple charts and graphs, plus it has templates and examples for items like Gage R&R and FMEA. Definitely a must have if you're doing data analysis or involved with quality metrics.

Reply to this review

Was this review helpful? (0)   (0)  

5 stars

"Amazing product"

March 10, 2015

2015-03-10 10:23:28

 |  Version: QI Macros SPC for Excel 2015.01

Pros

Saves time, very effective

Cons

can't think of any

Reply to this review

Was this review helpful? (0)   (0)  

5 stars

"QI Macros is easy to use"

February 19, 2014  |  By smarthu

2014-02-19 09:57:25  |  By smarthu

 |  Version: QI Macros for Excel 2013.06

Pros

The product is easy to install and to use; it's a good alternative to Minitab and uses Excel and your own data. You can redo the charts as many times as needed. There are Control Charts, Histograms and other Capability Analysis tools, Anova and other statistical tools. It has a couple of wizards.
And, the website has tons of information (do a search for whatever chart or information you need) and a support page.

Cons

The product may contain more charts/templates than you need, but you can pick-and-choose which ones you need and which you don't.

Summary

There is a free trial if you go to the website.

Reply to this review

Was this review helpful? (0)   (0)  

2 stars

"Lots of tools, much too complicated and no support"

December 20, 2013  |  By sking114

2013-12-20 07:48:16  |  By sking114

 |  Version: QI Macros for Excel 2013.06

Pros

There are pros to this excel add-in. There are tons of statistical tools that can you can use on your data sets and it makes things like correlation analysis a breeze.

Cons

Where to begin...
1 - First off there is no instruction manual. They include a 2 page description of some of the tools on their website but that is about it. With over 50 tools in the package it is very difficult to find which one you need. Additionally, if you have any concerns about how the calculations need to be set up or are taking place there is no way to check (add-in encrypted in VBA).
2 - No support: Since there was no manual I had to call QIMacros multiple times to ask a simple question (Are blank cells counted as zeros or not included), and was told "THEY AREN'T SURE BECAUSE THEY AREN'T STATISTICIANS", WHAT??
3 - Not a great output: once you do figure out how to use the product (without any help from QIMacros), the organization and output of the macro is rough at best.

Summary

Overpriced, under explained, no support because staff doesn't understand product.

Overall QIMacros is a nice stat package for excel but at $229 it is overpriced due to the fact that you won't be able to use 90% of the tools in a business setting (without knowing any of the underlying calculation/assumptions) and while there is tech support the staff do not have enough technical training or knowledge to help.

Also, most people will probably only use QIMacros for one or two of the tools (I usually just use the correlation function) and the macros they have programmed are nothing special. My advice is, unless you are a statistician and plans on investing lots of time on the phone trying to understand the product, make you own table or spreadsheet. It'll save you $230, allow you to be confident in your calculations, allow you to have a cleaner output, and you may learn useful information for the future.

Reply to this review Read reply (1)

Was this review helpful? (0)   (0)  

5 stars

"10 out of 10"

December 08, 2010  |  By nirmalmthp

2010-12-08 00:18:49  |  By nirmalmthp

 |  Version: QI Macros SPC Software for Excel 2010.9

Pros

Just awesome.Can't compare any other excel templates with this.

Cons

None..except for.........

Summary

I am using this product since 4 years and am loving its easy interface.

Reply to this review

Was this review helpful? (1)   (1)  

Results 1–5 of 5

Add Your Review

Login or create an account to post a review.

You are logged in as . Please submit your review for QI Macros SPC for Excel
Add Your Review

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

Update Your Review

Since you've already submitted a review for this product, this submission will be added as an update to your original review.
Submit

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

 
see all reviews +

Full Specifications

+
What's new in version 2016.09
Version 2016.08:
  • Enhanced Data Mining Wizard - creates a pivot table of data, and generates an XmR chart and defect Paretos with one click.
  • Pass - Fail Cp Cpk calculator added to Capability Templates
  • Fever Chart added to Diagrams
  • Frequency Polygon added to Compare 2 Histograms template
  • Test data is now accessible from the QI Macros help menu
  • Added OEE template to the Rolled Throughput Yield Calculator
  • Sample Size Calculator expanded; separate calculators for attribute data and variable data.
General
Publisher KnowWare
Publisher web site http://www.qimacros.com/
Release Date August 01, 2016
Date Added September 21, 2016
Version 2016.09
Category
Category Business Software
Subcategory Spreadsheet Software
Operating Systems
Operating Systems Windows NT/XP/2003/Vista/7/8/10
Additional Requirements Microsoft Excel 2000 to 2016 or Office 365
Download Information
File Size 10.83MB
File Name qimacros-30-day-trial.exe
Popularity
Total Downloads 45,880
Downloads Last Week 47
Pricing
License Model Free to try
Limitations 30-day trial
Price $229

Previous Versions:

Add to my list Report a problem
 
read more +
Close[x]

Submit a problem report for QI Macros SPC for Excel

Please describe the problem you have with this software. This information will be sent to our editors for review.

Problem:

The Download.com Installer isn't working as expected

The download link does not work

The software has a newer version

The product contains malicious software

Other

Description:

Please select a feedback type.

Please enter a description.

Submit Problem Report

Close[x]

Problem Report submitted

Thank you for submitting a problem report! The Download team is committed to providing you with accurate software information.

OK