book

Excel Scientific and Engineering Cookbook

Name: Excel Scientific and Engineering Cookbook
Author: David M Bourg
ISBN: 9780596008796

by David M Bourg

January 2006

Intermediate to advanced

442 pages

12h 3m

English

O'Reilly Media, Inc.

Read now

Unlock full access

A Note Regarding Supplemental Files
Preface
1. Who Should Read This Book2. What’s in This Book3. Conventions in This Book4. Using Code Examples5. Safari Enabled6. We’d Like Your Feedback!7. Acknowledgments
1. Using Excel
1.0. Introduction1.1. Navigating the Interface1.2. Entering Data1.3. Setting Cell Data Types1.4. Selecting More Than a Single Cell1.5. Entering Formulas1.6. Exploring the R1C1 Cell Reference Style1.7. Referring to More Than a Single Cell1.8. Understanding Operator Precedence1.9. Using Exponents in Formulas1.10. Exploring Functions1.11. Formatting Your Spreadsheets1.12. Defining Custom Format Styles1.13. Leveraging Copy, Cut, Paste, and Paste Special1.14. Using Cell Names (Like Programming Variables)1.15. Validating Data1.16. Taking Advantage of Macros1.17. Adding Comments and Equation Notes1.18. Getting Help
2. Getting Acquainted with Visual Basic for Applications
2.0. Introduction2.1. Navigating the VBA Editor2.2. Writing Functions and Subroutines2.3. Working with Data Types2.4. Defining Variables2.5. Defining Constants2.6. Using Arrays2.7. Commenting Code2.8. Spanning Long Statements over Multiple Lines2.9. Using Conditional Statements2.10. Using Loops2.11. Debugging VBA Code2.12. Exploring VBA’s Built-in Functions2.13. Exploring Excel Objects2.14. Creating Your Own Objects in VBA2.15. VBA Help
3. Collecting and Cleaning Up Data
3.0. Introduction3.1. Importing Data from Text Files3.2. Importing Data from Delimited Text Files3.3. Importing Data Using Drag-and-Drop3.4. Importing Data from Access Databases3.5. Importing Data from Web Pages3.6. Parsing Data3.7. Removing Weird Characters from Imported Text3.8. Converting Units3.9. Sorting Data3.10. Filtering Data3.11. Looking Up Values in Tables3.12. Retrieving Data from XML Files
4. Charting
4.0. Introduction4.1. Creating Simple Charts4.2. Exploring Chart Styles4.3. Formatting Charts4.4. Customizing Chart Axes4.5. Setting Log or Semilog Scales4.6. Using Multiple Axes4.7. Changing the Type of an Existing Chart4.8. Combining Chart Types4.9. Building 3D Surface Plots4.10. Preparing Contour Plots4.11. Annotating Charts4.12. Saving Custom Chart Types4.13. Copying Charts to Word4-14. Displaying Error Bars
5. Statistical Analysis
5.0. Introduction5.1. Computing Summary Statistics5.2. Plotting Frequency Distributions5.3. Calculating Confidence Intervals5.4. Correlating Data5.5. Ranking and Percentiles5.6. Performing Statistical Tests5.7. Conducting ANOVA5.8. Generating Random Numbers5.9. Sampling Data
6. Time Series Analysis
6.0. Introduction6.1. Plotting Time Series Data6.2. Adding Trendlines6.3. Computing Moving Averages6.4. Smoothing Data Using Weighted Averages6.5. Centering Data6.6. Detrending a Time Series6.7. Estimating Seasonal Indices6.8. Deseasonalization of a Time Series6.9. Forecasting6.10. Applying Discrete Fourier Transforms
7. Mathematical Functions
7.0. Introduction7.1. Using Summation Functions7.2. Delving into Division7.3. Mastering Multiplication7.4. Exploring Exponential and Logarithmic Functions7.5. Using Trigonometry Functions7.6. Seeing Signs7.7. Getting to the Root of Things7.8. Rounding and Truncating Numbers7.9. Converting Between Number Systems7.10. Manipulating Matrices7.11. Building Support for Vectors7.12. Using Spreadsheet Functions in VBA Code7.13. Dealing with Complex Numbers
8. Curve Fitting and Regression
8.0. Introduction8.1. Performing Linear Curve Fitting Using Excel Charts8.2. Constructing Your Own Linear Fit Using Spreadsheet Functions8.3. Using a Single Spreadsheet Function for Linear Curve Fitting8.4. Performing Multiple Linear Regression8.5. Generating Nonlinear Curve Fits Using Excel Charts8.6. Fitting Nonlinear Curves Using Solver8.7. Assessing Goodness of Fit8.8. Computing Confidence Intervals

9. Solving Equations
9.0. Introduction9.1. Finding Roots Graphically9.2. Solving Nonlinear Equations Iteratively9.3. Automating Tedious Problems with VBA9.4. Solving Linear Systems9.5. Tackling Nonlinear Systems of Equations9.6. Using Classical Methods for Solving Equations
10. Numerical Integration and Differentiation
10.0. Introduction10.1. Integrating a Definite Integral10.2. Implementing the Trapezoidal Rule in VBA10.3. Computing the Center of an Area Using Numerical Integration10.4. Calculating the Second Moment of an Area10.5. Dealing with Double Integrals10.6. Numerical Differentiation
11. Solving Ordinary Differential Equations
11.0. Introduction11.1. Solving First-Order Initial Value Problems11.2. Applying the Runge-Kutta Method to Second-Order Initial Value Problems11.3. Tackling Coupled Equations11.4. Shooting Boundary Value Problems
12. Solving Partial Differential Equations
12.0. Introduction12.1. Leveraging Excel to Directly Solve Finite Difference Equations12.2. Recruiting Solver to Iteratively Solve Finite Difference Equations12.3. Solving Initial Value Problems12.4. Using Excel to Help Solve Problems Formulated Using the Finite Element Method
13. Performing Optimization Analyses in Excel
13.0. Introduction13.1. Using Excel for Traditional Linear Programming13.2. Exploring Resource Allocation Optimization Problems13.3. Getting More Realistic Results with Integer Constraints13.4. Tackling Troublesome Problems13.5. Optimizing Engineering Design Problems13.6. Understanding Solver Reports13.7. Programming a Genetic Algorithm for Optimization
14. Introduction to Financial Calculations
14.0. Introduction14.1. Computing Present Value14.2. Calculating Future Value14.3. Figuring Out Required Rate of Return14.4. Doubling Your Money14.5. Determining Monthly Payments14.6. Considering Cash Flow Alternatives14.7. Achieving a Certain Future Value14.8. Assessing Net Present Worth14.9. Estimating Rate of Return14.10. Solving Inverse Problems14.11. Figuring a Break-Even Point
Index
About the Author
Colophon
Copyright

404

Not Found

Either this content does not exist or you do not have access to it. Try searching for something new.

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Excel Scientific and Engineering Cookbook

by David M Bourg

404

Not Found