Spreadsheet tools for engineers using Excel / Byron S. Gottfried.

By:

Gottfried, Byron S, 1934- [author.]

Material type: Text

TextSeries: McGraw-Hill's BEST--basic engineering series and toolsNew York : McGraw-Hill, 2007New York : McGraw-Hill, [2007]Edition: third editionDescription: x, 502 pages. : illustrations. ; 24 cmContent type:

text

Media type:

unmediated

Carrier type:

volume

ISBN:

0072971843
9780072971842
9780071106634

Subject(s):

DDC classification:

620.00285536 22 G.B.S

Online resources:

Contents:

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.

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Collection	Call number	Status	Date due	Barcode
Books	Main library B2	Faculty of Engineering & Technology (General)	620.00285536 G.B.S (Browse shelf(Opens below))	Available		00002650

Browsing Main library shelves, Shelving location: B2 Close shelf browser (Hides shelf browser)

Previous								Next
Previous	620.00285 G.B.S Spreadsheet tools for engineers : Excel 5.0 version /	620.00285 G.B.S Spreadsheet tools for engineers : Excel 5.0 version /	620.0028553 S.D.E Engineering computation with MATLAB /	620.00285536 G.B.S Spreadsheet tools for engineers using Excel /	620.002855369 H.B.E Essential MATLAB for engineers and scientists /	620.0042 B.J.E Engineering design and graphics with Autodesk Inventor 2009 /	620.0042 D.G.E Engineering design /	Next

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.

There are no comments on this title.

to post a comment.

FUE Central Library

Spreadsheet tools for engineers using Excel / Byron S. Gottfried.

Browsing Main library shelves, Shelving location: B2 Close shelf browser (Hides shelf browser)