Application of Alternative Floor Space Prediction Equations using Microsoft Excel®

Authors

J. R. Flohr, Kansas State University, ManhattanFollow
M. D. Tokach, Kansas State University, ManhattanFollow
S. S. Dritz, Kansas State University, ManhattanFollow
J. C. Woodworth, Kansas State University, ManhattanFollow
J. M. DeRouchey, Kansas State University, ManhattanFollow
R. D. Goodband, Kansas State University, ManhattanFollow

Keywords

finishing pigs, floor space, prediction equations

Abstract

The following information is related to the use of a spreadsheet tool designed to estimate the growth rate of finishing pigs provided varying floor space allowances. The spreadsheet is broken into four sections: 1) the adjustment observation section, 2) the estimate input section, 3) the database range information, and 4) the predicted performance output. Sections 1 and 2 allow users to input information to adjust the prediction equations to specific herd growth rates as well as information needed to calculate the growth rate estimates for different floor space allowances. This tool allows producers to utilize the prediction equations without having to convert standard to metric units and provides a simple output that is easy to evaluate and use as compared to the more complex prediction equations themselves. Three examples are included to show users the possible value of the spreadsheet tool. It is important for users to understand the potential pitfalls associated with inputting information into the spreadsheet and formatting “flags” that warn users of potential problems in the input information.

Recommended Citation

Flohr, J. R.; Tokach, M. D.; Dritz, S. S.; Woodworth, J. C.; DeRouchey, J. M.; and Goodband, R. D. (2015) "Application of Alternative Floor Space Prediction Equations using Microsoft Excel®," Kansas Agricultural Experiment Station Research Reports: Vol. 1: Iss. 7. https://doi.org/10.4148/2378-5977.1145