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.

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,

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.

This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to customize ribbon objects. It now also provides examples in using ADO, DAO, and SQL queries to retrieve data from databases for analysis. Operations such as fully automated linear and non-linear curve fitting, linear and non-linear mapping, charting, plotting, sorting, and filtering of data have been updated to leverage the newest Excel VBA object models. The text provides examples on automated data analysis and the preparation of custom reports suitable for legal archiving and dissemination. Functionality Demonstrated in This Edition Includes: Find and extract information raw data files Format data in color (conditional formatting) Perform non-linear and linear regressions on data Create custom functions for specific applications Generate datasets for regressions and functions Create custom reports for regulatory agencies Leverage email to send generated reports Return data to Excel using ADO, DAO, and SQL queries Create database files for processed data Create tables, records, and fields in databases Add data to databases in fields or records Leverage external computational engines Call functions in MATLAB® and Origin® from Excel

New strategies and techniques for today's fast-paced discoveryprocess Today, the pressure is on for high-throughput approaches toaccelerate the generation, identification, and optimization ofmolecules with desirable drug properties. As traditional methods ofanalysis become antiquated, new analytical strategies andtechniques are necessary to meet sample throughput requirements andmanpower constraints. Among them, mass spectrometry has grown to bea front-line tool throughout drug discovery. Integrated Strategies for Drug Discovery Using Mass Spectrometryprovides a thorough review of current analytical approaches,industry practices, and strategies in drug discovery. The topicsrepresent current industry benchmarks in specific drug discoveryactivities that deal with proteomics, biomarker discovery,metabonomic approaches for toxicity screening, lead identification,compound libraries, quantitative bioanalytical support,biotransformation, reactive metabolite characterization, leadoptimization, pharmaceutical property profiling, sample preparationstrategies, and automation. THIS BOOK: * Clearly explains how drug discovery and mass spectrometry areinterconnected * Discusses the uses and limitations of various types of massspectrometry in various aspects of drug discovery * Prominently features analytical applications that requiretrace-mixture analysis * Provides industry applications and real-world examples * Shares historical background information on various techniques toaid in the understanding of how and why new methods are now beingemployed to analyze samples

Flow cytometry continually amazes scientists with its ever-expanding utility. Advances in flow cytometry have opened new directions in theoretical science, clinical diagnosis, and medical practice. The new edition of Flow Cytometry: First Principles provides a thorough update of this now classic text, reflecting innovations in the field while outlining the fundamental elements of instrumentation, sample preparation, and data analysis. Flow Cytometry: First Principles, Second Edition explains the basic principles of flow cytometry, surveying its primary scientific and clinical applications and highlighting state-of-the-art techniques at the frontiers of research. This edition contains extensive revisions of all chapters, including new discussions on fluorochrome and laser options for multicolor analysis, an additionalsection on apoptosis in the chapter on DNA, and new chapters onintracellular protein staining and cell sorting, including high-speed sorting and alternative sorting methods, as well as traditional technology. This essential resource: Assumes no prior knowledge of flow cytometry Progresses with an informal, engaging lecture style from simpleto more complex concepts Offers a clear introduction to new vocabulary, principles of instrumentation, and strategies for data analysis Emphasizes the theory relevant to all flow cytometry, with examples from a variety of clinical and scientific fields Flow Cytometry: First Principles, Second Edition provides scientists, clinicians, technologists, and students with the knowledge necessary for beginning the practice of flow cytometry and for understanding related literature.

Provides practical guidance on pharmaceutical analysis, written by leading experts with extensive industry experience Analytical Testing for the Pharmaceutical GMP Laboratory presents a thorough overview of the pharmaceutical regulations, working processes, and drug development best practices used to maintain the quality and integrity of medicines. With a focus on smaller molecular weight drug substances and products, the book provides the knowledge necessary for establishing the pharmaceutical laboratory to support Quality Systems while maintaining compliance with Good Manufacturing Practices (GMP) regulations. Concise yet comprehensive chapters contain up-to-date coverage of drug regulations, pharmaceutical analysis methodologies, control strategies, testing development and validation, method transfer, electronic data documentation, and more. Each chapter includes a table of contents, definitions of acronyms, a reference list, and ample tables and figures. Addressing the principal activities and regulatory challenges of analytical testing in the development and manufacturing of pharmaceutical drug products, this authoritative resource: Describes the structure, roles, core guidelines, and GMP regulations of the FDA and ICH. Covers the common analytical technologies used in pharmaceutical laboratories, including examples of analytical techniques used for the release and stability testing of drugs. Examines control strategies established from quality systems supported by real-world case studies. Explains the use of dissolution testing for products such as extended-release capsules, aerosols, and inhalers. Discusses good documentation and data reporting practices, stability programs, and the Laboratory Information Management System (LIMS) to maintain compliance. Includes calculations, application examples, and illustrations to assist readers in day-to-day laboratory operations. Contains practical information and templates to structure internal processes or common Standard Operating Procedures (SOPs). Analytical Testing for the Pharmaceutical GMP Laboratory is a must-have reference for both early-career and experienced pharmaceutical scientists, analytical chemists, pharmacists, and quality control professionals. It is also both a resource for GMP laboratory training programs and an excellent textbook for undergraduate and graduate courses of analytical chemistry in pharmaceutical sciences or regulatory compliance programs.