Skip to main content

Data structuring and preparation

Updated over a week ago

Effortless DOE data alignment and processing in Synthace

Aligning experimental metadata with your measurements—especially when working across multiple plates—can be both tedious and error-prone. Synthace’s Prepare Data app takes the hard work out of this, so you can spend more time interpreting results, not wrangling spreadsheets.


Pivot replicate data points into insight-ready formats

By reshaping your dataset into wide format—pivoting replicates, drugs, or other factors into their own columns—you unlock richer analytics. This structure simplifies calculations like mean, stdev, or Z′ factor, and lets you assess assay quality or experimental controls at a glance—all without manual pivoting.


You can learn more about data reshaping here.


Use built-in data transformations

Calculations like averages, variability, or control comparisons are critical to understanding your DOE. Synthace brings these right into the pipeline—mean, standard deviation, variance, Z′ factor, even custom calculations—so you get results immediately, in context, and with no need for external tools.

You can learn more about using pre-defined data calculations here.

You can learn more about creating custom calculations here.


How to continue your analysis journey in Synthace

Finishing data prep isn’t the end—it’s the launchpad. One click on Start Analysis opens the Response Analysis app and preserves your version. You can smoothly iterate, explore model fits, and visualise results—all within Synthace’s empowered DOE workflow.

Learn more about response analysis and model fitting here.


How to export data for third‑party analysis

Need advanced modeling—like split-plot analyses, high-order interactions, or nonlinear fits? Export your polished dataset to .xlsx for off-line analysis.

Your data remains beautifully structured, ready for downstream tools like R, Python, or JMP.

To export the table shown in the data section in XLSX format, click Download selected columns.


Performing plate‑based blocking

Synthace checks your design to see whether it is split across multiple plates, and if so, adds a blocking factor to represent this. This factor is given the name “Plate Blocking ID” and is automatically selected when you structure your DOE data.

A blocking factor, called Plate Blocking ID, has been added to the data to allow for plate-based effects to be accounted for in the analysis.

Currently, blocking factors to account for plate-based effects are the only blocking factors supported by Synthace. There are two situations where the plate-based blocking factor is not added to the data. The first is when Synthace detects that another design factor correlates with the plate. This may be the case when you have split a design across multiple workflows using a design factor. In this scenario, Synthace will display a warning message with a list of the factors that correlate with the plate used:

The second situation where Synthace will not add a blocking factor is when you have arranged replicates into columns. Checking the “Arrange replicates into column” option will cause the plate-based blocking factor to be disabled:

For more information about why blocking factors are important to consider and how blocking factors impact your analysis, click here.

Did this answer your question?