Discussion Groups

Robot Structural Analysis

Reply
Product Support
Rafal.Gaweda
Posts: 5,087
Registered: ‎04-26-2010

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

10-16-2012 07:12 AM in reply to: TraitCarré

Take a look at this attached macro.

- selection of bars - from robot

- selection of cases - from robot



Rafal Gaweda
Please use plain text.
Valued Contributor
TraitCarré
Posts: 65
Registered: ‎07-26-2012

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

10-16-2012 09:14 PM in reply to: Rafal.Gaweda

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

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,087
Registered: ‎04-26-2010

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

10-18-2012 01:35 AM in reply to: TraitCarré

Take a look at this xls.

I made it for geometrically bottom and top node.

 

 



Rafal Gaweda
Please use plain text.
Valued Contributor
TraitCarré
Posts: 65
Registered: ‎07-26-2012

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

10-18-2012 04:13 AM in reply to: Rafal.Gaweda

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

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,087
Registered: ‎04-26-2010

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

10-19-2012 06:21 AM in reply to: TraitCarré

Here you are



Rafal Gaweda
Please use plain text.
Valued Contributor
TraitCarré
Posts: 65
Registered: ‎07-26-2012

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

10-22-2012 10:33 PM in reply to: Rafal.Gaweda

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

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 5,087
Registered: ‎04-26-2010

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

10-23-2012 12:38 AM in reply to: TraitCarré

 

 

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

 

 



Rafal Gaweda
Please use plain text.