Platemaker Wizard Data Analysis Tutorial

This tutorial video provides a comprehensive walkthrough of the Bensonium Platemaker Wizard, a powerful Excel Add-in designed to streamline microplate data analysis for life science and drug discovery researchers.

Using the included template “Ovarian Cancer Screen Demonstration”, the tutorial guides users through building the full Demonstration Workbook that ships with the software. It covers importing assay data using the Wizard’s generic import function, followed by a step-by-step analysis using core statistical tools.

Key features demonstrated include:

• Creating Z’-prime tables for assay quality assessment
• Generating heat maps and statistical summary tables using the Wizard’s built-in analysis functions
• Exporting formatted data directly to GraphPad Prism for visualization and downstream analysis

The video also includes a second example focusing on a time course experiment, illustrating how to handle sample and experimental repeats within the same workflow.

Additional sections cover:

• Data cleaning functions for removing outlier or faulty plate data
• Enhancing the workbook with a hyperlinked index and a custom image gallery page, ideal for integrating microscopy or high-content screening (HCS) images

Whether you’re analyzing screening data or preparing figures for publication, this tutorial is ideal for scientists seeking an efficient, Excel-based microplate data analysis solution.

Topics Covered in this video

Time Stamp	Topic
1:22	Container Workbook Structure
4:14	Building a Workbook
7:52	Importing Data
15:35	Adding a Z’ Page
18:26	Cleaning Data (Part 1)
24:43	Adding Heat Maps
29:11	Adding a Statistical Summary Table
37:43	Generate Prism Graphs
50:52	Cleaning Data (Part 2)
1:02:56	Updating the Prism Graphs
1:09:38	Time Course Experiment Example
1:11:45	Second Data Import Example
1:13:32	Statistical Summary Table for Time Course Experiment
1:17:34	Generating Time Course Graphs for Individual Experiments
1:22:43	Generating Time Course Graphs for the Mean of 3 Experiments
1:27:45	Adding an Index and other pages to your First Tutorial Workbook