Engineering Excel Calculation Sheets & Templates

Complete cable sizing worksheet evaluating continuous load ampacity, ambient temperature and grouping derating factors, short-circuit withstand capacity, and running voltage drop.

Calculation sheet for incident energy (cal/cm²), arc flash boundary, working distance, arcing current variation, and PPE safety category selection for switchgear and MCCs.

Spreadsheet for feeder and branch circuit voltage drop calculations across AC single/three-phase systems, power factor angle analysis, and maximum route length checks.

Substation transformer capacity worksheet accounting for continuous kVA demand, motor starting inrush voltage dip, harmonic derating (K-factor), and prospective fault level.

Ground grid conductor sizing, mesh voltage, touch and step potential limits, surface crushed-rock layer reduction factors, and total grid resistance calculation sheet.

Symmetrical and asymmetrical three-phase, line-to-ground, and line-to-line prospective short circuit calculations with system X/R ratio and breaking capacity evaluation.

Standard flow coefficient sizing for liquid, gas, and steam control valves. Includes choked flow, Reynolds number viscosity correction, and aerodynamic sound pressure checks.

Incipient and choked cavitation analysis, pressure recovery factor (FL), Sigma index verification, and flashing prevention worksheet for severe service process valves.

Differential pressure flow calibration template converting square root transmitter 4-20mA signals to volumetric/mass flow rates across custom process spans.

Pt100 and Pt1000 temperature measurement error estimation, lead wire resistance compensation for 2/3/4-wire bridges, and self-heating error calculation.

Relief valve required orifice area worksheet for gas/vapor, steam, and liquid overpressure relief scenarios with backpressure and overpressure derating corrections.

System head loss template calculating static head, piping friction losses (Darcy-Weisbach / Hazen-Williams), fitting equivalent lengths, and Net Positive Suction Head (NPSHa).

Saturated and superheated steam thermodynamic properties lookup worksheet for enthalpy, entropy, specific volume, and latent heat across wide pressure/temperature ranges.

Horizontal and vertical cylindrical vessel liquid volume strapping chart calculating wetted area, dished head partial volumes (2:1 ellipsoidal, torispherical, hemispherical).