Is there a way of exporting the parametric study results to a csv file or equivalent?

Is there a way of exporting the parametric study results to a csv file or equivalent?

mike.w.2020
Participant Participant
929 Views
9 Replies
Message 1 of 10

Is there a way of exporting the parametric study results to a csv file or equivalent?

mike.w.2020
Participant
Participant

I have a parametric design in which I would like to export the maximum displacement for each combination to a table for analysis. Up until now I have always had to enter these values in manually, I was wondering if there is a quicker way.

0 Likes
930 Views
9 Replies
Replies (9)
Message 2 of 10

Gabriel_Watson
Mentor
Mentor

Assuming it is not a weldment, you could open the 3D model tab in your assembly and add a 2D sketch to any plane that can see the stroke/displacement between two projected lines from your components, adding a reference dimension to save that as a parameter you can use later:

 

Galaxybane_0-1667262110917.png

 

Galaxybane_1-1667262267310.png

 

Then, with a bit of iLogic you can change your parametric design parameters in a loop (to go through each configuration possible), and export to Excel the new reference parameter measurement for the stroke, for example:

GoExcel.CellValue("c:\temp\parameters.xls", "Sheet1", "A2") = d0

 

If your parameters to change are within a subcomponent of the assembly, you may have to access them through something like this:

Parameter("myComponent:1","myParameter") = 10

 

But otherwise it is pretty straightforward.

Message 3 of 10

pcrawley
Advisor
Advisor

From the "Parametric Table" in the FEA environment - no.  You can view the "Design Constraints" resulting from your parametric changes, but there's no export option.  It would be a nice though - although what that export might look like could get complicated!

 

You can export from the Dynamic Simulation environment - but that's only exporting data relating to the motion of the model (e.g. max deflection at time interval x), it's not parametric shape changes.

Peter
Message 4 of 10

mike.w.2020
Participant
Participant

msrdc_2022-11-01_12-18-12.png

How would I go about looping through and printing each combination of dimension parameter values and design constraint (FEA max displacement in above table) results? Is there a way of retrieving these in iLogic?

 

I'm not sure where the data are stored maybe there is a way of reading through output files instead.

0 Likes
Message 5 of 10

mike.w.2020
Participant
Participant
If you know anyone who works at autodesk let them know! Thanks
0 Likes
Message 6 of 10

Gabriel_Watson
Mentor
Mentor
Sorry, I didn't realize you were talking about FEA analysis results here. Perhaps you could post the same question in the Inventor iLogic and VB.NET forum:
https://forums.autodesk.com/t5/inventor-ilogic-and-vb-net-forum/bd-p/120
Message 7 of 10

mike.w.2020
Participant
Participant
Will do thanks for your help nonetheless
0 Likes
Message 8 of 10

pcrawley
Advisor
Advisor

I'm not sure there's anything iLogic (or any other customization) can bring to the table because there's not much in the API to call when it comes to the analysis tools.

 

How would I go about looping through and printing each combination of dimension parameter values and design constraint (FEA max displacement in above table) results? 

 

To loop through the configurations, you can get it to generate the model for each parametric value:

01.jpg

Once you've done that you can drag the slider(s) to see the model change.  Right-click to get more options - like studying a particular configuration.

 

Running the analysis gives you three options:

02.jpg

 

These are defined in the help as:

  • Exhaustive set of configurations Solves all combinations of the parameters.
  • Smart set of configurations Solves the base configuration and each parameter change to the base, then interpolates the other results.
  • Current configuration only Solves the current configuration as a single point simulation.

If you want to refine your analysis, you can set "Limits" on the outputs you are analysing. 

This shows I'm within my goals:

03.jpg

And this shows I'm not:

04.jpg

 

But that still doesn't let you take all the parametric options and their results out to a table.  You can run a report to show all the outputs - but I don't think that's what you're looking for.

 

The output you are looking for would be complicated to display (even if it existed).  You'd probably have to create a new sheet in Excel for each study - and for the model in your screenshot, that would be 122 sheets (11 x 11 + 1)

 

You might be better off running the exhaustive analysis - setting some limits and checking which parameter combinations are worthy of further investigation.  Promote those configuration(s) back to the model and export the parameter(s).  While not the answer you asked for, it hopefully gets you closer to the goal more quickly - which I guess is what parametric analysis is for.

 

Hope this helps.

Peter
Message 9 of 10

mike.w.2020
Participant
Participant

image.png

Thanks for your help. I did in the end just reduce the number of points investigated and manually entered them as shown above. If I were to code it I would do something like the following:

 

for i = 1:steps_d1

    for j = 1:steps_d2

        excel or csv cell (i+1,j+1) = displacement (i,j)

    end

end

 

...etc

 

It seems like such a simple script; surely all that is required is an understanding of VB and a way of creating a matrix of displacements. I just don't know if there is a way of reading them through iLogic. If there were a way of creating macros I could try and create a macro to loop through solving each in a simple study rather than a parametric study, but I haven't found the right documentation to work this out. 

 

In any case I think you are right, parametric studies in inventor work great as a tool for quickly determining the best design in industry, but you start to see why academics prefer other packages which are more fiddly however allow much greater access 'under the hood'. I'll probably save this project for another day, it seems to be quicker to record data points manually rather than trying to find a way of exporting them! Maybe one day I'll work it out.

0 Likes
Message 10 of 10

pcrawley
Advisor
Advisor

You are correct - what you want isn't difficult to script, but the API (the tools available to work on the code behind your model) just don't exist. 

 

It's like knowing there's a pot of gold on the other side of the door - but there is no handle to open the door.

Peter