topic Automatic data generation to Excel in Robot Structural Analysis Forum

Automatic data generation to Excel

Anonymous — Sun, 21 Feb 2016 00:17:50 GMT

Hi,

I am doing my dissertation on cable trusses. The aim of the dissertation is to find the working ranges of the trusses by changing different parameteres. After chaging the parameters like, prestress, span, dip, thermal load application and more; I have to plot different graphs like pre-stress against displacement. I saw someone in the discussion trying to do that using VBA. I have no idea what VBA is. Is there a way to generate data directly to excel?

The discussion where someone else trying to do that

http://forums.autodesk.com/t5/robot-structural-analysis/api-vba-for-automatic-data-generation-to-excel/td-p/5510307/highlight/true

Can someone explain it here please. It will save me buckets loads of time...

I imagine proceadure should be as follows:

VBA reads a range of relative elongation values (or maybe there schould be a step increment)
It applies it to cable prestress value
Robot runs calculation
VBA copies Displacements of nodes to one sheet and stresses to another.
VBA applies another relative elangation for cable,
Robot runs analysis
and so on.

Copied results schould build one after another to one table.

I am attaching my robot file.

Re: Automatic data generation to Excel

Anonymous — Sun, 21 Feb 2016 12:07:26 GMT

Have you tried the results connect feature? https://knowledge.autodesk.com/support/robot-structural-analysis-products/learn-explore/caas/CloudHelp/cloudhelp/2016/ENU/RSAPRO-WhatsNew/files/GUID-A8E4D3BD-FD44-4189-85B2-85B35705C704-htm.html

Re: Automatic data generation to Excel

Anonymous — Sun, 21 Feb 2016 13:09:35 GMT

I will have a look at it now

Re: Automatic data generation to Excel

Anonymous — Sun, 21 Feb 2016 16:40:38 GMT

yeah, but it doesnt automatically increase the relative elongation or other parameteres which i mentioned..