+91 70057 36620ilustraca.edu@gmail.com

ILU-800-CN01 Bolt Design (IS 800:2026)

Designs a group of bolts in shear, tension or both, for ordinary (bearing type) and high-strength friction grip bolts, and checks the detailing rules of IS 800:2026.

Use it for Lap and splice joints, bracing and truss end connections, beam-to-column shear connections, brackets with eccentric shear, tension connections through end plates or T-stubs
Bolts Diameters M12 to M36; property classes 4.6, 5.6, 8.8, 10.9; standard, oversize, short slotted and long slotted holes
Checks (IS 800:2026) Hole clearance, Table 20 · minimum spacing 2.5d, 17.2.2 · maximum pitch and spacing, 17.2.3 · minimum and maximum edge / end distance, 17.2.4 · bolt shear with long joint βlj, large grip βlg and packing βpk factors, 17.3.3 · bearing with kb and oversize / slotted hole reduction, 17.3.4 · tension, 17.3.5 · shear + tension, 17.3.6 · slip resistance with μf from Table 21, 17.4.3 · friction bolt tension and slip + tension, 17.4.5 / 17.4.6 · prying force, 17.4.7 · grip length ≤ 8d
You enter Bolt type, diameter, class, hole type, shear planes with and without threads; rows and columns, pitch, gauge, end and edge distance, plate edge type; plate grade, thicknesses, grip and packing; faying surface and number of interfaces (HSFG); end plate thickness, lv, end distance and be (prying); factored shear, its eccentricity, and tension
You get Force on the critical bolt (including eccentric shear by the elastic method), Vdsb, Vdpb, Vdb, Tdb, slip resistance Vdsf, prying force Q, capacity of the whole group, all detailing limits, utilisation ratio of every check with the governing one, ADEQUATE / NOT ADEQUATE, live sketch of your bolt layout
Not covered Block shear and net section of the connected plates (use T01); out-of-plane moment on bolt groups (end-plate moment connections); staggered bolts; anchor bolts in concrete

Good to know: the net shear area at threads is taken as the tensile stress area. Prying uses η = 1.5 and β = 2 for bearing bolts, 1 for pretensioned bolts.

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.

Share this article
Picture of Er. Sandip Deb

Er. Sandip Deb

Founder of Ilustraca Academy and a practising structural engineer in Kolkata. B.Tech (Civil), AMIE, CEng(I), Empanelled Structural Engineer with NKDA & KMC. He teaches RCC and steel design the way design offices work, with every software result checked by hand against the IS codes.

Learn it properly, step by step

Self-paced courses on ETABS, STAAD.Pro, RCDC and IS codes, plus hundreds of free lectures.

error: Content is protected !!
Scroll to Top