Spreadsheet Modeling and Applications

Course Code
TO 513
1.5 hours
  • Fall 23 (B)
  • Winter 23 (B)
Graduate Standing

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.

Taught By
Jean-Paul Baldwin
  • Lecturer of Technology and Operations
Jean-Paul (‘J-P’) Baldwin is currently a Data Scientist and Section Supervisor at Ford Credit Motor Company. Originally from South Africa, Jean-Paul...
David Mendez
  • Associate Professor of Technology and Operations