Concepts Calculations in Analytical Chemistry Featuring the Use of Excel

Author: Henry Freiser
Publisher: CRC Press
ISBN: 1482292599
Format: PDF, Kindle
Download Now
Concepts & Calculations in Analytical Chemistry: A Spreadsheet Approach offers a novel approach to learning the fundamentals of chemical equilibria using the flexibility and power of a spreadsheet program. Through a conceptual presentation of chemical principles, this text will allow the reader to produce and digest large assemblies of numerical data/calculations while still focusing on the chemistry. The chapters are arranged in a logical sequence, identifying almost every equilibrium scenario that an analytical chemist is likely to encounter. The spreadsheet calculations and graphics offer an excellent solution to otherwise time-consuming operations. Worked examples are included throughout the book, and student-tested problems are featured at the end of each chapter. Spreadsheet commands for QuattroPro, Quattro, and Lotus 1-2-3 are embedded in the text. Concepts & Calculations in Analytical Chemistry: A Spreadsheet Approach has been designed to serve both as a supplement to an undergraduate quantitative analysis course or as a text in a graduate-level advanced analytical chemistry course. Professional chemists will also find this to be an excellent introduction to spreadsheet applications in the lab and a modern overview of analytical chemistry in a self-study format.

Concepts Calculations in Analytical Chemistry Featuring the Use of Excel

Author: Henry Freiser
Publisher: CRC Press
ISBN: 9780849347177
Format: PDF, ePub, Docs
Download Now
Concepts & Calculations in Analytical Chemistry: A Spreadsheet Approach offers a novel approach to learning the fundamentals of chemical equilibria using the flexibility and power of a spreadsheet program. Through a conceptual presentation of chemical principles, this text will allow the reader to produce and digest large assemblies of numerical data/calculations while still focusing on the chemistry. The chapters are arranged in a logical sequence, identifying almost every equilibrium scenario that an analytical chemist is likely to encounter. The spreadsheet calculations and graphics offer an excellent solution to otherwise time-consuming operations. Worked examples are included throughout the book, and student-tested problems are featured at the end of each chapter. Spreadsheet commands for QuattroPro, Quattro, and Lotus 1-2-3 are embedded in the text. Concepts & Calculations in Analytical Chemistry: A Spreadsheet Approach has been designed to serve both as a supplement to an undergraduate quantitative analysis course or as a text in a graduate-level advanced analytical chemistry course. Professional chemists will also find this to be an excellent introduction to spreadsheet applications in the lab and a modern overview of analytical chemistry in a self-study format.

Advanced Excel for Scientific Data Analysis

Author: Robert De Levie
Publisher: Oxford University Press, USA
ISBN: 0195152751
Format: PDF, Mobi
Download Now
Excel is by far the most widely distributed data analysis software but few users are aware of its full powers. Advanced Excel For Scientific Data Analysis takes off from where most books dealing with scientific applications of Excel end. It focuses on three areas-least squares, Fourier transformation, and digital simulation-and illustrates these with extensive examples, often taken from the literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. These macros and functions are provided in uncompiled, computer-readable, easily modifiable form; readers can therefore use them as starting points for making their own personalized data analysis tools. Detailed descriptions and sample applications of standard and specialized uses of least squares for fitting data to a variety of functions, including resolving multi-component spectra; standard processes such as calibration curves and extrapolation; custom macros for general "error" propagation, standard deviations of Solver results, weighted or equidistant least squares, Gram-Schmidt orthogonalization, Fourier transformation, convolution and deconvolution, time-frequency analysis, and data mapping. There are also worked examples showing how to use centering, the covariance matrix, imprecision contours, and Wiener filtering and custom functions for bisections, Lagrange interpolation, Euler and Runge-Kutta integration.

Applications of Microsoft Excel in Analytical Chemistry

Author: F. Holler
Publisher: Cengage Learning
ISBN: 128508795X
Format: PDF, ePub
Download Now
This supplement can be used in any analytical chemistry course. The exercises teaches you how to use Microsoft Excel using applications from statistics, data analysis equilibrium calculations, curve fitting, and more. Operations include everything from basic arithmetic and cell formatting to Solver, Goal Seek, and the Data Analysis Toolpak. The authors show you how to use a spreadsheet to construct log diagrams and to plot the results. Statistical data treatment includes descriptive statistics, linear regression, hypothesis testing, and analysis of variance. Tutorial exercises include nonlinear regression such as fitting the Van Deemter equation, fitting kinetics data, determining error coefficients in spectrophotometry, and calculating titration curves. Additional features include solving complex systems of equilibrium equations and advanced graphical methods: error bars, charts with insets, matrices and determinants, and much more. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Chemical Engineering Primer with Computer Applications

Author: Hussein K. Abdel-Aal
Publisher: CRC Press
ISBN: 1315353040
Format: PDF, ePub, Mobi
Download Now
Taking a highly pragmatic approach to presenting the principles and applications of chemical engineering, this companion text for students and working professionals offers an easily accessible guide to solving problems using computers. The primer covers the core concepts of chemical engineering, from conservation laws all the way up to chemical kinetics, without heavy stress on theory and is designed to accompany traditional larger core texts. The book presents the basic principles and techniques of chemical engineering processes and helps readers identify typical problems and how to solve them. Focus is on the use of systematic algorithms that employ numerical methods to solve different chemical engineering problems by describing and transforming the information. Problems are assigned for each chapter, ranging from simple to difficult, allowing readers to gradually build their skills and tackle a broad range of problems. MATLAB and Excel® are used to solve many examples and the more than 70 real examples throughout the book include computer or hand solutions, or in many cases both. The book also includes a variety of case studies to illustrate the concepts and a downloadable file containing fully worked solutions to the book’s problems on the publisher’s website. Introduces the reader to chemical engineering computation without the distractions caused by the contents found in many texts. Provides the principles underlying all of the major processes a chemical engineer may encounter as well as offers insight into their analysis, which is essential for design calculations. Shows how to solve chemical engineering problems using computers that require numerical methods using standard algorithms, such as MATLAB® and Excel®. Contains selective solved examples of many problems within the chemical process industry to demonstrate how to solve them using the techniques presented in the text. Includes a variety of case studies to illustrate the concepts and a downloadable file containing fully worked solutions to problems on the publisher’s website. Offers non-chemical engineers who are expected to work with chemical engineers on projects, scale-ups and process evaluations a solid understanding of basic concepts of chemical engineering analysis, design, and calculations.

Computer Applications in Food Technology

Author: R. Paul Singh
Publisher: Elsevier
ISBN: 9780080529714
Format: PDF, ePub, Docs
Download Now
The Institute of Food Technologists (IFT) recently endorsed the use of computers in food science education. The minimum standards for degrees in food science, as suggested by IFT,"require the students to use computers in the solution of problems, the collection and analysis of data, the control processes, in addition to word processing."Because they are widely used in business, allow statistical and graphical of experimental data, and can mimic laboratory experimentation, spreadsheets provide an ideal tool for learning the important features of computers and programming. In addition, they are ideally suited for food science students, who usually do not have an extensive mathematical background. Drawing from the many courses he has taught at UC Davis, Dr. Singh covers the general basics of spreadsheets using examples specific to food science. He includes more than 50 solved problems drawn from key areas of food science, namely food microbiology, food chemistry, sensory evaluation, statistical quality control, and food engineering. Each problem is presented with the required equations and detailed steps necessary for programming the spreadsheet. Helpful hints in using the spreadsheets are also provided throughout the text. Key Features * The first book to integrate speadsheets in teaching food science and technology * Includes more than 50 solved examples of spreadsheet use in food science and engineering * Presents a step-by-step introduction to spreadsheet use * Provides a food composition database on a computer disk

Computational Quantum Chemistry

Author: Charles M. Quinn
Publisher: Elsevier
ISBN: 9780080488530
Format: PDF, Mobi
Download Now
Computational Quantum Chemistry removes much of the mystery of modern computer programs for molecular orbital calculations by showing how to develop Excel spreadsheets to perform model calculations and investigate the properties of basis sets. Using the book together with the CD-ROM provides a unique interactive learning tool. In addition, because of the integration of theory with working examples on the CD-ROM, the reader can apply advanced features available in the spreadsheet to other applications in chemistry, physics, and a variety of disciplines that require the solution of differential equations. This book and CD-ROM makes a valuable companion for instructors, course designers, and students. It is suitable for direct applications in practical courses in theoretical chemistry and atomic physics, as well as for teaching advanced features of Excel in IT courses.

Key Concepts in Environmental Chemistry

Author: Grady Hanrahan
Publisher: Academic Press
ISBN: 012374993X
Format: PDF, ePub, Docs
Download Now
Key Concepts in Environmental Chemistry provides a modern and concise introduction to environmental chemistry principles and the dynamic nature of environmental systems. It offers an intense, one-semester examination of selected concepts encountered in this field of study and provides integrated tools in explaining complex chemical problems of environmental importance. Principles typically covered in more comprehensive textbooks are well integrated into general chapter topics and application areas. The goal of this textbook is to provide students with a valuable resource for learning the basic concepts of environmental chemistry from an easy to follow, condensed, application and inquiry-based perspective. Additional statistical, sampling, modeling and data analysis concepts and exercises will be introduced for greater understanding of the underlying processes of complex environmental systems and fundamental chemical principles. Each chapter will have problem-oriented exercises (with examples throughout the body of the chapter) that stress the important concepts covered and research applications/case studies from experts in the field. Research applications will be directly tied to theoretical concepts covered in the chapter. Overall, this text provides a condensed and integrated tool for student learning and covers key concepts in the rapidly developing field of environmental chemistry. Intense, one-semester approach to learning Application-based approach to learning theoretical concepts In depth analysis of field-based and in situ analytical techniques Introduction to environmental modeling

101 Ready to Use Excel Formulas

Author: Michael Alexander
Publisher: John Wiley & Sons
ISBN: 1118902599
Format: PDF, ePub
Download Now
Mr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas 101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem—along with detailed explanation of how the formulas work. Written in a user-friendly style that relies on a tips and tricks approach, the book details how to perform everyday Excel tasks with confidence. 101 Ready-to-Use Excel Formulas is sure to become your well-thumbed reference to solve your workplace problems. The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented. Teaches you how to implement the required Excel formula Explains and details how the formulas work Lets you reuse or customize the given formula to address your particular needs Helps you make the formulas a regular part of your new, more efficient workflow Specific real-world scenarios are used to demonstrate how to most effectively apply Excel and its powerful formulas to complete tasks faster and with greater accuracy than ever before. Now you can save time, automate, and be more efficient and productive with 101 Ready-to-Use Excel Formulas.

Excel 2003 Power Programming with VBA

Author: John Walkenbach
Publisher: John Wiley & Sons
ISBN: 0764568329
Format: PDF, ePub, Docs
Download Now
"Today, no accomplished Excel programmer can afford to be without John's book. The value of Excel 2003 Power Programming with VBA is double most other books-simultaneously the premier reference and best learning tool for Excel VBA." --Loren Abdulezer, Author of Excel Best Practices for Business Everything you need to know about: * Creating stellar UserForms and custom dialog box alternatives * Working with VBA subprocedures and function procedures * Incorporating event-handling and interactions with other applications * Building user-friendly toolbars, menus, and help systems * Manipulating files and Visual Basic components * Understanding class modules * Managing compatibility issues Feel the power of VBA and Excel No one can uncover Excel's hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user's guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you're fairly new to Excel programming, here's the foundation you need. If you're already a VBA veteran, you can start mining a rich lode of programming ideas right away. CD-ROM Includes * Trial version of the author's award-winning Power Utility Pak * Over one hundred example Excel workbooks from the book System Requirements: PC running Windows 2000 SP3 or later, or Windows XP(TM) or later. Microsoft Excel 2003. See the "What's on the CD" Appendix for details and complete system requirements.