+ Reply to Thread
Results 1 to 8 of 8

Solver wont work in 2010, any other ideas

  1. #1
    Registered User
    Join Date
    01-19-2013
    Location
    Everett, Wa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Solver wont work in 2010, any other ideas

    Excel 2010 – Solver will NOT work with whole numbers and that is what I need (only whole numbers, i.e whole vials being used). So this is a drug/inventory problem. The drug is dosed as 25, 35,or 50 units/kg. Also a Max dose is reached with 100 kg. (this I can do). The trick is we want to use whole vial sizes and the vials come with varying amount of drug per vial (480-620 units/vial). We can enter our existing Inventory to get the exact units/vial and number of vials on hand. Now I need to figure out the best combination of vials in Inventory to use to get the closest to the dose needed. If Max dose is reached then the MOST we can go over the max dose is 5%. I’d like to see the percentage difference from the calculated or Max dose.

    Thanks for any Tips.
    Gary

  2. #2
    Registered User
    Join Date
    01-19-2013
    Location
    Everett, Wa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Solver wont work in 2010, any other ideas

    If I did it right, attached is what I've come up with so far.
    Attached Files Attached Files

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Solver wont work in 2010, any other ideas

    B
    C
    D
    E
    F
    G
    H
    I
    2
    UnitsPerVial
    Vials
    Use
    Target Dose
    Actual Dose
    Error
    3
    558
    3
    0
    1600
    1589
    0.0069
    H3: =ABS(G3/F3-1)
    4
    546
    3
    0
    5
    537
    3
    1
    6
    526
    3
    2
    7
    518
    3
    0


    Solvers > Set cell Error to minimum by changing Use, subject to the constraints

    Use >= 0
    Use <= Vials
    Use int
    Last edited by shg; 05-13-2014 at 11:49 AM.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    01-19-2013
    Location
    Everett, Wa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Solver wont work in 2010, any other ideas

    Appreciate your thought, but I must be missing something here. I copied your example in a blank sheet and set solver with your constraints and nothing happened.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Solver wont work in 2010, any other ideas

    Attached .
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-19-2013
    Location
    Everett, Wa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Solver wont work in 2010, any other ideas

    Ah, Thanks! Will play with that some more, at a quick glance looks like it will work. Looks like the Set Cell is H3.

    Thanks again

  7. #7
    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: Solver wont work in 2010, any other ideas

    Have you check Solver -> "Options" and tab "All Methods" and seen that box marked "Ignore Integer Constraint" is not ticked?

    Alf

  8. #8
    Registered User
    Join Date
    01-19-2013
    Location
    Everett, Wa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Solver wont work in 2010, any other ideas

    Yes I have. Thanks

    oops, it must not have saved. It works as I was wishing it would. Thanks!!
    Last edited by gary98208; 05-15-2014 at 03:14 PM.

+ 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. Working 2007 excel add-in wont work with excell 2010 version. Please help.
    By kraft_mk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2014, 08:53 PM
  2. Solver don't work in excel 2010
    By masben in forum Excel General
    Replies: 5
    Last Post: 02-27-2013, 11:20 AM
  3. Excel 2010 VBA & Macros - Wont work in Open Office
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 04:49 AM
  4. Solver macro (2010) does not work in 2007
    By goldenaggregate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2012, 09:59 AM
  5. (2010) Excel hyperlinks to Excel files wont work
    By Rick_Stanich in forum Excel General
    Replies: 6
    Last Post: 10-18-2011, 08:29 AM

Tags for this Thread

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