Virtual Process
Virtual Process

This spreadsheet simulates a chemical process allowing the user to
"produce" batches of product and acquire the related quality measure
for each part.  Changes can be made to the Time, Temperature
Pressure and Concentration to improve the target or reduce variation.

This spreadsheet can be used for classroom instruction or individual
study.  The data can be used to perform many different types of
analysis including Capability Studies, Regression Analysis, Design of
Experiments (DOE) and others.

This spreadsheet is intended to generate only data. You must Copy
and Paste the results into another spreadsheet or software package
for analysis.
Features Include:

  • Variable inputs:
  1. Time
  2. Temperature
  3. Pressure
  4. Concentration
  • Slider controls for adjusting the inputs
  • A record of the quality measure for
    each batch
Quality Dimensions