Automating Tedious Functions

Many of our projects provide the same level of automation on the analysis side as on the production (and data-production) side. Data capturing and storage is easily automated and inexpensive. With JMP scripts, routine analysis can be just as automated and valuable.

This scripting project, from the bio-sciences sector, is just such an example. Using robotics and other automation equipement, our client effeciently produces samples (called "gels") but, until we developed a script, the analysis was time-consuming, tedious and expensive.

The script changes all that. It calculates differences in bio-activity (intensities) among pairs of "gels" from a set of between 20 and 30 gels (that's hundreds of comparisons that need to be made!). The script makes the comparison between a pair of gels, then sorts the results by difference and by ID and produces a report for each in JMP that can be saved as an RTF file and distributed to non-JMP users.

Creating a script to do this took less time than it takes to do one set of analysis. This script completes a set of 30 gels in seconds rather than hours (sometimes, days!).

Though the automated equipment that produces the bio-activity numbers produces the same column names, etc., the client requested this dialog box for clarification purposes. If all is in order, all the analyst needs to do is click OK.

Additionally, with the abov e dialog box, the analyst may occasionally decide to exclude some of the Series from the analysis.

This dialog box allows the analyst to determine how many hi-ranking differences to report (the default is 20), whether or not the reports should be saved and whether or not to close the data file.

Two reports are produced. One sorted by top differences, the other ordered by ID. The script arranges the reports so they are both easily identified and selectable for investigation.



 
© 2004-2008 Predictum Inc. - #506, 592 Sheppard Avenue West, Toronto, ON M3H 6A7 Canada
Tel: (416) 398 8900 info@predictum.com