 |
|
| EXCEL BY EXAMPLE
| |
| | |
|
|
 A Microsoft Excel Cookbook for Electronics Engineers
To order this title, and for more information, click here
By
Aubrey Kagan, Senior Design Engineer, Weidmuller Canada.
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.
Audience
Electronics/electrical engineers and technicians (500,000+ in U.S., according to Dept. of Labor statistics). Electrical/electronics engineering students.
Contents
Introduction
Excel Basics:
- autofill
- copying formulae
- relative & absolute
- naming cells
- formatting cells
- simple examples- amplifiers
LookupTables, File I/O (comma delimited):
- price break table
- interface to Parts & Vendors
- MTBF calculation
Macros
- Resistor value
- Timer
- Best Resistor pair selection
- Voltage regulator model
- 555 timer
- XTR104 model
- Automatic open
- Goal seek
- Timer
- Solver
Graphs
- curve fitting
- Bode plots
- Polar plots
- Simulating input/ monitor and plot output for a digital PID loop
- non-linear response
-
Controls
- pushbuttons
- hex - decimal conversion
- LCD initialization application
- Spinners
- Generate initialization code for microcomputer
(e.g. 8051)
- Serial number generation (or P.O. number etc.)
- Hide Excel from view
Voice control of Excel
Analysis Toolpak- statistical
analysis
- moving average
- random number generation
- Fourier analysis
Data base
- sort bills of material
External input into Excel
- linking to other applications, copying, dynamic updating
- loading files
- Enter data from serial port into spreadsheet
- Invoke Excel
from Visual Basic
Other resources
Index
Bibliographic & ordering Information
Paperback, 364 pages, publication date: MAY-2004
ISBN-13: 978-0-7506-7756-1
ISBN-10: 0-7506-7756-2
Imprint: NEWNES
Price: Order form
EUR 44.95
GBP 30.99
USD 48.95
Books and book related electronic products are priced in US dollars (USD), euro (EUR), and Great Britain Pounds (GBP). USD prices apply to the Americas and Asia Pacific. EUR prices apply in Europe and the Middle East. GBP prices apply to the UK and all other countries.
See also information about conditions of sale & ordering procedures, and links to our regional sales offices.
034/330
Last update: 18 Apr 2008
|
|
| |
| | |
|
|
| |
