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
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.
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
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.
5 People are following this question.
