|
Jay Arthur
888-468-1537
303-756-9144
KnowWare
International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224
We work with companies
that want to fire up their profits using
Lean Six Sigma
Copyright © 2011
|
|
In 2006, the QI Macros celebrated its 10th anniversary.
The QI Macros have changed a lot over those ten + years, but one thing hasn’t
changed. That is our commitment to providing affordable, accurate, easy to use
SPC software to quality and process improvement personnel in varying industries.
Click here to compare the
QI Macros ease of use with Minitab Some people confuse affordable with
cheap. They then take the next leap from cheap to unreliable. It just isn’t so
with the QI Macros. Here’s why. How can we keep our prices so low?
The QI Macros is an add-in for Microsoft Excel. Therefore, we let Excel
do all of the heavy lifting. We don’t have to create and maintain a separate application.
We also keep our overhead low. We don’t have a huge in-house sales staff
or fancy offices and you certainly won’t ever attend a conference where the QI
Macros is a platinum sponsor. How do we make sure the QI Macros are
accurate?
The QI Macros were developed and are maintained using
the methodology in Jay Arthur's three books on software development and maintenance:
- Rapid Evolutionary Development (Wiley 1992)
- Software Evolution - The
Software Maintenance Challenge (Wiley 1998)
- Software Quality (Wiley 1994)
QI Macros output is validated using the following methods:
- Validated by manual calculations
- Validated against textbook examples
- Validated against other software
The QI Macros Software
Development and Testing ProcessRequirements - come from three sources:
- Customers
Most of our best ideas come from customers.
We track requests from our technical support line, from our website comment forms
and through direct conversations with customers. Customers requesting new
functionality are asked to help us identify a resource for the requested calculations
that is generally accepted and well known in their industry. - Statistical
and Quality Textbooks
QI Macros formulas and test data come from
well known and generally accepted text books and publications. Resources used
to validate and verify our formulas and results include: - Juran's Quality
Control Handbook (4th), McGraw Hill, NY, 1988.
- Douglas Montgomery, Introduction
to Statistical Process Control (4th), John Wiley & Sons, NY, 2001.
- Montgomery
Instructor Companion Site includes Data Sets Referenced in Montgomery's book
- Douglas
Montgomery, Design and Analysis of Experiments (5th), John Wiley & Sons, NY,
2001.
- Engineering
Statistics On Line Handbook
3. Standards Bodies for
Various Industries We monitor standards bodies for various
industries. When these bodies come out with new requirements they are incorporated
into the QI Macros. Examples of these groups include: -
Joint Commission on Accreditation for Healthcare Organizations (JCAHO)
- Automotive
Industry Action Group - http://www.aiag.org/Index.cfm. AIAG resources used include:
- Statistical Process Control (SPC) 2nd edition, AIAG, 2005
- Measurement
Systems Analysis (MSA) 3rd edition, AIAG, 2002.
- Production Part Approval
Process (PPAP), 4th edition AIAG, 2006
- Advanced Product Quality Planning
and Control Plan, AIAG, 1995
- Potential Failure Mode and Effects Analysis,
3rd edition, AIAG, 2001
Development
The QI
Macros are written in VBA. Releases occur on a monthly basis and include new functionality,
performance enhancements and bug fixes. Testing
Unit and System Test: All changes to individual macros and templates
are unit tested by a separate department. Regression Testing: All
changes to the macros and templates are regression tested through Excel 95-2007
in both Windows and the Macintosh environments.
Test Data:
The QI Macros are validated using the test data provided with the software. The
QI Macros setup file loads this data on your computer at c:\qimacros\testdata.
Each test file specifies the book reference (Juran's Quality Handbook or
Montgomery's Intro to SPC) used for validation. Gage R&R template was verified
against AIAG MSA Version 3. The QI Macros have been independently verified
by several healthcare and manufacturing organizations. Validation
Data and Expected Test Results We used a subset of the test data mentioned
above to create a validation test file. You can download the validation data set
and expected QI Macros results with comparisons to Minitab and other resources
at the following links: Formulas - QI Macros
formulas can be viewed at http://www.qimacros.com/formulas.html Technical
Support - Users can contact us about technical questions in a variety of ways:
- On-line - View our tech support page and frequently asked questions
at http://www.qimacros.com/techsupport.html
- Call
888 468 1537 or 303 756 9144 - Monday thru Friday between 8:00 am and 5:00
pm Mountain time
- Email support@qimacros.com
- please attach a spreadsheet of your data and the QI Macros results.
Questions
regarding the QI Macros are always free. However, we charge a $95 fee for Excel
and SPC coaching (up to 1/2 hour). Bugs
If you find a bug,
we will fix it and send you a corrected file at no charge. 21 CFR 11Compliance
- see http://www.qimacros.com/21cfr11.html Download
a pdf version of this web page at QI
Macros Software Validation Statement |
|
QI Macros Software Validation
Statement Try QI Macros
FREE
For 30-Days
|
view cart · contact 
view cart | contact