Discussion Groups

Robot Structural Analysis

Reply
Valued Mentor
tony.ridley
Posts: 653
Registered: ‎09-07-2011

Re: Editing load cases in excel?

02-16-2012 02:00 AM in reply to: Rafal.Gaweda

Rafal,

 

Whats your address for the courier with the case of beer?

 

Cheers,

Tony

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,596
Registered: ‎04-26-2010

Re: Editing load cases in excel?

09-24-2012 03:44 AM in reply to: tony.ridley

Small update in attached file.

Possibility to make nested combinations. 
Limitation: max 23 simple cases can be used; But of course xls and macro can be modified to handle more. Have fun :-)There are just 26 columns for combinations in sheet but if you want more just create columns like precedent ones (contents of row 3 and 4) - no modification of macro is required in this case.



Rafal Gaweda
Please use plain text.
*Expert Elite* | International Moderator
Romanich
Posts: 584
Registered: ‎09-29-2009

Re: Editing load cases in excel?

05-20-2013 05:30 AM in reply to: Rafal.Gaweda

Dear Rafal,

If I understand correctly, for now we can't read/write Subnature type via API. Maybe I'm wrong?

   
Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,596
Registered: ‎04-26-2010

Re: Editing load cases in excel?

05-20-2013 06:01 AM in reply to: Romanich

 we can't read/write Subnature type via API.

 

We can read it by   .NatureName

Unfortunately we can not set subnature by API.



Rafal Gaweda
Please use plain text.
*Expert Elite* | International Moderator
Romanich
Posts: 584
Registered: ‎09-29-2009

Re: Editing load cases in excel?

05-20-2013 06:08 AM in reply to: Rafal.Gaweda

Unfortunately we can not set subnature by API.

 

Could you create Development Request for this issue please? Because this is a very need for work with Revit+Robot. 

   
Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,596
Registered: ‎04-26-2010

Re: Editing load cases in excel?

05-20-2013 06:19 AM in reply to: Romanich

My mistake - it is possble:

 

SetNatureExt (_rgl_action : long)



Rafal Gaweda
Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,596
Registered: ‎04-26-2010

Re: Editing load cases in excel?

05-21-2013 12:21 AM in reply to: Rafal.Gaweda

Updated xls with subnatures

 

 



Rafal Gaweda
Please use plain text.
Valued Contributor
jo2ny
Posts: 82
Registered: ‎02-07-2012

Re: Editing load cases in excel?

10-30-2013 05:26 AM in reply to: Rafal.Gaweda

This xls file is candy! Very nice!

 

But greed makes me wonder if there is some kind of excel like this that can generate also combinations.

I usualy have the same loads & combinations (fewer than the automatic generator makes). I could edit them in excel once, and use them whenever i need in the future.

 

So my question was, is there a tool for doing this (generation of loads and comb form excel) ?

 

Thanks,

Please use plain text.
Valued Contributor
jo2ny
Posts: 82
Registered: ‎02-07-2012

Re: Editing load cases in excel?

10-30-2013 05:47 AM in reply to: jo2ny

FOUND IT!

Never mind previous post! :smileyembarrassed:

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,596
Registered: ‎04-26-2010

Re: Editing load cases in excel?

10-30-2013 06:46 AM in reply to: jo2ny
Second tab of this macro :-)


Rafal Gaweda
Please use plain text.