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.
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.
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks