Random Ordering of Production Plan as an Experimenter Scenario

Question

question

Borja Lorenzo asked Jan 14 2025 at 12:31 PM Borja Lorenzo commented Jan 24 2025 at 5:41 PM

Random Ordering of Production Plan as an Experimenter Scenario

Hello,

I have a production plan in the Global Table "Plan_Produccion" with the orders to be placed and a Calculated Table where I get the total production time "TiempoTotalProduccion".

I need to get the best order of the orders from the production plan to get the lowest "TiempoTotalProduccion".

The idea would be to use the Experimenter to test different combinations in the ordering of the orders in the "Plan_Produccion". With different orderings of the orders, the proposed KPI of TiempoTotalProduccion (which will be defined as a Performance Measure) will vary its value. I know that this optimization would be the subject of study for OptiQuest, but before getting there, I would like to propose an intermediate option. The idea is to make this ordering automatic, and the number of combinations can be introduced as a Parameter (resulting in an error when the number of combinations is greater than the maximum possible number of combinations (number of rows raised to the number of rows)). With this, we would not obtain the optimal combination, but we could choose the best of the proposed combinations.

Could this random ordering of the production plan depend on a parameter, and could each combination be defined as a different scenario in the Experimenter?

I attach the file.

Thank you very much in advance.

Simplificación Statistic Collector from List 250114.fsm

Software Version:

FlexSim 24.1.1

experimenter parameters performance measures globaltable ordering

simplificacion-statistic-collector-from-list-25011.fsm (658.5 KiB)

· 1

Answer 1 · 2025-01-14T13:25:08Z

Felix Möhlmann answered Jan 14 2025 at 1:25 PM Borja Lorenzo commented Jan 24 2025 at 5:41 PM

The first change you would need to make is to create a duplicate of the production table that serves as a base and stays unchanged at all times. Through the On Set code of a parameter or the model reset trigger you would then generate the production table used in the model run by copying over row by row in varying sequences.

You can use the "Sequence" parameter type for this. By selecting to run a "Range-Based" job in the experimenter a scenario for each possible permuation will be created automatically.

1736861078977.png (35.5 KiB)

· 5

Borja Lorenzo commented · Jan 14 2025 at 1:57 PM

Hello

Thank you for your quick response.
In the definition of the Seq. length parameter, I have defined it with a code that looks at the number of rows in the Global Table (Plan_Produccion). Do I have to define the On Set code using FlexScript, or is there an option to do it through a guided assistant?

0 ·

1736863019296.png (129.4 KiB)

Felix Möhlmann Borja Lorenzo commented · Jan 14 2025 at 2:11 PM

Sorting the rows into the actual production table needs to be done through self-written code.

1 ·

Borja Lorenzo Felix Möhlmann commented · Jan 24 2025 at 1:28 PM

Hello

I could tested Felix's propousal.

I have created the custom code at trigger on Set from Parameter 1 (Sequence type), that makes a copy of the "Plan_Produccion" table, copying rows whose index must be given by the element of parameter 1 (sequencer). I understand that in each execution, the Experimenter uses a different parameter, and from there arises the variation of the "Plan_Produccion_Copia" table.

In the custom code, I referred to the array of parameter 1 (sequencer) as newValue: param(2). I have changed my Process Flow to be linked to the copy table ("Plan_Produccion_Copia"), which I interpreted changes its order based on the different parameter applied by the Experimenter.

I'm not sure if I have understood the approach correctly or if I am interpreting the data correctly. I would appreciate your help with this.

Thank you very much.

Attached is the reference model.

Simplificación Statistic Collector from List 250124.fsm

0 ·

simplificacion-statistic-collector-from-list-25012.fsm (184.2 KiB)

Show more comments

question