Integer linear programming

[Ima_P]

I have a question about linear programming in Labview. Is it possible to solve linear programming problems supporting integer variables (branch and bound code)?. For example:

f(z)=10*A+20*B+30*C                -->min!

Constraints:

    1*A+2*B+3*C>=20

    B<=5

A,B,C must be integers

The "Geometrical Version of LP in 2D.vi" is a great example to show how the "Linear Programming Simplex Method" works to solve this kind of problems. However, it does not support integer variables... How can I solve the problem above in Labview? Could I solve it using ActiveX controls to communicate with Excel solver?

Please help!! Thanks in advance

Traduce

[DavidOna]

Hi Ima,

     I have found some examples that show how to make ActiveX calls in LabVIEW in order to work with MSExcel:

Controlling Microsoft Excel for Office 2000 with an ActiveX Automation Server

Write Data to the Active Cell in Excel Using ActiveX

Reading Data from Excel

Controlling Microsoft Excel for Office 97 through ActiveX Automation

     You can find lots of examples on ni.com/devzone if you search for "excel activex". Hope it helps!

     Regards,

[Ima_P]

Hi DavidOna,

Thanks for your quick reply. Finally I created a macro in Excel which is able to use the solver functions. Later I developed a Labview program that runs this macro.