Create panel cuts and return the desired results to excel through Robot API

[mnggBA5CL]

Hi,

I am trying to create a vba code using API to create a bunch of panel cuts at desired locations, input for those panel cuts coordinates will be given in excel, our code should take that coordinates create a panel cuts in robot and should print the results back to the same excel file which will be used for designing that panel. I am new to ROBOT API please help me out. 

[Stephane.kapetanovic]

hi @mnggBA5CL 

you should read this topic :

https://forums.autodesk.com/t5/robot-structural-analysis-forum/api-panel-cuts/m-p/7167371#M54662

Best Regards

After that, one solution may be to read the results at the FE nodes..

https://forums.autodesk.com/t5/robot-structural-analysis-forum/read-fe-results-api-python/m-p/109415...

[mnggBA5CL]

Hi @Stephane.kapetanovic , i have read both the topics and i am not able to find what i need is from those topics.

all i want is to create many panel cuts in robot through API and get those integral values back in excel for further processing.

[Stephane.kapetanovic]

hi @mnggBA5CL 

When you say ‘return the desired results to Excel,’ what exactly do you mean? Are you referring to the tabulated calculation results for the cuts? The calculation results are not accessible from the panel cuts; they can only be displayed as a graphical result. The results are accessible from the results server. You need to create your own algorithm to do this.

Best Regards

To use this code, you need to have created a panel passing through the plane defined by the three points.

Sub CreatePanelCut()
  Dim RobApp As IRobotApplication
  Dim CutMngr As IRobotPanelCutMngr
  
  Set RobApp = New RobotApplication
  Set CutMngr = RobApp.Project.Structure.Results.FiniteElems.PanelCuts
  
  Dim DiagSect As IRobotPanelCut
  Set DiagSect = CutMngr.Create()
  With DiagSect
    .DefinitionType = I_PCDT_FULL_PLANE
    .Point1.Set -25, -5, 0
    .Point2.Set -3, -5, 0
    .Point3.Set -3, -5, 5
    .Color = 4
    .Active = True
  End With
  CutMngr.Store DiagSect, "A1"
  
  Set RobApp = Nothing
End Sub

[mnggBA5CL]

hi @Stephane.kapetanovic 

by ''return the desired results' i mean, panel cut results which are shown on graphical window as shown below, i want these results in excel through api, is it possible?

thanks for your time, appreciate it

[Stephane.kapetanovic]

hi @mnggBA5CL 

The results you want to extract require you to identify the load cases, the combinations, the position of all the cuts, and the geometry of the relevant panels. You'll need to extract the nodes and finite element (FE) neighbors of the cuts, organize them, extract the associated calculation values, and extrapolate the intermediate results to find the maxima. Depending on your expertise, this process may take more or less time.

Best Regards

[mnggBA5CL]

hi @Stephane.kapetanovic  

is there any related code samples to do the above processes you have mentioned?

[Stephane.kapetanovic]

hi @mnggBA5CL 

You can find almost everything you need to do this here, but you should get your project estimated by a professional developer. the volume for a very simple tool based on a rough extraction with excel is about 1500 lines of code and you can add a few classes to speed things up. The Robot software already allows you to read these results even if the search is not automatic.

Best Regards