The Structural Engineer's Corner

Eng. Onorio Francesco Salvatore

[DOWNLOAD] Annual Probability of Exceedance for structures in New Zealand according to AS-NZS 1170


In this post an Excel spreadsheet based on the AS/NZS 1170 is available. Scope of the tool is to define the Annual Probability of Exceedance, P (and, hence, Average Recurrence Level, R), for Ultimate State Limit and Serviceability Limit States. The values are referred to New Zealand, as per Section 3, Table 3.3. The Annual […]

Read the rest of this entry »

OFS Bolts and Weldings – Excel spreadsheet


Another Excel Spreadsheet in the structural engineer’s collection. This Excel spreadsheet permits the bolts and weldings check according to chapter 4.2.8 (§4.2.8.1.1 and §4.2.8.2.4) of Italian Code D.M. 14/01/2008. For bolts check you have just to put your inputs:

Read the rest of this entry »

Function analysis with integral and first derivative plot – Excel spreadsheet


This tool will plot a given function, its integral and first derivative. How to use the tool The usage is best illustrated with an example: suppose you want to integrate the equation y = esin(x) – 2 from x = 0 to x = 10. The constant of integration (value of the integral at x=0) […]

Read the rest of this entry »

Solution of System of Simultaneous Linear Equations – Excel spreadsheet


Here you can find an Excel spreadsheet for the solution of system of simultaneous linear equations. There are the options: – Solution of 2 Simultaneous Linear Equations with 2 Unknowns; – Solution of 3 Simultaneous Linear Equations with 3 Unknowns; – Solution of 4 Simultaneous Linear Equations with 4 Unknowns; – Solution of 5 Simultaneous […]

Read the rest of this entry »