Spreadsheet Application in Air Conditioning Design

Beat exchange in an open air-water system is considered. The system incorporates a vertical cooling tower, and a horizontal multi-stage spray chamber with unlimited number of stages. Mixing of two streams of both water and air is permitted. A spread-sheet implementation estimates temperatures of outgoing water and air for given mass flow of water and air, factor of merit for heat exchangers, barometric pressure, wet- and dry-bulb temperatures, and the temperature of incoming water.