TAFE NSW coursework

Thermofluid models

Modelled pipeline pressure drop, heat-exchanger energy balance, and vacuum-system energy demand in Excel.

2026 · Excel · Energy balances · Sensitivity analysis

Heat-exchanger outlet temperatures versus mass flow
Heat-exchanger sensitivity at a fixed 500 kW duty

What I did

  • Used Goal Seek for the pipeline flow, Solver for the heat-exchanger flow rates and outlet temperatures, and the analytical isothermal-work equation for the vacuum system.
  • Ran sensitivity cases: pipeline flow rate against pressure drop, heat-exchanger flow rates against outlet temperatures, and the vacuum system’s target pressure against pressure ratio and work.
  • Rebuilt the three models in JavaScript for this page.

Models