+ Reply to Thread
Results 1 to 1 of 1

Timetable Scheduling - Solver error

  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Exclamation Timetable Scheduling - Solver error

    Help needed.

    I am trying to schedule a timetable (by optimizing the total no.of students common across various subjects).
    5 slots on each day (6-day week), which gives me 30 slots ( 30 subjects are to be assigned with two slots for each i.e. 60, maximum of 2 courses can be assigned for same slot).

    I am using 30x30 binary variables (1-if the course is assigned for that slot, 0-else), effectively 900 decision variables.
    Since excel does not support more than 200 variables, i am getting this error 'too many adjustable cells'.

    is there any way to overcome this problem??

    Thanks in advance

  2. #2
    Registered User
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy Re: Timetable Scheduling - Solver error

    can someone help me with this!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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