The CSV analyzer is a macro that takes your DOE data and translates it into a series of reports so that you can study the effects of the variables you have selected on the quality criteria you have identified. The CSV analyzer is not localized and will appear in English regardless of which language pack you have installed.
The CSV analyzer is a macro that takes your comma delimited spreadsheet file (*.csv) and converts the data into tables and graphs so you can analyze the data more readily. The data is presented in a series of tabs at the bottom of the spreadsheet. The first tab, called Data, presents all the data recorded during the DOE analysis.
Note: Make sure that you run both the initial analysis and the DOE analysis on the same software version. If you import a study with existing results into a different software version, and subsequently run a DOE analysis, the DOE results will not be comparable.
| Terminology |
Definition |
|---|
| Number of Factors |
The number of variables selected in the DOE Builder |
| Number of Qualities |
The number of qualities selected in the DOE Builder |
| Number of Runs |
The number of runs performed during the DOE analysis to produce the relevant data |
| Number of Terms |
The number of terms in the response surface equations used. |
- Experimental data
- This section contains two tables.
- The first table lists the variables you selected and records the value of each variable on every run.
- The second table lists all the quality criteria you selected, and the value of each quality criterion under the variables conditions listed for each run.
This information can be used to investigate the results shown in the analysis logs, and determine which values are having a significant impact on the results.
- Response surface equations
- This section contains two tables.
- The first table lists the variables you selected in the DOE Builder, and provides the power of that variable for that term in the response surface equation.
- The second table provides the value of the quality for each term of the equation.
These data and how they relate to the response surface equation can be seen in each of the Quality tabs.
- Design of experiments
- The DOE analyzer uses a linear equation to model the significant effects of the various variables you selected. The levels are coded by -1 for a low level and +1 for the high levels. This section provides a single table which lists the 'coded' values for each variable you selected in the DOE Builder for each run. The corresponding actual values can be found in the Experimental data table, or in the Quality tabs.
After analyzing the data and selecting an optimum set of operating conditions, it is important that you run an analysis under these optimum conditions to verify the results.
Note: You can open the .csv data file directly, without applying the CSV analyzer macro, by navigating to the location that you defined for saving project data, when you installed this program, and double-clicking on the .csv file. The default path for Windows 7 is My Documents\My ASMI 20xx Projects.