Spreadsheet Problem Solving and Programming for Engineers and Scientists

This book provides a targeted and comprehensive resource essential to a full understanding of modern spreadsheet skills needed for engineering and scientific computations. Building on the authors' decades of experience teaching spreadsheets and programming, it is the ideal companion for all engineering courses and professional self-study.

David Clough joined the faculty of the Department of Chemical and Biological Engineering at the University of Colorado in 1975 after a brief career with DuPont in Wilmington, Delaware. He retired from Colorado in 2017 and holds the position of Professor Emeritus. He remains active at the university by assisting faculty and students in teaching and research. Notably, he teaches a series of workshops on process modeling and computer simulation as part of the senior design course sequence. In addition to this book, he has collaborated with Steve Chapra on two texts: Applied Numerical Methods with Python for Engineers and Scientists and Introduction to Engineering and Scientific Computing with Python. Dr. Clough received degrees in chemical engineering from Case Western Reserve University and the University of Colorado. He has extensive experience in applied computing, process automation, and the modeling of various processes with emphasis on dynamic behavior, including polymerization, high-temperature catalytic reactors, fluidized beds, open-channel flow, biomedical instrumentation, and solar-thermal reactors. Clough first learned to program in the original Fortran language while in high school in the early 1960s. Since then, he has experience in a wide array of programming languages and computing tools and has applied his expertise through his teaching, research, and industrial applications. In the 1980s, Clough and Steve Chapra originated the Introduction to Engineering Computing course for first-year students at the University of Colorado. The course is still taught and has included content on spreadsheets (originally Lotus 1-2-3, then Excel) and spreadsheet programming (VBA) for three decades. Over his career, Clough has taught hundreds of in-person short courses to practicing professionals on applied computing and problem-solving. His courses on spreadsheet problem-solving, offered through the American Institute of Chemical Engineers, have been among the most popular offered by AIChE, spanning three decades. He also offers on-line versions of his spreadsheet courses via AIChE Academy. Steve Chapra is Emeritus Professor and Louis Berger Chair in Civil and Environmental Engineering at Tufts University. His best-selling books include Surface Water-Quality Modeling, Numerical Methods for Engineers, 8th Ed., and Applied Numerical Methods with MATLAB for Engineers and Scientists, 5th Ed. He has also co-authored two texts with Prof. Clough on the Python language. Dr. Chapra received engineering degrees from Manhattan College and the University of Michigan. Before joining Tufts, he worked for the U.S. Environmental Protection Agency and the National Oceanic and Atmospheric Administration, and taught at Texas A&M University, the University of Colorado, and Imperial College London. His general research interests focus on surface water-quality modeling and advanced computer applications in environmental engineering. He is a Fellow and Distinguished Member of the American Society of Civil Engineering (ASCE) and has received several awards for his scholarly and academic contributions, including the Rudolph Hering Medal (ASCE), and the Meriam-Wiley Distinguished Author Award (American Society for Engineering Education). He has also been recognized as an outstanding teacher and advisor among the engineering faculties at Texas A&M University, the University of Colorado, and Tufts University. As a strong proponent of continuing education, he has taught over 90 workshops around the world introducing professionals to numerical methods, computer programming, and environmental modeling.

Chapter 1 Spreadsheet Basics Chapter 2 Charts and Graphs Chapter 3 Engineering and Scientific Formulas Chapter 4 Table-based Calculations Chapter 5 Case Studies and Targeting Chapter 6 Financial Calculations Chapter 7 Numerical Methods Chapter 8 Applied Statistics Chapter 9 Introduction to VBA and Macros Chapter 10 User-defined Functions Chapter 11 VBA Programming Chapter 12 User Interfaces Appendix A: Matrix Algebra Review Appendix B: Shortcut Keys and Key Combinations