Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Amsterdam ; Boston :
Elsevier/Newnes,
©2004.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- 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.