RHCES Spreadsheets

Spreadsheets that do the work.

Buy in one click, pay by GCash, Maya, QR Ph or PayPal, and your download appears as soon as the payment clears.

All products are non-refundable. Please check the details and price before you pay.
Licensed to the buyer only (one engineer or office). Sharing, uploading or reselling a product, or forwarding its download link, without the written permission of RHCES is prohibited. By buying you agree to our Terms of Service.

Preview of Wind Load Calculator (ASCE 7-22)
Structural

Wind Load Calculator (ASCE 7-22)

Calculate wind loads on buildings to ASCE 7-22 in SI units (wind speed in m/s, or type it in mph), including the ground elevation factor Ke and the ASCE 7-22 components-and-cladding zones.

Covers enclosed and partially enclosed rigid buildings with flat, gable, hip or monoslope roofs. Enter the plan size, storey heights (up to 30 storeys), roof shape and slope, exposure and the basic wind speed; the sheet works out Kz at every level, the topographic factor (2-D ridge, 2-D escarpment or 3-D hill, optional), qz and qh, the gust factor with a rigid/flexible check, and the external pressure coefficients for walls and roof by interpolation.

Main wind-force-resisting system (directional procedure): design pressures for wind in both principal directions and both internal-pressure signs, storey forces, storey shears and overturning moments, base shear and base moment, and the minimum design wind load check. Components and cladding (buildings up to 18 m): wall and roof zone pressures by effective wind area, with the zone width and the minimum pressure. Live charts show the plan with the wind directions, the pressure profile, storey forces, shears and moments.

Every result is a visible Excel formula with ASCE 7-22 section references; the Read Me lists the scope and limits. 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 + storey forces, C&C and live charts · SI (mph input)
₱349.00View sample
Preview of Seismic Load Calculator (ASCE 7-22)
Structural

Seismic Load Calculator (ASCE 7-22)

Calculate earthquake loads on buildings to ASCE 7-22 Chapters 11 and 12 (Equivalent Lateral Force procedure) in SI units, with the new site classes BC, CD and DE and the two-period design spectrum.

Enter SDS, SD1, S1 and TL from the USGS ASCE 7-22 Hazard Tool, the risk category and site class, and select the structural system from Table 12.2-1 (R, Ω0, Cd and the height limits are filled in, or type your own); the sheet works out the Seismic Design Category, checks whether the ELF procedure is permitted (Table 12.6-1), the approximate period with the Cu cap, Cs with its upper and lower limits, and the base shear V = Cs W.

Vertical distribution with the exponent k for up to 30 storeys: storey forces, shears and overturning moments. Also ρ, Eh, Ev and Em, and storey drift (δx = Cd δxe / Ie against Table 12.12-1) and P-Delta stability from the elastic displacements you enter. Live charts show the design spectrum, storey forces, shears, moments and drift.

Every result is a visible Excel formula with ASCE 7-22 section references; the Read Me lists the scope, the limits and the values to confirm against your copy of the standard. 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 + storey forces, drift/P-Delta and live charts · SI units
₱349.00View sample
1Click Buy now
2Pay by GCash, Maya or QR Ph on PayMongo’s secure page, or with PayPal
3Your Download button appears as soon as payment clears