TY - BOOK AU - Gottfried,Byron S. TI - Spreadsheet tools for engineers using Excel T2 - Basic engineering series and tools SN - 0072971843 U1 - 620.00285536 22 PY - 2007/// CY - New York PB - McGraw-Hill KW - Microsoft Excel (Computer file) KW - Engineering KW - Data processing KW - Electronic spreadsheets N1 - Includes index; Engineering Analysis and Spreadsheets -- General Problem-Solving Techniques -- Applicable Engineering Fundamentals -- Mathematical Solution Procedures -- The Role of Spreadsheets -- Excel Fundamentals -- Entering and Leaving Excel -- Moving around the Worksheet -- Entering Data -- Correcting Errors -- Using Formulas -- Using Functions -- Editing the Worksheet -- Saving and Retrieving the Worksheet -- Printing the Worksheet -- Displaying Cell Formulas -- Recording and Running Macros -- Graphing Data -- Creating a Graph in Excel -- Bar Graphs (Excel Column Charts) -- Line Graphs (Excel Line Charts) -- X-Y Graphs (Excel XY Charts, or Scatter Charts) -- Semi-Log Graphs -- Log-Log Graphs -- Pie Charts -- Converting Units -- Simple Conversions -- Simple Conversions in Excel -- Complex Conversions -- Complex Conversions in Excel -- Transferring Data -- Importing Data from a Text File -- Exporting Data to a Text File -- Transferring HTML Data -- Transferring a Worksheet to Microsoft Word -- Transferring a Worksheet to Microsoft PowerPoint -- Analyzing Data -- Data Characteristics -- Histograms -- Cumulative Distributions -- Organizing Data -- Creating a List in Excel -- Sorting Data in Excel -- Retrieving (Filtering) Data in Excel -- Pivot Table -- Fitting Equations to Data -- The Method of Least Squares -- Fitting a Straight Line to a Set of Data -- Derivation of the Least Squares Equations -- Fitting Other Functions to a Set of Data -- Selecting the Best Function for a Given Data Set -- Interpolating between Data Points -- Linear Interpolation -- Polynomial Interpolation Using Forward Differences -- Polynomial Interpolation Using Backward Differences -- Other Interpolation Techniques -- Solving Single Equations -- Characteristics of Nonlinear Algebraic Equations -- Graphical Solutions -- Solving Equations in Excel Using Goal Seek -- Solving Equations in Excel Using Solver -- Interval-Reduction Techniques -- Iterative Techniques -- Solving Simultaneous Equations -- Matrix Notation -- Matrix Operations in Excel -- Solving Simultaneous Equations in Excel Using Matrix Inversion -- Solving Simultaneous Equations in Excel Using Solver -- Making Logical Decisions (IF-THEN-ELSE) -- Logical Expressions -- The IF Function -- Nested IF Functions -- Evaluating Integrals -- The Trapezoidal Rule -- Simpson's Rule -- Comparing Economic Alternatives -- Compound Interest -- The Time Value of Money -- Uniform, Multipayment Cash Flows -- Irregular Cash Flows -- Internal Rate of Return -- Finding Optimum Solutions -- Optimization Problem Characteristics -- Solving Optimization Problems in Excel -- Answers to Selected Problems UR - http://www.loc.gov/catdir/toc/ecip0516/2005021256.html UR - http://www.loc.gov/catdir/enhancements/fy0664/2005021256-d.html UR - http://www.loc.gov/catdir/enhancements/fy0737/2005021256-b.html ER -