Practical Pharmaceutical Laboratory Automation: 1st Edition (Hardback) book cover

Practical Pharmaceutical Laboratory Automation

1st Edition

By Brian D. Bissett

CRC Press

464 pages | 178 B/W Illus.

Purchasing Options:$ = USD
Hardback: 9780849318146
pub: 2003-05-23
$180.00
x
eBook (VitalSource) : 9780429211386
pub: 2003-05-23
from $28.98


FREE Standard Shipping!

Description

Laboratory automation is an increasingly important part of the job description of many laboratory scientists. Although many laboratory scientists understand the methods and principles involved in automation, most lack the necessary engineering and programming skills needed to successfully automate or interface equipment in the lab. A step-by-step, how-to reference and guide, Practical Pharmaceutical Laboratory Automation explores the processes needed to automate the majority of tasks required in research today.

The author discusses topics ranging from automated mathematical analysis to robotic automation of chemical processes, to combinations of these and other processes. He presents a detailed discussion of high throughput screening and assay development and takes an in-depth look at Visual Basic as the primary programming language used in laboratories. The text has a dedicated web site (http://www.pharmalabauto.com) that contains all the sample code and examples contained within the text as well as other information related to laboratory automation. Providing a starting point for tackling automation problems, Practical Pharmaceutical Laboratory Automation helps you develop a strategy for automation that gets consistent results.

Table of Contents

MICROSOFT EXCEL VISUAL BASIC MACROS

The Importance of Consistent Laboratory Notebooks and Reports

Running VBA Macros in Excel

Setting Up a Microsoft Excel Visual Basic Macro

Getting the Data into Excel

Finding and Extracting Data

Analysis and Manipulation of Data

Activating Sheets within Different Workbooks

Creating a Custom Report Worksheet

Saving the Custom Report Worksheet

Creating an Uploadable File for a Database

ADVANCED MICROSOFT EXCEL VB MACRO TECHNIQUES

Using Hidden Workbooks to Store and Run Macros

Adding Custom Menu Items to Run Macros

Keeping a Macro from Crashing When a Cell has Invalid Data

Not all InputBoxes are Equal

Using Templates and GUIs

Opening and Using Other Applications within Excel

The Importance of "Idle Time"

The Magic of the "SendKeys" Statement

Exchanging Data between Excel and Other Applications

Programming Functions into Workbook Cells

Adding Drop Down Boxes to Worksheet Cells

Opening Files in Other Applications Using Macros

Interworkbook Recognition of Variables

Waiting for User Selections

The End: Closing all Nonhidden Workbooks

Saving Settings to the Windows Registry

Self Writing Macros

ROBOTIC AUTOMATION USING VISUAL BASIC

Communications Overview

The MSComm Control

Using the Timer Control

Deciphering a Communication Protocol

Sending a Command

Interpreting a Reply

Setting up a Que Using the Timer Control

Controlling Multiple Instruments from Differing Manufacturers

Hardware Considerations in Robotic Automation

Summary

LOW LEVEL HARDWARE INTERFACING USING VB

Controller Cards and Addressing

Installing and Using the PortIO DLL

Controlling Relays

The MEM-08 Relay Card

The MEM-32 Relay Card

The MBB-32 Digital I/O Card

The MAI-16 Analog Input Card

Discrete Time Measurement

Sampling Theory and the Nyquist Theorem

Aliasing

Sampling Limitations of Visual Basic

Sampling of Non Periodic Signals

Pseudo Continuous Time Measurement

Possible Causes of Inconsistent Data

Methods for Faster Acquisition

Adding Auxiliary Power to the Metrabus System

Summary

ELECTRONICS FOR AUTOMATION

Overview

Voltage Division

Diode Waveform Shaping

The Transistor

The Comparator

Compensating for Noise Effects with Hysteresis

Window Comparator

Peak Detection

Low Pass Filtering

Decoupling Capacitors

Creating Custom Instrument Interfaces

Liquid Level Sensing Circuits

Solenoid Valve Driver Circuits

Summary

ROBUST DATA ANALYSIS USING ORIGIN LAB'S ORIGIN

Labtalk Fundamentals

Button Scripts

Script Files

Passing Parameters in Labtalk

Curve Fitting Using the "nlsf" Commands

Harnessing Origin Remotely

Dynamic Data Exchange (DDE) with VB

Dynamic Data Exchange (DDE) with VBA

AGILENT (HP) CHEMSTATION MACRO WRITING

Basics of Chemstation Macro Writing

Chemstation Macro Variables

Using Macros as Functions and Subroutines

Tools to Aid Macro Writers

Registers, Objects and Tables

Loading Sequences into an HPLC

Loading Sequences which Contain both Plates and Vials

Exporting Data after each Sample is Analyzed

Exporting Actual XY Data from the Chromatograms

Adding Macros to Chemstation Menus

Some Generic Macros and Techniques

Summary

Appendices

Appendix A: Downloading and use of sample files from Web site http://www.pharmalabauto.com

Appendix B: Setting Up the Excel VBA Macro Examples

Appendix C: Kloehn Syringe Protocol

Appendix D: Communications Datasheets

Appendix E: Electronic Devices Datasheets

Appendix F: Setting Up the Origin Examples

Appendix G: Setting Agilent Chemstation Macros

Appendix H: HPLC Chemstation Macro Hook Information

Appendix I: For Further Reading

Subject Categories

BISAC Subject Codes/Headings:
MED071000
MEDICAL / Pharmacology
SCI013000
SCIENCE / Chemistry / General
SCI013010
SCIENCE / Chemistry / Analytic