+ Reply to Thread
Results 1 to 6 of 6

Solver- lock a cell

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    israel
    MS-Off Ver
    Excel 2010
    Posts
    9

    Solver- lock a cell

    Hi,

    I've build a solver with many conditions.

    The calc is performed on a list, with 80 items.

    It returns the combination of 8 items, under the conditions.

    If i want to "lock" items, that no matter what the result is, they have to be inside, how do i do it?

    Many thanks.

  2. #2
    Registered User
    Join Date
    11-05-2013
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2013
    Posts
    63

    Re: Solver- lock a cell

    Upload an example of the spreadsheet, impossible to understand what you want..

  3. #3
    Registered User
    Join Date
    08-21-2012
    Location
    israel
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Solver- lock a cell

    attached per your request
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-05-2013
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2013
    Posts
    63

    Re: Solver- lock a cell

    It's really uncreal in o1:r11 what you are calculating. Do you mean simply locking the range with $?

  5. #5
    Registered User
    Join Date
    08-21-2012
    Location
    israel
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Solver- lock a cell

    i want the max amount of points (Q1)
    Under 200 cost (Q2)
    With 8 items (Q3)

    Items are "B" column, Calced binary on "G"

    My question is that if i want "b3" item (KYL) to be in the end combination, how can i lock it to be there?

  6. #6
    Registered User
    Join Date
    11-05-2013
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2013
    Posts
    63

    Re: Solver- lock a cell

    Sorry mate, but I have no idea what you want.. G columns has all values as 0.

+ 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. Replies: 1
    Last Post: 04-27-2016, 03:05 PM
  2. Replies: 0
    Last Post: 07-20-2014, 12:45 PM
  3. macro not keeping solver solutions when solver is successful
    By jimmypants in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2014, 01:45 AM
  4. Can't start Solver. Error message says Solver.xlam already open.
    By DaveHills in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 10-21-2012, 11:02 AM
  5. solver macro + simulation code + not updating solver values
    By sabinemaria in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2012, 11:37 AM
  6. Solver constraints shall be OR // Solver target cell
    By Cunner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2009, 04:28 AM
  7. Interesting Solver problem (Solver encounters an error)
    By MrShorty in forum Excel General
    Replies: 3
    Last Post: 12-22-2005, 06:55 PM

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