What Every Engineer Should Know About Excel

Download or read book What Every Engineer Should Know About Excel written by J. P. Holman and published by CRC Press. This book was released on 2006-06-09 with total page 244 pages. Available in PDF, EPUB and Kindle. Book excerpt: With the many software packages available today, it's easy to overlook the computational and graphics capabilities offered by Microsoft® ExcelTM. The software is nearly ubiquitous and understanding its capabilities is an enormous benefit to engineers in almost any field and at all levels of experience. What Every Engineer Should Know About Excel offers in nine self-contained chapters a practical guide to the features and functions that can be used, for example, to solve equations and systems of equations, build charts and graphs, create line drawings, and perform optimizations. The author uses examples and screenshots to walk you through the steps and build a strong understanding of the material. With this book, you will learn how to... Set up the keyboard for direct entry of most math and Greek symbols Build a default scatter graph that is applicable to most simple presentations with little cosmetic modification Apply many types of formats to adjust the cosmetics of graphs Use 3D surface and area charts for data and functional representations, with associated cosmetic adjustments Correlate data with various types of functional relations Use line drawing tools to construct simple schematics or other diagrams Solve linear and nonlinear sets of equations using multiple methods Curve student grades using Excel probability functions Model device performance using different types of regression analysis involving multiple variables Manipulate Excel financial functions Calculate retirement accumulation with variable contribution rate and retirement payouts to match increases in inflation Apply Excel methods for optimization problems with both linear and nonlinear relations Use pivot tables to manipulate both experimental data and analytical relationships Calculate experimental uncertainties using Excel And much more!

Download or read book Excel by Example written by Aubrey Kagan and published by Newnes. This book was released on 2004-05-19 with total page 385 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Download or read book What Every Engineer Should Know About Modeling and Simulation written by Raymond J. Madachy and published by CRC Press. This book was released on 2017-09-01 with total page 173 pages. Available in PDF, EPUB and Kindle. Book excerpt: This practical book presents fundamental concepts and issues in computer modeling and simulation (M&S) in a simple and practical way for engineers, scientists, and managers who wish to apply simulation successfully to their real-world problems. It offers a concise approach to the coverage of generic (tool-independent) M&S concepts and enables engineering practitioners to easily learn, evaluate, and apply various available simulation concepts. Worked out examples are included to illustrate the concepts and an example modeling application is continued throughout the chapters to demonstrate the techniques. The book discusses modeling purposes, scoping a model, levels of modeling abstraction, the benefits and cost of including randomness, types of simulation, and statistical techniques. It also includes a chapter on modeling and simulation projects and how to conduct them for customer and engineer benefit and covers the stages of a modeling and simulation study, including process and system investigation, data collection, modeling scoping and production, model verification and validation, experimentation, and analysis of results.

Download or read book What Every Engineer Should Know About Career Management written by Mike Ficco and published by CRC Press. This book was released on 2016-04-19 with total page 262 pages. Available in PDF, EPUB and Kindle. Book excerpt: Thanks to their education, experience, and general philosophical orientation, many engineers fail to notice critical issues in the workplace that can directly impact their career advancement and day-to-day job satisfaction. This text focuses on career management, and the accompanying importance of human and social interactions in the office. Althou

Download or read book What Every Engineer Should Know About Business Communication written by John X. Wang and published by CRC Press. This book was released on 2008-05-15 with total page 208 pages. Available in PDF, EPUB and Kindle. Book excerpt: Engineers must possess a range of business communication skills that enable them to effectively communicate the purpose and relevance of their idea, process, or technical design. This unique business communication text is packed with practical advice that will improve your ability to- Market ideas Write proposals Generate enthusiasm for research De

Download or read book What Every Engineer Should Know about Software Engineering written by Philip A. Laplante and published by CRC Press. This book was released on 2007-04-25 with total page 330 pages. Available in PDF, EPUB and Kindle. Book excerpt: Do you Use a computer to perform analysis or simulations in your daily work? Write short scripts or record macros to perform repetitive tasks? Need to integrate off-the-shelf software into your systems or require multiple applications to work together? Find yourself spending too much time working the kink

Download or read book What Every Engineer Should Know about Software Engineering written by Phillip A. Laplante and published by CRC Press. This book was released on 2022-11-03 with total page 395 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book offers a practical approach to understanding, designing, and building sound software based on solid principles. Using a unique Q&A format, this book addresses the issues that engineers need to understand in order to successfully work with software engineers, develop specifications for quality software, and learn the basics of the most common programming languages, development approaches, and paradigms. The new edition is thoroughly updated to improve the pedagogical flow and emphasize new software engineering processes, practices, and tools that have emerged in every software engineering area. Features: Defines concepts and processes of software and software development, such as agile processes, requirements engineering, and software architecture, design, and construction. Uncovers and answers various misconceptions about the software development process and presents an up-to-date reflection on the state of practice in the industry. Details how non-software engineers can better communicate their needs to software engineers and more effectively participate in design and testing to ultimately lower software development and maintenance costs. Helps answer the question: How can I better leverage embedded software in my design? Adds new chapters and sections on software architecture, software engineering and systems, and software engineering and disruptive technologies, as well as information on cybersecurity. Features new appendices that describe a sample automation system, covering software requirements, architecture, and design. This book is aimed at a wide range of engineers across many disciplines who work with software.