Autodesk Robot Structural Analysis

[#1]

Take a look at this attached macro.

- selection of bars - from robot

- selection of cases - from robot

[#2]

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

[#3]

Take a look at this xls.

I made it for geometrically bottom and top node.

[#4]

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

[#5 · Accepted solution]

Here you are

[#6]

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

[#7]

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