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 Roof Framing Designer (NSCP 2015)
Steel

Roof Framing Designer (NSCP 2015)

Design the roof framing of one steel gable roof on angle trusses by NSCP 2015 (7th edition, SI), in one linked workbook: the roofing-sheet screws, the cold-formed purlins and sag rods, the steel truss analysis and its members, the joints, and the supports with their anchor rods. Wind comes from the roof geometry (MWFRS and components and cladding by zone), the purlin reactions load the truss, the truss forces size every member and joint, and the reactions go to the anchors; change one input and every sheet follows.

Purlins and sag rods: lipped C or lipped Z, simple or lapped continuous spans, from a library of Philippine stock sections or typed; black and pre-galvanized steels (ASTM, AS, JIS) or a typed Fy and Fu; sheet and purlin thickness as base metal (BMT) or total coated (TCT); gravity and wind uplift on every purlin line, the R-factor route of 554.6.1.1 with automatic routing to a rational analysis, weak axis between sag rods, shear and web crippling, deflection, the purlin anchorage of 554.6.3.1, sag rods of 10, 12 or 16 mm, the ridge tie, the end-bay X-bracing as a wind girder and the eave strut. Sheets and screws: pull-out, pull-over and shear, with conditions 9 to 13 of 554.6.1.1.

Truss and members: compound Fink, Fink, Howe, Pratt, pitched Warren, mono-pitch or a Custom form; single angles and double angles back to back, bolted or welded ends, stitches, bottom-chord ties, angle X-bracing; every load combination of 203.3.1 with the envelope per member; tension, compression, the top chord with bending from the purlins, and deflection against IBC 2009 Table 1604.3. Joints: bolt groups, fillet-weld groups, the heel joint, gussets with the Whitmore section and block shear, chord splices and the apex, the purlin cleat, the cleats of the eave strut and the end-bay strut, and the lug of the X-rods. Supports: bearing plate, grout pad, the anchor rods (cast-in and post-installed types) with breakout, pullout, side-face blowout and bond in tension, breakout and pryout in shear, the interaction of 417.6, the slotted end and the heel weld, checked in every combination at both ends. All checks are listed in the Design Check Summary (113 rows) with demand, capacity, ratio and status under one overall result: ROOF FRAMING ADEQUATE, ADEQUATE · SEE CHECKS, REVISE THE ROOF FRAMING or INCOMPLETE DATA — SEE CHECKS. Drawings of the sheet profile, the purlin section, the end bay and the support plate are in the workbook.

Not covered: portal frames, standing-seam, monoslope, hip and troughed roofs, gable overhangs, unequal spans, scissor, bowstring and parallel-chord trusses, members other than angles, slip-critical joints, fatigue, earthquake loads on the truss (except the collector force of the eave strut and the end-bay seats), the design of the sheet itself (the maker's tables), the design of the column, and base plates under moment.

References: NSCP 2015 (7th edition, 1st printing), with the page of each reference shown in the workbook; ACI 318M-14 where NSCP Section 417 relies on it; IBC 2009 Table 1604.3 for deflection limits; ASTM, AS and JIS steel grades and maker data for sheets and screws, listed in the Read Me. Three printed pages of our copy of the NSCP (2-27, 2-28 and 4-107) were unavailable; the workbook states where each is used and what it uses instead.

Checks run on the workbook: automated runs of more than 6 million checks (random and wide cases, blank and zero inputs, every drop-down value) ended with no problem; the sample's roof loads were re-derived from the printed NSCP in a separate script and agree within 0.1 % on pressures and 0.03 % on forces; and the truss analysis was compared with an independent ETABS 22 model: 3,213 member forces (27 members in 119 load combinations) agree to rounding.

Every result is a visible Excel formula. Includes the Excel workbook. View sample on the store page previews a worked A4 sample calculation (74 pages: roof R-1 of the one-storey shop RF-1 in Metro Manila, 12.0 x 24.0 m, seven trusses at 4.0 m, rise 2.0 m, V = 260 km/h, Exposure C; result ROOF FRAMING ADEQUATE, governing check purlin line P2 in uplift at 0.994, top chord 2L75x75x9, 12 mm sag rods, 24 mm X-rods, 16 mm anchor rods on a 400 x 400 mm column top). The sample is illustrative; the basic wind speed is a reading of the wind map, to be confirmed for the real site. Companion of the e-book Roof Framing Design Made Clear (NSCP 2015) on library.rhces.com; both are also sold together in the Roof Framing Bundle (Bundles). One licence per engineer or office.

Excel · Loads, Purlin, Sag Rod, Truss, Members, Joints, Supports and Summary sheets (A4); View sample: 74 pa
₱1,499.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