Return to Index
Operations Research Models and Methods
 
excel head
Subunit Operations Research Models and Methods
  - Linear/Integer Programming Solver
 

This add-in provides algorithms to solve Linear and Integer Programming problems. It can be used instead of the Excel solver for the linear models created by the Mathematical Programming add-in. Either the Math Programming add-in or the MP Model Builder add-in must be installed to use this add-in.

The LP/IP add-in was modified on 2/20/2011 to allow LP 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
lpip_solver.xla
2/26/2011

 

Associated Add-ins - Click the add-in name to transfer to the add-in page.
Add-in Name
File
  
mp_models.xla
 The Jensen LP/IP solver can be used for models constructed by the Math Programming add-in.
mp_model_builder.xla
 The Jensen LP/IP solver can also be used for models constructed by the MP Model Builder add-in.
Solver
solver.xla
 The Excel Solver can also be used to solve models.

 

Demonstration Files - Click the demo name to download a .xls file.
Demo Name
File Name
  
mpdem.xls
 See LP and IP examples
Ch. 3 Linear Programming Methods
bar
c03_lp_methods.xls
Linear programming methods from Chapter 3 in the ORMM textbook
Ch. 4 Sensitivity Analysis, Duality, and Interior Point Methods
bar
c04_duality.xls
 Dual linear programming from Chapter 4 in the ORMM textbook
c08_ip_methods.xls Integer programming methods from Chapter 8 in the ORMM textbook
Various demos
bar
A number of add-ins make math programming models that can be solved with the LP/IP models
 
gray line
  
Return to Top
tree roots

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