EXCEL linear programming solver

EXCEL linear programming solver - Using the Excel linear...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Using the Excel linear programming solver A linear program max xc x Ax b x T 0 0 = s.t. Can also be written in the form max x ax b x T T T m T m 0 1 1 2 2 0 = M This formulation uses the dot-product form, which conforms nicely with the approach used in Excel for formulating linear models. The Excel function SUMPRODUCT is their dot-product mechanism. The arguments for this function are (Array1, Array2). So to accomplish T 1 1 We represent this as SUMPRODUCT( a 1 array reference, x array reference). For example if a 1 is in A1:A5 and x is in B1:B5, then SUMPRODUCT(A1:A5, B1:B5). Thus, a constraint setup for the solver would be to for place this sum-product in a cell such as C1 by “= SUMPRODUCT(A1:A5, B1:B5)” (without the “’s) and then place b in another cell C2 “= b value”. Relating these two cells with a SOLVER constraint such as 1 1 C1 <= C2 results in that constraint being defined. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Consider the problem (from Baker Optimization Modeling with Spreadsheets) max ,,.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/26/2011 for the course ISEN 620 taught by Professor Curry during the Fall '10 term at Texas A&M.

Page1 / 4

EXCEL linear programming solver - Using the Excel linear...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online