Author: Gordon Filby
Publisher: Wiley-VCH
ISBN:
Category : Computers
Languages : en
Pages : 440
Get Book
Book Description
A practical guide 'Spreadsheets for Chemists' shows chemists of all levels how to use spreadsheet programs in their daily work. It highlights the possibilities provided by Lotus 1-2-3, the most widely used spreadsheet program in the sciences. Apart from hundreds of example fragments, it features: * Detailed discussion of the most relevant functions and all the () macro commands. * An accompanying diskette containing 57 worksheets involving many different fields of chemical research and teaching. * An extensive glossary of spreadsheet terms. * Three appendices covering 1-2-3's competitors and add-in packages, the use of Windows-based spreadsheets and how what-if analysis and back-solving is applied. Although the disk examples were developed for Lotus 1-2-3 DOS Versions 2.x (x=2-4), the worksheets are compatible with the newer Windows versions and those of their main competitors, Borland's Quattro Pro and Microsoft's Excel. Several compatible spreadsheets (AsEasyAs, Proqube) might also be as used as inexpensive alternatives. The author is a senior scientist at the Nuclear Research Centre in Karlsruhe, Germany. He has been using spreadsheet software for nearly ten years successfully in a variety of chemical problems.
Author: E. Joseph Billo
Publisher: John Wiley & Sons
ISBN: 047146080X
Category : Science
Languages : en
Pages : 483
Get Book
Book Description
Reviews from the First Edition: "Excel® for Chemists should be part ofany academic library offering courses and programs in chemistry.There is no other book on the market that deals so thoroughly withthe application of Excel for analyzing chemical data. Highlyrecommended, for upper-division undergraduates throughprofessionals." -Choice "I highly recommend this book; treat yourself to it; assign itto a class; give it as a gift." -The Nucleus Chemists across all subdisciplines use Excel to record data intabular form, but few have learned to take full advantage of thescientific calculating power within this program. Excel is capableof helping chemists process, analyze, and present scientific data,from the relatively simple to the highly complex.Excel® for Chemists, Second Edition has beenrevised and updated, not only to take into account the changes thatwere made in Excel, but also to incorporate an abundance of newexamples. Arranged in a user-friendly format, this book containsillustrations and examples of chemical applications, useful "Howto" boxes outlining how to accomplish complex tasks in Excel, andstep-by-step instructions for programming Excel to automaterepetitive data-processing tasks. In addition, tips are provided tospeed, simplify, and improve your use of Excel. Included is aCD-ROM, usable in either Macintosh or IBM/Windows environments withmany helpful spreadsheet templates, macros, and other tools. Entirely new chapters contained in this Second Editionfeature: Array formulas covered in depth in a separate chapter, alongwith a comprehensive review of using arrays in VBA How to create a worksheet with controls, such as optionbuttons, check boxes, or a list box An extensive list of shortcut keys-over 250 for Macintosh orPC-is provided in the appendix Whether as a text for students or as a reference for chemicalprofessionals in industry, academia, or government,Excel® for Chemists, Second Edition providesa valuable resource for using Excel to manage various chemicalcalculations.
Author: E. Joseph Billo
Publisher: John Wiley & Sons
ISBN: 9781118093931
Category : Science
Languages : en
Pages : 768
Get Book
Book Description
Reviews from previous editions: "Excel for Chemists should be part of any academiclibrary offering courses and programs in Chemistry." —Choice "I highly recommend the book; treat yourself to it; assign it toa class; give it as a gift." —The Nucleus The newly revised step-by-step guide to using the scientificcalculating power of Excel to perform a variety of chemicalcalculations Chemists across all subdisciplines use Excel to record data intabular form, but few have learned to take full advantage of theprogram. Featuring clear step-by-step instructions, Excelfor Chemists illustrates how to use the scientificcalculating power of Excel to perform a variety of chemicalcalculations. Including a CD-ROM for Windows, this new edition provideschemists and students with a detailed guide to using the currentversions of Excel (Excel 2007 and 2010) as well as Excel 2003. Additional features in this third edition include: How to perform a variety of chemical calculations by creatingadvanced spreadsheet formulas or by using Excel’s built-intools How to automate repetitive tasks by programming Excel’sVisual Basic for Applications New chapters show how to import data from other languageversions of Excel, and how to create automatic procedures The accompanying CD contains a number of Excel macros tofacilitate chemical calculations, including molecular weight,nonlinear regression statistics, and data interpolation Several appendices provide extensive lists of useful shortcutkeys and function descriptions
Author: Aoife Morrin
Publisher: John Wiley & Sons
ISBN: 1119182972
Category : Science
Languages : en
Pages : 196
Get Book
Book Description
SPREADSHEET APPLICATIONS IN CHEMISTRY USING MICROSOFT® EXCEL® Find step-by-step tutorials on scientific data processing in the latest versions of Microsoft® Excel® The Second Edition of Spreadsheet Applications in Chemistry Using Microsoft® Excel® delivers a comprehensive and up-to-date exploration of the application of scientific data processing in Microsoft® Excel®. Written to incorporate the latest updates and changes found in Excel® 2021, as well as later versions, this practical textbook is tutorial-focused and offers simple, step-by-step instructions for scientific data processing tasks commonly used by undergraduate students. Readers will also benefit from an online repository of experimental datasets that can be used to work through the tutorials to gain familiarity with data processing and visualization in Excel®. This latest edition incorporates new and revised content to use to learn the basics of Excel® for scientific data processing and now includes statistical analysis and regression analysis using Excel® add-ins, accounts for differences in navigation and utility between Windows and MacOS versions of the software, and integrates with an online dataset repository for the tutorial exercises. Spreadsheet Applications in Chemistry Using Microsoft® Excel® also includes: A thorough introduction to Microsoft® Excel® workbook and worksheet basics, including Excel® toolbar navigation, entering and manipulating formulas and functions and charting experimental chemical data Comprehensive explorations of statistical functions and regression analysis Generating calibration plots from instrumental data Visualizing concepts in physical chemistry Perfect for undergraduate and graduate students of analytical and physical chemistry, Spreadsheet Applications in Chemistry Using Microsoft® Excel® is also an ideal resource for students and practitioners of physics, engineering, and biology.
Author: Robert De Levie
Publisher: Oxford University Press, USA
ISBN: 0195152751
Category : Computers
Languages : en
Pages : 631
Get Book
Book Description
This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).
Author: E. Joseph Billo
Publisher: John Wiley & Sons
ISBN: 0471387347
Category : Computers
Languages : en
Pages : 485
Get Book
Book Description
Learn to fully harness the power of Microsoft Excel(r) to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's(r) capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's(r) capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: * Use worksheet functions to work with matrices * Find roots of equations and solve systems of simultaneous equations * Solve ordinary differential equations and partial differential equations * Perform linear and non-linear regression * Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: * All the spreadsheets, charts, and VBA code needed to perform the examples from the text * Solutions to most of the end-of-chapter problems * An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package.
Author: Robert de Levie
Publisher: Cambridge University Press
ISBN: 9780521644846
Category : Computers
Languages : en
Pages : 506
Get Book
Book Description
Because of their intuitive layout, extensive mathematical capabilities, and convenient graphics, spreadsheets provide an easy, straightforward route to scientific computing. This textbook for undergraduate and entry-level graduate chemistry and chemical engineering students uses Excel, the most powerful available spreadsheet, to explore and solve problems in general and chemical data analysis. This is the only up-to-date text on the use of spreadsheets in chemistry. The book discusses topics including statistics, chemical equilibria, pH calculations, titrations, and instrumental methods such as chromatography, spectrometry, and electroanalysis. It contains many examples of data analysis, and uses spreadsheets for numerical simulations, and testing analytical procedures. It also treats modern data analysis methods such as linear and non-linear least squares in great detail, as well as methods based on Fourier transformation. The book shows how matrix methods can be powerful tools in data analysis, and how easily these are implemented on a spreadsheet and describes in detail how to simulate chemical kinetics on a spreadsheet. It also introduces the reader to the use of VBA, the macro language of Microsoft Office, which lets the user import higher-level computer programs into the spreadsheet.
Author: E. Joseph Billo
Publisher:
ISBN:
Category :
Languages : en
Pages : 0
Get Book
Book Description
Author: Rodney J. Sime
Publisher: Prentice Hall
ISBN:
Category : Chemistry, Physical
Languages : en
Pages : 700
Get Book
Book Description
Physical Chemistry Calculations is a practical guide for students and instructors who want to learn how to use the most popular spreadsheet and computational software to solve problems in physical chemistry. The book provides students with a complementary approach to the chemistry and physics they are learning in the classroom. Physical Chemistry Calculations also gives a solid introduction to calculations with Excel, VB, VBA, MathCad and Mathematica.
Author: Henry Freiser
Publisher: CRC Press
ISBN: 9780849347177
Category : Science
Languages : en
Pages : 380
Get Book
Book Description
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.