UGA Poultry House Environmental Management and Energy Conservation

Sign up for newsletters and announcements

Excel Spreadsheets

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.2

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.2.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

2014 Tunnel House Heat Gain Analysis Spreadsheet - Metric

Input:
- house dimensions
- ceiling type (open/dropped)
- side wall type (curtain/solid)
- wall and ceiling R-values
- bird size, number, and heat production (Watts per kg)
- lighting system details
- maximum expected outside temperature
- maximum desired inside temperature (typically 30 C)
Outputs:
- Total heat gain through each building surface as well as the birds. - graphic.
- Breakdown in percentages of various heat sources in the house - pic echart

uga_tunnel-ventilated_poultry_house_heat_gain_analysis_2014_-_metric.xlsx

2014 Tunnel House Heat Gain Analysis Spreadsheet

Input:
- house dimensions
- ceiling type (open/dropped)
- side wall type (curtain/solid)
- wall and ceiling R-values
- bird size, number, and heat production (Btu's/hr per lb)
- lighting system details
- maximum expected outside temperature
- maximum desired inside temperature (typically 85 F)
Outputs:
- Total heat gain through each building surface as well as the birds. - graphic.
- Breakdown in percentages of various heat sources in the house - pic echart

tunnel_-_air_exchange.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 2014

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.xlsx