E-Book, Englisch, 464 Seiten
Bissett Practical Pharmaceutical Laboratory Automation
1. Auflage 2004
ISBN: 978-1-135-49722-4
Verlag: CRC Press
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)
E-Book, Englisch, 464 Seiten
ISBN: 978-1-135-49722-4
Verlag: CRC Press
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)
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.
Zielgruppe
Pharmaceutical and medical chemists, analytical chemists and spectroscopists, chemical enigneers, electrical engineers, and biological researchers
Autoren/Hrsg.
Fachgebiete
Weitere Infos & Material
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
