Principles of Balancing Swine Rations
![]()
|
Instructions
This simple spreadsheet allows you to enter inclusion rates and prices for ingredients for a
swine ration. It then calculates, based on inclusion rates, the composition of the ration,
which can be compared with the requirement. Requirements are based on NRC (1998) for diets
containing 3,265 kcal ME/kg of diet.
First select the swine produciton stage for which the diet is being designed by clicking
the poper radio button at the bottom of the sheet. Change inclusion rates until the diet
has the required nutrient composition. Try different ingredients and check prices to formulate
cheaper rations. Make sure to check Table 5 in PIH-7 for maximum recommended ingredient
inclusion rates.
The spreadsheet was created in Excel© 8.0 '00 but can be opened with version 7.0 '97.
This is not a least-cost formulation program. Do not add or delete rows or columns as it
will cause improper future calculations. To add different ingredients, simply change the
names and corresponding nutrient values of existing ingredients.
To download a copy (Excel© 8.0 '97 or higher required to run it):
Questions, comments, or for additional information
e-mail Dr. Todd See or phone him at 919-515-8797
Swine Ration Calculator Spreadsheet (48.5 kb)
Return to MARK Home Page
Number of accesses since July 31, 2000: