question

Pert P avatar image
0 Likes"
Pert P asked Pert P commented

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

FlexSim 22.1.2
experimentimport dataexcel importing
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

Kavika F avatar image
0 Likes"
Kavika F answered Pert P commented

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.

1655500029631.png

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.

1655500969229.png

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.

1655501160327.png


1655500969229.png (19.3 KiB)
1655501160327.png (31.9 KiB)
1655500084505.png (18.3 KiB)
· 1
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.

Pert P avatar image Pert P commented ·

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 Likes 0 ·