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.
Solved! Go to Solution.
Solved by mgaafar. Go to Solution.
Solved by Rafal.Gaweda. Go to Solution.
Solved by Rafal.Gaweda. Go to Solution.
Hi @Anonymous
This macro works for combinations made of simple cases only.
For example comb 1200 contains comb 1000 + simple case
Hi @Anonymous
Finally I got your point.
Macro with no limits for simple cases and combinations (also embedded) attached.
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.
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
Near the beginning of code add
RobApp.Interactive = 0
at the end
RobApp.Interactive = 1
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
thanks
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
Adding label for load cases , is it poosible from excel to RSA using API?
I don't know if it's still relevant.
But in this topic you will find a solution, thanks to rafal.
Hi,
does API "RMI_loadcomb_nested_with_subnatures" cooperate with RSA 2021. Im having a problem.
Thanks for answers!
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
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):
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.
Can't find what you're looking for? Ask the community or share your knowledge.