Steam Trap Repair Spreadsheet

This tool was developed by the Gulf Coast Center of Excellence for use on energy assessments and is free to download.

Inputs:

  • Steam trap types
  • Steam trap orifice diameter
  • System pressure
  • Saturated vapor enthalpy
  • Saturated liquid enthalpy
  • Enthalpy of makeup water
  • Percent feedwater from makeup water
  • Combustion efficiency
  • Heating value
  • Cost of steam traps
  • Volumetric fuel cost
  • Labor rate and repair time

Outputs:

  • Annual cost savings
  • Annual energy savings
  • Implementation cost
  • Simple payback period
  • CO2 reduction

Tool preview: