A Microsoft Excel Cookbook for Electronics Engineers

trexmilennium

Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers

Aubrey Kagan, «Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers»
Newnes | ISBN 0750677562 | Bk&CD-Rom edition (May 19, 2004) | PDF | 27.9 Mb | 364 pages

Buradan indirin(RapidShare)
veya

Buradan indirin(deposit files)
veya

Buradan indirin(FileHo)
Table of Contents

* Cover
* Frontmatter
o Half Title Page
o Title Page
o Copyright
o Dedication Page
o Contents
o Acknowlegments
o Introduction
+ Rules of Engagement
+ What s on the CD-ROM?
* Example 1. Voltage-to-Current Converter
o Model Description
o Starting Excel
o Data Entry into a Worksheet
o Autofill
o Bulk Formatting
o Formulas
o Copying Formulas
o Relative and Absolute References
o Naming Cells
o Hiding Cells
o Borders
o Bells and Whistles
o Conditional IF and Absolute Value
o Chart
o Error Bars
o Adding a Trendline
o Macro: Timer
* Example 2. Baud Rate Selection
o Model Description
o Setup Workbook
o Hexadecimal
o Lookup Tables
o Conditional Formatting
o Macro
* Example 3. Mean Time Between Failures (MTBF)
o Model Description2
o Factors
o Bill of Material
o Calculating the Quality Factor
o Calculate Electrical Stress Factor
o Calculation of lG
o Scenario
* Example 4. Counting Machine Cycles
o Model Description
o Importing the File
o Extracting Op-code
o Opening a Second Workbook
o Cross Workbook Reference
o Easing the Pain of Nested IFs
* Example 5. Character Generator
o Model Description
o Creating the Basic Workbook
o LEN Function
o Forms Controls
o Text Orientation
o Comments
o Double-Click Macro
o Macro Activation by the Command Button
o Save to Data File
o Usage
* Example 6. 8052 Microcomputer Register Setup
o Model Description
o Spreadsheet Concept
o Counter/Timer 0 Sheet
o Timer Counter Control Register TCON
o Counting Types
o Count
o Timer
o Macros to Hide and Unhide
o Adding Forms
o Add Image Control
o Timer/Counter 1 Sheet
o Timer/Counter 2 Sheet
o se-ri-@l Port Sheet
o Interrupt Control Sheet
o Summary Sheet
o Initialize Values
o Conclusion
* Example 7. Finding the Optimal Resistor Combination: LP 2951
o Model Description
o Custom Autofill
o Data Tables
o Min Function
o MATCH Function
o INDEX Function
o Block Conditional Formatting
* Example 8. Resistor Color Code Decoder Using Speech Input
o Model Description
o Implementing Speech Recognition
o Viewing and Hiding the Language Bar
o Worksheet Setup
o Macros
o Custom Toolbar
o Adding Speech
o Evaluate the Color Code
o Text to Speech
o Conclusion
* Example 9. RTD to 4 20 mA Converter: XTR105
o Model Description
o Acquiring RTD Tables
o Lookup RTD Value
o Creating a Function
o Accessing a Function
o Adding a Help Description to a Function
o Creating the Model in Excel
o Standard Resistor Values
o Creation of Add-In
o Installing the NearestValues Add-In
o Back to the Project At Hand
o Prompting for User Input
o Printout
o Running Macros when the Workbook is Started
o Running from the Desktop
* Example 10. Voltage Regulator: LM317
o Model Description
o Installing the NearestValues Add-In
o Initial Model
o Goal Seek
o Worst Case Analysis
o Thermal Analysis
o Half-Wave Rectification
o True RMS and Integration
o More Preparation
o Standard Capacitance Value
o Chart
o Conclusion
* Example 11. TL431 Adjustable Voltage Reference
o Model Description
o Installing the NearestValues Add-In
o Initial Model
o Solver
o Standard Resistor Values
o Adding a Macro
o Report Generation
o Limitations
* Example 12. 555 Timer
o Model Description
o Monostable Operation
o Setup
o Add User Form
o Add Image Control
o Second Image
o Modifying Form Location
o Monostable Pulse Width Entry
o Command Button
o Solver
o Standard Values
o SolverSolve
o Using Standard Capacitor Values
o Tidying Up
o Astable Operation
o Worksheet Setup
* Example 13. Purchase Order Generator
o Model Description
o Create a Purchase Order
o Print Macro
o User Form
o Initial Procedure
o Event Actions
o Auto Startup
o Running PurchaseOrder
* Example 14. Interface to a Digital Multimeter Using a se-ri-@l Port
o Model Description
o DMM Interface Protocol
o MSComm32
o Initializing the se-ri-@l Port
o Conversion of DMM Display to Data
o Analog Meter Chart
o Zone Identification
o Data Plot Chart Recorder
o Food For Thought
* Example 15. Vernier Caliper Interface
o Model Description
o Pinout
o Hardware Interface
o Timing Diagram
o Installing IO.DLL
o PC Parallel Port
o First Steps
o Actual Interface
o Acquiring Data
o Adding Sound
o Thoughts on Improvement
o Statistics
* Example 16. Function Generator Interface
o Model Description
o se-ri-@l Interface
o Workbook Open and Close
o Adding VBA Controls: Granularity
o Adding VBA Controls: Frequency
o Waveform Sampling Frequency
o Bump Frequency
o Generating Frequency Tables
o Add a Chart
o Download Waveform
o Setting the Amplitude
o Skew
o Average Voltage, RMS Voltage
* Appendix A: VBA and Excel
o Where Do Macros, Procedures and Functions Get Stored?
o Using a Macro
o Personal Macro Workbook
o Open Workbooks at Startup
o Accessing a Function Across Workbook Boundaries
o Template
o Add-Ins
o Automatic Startup
o Private
o Running a Macro
o Finding the Stop Recording Macro Toolbar
o Actions Recorded During Macro Record
o Names
o Naming Objects
o Naming Constants
o Naming Formulas
o Absolute and Relative Reference
o Moving Cell Selection Relative to Current Cell
o Cell Access
o Detecting Blank Cells
o Extended Range Selection
o Accessing Data off the Current Sheet
o Accessing a Procedure in a Different Module
o Accessing a Procedure in a Different Workbook
o Recalculate
o Screen Update
o Exit
o Workbook Open, Activation
o Multiple Actions on an Object: With Statement
o Using an Excel Function in VBA
o Arrays
o Array Formula
o Returning an Array from a Function
o Error Values
o Useful Functions
o Web Resources
* Appendix B: Parallel and se-ri-@l I/O
o Parallel (Printer) Port
o se-ri-@l Port
o Possible Hardware Sources
* References
* About the Author
* Index
* CD-ROM License Agrement