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

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solving a puzzle using "Solver"? Can already do by Iteration & functions. 2
Error message when using the Solver in a VBA macro loop 2
how do I write a 6 day schedule? 1
How do I extract a second data in a Lookup 3
how do i calculate a work schedule in excel? 3
How do I create a formula in excel to multiply two items from two 2
Using A Query To Group & Sum 4
How do I change a field value($) in Access without changing previo 6

Top