Templates

Engineering spreadsheet templates

Calculation sheets that show their working. Each engineering template keeps inputs, formulas and results on the page, so you can check every step, swap in your own numbers and hand the file to a colleague who can follow it. The formulas come from standard references (Euler-Bernoulli beam theory, the Darcy-Weisbach equation, worst-case and root-sum-square stack-ups), and every template carries a notes tab that states its assumptions and limits.

They are working tools, not a substitute for professional review: verify results against the codes and standards that apply to your project.

TemplateEngineering

Beam deflection and bending calculator

Deflection, bending moment, shear and stress for simply supported and cantilever beams under point and uniform loads.

4 tabs · 183 formulas

TemplateEngineering

Bill of materials with cost roll-up

Multi-level bill of materials with extended quantities, supplier prices and cost roll-up by sub-assembly.

4 tabs · 366 formulas

TemplateEngineering

Electrical energy and cost calculator

Estimate daily and monthly energy use from appliance input power, operating hours, days, and an entered tariff.

2 tabs · 246 formulas

TemplateEngineering

Electrical panel load schedule

A 42-circuit 208Y/120 V panel schedule with phase totals, NEC 220.44 receptacle demand and current.

3 tabs · 213 formulas

TemplateEngineering

Linear thermal expansion calculator

Estimate length change from original length, temperature change, and a supplied linear expansion coefficient.

2 tabs · 246 formulas

TemplateEngineering

Pump hydraulic power calculator

Estimate hydraulic and electrical input power from flow, total head, fluid density, and combined efficiency.

2 tabs · 186 formulas

TemplateEngineering

Sensible airflow heat load calculator

Calculate air mass flow rate and sensible heating or cooling load in kilowatts from volumetric airflow and air temperatures.

2 tabs · 246 formulas

TemplateEngineering

Single-phase voltage drop calculator

Estimate two-wire loop resistance, voltage drop, percentage drop, and load voltage from current, one-way distance, and conductor resistance.

2 tabs · 306 formulas