› › Spreadsheet Tools For Engineers

Spreadsheet Tools for Engineers Using Excel

Author : Byron S. Gottfried

Publisher : McGraw-Hill

Page : 502 pages

File Size : 18,25 MB

Release : 2007

Category : Electronic spreadsheets

ISBN : 9780071106634

Get eBook

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.





Excel by Example

Author : Aubrey Kagan

Publisher : Newnes

Page : 385 pages

File Size : 18,18 MB

Release : 2004-05-19

Category : Computers

ISBN : 0750677562

Get eBook

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



Spreadsheet Tools for Engineers Using Excel ® 2007

Author : Byron S. Gottfried

Publisher : McGraw-Hill Companies

Page : 532 pages

File Size : 14,90 MB

Release : 2009-01-22

Category : Computers

ISBN :

Get eBook

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.



Excel for Scientists and Engineers

Author : E. Joseph Billo

Publisher : John Wiley & Sons

Page : 480 pages

File Size : 18,75 MB

Release : 2007-03-16

Category : Computers

ISBN : 0470126701

Get eBook

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



Microsoft Excel for Engineers

Author : Delores M. Etter

Publisher : Prentice Hall

Page : 0 pages

File Size : 19,11 MB

Release : 1995-03

Category : Engineering

ISBN : 9780805365368

Get eBook

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.



Spreadsheet Tools for Engineers

Author : Byron S. Gottfried

Publisher : McGraw-Hill Science, Engineering & Mathematics

Page : 388 pages

File Size : 21,63 MB

Release : 1998

Category : Computers

ISBN : 9780070246546

Get eBook

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.



Excel Scientific and Engineering Cookbook

Author : David M Bourg

Publisher : "O'Reilly Media, Inc."

Page : 445 pages

File Size : 34,16 MB

Release : 2006-01-17

Category : Computers

ISBN : 059655317X

Get eBook

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.



Advanced Excel for Scientific Data Analysis

Author : Robert De Levie

Publisher : Oxford University Press, USA

Page : 631 pages

File Size : 38,42 MB

Release : 2004

Category : Computers

ISBN : 0195152751

Get eBook

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).



Engineering with Excel

Author : Ronald W. Larsen

Publisher : Prentice Hall

Page : 697 pages

File Size : 34,36 MB

Release : 2009

Category : Engineering

ISBN : 0136017754

Get eBook

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.