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
Solved! Go to Solution.
Solved by Rafal.Gaweda. Go to Solution.
Solved by Rafal.Gaweda. Go to 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):
The file for message 22 attached.
What changes would you like to have?
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?
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
GREAT!
I will just add a column with sqr(Fx²+Fy²+Fz²) and that will be fine.
Many thanks
Benoît
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
Take a look at this attached macro.
- selection of bars - from robot
- selection of cases - from robot
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
Take a look at this xls.
I made it for geometrically bottom and top node.
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
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
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
Can't find what you're looking for? Ask the community or share your knowledge.