This practical text is a perfect fit for 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 compatibility with Excel 2007, Spreadsheet Tools for Engineers Using Excel 2007 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 provides 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, unit conversions, data analysis, interpolation and curve fitting, solving equations, evaluating integrals, creating macros, and comparing economic alternatives.

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

What this book is about is how to lear as much as you can, get good grades, and still have fyn while prusuing an engineering degree. You will find strategies to ace tests, learn to love your computer in times of cybercrisis, land most agreeable internships, and pull through end-of-the-quarter slams in ways that are specific to engineers.

This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).

Completely updated guide for scientists, engineers and students who want to use Microsoft Excel 2007 to its full potential.Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data. - Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with the new Microsoft Office release of Excel 2007. - Features of Excel 2007 are illustrated through a wide variety of examples based in technical contexts, demonstrating the use of the program for analysis and presentation of experimental results. - Updated with new examples, problem sets, and applications.

What other reviewers say about ?Spreadsheet Check and Control??It is excellent. I am embarrassed when I think of the shortcuts I generally take with spreadsheets and I have often paid the price. I think it will become, and it should be, required reading for all young trainee accountants.? Ciaran Walsh, senior finance specialist, Irish Management Institute.?It's super. I kept saying to myself, ?Wow, I didn't know you could do that.? A great job.? Ray Panko, the most cited authority on spreadsheet error, University of Hawai?I.?Spreadsheet Check and Control does what no other book before has attempted to do; provide standards for designing spreadsheets that lend themselves to a logical review by management and internal auditors. Following this author?s guide and insight can help your organization minimize spreadsheet errors and facilitate audit review to prevent and detect those errors.? Jim Kaplan, AuditNet.org.?I thought I knew a lot about Excel, but in the course of teaching me to be Excel-careful, O'Beirne taught me some new tricks and methods that both helped me build better financial models and track down errors.? Simon Benninga, author of Financial Modeling, MIT Press 2000 and Principles of Finance with Excel, Oxford University Press, 2005.'Save red faces all round by buying, absorbing and passing-on this book, especially if you personally develop spreadsheets or if your organization is subject to Sarbanes Oxley and related regulations. Avoiding even a trivial spreadsheet mistake may well pay for the book. Avoiding a large one may save your career.' Dr. Gary Hinson, independent consultant in information security and computer auditing, editor of security awareness website NoticeBored.com.'Probably one of the most important spreadsheet books ever written. Your customers and boss will be delighted with the increased usability, accuracy and reliability his techniques encourage. Be aware that the pages are packed with useful and usable advice, so the 200 pages is probably equivalent to 500 pages in many other books.' Simon Murphy, Codematic.net, author of XLAnalyst.'An essential guide for serious spreadsheet users. This book goes a long way to help spreadsheet users adopt methods that will reduce errors and thereby improve the quality of the information vital to the success of all organisations.' P M Cleary, University of Wales Institute Cardiff, Wales'This is an excellent, easy to follow book containing the key practices that will arm the novice and self taught spreadsheet user so they can create well designed, reliable and error free spreadsheets.' CPA Ireland magazine review'Minimizing or eliminating spreadsheet errors is Patrick O'Beirne's focus in this visual 200-page book, which is geared toward software testers, business managers, or auditors sleuthing for fraud'. CA Magazine (Canada) review Summary of contents

It's a Excel basics book that every civil engineer should have read by now. It addresses skills that may not be covered in most Excel for civil engineering texts, such as step by step guides to create an application program and how to convert the steps into VBA code, how to perform matrix operations (multiplication and inversion) using Excel-VBA, macro for creating an engineering chart, a brief and simple guide to become an instant Excel-VBA programmer, and more... Also to be presented the depiction in AutoCAD program. Yes! AutoCAD is chosen because one of its advantages that relies on high drawing accuracy. You will learn how to create a simple AutoCAD script file using Excel formulas and Excel-VBA. It is expected that you will be able to create simple Cartesian graph in AutoCAD, even you are an AutoCAD first time user! With the ease of working with Excel, coupled with benefit of the given examples in this book, it is expected to increase the interest of the reader to create new original application programs. Thus, each model or even a specific calculation will be an exciting challenge for a programming job is already enjoyable. Happy Excel programming!

CHEMICAL PROCESS ENGINEERING Written by one of the most prolific and respected chemical engineers in the world and his co-author, also a well-known and respected engineer, this two-volume set is the "new standard" in the industry, offering engineers and students alike the most up-do-date, comprehensive, and state-of-the-art coverage of processes and best practices in the field today. This new two-volume set explores and describes integrating new tools for engineering education and practice for better utilization of the existing knowledge on process design. Useful not only for students, university professors, and practitioners, especially process, chemical, mechanical and metallurgical engineers, it is also a valuable reference for other engineers, consultants, technicians and scientists concerned about various aspects of industrial design. The text can be considered as complementary to process design for senior and graduate students as well as a hands-on reference work or refresher for engineers at entry level. The contents of the book can also be taught in intensive workshops in the oil, gas, petrochemical, biochemical and process industries. The book provides a detailed description and hands-on experience on process design in chemical engineering, and it is an integrated text that focuses on practical design with new tools, such as Microsoft Excel spreadsheets and UniSim simulation software. Written by two of the industry's most trustworthy and well-known authors, this book is the new standard in chemical, biochemical, pharmaceutical, petrochemical and petroleum refining. Covering design, analysis, simulation, integration, and, perhaps most importantly, the practical application of Microsoft Excel-UniSim software, this is the most comprehensive and up-to-date coverage of all of the latest developments in the industry. It is a must-have for any engineer or student’s library.

Numerical models have become much more efficient, making their application to problems increasingly widespread. User-friendly interfaces make the setup of a model much easier and more intuitive while increased computer speed can solve difficult problems in a matter of minutes. Co-authored by the software’s creator, Dr. Jirka Šimůnek, Soil Physics with HYDRUS: Modeling and Applications demonstrates one- and two-dimensional simulations and computer animations of numerical models using the HYDRUS software. Classroom-tested at the University of Georgia by Dr. David Radcliffe, this volume includes numerous examples and homework problems. It provides students with access to the HYDRUS-1D program as well as the Rosetta Module, which contains large volumes of information on the hydraulic properties of soils. The authors use HYDRUS-1D for problems that demonstrate infiltration, evaporation, and percolation of water through soils of different textures and layered soils. They also use it to show heat flow and solute transport in these systems, including the effect of physical and chemical nonequilibrium conditions. The book includes examples of two-dimensional flow in fields, hillslopes, boreholes, and capillary fringes using HYDRUS (2D/3D). It demonstrates the use of two other software packages, RETC and STANMOD, that complement the HYDRUS series. Hands-on use of the windows-based codes has proven extremely effective when learning the principles of water and solute movement, even for users with very little direct knowledge of soil physics and related disciplines and with limited mathematical expertise. Suitable for teaching an undergraduate or lower level graduate course in soil physics or vadose zone hydrology, the text can also be used for self-study on how to use the HYDRUS models. With the information in this book, you can run models for different scenarios and with different parameters, and thus gain a better understanding of the physics of water flow and contaminant transport.