question

Jeremy R avatar image
0 Likes"
Jeremy R asked Andrew O commented

Import from Excel to Experiment parameters

Is it possible to import a table from Excel into an Experiment's parameter table?

I would like to manage all of my input data in Excel, and import that into the model to use it. However, I cannot figure out a way to define a set of scenarios in Excel, and then import that into my FlexSim model as an experiment's scenario definitions.

I tried adding an entry to the Excel Import interface then attempted to sample the experiment's scenario table, but I could only sample individual cells rather than the entire table. I've attached an image of this attempt.

image-2022-08-29-101528872.png

FlexSim 22.2.0
experimenterexcel import
· 1
5 |100000

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

1 Answer

Kavika F avatar image
0 Likes"
Kavika F answered

Hey @Jeremy R, there's not really a way to import an excel sheet into an Experimenter "Scenarios" table. However, you can copy and paste the values into the table easily.

exceltoexperimenter.gif


5 |100000

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