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 »