Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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"
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 258
Default 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"

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change a password for VB SOLVER Add-in? Jim Shaffer Excel Discussion (Misc queries) 1 April 12th 06 05:03 AM
I Need a formula to evaluate a cell with + or - values Bob in Oklahoma Excel Worksheet Functions 6 October 31st 05 02:41 PM
change footer in workbook w/o changing on each wksht? Zolli6769 Excel Discussion (Misc queries) 2 April 20th 05 08:06 PM
How can I change size of the picture without changing chartobject? Marie J-son Charts and Charting in Excel 6 December 7th 04 12:34 PM
vlookup change column index position - without changing formulae loopyloobyloo Excel Worksheet Functions 1 November 26th 04 01:35 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"