Spreadsheet DoE: A simple tool for optimising protein production and characterisation

Biochemical research often requires conditions to be optimised along the protein production and characterisation pipeline. However, the use of Design of Experiments (DoE) approaches for rapid process optimization presents a challenge due to statistical complexities and high software costs. To address this, Spreadsheet DoE is introduced as a  user-friendly tool for the design and analysis of 2-level factorial experiments by non-statisticians in an educational manner. Spreadsheet DoE provides step-by-step guidance and transparent calculations, eliminating the 'black box' experience typically associated with statistical tools with the goal of empowering student researchers to effectively employ DoE methodologies in their biochemical studies.

For E.coli protein expression optimisation, protein refolding optimisation and protein buffer stability optimisations or any other general protein production/characterisation optimisation, please consider sharing your DoE spreadsheet by sending the spreadsheet to: stollare@liverpool.ac.uk. This will contribute to a central database that will be made publically available through the author's university webpage in a future study.

For an associated article published in the Biochemist (Portland Press.org) related to this resource, visit here

For video tutorials on Spreadsheet DoE visit here that includes a short video showing the use of the 4.8 spreadsheet with the protein expression data used in the Biochemist publication. This example 4.8 spreadsheet is also deposited here.