The Structural Engineer's Corner

Eng. Onorio Francesco Salvatore

Archive for the 'Downloads' Category

[DOWNLOAD] Excel spreadsheet for evaluation of crack width according to Eurocode 2


Another addition for the Downloads section. In this post we’ll discuss about an Excel spreadsheet for the evaluation of the crack width in concrete structures. The inputs required are: INPUT Characteristic compressive cylinder strength fck 30 N/mm² Characteristic tensile strength of reinforcement fyk 500 N/mm² Base b 300 mm Height h 500 mm QP moment […]

Read the rest of this entry »

[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 »

[DOWNLOAD] Torsional section properties for concrete sections according to ACI 314


In this post, an Excel spreadsheet for the evaluation of the torsional section properties of concrete sections according to the ACI 318 is available. The sections are: – rectangular near the edge; – rectangular in interior position; – L-shaped; – inverted tee. The design for torsion as per ACI 318 is based on a thin-walled tube, […]

Read the rest of this entry »

[DOWNLOAD] Moment of Inertia of the cracked section transformed to concrete for T-sections according to ACI 314


Following the Excel spreadsheet for the rectangular section, in the following you can download the spreadsheet for the evaluation of the Moment of Inertia of the cracked section transformed to concrete, Icr, for T-sections. The reference is the ACI 314R-11 “Guide to Simplified Design for Reinforced Concrete Buildings“. Basically, starting from the gross section:

Read the rest of this entry »

[DOWNLOAD] Moment of Inertia of the cracked section transformed to concrete for rectangular sections according to ACI 314


New addition for the Download section: the following Excel spread sheet calculates the Moment of Inertia of the cracked section transformed to concrete, Icr, for rectangular sections. The reference is the ACI 314R-11 “Guide to Simplified Design for Reinforced Concrete Buildings“. Basically, starting from the gross section:

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 »

RO-Goal Seek: thousand equations solutions in just one click!


Do you need to use Goal Seek function on multiple cells? You can do it manually multiple times or… save time using this custom function! With RO-GoalSeek you can use the Excel function thousand of times in just one click! Do you need results in short time? Don’t let your boss getting nervous, be quick!

Read the rest of this entry »

[DOWNLOADS] NTC08 travi continue: foglio Excel per risoluzione travi continue su più campate


NTC08 travi continue è un foglio Excel sviluppato per la risoluzione di travi continue su più campate in accordo con le vigenti disposizioni normative del D.M. 14 gennaio 2008. Il file è articolato in più fogli: – da 1 a 8 campate in condizioni non sismiche; – da 1 a 8 campate in condizioni sismiche; […]

Read the rest of this entry »

[REPOST] PROCOID – PROgetto COstruzioni IDrauliche v. 1.3 (dimensionamento serbatoio, blocchi di ancoraggio, verifica statica tubazioni interrate, verifica alla massima pressione, verifica alla massima depressione)


[REPOST] Il PROCOID giunge alla terza edizione con la possibilità di diagrammare l’andamento dei carichi nel terreno per la verifica delle tubazioni interrate. Ma andiamo con ordine: quando vogliamo eseguire questo tipo di verifica dobbiamo anzitutto valutare quali siano le sollecitazioni sulla nostra tubazione. Si hanno: Carico statico da rinterro (la porzione di terreno agente […]

Read the rest of this entry »

Spettri elastici DM2008 – calcolo dell’azione sismica e definizione spettri con Excel


Con questo articolo si mette a disposizione un foglio Excel che sicuramente tornerà utilissimo a molti.  Tale foglio, infatti, consente il calcolo dell’azione sismica in accordo con il DM 2008 e la relativa rappresentazione degli spettri. L’utilizzo del foglio è molto semplice ed il tutto è suddiviso per fasi. Nel foglio “Fase 1” si immettono […]

Read the rest of this entry »