Calling the LP-Solve Linear Program Software From Excel, S-Plus and R

摘要

We present software that allows Excel, S-Plus and R to call the functions in the lp(underline)solve system. Lp(underline)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.