A Timetable Organizer for the Planning and Implementation of Screenings in Manual or Semi-Automation Mode

Abstract

We have designed an Excel spreadsheet to facilitate the planning and execution of screenings performed manually or in semi-automation mode, following a sequential set of events. Many assays involve multiple steps, often including time-sensitive stages, thus complicating the proper implementation to ensure that all plates are treated equally to achieve reliable outcomes. The spreadsheet macro presented in this study analyzes and breaks down the timings for all tasks, calculates the limitation in the number of plates that suit the desired parameters, and allows for optimization based on tolerance of time delay and equal treatment of plates when possible. The generated Gantt charts allow for visual inspection of the screening process and provide timings in a tabulated form to assist the user to conduct the experiments as projected by the software. The program can be downloaded from http://sourceforge.net/projects/sams-hts/ .