Import from Excel to Experiment parameters

Question

question

Jeremy R asked Aug 29, '22 Andrew O commented Sep 1, '22

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.

Software Version:

FlexSim 22.2.0

experimenter excel import

image-2022-08-29-101528872.png (80.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.

Andrew O commented · Sep 01, 2022 at 07:48 PM

Hi @Jeremy R, was Kavika F's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2022-08-29T19:35:43Z

Kavika F answered Aug 29, '22

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 (123.2 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.

question