RHCES Spreadsheet Store

Serviceability Checks

Torsional Irregularity Checker (ASCE 7-22)

by RHCES

Check the torsional irregularity of a building from your ETABS, SAP2000, STAAD or RAM results by ASCE 7-22 Chapter 12 (SI units). Paste the ETABS tables (Story Max Over Avg Drifts and Displacements, ETABS 22 or older layouts) or type the values, for up to 50 storeys and 8 load cases.

For every storey and load case the sheet works out the Torsional Irregularity Ratio TIR (maximum over average storey drift) against 1.2 (the single Type 1 of ASCE 7-22), with EXTREME above 1.4, and the amplification factor Ax of 12.8.4.3 (1.0 to 3.0) with the amplified accidental eccentricity. It gives the governing storey and load case in each direction, PASS / CHECK / EXTREME for every storey and case, one overall result (NO TORSIONAL IRREGULARITY, TORSIONALLY IRREGULAR or EXTREME TORSIONAL IRREGULARITY) and a checklist of what the irregularity triggers by Seismic Design Category: 3D model, amplified accidental torsion, drift at the edges, orthogonal load combinations, diaphragm and collector force increase, height limits, redundancy and the mass offset restriction of modal response spectrum analysis. Six live charts show the TIR, Ax and the edge and average drift against the elevation. The ASCE 7-22 provisions follow published secondary sources; the Read Me lists what is still to be confirmed.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 6 live charts · ETABS paste · SI units

Includes 2 files: Excel workbook: Torsional Irregularity Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

Storey Drift & P-Delta Checker (ASCE 7-22)

by RHCES

Check storey drift, P-Delta stability and structural separation from your ETABS, STAAD.Pro, SAP2000 or RAM results by ASCE 7-22 Chapter 12 (SI units). Paste the ETABS tables Story Max Over Avg Displacements, Diaphragm Center of Mass Displacements and Story Forces (ETABS 22 or older layouts) or type the values, for up to 50 storeys in X and Y, up to 8 load cases, risk categories I to IV and SDC A to F.

Storey by storey the sheet works out the design storey drift (Cd times the elastic drift over Ie) against the allowable drift of Table 12.12-1 (divided by the redundancy factor for moment-frame-only systems in SDC D to F), taken along the edges for torsionally irregular structures in SDC C to F; the stability coefficient against 0.10 (drift amplified above it) and its maximum; the Type 1 torsional irregularity (TIR above 1.2, extreme above 1.4) with Ax; and the separation from adjacent structures and a property line (12.12.2), with Cd and the overstrength factor for every system of Table 12.2-1. The sheet names the storey and load case of the largest drift per direction, and a design check summary (PASS / CHECK / EXTREME / FAIL) gives one overall result: DRIFT OK, OK · SEE CHECKS, REVISE — DRIFT EXCEEDED or REVISE — SEE FAILS. Six live charts plot the drift ratio, the stability coefficient and the level displacement with their limits and the separation. The values come from secondary sources and ASCE 7-16 (such as the allowable drifts); the Read Me lists what is not yet confirmed.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 6 live charts · ETABS paste · SI units

Includes 2 files: Excel workbook: Storey Drift & P-Delta Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

Soft Storey Checker (Stiffness Irregularity, ASCE 7-22)

by RHCES

Check the soft storey (stiffness) irregularity of a building from your ETABS, SAP2000, STAAD or RAM results by ASCE 7-22 Chapter 12 (SI units). Paste the ETABS Story Stiffness table (ETABS 22 or older layouts) or type the storey shear and drift, or the stiffness, for up to 50 storeys in X and Y, one load case per direction.

The sheet works out k = V / drift for every storey and, below the roof, its ratio to the storey above and to the mean of the three above against Table 12.3-2 Type 1a (70 % and 80 %) and Type 1b, extreme (60 % and 70 %), with the 12.3.2.2 exceptions (structures of one storey, or two in SDC B to D; no storey drift ratio above 1.3 times that of the storey above). It gives the lowest ratios and their storeys per direction, PASS, CHECK (Type 1a) or EXTREME (Type 1b) for each storey tested, one overall result (NO SOFT STOREY IRREGULARITY, marked DRIFT EXCEPTION MET where the exception is met, SOFT STOREY IRREGULARITY or EXTREME SOFT STOREY IRREGULARITY) and a checklist by SDC: Type 1b not permitted in SDC E and F (12.3.3.1, FAIL), no reduced SDS of 12.8.1.3 for irregular structures up to five storeys, and a CHECK in SDC D, where ASCE 7-22 does not prohibit Type 1b but a local amendment may. Six live charts show the stiffness and the two ratios against the elevation. The ASCE 7-22 rules follow secondary sources, not the printed standard; the Read Me lists what is unconfirmed.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 6 live charts · ETABS paste · SI units

Includes 2 files: Excel workbook: Soft Storey Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

Weak Storey Checker (Strength Irregularity, ASCE 7-22)

by RHCES

Check the weak storey (strength) irregularity of a building by ASCE 7-22 Chapter 12 (SI units). Type the lateral strength of each storey in X and Y, or build it from up to 1000 element-group rows, with the strength per element typed or worked out from Mn and Vn. Paste the ETABS Story Forces table (ETABS 22 or older layouts) or type the design storey shears from SAP2000, STAAD or RAM, for up to 50 storeys.

Storey by storey the sheet works out the strength ratio to the storey above for the weak storey (Type 4a) and extreme weak storey (Type 4b, below 65 %) of Table 12.3-2 (5a and 5b in ASCE 7-16) and applies 12.3.3.1 to 12.3.3.3 for SDC B to F (SDC A has no limit), with the overstrength exception for SDC B and C. It gives the governing storey in each direction, PASS, CHECK, EXTREME or FAIL for every storey below the roof (FAIL where the SDC does not permit it), one overall result (NO WEAK STOREY IRREGULARITY up to WEAK STOREY - NOT PERMITTED) and a checklist of what the irregularity triggers, including the loss of the 12.8.1.3 SDS reduction (five storeys or fewer). The ASCE 7-22 rules come from published redlines and summaries, not the printed standard (the Read Me lists what is unconfirmed); Type 4a follows the redline reading (weaker than the storey above), with a switch to the ASCE 7-16 definition (below 80 %). Four live charts show the strength and its ratio against the elevation.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 4 live charts · ETABS paste · SI units

Includes 2 files: Excel workbook: Weak Storey Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

Mass Irregularity Checker (ASCE 7-22)

by RHCES

Check storey masses (weights) from your ETABS, SAP2000, STAAD or RAM results against the mass irregularity, Type 2 of Table 12.3-2 of ASCE 7-16, which ASCE 7-22 deleted together with Table 12.6-1, as published summaries of the 7-22 changes show (the Read Me lists the sources and what is not yet confirmed against the printed standards). Paste the ETABS tables (Mass Summary by Story and, for the drift-ratio exception, Story Drifts; ETABS 22 or older layouts) or type the weights or masses, in any of 8 units, for up to 50 storeys.

With the ASCE 7-22 basis (the default) the ratio of every storey to the storey above and below is information only: CHECK marks a ratio above the former 1.5 limit, nothing is triggered, and the overall result reads NO MASS IRREGULARITY — TYPE DELETED IN ASCE 7-22 or MASS RATIO ABOVE 150 % — NOT AN IRREGULARITY IN ASCE 7-22. The ASCE 7-16 basis, for earlier editions, applies the former Type 2 with the drift-ratio exception of 12.3.2.2 (1.3 times the storey above, in X and Y) and, in SDC D to F, the Table 12.6-1 limit on the equivalent lateral force procedure as one secondary source gives it (its exceptions are not evaluated: ELF reads CHECK). Both name the governing storey and give PASS / CHECK for every storey and a checklist with lines for 7-22 and for 7-16. Four live charts plot the weight with its allowed band, the ratios and the drift-ratio comparisons in X and Y against the elevation.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 4 live charts · ETABS paste · SI units

Includes 2 files: Excel workbook: Mass Irregularity Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

Vertical Geometric Irregularity Checker (ASCE 7-22)

by RHCES

Check the vertical geometric irregularity of a building by ASCE 7-22 Chapter 12 (SI units), Type 2 of Table 12.3-2 (Type 3 in ASCE 7-16): the horizontal dimension of the seismic force-resisting system in any storey more than 130 % of that in an adjacent storey. Paste the storey names and heights from the ETABS Story Definitions table or type them, then type the dimension of the system along X and Y for each storey, from the plan or point coordinates of your ETABS, SAP2000, STAAD or RAM model, for up to 50 storeys, and pick the Seismic Design Category. A switch, left at No, exempts a one-storey roof penthouse where your authority allows it (no source seen shows one).

In X and Y the sheet works out the ratio of each storey's dimension to the storey above and below against the 1.30 limit (a setback makes the wider storey irregular). It gives the governing storey per direction, PASS / CHECK for every storey, the overall result (NO VERTICAL GEOMETRIC IRREGULARITY or VERTICAL GEOMETRIC IRREGULARITY — SEE REQUIREMENTS) and a checklist, short because ASCE 7-22 deleted Table 12.6-1: the reduced SDS of 12.8.1.3 is lost (N/A above five storeys), the equivalent lateral force procedure is not limited (12.6) and SDC E and F do not prohibit it (12.3.3.1). The ASCE 7-22 clauses follow published secondary sources; the Read Me lists them and what is still to be confirmed. Four live charts show the stepped elevation of the system width and the ratio at every floor, in X and Y.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 4 live charts · up to 50 storeys · SI units

Includes 2 files: Excel workbook: Vertical Geometric Irregularity Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

In-Plane Discontinuity Checker (ASCE 7-22)

by RHCES

Check the in-plane discontinuity (Table 12.3-2 Type 3, Type 4 in ASCE 7-16) of the shear walls, braced bays and frame bays of a building by ASCE 7-22 Chapter 12, in SI units. Type or paste the storey list and one row per element per storey (mark, line, storey, position, length, element below), taken from your ETABS, SAP2000, STAAD or RAM model; the Read Me shows how to read the ETABS Pier Section Properties table. Up to 50 storeys, 40 element rows and 30 supporting-member actions.

The sheet works out how much of each element overhangs the element below (above your tolerance, zero by default: in-plane offset; nothing below in a storey above the lowest: discontinued element) and gives PASS, CHECK or N/A for every element, the governing element with its storey and line, 19 check lines and one overall result: NO IN-PLANE DISCONTINUITY, IN-PLANE DISCONTINUITY - SEE REQUIREMENTS, INCOMPLETE DATA - SEE CHECKS or NOT APPLICABLE - SDC A. For the supporting members it works out Em = Ω0 QE (system from Table 12.2-1, optional cap) in the 2.3.6 combinations with Ev = 0.2 SDS D. A checklist by Seismic Design Category marks REQUIRED, NOT REQUIRED or N/A: supporting elements with overstrength (12.3.3.4), the 12.3.3.5 force increase, diaphragm transfer forces and the loss of the reduced SDS of 12.8.1.3 (five storeys or fewer). A live chart draws the elevation of one line with the offset marked. The 7-22 provisions come from published secondary sources; the sheet and the Read Me mark what is not yet confirmed.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + live elevation chart · overstrength helper · SI units

Includes 2 files: Excel workbook: In-Plane Discontinuity Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

Re-entrant Corner Checker (ASCE 7-22)

by RHCES

Check the re-entrant corners of building plans, horizontal irregularity Type 2 of Table 12.3-1, by ASCE 7-22 Chapter 12 (SI units). Describe up to five plan types, each a rectangle, L, T, U, H or cruciform built from up to four dimensions, or any orthogonal outline of up to 24 vertices typed or pasted in order (from the ETABS Point Object Connectivity table, SAP2000 or STAAD joint coordinates, RAM or a CAD polyline), and give each of up to 50 storeys its plan type.

At every re-entrant corner the sheet measures both projections, to the outer limit of the plan (the safer default) or along the edges at the corner, and compares px / Lx and py / Ly with 20 % (15 % in ASCE 7-16): the corner is irregular only where both are greater. It lists up to 10 corners per plan type with PASS or CHECK, the governing ratio, the first and last storey with the irregularity, one overall result (NO RE-ENTRANT CORNER IRREGULARITY or RE-ENTRANT CORNER IRREGULARITY — SEE REQUIREMENTS) and a checklist by SDC: increase of the design forces of collectors and diaphragm connections (12.3.3.5, SDC D to F; 25 % in ASCE 7-16, the 7-22 amount not confirmed), the diaphragm flexibility of 12.3.1.2 and the loss of the reduced SDS of 12.8.1.3 (five storeys or fewer). Table 12.6-1 is deleted in 7-22: no procedure limit. Five live charts draw the plans to scale, re-entrant corners marked. The 20 % limit and the other 7-22 rules follow published redlines and summaries, not the printed standard.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 5 live plan charts · 6 preset shapes or outlines up to 24 vertices · SI units

Includes 2 files: Excel workbook: Re-entrant Corner Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

Diaphragm Discontinuity Checker (ASCE 7-22)

by RHCES

Check the diaphragm discontinuity (horizontal irregularity Type 3 of Table 12.3-1) by ASCE 7-22 Chapter 12 (SI units) from your ETABS, SAP2000, STAAD or RAM model. For up to 50 storeys, type or paste the storey names and heights (in ETABS, Name and Height of Story Definitions), the gross enclosed area of each diaphragm and its stiffness in X and Y (typed, or the index Ec t D from slab thickness, concrete modulus and diaphragm depth), then list up to 500 cut-outs by width and length or area.

The sheet adds up the cut-outs of each storey and flags an open area of more than 25 % of the gross enclosed area (the ASCE 7-22 limit in published summaries; 50 % in ASCE 7-16) and a stiffness change of more than 50 % to the storey above or below (on the smaller stiffness by default). It gives PASS or CHECK per storey, the governing storey and interface, and the overall result NO DIAPHRAGM DISCONTINUITY, DIAPHRAGM DISCONTINUITY — SEE REQUIREMENTS or INCOMPLETE DATA — SEE CHECKS. A 7-line checklist by Seismic Design Category (ASCE 7-22 items from secondary sources, see the Read Me) gives what the irregularity triggers: increased collector and connection forces (12.3.3.5, SDC D to F; amount not stated), no rigid diaphragm idealization (12.3.1.2), no SDS reduction of 12.8.1.3 (N/A above five storeys), diaphragm forces by 12.10, the ACI 318M-19 rules around openings, the 50 mm slab and the flexible-diaphragm check. Four live charts plot the open area, areas, stiffness ratio and stiffness profile against the elevation.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 4 live charts · 50 storeys, 500 cut-outs · SI units

Includes 2 files: Excel workbook: Diaphragm Discontinuity Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

Out-of-Plane Offset Checker (ASCE 7-22)

by RHCES

Check the out-of-plane offset (horizontal irregularity Type 4 of Table 12.3-1) of a building by ASCE 7-22 Chapter 12 (SI units). Type or paste the vertical seismic-force-resisting elements of every storey (walls, frame lines, braced bays) as lines in plan: mark, storey, direction X or Y, position of the plane, start and length, up to 100 lines in up to 50 storeys. The Read Me shows how to take the coordinates from ETABS connectivity tables or SAP2000, STAAD and RAM joints.

For every element above the lowest storey the sheet finds the element of the same direction below, works out the shift of its plane in mm against your tolerance and gives PASS or CHECK (offset, or no element below), the governing storey and element per direction and the supporting elements that carry an offset. A helper combines your effects for up to 8 members into the overstrength load combinations in their ASCE 7-16 form (Emh = Ω0 QE). One overall result (NO OUT-OF-PLANE OFFSET IRREGULARITY or OUT-OF-PLANE OFFSET IRREGULARITY — SEE REQUIREMENTS) and a checklist by Seismic Design Category: supporting elements designed with Ω0 (12.3.3.4), increased collector and connection forces (12.3.3.5), the three-dimensional model (12.7.3), no rigid idealization of concrete diaphragms (12.3.1.2), no reduced SDS of 12.8.1.3 (five storeys or fewer) and the diaphragm transfer forces (12.10.1.1). These come from published secondary sources, mostly ASCE 7-16 provisions not yet confirmed in ASCE 7-22; the Read Me lists them with their confidence. Three live charts show the plans of two storeys and the largest offset per storey.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 3 live charts · type or paste element lines · SI units

Includes 2 files: Excel workbook: Out-of-Plane Offset Checker, ASCE 7-22 · Sample calculation, A4

Serviceability Checks

Nonparallel System Checker (ASCE 7-22)

by RHCES

Check the nonparallel system irregularity (Type 5 of Table 12.3-1) by ASCE 7-22 Chapter 12 (SI units), from the plan geometry of your ETABS, SAP2000, STAAD or RAM model. Type or paste up to 40 lines of vertical lateral force-resisting elements (walls, frame lines, braced bays) by the coordinates of their two ends or by their angle alone, with the principal axes angle, Seismic Design Category, diaphragm type and number of storeys, and optionally each line's result from the EX and EY seismic cases.

The sheet works out each line's angle to the nearest principal axis and reads it as parallel (within your tolerance) or symmetric (a mirror-image partner about axis 1 or 2), with PASS / CHECK per line, the governing line and one overall result: NO NONPARALLEL SYSTEM IRREGULARITY or NONPARALLEL SYSTEM IRREGULARITY — SEE REQUIREMENTS. A helper combines EX and EY into each line's design value by 100 % + 30 % both ways, with SRSS for comparison. A checklist by SDC, from published secondary sources with each item's confidence shown, lists what the irregularity triggers: the orthogonal combination of 12.5 (also for a Type 1 irregularity and for columns or walls of intersecting systems with a seismic axial load above 20 % of their design strength), the three-dimensional model of 12.7.3, the rigid-diaphragm idealization of 12.3.1.2 and the loss of the reduced SDS of 12.8.1.3 (up to five storeys). Three live charts show the plan of the lines with the principal axes, each line's angle against the tolerance and the orthogonal combination.

Every result is a visible Excel formula with ASCE 7-22 section references; the items taken from secondary sources are listed in the Read Me. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + 3 live charts · up to 40 element lines · SI units

Includes 2 files: Excel workbook: Nonparallel System Checker, ASCE 7-22 · Sample calculation, A4

Spreadsheets that do the work.

Torsional Irregularity Checker (ASCE 7-22)

Storey Drift & P-Delta Checker (ASCE 7-22)

Soft Storey Checker (Stiffness Irregularity, ASCE 7-22)

Weak Storey Checker (Strength Irregularity, ASCE 7-22)

Mass Irregularity Checker (ASCE 7-22)

Vertical Geometric Irregularity Checker (ASCE 7-22)

In-Plane Discontinuity Checker (ASCE 7-22)

Re-entrant Corner Checker (ASCE 7-22)

Diaphragm Discontinuity Checker (ASCE 7-22)

Out-of-Plane Offset Checker (ASCE 7-22)

Nonparallel System Checker (ASCE 7-22)