[PDF] Excel by Example A Microsoft Excel Cookbook for Electronics Engineer

Contents of Excel by Example for Electronics Engineer PDF

EXAMPLE 1: Voltage-to-Present Converte

• Mannequin Description 
• Beginning Excel 
• Knowledge Entry right into a Worksheet 
• Autofill 
• Bulk Formatting 
• Formulation 
• Copying Formulation 
• Relative and Absolute References 
• Naming Cells 
• Hiding Cells 
• Borders 
• Bells and Whistles 
• Conditional IF and Absolute Worth 
• Chart 
• Error Bars 
• Including a Trendline 
• Macro: Timer

EXAMPLE 2: Baud Fee Choice

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

EXAMPLE 3: Imply Time Between Failures (MTBF)

• Mannequin Description 
• Elements
• Invoice of Materials 
• Calculating the High quality Issue 
• Calculate Electrical Stress Issue 
• Calculation of λG 
• State of affairs

EXAMPLE 4: Counting Machine Cycles

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

EXAMPLE 5: Character Generator

• Mannequin Description 
• Creating the Primary Workbook 
• LEN Perform 
• Types Controls 
• Textual content Orientation 
• Feedback 
• Double-Click on Macro 
• Macro Activation by the Command Button 
• Save to Knowledge File 
• Utilization

EXAMPLE 6: 8052 Microcomputer Register Setup

• Mannequin Description 
• Spreadsheet Idea 
• Counter/Timer Sheet 
• Timer Counter Management Register TCON 
• Counting Sorts 
• Macros to Cover and Unhide 
• Including Types 
• Add Picture Management 
• Timer/Counter Sheet 
• Timer/Counter Sheet 
• Serial Port Sheet 
• Interrupt Management Sheet 
• Abstract Sheet 
• Initialize Values 
• Conclusion

EXAMPLE 7: Discovering the Optimum Resistor Mixture: LP 2951

• Mannequin Description       
• Customized Autofill       
• Knowledge Tables       
• Min Perform       
• MATCH Perform 
• INDEX Perform       
• Block Conditional Formatting

EXAMPLE 8: Resistor Shade Code Decoder Utilizing Speech Enter

• Mannequin Description       
• Implementing Speech Recognition       
• Viewing and Hiding the Language Bar       
• Worksheet Setup       
• Macros       
• Customized Toolbar       
• Including Speech       
• Consider the Shade Code       
• Textual content to Speech       
• Conclusion

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

• Mannequin Description 
• Buying RTD Tables 
• Lookup RTD Worth 
• Making a Perform 
• Accessing a Perform 
• Including a Assist Description to a Perform 
• Creating the Mannequin in Excel 
• Customary Resistor Values 
• Creation of Add-In 
• Putting in the NearestValues Add-In 
• Again to the Challenge At Hand 
• Prompting for Consumer Enter 
• Printout 
• Operating Macros when the Workbook is Began 
• Operating from the Desktop

EXAMPLE 10: Voltage Regulator: LM317

• Mannequin Description 
• Putting in the NearestValues Add-In 
• Preliminary Mannequin 
• Objective Search 
• Worst Case Evaluation 
• Thermal Evaluation 
• Half-Wave Rectification 
• True RMS and Integration 
• Extra Preparation 
• Customary Capacitance Worth 
• Chart 
• Conclusion

EXAMPLE 11: TL431 Adjustable Voltage Reference

• Mannequin Description 
• Putting in the NearestValues Add-In
• Preliminary Mannequin 
• Solver 
• Customary Resistor Values 
• Including a Macro 
• Limitations

EXAMPLE 12: 555 Timer

• Mannequin Description 
• Monostable Operation 
• Setup 
• Add Consumer Type 
• Add Picture Management 
• Second Picture 
• Modifying Type Location 
• Monostable Pulse Width Entry 
• Command Button 
• Solver 
• Customary Values 
• SolverSolve 
• Utilizing Customary Capacitor Values 
• Tidying Up 
• Astable Operation 
• Worksheet Setup

EXAMPLE 13: Buy Order Generator

• Mannequin Description 
• Create a Buy Order 
• Print Macro 
• Consumer Type 
• Preliminary Process 
• Occasion Actions 
• Auto Startup 
• Operating Buy Order

EXAMPLE 14: Interface to a Digital MultimeterUsing a Serial Port

• Mannequin Description 
• DMM Interface Protocol 
• MSComm 
• Initializing the Serial Port 
• Conversion of DMM Show to Knowledge 
• Analog Meter Chart 
• Zone Identification 
• Knowledge Plot—Chart Recorder 
• Meals For Thought

EXAMPLE 15: Vernier Caliper Interface

• Mannequin Description 
• Pinout 
• {Hardware} Interface 
• Timing Diagram 
• Putting in IO DLL 
• PC Parallel Port 
• First Steps 
• Precise Interface 
• Buying Knowledge 
• Including Sound 
• Ideas on Enchancment 
• Statistics

EXAMPLE 16: Perform Generator Interface

• Mannequin Description 
• Serial Interface 
• Workbook Open and Shut 
• Including VBA Controls: Granularity 
• Including VBA Controls: Frequency 
• Waveform Sampling Frequency 
• Bump Frequency 
• Producing Frequency Tables 
• Add a Chart 
• Download Waveform 
• Setting the Amplitude 
• Skew 
• Common Voltage, RMS Voltage

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