+91 70057 36620ilustraca.edu@gmail.com
IS 800:2026 · SECTION 17 CONNECTIONS

Pack B: Bolt & Weld Pack (IS 800:2026)

Design bolted and welded joints to the new IS 800:2026, with a live sketch of your layout and clause-referenced reports.

₹500 both workbooks · or ₹299 each

After payment you download the .xlsx files instantly, and the download link is also emailed to you. If you do not see the email within a few minutes, check your Spam or Promotions folder and mark it “Not spam”.

What’s inside

ILU-800-CN01Bolt Design

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 & key clauses

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

Key clauses: 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

₹299Buy CN01
Full specs →
ILU-800-CN02Weld Design

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 & key clauses

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

Key clauses: 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

₹299Buy CN02
Full specs →

See your layout

The Input tab draws your bolt pattern or weld group and redraws it as you type: change the rows, pitch, gauge or weld lengths and the sketch follows. A labelled key drawing explains every symbol (p, g, e, edge, lv, s, d, b …), so nobody has to guess what an input means.

The same sketch prints on the one-page Summary report, so the checker sees the layout next to the results.

Why engineers use it

Live results as you type. Every check updates instantly with ADEQUATE / NOT ADEQUATE.
Bearing and HSFG bolts: M12 to M36, classes 4.6 to 10.9, standard, oversize and slotted holes.
The factors people miss: prying, slip, long-joint βlj, large-grip βlg and packing βpk.
The 2026 weld check: combined stress fe = √(fa² + 3q²), plus size limits and long-joint reduction.
Reports ready to submit: one-page Summary with the sketch and a clause-by-clause Detailed report.
Your office on every page: company name, logo, project, revision and issue status (Preliminary to GFC). No macros, no setup.

Which one should I buy?

Buy the full pack if you detail steel connections regularly; buy a single workbook for one type of joint.

If you mostly designBuy
Bolted splices, bracing and truss jointsCN01
HSFG (friction grip) jointsCN01
Welded brackets, cleats, stiffenersCN02
Fabrication drawings with both bolts and weldsFull Pack B
Complete steel buildingsPack A + Pack B

Both workbooks share the same Project tab, report title block and format as Pack A, so a full calculation package looks consistent. Each workbook is self-contained and works without the others.

Before you buy

Requirements: Microsoft Excel 2016 or later on Windows or Mac, including Microsoft 365. Not for Google Sheets, LibreOffice or Excel Online editing (drop-downs, formulas and sketches may not behave).

What is not covered:
  • ILU-800-CN01: 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
  • ILU-800-CN02: Weld groups twisted by eccentric load in their own plane; intermittent welds; the bearing term for butt welds of 17.5.10.2.2
  • Column base plates, end-plate moment connections, fin plates, cleats, splices and gussets are not in this pack; they will come as separate workbooks.

Engineer’s responsibility: these workbooks are design aids. Results must be reviewed by a qualified structural engineer, who remains responsible for the design.

Frequently asked questions

Do I need macros?

No. The workbooks open in Microsoft Excel 2016 or later with no macros, add-ins or internet connection. The live sketch is drawn with ordinary Excel formulas.

Can I put my company logo?

Yes. Reports carry only your office details. Add your logo once to the report header (Page Layout › Print Titles › Header/Footer › Custom Header › Insert Picture).

Is it IS 800:2026 or 2007?

IS 800:2026 (Fourth Revision), limit state method, Section 17, with γmb = 1.25, γmf = 1.25 / 1.10 and γmw = 1.25 shop / 1.50 site from Table 5.

Does it cover HSFG bolts?

Yes. CN01 designs friction grip bolts for slip resistance with μf from Table 21 (17.4.3), friction bolt tension and slip + tension (17.4.5 / 17.4.6) and prying (17.4.7), as well as bearing-type bolts.

Does it check block shear of the plate?

No. Pack B designs the bolts and welds. Block shear and net section of the connected plates are checked in Pack A, ILU-800-T01 Tension Member.

How do I get a PDF report?

File › Print › “Microsoft Print to PDF”. Reports are A4 portrait, and the Summary includes the sketch.

Is it one computer or the whole office?

Each purchase is a personal, non-transferable licence for your own work. See the Terms and Conditions.

How do I receive the files and get support?

You can download the files right after payment, and the download link is emailed to you. If you do not see the email within a few minutes, check your Spam or Promotions folder and mark it “Not spam”. For support, write to ilustraca.tech@gmail.com.

Designing a complete steel building?

Pack A designs the members (sections, columns, beams, beam-columns, ties); Pack B designs the bolts and welds that join them. Same title block, same report format.

Questions? Email ilustraca.tech@gmail.com

Talk to us

Questions about a course, a StructDesk licence, or inviting Er. Sandip Deb for a lecture or workshop? Get in touch.

Phone / WhatsApp+91 70057 36620
Emaililustraca.edu@gmail.com
Message on WhatsApp
error: Content is protected !!
Scroll to Top