Project Management

QI Macros SPC Add-in for Excel

QI Macros SPC Software for Excel

QI Macros is an easy-to-install Excel add-in for both PC and Mac.  It loads on Excel’s menu so you can use your data right in Excel instead of importing to a separate application.  Draws control charts, histograms, pareto charts and more. Contains Project Management Tool templates like Gantt chart, project charter, stakeholder analysis and earned value calculators. QI Macros functionality is comparable to Minitab software, but at a fraction of the price.

The software was developed from the ground up to work in Excel and deliver immediate results in business environments using Grab-It-And-Go Simplicity:

  • Mistake-proof data selection. Your data can be in connected or separated, rows or columns; QI Macros will clean up nonnumeric data, fix any misalignments and use your data as you selected it.
  • Control Chart Wizard to select the right control chart for you automatically.
  • Control Chart Dashboards to simplify monthly reporting.
  • PivotTable Wizard to simplify analyzing complex transaction files.
  • Mistake-proof statistical analysis (Excel can be picky and even produce invalid results if the data isn't selectefd correctly).

QI Macros will do all the math and statistics for you. There are no complex formulas to grasp or apply just charts and results.

Fill-in-the-blanks simplicity of the 100+ chart and documentation templates.

You don't have to waste time transposing or transferring your data from Excel to a separate program.  QI Macros works inside Excel, is easy to install, fast and efficient, and easy to understand.

Learn from your charts: extensive help links and documents are provided to help you learn and understand Six Sigma, Project Management techniques, and scientific statistics.

Provide reports for management and peers quickly and easily to forecast your results, solve problems, and provide information to management.

QI Macros output is validated using the following methods:

  1. Validated by manual calculations
  2. Validated against textbook examples
  3. Validated against other SPC software

For more detailed information see our software validation page.

Compare with Minitab: Click Here.

Who Uses It?

QI Macros were created in 1996. Based on customer input, we add new functionality all of the time. We have more than 100,000 customers in 80 countries. 

  • More than 3,000 hospitals use QI Macros to reduce medical errors and save lives.
  • Thousands of manufacturing companies use QI Macros to measure, monitor and mistake proof production.
  • Electronics companies use them.
  • Construction companies use them to monitor quality.
  • Food companies use QI Macros to monitor the quality and safety of their products from canned goods to raw chicken.
  • Aerospace companies use QI Macros.
  • The military uses QI Macros.
  •  Hotels use QI Macros to improve customer experience. 

Features of QI Macros for Excel

  • More than 40 charts you can draw in seconds using your own data, including paretos, control charts, histograms, box and whisker, scatter, and many more.
  • QI Macros is the only SPC toolkit that can choose the right chart automatically based on your data.
  • 100+ fill-in-the-blank templates for Lean Six Sigma tools like fishbones, flowcharts, Gage R&R, PPAP and SPC Charts.
  • Statistical Tools like ANOVA, Normality Test, F-Test, t-Test, Regression and more that make hypothesis testing and statistical analysis a breeze.
  • Data transformation tools - to help stack, restack, aggregate and analyze your data.
  • QI Macros is the only tool that includes a PivotTable Wizard to instantly aggregate line-by-line transaction data like ERP, error logs or financial data into actionable improvement stories.
  • QI Macros is the only tool that has a Word/Number Count Wizard that analyzes service rep comments to find pareto patterns in the notes.
  • Control Chart Dashboards for Monthly Reporting and Monitoring of Key Indicators-- just drop your data into these XmR, c, np, p, or u chart templates and click on the Create Dashboards icon.

 Compatible with PC (Excel 2010-2019 and Office 365, and Windows 7, 8 and 10) and Mac (Excel 2016, 2019, and Office 365, and OS X and macOS).  A 30-day trial is available for download on our website.

Categories

Agile
Application Lifecycle Management
Budgeting and Forecasting
Change Management (Version Control)
Collaboration
Document Management
Enterprise Portfolio Management
Expense Tracking
File Sharing
Issue Tracking
Metrics Tracking
Process Management
Professional Services Automation
Program Management
Project Accounting
Project Management
Project Portfolio Management
Reporting
Requirements Management
Resource Management
Risk Management
Scheduling
Service Management
Time Keeping
Workflow Management
Workforce Management

Features

Action Item Tracking
Approval/Workflow Management
Archiving Processes
Archiving Templates
Assignment Tracking
Benefits Documentation and Tracking
Best Practices Management
Billing & Chargeback Tracking
Budgeting & Forecasting
Change/Version Management
Collaboration
Custom User Interface
Customizable Fields
Customizable Functionality
Customizable Reporting
Data Import/Export to MS Excel
Data Import/Export to MS Project
Document Management
Email Integration
Estimating
Executive Dashboarding
Expense Tracking
Fault Management
File Sharing
Gantt Charting
Issue Management
Knowledge Management
Legacy System Integration
Methodology/Process Management
Metrics Management
Milestone Tracking
Mobile Access
Multi-Currency
Multi-Language
Percent-Complete Tracking
Pert Charting
Portfolio Management
Progress Tracking
Project Accounting
Project Estimating
Project Template Customization
Project Template Integration
Project Workflow
Quality Management
Records Management
Reporting (Financial)
Reporting (Progress)
Requirements Management
Resource Management
Risk Management
Scheduling
Software Development Kit
Task Management
Template Customization Support
Time Tracking
Total Cost Tracking
Workforce Management

Platforms

Linux/Unix
Mac
Open Source
Other
Software as a Service
Windows

Comments (1)

Login/join to subscribe
ADVERTISEMENTS

"Try not to have a good time...this is supposed to be educational."

- Charles Schultz

ADVERTISEMENT

Sponsors