+ Reply to Thread
Results 1 to 2 of 2

Solver Constraint to Keep Certain Data Together?

  1. #1
    Registered User
    Join Date
    09-26-2019
    Location
    Toronto, Canada
    MS-Off Ver
    2017
    Posts
    8

    Solver Constraint to Keep Certain Data Together?

    Please see the "New Schedule" sheet in the attached excel file for the problem. It's currently been optimized using solver.

    Basically, the left column represents the "Fillers", and the right side has six "Mixers" (CM06, CM07...). The mixers send product to the fillers to create final goods, so I created the table so that filling out the final goods fill times will reverse fill the mixer times (if I want to fill out the final good at X time, when do I need to make the bulk?). I then use solver to optimize by having zero overlap of mixer times and fill times respectively. I created a column for the fill times showing the difference from the beginning of the week to the start times, and had solver minimize this since that would create a schedule with everything happening as close to the beginning of the week as possible. My new issue is that there are wash cycles that need to happen for the mixers, but if I fill them out in the fillers, (look under Profil-Clip at D14 and D15, there are two wash cycles) solver rearranges them same as the fill times.

    I need a way to make sure the wash cycles happen between a certain number of mixer batches, or that it happens at a certain time. I've considered having solver not affect it, but that doesn't stop it from rearranging the other times around the wash cycle, which could end up leaving the wash cycle in the wrong spot. Also, if I fill out the wash cycle after running solver, I need a way to go back and fix the fill times as well.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Solver Constraint to Keep Certain Data Together?

    solver rearranges them same as the fill times
    Solver has no concept of time, when things happen in solver they all occur at the same time i.e. instantly.

    So if you have a process that takes a number of hours you can give solver the total hours say for a week and it will tell you how many times you could you can run this process before you used all available time but it can't tell you the start and stop time for each process. That you have to use other tools for if you wish to see a detailed picture of your production in said week.

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding Constraint to Solver
    By DAVE201992 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2019, 12:39 PM
  2. Excel Solver Constraint Help
    By BauceArj in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-14-2014, 08:47 PM
  3. Solver add in - Constraint not working
    By mkmed in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2013, 01:23 PM
  4. BUY-IN Constraint in Solver
    By WhamBam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2012, 02:30 AM
  5. A wacky solver constraint
    By simonsays in forum Excel General
    Replies: 0
    Last Post: 09-08-2006, 05:14 PM
  6. Add Constraint - "Solver:
    By tikchye_oldLearner57 in forum Excel General
    Replies: 2
    Last Post: 08-14-2006, 01:40 AM
  7. [SOLVED] solver constraint
    By jojo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2005, 10:06 AM

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