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

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

Office spreadsheet icon 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

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

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

File 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:

File poultry_house_air_leakage_calculator.xlsx

Evaporative Cooling Pad Design Spreadsheet - metric

Metric version of the Evaporative Cooling System Design Spreadsheet

File evaporative_cooling_design_spreadsheet_2014_-_metric.xlsx

Pages