HOW DO I CHANGE A SCHEDULE USING SOLVER WITHOUT CHANGING EACH DAY?
 

I AM USING SOLVER AND I HAVE A WORK SCHEDULE TO CHANGE AND ENSURE THAT EVER
EMPLOYEE HAS THE TIME OFF THAT THEY HAVE REQUESTED AND I MUST ADD THE
CONTRAINTS USING THE SOLVER MODEL AND GET THE CORRECT
TOTAL AMOUNT SCHEDULED, THE DIFFERENCE & THE SHORTFALL OF ATTENDANTS
WORKING. SOME OF THE EMPLOYEES ARE PARTTIME & SOME FULLTIME WITH A TOTAL OF
20 EMPLOYEES.

THANKS, TARANEISHEA BROWN
AKA "TARA"

HOW DO I CHANGE A SCHEDULE USING SOLVER WITHOUT CHANGING EACH DAY?
 

Tara --

I'm afraid this subject is a little too complicated for me to explain in
this forum. Hopefully, someone else will post a nice link for you. If no
one does, then there's an excellent chapter on this very subject in
"Microsoft Excel -- Data Analysis and Business Modeling" by Wayne Winston.
Well-explained. You'll get it right away.

Sorry I can't be more help.

"TARA BROWN" wrote:

I AM USING SOLVER AND I HAVE A WORK SCHEDULE TO CHANGE AND ENSURE THAT EVER
EMPLOYEE HAS THE TIME OFF THAT THEY HAVE REQUESTED AND I MUST ADD THE
CONTRAINTS USING THE SOLVER MODEL AND GET THE CORRECT
TOTAL AMOUNT SCHEDULED, THE DIFFERENCE & THE SHORTFALL OF ATTENDANTS
WORKING. SOME OF THE EMPLOYEES ARE PARTTIME & SOME FULLTIME WITH A TOTAL OF
20 EMPLOYEES.

THANKS, TARANEISHEA BROWN
AKA "TARA"