Learning Forum

[zimmermana1992]

Hi all,

Is it possible to export solution data from a parametric study into excel or other program for post processing? I have quite a lot of design variations (2000), so this would be very time consuming to do it manually. Its not very intuitive to compare across many design variations inside of Ansys.

I understand there are custom design sheets that you can create, but it doesn't provide the option to export all solution data, from all design variations, into one file. Maybe there is also possibility to create a table with all solutions inside of Ansys which can be exported? I haven't figured out how to do that.

Thanks for the help.

[Navya C]

Hi @zimmermana1992 When you say "export Solution data" what all data do you want to export?
Is it the design sheet for each variation?

Regards Navya

[zimmermana1992]

Hi Navya,
Yes, The design sheet would be sufficient. Although I don't need all of the information in the design sheet. My key performance data that I want to extract is shown in the attached screenshot.
I would like to review the results for this data for each design variation.
Do you think its possible?

[Deyu Li]

you can export a customized design sheet with keywords, there are two templates coming from installation. folder path is at: C:\Program Files\AnsysEM\AnsysEMXX.X\Win64\Examples\RMxprt.

You can refer to either one, and use the key words in the design sheet to create a design sheet.
1. Click RMxprt>Analysis Setup>Export.
2. Select Customized Design Sheet from the pull-down list Type. Type in the directory of the output Excel file or browse and find the output Excel sheet you want to use in the Path box, and clicking Save to return to the dialog box Export.
3. Click OK to close the dialog box Export