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