Sounds like a SQL problem.
Data -> database -> query -> answer :)
Matt Graham wrote:
After a long battle with technology, Alex LeDonne wrote:
  
On Nov 19, 2007 4:17 PM, betty <nicepenguin@webcanine.com> wrote:
    
anyone know a linear programming  model (for feed ingredients) that is
avail as an open source program??? I do my own dog diet blending and it is 
pretty tiring to use gnumeric (or else i don't know all the features;

I looked on line but most (all) of the pet food programs are keeping it
close to the vest since it is their bread and butter (sorry about the
mixed metaphors :(  )
      

That's a horse of a different feather, and once you let it out of the barn 
door, it snowballs and has a life of its own sort of like a computer virus.

  
What do you mean by "linear programming model"?
What are the inputs, and what is the output you're looking for?
    

I believe betty is looking for something like this (from the BSD fortune 
file):
----------------
Enter lots of data on calorie & nutritive content of foods.  Instruct
the thing to maximize a function describing nutritive content, with a
minimum level of each component, for fixed caloric content.  The
results are that one should eat each day:

        1/2 chicken
        1 egg
        1 glass of skim milk
        27 heads of lettuce.
                -- Rev. Adrian Melott
----------------

...except one that works properly, and one geared for dogs instead of people.  
This can get very complex depending on the number of lines you have to deal 
with and which factors you're trying to min/max.  I did this a very long time 
ago in junior high, but have forgotten everything except the basic concepts.  
Searching for "linear programming" on freshmeat doesn't give you anything 
that works with gnumeric or OOO, but does turn up a C package.  This is 
probably not what you want.  Can't see anything in OOO's help either.  Dang.

  


-- 
JD Austin
Twin Geckos Technology Services LLC
email: jd@twingeckos.com
http://www.twingeckos.com
phone/fax: 480.288.8195