A question using Excel Solver
July 9, 2019 8:03 AM Subscribe
Hello, I've been experimenting with excel Solver to solve a scheduling problem, but I can't get it to work even the simplest solution. Any ideas?
The problem is simple. Here is the excel sheet:
There are two teams
Team A and Team B
Every week needs 5 people on team A and 4 people on team B
I'd like everyone to have as equal as possible a ratio between A:B.
The problem HAS a solution (I've made it below), so why can't solver find it?
The problem is simple. Here is the excel sheet:
There are two teams
Team A and Team B
Every week needs 5 people on team A and 4 people on team B
I'd like everyone to have as equal as possible a ratio between A:B.
The problem HAS a solution (I've made it below), so why can't solver find it?
« Older Everyone says 'trust your gut' - but I think my... | Which San Francisco park to visit between roughly... Newer »
This thread is closed to new comments.
The Solver documentation goes into a bit more detail about this:
posted by Johnny Assay at 11:44 AM on July 9, 2019 [1 favorite]