Robot Structural Analysis Forum
Welcome to Autodesk’s Robot Structural Analysis Forums. Share your knowledge, ask questions, and explore popular Robot Structural Analysis topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Editing load cases in excel? API?

63 REPLIES 63
SOLVED
Reply
Message 1 of 64
Anonymous
14808 Views, 63 Replies

Editing load cases in excel? API?

In order to create envelope diagrams, I'm about to create separate load cases for each span of a 30-span bridge and both symmetric and asymmetric loads. Is there a way to edit the load cases i excel, or do I have to create them all in Robot?

 

Thank you!

 

@Anonymous Artur Kosakowski marked Rafal Gawenda's post as the solution. If it did not work as an answer, please post your reply in this thread so that I can unmark the solution. 

63 REPLIES 63
Message 41 of 64
Rafal.Gaweda
in reply to: Anonymous

Hi @Anonymous

 

This macro works for combinations made of simple cases only.

For example comb 1200 contains comb 1000 + simple case



Rafal Gaweda
Message 42 of 64
Rafal.Gaweda
in reply to: Anonymous

Hi @Anonymous

 

Finally I got your point.

Macro with no limits for simple cases and combinations (also embedded) attached.



Rafal Gaweda
Message 43 of 64
Anonymous
in reply to: Rafal.Gaweda

Fantastic! This is so useful.

Thank you

Message 44 of 64
mgaafar
in reply to: Rafal.Gaweda

Thanks, Rafal for your effort, I find this sheet very important and helpful.

If I may suggest also to make the sheet read Static-Seismic load cases in case a Seismic load case is created. it happened that I had one in a model and it didn't catch it in the import/export generation.

Message 45 of 64
danielroure2267
in reply to: mgaafar

Hello
It's a good macro, do you know if there is a statement to block redisplay in RSA to accelerate the transfer?
Kind regards



 

Message 46 of 64

Hi @danielroure2267 

 

Near the beginning of code add

RobApp.Interactive = 0

at the end

 

RobApp.Interactive = 1


Rafal Gaweda
Message 47 of 64

Thank you

Message 48 of 64

Hello

do you think it is possible to accelerate again?
the insert of a combination is done in 1 second; I have 80000
I found the link below but I do not know how to introduce it
is it necessary to limit the cache (ApplyCache) to a number of combinations?
is what BeginMultiOperation, (IRobotCombServer?) can be used

 

 

https://knowledge.autodesk.com/fr/support/robot-structural-analysis-products/troubleshooting/caas/sf...

 

thanks

Message 49 of 64

This appears to have no effect on time it takes to transfer combinations from Excel to RSA. In one project we have just under 2000 combinations which is taking more than 60min to get transferred. It's a lot of time.

Any improvements would be greatly appreciated.

 

Rokas

Tags (3)
Message 50 of 64
ALEXTHAINESE
in reply to: Rafal.Gaweda

Adding label for load cases , is it poosible from excel to RSA using API?

 

load case labels .png

Message 51 of 64
Rafal.Gaweda
in reply to: ALEXTHAINESE

Hi @ALEXTHAINESE 

 

I am afraid it is not implemented in API.

 

 

 



Rafal Gaweda
Message 52 of 64
1234eddie
in reply to: ALEXTHAINESE

I don't know if it's still relevant. 

But in this topic you will find a solution, thanks to rafal.

https://forums.autodesk.com/t5/robot-structural-analysis-forum/robot-load-case-labels-dynamo-api-pyt...

Message 53 of 64
JPNR87
in reply to: Rafal.Gaweda

Hi,

does API "RMI_loadcomb_nested_with_subnatures" cooperate with RSA 2021. Im having a problem.

 

Thanks for answers!

Message 54 of 64
Rafal.Gaweda
in reply to: JPNR87

Hi @JPNR87 

 

Yes it does.

What is the problem?

 

 



Rafal Gaweda
Message 55 of 64
JPNR87
in reply to: JPNR87

0.JPG

Message 56 of 64
Rafal.Gaweda
in reply to: JPNR87

??????



Rafal Gaweda
Message 57 of 64
bos3UYUJ
in reply to: Rafal.Gaweda

Hi @Rafal.Gaweda,

 

In response to your video showing you copying loads from an excel spreadsheet to the "Table edition" tab in RSA, is it possible to automate this step with a macro. At the moment I have to copy and paste the table from Excel to RSA (like you show in your video) and I would like to remove this manual process.

 

Many thanks

Message 58 of 64
Rafal.Gaweda
in reply to: bos3UYUJ

Hi @bos3UYUJ 

 

I am afraid it is not possible. 



Rafal Gaweda
Message 59 of 64
bos3UYUJ
in reply to: Rafal.Gaweda

No problem. Thank you for your quick reply.

 

Best wishes

Message 60 of 64
bac5VG3Q
in reply to: bos3UYUJ

Hello, 

 

Regarding these comments, I would like to make sure that Robot API is not able to copy the load table (single loads) to Robot through VBA. I found this video that shows how a single load is created (minute 20:20):

https://www.youtube.com/watch?v=6Kv4zqgRGOo&list=RDCMUCQA3aXtNDnsT80V59qQmKGQ&start_radio=1&rv=6Kv4z...

I would like to do the same with a loop so a total of 100 or 200 loads are applied to the Robot model from a predefined excel sheet.

Thanks for your help.

THIS IS ONE OF WEBINARS SERIES PRESENTED\PRODUCED BY AUTODESK FOR ROBOT STRUCTURAL ANALYSIS

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Technology Administrators


Autodesk Design & Make Report