๐”– Scriptorium
โœฆ   LIBER   โœฆ

๐Ÿ“

Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers

โœ Scribed by Aubrey Kagan


Publisher
Newnes
Year
2004
Tongue
English
Leaves
385
Category
Library

โฌ‡  Acquire This Volume

No coin nor oath required. For personal study only.

โœฆ Synopsis


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 for statistical analysis, databases, and linking into Excel from other sources, such as data from a serial port. The book is basically an engineering cookbook, with each chapter providing tutorial information along with several Excel "recipes" of interest to electronics engineers. The accompanying CD-ROM features ready-to-run, customizable Excel worksheets derived from the book examples, which will be useful tools to add to any electronics engineer's spreadsheet toolbox. Engineers are looking for any and all means to increase their efficiency and add to their "bag of design tricks." Just about every electronics engineer uses Excel but most feel that the program has many more features to offer, if they only knew what they were! The Excel documentation is voluminous and electronics engineers don't have the time to read it all and sift through looking for those features that are directly applicable to their jobs and figure out how to use them. This book does that task for them-pulls out those features that they need to know about and shows them how to make use of them in specific design examples that they can then tailor to their own design needs. This is the ONLY book to deal with Excel specifically in the electronics field Distills voluminous and time-consuming Excel documentation down to nitty-gritty explanations of those features that are directly applicable to the electronics engineer's daily job duties *The accompanying CD-ROM provides ready-to-use, fully-customizable worksheets from the book's examples

โœฆ Table of Contents


Cover......Page 1
Contents......Page 8
Voltage-to-Current Converter......Page 20
Baud Rate Selection......Page 45
Mean Time Between Failures......Page 60
Counting Machine Cycles......Page 77
Character Generator......Page 88
8052 Microcomputer Register Setup......Page 105
Finding the Optimal Resistor Combination: LP 2951......Page 137
Resistor Color Code Decoder Using Speech Input......Page 146
RTD to 4โ€“20 mA Converter: XTR105......Page 162
Voltage Regulator: LM317......Page 186
TL431 Adjustable Voltage Reference......Page 209
555 Timer......Page 225
Purchase Order Generator......Page 248
Interface to a Digital Multimeter Using a Serial Port......Page 259
Vernier Caliper Interface......Page 300
Function Generator Interface......Page 320
Appendix A VBA and Excel......Page 352
Appendix B Parallel and Serial I/O......Page 368
Index......Page 378


๐Ÿ“œ SIMILAR VOLUMES


Excel by Example: A Microsoft Excel Cook
โœ Aubrey Kagan ๐Ÿ“‚ Library ๐Ÿ“… 2004 ๐Ÿ› Newnes ๐ŸŒ English

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 eng

Excel by Example: A Microsoft Excel Cook
โœ Aubrey Kagan ๐Ÿ“‚ Library ๐Ÿ“… 2004 ๐Ÿ› Newnes ๐ŸŒ English

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 eng

Excel by Example A Mcrosoft Excel Cookbo
โœ Aubrey Kagan ๐Ÿ“‚ Library ๐Ÿ“… 2004 ๐Ÿ› Newnes ๐ŸŒ English

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 eng

Excel Example A Microsoft Excel Cookbook
โœ Aubrey Kagan ๐Ÿ“‚ Library ๐Ÿ“… 2004 ๐Ÿ› Newnes ๐ŸŒ English

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 eng

Excel Cookbook: Recipes for Mastering Mi
โœ Dawn Griffiths ๐Ÿ“‚ Library ๐Ÿ“… 2024 ๐Ÿ› O'Reilly Media ๐ŸŒ English

Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource for intermediate to advanced users of Excel. You'll find complete recipes for more than a dozen topics covering formulas, PivotTables, charts, Power Query, and more. Each recipe poses a particular problem and out

Excel Cookbook: Recipes for Mastering Mi
โœ Dawn Griffiths ๐Ÿ“‚ Library ๐Ÿ“… 2024 ๐Ÿ› O'Reilly Media ๐ŸŒ English

<p><span>Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource for intermediate to advanced users of Excel. You'll find complete recipes for more than a dozen topics covering formulas, PivotTables, charts, Power Query, and more. Each recipe poses a particular proble