RHCES Spreadsheet Store

Serviceability Checks

Torsional Irregularity Checker (NSCP 2015)

by RHCES

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 worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Torsional Irregularity Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

Storey Drift & P-Delta Checker (NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Storey Drift & P-Delta Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

Soft Storey Checker (Stiffness Irregularity, NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Soft Storey Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

Weak Storey Checker (Strength Irregularity, NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Weak Storey Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

Mass Irregularity Checker (NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Mass Irregularity Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

Vertical Geometric Irregularity Checker (NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Vertical Geometric Irregularity Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

In-Plane Discontinuity Checker (NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: In-Plane Discontinuity Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

Re-entrant Corner Checker (NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Re-entrant Corner Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

Diaphragm Discontinuity Checker (NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Diaphragm Discontinuity Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

Out-of-Plane Offset Checker (NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Out-of-Plane Offset Checker, NSCP 2015 · Sample calculation, A4

Serviceability Checks

Nonparallel System Checker (NSCP 2015)

by RHCES

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 and a worked A4 sample calculation. One licence per engineer or office.

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

Includes 2 files: Excel workbook: Nonparallel System Checker, NSCP 2015 · Sample calculation, A4

Spreadsheets that do the work.

Torsional Irregularity Checker (NSCP 2015)

Storey Drift & P-Delta Checker (NSCP 2015)

Soft Storey Checker (Stiffness Irregularity, NSCP 2015)

Weak Storey Checker (Strength Irregularity, NSCP 2015)

Mass Irregularity Checker (NSCP 2015)

Vertical Geometric Irregularity Checker (NSCP 2015)

In-Plane Discontinuity Checker (NSCP 2015)

Re-entrant Corner Checker (NSCP 2015)

Diaphragm Discontinuity Checker (NSCP 2015)

Out-of-Plane Offset Checker (NSCP 2015)

Nonparallel System Checker (NSCP 2015)