Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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" |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change a password for VB SOLVER Add-in? | Excel Discussion (Misc queries) | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
change footer in workbook w/o changing on each wksht? | Excel Discussion (Misc queries) | |||
How can I change size of the picture without changing chartobject? | Charts and Charting in Excel | |||
vlookup change column index position - without changing formulae | Excel Worksheet Functions |