The spreadsheets have been developed with the goal of carry out fast calculations according to the Eurocodes (EN) and have been produced to cater for both first-time users and the very experienced. The spreadsheets will be issued with publications (provided electronically in the PDF format) covering their use, complete with model designs and verification tests. The data given in the “problem sketch” of each test is intended to illustrate the problem in general terms rather than to give all the data necessary to actually perform the test. The verification tests-results given in the publications were obtained using Microsoft® Office® Excel® 2003 (11.5612.5606), which comes with Microsoft Office Professional Edition 2003®.

Click on it to view book details

A4 format (last update: September 2019)
PDF - PC, iPad

Eurocodes Spreadsheets - Verification Tests - (@lulù.com)

Support independent publishing: Buy this e-book on Lulu.

Book1 - Download links (chapters):

 

 

(Cover)

 

(TOC)


(Link) EN 1990.exe Eurocode 0: Basis of Structural Design Target reliability index Approach for calibration of design values (section C7 - EN1990)  factors (section C10.EN1990). Assessment via the characteristic value Standard evaluation procedure (Method (a)) Standard evaluation procedure (Method (b)).

 

EN1991-1-1.exe - Eurocode 1: Actions on structures - Part 1-1: General actions Sec. 6 - Imposed loads on buildings - From Sec. 6.3 Characteristic values of imposed loads to Sec. 6.4 Horizontal loads on parapets and partition walls acting as barriers. Annex A - Informative - Tables for nominal density of construction materials, and nominal density and angles of repose for stored. Annex B - Informative - Vehicle barriers and parapets for car parks.

 

(Link) EN1991-1-2_(a).exe - Eurocode 1: Actions on structures - Part 1-2: General actions - Actions on structures exposed to fire From Sec. 3.1 to Sec. 3.3 Sec. 3.2 Nominal temperature-time curves. Sec. 3.2.1 Standard temperature-time curve. Sec. 3.2.2 External fire curve. Sec. 3.2.3 Hydrocarbon curve Annex A - Informative - Parametric temperature-time curves.

 

EN1991-1-2_(b).exe - Eurocode 1: Actions on structures - Part 1-2: General actions - Actions on structures exposed to fire Annex B - Informative - Thermal actions for external members - simplified calculation method. Sec. B.4 Characteristics of fire and flames. Sec. B.4.1 No forced draught. Sec. B.4.2 Forced draught.

 

EN1991-1-2_(c).exe - Eurocode 1: Actions on structures - Part 1-2: General actions - Actions on structures exposed to fire Annex C - Informative - Localised fires. Equations (net heat flux vs Theta-m @ time “t”). Annex E - Informative - Fire load densities. Sec. E.4 Rate of heat release Q.

 

EN1991-1-2_(d).exe - Eurocode 1: Actions on structures - Part 1-2: General actions - Actions on structures exposed to fire Annex F - Informative - Equivalent time of fire exposure. Annex G - Informative - Configuration factor (for the calculation of temperatures in external members). Annex B (Sec. B.5, taken from Annex B), Sec. B.5 Overall configuration factors.

 

EN1991-1-3_(a).exe - Eurocode 1 - Actions on structures - Part 1-3: General actions - Snow loads. Sec. 5 - Snow load on roofs. Sec. 5 Roof shape coefficients. Sec. 5.3.2 Monopitch roofs. Sec. 5.3.3 Pitched roofs. Sec. 5.3.4 Multi-span roofs. Sec. 5.1 Nature of the load. Sec. 5.3.5 Cylindrical roofs. Sec. 5.3.6 Roof abutting and close to taller construction works. Sec. 6 - Local effects - Sec. 6.2 Drifting at projections and obstructions. Sec. 6.3 Snow overhanging the edge of a roof. Sec. 6.4 Snow loads on snowguards and other obstacles.

 

EN1991-1-3_(b).exe - Eurocode 1 - Actions on structures - Part 1-3: General actions - Snow loads. Annex A - Normative - Design situations and load arrangements to be used for different locations. Annex B - Normative - Snow load shape coefficients for exceptional snow drift. Sec. B.2 Multi-span roofs. Sec. B.3 Roofs abutting and close to taller structures. Sec. B.4 Roofs where drifting occurs at projections and parapets.

 

(Link) EN1991-1-3_(c).exe - Eurocode 1 - Actions on structures - Part 1-3: General actions - Snow loads. Annex C - Informative - European ground snow load maps. (Expression characteristic snow load on the ground vs Climatic region). Sec. 4.3, Sec. 5.2 - Snow load on roofs (Sec. 5.2(3)P). Annex D - Informative - Adjustment of the ground snow load according to return period.

-------------------------------------------------------------------------------

EN1991-1-4_(a).exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 4 - Wind velocity and velocity pressure. Sec. 4.2 Basic values. Sec. 4.3 Mean wind. Sec. 4.3.2 Terrain roughness. Sec. 4.3.1 Variation with height. Sec. 4.4 Wind turbolence. Sec. 4.5 Peak velocity pressure (basic velocity pressure, exposure factor). EN1991-1-4_(a)_2.xls - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7.2 - Pressure coefficients for building. Sec. 7.2.2 Vertical walls of rectangular plan buildings. UK National Annex - Fundamental value of the basic wind velocity.

 

EN1991-1-4_(a)_2.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7.2 - Pressure coefficients for building. Sec. 7.2.2 Vertical walls of rectangular plan buildings. UK National Annex - Fundamental value of the basic wind velocity.

-------------------------------------------------------------------------------

EN1991-1-4_(a)_3.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Pressure and force coefficients. Sec. 7.2 Pressure coefficients for building. Sec. 7.2.2 Vertical walls of rectangular plan buildings. Sec. 7.12 Asymmetric and counteracting pressure and forces.

 

EN1991-1-4_(a)_4.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.2 Pressure coefficients for buildings. Sec. 7.2.3 Flat roofs.

 

(Link) EN1991-1-4_(a)_5.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.2 Pressure coefficients for buildings. Sec. 7.2.4 Monopitch roofs.

 

EN1991-1-4_(a)_6.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.2 Pressure coefficients for buildings. Sec. 7.2.5 Duopitch roofs.

 

EN1991-1-4_(a)_7.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.2 Pressure coefficients for buildings. Sec. 7.2.6 Hipped roofs.

 

EN1991-1-4_(a)_8.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.2 Pressure coefficients for buildings. Sec. 7.2.7 Multispan roofs.

 

EN1991-1-4_(a)_9.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.2 Pressure coefficients for buildings. Sec. 7.2.8 Vaulted roofs and domes.

 

EN1991-1-4_(a)_10.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.2 Pressure coefficients for buildings. Sec. 7.2.9 Internal pressure.

 

EN1991-1-4_(a)_11.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.2 Pressure coefficients for buildings. Sec. 7.2.10 Pressure on walls or roofs with more than one skin. Sec. 7.3 Canopy roofs.

 

(Link) EN1991-1-4_(a)_12.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.4 Free-standing walls, parapets, fences and signboards. Sec. 7.4.2 Shelter factors for walls and fences. Sec. 7.4.3 Signboards. Sec. 7.5 Friction coefficients.

 

EN1991-1-4_(a)_13.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.6 Structural elements with rectangular sections. Sec. 7.7 Structural elements with sharp edged section. Sec. 7.8 Structural elements with regular polygonal section.

 

EN1991-1-4_(a)_14.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.9 Circular cylinders. Sec. 7.9.1 External pressure coefficients. Sec. 7.9 Circular cylinders. Sec. 7.9.2 Force coefficients.

 

EN1991-1-4_(a)_15.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.9 Circular cylinders. Sec. 7.9.3 Force coefficients for vertical cylinders in a row arrangement. Sec. 7.10 Spheres.

 

EN1991-1-4_(a)_16.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.11 Lattice structures and scaffoldings.

 

EN1991-1-4_(a)_17.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 7 - Sec. 7.12 Flags. Sec. 7.13 Effective slenderness and end-effect factor.

 

EN1991-1-4_(a)_18.exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Sec. 8 Wind actions on bridges. Sec. 8.3 Force coefficients. Sec. 8.3.1 Force coefficients in x-direction (general method). Sec. 8.3.2 Force in x-direction - Simplified Method. Sec. 8.3.3 Wind forces on bridge decks in z-direction. Sec. 8.3.4 Wind forces on bridge decks in y-direction.

 

(Link) EN1991-1-4_(b).exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Annex A - Informative - Terrain effects. Sec. A.2 Transition between roughness categories 0,I,II,III and IV. Sec. A.4 Neighbouring structures. Sec. A.5 Displacement height.

 

EN1991-1-4_(c).exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Annex B - Informative - Procedure 1 for determining the structural factor cscd. Sec. B.1 WInd turbulence. Sec. B.2 Structural factor. Sec. B.3 Number of loads for dynamic response. Sec. B.4 Service displacement and accelerations for serviceability assesments of a vertical structure. Sec. 6.3 Detailed procedure (from Sec. 6 - EN 1991-1-4). Sec. 6.3.1 Structural factor cscd.

 

EN1991-1-4_(d).exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Annex C - Informative - Procedure 2 for determining the structural factor cscd. Sec. C.1 Wind turbulence - Procedure 2 for determining the structural factor cscd. Sec. C.2 Structural factor. Sec. C.3 Number of loads for dynamic response. Sec. C.4 Service displacement and accelerations for serviceability assesments of a vertical structure. Sec. 6.3 Detailed procedure (from Sec. 6 - EN 1991-1-4). Sec. 6.3.1 Structural factor cscd.

 

EN1991-1-4_(e).exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Annex E - Informative [from Sec. E.1 to Sec. E.1.5.2.5] - Vortex shedding and aeroelastic instabilities. Sec. E.13 Basic parameters for vortex shedding. Sec. E.1.3.1 Critical wind velocity. Sec. E.1.3.2 Strouhal number St. Sec. E.1.3.3 Scruton number Sc. Sec. E.1.3.4 Reynolds number Re. Sec. E.1.4 Vortex shedding action. Sec. E.1.5 Calculation of the cross wind amplitude. Sec. E.1.5.2 Approach 1 for the calculation of the cross wind amplitudes. Sec. E.1.5 Calculation of the cross wind amplitude. Sec. E.1.5.2.2 Lateral force coefficient clat. Sec. E.1.5.2.3 Correlation length L. Sec. E.1.5.2.4 Effective correlation length factor Kw.

 

EN1991-1-4_(f).exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Annex E - Informative [from Sec. E.1.5.2.6 to Sec. E.4.3] - Vortex shedding and aeroelastic instabilities. Sec. E.15 Calculation of the cross wind amplitude. Sec. E.1.5.2.6 Number of load cycles. Sec. E.1.5.2.7 Vortex resonance of vertical cylinders in a row or grouped arrangement. Sec. E.1.5.3 Approach 2, for calculation of the cross wind amplitudes. Sec. E.2 Galloping. E.2.2 Onset wind velocity. Sec. E.2.3 Classical galloping of coupled cylinders. Sec. E.3 Interference galloping of two or more free standing cylinders. Sec. E.4 Divergence and Flutter. Sec. E.4.3 Divergency velocity.

 

EN1991-1-4_(g).exe - Eurocode 1: Actions on structures - Part 1-4: General actions - Wind actions. Annex F - Informative - Dynamic characteristic of structures. Sec. F.2 Fundamental frequency. Sec. F.3 Fundamental mode shape. Sec. F.4 Equivalent mass. Sec. F.5 Logarithmic decrement of damping.

 

EN1991-1-5_(a).exe - Eurocode 1: Actions on structures - Part 1-5: General actions - Thermal actions. Sec. 5 Temperature changes in buildings. Sec. 5.2 Determination of temperatures. Sec. 5.3 Determination of temperature profiles.

 

(Link) EN1991-1-5_(a)_2.exe - Eurocode 1: Actions on structures - Part 1-5: General actions - Thermal actions. Sec. 6.1.1 Bridge deck types. Sec 6.1.2 Consideration of thermal actions. Sec 6.1.3 Uniform temperature component. Sec 6.1.4 Temperature difference components. Sec 6.1.5 Simultaneity of uniform and temperature difference components. Sec 6.1.6 Differences in the uniform temperature component between different structural elements.

 

EN1991-1-5_(b).exe - Eurocode 1: Actions on structures - Part 1-5: General actions - Thermal actions. Sec. A.1 General - [values of both annual minimum and maximum shade air temperature for height above sea level > 0]. Sec. A.2 Maximum and minimum shade air temperature values with an annual probability of being exceeded p other than 0,02.

 

EN1991-1-5_(c).exe - Eurocode 1: Actions on structures - Part 1-5: General actions - Thermal actions. Annex C (Informative) Coefficients of linear expansion. Annex D (Informative) Temperature profiles in buildings and other construction works [Analysis of temperature distribution within a structural member].

 

EN1991-1-6.exe - Eurocodes 1: actions during execution - Part 1-6: Principles and general rules for the determination of actions which should be taken into account during the execution of buildings and civil engineering works.