Iterative function in Process Flow to minimize value

Question

question

Steve Holland asked Feb 24, '17 Mischa Spelt answered Feb 27, '17

Iterative function in Process Flow to minimize value

I have a model in Process Flow that represents a batch process. Esentially, I create tokens that represent demand, assign SKU, and create items to represent the demand. I am trying to Push/Pull to lists.

I would like to have some iterative function in process flow that would compare the current SKU and pick the next SKU to run based on minimizing the cleaning/changeover time.

I already have a Global Table that shows the changeover matrix (i.e. going from SKU X to SKU Y is cleaning type Z) and can assign SKU labels to the incoming tokens. I am having trouble with searching the Changeover Table to select the next SKU that should be pulled from the list.

Any advice is appreciated.

Software Version:

FlexSim 16.2.2

table process flow pull from list

· 1

Matthew Gillespie ♦♦ commented · Feb 25, 2017 at 12:37 AM

Can you give us some more detail about what you're trying to do? I don't understand how you determine what minimizes the cleaning time. A sample model of what you're trying to do would help a lot.

0 ·

Answer 1 · 2017-02-27T09:03:26Z

Mischa Spelt answered Feb 27, '17

Like @Matthew Gillespie said, attaching the model would probably be useful. However, in general, what you could do is

1. Put a label on the puller (machine) with the current SKU type.

Then either

2. Create a dynamic field on your list of SKUs to be processed, in which you use the SKU number of value and that of the puller to calculate the changeover time.

3. In the pull, ORDER BY the items on the list by changeover time, in ascending order.

or

2. Create a user command CalculateChangeoverTime that takes two SKU numbers and calculates the changeover time.

3. In the pull, use the user command to sort by changeover time from the machine's current SKU to the list item's new SKU: ORDER BY CalculateChangeoverTime( puller.currentSku, value.sku )

question