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.
The Penn State TMR spreadsheet allows the user to create rations, mix sheets, batch size and feed costs for up to nine rations 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 estimates production budgets and costs for corn grain and silage (with dry matter and net energy adjustments) based on tillage practices.
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.