What Every Engineer Should Know About Excel

What Every Engineer Should Know About Excel
Author: J. P. Holman
Publisher: CRC Press
Total Pages: 383
Release: 2017-10-12
Genre: Technology & Engineering
ISBN: 1351976478

Understanding the powerful computational and graphics capabilities of Microsoft Excel is an enormous benefit to engineers and technical professionals in almost any field and at all levels of experience. What Every Engineer Should Know About Excel is a practical guide to unlocking the features and functions of this program, using examples and screenshots to walk readers through the steps to build a strong understanding of the material. This second edition is updated to reflect the latest version of Excel (2016) and expands its scope to include data management, connectivity to external data sources, and integration with "the cloud" for optimal use of the Excel product. It also introduces the ribbon bar navigation prevalent in Microsoft products beginning with the 2007 version of MS Office. Covering a variety of topics in self-contained chapters, this handy guide will also prove useful for professionals in IT, finance, and real estate.

What Every Engineer Should Know About Excel

What Every Engineer Should Know About Excel
Author: J. P. Holman
Publisher: CRC Press
Total Pages: 244
Release: 2006-06-09
Genre: Technology & Engineering
ISBN: 0849373263

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!

What Every Engineer Should Know About Excel

What Every Engineer Should Know About Excel
Author: J. P. Holman
Publisher: CRC Press
Total Pages: 239
Release: 2006-06-09
Genre: Technology & Engineering
ISBN: 142000719X

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!

What Every Engineer Should Know About Modeling and Simulation

What Every Engineer Should Know About Modeling and Simulation
Author: Raymond J. Madachy
Publisher: CRC Press
Total Pages: 173
Release: 2017-09-01
Genre: Computers
ISBN: 1498753124

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.

What Every Engineer Should Know about Software Engineering

What Every Engineer Should Know about Software Engineering
Author: Phillip A. Laplante
Publisher: CRC Press
Total Pages: 428
Release: 2022-11-03
Genre: Computers
ISBN: 1000775976

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.

What Every Engineer Should Know About Digital Accessibility

What Every Engineer Should Know About Digital Accessibility
Author: Sarah Horton
Publisher: CRC Press
Total Pages: 258
Release: 2024-04-30
Genre: Business & Economics
ISBN: 1040009832

Accessibility is a core quality of digital products to be deliberately addressed throughout the development lifecycle. What Every Engineer Should Know About Digital Accessibility will prepare readers to integrate digital accessibility into their engineering practices. Readers will learn how to accurately frame accessibility as an engineering challenge so they are able to address the correct problems in the correct way. Illustrated with diverse perspectives from accessibility practitioners and advocates, this book describes how people with disabilities use technology, the nature of accessibility barriers in the digital world, and the role of engineers in breaking down those barriers. Accessibility competence for current, emerging, and future technologies is addressed through a combination of guiding principles, core attributes and requirements, and accessibility‐informed engineering practices. FEATURES Discusses how technology can support inclusion for people with disabilities and how rigorous engineering processes help create quality user experiences without introducing accessibility barriers Explains foundational principles and guidelines that build core competency in digital accessibility as they are applied across diverse and emerging technology platforms Highlights practical insights into how engineering teams can effectively address accessibility throughout the technology development lifecycle Uses international standards to define and measure accessibility quality Written to be accessible to non‐experts in the subject area, What Every Engineer Should Know About Digital Accessibility is aimed at students, professionals, and researchers in the field of software engineering.

What Every Engineer Should Know about Software Engineering

What Every Engineer Should Know about Software Engineering
Author: Philip A. Laplante
Publisher: CRC Press
Total Pages: 330
Release: 2007-04-25
Genre: Computers
ISBN: 1420006746

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

What Every Engineer Should Know About Developing Real-Time Embedded Products

What Every Engineer Should Know About Developing Real-Time Embedded Products
Author: Kim R. Fowler
Publisher: CRC Press
Total Pages: 496
Release: 2007-10-24
Genre: Computers
ISBN: 0849379636

You can find them in your wristwatch or MP3 player; they perform specific functions in washing machines, traffic lights, and even pacemakers. Embedded systems are pervasive, ubiquitous, and widespread throughout our daily lives. Developing these real-time embedded products requires an understanding of the interactions between different disciplines,

What Every Engineer Should Know About Business Communication

What Every Engineer Should Know About Business Communication
Author: John X. Wang
Publisher: CRC Press
Total Pages: 208
Release: 2008-05-15
Genre: Technology & Engineering
ISBN: 0849383978

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