Home > Forum Home > Planning and Managing Projects > Solver add-in problem > A belated solution! Share

A belated solution!

Excel Help for A Belated Solution! in Planning and Managing Projects


Forum TopicLogin

A Belated Solution!

Rate this:
(3/5 from 1 vote)
ConfusedHi Nicole, I realise this is an old problem and you might have solved it yourself or have had it solved elsewhere but I have attempted this problem. My solution is as follows. Room 1 not assigned, room 2 =G, room 3 = F, room 4 = not assigned, room 5 assigned to B AND C, room 6 not assigned, room 7 = A, room 8 = H AND I, room 9 D AND E, room 10 = J. I didn't see a constraint that says unoccupied and double occupancy are banned and SOLVER gives me the above. I would love to see the correct answer IN CASE THE ABOVE IS RUBBISH!
I will share my Excel fille too if you want.
 Duncan
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for A belated solution! in the