Results 1 to 8 of 8

Trouble Coding a Constraint for Solver

Threaded View

dmcmillon86 Trouble Coding a Constraint... 09-23-2011, 01:09 PM
shg Re: Trouble Coding a... 09-23-2011, 02:04 PM
dmcmillon86 Re: Trouble Coding a... 09-28-2011, 09:34 AM
dmcmillon86 Re: Trouble Coding a... 09-28-2011, 03:40 PM
Alf Re: Trouble Coding a... 09-28-2011, 01:39 PM
dmcmillon86 Re: Trouble Coding a... 09-28-2011, 03:39 PM
Alf Re: Trouble Coding a... 09-28-2011, 03:59 PM
dmcmillon86 Re: Trouble Coding a... 09-30-2011, 02:44 PM
  1. #1
    Registered User
    Join Date
    09-13-2011
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Excel 2010
    Posts
    8

    Trouble Coding a Constraint for Solver

    Hi everybody,

    This is my first post, so please let me know if I don't follow the forum conventions, but I think I've got it so here goes.

    I have a macro that is running solver to optimize routes. I have a set of rows set up with indices linked to drivetimes and time windows. I need solver to manipulate the indices so that the route time is under a limit, delivery windows are met, and there are no duplicate stops. I need it to be a macro because we're going to be running it with different data sets, but I know there is a feasible solution because I've found one myself manually for one of our sets, and when I have the solution input already into the variable cells and run solver, solver confirms my solution and presents no problems. If I don't have the solution already entered in, however, solver says it can not find a feasible solution.

    I suspect this is because the way I have set up my constraints won't allow solver any wiggle room without violating a constraint, but I don't know for sure.

    Does anyone have any suggestions?

    Thank you.
    Last edited by dmcmillon86; 09-30-2011 at 02:44 PM. Reason: Problem Solved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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