# 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 »

You are not logged in, either login or create an account to post comments

The Solver documentation goes into a bit more detail about this:

posted by Johnny Assay at 11:44 AM on July 9 [2 favorites]