UGA Poultry House Environmental Management and Energy Conservation

Sign up for newsletters and announcements

Excel Spreadsheets

2018 Poultry House Moisture Control Spreadsheet

This spreadsheet allows the producer to determine minimum ventilation rates to control house moisture levels. The spreasheet determines the minimum ventilation rate required to remove the amount of moisture the birds are adding to the house based on the inside and outside conditions the user inputs. A target relative humidity of 60% is preset into the spreadsheet. The spreadsheet only determines a minimum ventilation rate to control moisture. The actual minimum ventilation rate to control other air quality variables (i.e, carbon dioxide, ammonia, and carbon monoxide) may need to be high

minimum_ventilation_calculator_2018p.xlsx

Poultry House Lighting Comparision

This spreadsheet allows the user to determine power savings by switching from incandent to fluorescent fixtures.

poultrylighting.xls

Tunnel Air Speed/Static Pressure Estimating Spreadsheet V1.5

To use the spreadsheet simply input basic information about the house in question (i.e., house and pad dimensions), the number of tunnel fans, the theoretical tunnel air moving capacity of the fans at various static pressures (available from BESS Laboratory websitewww.bess.uiuc.edu), and the general condition of the house’s evaporative cooling pads (1 to 5 scale) and fans (1 to 4

tunnel_air_speedstatic_pressure_estimating_spreadsheet_v1.5.xlsx

Pullet House Fan/Light Trap Comparison Worksheet (v5.0 - February 2018)

This excel spreadsheet allows the user to determine how the amount and type of fan/inlet light traps affect the air moving capacity of the exhaust fans and therefore air speed in a light-controlled, tunnel ventilated pullet house. This version lists more currently used light traps
Input:
- Number of fans
- Air moving capacity (cfm) of the fan you want to examine @ static pressures from 0.00" to 0.25"
- Fan condition
- Type and amount of tunnel inlet light trap
- Type and amount of tunnel fan light trap

tunnel_pullet_house_air_speed_and_static_pressure_estimating_spreadsheet_v5.xlsx

2018 Tunnel House Heat Gain Analysis Spreadsheet (v1.2)

Input (english units with metric equivalents displayed):
- house dimensions
- ceiling type (open/dropped)
- side wall type (curtain/solid)
- wall and ceiling R-values
- bird size, number, and heat production
- lighting system details
- maximum expected outside temperature
- maximum desired inside temperature (typically 85 F)
Outputs (english and metric units):
- Total heat gain through each building surface as well as the birds. - graphic.

2018_uga_tunnel_ventilation_workshop_spreadsheets_v_1.2_-_webpage.xlsx

Tunnel Fan Comparison Spreadsheet 2014

This spreadsheet allows the user to compare different tunnel fans: the number required, air speed produced, and yearly electricity usage.

tunnel_fan_comparison_spreadsheet_-_2014.xlsx

Tunnel Fan Comparison Spreadsheet 2014 - Metric

This spreadsheet allows the user to compare different tunnel fans: the number required, air speed produced, and yearly electricity usage.

tunnel_fan_comparison_spreadsheet_-_2014_metric.xlsx

Poultry House Leakage Area Calculator 2018

This spreadsheet allows the user to determine the amount of leakage area a poultry house has by conducting a static pressure test. A static pressure test consists of closing all the openings in a poultry house and then turning on one fan (typically that has an air moving capacity of roughly 0.75 to 1.25 cfm per square foot of floor space) and measuring the resultant level of static pressure achieved.

Inputs:

poultry_house_air_leakage_calculator_2018.xlsx