Pack C designs the two members every industrial shed needs and general beam sheets do not handle well: two workbooks, sold as a pack or one by one.
| Code | Workbook | Designs |
|---|---|---|
| ILU-800-SH01 | Roof Purlin Design | Hot-rolled purlins on sloping roofs: loads, five load combinations, biaxial bending, uplift LTB, deflection |
| ILU-800-SH02 | Gantry Girder Design | I-section with channel cap under EOT or hand cranes: wheel loads, LTB, web checks, deflection |
All workbooks share the same Project tab, report title block and format as Packs A and B. Each workbook is self-contained and works without the others.
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.
