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 510x
  • Updated 04/19/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.

(267) 702-2815

info-us@dlubal.com

Blast Time History Analysis in RFEM

Blast Time History Analysis in RFEM

Webinar 05/13/2021 2:00 PM - 3:00 PM EDT

Online training | English

RFEM for Students | Part 3

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

Plate and Shell Buckling Utilizing Dlubal Software

Plate and Shell Buckling Utilizing Dlubal Software

Webinar 03/30/2021 2:00 PM - 2:45 PM CEST

CSA S16:19 Steel Design in RFEM

CSA S16:19 Steel Design in RFEM

Webinar 03/10/2021 2:00 PM - 3:00 PM EDT

Dlubal Info Day

Dlubal Info Day Online | December 15, 2020

Webinar 12/15/2020 9:00 AM - 4:00 PM BST

Programmable COM Interface for RFEM/RSTAB

Programmable COM Interface for RFEM/RSTAB

Webinar 05/12/2020 3:00 PM - 3:45 PM CEST

Nonlinear Time History Analysis in RFEM

Nonlinear Time History Analysis in RFEM

Webinar 05/08/2018 3:00 PM - 4:00 PM EDT

RFEM Steel and Aluminum 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