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 (§ and § 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 »