How can I create new processors when importing an Excel file?

Question

question

RUCU17 asked Apr 10, '24 RUCU17 commented Apr 11, '24

How can I create new processors when importing an Excel file?

I want to know how to create new processors when importing and reading the excel file? My goal is to decide through an excel cell how many processors to use in the model. Imagine typing on a cell "3" and right after importing the excel file on FlexSim 3 processors appear.

There is a cell with the Inter-Arrival time of the items in the excel file uploaded to this query. In there you can modify the number of the cell and then, when importing the file into FlexSim the source arrival time change.

In conclusion, the purpose is to use the uploaded excel file to import it into the FlexSim file, also uploaded, in order to create the number of processors indicated in the excel cell.

Software Version:

FlexSim 23.1.0

dispatcher excel import processors

importexcel.xlsx (8.6 KiB)

createnewprocessor.fsm (30.1 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2024-04-11T07:21:25Z

Felix Möhlmann answered Apr 11, '24 RUCU17 commented Apr 12, '24

To create copies of the processor you can use the "Delete and Copy Group Members" option in a model parameter.

Create a group for the processor and use the samling tool next to the reference field of the parameter to select the group and choose that option.

Then, in the Post Import Code, set the parameter to be equal to the relevant table cell and reset the model for the change to take effect.

createnewprocessor_1.fsm

capture1.png (16.6 KiB)

createnewprocessor-1.fsm (58.0 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

RUCU17 commented · Apr 11 at 08:36 AM

Thank you so much Felix! That was what I was searching for. Cheers.

0 ·

question