A Microsoft Excel Cookbook for Electronics Engineers(Excel by Example) : 8051 Microcontroller Projects AVR PIC Projects Tutorials Ebooks Libraries codes

Forums

Rickey's World :: Discussion Forums :: Discuss and Learn :: E-books and Tutorials :: Electronics		<< Previous thread \| Next thread >>
A Microsoft Excel Cookbook for Electronics Engineers(Excel by Example)


Moderators: Ajay Bhargav, Arun Kumar V, pdi33, Shailesh NAYAK, ۞ TPS ۞, shyam, sashijoseph, ExperimenterUK, DavesGarage

Author

Post

Nisar Ahmed

Thu Oct 11 2007, 05:22PM

Registered Member #1201

Joined: Fri May 25 2007, 11:27PM

Posts: 360
Thanked 183 times in 121 posts

Hi all scientists/Electronics Engineers

Book Description:
Excel by Example shows you how you can use the ubiquitous spreadsheet application to model and analyze parts of your design can help you become more efficient in many of the small-scale aspects of design. These aspects can take a suprisingly large amount of your time and yield many benefits when you work efficiently. The author has written for Circuit Cellar, and he must know his subject - EDN August 2004 This is an excellent resource for electronics engineers (and enthusiasts), and a great guide to the use of spreadsheet programs to high-end applications. Very well written and presented. - PC Update Online, Major Keary.
Collection name: Electronics & Electrical

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 Serial 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 Serial Port
o Model Description
o DMM Interface Protocol
o MSComm32
o Initializing the Serial 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 Serial 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 Serial I/O
o Parallel (Printer) Port
o Serial Port
o Possible Hardware Sources
* References
* About the Author
* Index
* CD-ROM License Agrement

DOWNLOAD FROM:
http://rapidshare.com/files/4582527/e0750677562.pdf

Thanks

Nisar Ahmed (Pakistan0
M.Sc: Electronics
Department :R and D

Email:nisar_sci@yahoo.com

Nisar