Can I import excel to control or add data into global table?

Question

question

Pert P asked Jun 17, '22 Pert P commented Jun 18, '22

Can I import excel to control or add data into global table?

From the question, On experiment i need to import excel add data on global table or read on excel to run result but each run differnce excel example

1st replication using 1st Excel file

2nd replication use 2nd excel file

Can i import all file at same time and program will know by itself which file fit to replication using? If not how and fix

Software Version:

FlexSim 22.1.2

experiment import data excel importing

Answer 1 · 2022-06-17T21:26:25Z

Kavika F answered Jun 17, '22 Pert P commented Jun 18, '22

Hey @Pert P. When you make a Global Table, in the Properties tab, there in an Excel button you can click to Import a table.

This link will tell you more about formatting and other things about how to hookup your tables.

The way the Experimenter works is that it will run every permutation/Scenario of the parameters you give it and then give you the results. You can make parameters reference cells in a Global Table using "Pass-through" and then the dropper to reference the cell.

But the Experimenter cannot use a different Global Table for each replication of the model. If your tables don't have much information or are in ranges, you could use a Range Based experiment and use the range you want or Specific Values.

1655500969229.png (19.3 KiB)

1655501160327.png (31.9 KiB)

1655500084505.png (18.3 KiB)

· 1

Pert P commented · Jun 18, 2022 at 07:42 AM

If I have 10 Excel files (These Excel is the data similar key on Global Table and Process flow will read the data on it) to run experiment. Can I import all in to Experiment at the same time and give the program complete all Excel File and see the result of individual file. Example There are 3 Excel File on model

1st Excel File import to experiment --> run replication model 3 times --> see result

2nd Excel File import to experiment -->run replication model 3 times --> see result

3rd Excel File import to Experiment -->run replication model 3 times --> see result

On Experiment Can I add all of Excel Files at the same times and do like that?

0 ·

question