Workbooks for DoE design and analysis of results for:
* Response surface designs, Central composite design for 2 or 3 factors and Box-Behnken for 3 factors
* D-Optimal designs when there are too many factors or levels and too few runs to make a standard design
* Fractional designs with 2 to 8 factors, 4 to 16 runs + centre points

A basic understanding of statistical designs of experiments is highly recommendend



Files to download:
Response_surface_1.3.xlsm (Excel)
Response surface designs with 2 to 3 factors Central Composite design and 3 factor Box-Behnken design
Uploaded: November 12, 2024

D-Optimal-design1.0.xlsm (Excel)
Workbook for input and analysis of D-Optimal designs. To be used together with the CAT software, please see the manual
Uploaded: October 13, 2025

DOE_R4_1.0 (Excel)
For designs with 2 to 3 factors, 4 runs in basic design
The sheet "Input" is intended for our laboratory course and may be negleted
Updated: October 13, 2025

DOE_R8_1.0 (Excel)
For designs with 3 to 7 factors, 8 runs in basic design
The sheet "Input" is intended for our laboratory course and may be negleted
Updated: October 13, 2025

DOE_R16_1.0 (Excel)
For designs with 4 to 8 factors, 16 runs in basic design
The sheet "Input" is intended for our laboratory course and may be negleted
Updated: October 13, 2025


Documentation:
Manual for response surface (pdf)
Manual for Factorial and D-Optimal designs(pdf)
Manual for use of CAT for D-Optamla designs(pdf)
Tutorial for fractional designs(pdf)
Short manual
Minor differences in examples, because examples are from earlier versions

Trobleshooting (pdf)
Short manual for problems with the VBA Macros

Changelog:
Log of changes (word)


Home