Return to Index
Operations Research Models and Methods
 
excel head
Subunit Operations Research Models and Methods
  - Mathematical Programming Model Builder
 

The MP Model Builder add-in constructs linear and integer optimization models.The add-in constucts forms to hold the variables, constraints, and constraint coefficients for the linear model. Four alternative formats are available. They differ on the placement and orientation of the variables and constraints. A new feature stores constraint coefficients in a list rather than in a table.

The MP Model Builder add-in was modified on 2/20/2011 to allow column list models to have more than 32,000 nonzero coefficients.

Add-in - Click the add-in name to download a zipped .xla file.
Add-in Name
File
Date
mp_model_builder.xla
3/16/2011

 

Associated Add-ins - Click the add-in name to transfer to the add-in page.
Add-in Name
File
 
lpip_solver.xla
Jensen solver for linear and integer models. It only works for models constructed by the Math Programming add-in. Be sure to use a version later than Jan. 23, 2011.
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
 
mp_builder_demo.xls
Illustrates the four formats available on the add-in.
 
gray line
  
Return to Top

tree roots

Operations Research Models and Methods
Internet
by Paul A. Jensen
Copyright 2010 - All rights reserved