Engineering Calculation Bundle Excel & Google Sheets | Unit Converter Beam Deflection Inertia Calculator Pipe Flow Bolt Group Tolerance

Stop rebuilding the same formulas every project. This 7-module Excel bundle covers the calculations mechanical, structural, and civil engineers actually reach for daily — unit conversions, section properties, beam deflection, eccentric bolt groups, tolerance stack-up, pipe flow, and a 20-material property database. Everything lives in one workbook with color-coded inputs, auto-calculating results, and a linked index tab.

What's inside:
Module 1 — Unit Converter: 48 conversions across length, area, mass, force, pressure, torque, density, and temperature. Type a value, get the answer instantly. No lookup tables, no manual math.

Module 2 — Section Properties Calculator: Rectangular, hollow circular, and custom asymmetric sections. Calculates area, centroidal Ixx/Iyy, section modulus, radius of gyration, polar moment, torsional constant (Roark's approximation), and principal axes via Mohr's circle.

Module 3 — Material Database: 20 engineering materials including aluminum alloys (2014, 2024, 5052, 6061, 7075), structural steels (A36, 4140, 4340), stainless (304/316), Ti-6Al-4V, Inconel 718, polymers, and ceramics. Row-selector lookup pulls E, G, density, Sy, Su, elongation, Poisson's ratio, and CTE. Includes a polynomial Seebeck coefficient model for thermoelectric applications.

Module 4 — Beam Deflection: Five simply-supported load cases (central point load, full UDL, 1/3-point load, two-point loads, triangular UVL). Returns max moment, max deflection, shear force, bending stress, and L/δ ratio — all driven by your span, E, and I inputs.

Module 5 — Eccentric Bolt Group: Elastic method for 6-bolt patterns under combined shear and in-plane moment. Auto-computes centroid, polar inertia Iz, torsional force components for each bolt, total resultant, and flags the critical bolt.

Module 6 — Tolerance Stack-Up: Worst-Case and Root Sum Square (RSS) analysis for 8-component assemblies. Tracks each feature's contribution percentage, and calculates min/max clearance against your nominal gap target. Monte Carlo guidance included.

Module 7 — Pipe Flow: Reynolds number, flow regime detection, and three friction factor methods (Hagen-Poiseuille for laminar, Swamee-Jain explicit, Haaland explicit). Full Darcy-Weisbach pressure drop, head loss, volume flow rate, mass flow rate, and pump power. Crane TP-410 K-value reference table for 14 fittings.

Works in: Microsoft Excel 2016 and newer and Google Sheets. No macros, no VBA, no add-ins required.
You get: 1 XLSX file and Google Sheets template link, instant download.