question

Giada R avatar image
0 Likes"
Giada R asked Regan Blackett edited

INSERT EXCEL DOCUMENT IN PROCESS FLOW

Hi,

I would like to know a way to insert variables inside the process flow through an excel document (for example, to change the size, the position of the rack).
In this way I would like, if necessary, to modify the variables through the excel document and,hence, the objects related to them .



Attached is, also, the document with the script and the variables I have to insert and the document with the process flow.
modello-con-script.fsm

modello-con-flow.fsm

Do you have any suggestions?
Thanks to anyone who can help me

FlexSim 19.2.4
insert document excel in process flow
modello-con-script.fsm (2.9 MiB)
modello-con-flow.fsm (36.4 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Regan Blackett avatar image
1 Like"
Regan Blackett answered Regan Blackett edited

The best thing to do would be to import the Excel sheet into a Global Table in your model and then let your process flow reference the cells of the Global Table.

Read about the Excel Interface here

And Global Tables here

The specific way you will use these concepts depends a lot on your model and what you are trying to accomplish. I'd recommend giving these a read, giving it a try and coming back if you are having trouble.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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