Works out purlin loads from the roof geometry and designs the purlin for biaxial bending under all Table 4 combinations, including wind uplift.
| Use it for | Roof purlins of industrial sheds, warehouses, workshops, canopies; checking existing purlins |
|---|---|
| Section types | Channels, I-sections, SHS, RHS from any database in the list |
| Loads it works out | Self weight from the section; roof imposed load from IS 875 (Part 2) reduced with slope (0.75 kN/m² up to 10°, less 0.02 per degree, minimum 0.40), or your own value; load split into normal and down-slope parts; wind pressure and uplift from your pd and net Cp |
| Load combinations | 1.5 DL + 1.5 IL · 1.2 DL + 1.2 IL + 0.6 WL · 1.2 DL + 1.2 IL + 1.2 WL · 1.5 DL + 1.5 WL inward · 0.9 DL + 1.5 WL uplift (Table 4) |
| Checks (IS 800:2026) | Classification, Table 2 · bending about both axes to 15.2.1 with the elastic-modulus cap · lateral torsional buckling under uplift (bottom flange in compression), 15.2.2 · biaxial bending as required by 15.9 and Section 16 · shear, 15.4 · deflection span/150 elastic or span/180 brittle cladding, Table 6 |
| You enter | Section; purlin span, spacing and slope; simply supported or continuous; sag rods (none, mid-span, third points); LLT under uplift; sheeting and other dead load; imposed load mode; design wind pressure, net inward and uplift coefficients; deflection limit |
| You get | Loads per metre, moments in each combination, Mdz with and without LTB, Mdy, Vd, a utilisation ratio for each combination, shear and deflection, the governing case, steel weight per m² of roof, ADEQUATE / NOT ADEQUATE |
| Not covered | Cold-formed Z / C purlins (IS 801 / IS 811); LTB of the bottom flange in hogging zones of continuous purlins under gravity; design of sag rods and cleats; calculation of wind pressure |
Know before buying: Pack C covers hot-rolled purlins and gantry girders. Cold-formed Z / C purlins, roof trusses, portal frames and columns are not in this pack. Full details: Pack C page.
Common to both workbooks
- Design code: IS 800:2026 (Fourth Revision), limit state method; γm0 = 1.10. Load combinations from Table 4; loads to IS 875 (Part 2) and inputs from IS 875 (Part 3).
- Software: Microsoft Excel 2016 or later on Windows or Mac, including Microsoft 365. No macros, add-ins or internet connection needed.
- Not supported: Google Sheets, LibreOffice, Excel Online editing.
- Units: kN, kNm, m for loads and lengths; mm for dimensions; kN/m² for area loads; MPa for stresses.
- Steel grades: IS 2062 E250 to E450 (fy reduces with thickness), EN S275 / S355 / S460, IS 4923 / IS 1161 YSt grades for hollow purlins.
- Section database: 3,525 sections: IS 808:2021, SAIL, Jindal, Tata Structura, APL Apollo, ArcelorMittal, British Steel, IS 4923 / IS 1161.
- Key drawing: the Input tab carries a labelled drawing that shows what every input means (roof section and plan for purlins; girder section, wheels and crane plan for gantries).
- Tabs: Guide, Input (inputs, live results, key drawing), Summary (one-page report), Detailed (clause-by-clause calculation), Project (report title block).
- Reports: A4 portrait, print or save as PDF. Every page carries your company name, project, client, job no., calc no., revision, date, made / checked / approved by and issue status (Preliminary to GFC). Your logo can be added to the report header.
- Protection: all formulas are locked; only the shaded input cells can be edited.
- Support: Ilustraca Academy, ilustraca.tech@gmail.com
Engineer’s responsibility: these workbooks are design aids. Results must be reviewed by a qualified structural engineer, who remains responsible for the design. Wind pressure and pressure coefficients are entered by you from IS 875 (Part 3); crane data comes from the crane supplier.
