getting internal forces from RSA to XL (API)

[Anonymous]

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

[Rafal.Gaweda · Accepted solution]

 

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/high...

[Anonymous]

OK thanks!

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

benoît

[Rafal.Gaweda]

The file for message 22 attached.

What changes would you like to have?

[Anonymous]

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?

[Rafal.Gaweda]

Try this

[Anonymous]

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

[Rafal.Gaweda]

I have also such macro

[Anonymous]

GREAT!

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

Many thanks

Benoît

[Anonymous]

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

[Rafal.Gaweda]

Take a look at this attached macro.

- selection of bars - from robot

- selection of cases - from robot

[Anonymous]

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

[Rafal.Gaweda]

Take a look at this xls.

I made it for geometrically bottom and top node.

[Anonymous]

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

[Rafal.Gaweda · Accepted solution]

Here you are

[Anonymous]

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

[Rafal.Gaweda]

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.

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