Calling the LP Solve linear program software from Excel, S-Plus and R
Loading...
Authors
Buttrey, Samuel E.
Subjects
Microsoft software
Computer software
Linear programming
Integer programming
Computer software
Linear programming
Integer programming
Advisors
Date of Issue
2003
Date
2003
Publisher
Monterey, California. Naval Postgraduate School
Language
Abstract
We present software that allows Excel, S-Plus and R to call the functions in the lp solve system. Lp solve is free software (licensed under the Gnu Lesser GPL) that solves linear and mixed-integer linear programs of moderate size (on the order of 10,000 variables and 50,000 constraints). Since these problems are substantially larger than those that can be handled by Excel's built-in solver, this link will allow Excel users to handle large problems at no extra cost.
Type
Technical Report
Description
Series/Report No
Department
Operations Research
Organization
Naval Postgraduate School (U.S.)
Identifiers
NPS Report Number
NPS-OR-03-006
Sponsors
Funder
Format
15 p.: ill. (some col.);28 cm.
Citation
Distribution Statement
Approved for public release; distribution is unlimited.