David M. Bourg

Excel Scientific and Engineering Cookbook

Adding Excel to Your Analysis Arsenal

• Broschiertes Buch

Produktbeschreibung

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 problemsWherever 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.

---

Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 442
• Erscheinungstermin: 21. Februar 2006
• Englisch
• Abmessung: 233mm x 179mm x 32mm
• Gewicht: 710g
• ISBN-13: 9780596008796
• ISBN-10: 0596008791
• Artikelnr.: 15220126

Autorenporträt

As a naval architect and marine engineer, David M. Bourg performs computer simulations and develops analysis tools that measure such things as hovercraft performance and the effect of waves on the motion of ships and boats. He teaches at the college level in the areas of ship design, construction and analysis. On occasion, David also lectures at high schools on topics such as naval architecture and software development. In addition to David's practical engineering background, he's professionally involved in computer game development and consulting through his company, Crescent Vision Interactive.

Inhaltsangabe

Preface 1. Using Excel 1.1 Navigating the Interface 1.2 Entering Data 1.3 Setting Cell Data Types 1.4 Selecting More Than a Single Cell 1.5 Entering Formulas 1.6 Exploring the R1C1 Cell Reference Style 1.7 Referring to More Than a Single Cell 1.8 Understanding Operator Precedence 1.9 Using Exponents in Formulas 1.10 Exploring Functions 1.11 Formatting Your Spreadsheets 1.12 Defining Custom Format Styles 1.13 Leveraging Copy, Cut, Paste, and Paste Special 1.14 Using Cell Names (Like Programming Variables) 1.15 Validating Data 1.16 Taking Advantage of Macros 1.17 Adding Commentsand Equation Notes 1.18 Getting Help 2. Getting Acquainted with Visual Basic .1 Navigating the VBA Editor 2.2 Writing Functions and Subroutines 2.3 Working with Data Types 2.4 Defining Variables 2.5 Defining Constants 2.6 Using Arrays 2.7 Commenting Code 2.8 Spanning Long Statements over Multiple Lines 2.9 Using Conditional Statements 2.10 Using Loops 2.11 Debugging VBA Code 2.12 Exploring VBA's Built-in Functions 2.13 Exploring Excel Objects 2.14 Creating Your Own Objects in VBA 2.15 VBA Help 3. Collecting and Cleaning Up Data