Skip to content

Excel Scientific and Engineering Cookbook

Spend $50 to get a free DVD!

ISBN-10: 0596008791

ISBN-13: 9780596008796

Edition: 2006

Authors: David M. Bourg

List price: $49.99
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

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…    
Customers also bought

Book details

List price: $49.99
Copyright year: 2006
Publisher: O'Reilly Media, Incorporated
Publication date: 1/27/2006
Binding: Paperback
Pages: 446
Size: 6.75" wide x 8.75" long x 1.00" tall
Weight: 1.804

David Bourg is a Naval Architect involved in various military and commercial proposal, design, and construction efforts. Since 1998, David has served as an independent consultant working for various regional clients engaged in both commercial and military shipbuilding where he provides design and analysis services including but not limited to concept design, proposal writing, detailed design and analysis, visualization, and software development among other services. He coordinated and led the winning design and proposal effort for the US Coast Guard Point Class (patrol boat) Replacement Program. In 2006, David joined fellow Naval Architect Kenneth Humphreys to form MiNO Marine, LLC, a naval…    

Preface
Using Excel
Navigating the Interface
Entering Data
Setting Cell Data Types
Selecting More Than a Single Cell
Entering Formulas
Exploring the R1C1 Cell Reference Style
Referring to More Than a Single Cell
Understanding Operator Precedence
Using Exponents in Formulas
Exploring Functions
Formatting Your Spreadsheets
Defining Custom Format Styles
Leveraging Copy, Cut, Paste, and Paste Special
Using Cell Names (Like Programming Variables)
Validating Data
Taking Advantage of Macros
Adding Comments and Equation Notes
Getting Help
Getting Acquainted with Visual Basic for Applications
Navigating the VBA Editor
Writing Functions and Subroutines
Working with Data Types
Defining Variables
Defining Constants
Using Arrays
Commenting Code
Spanning Long Statements over Multiple Lines
Using Conditional Statements
Using Loops
Debugging VBA Code
Exploring VBA's Built-in Functions
Exploring Excel Objects
Creating Your Own Objects in VBA
VBA Help
Collecting and Cleaning Up Data
Importing Data from Text Files
Importing Data from Delimited Text Files
Importing Data Using Drag-and-Drop
Importing Data from Access Databases
Importing Data from Web Pages
Parsing Data
Removing Weird Characters from Imported Text
Converting Units
Sorting Data
Filtering Data
Looking Up Values in Tables
Retrieving Data from XML Files
Charting
Creating Simple Charts
Exploring Chart Styles
Formatting Charts
Customizing Chart Axes
Setting Log or Semilog Scales
Using Multiple Axes
Changing the Type of an Existing Chart
Combining Chart Types
Building 3D Surface Plots
Preparting Contour Plots
Annotating Charts
Saving Custom Chart Types
Copying Charts to Word
Displaying Error Bars
Statistical Analysis
Computing Summary Statistics
Plotting Frequency Distributions
Calculating Confidence Intervals
Correlating Data
Ranking and Percentiles
Performing Statistical Tests
Conducting ANOVA
Generating Random Numbers
Sampling Data
Time Series Analysis
Plotting Time Series Data
Adding Trendlines
Computing Moving Averages
Smoothing Data Using Weighted Averages
Centering Data
Detrending a Time Series
Estimating Seasonal Indices
Deseasonalization of a Time Series
Forecasting
Applying Discrete Fourier Transforms
Mathematical Functions
Using Summation Functions
Delving into Division
Mastering Multiplication
Exploring Exponential and Logarithmic Functions
Using Trigonometry Functions
Seeing Signs
Getting to the Root of Things
Rounding and Truncating Numbers
Converting Between Number Systems
Manipulating Matrices
Building Support for Vectors
Using Spreadsheet Functions in VBA Code
Dealing with Complex Numbers
Curve Fitting and Regression
Performing Linear Curve Fitting Using Excel Charts
Constructing Your Own Linear Fit Using Spreadsheet Functions
Using a Single Spreadsheet Function for Linear Curve Fitting
Performing Multiple Linear Regression
Generating Nonlinear Curve Fits Using Excel Charts
Fitting Nonlinear Curves Using Solver
Assessing Goodness of Fit
Computing Confidence Intervals
Solving Equations
Finding Roots Graphically
Solving Nonlinear Equations Iteratively
Automating Tedious Problems with VBA
Solving Linear Systems
Tackling Nonlinear Systems of Equations
Using Classical Methods for Solving Equations
Numerical Integration and Differentiation
Integrating a Definite Integral
Implementing the Trapezoidal Rule in VBA
Computing the Center of an Area Using Numerical Integration
Calculating the Second Moment of an Area
Dealing with Double Integrals
Numerical Differentiation
Solving Ordinary Differential Equations
Solving First-Order Initial Value Problems
Applying the Runge-Kutta Method to Second-Order Initial Value Problems
Tackling Coupled Equations
Shooting Boundary Value Problems
Solving Partial Differential Equations
Leveraging Excel to Directly Solve Finite Difference Equations
Recruiting Solver to Iteratively Solve Finite Difference Equations
Solving Initial Value Problems
Using Excel to Help Solve Problems Formulated Using the Finite Element Method
Performing Optimization Analyses in Excel
Using Excel for Traditional Linear Programming
Exploring Resource Allocation Optimization Problems
Getting More Realistic Results with Integer Constraints
Tackling Troublesome Problems
Optimizing Engineering Design Problems
Understanding Solver Reports
Programming a Genetic Algorithm for Optimization
Introduction to Financial Calculations
Computing Present Value
Calculating Future Value
Figuring Out Required Rate of Return
Doubling Your Money
Determining Monthly Payments
Considering Cash Flow Alternatives
Achieving a Certain Future Value
Assessing Net Present Worth
Estimating Rate of Return
Solving Inverse Problems
Figuring a Break-Even Point
Index