Excel Spreadsheet Tools
The Batch Mix spreadsheet was designed to provide a simple method of adjusting the amount fed as the dry matter of forages changes. Instructions for using the spreadsheet are described in this article.
The Batch Mix spreadsheet was designed to provide a simple method of adjusting the amount fed as the dry matter of forages changes. This spreadsheet also contains instructions for determining forage dry matter using a microwave. Users can enter ration ingredients for up to 4 different rations, then adjust forage dry matter or number of cows in the group and print an updated feed sheet.
Instructions for using the TMR Mix Sheet spreadsheet to assist in accurately mixing total mixed rations (TMR). The spreadsheet allows users to enter nine rations for various animal groups and print mix sheets according to cow number, batch size, or percent of mix.
Accurately mixing total mixed rations (TMR) is essential if animal groups are to receive what the nutritionist has formulated. The Penn State TMR spreadsheet allows the user to enter nine rations for various animal groups. Mix sheets can be printed according to cow number, batch size, or percent of mix, and feed costs can be calculated for the whole herd.
Instructions for using the Enterprise Budget to develop production budgets, breakeven returns, and pricing for corn grain and silage.
This Excel spreadsheet allows users to calculate production budgets for corn grain and corn silage based on tillage practices. That information is then used to determine breakeven prices for dry and high moisture corn grain, and corn silage. Corn silage pricing can be adjusted for dry matter and net energy, the quality parameters that have the greatest impact on dairy cattle performance.
The Nitrate Calculator automates the calculation of nitrate intake from feed and water sources, includes a suggestions for ration adjustments to limit nitrate intake, and provides assistance in converting between various expressions of nitrate concentration.