+ Reply to Thread
Results 1 to 2 of 2

Excel Solver- Ratio Constraint

  1. #1
    Registered User
    Join Date
    06-12-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    1

    Excel Solver- Ratio Constraint

    Having a problem constructing a ratio constraint in Excel Solver.

    I need to construct a ratio constraint of at least 1 to every 2.

    For example, a facility must have at least one physician for every two extenders.

    Can anyone help?

    Thanks.

  2. #2
    Registered User
    Join Date
    06-08-2011
    Location
    Orlando, Florida
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Excel Solver- Ratio Constraint

    What would you like to happen if the ratio is wrong (i.e. no physician or one physician and three extenders)? Should the workbook prevent entry of too many extenders after having a certain number of physicians identified? Should the workbook allow the wrong ratio, but flag either the physician count or the extender count or both? Are you keeping track of many facilities or one facility with many physicians and extenders?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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