RHCES Spreadsheet Store

Serviceability Checks

Building Separation Checker (NSCP 2015)

Check the seismic separation of your building from an adjacent building on the same property (ΔMT = √(ΔM1² + ΔM2²), Equation 208-23) or the setback from a property line (208.7.2.9) level by level, from the ETABS table Story Max Over Avg Displacements of each building or typed results, for up to 50 storeys, with the neighbour's floors at any elevation, a lower or taller neighbour, a twin building or a typed ΔM2 profile, and the separation provided in X and Y (one value or per level). Every level gets ΔM = 0.7 R ΔS, the required and the provided separation, the ratio and OK / SHORT, a design check summary gives one result (SEPARATION ADEQUATE, INCREASE THE SEPARATION, OK · SEE CHECKS or NO SETBACK REQUIRED), and four live charts draw the required against the provided separation and the joint elevation with both buildings swaying toward the joint.

Every result is a visible Excel formula with printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

Building Separation Checker (ASCE 7-22)

Check the structural separation of your building from an adjacent structure on the same property (δSS = √(δDE1² + δDE2²), Equation 12.12-2) or the setback from a property line (12.12.2) level by level, from the ETABS table Story Max Over Avg Displacements of each building or typed results, for up to 50 storeys, with the neighbour's floors at any elevation, a lower or taller neighbour, a twin building or a typed δDE2 profile, and the separation provided in X and Y (one value or per level). Every level gets δDE = Cd δe / Ie (+ δdi), the required and the provided separation, the ratio and OK / SHORT, the relative displacement δMCE1 + δMCE2 for members spanning between the structures (12.12.3), a design check summary gives one result (SEPARATION ADEQUATE, INCREASE THE SEPARATION, OK · SEE CHECKS or NO SETBACK REQUIRED), and four live charts draw the required against the provided separation and the joint elevation with both buildings swaying toward the joint.

Every result is a visible Excel formula with printed ASCE 7-22 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

Torsional Irregularity Checker (NSCP 2015)

Check the torsional irregularity of a building from your ETABS, SAP2000, STAAD or RAM results by NSCP 2015 Section 208. 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 ratio of the maximum to the average storey drift against the 1.2 limit of Table 208-10 Type 1, and the torsional amplification factor Ax (Equation 208-7, at most 3.0) with the accidental eccentricity and its amplified value. It gives the governing storey and load case in each direction, PASS / CHECK for every storey and case, one overall result (NO TORSIONAL IRREGULARITY or TORSIONALLY IRREGULAR) and a checklist of what the irregularity triggers in NSCP 2015: amplified accidental torsion, static or dynamic procedure, drift at the edges, orthogonal effects, Zone 4 diaphragm connections and the near-source factor limits, each with its clause and printed page. Six live charts show the ratio, Ax and the edge and average drift against the elevation.

Every result is a visible Excel formula with printed NSCP 2015 clause and page references. Includes the Excel workbook and a 17-page user manual (A4 PDF) that takes a real ETABS 22.7 model step by step: load patterns, the two tables to paste, the results and how to put Ax into the ETABS diaphragm eccentricity. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

Version 1.1 (November 2026), bug fix: ETABS gives Max Drift and Avg Drift in mm, but v1.0 read them as drift ratios. This bug affected the edge drift of section 09, chart 03 and the Design edge drift value. The torsion ratio, Ax and the overall result were not affected.

Excel · A4 calc sheets + 6 live charts · ETABS paste · v1.1 · 2 files incl. user manual

Includes 2 files: Excel workbook: Torsional Irregularity Checker, NSCP 2015 · User manual, A4 (17 pages)

Serviceability Checks

Torsional Irregularity Checker (ASCE 7-22)

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 17-page user manual (A4 PDF) that takes a real ETABS 22.7 model step by step: load patterns, the two tables to paste, the results and how to put Ax into the ETABS diaphragm eccentricity. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Version 1.1 (November 2026), bug fix: ETABS gives Max Drift and Avg Drift in mm, but v1.0 read them as drift ratios. This bug affected the edge drift of section 09, chart 03 and the Design edge drift value. The torsion ratio, Ax and the overall result were not affected.

Excel · A4 calc sheets + 6 live charts · ETABS paste · SI units · v1.1 · 2 files incl. user manual

Includes 2 files: Excel workbook: Torsional Irregularity Checker, ASCE 7-22 · User manual, A4 (17 pages)

Serviceability Checks

Storey Drift & P-Delta Checker (NSCP 2015)

Check storey drift, P-Delta and building separation from your ETABS, STAAD.Pro, SAP2000 or RAM results by NSCP 2015 Section 208. 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 and up to 8 load cases (static cases with and without the accidental eccentricity, response spectrum cases).

Storey by storey the sheet works out the maximum inelastic response displacement 0.7 R times the elastic drift (Equation 208-21) against 0.025 h or 0.020 h by the period, or a tolerable drift ratio you type (exception 1), at the centre of mass and at the extreme points of the plan; the P-Delta ratio against 0.10 with the Zone 4 alternative; the torsional irregularity indicator (above 1.2, Table 208-10) and Ax; and the separation from adjacent buildings and from a property line (Equation 208-23, 208.7.2.9). R for every system of Table 208-11, and every printed row names its governing load case. The sheet names the storey and load case of the largest drift in each direction, and a design check summary (PASS / CHECK / FAIL) gives one overall result: DRIFT OK, OK · SEE CHECKS, REVISE — DRIFT EXCEEDED or REVISE — SEE FAILS. Six live charts show the drift ratio with its limit, the P-Delta ratio and the level displacement with the separation, in each direction.

Every result is a visible Excel formula with printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

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

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Serviceability Checks

Soft Storey Checker (Stiffness Irregularity, NSCP 2015)

Check the soft storey (stiffness) irregularity of a building from your ETABS, SAP2000, STAAD or RAM results by NSCP 2015 Section 208. 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 the 70 % and 80 % limits of Table 208-9 Type 1, with the drift-ratio exception of 208.4.5.2 Item 2 (no storey drift ratio above 1.3 times that of the storey above, the top two storeys excepted). It gives the lowest ratios and their storeys per direction, PASS or CHECK for each storey tested, one overall result (NO SOFT STOREY IRREGULARITY, marked DRIFT EXCEPTION MET where the exception is met, or SOFT STOREY IRREGULARITY) and a checklist of what the irregularity triggers: the dynamic procedure (PASS for a dynamic or declared two-stage analysis; a static analysis reads FAIL above five storeys or 20 m and CHECK within both limits), 100 % of the static base shear for a dynamic analysis, no Na cap of 1.1 or 1.2 in Zone 4, irregular-feature requirements and the Zone 2 relief for occupancy categories IV and V, each with its clause and printed page. Six live charts show the stiffness and the two ratios against the elevation.

Every result is a visible Excel formula with printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

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

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Serviceability Checks

Weak Storey Checker (Strength Irregularity, NSCP 2015)

Check the weak storey (strength) irregularity of a building by NSCP 2015 Section 208. 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.

For every storey and direction the sheet works out the strength ratio to the storey above against the 80 % limit of Table 208-9 Type 5 and, below 65 %, the height limit of 208.4.9.1 (two storeys or 9 m) with its overstrength exception, using the factor of the system picked from Table 208-11. It gives the governing storey in each direction, PASS, CHECK or FAIL for every storey below the roof (FAIL only where 208.4.9.1 does not permit the structure), one overall result (NO WEAK STOREY IRREGULARITY, WEAK STOREY IRREGULARITY or WEAK STOREY - NOT PERMITTED) and a checklist of what the irregularity triggers in NSCP 2015: additional requirements, static or dynamic procedure, the dynamic base shear, the Zone 4 near-source factor and height limits, each with its clause and printed page. Four live charts show the strength and its ratio against the elevation.

Every result is a visible Excel formula with printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

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

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Serviceability Checks

Mass Irregularity Checker (NSCP 2015)

Check the mass (weight) irregularity of a building from your ETABS, SAP2000, STAAD or RAM results by NSCP 2015 Section 208, Table 208-9 Type 2. 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.

For every storey the sheet works out the ratio of its weight to the storey above and below against the 150 % limit (a roof lighter than the floor below is not considered) and the drift-ratio exception of 208.4.5.2 Item 2 (1.3 times the storey above, in X and Y). It gives the governing storey, PASS / CHECK for every storey, one overall result (NO MASS IRREGULARITY, NO MASS IRREGULARITY — DRIFT-RATIO EXCEPTION or MASS IRREGULARITY (TYPE 2) — SEE REQUIREMENTS; not evaluated in Zone 2 for categories IV and V) and a checklist of what the irregularity triggers, with clause and printed page: the dynamic procedure of 208.4.8.3 Item 2 (a static analysis reads FAIL above five storeys or 20 m without the two-stage analysis, CHECK at or below both), the 100 % base shear floor, the 90 % participating mass and the loss of the 50 % height-limit allowance in Zone 4. 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 printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

Mass Irregularity Checker (ASCE 7-22)

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Serviceability Checks

Vertical Geometric Irregularity Checker (NSCP 2015)

Check the vertical geometric irregularity of a building by NSCP 2015 Section 208, Table 208-9 Type 3: the horizontal dimension of the lateral-force-resisting system in any storey more than 130 % of that in an adjacent storey, one-storey penthouses excepted. 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 zone, occupancy category and analysis procedure.

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; a marked roof penthouse is left out). It gives the governing storey per direction, PASS / CHECK for every storey, the overall result (NO VERTICAL GEOMETRIC IRREGULARITY, VERTICAL GEOMETRIC IRREGULARITY — SEE REQUIREMENTS or NOT APPLICABLE — ZONE 2, CATEGORY IV OR V) and a checklist with clause and printed page: the dynamic procedure of 208.4.8.3 Item 2 (a static analysis reads CHECK up to five storeys and 20 m, FAIL above unless the two-stage analysis is justified), the 100 % static base shear floor, the vertical-irregularity designation, no 50 % increase of the Zone 4 height limits and the Zone 2 relief for categories IV and V. 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 printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

Vertical Geometric Irregularity Checker (ASCE 7-22)

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Serviceability Checks

In-Plane Discontinuity Checker (NSCP 2015)

Check the in-plane discontinuity of the shear walls, braced bays and frame bays of a building by NSCP 2015 Section 208 (Table 208-9, vertical Type 4). 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 compares the offset of each element's centre from the element below with the shorter of the two lengths (above 1.0: in-plane discontinuity; nothing below in a storey above the lowest: discontinued, shown as 9.999) 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 - ZONE 2, OCCUPANCY IV / V. For the supporting members it works out Em = Ω0 Eh (system from Table 208-11, optional cap) in Equations 203-19 and 203-20. An 11-item checklist with clause and printed page covers, among others, the supporting elements and their Zone 4 detailing, the concrete columns below, the foundation, diaphragm transfer forces, framing below the base, the near-source factor Na, the static procedure (FAIL where used above five storeys or 20 m), the Zone 4 height limits and the 100 % dynamic base shear. A live elevation chart draws one line of elements with the offset marked.

Every result is a visible Excel formula with printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

In-Plane Discontinuity Checker (ASCE 7-22)

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Serviceability Checks

Re-entrant Corner Checker (NSCP 2015)

Check the re-entrant corners of building plans by NSCP 2015 Section 208, plan irregularity Type 2 of Table 208-10. 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 15 %: 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; not evaluated in Zone 2 for categories IV and V) and a checklist of what it triggers: the Zone 4 rules for diaphragm connections and for the chords and drag members of the projecting wings (208.7.2.7 Items 6 and 7), the static procedure only up to five storeys and 20 m (FAIL if used beyond), the 3-D model of 208.5.3.3, 100 % of the static base shear in a dynamic analysis and the loss of the Zone 4 height-limit allowance of 208.4.7. Five live charts draw the plans to scale, re-entrant corners marked.

Every result is a visible Excel formula with printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

Re-entrant Corner Checker (ASCE 7-22)

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Serviceability Checks

Diaphragm Discontinuity Checker (NSCP 2015)

Check the diaphragm discontinuity (plan irregularity Type 3 of Table 208-10) by NSCP 2015 Section 208 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 50 % of the gross enclosed area 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, INCOMPLETE DATA — SEE CHECKS or, for categories IV and V in Zone 2, NOT EVALUATED. A 13-line checklist gives what the irregularity triggers: Zone 4 diaphragm connections without the one-third increase, diaphragm forces and deflection, collectors, ties, the elements around openings in concrete diaphragms, the 3-D model and 100 % base shear of the dynamic procedure, the static procedure only up to five storeys or 20 m (FAIL if used above), the 50 mm slab, the flexible-diaphragm check and no Zone 4 height-limit exception (208.4.7). Four live charts plot the open area, areas, stiffness ratio and stiffness profile against the elevation.

Every result is a visible Excel formula with printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

Diaphragm Discontinuity Checker (ASCE 7-22)

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Serviceability Checks

Out-of-Plane Offset Checker (NSCP 2015)

Check the out-of-plane offset (plan irregularity Type 4 of Table 208-10) of a building by NSCP 2015 Section 208. 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 special seismic load combinations with Em = Ω0 Eh. One overall result (NO OUT-OF-PLANE OFFSET IRREGULARITY or OUT-OF-PLANE OFFSET IRREGULARITY — SEE REQUIREMENTS; not evaluated in Zone 2 for categories IV and V) and a checklist of what the irregularity triggers, with clause and printed page: the elements supporting the discontinuous system (208.5.1.5.1.1), Chapter 4 column detailing, the diaphragm transfer forces (208.7.2.7), the Zone 4 near-source factor, the static procedure (a static analysis reads FAIL above five storeys or 20 m), the three-dimensional model and the 100 % base shear. Three live charts show the plans of two storeys and the largest offset of every storey.

Every result is a visible Excel formula with printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

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

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Serviceability Checks

Nonparallel System Checker (NSCP 2015)

Check the nonparallel system irregularity (plan Type 5 of Table 208-10) by NSCP 2015 Section 208, from the plan geometry of your ETABS, SAP2000, STAAD or RAM model. Type or paste up to 40 lines of vertical lateral-load-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 zone, occupancy category, procedure used, number of storeys and height, 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 (not evaluated for occupancy categories IV and V in Zone 2). A helper combines EX and EY into each line's design value by 100 % + 30 % both ways, SRSS or the larger of the two. The checklist of what the irregularity triggers gives clause and printed page: the orthogonal effects of 208.7.1 (Type 5, plan Type 1 for both axes, columns of intersecting systems with the 20 % exception), the three-dimensional model of 208.5.3.3, the static procedure limit of five storeys or 20 m (FAIL when the static procedure is used beyond it), 208.4.9.3 and the Zone 4 height limits. 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 printed NSCP 2015 clause and page references. Includes the Excel workbook. A worked A4 sample calculation can be previewed with View sample on the store page. One licence per engineer or office.

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

Serviceability Checks

Nonparallel System Checker (ASCE 7-22)

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. A worked A4 sample calculation can be previewed with View sample on the store page. 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

Spreadsheets that do the work.

Building Separation Checker (NSCP 2015)

Building Separation Checker (ASCE 7-22)

Torsional Irregularity Checker (NSCP 2015)

Torsional Irregularity Checker (ASCE 7-22)

Storey Drift & P-Delta Checker (NSCP 2015)

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

Soft Storey Checker (Stiffness Irregularity, NSCP 2015)

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

Weak Storey Checker (Strength Irregularity, NSCP 2015)

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

Mass Irregularity Checker (NSCP 2015)

Mass Irregularity Checker (ASCE 7-22)

Vertical Geometric Irregularity Checker (NSCP 2015)

Vertical Geometric Irregularity Checker (ASCE 7-22)

In-Plane Discontinuity Checker (NSCP 2015)

In-Plane Discontinuity Checker (ASCE 7-22)

Re-entrant Corner Checker (NSCP 2015)

Re-entrant Corner Checker (ASCE 7-22)

Diaphragm Discontinuity Checker (NSCP 2015)

Diaphragm Discontinuity Checker (ASCE 7-22)

Out-of-Plane Offset Checker (NSCP 2015)

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

Nonparallel System Checker (NSCP 2015)

Nonparallel System Checker (ASCE 7-22)