---

Book Details :
Language	English
Pages	385
Format	PDF
Size	14.7 MB

---

[Free ebook]Excel by Example A Microsoft Excel Cookbook for Electronics Engineer

DOWNLOAD

Excel by Example A Microsoft Excel Cookbook for Electronics Engineer by Aubrey Kagan | PDF Free Download.

Contents of Excel by Example for Electronics Engineer PDF

---

EXAMPLE 1: Voltage-to-Current Converte

• Model Description 
• Starting Excel 
• Data Entry into a Worksheet 
• Autofill 
• Bulk Formatting 
• Formulas 
• Copying Formulas 
• Relative and Absolute References 
• Naming Cells 
• Hiding Cells 
• Borders 
• Bells and Whistles 
• Conditional IF and Absolute Value 
• Chart 
• Error Bars 
• Adding a Trendline 
• Macro: Timer

EXAMPLE 2: Baud Rate Selection

• Model Description 
• Setup Workbook 
• Hexadecimal 
• Lookup Tables 
• Conditional Formatting 
• Macro

EXAMPLE 3: Mean Time Between Failures (MTBF)

• Model Description 
• Factors
• Bill of Material 
• Calculating the Quality Factor 
• Calculate Electrical Stress Factor 
• Calculation of λG 
• Scenario

EXAMPLE 4: Counting Machine Cycles

• Model Description 
• Importing the File 
• Extracting Op-code 
• Opening a Second Workbook 
• Cross Workbook Reference 
• Easing the Pain of Nested IFs 

EXAMPLE 5: Character Generator

• Model Description 
• Creating the Basic Workbook 
• LEN Function 
• Forms Controls 
• Text Orientation 
• Comments 
• Double-Click Macro 
• Macro Activation by the Command Button 
• Save to Data File 
• Usage

EXAMPLE 6: 8052 Microcomputer Register Setup

• Model Description 
• Spreadsheet Concept 
• Counter/Timer Sheet 
• Timer Counter Control Register TCON 
• Counting Types 
• Macros to Hide and Unhide 
• Adding Forms 
• Add Image Control 
• Timer/Counter Sheet 
• Timer/Counter Sheet 
• Serial Port Sheet 
• Interrupt Control Sheet 
• Summary Sheet 
• Initialize Values 
• Conclusion

EXAMPLE 7: Finding the Optimal Resistor Combination: LP 2951

• Model Description       
• Custom Autofill       
• Data Tables       
• Min Function       
• MATCH Function 
• INDEX Function       
• Block Conditional Formatting 

EXAMPLE 8: Resistor Color Code Decoder Using Speech Input

• Model Description       
• Implementing Speech Recognition       
• Viewing and Hiding the Language Bar       
• Worksheet Setup       
• Macros       
• Custom Toolbar       
• Adding Speech       
• Evaluate the Color Code       
• Text to Speech       
• Conclusion

EXAMPLE 9: RTD to 4–20 mA Converter: XTR105

• Model Description 
• Acquiring RTD Tables 
• Lookup RTD Value 
• Creating a Function 
• Accessing a Function 
• Adding a Help Description to a Function 
• Creating the Model in Excel 
• Standard Resistor Values 
• Creation of Add-In 
• Installing the NearestValues Add-In 
• Back to the Project At Hand 
• Prompting for User Input 
• Printout 
• Running Macros when the Workbook is Started 
• Running from the Desktop

EXAMPLE 10: Voltage Regulator: LM317

• Model Description 
• Installing the NearestValues Add-In 
• Initial Model 
• Goal Seek 
• Worst Case Analysis 
• Thermal Analysis 
• Half-Wave Rectification 
• True RMS and Integration 
• More Preparation 
• Standard Capacitance Value 
• Chart 
• Conclusion

EXAMPLE 11: TL431 Adjustable Voltage Reference

• Model Description 
• Installing the NearestValues Add-In
• Initial Model 
• Solver 
• Standard Resistor Values 
• Adding a Macro 
• Limitations

EXAMPLE 12: 555 Timer

• Model Description 
• Monostable Operation 
• Setup 
• Add User Form 
• Add Image Control 
• Second Image 
• Modifying Form Location 
• Monostable Pulse Width Entry 
• Command Button 
• Solver 
• Standard Values 
• SolverSolve 
• Using Standard Capacitor Values 
• Tidying Up 
• Astable Operation 
• Worksheet Setup

EXAMPLE 13: Purchase Order Generator

• Model Description 
• Create a Purchase Order 
• Print Macro 
• User Form 
• Initial Procedure 
• Event Actions 
• Auto Startup 
• Running Purchase Order

EXAMPLE 14: Interface to a Digital MultimeterUsing a Serial Port

• Model Description 
• DMM Interface Protocol 
• MSComm 
• Initializing the Serial Port 
• Conversion of DMM Display to Data 
• Analog Meter Chart 
• Zone Identification 
• Data Plot—Chart Recorder 
• Food For Thought

EXAMPLE 15: Vernier Caliper Interface

• Model Description 
• Pinout 
• Hardware Interface 
• Timing Diagram 
• Installing IO DLL 
• PC Parallel Port 
• First Steps 
• Actual Interface 
• Acquiring Data 
• Adding Sound 
• Thoughts on Improvement 
• Statistics

EXAMPLE 16: Function Generator Interface

• Model Description 
• Serial Interface 
• Workbook Open and Close 
• Adding VBA Controls: Granularity 
• Adding VBA Controls: Frequency 
• Waveform Sampling Frequency 
• Bump Frequency 
• Generating Frequency Tables 
• Add a Chart 
• Download Waveform 
• Setting the Amplitude 
• Skew 
• Average Voltage, RMS Voltage

Download Excel by Example A Cookbook for Electronics Engineer in PDF Format For Free.

#evba #etipfree
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1