Tabling Member forces to Global Axis and Not local Axis

[tinusD9SCA]

I am designing a steel structure with non-symmetric geometry, meaning the member local axis differs from the global axis. Naturally Robot provides the forces generated to the local axis. I need to export the forces based on the global axis for each member to a different spreadsheet that requires the moments and shear forces along the gblobal axis.

Is this possible  (My model as approx 500 members and 90 load cases and each member is checked along 5 points- this makes exporting from the forces table my only option)

[lauri_barnhart]

Hello, @tinusD9SCA.

Thank you for posting your question. Could you provide some additional information such as product version or any other information that might be relevant?

Thanks,

[Stephane.kapetanovic · Accepted solution]

hi @tinusD9SCA

although it was not specifically requested in your message, I thought you might find the following discussion thread useful. It includes programming examples for converting forces between coordinate systems, along with best practices for extracting force results. I hope you find it helpful.

https://forums.autodesk.com/t5/robot-structural-analysis-forum/uniform-moment-in-bar-in-local-coordi...

https://forums.autodesk.com/t5/robot-structural-analysis-forum/api-best-practice-for-capturing-bar-f...

Updated 08/08/2026

See also how to restore the local axis defined by the section itself ↓.

https://forums.autodesk.com/t5/robot-structural-analysis-forum/how-to-obtain-results-for-beam-elemen...

Here is an Excel workbook containing a ready-to-use macro; it queries the member forces for the selected elements and load cases, then automatically converts them from the local coordinate system to the global coordinate system.

Best Regards

[robthenry0]

Have you checked the member force display and result table settings to see whether the output can be switched from local to global axes? It would also be useful to know whether you need the global components for all members or only for selected members, since that may affect the best way to export the results.

[lauri_barnhart]

Hello, @tinusD9SCA.

It looks like you have received some advice here. When you have a chance, please look at the replies and see if a solution is available. If either of the replies helps you resolve the question, please consider clicking on the 'Accept Solution' button. If you still have additional questions and still need assistance, please provide an update here.

Best,

[tinusD9SCA]

Hi Thanks



Yes, this is resolved



I just haven't had the opportunity to visit the forum to provide feedback
and thank everyone.