Part 1 - DOE design, simulation, execution, and data upload.
Getting started
Open Synthace and navigate to the Tutorials page
Select Tutorial Data preparation for DOE analysis
Open the workflow “📊 Data Preparation Improvements”
Make an editable copy
Simulating and executing your workflow
Add your copied workflow to a new experiment
Toggle into DOE mode
Click “Design” and then “Upload Design”
Scroll down to review the Settings
Then, "Simulate with Design" to generate your simulation
⏱️ Please be patient, there are several runs in the design.
Review the simulation by clicking "View Simulation"
When ready, click "Start Execution"
Download instructions for your execution
Once executed, mark as complete with any relevant comments
Uploading and preparing your results
⬇️ Scroll to bottom of this article and download the linked results file 🖇️ "Data prep tutorial_response.xlsx"
Navigate to the Results tab in your execution
Click "Add file" to add your results file, then from “Computer”
Select "Another Device" when prompted for parsing options
After uploading data to each DOE plate, click "Structure DOE data"
Part 2 - Preparing data, structuring, transforming and launching Response Analysis
Introduction
This section will walk you through the process of structuring and analyzing your Design of Experiments (DOE) data using Synthace's enhanced data preparation features. By following these steps, you'll be able to efficiently organize your data, perform calculations, and prepare it for comprehensive analysis.
DOE Prepare data interface
The DOE Prepare Data interface contains three main tabs: Reshape, Calculate, and Review
➡️ If your data is already properly structured, you can proceed directly to the Review tab
Step 1: Reshape your data
Here you'll find guidance about restructuring your data from a long to wide format table using the values from selected columns.
Select the columns you wish to use for reshaping your data:
Choose "Control Type" to pivot your data by control categories (e.g., Positive, Negative)
Select "Replicate" to further organize your data by replicate number
After selection, your data will be automatically pivoted showing response values organized by your selected parameters (e.g., "Control Type Negative Replicate 1-12" followed by "Control Type Positive Replicate 1-12")
Step 2: Calculate statistical parameters
Navigate to the Calculate tab
Review the introduction and instructions for this section
Choose from preset transformations:
Calculate the Mean of your Positive and Negative response:
Choose Mean from the transformation menu
Select Control Type Negative
Optional: Edit the column header
Click "Apply" to add the calculated column to your data table
Repeat with Control Type Positive
Calculate the Standard deviation of your Positive and Negative response:
Choose Standard deviation from the transformation menu
Select Control Type Negative
Optional: Edit the column header
Click "Apply" to add the calculated column to your data table
Repeat with Control Type Positive
Calculate the Z-factor:
Choose Z-factor from the transformation menu
Select your Control Type Negative (negative controls)
Select your Control Type Positive (positive controls)
💡 Note: this calculation automatically includes the mean and standard deviation calculations for both control types and adds them to your data table
Click "Apply" to add these calculated columns to your data table
Calculate the Signal to background ratios for Mean and Standard deviation:
Choose Column-based arithmetic from the transformation menu
Step 1: Add a name for the response e.g, “Mean Signal/Background”
Step 2: Choose Response from the drop-down
Step 3: Enter an equation to calculate the new column
Scroll down and click on “mean(Response - Control Type Positive)”
Do not alter the text within the { } braces
Add the operator for division (backslash) /
Scroll down and click on “mean(Response - Control Type Negative)”
Click “Evaluate equation” to generate the new column
Click "Apply" to add the calculated column to your data table
Repeat for Standard Deviation
Save your work as a draft by clicking the "Save Draft" button to preserve your progress
Step 3: Review your structured data
Move to the Review tab to see all columns that will be available for analysis
Review the data to ensure all necessary parameters are included
Optional: Download selected columns
Step 4: Launch Response Analysis
When you're satisfied with your data preparation, click the "Start Analysis" button
This will launch the Response Analysis app, where you can perform in-depth analysis of your DOE results
💡 Save drafts frequently to prevent losing your work
𝚺 Take advantage of the preset transformations to quickly calculate common statistical parameters
👀 Review the guidance provided in each tab if you're unsure about any step in the process
By following these steps, you'll be able to efficiently prepare your DOE data for comprehensive analysis, allowing you to identify significant effects and build predictive models to guide your next experiments!