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...
| Κύριος συγγραφέας: | Kagan, Aubrey. |
|---|---|
| Μορφή: | Ηλεκτρονική πηγή |
| Γλώσσα: | English |
| Στοιχεία έκδοσης: |
Amsterdam ; Boston :
Elsevier/Newnes,
c2004.
|
| Θέματα: | |
| Διαθέσιμο Online: |
http://www.sciencedirect.com/science/book/9780750677561 |
| Ετικέτες: |
Προσθήκη ετικέτας
Δεν υπάρχουν, Καταχωρήστε ετικέτα πρώτοι!
|
Πίνακας περιεχομένων:
- 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.