Results 1 to 6 of 6

excel solver constraints

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-21-2013
    Location
    KL
    MS-Off Ver
    Excel 2010
    Posts
    168

    excel solver constraints

    Hi all,

    Good day!

    I am currently facing some difficulties in constructing the constraints for my solver model.

    Referring to the sample attached, I have to make an schedule for employees to attend training sessions, 2 times per month.

    I have 2 constraints that I am not very sure on how to add in:
    1) 2 sessions have to be at least 2 weeks apart. It doesn't have to be exactly 14 days. For example, if 1st session is on 1st week, 2nd session must be at least on 3rd week, anyday.

    2) The sessions must be scheduled on the day the are scheduled to work, as shown in the second table in my sample file.

    Hope that my request is clear.
    Appreciate any assistance!

    Thank you!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Solver binary constraints
    By jharaldson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2014, 03:37 AM
  2. Excel Solver – Constraints referencing another sheet
    By Kondrat in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-29-2012, 03:49 AM
  3. using variables in excel solver constraints problem!
    By 77anders in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-12-2009, 08:49 PM
  4. Excel Solver Constraints
    By jcoleman52 in forum Excel General
    Replies: 2
    Last Post: 06-01-2006, 03:00 PM
  5. Constraints in Excel Solver
    By Donna in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2005, 06:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1