Spreadsheets In Science And Engineering

"Spreadsheets in Science and Engineering" shows scientists and engineers at all levels how to analyze, validate and calculate data and how the analytical and graphic capabilities of spreadsheet programs (ExcelR) can solve these tasks in their daily work. The examples on the CD-ROM accompanying the book include material of undergraduate to current research level in disciplines ranging from chemistry and chemical engineering to molecular biology and geology.

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.

In this basic introduction, the author aims to help engineers and scientists to understand and use Excel in their fields. The book is interactive and designed to be used in conjunction with a computer, to provide a hands-on learning experience.

A complete tutorial on how to use all version of the excel spreadsheets including 3.0 for specific engineering and scientific functions.

Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.

Excel is an everyday computational tool for most engineers and scientists. Foundations of Excel Spreadsheets for Engineers and Scientists is specifically written to respond to gaps in understanding of this important spreadsheet tool among undergraduates and provide them with a concise, informative and cost effective resource that will assist them with their study and careers. Foundations of Excel Spreadsheets: introduces the core aspects of Microsoft Excel; addresses the range of skills required by undergraduate students using this technology across various disciplines including science, engineering and technology; covers additional key topics such as documentation and verification, which are ignored by other textbooks; refers to Excel 2010 but has application to earlier Excel versions as well. Supplements: Additional online guides to using keyboard shortcuts and translating commands between different Excel versions are available to users of the text at www.pearsoned.co.nz/jordan.

Using an informal, conversational style, this "how to" book guides beginning students from spreadsheet basics through the robust engineering and scientific applications of EXCEL, including using EXCEL in the lab. Students learn how to compose structured, efficient, documented workbooks with data entry cells, summary results and statistics cells, and commented cells. Throughout the book, they′ll find innovative techniques for composing spreadsheets, solving problems, analyzing data, and presenting results that will help them in their courses and professional careers. End–of–Chapter problems not only show how to use EXCEL, they also relate directly to topics in engineering and the sciences. Plus, a CD, which is packaged with the text, contains sample workbooks, links to online EXCEL resources, and text updates via the book′s web site.