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.

• 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 
• E-Ductulator06 (282kB 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.

• PsychProcess06 (133 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.

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

• TideLoad06B -  Heating and Cooling Load Calculation Spreadsheet (674 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.

• Instructions for TideLoad06B(68 kB download)

• HVACSysEff06 is a program to compute the net system efficiency of HVAC systems.  Includes consideration of auxiliary demand and heat penalty.

• A-AHPCorrect07 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.

• BAMALOAD (3.27 MB download) - A Cooling & Heating Load Calculation Program with sensible, latent, & total loads. Based on CTLD/CLF Method. Output at maximum dry bulb, maximum wet bulb, and for all bin temperature at 30 locations. Developed by Sanjay Mahapatra, MSME.

• Psychrometrics (44 kB download) - A FREE program developed by Lan Xie 

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

• R-Value and U-Value Calculator and Table (46 kB download)

• Attic Duct Heat Loss and Heat Gain Calculator (25 kB download)

 

GeoKISS Home