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

Trang

20 December, 2019

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

Excel by Example A Microsoft Excel Cookbook for Electronics Engineer

Book Details :
LanguageEnglish
Pages385
FormatPDF
Size14.7 MB

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






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

No comments:

Post a Comment

Recent Comments