Excel by example : a Microsoft Excel cookbook for electronics engineers / by Aubrey Kagan.

Format:

Book

Author/Creator:

Kagan, Aubrey.

Language:

English

Subjects (All):

Electrical engineering--Data processing.

Electrical engineering.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (384 p.)

Edition:

1st ed.

Place of Publication:

Amsterdam ; Boston : Elsevier/Newnes, c2004.

Language Note:

English

Summary:

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

Contents:

Cover; Contents; Acknowledgments; Introduction; EXAMPLE 1: Voltage-to-Current Converter; Model Description; Starting Excel; Data Entry into a Worksheet; Autofill; Bulk Formatting; Formulas; Copying Formulas; Relative and Absolute References; Naming Cells; Hiding Cells; Borders; Bells and Whistles; Conditional IF and Absolute Value; Chart; Error Bars; Adding a Trendline; Macro: Timer; EXAMPLE 2: Baud Rate Selection; Model Description; Setup Workbook; Hexadecimal; Lookup Tables; Conditional Formatting; Macro; EXAMPLE 3: Mean Time Between Failures (MTBF); Model Description; Factors

Bill of Material Calculating the Quality Factor; Calculate Electrical Stress Factor; Calculation of ?G; Scenario; EXAMPLE 4: Counting Machine Cycles; Model Description; Importing the File; Extracting Op-code; Opening a Second Workbook; Cross Workbook Reference; Easing the Pain of Nested IFs; EXAMPLE 5: Character Generator; Model Description; Creating the Basic Workbook; LEN Function; Forms Controls; Text Orientation; Comments; Double-Click Macro; Macro Activation by the Command Button; Save to Data File; Usage; EXAMPLE 6: 8052 Microcomputer Register Setup; Model Description

Spreadsheet Concept Counter/Timer 0 Sheet; Timer Counter Control Register TCON; Counting Types; Macros to Hide and Unhide; Adding Forms; Add Image Control; Timer/Counter 1 Sheet; Timer/Counter 2 Sheet; Serial Port Sheet; Interrupt Control Sheet; Summary Sheet; Initialize Values; Conclusion; EXAMPLE 7: Finding the Optimal Resistor Combination: LP 2951; Model Description; Custom Autofill; Data Tables; Min Function; MATCH Function; INDEX Function; Block Conditional Formatting; EXAMPLE 8: Resistor Color Code Decoder Using Speech Input; Model Description; Implementing Speech Recognition

Viewing and Hiding the Language Bar Worksheet Setup; Macros; Custom Toolbar; Adding Speech; Evaluate the Color Code; Text to Speech; Conclusion; EXAMPLE 9: RTD to 4-20 mA Converter: XTR105; Model Description; Acquiring RTD Tables; Lookup RTD Value; Creating a Function; Accessing a Function; Adding a Help Description to a Function; Creating the Model in Excel; Standard Resistor Values; Creation of Add-In; Installing the Nearest Values Add-In; Back to the Project At Hand; Prompting for User Input; Printout; Running Macros when the Workbook is Started; Running from the Desktop

EXAMPLE 10: Voltage Regulator: LM317 Model Description; Installing the Neares tValues Add-In; Initial Model; Goal Seek; Worst Case Analysis; Thermal Analysis; Half-Wave Rectification; True RMS and Integration; More Preparation; Standard Capacitance Value; Chart; Conclusion; EXAMPLE 11: TL431 Adjustable Voltage Reference; Model Description; Installing the Nearest Values Add-In; Initial Model; Solver; Standard Resistor Values; Adding a Macro; Limitations; EXAMPLE 12: 555 Timer; Model Description; Monostable Operation; Setup; Add User Form; Add Image Control; Second Image; Modifying Form Location

Monostable Pulse Width Entry

Notes:

Description based upon print version of record.

Includes bibliographical references (p. 354-356) and index.

ISBN:

1-4175-3714-0

1-281-00977-6

9786611009779

0-08-047767-4

OCLC:

517566480