 |
     
| SPC for MS Excel |
|
Affordable
& Easy!
All you
need to quickly create and update SPC charts in Excel.
|
|
 |
SPC for MS Excel is used internationally including:
 |
Argentina
|
|
Australia
|
|
Austria
|
|
Belgium |
|
Brazil
|
|
Canada
|
|
Chile |
|
China
|
|
Columbia |
| Costa
Rica |
|
Denmark
|
|
Germany
|
|
Hong Kong |
|
Hungary |
|
Iceland |
|
India |
|
Indonesia
|
|
Ireland
|
|
Israel
|
|
Italy
|
|
Japan
|
|
Malaysia
|
|
Malta
|
|
Mexico
|
|
Netherlands
|
| New
Zealand |
|
Nigeria |
|
North
Korea
|
|
Norway
|
|
Peru |
|
Philippines |
|
Puerto Rico
|
|
Republic
of
Korea
|
|
Russia |
|
Saudi
Arabia |
|
Singapore
|
|
Slovenia |
| South
Africa |
|
Spain
|
|
Sri
Lanka
|
|
Sweden
|
|
Thailand
|
|
Turkey
|
|
United
Arab Emirates
|
|
Uganda
|
|
United Kingdom
|
|
United States
|
|
Vietnam |
|
Yugoslavia
|
|
|
For Excel 2000, 2002, 2003 and 2007!
See videos of how the program works below
or by clicking here!
The following questions are answered in detail
below.
SPC for MS Excel is used to generate and easily update
SPC
charts and to perform other statistical functions from Microsoft Excel spreadsheets. This affordable
software is easy to learn and easy to use and fits the needs
of the SPC novice or SPC expert. It is the
premier Excel-based SPC program. We have reached this
position by listening to what our users say they need.
This product has been used around the world for more than a
decade. Countries include the United States, Canada,
Mexico, United Kingdom, Ireland, Spain, Greece, Hong Kong, Turkey,
Indonesia, and Vietnam. It is a key part of many manufacturing and
service organizations process improvement efforts.
Return
to top of page
Anyone who uses
Excel to analyze data - green belts, black belts, quality
professionals, quality assurance, front-line personnel,
supervisors, quality control, controllers, engineers,
laboratory personnel -- anyone who wants to improve their data
analysis!
"As a Six Sigma Black Belt I have
used this great tool to support the completion of numerous
projects. It is versatile as well as highly
capable. This version has phenomenal enhancements that
will make stronger analytical tools available to anyone with
Excel."
-Walt Wilson
Six
Sigma Master Black Belt
Wal-Mart
Stores, Inc.
(see full quote)
Return
to top of page
- Easy to use.
Easily update existing charts. Simply
enter the new data on the spreadsheet and, in two clicks,
the chart is updated. Plus, you have the option
update all charts in the workbook at the same
time. View video
(same as c control chart in 1 above).
Change (split) control limits multiple times
within the same chart by selecting the point and, in two
clicks, the chart is updated with split limits. View Video
Start the control chart at
a new point on the chart by selecting the point and, in
two clicks, the chart starts at a new point. View
Video (same as 3)
Delete (and add back) a
point from the calculations but keep the point on the
chart. View video
Add or delete a comment to
a point on the control chart. View video
(same as 5)
Delete (or add back) all
points beyond the control limits but keep the points on
the chart. View video
(same as 5)
Add, delete, or change a target line to the
chart (for example, the nominal) to see how close the
average is to the target. View video
Regression analysis to
determine which independent variables (the Xs)
statistically impact the dependent variable; plus an easy
method to remove unwanted variables. View
Video
And much, much more as
described below.
Return
to top of page
The following SPC tools and
options are included in the software:
|
Pareto
diagrams
(View
Video)
 |
Available
with or without cumulative percentage lines
|
|
Ability
to determine the frequencies automatically
|
|
Ability
to construct the Pareto from one column of data
|
|
|
Histograms
(View
Video)
|
Easily
change the number of classes
|
|
Add
descriptive statistics if desired
|
|
|
Attribute
Control Charts
|
|
Variable
Control Charts
|
Xbar-R
charts
(View
Video)
|
|
Xbar-s
charts
|
|
Moving
average & moving range Charts
|
|
Individual
charts
|
|
Run
charts
|
|
Ability
to make subgroups of any size from a column of data
|
| Ability
to make multiple individuals charts at once (View
Video) |
|
Option
to display Xbar chart only, Xbar and range charts on
separate sheets, or Xbar and range chart on same sheet |
|
Automatic
checking for trends and option for trend control chart
(View
Video)
|
|
|
Process
Capability
|
Cp,
Cpk, Pp, and Ppk
(View
Video)
|
|
%
out of specifications
|
|
Normal
curve on top of histogram with USL, LSL and nominal
|
|
One-side
specification limits
|
|
Descriptive
statistics
|
|
Removal
of outliers
(View
Video)
|
|
Ability
to make multiple process capability charts at once
(View
Video)
|
|
Ability
to set specification limits based on data
|
|
Option
to add +/- three sigma limits to the chart
|
|
|
Scatter
Diagrams (View
Video)
|
With
or without line regression using linear, logarithmic, polynomial, power
or exponential
|
|
With
or without regression line on chart
|
|
Ability
to add labels to each point
|
|
|
Measure
Systems Analysis
| Average
and Range Method to generate the classical Gage
R&R report with the following chart options: (View
Video)
 |
Averages
charts – stacked and unstacked |
|
Range
charts – stacked and unstacked
|
|
Run
chart by part
|
|
Scatter
plots
|
|
Whiskers
charts
|
|
Error
charts
|
|
Normalized
histograms
|
|
X-Y
Plots
|
|
Range
charts for each operator
|
|
Operator
bias chart
|
|
Operator
consistency chart
|
|
|
ANOVA
Method that includes:
|
ANOVA
table
|
|
Residuals
plot
|
|
ANOVA
Gage R&R report
|
|
|
Range
Method for Gage R&R
|
|
Bias
Method – Independent Sample Method
|
|
Bias
Method – Control Chart Method (checks Stability
also)
|
|
Linearity
Method
|
|
Attribute
Gage R&R that includes:
|
Effectiveness
table (attribute Gage R&R report)
|
|
Crosstabulations
|
|
Kappa
values
|
|
|
|
Cause
and Effect Diagrams
|
Easily
add items to the diagram
|
|
|
Transfer
Charts to Word and PowerPoint
|
Easily
move charts to these other applications with one click
|
|
|
Descriptive
Statistics
|
Mean,
standard error, median, mode,
standard deviation, sample variance,
kurtosis, skewness, range,
minimum, maximum, sum, and count for
a set of data
|
|
|
Confidence
Interval Around a Mean
|
Sets
the upper and lower confidence limits for the mean of
a set of data
|
|
|
Confidence
Interval Around a Variance
|
Sets
the upper and lower confidence limits for the variance
of a set of data
|
|
|
Confidence
Interval for the Difference in Two Means (View
Video)
|
Determines
if there is a statistical difference in the means of
two data sets
|
|
|
Confidence
Interval for Multiple Processes
|
Determines
if there a statistical difference in the means of
multiple processes
|
|
|
Paired
Sample Comparison
|
Determines
if there is a statistical difference in the means of
two processes that run the same sample
|
|
|
Analysis
of Means
|
A
graphical and statistical way of comparing k
treatments means with the overall mean.
|
|
|
Correlation
Coefficients
|
Determines
the linear association between two or more variables
|
|
|
Failure
Mode and Effect Analysis
|
Template
is used to determine the potential failure modes of a
process and the associated risk priority numbers
|
|
|
Box and
Whisker Plots (View
Video)
|
Presents
a visual representation of how data is spread out and
how much variation there is in the data. |
|
|
Sample
Size Selector
|
Determines
the sample size needed for a given probability and
error |
|
|
Chart
Selector
|
Helps
you determine what type of chart to use based on the
data you have |
|
| Multiple
Linear Regression Analysis
|
Determines
which independent variables statistically impact the
dependent variable; easy to remove insignificant
variables (View
Video) |
|
Helps
model the process |
|
Includes
residuals data, residuals plots, and line fit plots
for each independent variable (View Video) |
|
Return
to top of page
Other features include:
| It is very easy to make new charts - anyone can use this
program - extensive knowledge of Excel or SPC is not
required. |
| You enter only the raw data; all calculations done by
the program. |
| The program automatically checks for out of control
situations (points beyond the limits, zones tests and rule
of seven tests). |
| Out of control points are in red. |
|
It is
easy to update existing charts with new data.
|
|
Easily
change any options on any of the charts and remake the
chart
|
|
Single
Point Action (select a point on the chart) and
|
Split
control limits at any point on the chart
|
|
Delete
(or add back) any point from the calculations while
keeping the point on the chart
|
|
Start
the chart at a new point
|
|
Add
(or delete) a comment to a point on the chart
|
|
|
All
Point Action
|
Delete
(or add back) all points beyond the control limits
from the calculations while keeping the points on the
chart
|
|
| Select
the range to base your average and control limits on |
Return
to top of page
To see examples of the types of charts the SPC program
generates, you can either:
Download a workbook containing examples of the SPC tools
(except for the measurement systems analysis tools) in
the program
and
Download a
workbook containing examples of the Measurement Systems
Analysis portion of the program
or
View some of the examples from the workbooks on the internet
Return
to top of page
User support is provided directly by us. This includes the person
who developed and upgrades the software and knows it inside
and out. We will provide the answers you need to effectively
use the program - all at no cost.
Return
to top of page
Enhancements to the program are done on a regular basis -
often from suggestions from users. Want the software to do
something else? Simply ask. In many cases, it can be done and
done quickly. Revisions between major upgrades are available
at no cost.
Return
to top of page
Yes, we do have a demo.
The demo is a full-working version of the program that you can
use for 10 days. The videos available here on the
website provide a great way of seeing how the software
works. The demo allows you to actually try the software
out.
Return to top of
page
The software will run on any PC that will run Excel.
Excel 2000, Excel 2002, Excel 2003 and Excel 2007 are supported.
The
software itself is less than 3.0 MB in size.
Return
to top of page
The cost of the software for a single user (one computer) is
only $149. You can order SPC for MS Excel on-line using a credit card (Visa, MasterCard,
Discover or American
Express) or a purchase order number. With a credit card,
you can download the software immediately!
For pricing for multiple users, please contact us or click
below to see our attractive price discounts for multiple users.
|
|
|
