linux linear programming model

Jon M. Hanson jon at the-hansons-az.net
Mon Nov 19 18:55:12 MST 2007


On Nov 19, 2007, at 6:29 PM, Kevin Brown wrote:

>> Sounds like a SQL problem.
>> Data -> database -> query -> answer :)
>
> It isn't because it is trying to solve a multivariate series of  
> problems.
>
> X + 2Y - 3Z = 8
> X*Y/Z = 12
>
> Solve for X, Y and Z (which you can't in this case because there is  
> one
> fewer equations than you have variables).  SQL can't do this.
>

In linear programming you usually don't have enough equations or  
variable to solve a set of equations (rarely do you have complete  
information in real life to generate a complete set of equations or  
to know all variables). You usually know constraints for variables.  
It's really not programming like when you think of computer programming.

Of course, Wikipedia has an entry for it: http://en.wikipedia.org/ 
wiki/Linear_programming.

You might be able to accomplish the same thing with a spreadsheet. I  
know in Excel there is a feature called "Solver" or "Goal Seek" that  
may do what you need. There should be something similar in OpenOffice  
Calc.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20071119/512558ad/attachment.htm 


More information about the PLUG-discuss mailing list