Hello I am very new to the spreadsheet calculator provided with RSA, but do have some experience with VBA programming.
From my initial trials and following the video tutorials:
http://www.youtube.com/watch?v=jo6N6XyRZ_M
http://www.youtube.com/watch?v=cjxVZrapj_E
I have been able to pull information from an existing RSA model, Node coordinates, maximum member stresses etc.
However, what I would like to be able to do is create a model from a spreadsheet. I currently have a spread sheet that calculates loads and the geometry of a roof and would like to be able to quickly generate a model from this information i.e.
- Create nodes
- Members
- Define section properties
- Apply loads
- Analyse
And then to return the maximum stresses and deflections to see if the proposed installation is ok.
Is this possible?
I have looked through the help file and the only equations I see include the command
“GET “ for example ROS_GET_BAR_DATA (**********)
Is there a similar command such as “SET”?
Or how do I go about creating a node and then changing its coordinates and then assigning bars etc.
I realise that this question is possible very trivial, it would however be very useful if someone could give me a quick example of how this might done or guide me a resource or example.
Thanks