question

Bryan Suharik avatar image
0 Likes"
Bryan Suharik asked Sam Stubbs commented

Export performance Measures after Experiment?

Hello,

After an experiment scenario (10 replications) id like my performance measures to be exported to an excel file for each scenario.

How do i achieve this? Thanks in Advance!

Version 16.2

Bryan

experimenter
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

Sam Stubbs avatar image
1 Like"
Sam Stubbs answered Sam Stubbs commented

There's not a simple drop down option to do this. Although that is a good idea to post to the devs.

You can achieve this by using some triggers and code combined with a global table.

  • First start by setting up a global table. In your Experimenter go to the advanced tab, and add some logic to your End of Replication trigger. Here you are going to select write to a global table. Select the options you want to have your replications write their info to your Global table.
  • Second, set up your excel export options by opening the Excel Interface (It's the button at the top between the Tools and Tree buttons). In the Export tab, click the green plus sign, and set up a new export. Set your file/workbook/sheet name options, and select Global Table as the table type. Then select the global table you are going to export.
  • Finally, in your Experimenter advanced tab again, add a snippet of code to your End of Experiment trigger with this command: excelmultitableexport()

That should allow you to export your data to a Global Table and from the Global Table to excel after you run the experimenter.

· 2
5 |100000

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

Bryan Suharik avatar image Bryan Suharik commented ·

Hi @Sam Stubbs

The only problem with that is that i need the PErformance measure average value. I.e. the experiment runs for 10 times and i take the average value. Perhaps it's a good option for development as you suggest.

bryan

0 Likes 0 ·
Sam Stubbs avatar image Sam Stubbs ♦ Bryan Suharik commented ·

Yeah, the best way to do that would be to write the results to the Excel sheet, and have the excel sheet then calculate the averages. But this could be a good idea to post to the developers.

0 Likes 0 ·