ORMM Excel

Demonstration

Operations Research Models and Methods

- Mathematical Programming Models

The Mathematical Programming Add-in constructs optimization models of several kinds:

Linear Programming
Nonlinear Programming
Integer Programming
Mixed Integer Programming
Network Flow Programming
Transportation Model

The models can be solved using the Solver Add-in or one of the solution add-ins provided in this collection. The Solver Add-in comes with Excel, and it can solve linear programming, integer programming and nonlinear programming models. Additional add-ins are available in this package to solve linear programming, integer programming, network programming and transportation models.

Add-in - Click the add-in name to download a zipped .xla file.
Add-in Name	File	Date
Math Programming	mp_models.xla	3/14/2011

Associated Add-ins - Click the add-in name to transfer to the add-in page.
Add-in Name	File
MP Model Builder	mp_model_builder.xla	The MP Model Builder add-in is an alternative for constructing LP models. For some application it is preferred to the Math Programming add-in because it is smaller.
LP/IP Solver	lpip_solver.xla	Jensen solver for linear and integer models. It only works for models constructed by the Math Programming add-in.
Network Solver	net_solver.xla	Jensen solver for network flow models. It only works for models constructed by the Math Programming add-in.
Excel Solver	solver.xla	The Solver add-in is provided with Excel and can solve all the models constructed by the Math Programming add-in.

Demonstration Files - Click the demo name to download a .xls file.
Demo Name	File Name
Math Programming Demo	mpdem.xls	Linear and integer programming, nonlinear programming, network flow programming and transportation examples used in the Math Programming Instruction pages.
Parametric Analysis	mp_param.xls	Parametric analysis for LP, network and transportation models.
Side Constraint Models	mp_side.xls
Side Constraint Models	mp_side2.xls
Side Constraint Models	mp_side_l.xls	L-shaped method
Stochastic Programming Demo	mp_stoch.xls
Stochastic Programming with Recourse	mp_stoch_rec.xls
Ch. 2 Linear Programming Models	c02_lp_models.xls	Linear programming models from Chapter 2 in the ORMM textbook.
Equivalent Linear Programs	c02_equiv_lp.xls	Exampes from Equivalent Linear Programs (Supplement)
Ch. 5 Network Flow Programming Models	c05_net_models.xls	Network Flow programming models from Chapter 5 in the ORMM textbook.
Ch. 7 Integer Programming Models	c07_ip_models.xls	Integer programming models from Chapter 7 in the ORMM textbook.
Ch. 9 Nonlinear Programming Models	c09_nlp_models1.xls	Nonlinear programming models from Chapter 9 in the ORMM textbook.
Ch. 9 Nonlinear Programming Models	c09_nlp_models2.xls	More nonlinear programming models from Chapter 9 in the ORMM textbook.
Ch. 10 Nonlinear Programming Methods	c10_nlp_methods.xls	Nonlinear programming methods from Chapter 10 in the ORMM textbook