Spreadsheet Tools for Engineers Using Excel PDF Download

Author: Byron S. Gottfried
Publisher: McGraw-Hill
ISBN: 9780071106634
Category : Electronic spreadsheets
Languages : en
Pages : 502

View

Book Description
This best-selling Spreadsheet book provides excellent coverage of all versions of Excel including the latest version, Excel 2002. It discusses how to use Excel to solve a variety of problems in introductory engineering analysis, such as graphing data, unit conversions, simple statistical analysis, sorting, searching and analyzing data, curve fitting, interpolation, solving algebraic equations, logical decisions, evaluating integrals, comparing economic alternatives, and finding optimum solutions. Numerous examples are included illustrating both traditional and spreadsheet solutions to a variety of problems. The underlying mathematical solution procedures are also discussed, so that the reader is provided with an understanding of what the spreadsheet does and how it does it.

Author: Byron S. Gottfried
Publisher: McGraw-Hill Companies
ISBN: 9780071199766
Category : Technology & Engineering
Languages : en
Pages : 469

View

Book Description

Author: Aubrey Kagan
Publisher: Newnes
ISBN: 0750677562
Category : Computers
Languages : en
Pages : 385

View

Book Description
The spreadsheet has become a ubiquitous engineering tool, and Microsoft Excel is the standard spreadsheet software package. Over the years, Excel has become such a complex program that most engineers understand and use only a tiny part of its power and features. This book is aimed at electronics engineers and technicians in particular, showing them how to best use Excel's features for computations, circuit modeling, graphing, and data analysis as applied to electronics design. Separate chapters cover lookup tables and file I/O, using macros, graphing, controls, using Analysis Toolpak for statistical analysis, databases, and linking into Excel from other sources, such as data from a serial port. The book is basically an engineering cookbook, with each chapter providing tutorial information along with several Excel "recipes" of interest to electronics engineers. The accompanying CD-ROM features ready-to-run, customizable Excel worksheets derived from the book examples, which will be useful tools to add to any electronics engineer's spreadsheet toolbox. Engineers are looking for any and all means to increase their efficiency and add to their "bag of design tricks." Just about every electronics engineer uses Excel but most feel that the program has many more features to offer, if they only knew what they were! The Excel documentation is voluminous and electronics engineers don't have the time to read it all and sift through looking for those features that are directly applicable to their jobs and figure out how to use them. This book does that task for them-pulls out those features that they need to know about and shows them how to make use of them in specific design examples that they can then tailor to their own design needs. *This is the ONLY book to deal with Excel specifically in the electronics field *Distills voluminous and time-consuming Excel documentation down to nitty-gritty explanations of those features that are directly applicable to the electronics engineer's daily job duties *The accompanying CD-ROM provides ready-to-use, fully-customizable worksheets from the book's examples

Author: E. Joseph Billo
Publisher: John Wiley & Sons
ISBN: 0470126701
Category : Computers
Languages : en
Pages : 480

View

Book Description
Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's® capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices Find roots of equations and solve systems of simultaneous equations Solve ordinary differential equations and partial differential equations Perform linear and non-linear regression Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: All the spreadsheets, charts, and VBA code needed to perform the examples from the text Solutions to most of the end-of-chapter problems An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package

Author: Byron S. Gottfried
Publisher: McGraw-Hill Companies
ISBN:
Category : Computers
Languages : en
Pages : 532

View

Book Description
This practical text is a perfect fit for introductory engineering courses by successfully combining an introduction to Excel fundamentals with a clear presentation on how Excel can be used to solve common engineering problems. Updated to ensure compatibility with Excel 2007, Spreadsheet Tools for Engineers Using Excel 2007 provides beginning engineering students with a strong foundation in problem solving using Excel as the modern day equivalent of the slide rule. As part of McGraw-Hill's BEST series for freshman engineering curricula, this text is particularly geared toward introductory students. The author provides plenty of background information on technical terms, and provides numerous examples illustrating both traditional and spreadsheet solutions for a variety of engineering problems. The first three chapters introduce the basics of problem solving and Excel fundamentals. Beyond that, the chapters are largely independent of one another. Topics covered include graphing data, unit conversions, data analysis, interpolation and curve fitting, solving equations, evaluating integrals, creating macros, and comparing economic alternatives.

Author: Delores M. Etter
Publisher: Prentice Hall
ISBN: 9780805365368
Category : Engineering
Languages : en
Pages : 0

View

Book Description
Now you can design a learning package that fits your introductory engineering course perfectly with The Engineer's Toolkit: A First Course in Engineering. The Engineer's Toolkit is Prentice Hall's innovative publishing program for introductory engineering. Consisting of modules that cover engineering skills and concepts, programming languages and software tools, The Engineer's Toolkit is a flexible solution for keeping up with the evolving curriculum of first-year engineering.

Author: Byron S. Gottfried
Publisher: McGraw-Hill Science, Engineering & Mathematics
ISBN: 9780070246546
Category : Computers
Languages : en
Pages : 388

View

Book Description
Spreadsheet Tools for Engineers: Excel 97 Version explains how to use the latest version of Microsoft's popular spreadsheet package Excel to solve simple problems that commonly arise in engineering analysis. It is intended as a supplementary textbook for use in introductory engineering courses, although it will also be of interest to more advanced students and to practicing engineers. This new edition has been rewritten for Excel 97 (the version of Excel included in Microsoft's Office 97 suite). It includes separate chapters on Excel fundamentals, graphing data, analyzing data using simple statistics, fitting equations to data, interpolating between data points, solving single algebraic equations, solving simultaneous algebraic equations, evaluating integrals, comparing alternatives using engineering economic analysis, finding optimum solutions, and sorting and retrieving data. The book contains many detailed examples supplemented by a large number of problems for student solution. Answers are provided for most problems. Book jacket.

Author: David M Bourg
Publisher: "O'Reilly Media, Inc."
ISBN: 059655317X
Category : Computers
Languages : en
Pages : 445

View

Book Description
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 analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.

Author: Robert De Levie
Publisher: Oxford University Press, USA
ISBN: 0195152751
Category : Computers
Languages : en
Pages : 631

View

Book Description
This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).

Author: Ronald W. Larsen
Publisher: Prentice Hall
ISBN: 0136017754
Category : Engineering
Languages : en
Pages : 697

View

Book Description
For introductory courses in Engineering and Computing Based on Excel 2007, Engineering with Excel, 3e takes a comprehensive look at using Excel in engineering. This book focuses on applications and is intended to serve as both a textbook and a reference for students.