Engineering with Excel

Author: Ronald W. Larsen

Publisher: Pearson

ISBN: 9780134589664

Category: Computers

Page: 720

View: 8590

For courses in Introduction to Engineering and Computer Methods for Engineers. Gives Students A Foundation In Excel Functions For Various Engineering Purposes Engineering With Excel , 5th Edition introduces students to all of the functions and ways to use Microsoft's Excel 2016 on Windows 10, the most up-to-date version of the program. The text gives students an understanding of the many ways Excel can be used for engineering purposes. Chapters on graphing, matrix operations, linear regressions and statistics give students a foundation in computational math, while sections on using excel for finance and extending it to other computer programs helps students apply Excel to their broader lives. Finally, students will learn to write their own excel functions.

Engineering with Excel

Author: Ronald W. Larsen

Publisher: Prentice Hall

ISBN: 9780132788656

Category: Computers

Page: 709

View: 1293

For introductory courses in Engineering and Computing Based on¿Excel 2010, Engineering with Excel, 4e takes a comprehensive look at using Excel in engineering.¿ This book focuses on applications and is intended to serve as both a textbook and a reference for students.

Engineering with Excel

Author: Ronald W. Larsen

Publisher: N.A

ISBN: 9780131475113

Category: Technology & Engineering

Page: 552

View: 6049

This title allows professors to customize their textbooks through the ESource website. Professors can pick and choose complete modules as well as custom-build a freshman engineering text that matches their content needs and course organization. Using the ESource online BookBuild system, they can view and select book chapters and more.

What Every Engineer Should Know About Excel

Author: J. P. Holman

Publisher: CRC Press

ISBN: 0849373263

Category: Technology & Engineering

Page: 248

View: 3103

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!

MATLAB Programming for Engineers

Author: Stephen J. Chapman

Publisher: Cengage Learning

ISBN: 1305445368

Category: Technology & Engineering

Page: 672

View: 365

Emphasizing problem-solving skills throughout, this fifth edition of Chapman's highly successful book teaches MATLAB as a technical programming language, showing students how to write clean, efficient, and well-documented programs, while introducing them to many of the practical functions of MATLAB. The first eight chapters are designed to serve as the text for an Introduction to Programming / Problem Solving course for first-year engineering students. The remaining chapters, which cover advanced topics such as I/O, object-oriented programming, and Graphical User Interfaces, may be covered in a longer course or used as a reference by engineering students or practicing engineers who use MATLAB. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Spreadsheet Tools for Engineers using Excel

Author: Byron Gottfried

Publisher: McGraw-Hill Education

ISBN: 9780072971842

Category: Technology & Engineering

Page: 512

View: 3444

Through previous editions, this practical text has found a permanent spot in many introductory engineering courses by successfully combining an introduction to Excel fundamentals with a clear presentation on how Excel can be used to solve common engineering problems. Updated to ensure compatability with all recent versions of Excel, this third edition of Spreadsheet Tools for Engineers provides beginning engineering students with a strong foundation in problem solving using Excel as the modern day equivalent of the slide rule. As part of McGraw-Hill's BEST series for freshman engineering curricula, this text is particularly geared toward introductory students. The author provides plenty of background information on technical terms, and numerous examples illustrating both traditional and spreadsheet solutions for a variety of engineering problems. The first three chapters introduce the basics of problem solving and Excel fundamentals. Beyond that, the chapters are largely independent of one another. Topics covered include graphing data, converting units, analyzing data, interpolation and curve fitting, solving equations, evaluating integrals, writing macros, and comparing economic alternatives.

Excel for Engineers and Scientists

Author: S. C. Bloch

Publisher: John Wiley & Sons Incorporated

ISBN: 9780471256861

Category: Technology & Engineering

Page: 281

View: 6030

In this basic introduction, the author aims to help engineers and scientists to understand and use Excel in their fields. The book is interactive and designed to be used in conjunction with a computer, to provide a hands-on learning experience.

Excel for Scientists and Engineers

Numerical Methods

Author: E. Joseph Billo

Publisher: John Wiley & Sons

ISBN: 0470126701

Category: Computers

Page: 480

View: 8163

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's® capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices Find roots of equations and solve systems of simultaneous equations Solve ordinary differential equations and partial differential equations Perform linear and non-linear regression Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: All the spreadsheets, charts, and VBA code needed to perform the examples from the text Solutions to most of the end-of-chapter problems An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package

Statistical Analysis with Excel For Dummies

Author: Joseph Schmuller

Publisher: John Wiley & Sons

ISBN: 1119271169

Category: Computers

Page: 552

View: 8765

There's nothing random about it—this is the book on statistical analysis with Excel Stunned by statistics? Exhausted by Excel? Relax! Statistical Analysis with Excel For Dummies, 4th Edition shows you how to use the world's most popular spreadsheet program to crunch numbers and interpret statistics—even if you've never taken a statistics or advanced math course. In no time, you'll learn to use Excel to create and translate statistics in everyday life, understand common statistical terms, and improve your classroom or professional skills. Statistics has a reputation for being a challenging, math-intensive pursuit—but it doesn't have to make your palms sweat. Using a minimum of equations and assuming no prior knowledge of statistics or Excel, this hands-on guide cuts through the jargon and shows you how to make sense of formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends and correlations, and much more. Use Excel's tools to analyze and understand data Apply statistical analysis to predict trends and make decisions Interpret sales figures, gambling odds, and sports stats Develop a grading curve or medical correlations Forget the mumbo jumbo! This guide shows you that statistical analysis with Excel can be easy, fun, and useful!

Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB

Author: Victor J. Law

Publisher: CRC Press

ISBN: 1482201593

Category: Mathematics

Page: 247

View: 7543

While teaching the Numerical Methods for Engineers course over the last 15 years, the author found a need for a new textbook, one that was less elementary, provided applications and problems better suited for chemical engineers, and contained instruction in Visual Basic® for Applications (VBA). This led to six years of developing teaching notes that have been enhanced to create the current textbook, Numerical Methods for Chemical Engineers Using Excel®, VBA, and MATLAB®. Focusing on Excel gives the advantage of it being generally available, since it is present on every computer—PC and Mac—that has Microsoft Office installed. The VBA programming environment comes with Excel and greatly enhances the capabilities of Excel spreadsheets. While there is no perfect programming system, teaching this combination offers knowledge in a widely available program that is commonly used (Excel) as well as a popular academic software package (MATLAB). Chapters cover nonlinear equations, Visual Basic, linear algebra, ordinary differential equations, regression analysis, partial differential equations, and mathematical programming methods. Each chapter contains examples that show in detail how a particular numerical method or programming methodology can be implemented in Excel and/or VBA (or MATLAB in chapter 10). Most of the examples and problems presented in the text are related to chemical and biomolecular engineering and cover a broad range of application areas including thermodynamics, fluid flow, heat transfer, mass transfer, reaction kinetics, reactor design, process design, and process control. The chapters feature "Did You Know" boxes, used to remind readers of Excel features. They also contain end-of-chapter exercises, with solutions provided.

Excel Formulas and Functions For Dummies

Author: Ken Bluttman

Publisher: John Wiley & Sons

ISBN: 111907679X

Category: Computers

Page: 408

View: 1820

Grab these Excel formulas and functions to make your life easier! Are you intimidated by major financial choices, like which loan to get or how to grow your savings? Don't worry—we all are! But Excel Formulas & Functions For Dummies, 4th Edition can take some of the pain out of the data organization and analysis processes. This step-by-step reference sheds light on Microsoft Excel's 150 most useful functions, and offers detailed instructions on how to implement them. Additionally, each function is illustrated by helpful, real-world examples that show how they are used within a larger formula. To take your knowledge of Excel's functions a step further, 85 specialized functions are described in abbreviated form so you can use Excel to better support your decision-making process when securing a mortgage, buying a car, computing classroom grades, evaluating investment performance, and more. Functions are predefined formulas that you can use to make data analysis a bit easier within the Microsoft Excel framework. Functions use specific values, called arguments, to calculate a variety of things, from simple sums and averages to more complicated loan payments. Explore the 150 most useful functions that help Microsoft Excel make your life easier Access real-world examples of how functions fit into larger formulas Discover 85 specialized functions, which are described in abbreviated form and take your knowledge of Excel to the next level Understand how Microsoft Excel can help you make key decisions, such as whether to go with a 15-year or 30-year mortgage Excel Formulas & Functions For Dummies, 4th Edition brings order to chaotic data—and helps you make decisions with confidence!

Excel Data Analysis

Your visual blueprint for analyzing data, charts, and PivotTables

Author: Paul McFedries

Publisher: John Wiley & Sons

ISBN: 1118780329

Category: Computers

Page: 336

View: 5321

Separation Process Engineering

Includes Mass Transfer Analysis

Author: Phillip C. Wankat

Publisher: Prentice Hall

ISBN: 013344368X

Category: Technology & Engineering

Page: 1152

View: 7734

The Definitive, Up-to-Date, Student-Friendly Guide to Separation Process Engineering—With More Mass Transfer Coverage and a New Chapter on Crystallization Separation Process Engineering, Fourth Edition, is the most comprehensive, accessible guide available on modern separation processes and the fundamentals of mass transfer. In this completely updated edition, Phillip C. Wankat teaches each key concept through detailed, realistic examples using real data—including up-to-date simulation practice and spreadsheet-based exercises. Wankat thoroughly covers each separation process, including flash, column, and batch distillation; exact calculations and shortcut methods for multicomponent distillation; staged and packed column design; absorption; stripping; and more. This edition provides expanded coverage of mass transfer and diffusion, so faculty can cover separations and mass transfer in one course. Detailed discussions of liquid-liquid extraction, adsorption, chromatography, and ion exchange prepare students for advanced work. Wankat presents coverage of membrane separations, including gas permeation, reverse osmosis, ultrafiltration, pervaporation, and applications. An updated chapter on economics and energy conservation in distillation adds coverage of equipment costs. This edition contains more than 300 new, up-to-date homework problems, extensively tested in undergraduate courses at Purdue University and the University of Canterbury (New Zealand). Coverage includes New chapter on crystallization from solution, including equilibrium, chemical purity, crystal size distribution, and pharmaceutical applications Thirteen up-to-date Aspen Plus process simulation labs, adaptable to any simulator Eight detailed Aspen Chromatography labs Extensive new coverage of ternary stage-by-stage distillation calculations Fraction collection and multicomponent calculations for simple batch distillation New mass transfer analysis sections on numerical solution for variable diffusivity Mass transfer to expanding or contracting objects, including ternary mass transfer Expanded coverage of pervaporation Updated Excel spreadsheets offering more practice with distillation, diffusion, mass transfer, and membrane separation problems

Introduction to Optimum Design

Author: Jasbir Arora

Publisher: Academic Press

ISBN: 0128009187

Category: Technology & Engineering

Page: 968

View: 9738

Introduction to Optimum Design, Fourth Edition, carries on the tradition of the most widely used textbook in engineering optimization and optimum design courses. It is intended for use in a first course on engineering design and optimization at the undergraduate or graduate level in engineering departments of all disciplines, with a primary focus on mechanical, aerospace, and civil engineering courses. Through a basic and organized approach, the text describes engineering design optimization in a rigorous, yet simplified manner, illustrates various concepts and procedures with simple examples, and demonstrates their applicability to engineering design problems. Formulation of a design problem as an optimization problem is emphasized and illustrated throughout the text using Excel and MATLAB as learning and teaching aids. This fourth edition has been reorganized, rewritten in parts, and enhanced with new material, making the book even more appealing to instructors regardless of course level. Includes basic concepts of optimality conditions and numerical methods that are described with simple and practical examples, making the material highly teachable and learnable Presents applications of optimization methods for structural, mechanical, aerospace, and industrial engineering problems Provides practical design examples that introduce students to the use of optimization methods early in the book Contains chapter on several advanced optimum design topics that serve the needs of instructors who teach more advanced courses

Introduction to Excel

Author: David Kuncicky,Ronald W Larsen

Publisher: Pearson Higher Ed

ISBN: 0133083659

Category: Technology & Engineering

Page: 336

View: 2799

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. A highly visual, step-by-step approach to solving engineering problems with Excel. Specifically targeted at first-year engineering students, this text seeks to teach the basic Excel skills that undergraduates will use in the first few years of engineering courses. This book was written with the understanding that students get frustrated by multi-step procedures that illustrate only the final outcome. Ron Larsen, in his hallmark approach, provides screen images for each and every step allowing students to easily follow along as they try to perform each task.

Engineering Computations

An Introduction Using MATLAB and Excel

Author: Joseph C. Musto,William E. Howard,Richard R. Williams

Publisher: N.A

ISBN: 9780071263573

Category: Engineering

Page: 330

View: 8662

The strength of Engineering Computation is its combination of the two most important computational programs in the engineering marketplace today, MATLAB® and Excel®. Engineering students will need to know how to use both programs to solve problems. The focus of this text is on the fundamentals of engineering computing: algorithm development, selection of appropriate tools, documentation of solutions, and verification and interpretation of results. To enhance instruction, the companion website includes a detailed set of PowerPoint slides that illustrate important points reinforcing them for students and making class preparation easier.

Essential MATLAB for Engineers and Scientists

Author: Brian Hahn,Daniel T. Valentine

Publisher: Academic Press

ISBN: 0128052716

Category: Technology & Engineering

Page: 428

View: 1126

Essential MATLAB for Engineers and Scientists, Sixth Edition, provides a concise, balanced overview of MATLAB's functionality that facilitates independent learning, with coverage of both the fundamentals and applications. The essentials of MATLAB are illustrated throughout, featuring complete coverage of the software's windows and menus. Program design and algorithm development are presented clearly and intuitively, along with many examples from a wide range of familiar scientific and engineering areas. This updated edition includes the latest MATLAB versions through 2016a, and is an ideal book for a first course on MATLAB, or for an engineering problem-solving course using MATLAB, as well as a self-learning tutorial for professionals and students expected to learn and apply MATLAB. Updated to include all the newer features through MATLAB R2016a Includes new chapter on complex variables analysis Presents a comparison of execution time between compiled and un-compiled code that includes examples Describes the new H2 graphics features

Design Concepts for Engineers

Author: Mark N. Horenstein

Publisher: Pearson

ISBN: 0134024257

Category: Technology & Engineering

Page: 300

View: 2532

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. For courses in design engineering Applying Design Concepts for All Engineers Design Concepts for Engineers introduces engineering students to the basic concepts and principles of design and their application to engineering disciplines. This general text provides a platform through which all engineers can understand major concepts, despite their specialty backgrounds. With a focus on the design process rather than the technical details of a specific engineering field, the Eighth Edition connects with a wide range of readers. Design Concepts for Engineers is a versatile text that can be taught to both introductory and higher level students as either a comprehensive material or in its distinct chapter modules. With knowledge of basic algebra, any engineer can explore and understand this enticing text, making it an ideal source material to reach a wide range of audiences.

Problem Solving in Chemical and Biochemical Engineering with POLYMATH, Excel, and MATLAB

Author: Michael B. Cutlip,Mordechai Shacham

Publisher: Prentice-Hall PTR

ISBN: 9780131482043

Category: Computers

Page: 727

View: 2242

Problem Solving in Chemical and Biochemical Engineering with POLYMATH™, Excel, and MATLAB®, Second Edition , is a valuable resource and companion that integrates the use of numerical problem solving in the three most widely used software packages: POLYMATH, Microsoft Excel, and MATLAB. Recently developed POLYMATH capabilities allow the automatic creation of Excel spreadsheets and the generation of MATLAB code for problem solutions. Students and professional engineers will appreciate the ease with which problems can be entered into POLYMATH and then solved independently in all three software packages, while taking full advantage of the unique capabilities within each package. The book includes more than 170 problems requiring numerical solutions. This greatly expanded and revised second edition includes new chapters on getting started with and using Excel and MATLAB. It also places special emphasis on biochemical engineering with a major chapter on the subject and with the integration of biochemical problems throughout the book. General Topics and Subject Areas, Organized by Chapter Introduction to Problem Solving with Mathematical Software Packages Basic Principles and Calculations Regression and Correlation of Data Introduction to Problem Solving with Excel Introduction to Problem Solving with MATLAB Advanced Problem-Solving Techniques Thermodynamics Fluid Mechanics Heat Transfer Mass Transfer Chemical Reaction Engineering Phase Equilibrium and Distillation Process Dynamics and Control Biochemical Engineering Practical Aspects of Problem-Solving Capabilities Simultaneous Linear Equations Simultaneous Nonlinear Equations Linear, Multiple Linear, and Nonlinear Regressions with Statistical Analyses Partial Differential Equations (Using the Numerical Method of Lines) Curve Fitting by Polynomials with Statistical Analysis Simultaneous Ordinary Differential Equations (Including Problems Involving Stiff Systems, Differential-Algebraic Equations, and Parameter Estimation in Systems of Ordinary Differential Equations) The Book's Web Site ( Provides solved and partially solved problem files for all three software packages, plus additional materials Describes discounted purchase options for educational version of POLYMATH available to book purchasers Includes detailed, selected problem solutions in Maple™, Mathcad®, and Mathematica™