Interface with MS Excel/OpenOffice

Technical Article on the Topic Structural Analysis Using Dlubal Software

  • Knowledge Base

Technical Article

This article was translated by Google Translator

View original text

In RF-/STEEL EC3, you can optimize a cross‑section automatically within the design. For this, select the corresponding cross‑section in Table 1.3 or define variable parameters for a welded cross‑section.

In terms of a further optimization or variant analysis, you can also select completely different cross-sections for the design in the add-on module as they are connected with members in the RFEM/RSTAB model. You can manually overwrite an existing cross-section in column B of Table 1.3 with a desired section. However, in the case of several cross‑sections or long descriptions such as “IU 500/250/16/10.2/200/16/0/0”, this can be time‑consuming. The MS Excel interface, which is consistently available in RFEM/RSTAB, allows you to do this in no time at all, see Figure 1.

Please note: When optimizing a cross‑section, the internal forces are not automatically recalculated with the modified cross‑sections. The user decides which sections are to be transferred to the main program for recalculation.

To transfer the cross -section to RFEM/RSTAB, right -click the corresponding cross -section in Window 1.3 - Cross -Sections, see Figure 2.

Because of the modified stiffnesses in the system, the internal forces defined by the optimized cross-sections can differ significantly.

Author

Bastian Ackermann, M.Sc.

Bastian Ackermann, M.Sc.

Customer Support

Mr. Ackermann provides technical support for customers of Dlubal Software and takes care of their requests.

Keywords

Interface MS Excel Excel Cross-section optimization Optimization analysis

Links

Write Comment...

Write Comment...

  • Views 508x
  • Updated 27 April 2021

Contact us

Contact Dlubal

Do you have questions or need advice?
Contact our free e-mail, chat, or forum support or find various suggested solutions and useful tips on our FAQ page.

+49 9673 9203 0

info@dlubal.com

Blast Time History Analysis in RFEM

Blast Time History Analysis in RFEM

Webinar 13 May 2021 2:00 PM - 3:00 PM EDT

Online Training | English

RFEM for Students | Part 3

Online Training 15 June 2021 2:00 PM - 4:30 PM CEST

Plate and Shell Buckling Utilizing Dlubal Software

Plate and Shell Buckling Utilizing Dlubal Software

Webinar 30 March 2021 2:00 PM - 2:45 PM CEST

CSA S16: 19 Steel design in RFEM

CSA S16:19 Steel Design in RFEM

Webinar 10 March 2021 2:00 PM - 3:00 PM EDT

Dlubal Info Day

Dlubal Info Day Online | 15 December 2020

Webinar 15 December 2020 9:00 AM - 4:00 PM BST

Stability Design in Steel Construction with RFEM and RSTAB

Stability Design in Steel Construction with RFEM and RSTAB

Webinar 1 December 2020 2:00 PM - 2:45 PM BST

Programmable COM Interface for RFEM/RSTAB

Programmable COM Interface for RFEM/RSTAB

Webinar 12 May 2020 3:00 PM - 3:45 PM CEST

Designing Cold-Formed Steel Sections According to Eurocode 3

Designing Cold-Formed Steel Sections According to Eurocode 3

Webinar 30 April 2020 3:00 PM - 3:45 PM CEST

Membrane Structures with Wind Loads From CFD Wind Simulation

Membrane Structures with Wind Loads From CFD Wind Simulation

Webinar 24 March 2020 3:00 PM - 4:15 PM BST

Nonlinear Time History Analysis in RFEM

Nonlinear Time History Analysis in RFEM

Webinar 8 May 2018 3:00 PM - 4:00 PM EDT

Piping Design in RFEM

Piping Design per ASME in RFEM

Webinar 13 December 2017

RFEM Steel and Aluminium Structures
RF-STEEL EC3 5.xx

Add-on Module

Design of steel members according to Eurocode 3

Price of First License
1,480.00 USD