Forum Discussion
Optimisation in Excel - Roster
Hey All, I’m not sure where to begin but I’d like to try and tackle some ‘optimisation’ in excel? I’m not unfamiliar with the concept but have never had to implement it. The challenge is; Every...
ScottAshby any luck with this? I'm running into a similar scenario
cortes272 blast from the past, I forgot about this! I never got anywhere with the excel solver. There was a more complex solver add on but still no luck.
Knowing what I do now, I think an approach would have been to try and formulate an lp file for my problem, and then run it through a solving engine like neos-server or HiGHS.
At the time I might have been happy with a halfway solution like some VBA code and loops to assign preferences, then fill up the desks by zone until it couldnt any more and I'd deal with the leftovers manually.
Good luck with your problem