Iain Dunning just sent me a link to Katherine Perry’s masters thesis on Call Center Scheduling Problem using Spreadsheet Optimization and VBA. (You will have to click past a broken certificate.) Katherine has been using OpenSolver to solve her call center problems. Her thesis includes an appendix giving step by step instructions on installing OpenSolver that might be useful for new users.
Any luck on contacting the author or finding the excel template at all?
Does the speadsheet example or template exist for this project?
I don’t have the spreadsheet developed for this masters project, but you could contact the author or perhaps re-create the model by reading through the thesis. Good luck, Andrew