Engineering With Excel

by Larsen, Ronald W.

• ISBN13: 9780130176967
• ISBN10: 0130176966
• Edition: 1st
• Format: Paperback
• Copyright: 2002-01-01
• Publisher: PRENTICE HALL

Summary

For courses in Computer Methods. An extensive text thoroughly covering the application of Excel to Engineering. This book is best for those who will spend a significant amount of time covering Excel during a semester or quarter, those who require that their students have a complete engineering reference to excel, or those who want to learn to apply excel to engineering problems on their own. This text is designed for all users from introductory to graduate students.

Table of Contents

Introduction to Excel	1	(45)
Introduction	1	(3)
Nomenclature	2	(1)
Examples and Application Problems	2	(1)
What Is a Spreadsheet?	2	(1)
Why Use a Spreadsheet?	3	(1)
Starting Excel	4	(2)
Starting Excel Using the Excel Icon on the Start Menu	4	(1)
Starting Excel Using New Office Document	5	(1)
A Little Windows	6	(4)
Title Bar	6	(1)
Control Buttons	6	(1)
Menu Bar	7	(1)
Standard Toolbar	7	(1)
Formatting Toolbar	7	(1)
Formula Bar	8	(1)
Spreadsheets and Workbooks	8	(2)
Status Bar	10	(1)
Spreadsheet Basics	10	(22)
Labels, Numbers, Formulas	10	(1)
Entering Formulas	11	(1)
Copying Cell Ranges to Perform Repetitive Calculations	12	(1)
Using the Fill Handle	13	(2)
Relative and Absolute Addressing	15	(2)
Using Named Cells	17	(2)
Editing the Active Cell	19	(1)
Using Built-In Functions	20	(1)
Error Messages in Excel	21	(1)
Formatting Cells	22	(3)
Hyperlinks in Excel	25	(3)
Splitting and Freezing Panes	28	(4)
Printing the Spreadsheet	32	(3)
Setting the Print Area	33	(1)
Printing Using Current Options	34	(1)
Changing Printing Options	34	(1)
Saving, Opening Workbooks, and Exiting	35	(11)
Saving the Workbook	35	(1)
Opening a Previously Saved Workbook	35	(1)
Exiting Excel	35	(11)
Graphing with Excel	46	(38)
Introduction	46	(1)
Getting Ready to Graph: Importing Text Files	47	(3)
Creating an XY Scatter Plot	50	(4)
Editing an Existing Graph	54	(9)
Modifying Graph Features	54	(4)
Adding TrendLine	58	(3)
Adding Error Bars	61	(2)
Creating Graphs with Multiple Curves	63	(6)
Adding an Additional Curve	65	(4)
Printing the Graph	69	(1)
Types of Graphs	69	(15)
Excel Functions	84	(42)
Introduction to Excel Functions	84	(1)
Excel's Built-in Functions	85	(3)
Function Syntax	85	(3)
Using the CONVERT ( ) Function to Convert Units	88	(4)
Checking to see if CONVERT ( ) is available	88	(2)
Once the CONVERT ( ) function is available	90	(2)
Simple Math Functions	92	(2)
Common Math Functions	92	(2)
Computing Sums	94	(3)
The SUM ( ) Function	94	(1)
The Auto Sum Button	95	(1)
Logarithm and Exponentiation Functions	96	(1)
Trigonometric Functions	97	(3)
Standard Trigonometric Functions	98	(2)
Inverse Trigonometric Functions	100	(4)
Advanced Math Functions	104	(2)
Logical Functions	104	(2)
Conditional Formatting	106	(2)
Error Function	108	(1)
Bessel Functions	109	(1)
Working with Complex Numbers	110	(1)
Working with Binary, Octal, and Hexadecimal Values	110	(1)
Miscellaneous Functions	111	(15)
Working with Random Numbers	111	(1)
Odd, Even	111	(1)
Date and Time Functions	111	(3)
Text Handling Functions	114	(1)
Lookup and Reference Functions	114	(12)
Matrix Operations in Excel	126	(27)
Matrix Manipulations: Vectors, Matrices, and Arrays	126	(1)
How Excel Handles Matrix Math	127	(1)
Basic Matrix Operations	127	(10)
Adding Two Matrices	127	(1)
Multiplying a Matrix by a Scalar	128	(2)
Multiplying Two Matrices	130	(3)
Transposing a Matrix	133	(2)
Inverting a Matrix	135	(1)
Matrix Determinant	136	(1)
Solving Systems of Linear Equations	137	(16)
Linear Regression in Excel	153	(34)
Introduction	153	(1)
Linear Regression Using Excel Functions	154	(2)
A Simple Example	154	(2)
Linear Regression Using Excel's Trend Line Capability	156	(4)
Simple Slope-Intercept Linear Regression	156	(4)
Forcing the Regression Line through the Origin (0,0)	160	(1)
Other Two-Coefficient Linear Regression Models	160	(2)
Polynomial Regression	162	(2)
Linear Regression Using Excel's Regression Analysis Package	164	(23)
A Simple Linear Regression for Slope and Intercept	164	(6)
Polynomial Regression Using the Regression Analysis Package	170	(2)
Other Linear Models	172	(1)
Forcing the Regression Line through the Origin (O, O)	173	(14)
Iterative Solutions Using Excel	187	(38)
Introduction	187	(1)
Iterative Solutions	188	(10)
Standard Forms	188	(1)
Using a Plot to Search for Roots	189	(2)
Simple ``Guess and Check'' Iteration	191	(1)
Writing Your Equation in Standard Form 2 (``Guess and Check'' Form)	192	(2)
Direct Substitution	194	(2)
In-Cell Iteration	196	(2)
Introduction to Excel's Solver	198	(6)
To Activate the Solver	198	(1)
To Install the Solver	198	(1)
To Use the Solver	199	(5)
Optimization Using the Solver	204	(4)
Nonlinear Regression	208	(5)
Testing the Regression Result	213	(12)
Using Macros in Excel	225	(43)
Introduction	225	(2)
Formulas, Functions, Macros, VBA Programs: Which One and When?	226	(1)
Macros and Viruses	227	(1)
Recorded Macros	227	(19)
Recording a Macro	228	(2)
Testing the Recorded Macro	230	(2)
Using Absolute Cell References When Recording Macros	232	(1)
Including an Absolute Cell Reference in a Macro Recorded Using Relative Referencing	232	(1)
Editing a Recorded Macro	233	(13)
Programmed Macros (VBA)	246	(22)
Starting Visual Basic for Applications (VBA)	246	(2)
Modules, Subs, and Functions	248	(2)
A Simple Border Macro	250	(1)
Running the Macro	251	(1)
Saving Your Macro Project	252	(1)
Using a Programmed Macro from Another Workbook	252	(1)
Common Macro Commands	253	(15)
Programming in Excel with VBA	268	(28)
Introduction	268	(1)
Visual Basic for Applications (VBA) Overview	269	(1)
Starting the VBA Editor	269	(1)
Forms and Modules	270	(8)
Inserting a Module	270	(1)
Overview of Writing a Function	271	(3)
The Difference Between Subs (subprograms) and Functions	274	(1)
The Scope of Variables and Functions	274	(1)
Passing Values through an Argument List	275	(1)
Declaring Data Types for Variables	276	(1)
Using the Function Name as the Return Variable Name	277	(1)
Working with Forms	278	(10)
Saving Your Project	288	(1)
Using the Form from the Spreadsheet	288	(8)
Sharing Excel Information with Other Programs	296	(39)
Introduction to Sharing Excel Information with Other Programs	296	(1)
Using Copy and Paste to Move Information	297	(8)
Moving Information Between Excel and Word	297	(4)
Moving Information Between Excel and MATHCAD	301	(3)
Moving Information Between Excel and the World Wide Web	304	(1)
Embedded and Linked Objects	305	(14)
Embedded and Linked Objects in Word and Excel	305	(2)
Embedded and Linked Objects in MATHCAD and Excel	307	(12)
External Data Sources	319	(16)
Text Files as Data Sources for Excel	319	(6)
Database Files as Data Sources for Excel	325	(7)
Excel Files as Data Sources for Excel Spreadsheets	332	(3)
Time Value of Money with Excel	335	(28)
Time, Money, and Cash Flows	335	(3)
Cash Flows	336	(1)
Types of Expenses	337	(1)
Types of Income	338	(1)
Interest Rates and Compounding	338	(4)
Periodic Interest Rates, ip	339	(1)
Nominal Interest Rates (inom)	339	(1)
Effective Annual Interest Rates (ie)	340	(2)
Moving Amounts through Time	342	(12)
Present and Future Values	342	(5)
Regular Payments	347	(4)
Discounting Factor Tables and Nomenclature	351	(3)
Economic Alternatives: Making Decisions	354	(9)
Financial Calculations with Excel	363	(24)
Introduction	363	(1)
Internal Rate of Return and Net Present Value	364	(6)
Net Present Value	364	(4)
Internal Rate of Return	368	(2)
Depreciation of Assets	370	(17)
Methods of Depreciation	370	(17)
Excel's Statistics Functions	387	(22)
Overview	387	(1)
Populations and Samples	388	(1)
Alternative Example	388	(1)
Multiple Instrument Readings	388	(1)
Arithmetic Mean, or Average	389	(1)
Standard Deviations and Variances	389	(3)
Population Statistics	391	(1)
Samples of a Population	391	(1)
Errors, Deviations, and Distributions	392	(6)
Frequency Distributions	394	(4)
Confidence Intervals	398	(11)
Confidence Levels and the Level of Significance	398	(1)
Confidence Intervals: Bounding the Extent of Uncertainty	399	(10)
Numerical Differentiation Using Excel	409	(24)
Finite Differences	409	(8)
Derivatives as Slopes	410	(2)
Caution on Using Finite Differences with Noisy Data	412	(1)
Common Finite-Difference Forms	413	(3)
Accuracy and Error Management	416	(1)
Filtering Data	417	(6)
Moving Average	417	(4)
Exponential Smoothing	421	(2)
Curve-Fitting and Differentiation	423	(10)
Numerical Integration Using Excel	433	(26)
Integrating for Area under a Curve	433	(1)
Integrating for Area Between Two Curves	434	(1)
Numerical Integration Methods	434	(13)
Integration Using Rectangles	435	(4)
Integration Using Trapezoids	439	(5)
Integration Using Smooth Curves (Simpson's Rule)	444	(1)
Simpson's Rule Procedure	444	(3)
Using Regression Equations for Integration	447	(12)
Numerical Integration Techniques for Differential Equations Using Excel	459	(31)
Euler's Method	459	(8)
Choosing an Integration Step Size	459	(5)
Checking the Accuracy of the Result	464	(1)
Error	465	(2)
Fourth-Order Runge-Kutta Method	467	(6)
Evaluating the Derivative: Function dDdl()	467	(1)
How the Fourth-Order Runge-Kutta Method Works	468	(2)
Automating Fourth-Order Runge-Kutta: Function rk4()	470	(1)
Implementing Fourth-Order Runge-Kutta in a Spreadsheet	471	(2)
Integrating Two Simultaneous ODEs Using the Runge---Kutta Method	473	(6)
Checking for Accuracy	478	(1)
Implicit Methods	479	(11)
Using the Method of Lines to Get the General Finite-Difference Equation	479	(11)
Index	490