Hi, I am not particularly skilled at using excel, but I found the Excel Solver and the What-if analysis have some potential for something I am trying to do. I have a set of either two, three, or four linear equations, which all have the same integer (constrainted to whole) variables affect them.

a + b + 0c + 0d + 0e + 3f + 0g = A
a + 0b + 0c + d + 0e + f + 4g = B
0a + 0b + 4c + 0d + e + 0f + 0g = C

a,b,c,d,e,f,g >= 0 and a + b + c + d + e + f + g = x, x a natural number

I want to find the optimum solution for all three of these equations (A,B,C) under the two given constraints, as a pure integar programming problem. Hopefully this is enough to understand what I am doing, this was a nightmare to explain to my instructors and various forums, but I am pretty sure from what I read Excel can handle this. If anyone has a solution or perhaps better examples than I have come across to model around let me know. Thanks!

Darren