2 Replies Latest reply on Jun 12, 2017 3:20 AM by wimdecorte

    Looking for some advice


      struggling with a project here, not sure how to solve it.


      I have 7 parts, each part can be boxed in several boxes, but not all boxes.  Example:


      part 1 can go in Boxes A, B, F

      part 2 can go in Boxes A, D, E

      part 3 can go in Boxes D, J

      and so on.


      once a box is used, it's consumed for the day.


      each also has a due date.


      client wants the database to loop through all options and combinations to find fastest combo, among two thousand of these.  They also want the ability to insert emergency orders and have the rest of it adjust.




      I'd love some advice or help!

        • 1. Re: Looking for some advice

          How do you define the "fastest combo"?  How do you see this optimization working?


          How do you do this workflow now?


          What does it mean that a box is "consumed"? When it has one part, two parts, or what?


          How would an emergency order be done?


          What do you mean by re-adjust? How would parts in the emergency order go to other boxes?




          I think if you rigorously define all these terms, create flow diagrams (both for yourself and the ability to communicate a complicated process with others), and clearly define your optimization's goals, you'll be in much better shape to start the project. Currently, it seems you're just at the brainstorming stage, which is fine, but it seems way too early to worry about a computer implementation.

          • 2. Re: Looking for some advice

            Agreed with @fmpdude: doesn't sound like you have all the rules defined.  Once you do based on his questions as a start, and you start mapping out  the flowcharts, it will be become clear how to 'program' this.