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

T

TARA BROWN

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"
 
P

pdberger

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.
 
Top