question

William Proctor avatar image
1 Like"
William Proctor asked Sam Stubbs commented

Writing Experimenter Results in a Consolidated Global Table

I have created a global table to store the input and output information for each of my experiment runs. The data for each scenario goes into the column equal to the scenario number. This works great if I run a single experiment but breaks down if I want to use the experimenter to run multiple scenarios.

Is there a way to copy a single column of a table of a scenario into the base global table so that the entire table is populated at the end of the experimenter run?

FlexSim 16.1.1
global tableexperimentercopyconsolidation
· 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.

William Proctor avatar image William Proctor commented ·

Can I assume that "replication" and "scenario" are already established values for the experimenter? I don't see them defined except as input parameters. I'm trying to understand in the code how to save multiple values in one column for one scenario (only one repetition). Thanks!

0 Likes 0 ·

1 Answer

Sam Stubbs avatar image
0 Likes"
Sam Stubbs answered Sam Stubbs commented

So I'm trying to figure out exactly what you're trying to write as the output of your results. Because you have 3 axis of information you're looking at with an experimenter. Variables, Scenarios, and Number of Replications.

For example if you're wanting the results of each Replication for each Scenario of one specific variable, you can easily set this up where columns represent the Scenarios, and each Row is a result.

If you go into the Advanced tab in your experimenter, in the "End of Replication" trigger, you can select "Write to a Global Table."

In this example the Table field would be the name of your Global table. The row is each of the replications, and the columns are each of the scenarios. And in this example I'm looking at the input of "Sink5," in relation to the different scenarios. (One thing you'll need to be wary of, is if you are using a Global Table that is already populated with input numbers. You'll need to go into the code and offset the column or whatever that's being written to, to be in line with where you want those output values to be written. Otherwise it will start writing the values at 0,0))

I'm attaching the model below. You can see as an example.

experimenterexample.fsm


· 5
5 |100000

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

William Proctor avatar image William Proctor commented ·

Thanks. I'm looking at your example. In my case, I'm only doing one replication for each experiment and then filling in the entire scenario column with the input and output information for that one scenario replication.

0 Likes 0 ·
Sam Stubbs avatar image Sam Stubbs ♦ William Proctor commented ·

So just to clarify, are each of the rows your variables then?

0 Likes 0 ·
William Proctor avatar image William Proctor Sam Stubbs ♦ commented ·

Yes. There are around 100 different values on one scenario that I would be transferring from the scenario to the global table.

0 Likes 0 ·
Show more comments