During product development, reagent formulations for new sequencing platforms require multiple cycles of development, optimization, and robustness testing. The result? Significant amounts of data that need to be processed and compared using statistical analysis.

These data handling tasks are often tedious, time-consuming, and prone to copy-and-paste errors. Automation of the data processing workflow represents the ideal solution to those issues.

The Workflow Builder in JMP allows scientists with minimal programming experience to create their own scripts that automate otherwise repetitive data-handling workflows.

In this presentation, a reuseable script is created for the analysis of an example: the results of a plate-based enzyme assay. Use of column formulas, column stacking, non-linear (exponential) fits, and combined data tables are demonstrated live in conjunction with basic functions of the Workflow Builder. The final workflow is debugged in real time and modified to make the script reuseable and robust, using simple JSL elements such as variables, and the “Current Data Table” and “Pick File” functions.

The presentation culminates by showing how JMP scripts were leveraged to streamline data processing at Illumina, unlocking substantial time savings and faster insights for project development teams.