QI Macros for Excel SPC Software Upgrades

home · products · services · search ·  view cart · contact  
 
  NAVIGATION        
 
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar

2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2008

 



  Check your version date:
  1. Put the QI Macros installation CD in the appropriate drive.
  2. Click on "My Computer" and then double click on the floppy disk or CD icon
    (If you downloaded from the internet, search for pcsetup.exe)
  3. Right click on the "QI Macros setup.exe" or pcsetup.exe file and select "Properties".
  4. The date on the setup file is the date your version was created.
    If the date is less than six months old, you don't need a new version. If the date is over a year old, you might want to consider upgrading to take advantage of the new features shown below.
October 2008

QI Macros and templates
Enhancements:

September 2008

QI Macros and templates
Enhancements:

  • APQP 2nd edition updates of control plan, check list and checksheet
  • Control chart wizard - comma/decimal fix for International versions of Excel
August 2008

QI Macros and templates
Enhancements:

June 2008

QI Macros and templates
Enhancements:

May 2008

QI Macros and templates
Enhancements:

March 2008

QI Macros and templates
Enhancements:

  • Show Process Change - allows more than one change per chart.
  • PPAP - added input sheet for data common to all forms such as part name, part number etc.
  • Pull down menu and error messages translated to various foreign languages.
February 2008

QI Macros and templates
Enhancements:

  • Macros - chart sheet name is automatically populated to match the chart title
  • Help files and user guide translated to various foreign languages.
January 2008

QI Macros and templates
Enhancements:

  • Regression Analysis - Added multiple regression analysis. First columns are X, last column is Y.
  • Box Whisker chart - allows negative values now
December 2007

QI Macros and templates
Enhancements:

  • Hidden Rows and Columns - in the data selection were used in chart macros in previous versions. This change enables them to be omitted from the chart.
  • Probability Plot template - added Half Normal Probability Plot
November 2007

QI Macros and templates
Enhancements:

October 2007

QI Macros and templates
Enhancements:

September 2007

QI Macros and templates
Enhancements:

  • All variable charts - update to enable charts to handle cells with blank data
August 2007

QI Macros and templates
Added:

Created uninstall.exe file to more easily uninstall the software or 30 day evaluation copy

July 2007

QI Macros and templates
Added:

Classic 2003 menu for Excel 2007 users - to ease the transition to the new 2007 ribbon

Install file now identifies multiple versions of Excel on your PC and asks which version you want to load the QI Macros on.

June 2007

QI Macros and templates
Added:

Multivariate Analysis

QI Macros Help file - descriptions and instructions for using each tool

May 2007

QI Macros and templates-
Added:

Corrected bug in box and whisker formula (QI Macros 2007 version only).

April 2007

QI Macros and templates-
Added:

Corrected run time error when some International versions closed Excel.

February 2007

QI Macros, templates and menu-
Completely rewritten in VBA to support Excel 97-2007 including the new "ribbon" interface.
Added:

October 2006

QI Macros -
Histogram enhancement - allow more than 50 classes.
Performance enhancement - speed up XmR chart macro.

September 2006

QI Macros and templates-
Updated PPAP Forms per 4th edition errorata sheet published by AIAG.
Gage R&R deleted acceptability % in cell C44 since it is no longer needed.
Performance enhancement - consolidated stability analysis code for all control charts.

August 2006

QI Macros -
Fixed comma-decimal point problem for international users in Germany.
Enhanced # of bars calculation in Histogram.
Fixed chi-squared calculation.

July 2006

QI Macros and templates-
Upgraded Balanced Scorecard Template
Fixed comma-decimal point problem for international users in Poland.
Added LinkTranspose Macro to allow paste-link and transposition of data. Excel won't do this.

June 2006

QI Macros templates-
Added Scatter and Youden Plot templates

May 2006

QI Macros -
Upgraded Histogram macro

April 2006

QI Macros templates-
Upgraded PPAP and FMEA templates to 4th Edition

March 2006

QI Macros -
Upgraded Control Chart Wizard to work with split columns of data.

February 2006

QI Macros -
Efficiency Upgrade to QI Macros to speed up starting Excel. Reduced number of macro files from 19 to 1.

Upgraded templates and added links to training documentation on website.

January 2006

QI Macros -
Added Value Stream Mapping Template
Added Version Information
Removed rounding from histograms

December 2005

QI Macros -
Fixed Sample Size Calculator
Fixed p & u charts for long file names

November 2005

QI Macros - Control Chart Wizard
Don't know what control chart to choose? That's why we added the Control Chart Wizard. Just select your data, click on the Control Chart Wizard and it will analyze your data and choose the best chart based on your data's sample size and integer or decimal format.

October 2005

QI Macros and Templates
Added XMedianR chart to the macros.
Upgraded p and u charts for AIAG SPC 2nd

Added ROC Curve Templates

September 2005

QI Macros Templates
Added Time Tracking Template

August 2005

QI Macros and Templates
Added enhanced descriptive statistics to the Anova tools.

July 2005

QI Macros and Templates
Maintenance enhancements to Normal Probability Plot

Added 1 sample t test and additional descriptive statistics to Anova and Analysis tools.

GageR&R - added Analytic Attribute Method

May 2005

QI Macros and Templates
Maintenance enhancements to Histogram and Frequency Histogram to allow blank data fields

April 2005

QI Macros and Templates
Maintenance enhancements to XmR, GageR&R and other templates

March 2005

QI Macros and Templates
Maintenance enhancements to PPAP and other templates

Converted to Windows 32-bit installer to prevent installation problems in Windows XP.

February 2005

QI Macros and Templates
Added non-parametric (not normally distributed) analysis templates for:

  • 1-sample sign test
  • Sign Test
  • Friedman
  • Kruskal-Wallis
  • Kolmogorov-Smirnov
  • Mann-Whitney
  • Spearman
  • Wilcoxon
January 2005

QI Macros and Templates
Added sigma estimator (SIGMAave/c4) for subgroup sizes > 10 to:

  • Histogram macro
  • Frequency histogram
  • XbarS template
December 2004

QI Templates
Added PPAP templates for AIAG PPAP Third Edition

  • Appearance Approval Request
  • Supplier Checklist/Approval
  • Supplier Request for Engineering Approval
  • Interim Recovery Worksheet
  • Engineering Source Approval
  • Part Submission Warrant
  • Production Part Approval - Dimensional Results
  • Production Part Approval - Material Test Results
  • Production Part Approval - Performance Test Results
  • Design Matrix
  • Bulk Material Interim Approval

Fixed GageR&R UCL/LCL display problem.

November 2004

QI Templates
Added ROI Calculator using lifetime value of the customer, defect rates, and other key indicators to calculate ROI for improvements.

October 2004

QI Templates
Added Levey Jennings Chart template.

September 2004

QI Templates
Added Short Run XbarR, XmR, c, np, p, u chart templates.

Fixed Regression tool to allow for multiple regression. (One column for Y, multiple columns for X).

August 2004

QI Templates
Added and p values to the GageR&R Template
Lean manufacturing (Takt Time and NVA)

Fixed number of decimals bug in Histogram macro.

June 2004 QI Templates
Added Z scores and p values to these templates:
  • Probability Plot
  • Histogram
  • XmR
  • XbarR
  • XbarS
Fixed number of bars bug in Histogram.
Changed Regression Analysis to match data order of the Scatter diagram.
May 2004 Added the following templates:
April 2004 Added the following templates:
March 2004 Added the following capabilities:
February 2004 Added the following templates:
  • Pareto chart
  • Run and XmR charts with target lines
  • Speedometer chart
  • Quality costs worksheet for prevention, appraisal, and failure costs
January 2004
  • Added SIPOC worksheet and u
  • Upgraded histograms to allow users to add data without redrawing the chart
October 2003

Added ability to rerun Stability Analysis on Control Charts.

Added Gantt Chart

Note: Current version of QI Macros have been tested with Office 2003 and work perfectly.

May 2003

Added Sample Size calculator using confidence levels, limits and standard deviation.

Apr. 2003

Added Anova, Regression, t-Test, and other statistics for hypothesis testing.
Added tolerance calculations to the GageR&R template (QS 9000 MSA Version 3).

Mar. 2003

Added histogram, probability plot, and scatter plot to XmR, XbarR, and XbarS templates.

Dec. 2002

Automated adding data to existing control charts

Oct.. 2002

Upgrade for Windows 2000 bug that causes QI Macros to appear on the toolbar twice.

Sept. 2002

International Version Available for all languages.

Aug. 2002

Added Run Chart macro

July 2002 Multiple Control Limits for comparing several sets of data in the c, np, p, u, XmR, XbarR and XbarS charts
June 2002 Gentable macro added to convert matricies of any size to any other size
March 2002 Probability Plot Template for analyzing distributions
January 2002 GageR&R upgrade with bias, linearity, and Anova
Sept. 2001 Cusum Chart
August 2001 Stability Analysis added to control charts
June 2001

Box and Whisker Chart

May 2001 Excel XP compatibility upgrade
March 2001 QI Macros Training CD-ROM
November 2000 Design of Experiments L4, L8, L16
May 2000 Gage R&R template
April 2000 Multivari Chart
March 2000 InstallWizard simplies installation
February 2000 Control charts: Added 1,2 sigma lines for stability analysis
December 1999 Scatter Chart: Added Trend line
August 1999 XbarS chart added
  Histogram: added normal curve
December 1998 Excel 2000 compatibility upgrade
October 1998 XmR Trend chart added
May 1998 Histogram Cp, Cpk, Pp, Ppk
March 1998 Excel 97 Upgrade

Find out more about the QI Macros For Excel SPC Software or

QI Macros Upgrade - Download with backup CD and user guide (#232) $69 + S&H
QI Macros Upgrade - Download Only - No Shipping or Customs Duties (#W232) $69
QI Macros - Download with backup CD & User Guide (#230) $139 + S&H
QI Macros - Download Only - No Shipping or Customs Duties (#W230) $139

 

 

 

If you own an older version of the QI Macros, order an upgrade. Note: You need one upgrade for each license you own.

QI Macros Upgrade - Download with backup CD and user guide (#232) $69 + S&H
QI Macros Upgrade - Download Only - No Shipping or Customs Duties (#W232) $69

 

If you don't own a copy of the QI Macros order a new copy.

QI Macros - Download with backup CD & User Guide (#230) $139 + S&H
QI Macros - Download Only - No Shipping or Customs Duties (#W230) $139

 

View Quantity Discounts

QI Macros 30-day Trial &
FREE Lean Six Sigma Course
Name:
E-mail
 
home | products | services | search | Shopping cart  view cart | contact