


Diet Formulation
and Net Energy Programs 

TTU Diet Formulation Spreadsheet
(ttu_diet.xls) – This ExcelÒ spreadsheet, which allows up to 40 feeds to be used, also is based on the
principle of trialanderror formulation. It contains the complete NRC (1996) feed library
and provides output of all major nutrients and trace minerals, as well as dietary
cationanion balance. Recent modifications include the ability to archive and retrieve up
to 50 formulations within the spreadsheet. 

TTU
Supplement Formulation Spreadsheet
(supp_form.xls) –
This ExcelÒ spreadsheet allows the user to input concentrations of major
minerals and salt, trace minerals, vitamins, and selected feed additives
that are desired in a supplement. Given the percent that the supplement
makes up of the final diet, the program calculates the percentages of
various ingredients needed to meet the specifications. Modest help screens
are available throughout the program. Recent modifications include the
ability to archive and retrieve up to 50 formulations within the
spreadsheet. 

Diet Solver (diet_solv.xls)
– This ExcelÒ spreadsheet uses the Solver AddIn to calculate a diet based on nutrient
specifications and ingredient constraints provided by the user. The program will
accommodate up to five fixed feed ingredients and seven variable feed ingredients, from
which the program selects to calculate the diet. The Solver AddIn must be installed
with ExcelÒ for this program to run properly. Do not attempt to run this file from the
browser. The file must be downloaded and saved to a drive for it to run properly.
NOTE  This is truly a Beta version. 

NEm and NEg Calculations
(ne.xls) – This ExcelÒ spreadsheet uses a generalized quadratic solution to determine dietary NEm
and NEg values based on intake and performance by cattle, using the NRC (1996) equations. 

TI80 Series
Calculator NEm and NEg Calculations
(neperf.8xp) –
This file is programmed in the
Texas Instruments Basic language for use on TI80 series calculators.
It uses a generalized quadratic solution to determine dietary NEm
and NEg values based on intake and performance by cattle, using the NRC (1996) equations.
Note that target endpoints are limited to Choice and Select. If
Standard is desired as an endpoint, use the
ExcelÒ spreadsheet (ne.xls) described above. Once downloaded to
a computer, this file can be transferred to a TI80 series calculator using
TI Connect or TI GRAPH LINK software. 

SASBased NEm and NEg
Calculations
(necalc.docx) –
This SAS code uses a
generalized quadratic solution to determine dietary NEm and NEg values based
on intake and performance by cattle, using the NRC (1996) equations.
Results are the same as for the Excel spreadsheets described above, but
using SAS allows multiple entries to be analyzed at the same time and output
data sets to be transferred to other SAS procedures. 

Programmed Gain Calculations
(pgm_gain.xls) – This ExcelÒ spreadsheet uses the NRC (1996) energy
equations
to determine the intake needed to achieve a userdefined average daily gain
by growingfinishing beef cattle. 

Fermentation Balance
Calculations
(ferm_bal.xls) –
This ExcelÒ spreadsheet can be used to calculate values for hexose
fermented and CO_{2}, CH_{4}, and H_{2}O produced
given molar proportions of ruminal VFA. 