Description
This Lifting Lug spreadsheet from 3D-LABS follows ASME standards and gives instant, checkable results for practising engineers — no manual derivation required.
Lifting Lug (Pinned) ASME BTH-1 Calculation
This Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel spreadsheet provides a complete, code-compliant engineering solution.
Engineering Spreadsheet — Instant Download
What This Spreadsheet Does
Designs pinned lifting lugs per ASME BTH-1, the US standard for below-the-hook lifting devices. Used for crane lifts of equipment, skids, vessels, and any rigged lift requiring code-compliant lug design.
What’s Inside the Excel File
- Inputs — lug plate thickness, hole diameter, pin diameter, edge distance, plate width, material grade, design lift load, Design Category and Service Class
- Design factor selection per ASME BTH-1 Category A/B and Service Class 0–4
- Tensile strength at pin hole net section
- Single-plane fracture capacity
- Double-plane shear capacity
- Pin bearing on lug plate
- Weld capacity at lug-to-base connection
Who This Is For
- Mechanical and structural engineers on lifting operations
- EPC project teams specifying crane lifts
- Equipment manufacturers and skid builders
- Rigging engineers and lift planners
Codes & Standards Referenced
- ASME BTH-1 — Design of Below-the-Hook Lifting Devices
How It Works
| 1 | Purchase — secure payment |
| 2 | Download — instant Excel access |
| 3 | Enter Values — lug geometry, pin, load, Category/Class |
| 4 | Get Results — capacity vs. demand for every failure mode |
File Format & Compatibility
Microsoft Excel (.xlsx). Opens in Excel 2016+, Excel 365, Google Sheets. No macros, no locked cells.
What You Get After Payment
- ✅ Instant download (also emailed)
- ✅ Lifetime access
- ✅ Engineer email support
- ✅ 7-day refund if file fails to open
🌍 Trusted by engineers across 50+ countries · 📚 Part of 160+ engineering spreadsheets · 🛠 Support from qualified engineers
Frequently Asked Questions
Design Category and Service Class — which to pick?
Category A for predictable loading, B for less predictable. Service Class 0–4 based on fatigue cycles per BTH-1 Table 2-1.
Pinned and shackle versions?
This sheet is pinned. For shackle-connected lugs, see our Lug from Shackle (Bechtel Method) sheet.
Custom version needed?
Request a custom quote.
Related Spreadsheets
- Lug from Shackle (Bechtel Method)
- Pad Eye Design Calculation
- Padeye Combined Stress (Von Mises)
- Spreader Bar Design
🚀 Ready to download?
Purchase now and get instant access. 📧 info@3d-labs.com | ☎ +91 9843511204 | ☎ +44 7418 355355
What’s Included
An instant Excel download with the complete formula set, a worked numerical example, and reference to the governing standard — ready to adapt to your own project inputs.
Related Calculations
- Spreader Bar Design Calculation — Lifting Beam Excel
- Pad Eye Design Calculation — Lifting Pad Eye Excel
- Skid Lifting Lug Rope-Angle Calculation — Equipment Skid Excel
Download the Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel from 3D-LABS for instant, verifiable results per ASME BTH.
Download the Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel from 3D-LABS for instant, verifiable results per ASME BTH.
What Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel calculates
Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel is an Excel-native engineering calculation tool built by 3D-LABS for mechanical, design, and equipment engineers working with pressure equipment, rotating machinery, and mechanical systems. It is used for sizing pressure vessels, heat exchangers, flanges, bolts, and other mechanical components. Every input is labelled and every output is traceable — the sheet is designed to be checkable, not a black box.
Codes and standards followed
Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel follows industry-standard Mechanical Engineering codes including ASME VIII Div 1 & 2, ASME B16.5, TEMA, API 660, HEI, EN 13445. Each formula is cross-referenced to the applicable code clause so your reviewer can trace calculations back to the standard.
If your project requires a different code base (e.g. converting an IS-code sheet to an ASME basis), we can produce a code-variant edition on request. Contact info@3d-labs.com for a variant quote.
What is included in your download
- The Excel calculation file (.xlsx) — fully unlocked formulas, cell-level comments, and a clear input/output layout.
- A sample worked example — realistic inputs plus expected outputs so you can validate the spreadsheet against a known case.
- User notes (PDF) — assumptions, code clauses referenced, and edge-case guidance.
- Revision history — every update to the spreadsheet is logged so you know what changed and when.
- Email support — reply within 24 hours (Monday to Saturday, IST) for questions about the spreadsheet or its use.
Software requirements
Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel runs in Microsoft Excel 2016 or later on Windows and Mac. It is also compatible with LibreOffice Calc and can be imported into Google Sheets (some formatting may shift). No macros are required and no external add-ins are needed — every calculation runs in cell formulas, which means every step is auditable.
Pricing and delivery
Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel is priced at ₹999 (approximate USD equivalent shown in the cart). Delivery is instant — after payment you get a download link immediately and a receipt by email. One-time purchase, lifetime access, no subscriptions or hidden fees.
Payment methods: Cashfree (Indian customers) or PayPal International (customers outside India). Volume discounts are available on bundles of 5 or more spreadsheets from the same discipline — contact sales@3d-labs.com for a bundle quote.
Related tools and services
Engineers who work with Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel often also need:
- Other Mechanical Engineering spreadsheets from our catalogue of 119 tools in this discipline.
- Our Pressure Vessel Design Services — for projects where the calculation is only part of a larger scope and you want the full engineering deliverable produced by 3D-LABS.
- Our online training courses — instructor-led programmes on Mechanical Engineering topics, including software mastery and code walkthroughs.
- Our engineering e-book library — 115+ technical PDF references covering theory, practice, and code interpretation.
Frequently asked questions
What software do I need to run Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel?
The spreadsheet is delivered as a native Excel (.xlsx) file. It runs in Microsoft Excel 2016 or later on Windows and Mac. It also runs in LibreOffice Calc and Google Sheets (with import), though some formatting may shift. No macros are required — all logic runs in cell formulas so you can audit every step.
Which codes and standards does this spreadsheet follow?
Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel follows ASME VIII Div 1 & 2, ASME B16.5, TEMA, API 660, HEI, EN 13445. Every formula is cross-referenced to the code clause it implements, so your reviewer can trace the calculation back to the standard. If your project needs a different code, contact us — many spreadsheets are available in code-variant editions.
Are the formulas locked or editable?
All formulas are unlocked and editable. You can adapt inputs, add your own load combinations, integrate the sheet into your own workflow, and audit the logic. We do not password-protect our worksheets — an engineer should always be able to verify what the tool is doing.
What is included in the download?
The download includes: (1) the Excel calculation file with all formulas, (2) a sample worked example showing typical inputs and expected outputs, (3) a short user notes PDF explaining assumptions and code clauses used, and (4) a revision history so you can see how the sheet has been updated over time.
Do you offer support if I have questions?
Yes. Email support with any 3D-LABS spreadsheet purchase — reply within 24 hours (Mon-Sat, IST). We also offer paid tuning if you need the spreadsheet adapted to a specific project (typically USD 50-200 depending on scope). Contact info@3d-labs.com for details.
About 3D-LABS engineering spreadsheets
Lifting Lug (Pinned) ASME BTH-1 Calculation — Below-the-Hook Excel is one of 621 engineering calculation spreadsheets in the 3D-LABS catalogue — the largest curated collection of code-compliant Excel calculators for practising engineers anywhere. Each sheet is built and reviewed by 3D-LABS engineers who use them daily on real client projects across pressure vessel design, storage tank design, piping stress analysis, structural engineering, heat exchanger design, and FEA services since 2003.
Browse the full SpreadSheet Calculations catalogue or the Mechanical Engineering calculations sub-category. Volume discounts apply on 5+ spreadsheets from the same discipline.
