Spreadsheet Modeling and Applications
- Fall 19 (B)
- Fall 20 (B)
- Winter 20 (B)
- Winter 21 (B)
Spreadsheet Modeling and Applications --- This course, a continuation of TO 512, emphasizes problem solving using spreadsheet software. Extensive use is made of a spreadsheet solver (such as Solver in Excel) to formulate and solve practical optimization problems from such mathematical programming areas as linear, integer, and nonlinear programming, and multiple-objective decision making. Probabilistic modeling to support risk analysis in the context of spreadsheets is also studied, using native spreadsheet capabilities alone and then supplementing these capabilities with spreadsheet problem analysis, model formulation, implementation, execution and interpretation. Students are assigned computer work to reinforce and extend conceptual and operational aspects of the material.