Mechanical
Excel calculators · 51-page guide

Mechanical Engineer's Calculator Kit

Nine working calculators for piping, vessels, pumps, expansion, supports and bolting, with a guide that works every example by hand.

Instant download · Secure checkout with Payhip · Single-user licence

9 calculators51 page guide21 diagrams
Cover of Mechanical Engineer's Calculator Kit
Look inside

See the real pages before you buy.

9 pages and screens from the product itself. Click any page to read it at full size.

What you get

In the download.

Every file, ready to use.

Mechanical Engineering Calculators (Excel)

Pipe wall and MAWP with schedule selection, vessel shell and heads, hydrotest, pressure drop, pump sizing with NPSH, thermal expansion and loops, support span, bolt torque and a unit converter.

Calculator guide (PDF)

51 pages: plain-English theory, diagrams, a hand-worked example for every calculator, common mistakes, limits and practice problems.

Contents

Everything that is inside.

The full table of contents, so you know exactly what you are buying.

Pipe wall thickness and MAWP6
  1. Hoop stress: the starting point
  2. The B31.3 formula and the Y coefficient
  3. From pressure thickness to the wall you buy
  4. NPS, outside diameter and schedule
  5. Working back to MAWP
  6. Practice problems
Pressure vessel shell and heads6
  1. Stresses in a cylinder and a sphere
  2. The published formulas
  3. Head shapes
  4. Allowances and plate selection
  5. Static head and the quoted MAWP
  6. Practice problems
Hydrostatic test pressure5
  1. The general formula
  2. Static head: high point and low point
  3. Stress check during the test
  4. Gauges, volumes and practical points
  5. Practice problems
Pipe pressure drop6
  1. Velocity and Reynolds number
  2. Darcy-Weisbach
  3. Friction factor
  4. Fittings and valves: the K method
  5. Elevation and total pressure drop
  6. Practice problems
Pump sizing: head, power and NPSH5
  1. Total dynamic head
  2. Pump curve, system curve and duty point
  3. Power and motor size
  4. NPSH: will it cavitate?
  5. Practice problems
Thermal expansion and loop sizing5
  1. Free expansion
  2. The guided cantilever
  3. L-bends and expansion loops
  4. Which stress to use
  5. Practice problems
Pipe support span4
  1. The load
  2. Beam models
  3. The two limits
  4. Practice problems
Bolt load and tightening torque5
  1. How the joint works
  2. Tensile stress area
  3. Target stress and the torque equation
  4. Tightening passes and pattern
  5. Practice problems
Who it is for

Made for working mechanical engineers.

Questions

Before you buy.

What format is it?

Digital files: PDF guides, and Excel, Word or PowerPoint files where the product includes them. You get a download link straight after checkout, and by email.

Can I use it at work?

Yes. The single-user licence covers your own work, including on your employer's and your clients' projects. For a team licence, contact us through the Payhip store.

Which software do I need?

A PDF reader, and Microsoft Excel 2016 or later (or Microsoft 365) for the spreadsheets. Word files open in Word or any compatible editor.

Is the sample data real?

No. All sample projects, names, dates and figures are fictitious and are there to show how each file works.

Can I use the results for design?

The calculators are for preliminary and screening work. Results must be checked by a competent engineer to the current code edition.

You may also need

Related products.

Template kitNew

Mechanical Completion Kit

The construction-to-handover process step by step, with nine editable forms and an Excel completions tracker with a live dashboard.

$39Look inside →
Exam prepNew

API 570 Exam Prep

A complete study system for the API 570 piping inspector exam: a 144-page plain-English guide, 42 worked calculations, 320 original questions with explanations, two mock exams and an Excel calculator.

$39Look inside →
GuideNew

Piping QA/QC Guide

From isometric to handover: what a piping QA/QC inspector checks at every stage, with a test pack and line tracker.

$29Look inside →
Mechanical Engineer's Calculator Kit

Ready when you are.

$35 Mechanical Engineer's Calculator KitBuy now