Excel by example : a Microsoft Excel cookbook for electronics engineers /

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

Full description

Bibliographic Details
Main Author: Kagan, Aubrey
Format: eBook
Language:English
Published: Amsterdam ; Boston : Elsevier/Newnes, [2004]
Subjects:
Online Access:Connect to the full text of this electronic book

MARC

Tag First Indicator Second Indicator Subfields
LEADER 00000cam a2200000Ia 4500
001 in00002425407
005 20190327171548.0
006 m d
007 cr cn|||||||||
008 070806s2004 ne a sb 001 0 eng d
020 |a 9780750677561 
020 |a 0750677562 
035 |a (OCoLC)ocn162592977 
035 |a (OCoLC)162592977 
037 |a 102084:102101  |b Elsevier Science & Technology  |n http://www.sciencedirect.com 
040 |a OPELS  |c OPELS  |d UtOrBLW 
049 |a TEFA 
050 1 4 |a TK153  |b .K16 2004eb 
082 0 4 |a 621.381/0285/554  |2 22 
100 1 |a Kagan, Aubrey. 
245 1 0 |a Excel by example :  |b a Microsoft Excel cookbook for electronics engineers /  |c by Aubrey Kagan. 
264 1 |a Amsterdam ;  |a Boston :  |b Elsevier/Newnes,  |c [2004] 
264 4 |c ©2004 
300 |a xviii, 364 pages :  |b illustrations ;  |c 23 cm. +  |e 1 CD-ROM (4 3/4 in.) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
533 |a Electronic reproduction.  |b Amsterdam :  |c Elsevier Science & Technology,  |d 2007.  |n Mode of access: World Wide Web.  |n System requirements: Web browser.  |n Title from title screen (viewed on Aug. 2, 2007).  |n Access may be restricted to users at subscribing institutions. 
520 |a 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. 
505 0 |a 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. 
504 |a Includes bibliographical references (pages 354-356) and index. 
500 |a CD-ROM includes a full searchable eBook version of the text in Adobe Pdf format, ready to run and customizable Excel worksheets for each application covered. 
500 |a Electronic resource. 
650 0 |a Electrical engineering  |x Data processing. 
630 0 0 |a Microsoft Excel (Computer file) 
655 7 |a Electronic books.  |2 local 
730 0 |a Referex. 
776 1 |c Original  |z 0750677562  |z 9780750677561  |w (DLC) 2004049951  |w (OCoLC)148220677 
856 4 0 |u http://proxy.library.tamu.edu/login?url=http://www.sciencedirect.com/science/book/9780750677561  |z Connect to the full text of this electronic book  |t 0 
994 |a C0  |b TEF 
999 |a MARS 
999 f f |s 5da8aeb0-afb1-3368-9596-c4faa988a3a9  |i 37ad3d0b-7080-30bd-8412-c8d12c0834a6  |t 0 
952 f f |a Texas A&M University  |b College Station  |c Electronic Resources  |d Available Online  |t 0  |e TK153 .K16 2004eb  |h Library of Congress classification 
998 f f |a TK153 .K16 2004eb  |t 0  |l Available Online