Designs fillet and butt welds in a weld group under normal force, shear and moment, including the new IS 800:2026 equivalent-stress limit.
| Use it for | Bracket and cleat welds, end plate and base plate welds to columns, stiffener and gusset welds, lap joints, shop and site welds |
|---|---|
| Weld types | Fillet; complete-penetration butt; partial-penetration butt |
| Weld groups | Single line, two parallel lines, all round (rectangle b × d) |
| Checks (IS 800:2026) | Minimum fillet size, Table 22 · effective throat with K from Table 23, 17.5.3 · minimum effective length 4s, 17.5.4 · fillet weld strength fwd = fu/(√3 γmw), 17.5.7.1 · site welds γmw = 1.50, 17.5.7.2 · long joints βlw, 17.5.7.3 · maximum size at square plate edges and rounded toes, 17.5.8 · normal and shear stress, 17.5.9 · combined stress fe = √(fa² + 3q²) ≤ fu/γmw, 17.5.10 |
| You enter | Weld type, shop or site, fillet size, angle between fusion faces, weld metal strength; arrangement and effective lengths d and b, length of joint; parent grade, thinner and thicker part thickness, edge condition; factored N, V and M |
| You get | Throat, weld area and section modulus, fa, q and fe, design strength per mm run, size limits, utilisation ratio of every check with the governing one, the fillet size you need, ADEQUATE / NOT ADEQUATE, live sketch of your weld group |
| Not covered | Weld groups twisted by eccentric load in their own plane; intermittent welds; the bearing term for butt welds of 17.5.10.2.2 |
Know before buying: Pack B designs the bolts and welds. The strength of the connected members and plates (net section, block shear) is checked in Pack A (ILU-800-T01 Tension Member).
Common to both workbooks
- Design code: IS 800:2026 (Fourth Revision), limit state method. Partial safety factors per Table 5: γm0 = 1.10, γmb = 1.25 (bolts), γmf = 1.25 / 1.10 (friction grip, slip at ultimate / service), γmw = 1.25 shop / 1.50 site welds.
- 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 (drop-downs, formulas and sketches may not behave).
- Units: kN, kNm for forces; mm for dimensions; MPa for stresses.
- Steel grades (plates): IS 2062 E250 to E450 (fy reduces with thickness), EN S275 / S355 / S460.
- Live sketch: the Input tab draws your bolt pattern or weld group and redraws it as you type. A labelled key drawing explains every symbol (p, g, e, edge, lv, s, d, b …). The sketch also prints on the Summary report.
- Tabs: Guide, Input (inputs, live results, live sketch, key to symbols), Summary (one-page report with sketch), Detailed (clause-by-clause calculation), Project (report title block).
- Reports: A4 portrait, ready to 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.
