Excel by example a Microsoft Excel cookbook for electronics engineers

• Κύριος συγγραφέας: Kagan, Aubrey
• Συγγραφή απο Οργανισμό/Αρχή: ScienceDirect (Online service)
• Μορφή: Ηλεκτρονική πηγή Βιβλίο
• Γλώσσα: English
• Έκδοση: Amsterdam Boston Elsevier/Newnes c2004
• Θέματα: Electric engineering > Data processing

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

Πίνακας περιεχομένων:

• 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