Ground Source Heat Pump Design

Keep It Simple & Solid

Several of these programs contain 'macros' which required the
Excel macro security level to be set at Medium.
Instructions for Setting Macro Security level

This suite of simplified HVAC software has been developed by the instructor and students of the HVAC and Energy Conservation courses at The University of Alabama. It attempts to follow basic ASHRAE calculation procedures. The programs are provided at no cost to the public. We welcome comments and suggestions.

• Heat&CoolCost7-10.xls (68 kB download) - Heating, cooling, and water heating energy, demand, cost and carbon dioxide calculator for homes, offices, and schools.
• TideLoad10v1 -  Heating and Cooling Load Calculation Spreadsheet (1140 kB download) - Eight Zones with condensed CLTD/CLF/SCL tables. Includes traditional sensible load calculations plus new latent loads, heat recovery unit adjustments, and duct loss/gain options. New Worksheet for computing ASHRAE Standard 62.1-2004 ventilation air requirements.  Excel Program is unlocked so user can add more zones and expand capabilities if adventuresome.
• E-Ductulator09 (296kB download) is a program for designing air distribution systems and computing losses with the Equal Friction/Equivalent Length method.  New equivalent length tables for rectangular and round duct fittings with friction options for metal duct, spiral duct, duct liners, duct board, and flex duct.  Register, diffuser, and filter (for MERV = 4, 6, 8, 11, and 14) losses also included.

• E-PipeAlator08 (395kB download) is a program for designing water distribution systems and computing losses.  Program handles water and water-glycol mixtures, (temperature corrected) in steel, cast iron, polyethylene, PVC and copper (a new feature) piping.  Equivalent lengths for common fittings automatically entered.  Heat exchanger, valve, and flow control valve losses also considered.  New GSHP piping example calculations and figures have been added.

• PsychProcess09 (136 kB download) is a program for computing the properties (enthalpy, specific volume, humidity ratio, relative humidity, specific heat, and dew point).  It also calculates resulting properties for air mixing, cooling, and heat recovery. Total, sensible, and latent capacities computed for cooling and heat recovery processes.

• FanPumpCalc10 (25 kb download) is a program for calculating the wire-to-air efficiency of fans and wire-to-water efficiency of pumps. The impact of fan and pump power on the capacity and efficiency of cooling systems can also be determined.

• ResLoad08 (475kB download) - A Residential Heating and Cooling Load Calculation program based on the 2001 ASHRAE Handbook of Fundamentals and HVAC Simplified (available from ASHRAE).

• HVACPowDen08a.xls (2.4MB download) is a program for quickly estimating the required capacity and electrical demand of cooling and heating equipment for 30 different building types in the 10 US climate zones.  Results are expressed in cooling tons, Btu/hr-ft², total kW demand, and W/ft².  Program is now integrated with HVACSysEff.xls. Developed as part of an EPA-sponsored Energy Star Buildings project.
• HVACPowDenInstructions 
• Instructions for TideLoad (68 kB download)

• A-AHPCorrect08 (115kb download) is a program to correct the cooling performance of a model line of air-to-air heat pumps for various outdoor air temperatures, indoor temperatures, and indoor air flow rates. Performance correction of other product lines can also be used by entering nominal performance data in a “MfgData” worksheet.

• DuctCostCalc04 (61kB download) - A Spreadsheet to compute the cost of ductwork – Rectangular and Round Metal, Insulation, Duct Board, Flex Duct

• W-AHPCorrect04 (61kB download)- A Program to correct the performance of Water-to-Air heat pumps for various air and water temperature and flows.

• NetLoopCost (17 kB download) - A FREE Spreadsheet to compute the cost of installing and grouting vertical ground loops