Excel by example [[electronic resource] ] : a Microsoft Excel cookbook for electronics engineers / / by Aubrey Kagan

• Autore: Kagan Aubrey
• Pubblicazione: Amsterdam ; ; Boston, : Elsevier/Newnes, c2004
• Descrizione fisica: 1 online resource (384 p.)
• Disciplina: 621.381/0285/554
• Soggetto topico: Electrical engineering - Data processing
• Soggetto genere / forma: Electronic books.
• Note generali: Description based upon print version of record.
• Nota di bibliografia: Includes bibliographical references (p. 354-356) and index.
• Nota di contenuto: Cover; Contents; Acknowledgments; Introduction; EXAMPLE 1: Voltage-to-Current Converter; 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 0 Sheet; Timer Counter Control Register TCON; Counting Types; Macros to Hide and Unhide; Adding Forms; Add Image Control; Timer/Counter 1 Sheet; Timer/Counter 2 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 Nearest Values 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 Neares tValues 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 Nearest Values 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
• Sommario/riassunto: The spreadsheet has become a ubiquitous engineering tool, and Microsoft Excel is the standard spreadsheet software package. Over the years, Excel has become such a complex program that most engineers understand and use only a tiny part of its power and features. This book is aimed at electronics engineers and technicians in particular, showing them how to best use Excel's features for computations, circuit modeling, graphing, and data analysis as applied to electronics design. Separate chapters cover lookup tables and file I/O, using macros, graphing, controls, using Analysis Toolpak
• Titolo autorizzato: Excel by example
• ISBN: 1-4175-3714-0; 1-281-00977-6; 9786611009779; 0-08-047767-4
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910449814603321
• Lo trovi qui: Univ. Federico II