topic Re: getting internal forces from RSA to XL (API) in Robot Structural Analysis Forum

getting internal forces from RSA to XL (API)

Anonymous — Wed, 10 Oct 2012 15:42:42 GMT

Hello everybody,

I wonder if it is posible to get the internal forces from RSA to XL :

- with the possibility of choosing the dimensions ( N, daN, daN.N, etc)

- getting first the values for the origin of the bar for all the load cases and then the values for the end of the bar

- getting Fx as Fxcompression and Fxtraction

if someone could help me please!

Benoît

Re: getting internal forces from RSA to XL

Rafal.Gaweda — Tue, 09 Oct 2012 12:34:35 GMT

I wonder if it is posible to get the internal forces from RSA to XL :

- with the possibility of choosing the dimensions ( N, daN, daN.N, etc)

- getting first the values for the origin of the bar for all the load cases and then the values for the end of the bar

- getting Fx as Fxcompression and Fxtraction

Make these settings in table then select whole table (CTRL+A) or some records then copy it to clipboard then paste it in Excel

or take a look at this thread and find there example macros (message 12, 14, 19, maybe 22):

http://forums.autodesk.com/t5/Autodesk-Robot-Structural/Export-results-ARSA-via-API/m-p/3294083/highlight/true#M2229

Re: getting internal forces from RSA to XL

Anonymous — Wed, 10 Oct 2012 09:19:33 GMT

OK thanks!

message 22 is (almost) what I was looking for.

benoît

Re: getting internal forces from RSA to XL

Rafal.Gaweda — Wed, 10 Oct 2012 09:39:09 GMT

The file for message 22 attached.

What changes would you like to have?

Re: getting internal forces from RSA to XL

Anonymous — Wed, 10 Oct 2012 11:01:30 GMT

Thanks for the file!

I would like to have Fx as traction and compression, if possible.

My final goal is to analyse those values in order to get the max bending moment and the max of FX and Fz resultant (squareroot(Fx²+Fz²)) for each point (node) on the bar.

I've you this kind of macro?

Re: getting internal forces from RSA to XL (API)

Rafal.Gaweda — Wed, 10 Oct 2012 14:34:56 GMT

Try this

Re: getting internal forces from RSA to XL (API)

Anonymous — Fri, 12 Oct 2012 06:37:49 GMT

OK thanks,

I will add some macro to get the maximum force for each bar extremity in order to design the connection.

I could use the SpreadsheetCalculator, but for the moment, we don't use the Eurocode5....

rgds

benoît

Re: getting internal forces from RSA to XL (API)

Rafal.Gaweda — Fri, 12 Oct 2012 07:42:44 GMT

I have also such macro

Re: getting internal forces from RSA to XL (API)

Anonymous — Fri, 12 Oct 2012 09:11:41 GMT

GREAT!

I will just add a column with sqr(Fx²+Fy²+Fz²) and that will be fine.

Many thanks

Benoît

Re: getting internal forces from RSA to XL (API)

Anonymous — Tue, 16 Oct 2012 11:34:27 GMT

After analyse, this macro is not exactly what I wanted.

I have a hall with several time the same frame.

I want to select the same bar of each frame (all the rafters for exemple), and find the bar which has the maximum Sqr(Fx²+Fz²) and the maximum My.

Would you have some macro like that?

rgds

Benoît

Re: getting internal forces from RSA to XL (API)

Rafal.Gaweda — Tue, 16 Oct 2012 14:12:30 GMT

Take a look at this attached macro.

- selection of bars - from robot

- selection of cases - from robot

Re: getting internal forces from RSA to XL (API)

Anonymous — Wed, 17 Oct 2012 04:14:23 GMT

Hi Rafal,

It's almost perfect!

Do you think it would be possible to get the maximum values separetely for the end and the origin of the bars.

If I take the exemple of a rafter, it would give the max values of the top and the max value for the bottom part.

Rgds

Benoît

Re: getting internal forces from RSA to XL (API)

Rafal.Gaweda — Thu, 18 Oct 2012 08:35:07 GMT

Take a look at this xls.

I made it for geometrically bottom and top node.

Re: getting internal forces from RSA to XL (API)

Anonymous — Thu, 18 Oct 2012 11:13:17 GMT

It would be perfect if it would work with hyperbar (bar composed with several bars)....

it'll really save a lot of time

Thanks

Benoît

Re: getting internal forces from RSA to XL (API)

Rafal.Gaweda — Fri, 19 Oct 2012 13:21:49 GMT

Here you are

Re: getting internal forces from RSA to XL (API)

Anonymous — Tue, 23 Oct 2012 05:33:22 GMT

Thanks a lot Rafal!

Find attached your file on which I've added MaxFX, MinFx and MaxFZ (in absolute value).

Be carefull if you have an horizontal piece (bars N° 871 and 872 or 281 and 283 on attached pdf) : the bottom part will be on the left side for the both pieces, wheras the left side side of the bar 871 must analysed with the right side of the bar 872.

I consider that a lot of time could be saved during the treatment of the values when you have a structure made by the repetition of a single frame. We should be abble to get quickly the max values in order to calculate all the connections, and, in case of modification (load, geometry, support conditions, etc), to be abble to check quickly if the connections are still OK.

Can you tell us if Autodesk will officialy develop this kind of spreadsheets in the future?

Rgds

Benoît

Re: getting internal forces from RSA to XL (API)

Rafal.Gaweda — Tue, 23 Oct 2012 07:38:42 GMT

That's why node numbers are given.

My assumptions in short: if Z1<Z2 -> bottom node1, if Z1=Z1-> Y1<Y2 -> bottom node 1, if Z1=Z2, Y1=Y2 -> X1<X2 -> bottom node 1....

If you want to change it please play with this part of code:

    If RNO.Z < RNE.Z Then
        BottomNode = RNO.Number
    Else
        If RNO.Z > RNE.Z Then
            BottomNode = RNE.Number
        Else
            If RNO.Y < RNE.Y Then
                BottomNode = RNO.Number
            Else
                If RNO.Y > RNE.Y Then
                    BottomNode = RNE.Number
                Else
                    If RNO.X < RNE.X Then
                        BottomNode = RNO.Number
                    Else
                        BottomNode = RNE.Number
                    End If
                End If
            End If
        End If
    End If