+ Reply to Thread
Results 1 to 6 of 6

code for lpp minimization problem

  1. #1
    Registered User
    Join Date
    12-22-2014
    Location
    Pune
    MS-Off Ver
    Ms excel 2007
    Posts
    3

    code for lpp minimization problem

    code for solving lpp problem in vba excel

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,858

    Re: code for lpp minimization problem

    It can be difficult to give specific help with such a cryptic and generic question.

    First thought -- can you define an "lpp problem". I could assume that lpp stands for linear programming problem, but it would really help us help you if we don't have to make such assumptions.

    I would also suggest that you ask a specific, narrow scope question rather than a generic, broad question. Linear programming (assuming this is linear programming) covers a lot of different scenarios and problems. It is difficult to provide a complete overview in a single forum post. Explain enough of your problem so that we understand enough to help you.

    If this is a linear programming problem, I might first suggest that you review other tutorials online. These tutorials can give a context to your question, and allow you to ask specifically about steps and concepts that you don't understand. One tutorial I readily came across by putting "linear programming Excel Solver example" into my favorite search engine: http://it.usu.edu/plugins/work/sitem...sing_Excel.pdf

    We want to help you, but we need you to help us help you.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    12-22-2014
    Location
    Pune
    MS-Off Ver
    Ms excel 2007
    Posts
    3

    Re: code for lpp minimization problem

    X1 + 4X2 <= 28

    5X1 + 3X2 <= 55

    X2 – X1 <= 2

    X1 + 2 X2 >= 4

    Maximize: 26X1 + 57X2

    solve this example in vba excel

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,858

    Re: code for lpp minimization problem

    This looks very similar to the example in the USU pdf that I linked to. Is there something specific in the tutorial file that did not make sense to you? I am not personally familiar with linear programming, so I am essentially limited to repeating what is in the linked tutorial. If you pose a specific question that you don't understand, then we can focus on those steps.

  5. #5
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: code for lpp minimization problem

    Perhaps a solver setup would do just as well?

    Solver must be installed on your PC, if not see description in the link MrShorty provided how to set up solver.

    Clear cells F3 and G3 before doing a solver run.

    Alf
    Attached Files Attached Files

  6. #6
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: code for lpp minimization problem

    This is the Office 365 forum. Why would you post a question here if you use Excel 2007? Please take a moment to learn about the forum and where to post which kind of question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel columns and rows minimization
    By vjharry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-13-2013, 03:27 AM
  2. Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  3. Minimization of numbers of vendors
    By Jowi7991 in forum Excel General
    Replies: 5
    Last Post: 06-18-2012, 09:50 AM
  4. OR Minimization problem
    By oleg174 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2011, 12:07 PM
  5. Disable Minimization of App Window
    By JVollmer in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-28-2009, 10:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1