Editing load cases in excel? API?

[Anonymous]

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. 

[Rafal.Gaweda]

Hi @Anonymous

This macro works for combinations made of simple cases only.

For example comb 1200 contains comb 1000 + simple case

[Rafal.Gaweda]

Hi @Anonymous

Finally I got your point.

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

[Anonymous]

Fantastic! This is so useful.

Thank you

[mgaafar · Accepted solution]

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.

[danielroure2267]

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

---

---

[Rafal.Gaweda]

Hi @danielroure2267 

Near the beginning of code add

RobApp.Interactive = 0

at the end

RobApp.Interactive = 1

[danielroure2267]

Thank you

[danielroure2267]

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

[rokas_varanauskas]

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

[ALEXTHAINESE]

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

[Rafal.Gaweda]

Hi @ALEXTHAINESE 

I am afraid it is not implemented in API.

[1234eddie]

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...

[JPNR87]

Hi,

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

Thanks for answers!

[Rafal.Gaweda]

Hi @JPNR87 

Yes it does.

What is the problem?

[JPNR87]

[Rafal.Gaweda]

??????

[bos3UYUJ]

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

[Rafal.Gaweda]

Hi @bos3UYUJ 

I am afraid it is not possible. 

[bos3UYUJ]

No problem. Thank you for your quick reply.

Best wishes

[bac5VG3Q]

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.