Steel Buildings in Europe

Part 8: Design Software – Section Capacity 8 - 1 1 INTRODUCTION This document provides an introduction to the Excel workbook that calculates the design resistance of steel members (beams and columns) in accordance with EN 1993-1-1, as part of the design guide Multi-storey steel buildings . The workbook offers the alternative of different languages, and selection of National Annex values. The operation of the spreadsheet is described in the following Section 2. Screenshots of the various sheets in the workbook are given in Section 3. 1.1 Visual Basic The spreadsheet depends on extensive visual basic code. Some users may have security settings set to disable such code. The security level can be changed by selecting: “Tools”, “Options”. Select the “Security” tab and select “Macro security”. The setting must be at least “Medium”. Usually, Excel must be closed and re-started for the changes in security levels to become effective. 1.2 Scope The spreadsheet calculates resistances of steel members subject to the following types of forces and moments:  Axial compression  Bending  Combined axial compression and bending  Tension  Shear  Point load (Web bearing and buckling) Each worksheet provides a cross-sectional view of the selected section as well as the main geometric data. In the case of tension and web bearing and buckling resistance, it also provides a graphic illustration drawn to scale showing what the detail looks like. Member resistances and drawn details are immediately updated as input data is modified by the user. 1.2.1 National Annex The workbook includes National Annex values for  M0 ,  M1 and  M2 . for the following countries:  Belgium  France  Germany  Italy  Netherlands  Poland