Designs a crane runway girder made of a rolled I-section with an optional channel cap, from the crane supplier’s data.
| Use it for | Crane gantries in workshops, factories and warehouses with EOT or hand-operated overhead cranes |
|---|---|
| Sections | Any I-section from the database, with an IS 808 channel cap (ISMC 150 to ISMC 400) or none |
| Crane loads it works out | Maximum wheel load with the crab at minimum hook approach; vertical impact (+25 % EOT, +10 % hand); lateral surge (10 % / 5 % of crab + lifted load); worst wheel positions for moment and shear |
| Checks (IS 800:2026) | Compound section properties · Annex E elastic critical moment for monosymmetric sections with wheel load above the shear centre and Table 40 factors · lateral torsional buckling, 15.2.2 with Table 13 · bottom flange bending · biaxial bending of the top flange (vertical + surge) · shear, 15.4 · web bearing under the wheel, 15.7.4 · web buckling under the wheel, 15.7.3.1 · vertical deflection span/500, /750 or /1000 and lateral deflection span/400, Table 6 |
| You enter | I-section and cap channel; crane type; capacity, crab weight, bridge weight, crane span, hook approach, wheel base; gantry span, rail weight and height; LTB length factor; moment diagram for Table 40 |
| You get | Wheel loads with and without impact, surge, factored moments and shear, compound Iz, Iy, Ztop, Zbottom, Mcr, χLT, all design strengths, deflections, the governing check, ADEQUATE / NOT ADEQUATE |
| Not covered | Tandem cranes and more than two wheels per end carriage; longitudinal braking force; fatigue (Section 18); torsion from rail eccentricity; bumper loads; welded plate girders; continuous gantries |
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.
