Spreadsheet Applications in Chemistry Using Microsoft Excel

Everything you need to know about this emerging tool for scientific data processing
Spreadsheet packages –– once limited primarily to business applications–are emerging as invaluable tools for processing, analyzing, and presenting scientific data. Many spreadsheet programs now include built–in scientific and statistical tools, 3–D display options, and the capacity to nest dedicated scientific programs, enabling students, teachers, and scientists to process experimental data in a digital environment.
This book illustrates how EXCEL′s flexible environment can be used to prepare spreadsheet solutions for scientific data processing problems. It demonstrates step by step how to program EXCEL to perform appropriate tasks, automate repetitive data processing tasks, and prepare integrated documents by transferring data and graphics. While the examples used are primarily related to chemistry, the overall approach is useful in numerous disciplines, including physics, engineering, and biology. Supported by numerous illustrations, this book
∗ Covers statistical functions and regression analysis
∗ Includes advanced topics, such as digital filters, graphing complex equations, nonlinear curve fitting, and mathematical model building
∗ Discusses the use of VBA and macros for user interface customization and automation of repetitive tasks

Spis treści:
Introduction to Excel.
Statistical Functions and Regression Analysis.
Introduction to Macros and VBA.
Case Studies in Quantum Chemistry.
Case Studies in Physical Chemistry.
Importing and Processing Instrumental Data.
Processing Experimental Data Using Solver.
Case Studies Involving VBA.
Appendix.
Index.

Nota biograficzna:
Dermot Diamond, PhD, Senior Lecturer at the Dublin City University School of Chemical Sciences, is currently the Director of the DCU Biomedical and Environmental Sensor Technology (BE ST) Centre.
Venita C. A. Hanratty, PhD, has lectured at Trinity College Dublin and Dublin City University in physical chemistry and computer applications in chemistry. Currently, she is a software support specialist with Digital Equipment Ireland, Ltd.

Okładka tylna:
Everything you need to know about this emerging tool for scientific data processing
Spreadsheet packages –– once limited primarily to business applications–are emerging as invaluable tools for processing, analyzing, and presenting scientific data. Many spreadsheet programs now include built–in scientific and statistical tools, 3–D display options, and the capacity to nest dedicated scientific programs, enabling students, teachers, and scientists to process experimental data in a digital environment.
This book illustrates how EXCEL′s flexible environment can be used to prepare spreadsheet solutions for scientific data processing problems. It demonstrates step by step how to program EXCEL to perform appropriate tasks, automate repetitive data processing tasks, and prepare integrated documents by transferring data and graphics. While the examples used are primarily related to chemistry, the overall approach is useful in numerous disciplines, including physics, engineering, and biology. Supported by numerous illustrations, this book
∗ Covers statistical functions and regression analysis
∗ Includes advanced topics, such as digital filters, graphing complex equations, nonlinear curve fitting, and mathematical model building
∗ Discusses the use of VBA and macros for user interface customization and automation of repetitive tasks