(3 units). Study of advanced techniques in Excel and coding in Visual Basic for Applications (VBA). Numerical methods common to chemical engineering analysis and design, including linear least squares, empirical model building, methods for solving nonlinear equations and systems of equations using programming and Excel Solver, numerical integration and the solution of differential equations. Theory behind the methods and, equally important, when and how to apply them using Excel and VBA to solve engineering problems. Course Component: Lecture, Tutorial Prerequisite: CHG 1125.
(3 units). Study of advanced techniques in Excel and coding in Visual Basic for Applications (VBA). Numerical methods common to chemical engineering analysis and design, including linear least squares, empirical model building, methods for solving nonlinear equations and systems of equations using programming and Excel Solver, numerical integration and the solution of differential equations. Theory behind the methods and, equally important, when and how to apply them using Excel and VBA to solve engineering problems. Course Component: Lecture, Tutorial Prerequisite: CHG 1125.
