Welcome to the Home Page of:
Michael Galyean
Paul Whitfield Horn Professor
Thornton Distinguished Chair

Department of Animal and Food Sciences
e-mail michael.galyean@ttu.edu

Teaching Responsibilities:

  • AnSc 3307 – Feeds and Feeding
  • AnSc 5311 – Ruminant Nutrition
  • AnSc 5314 – Protein and Energy Metabolism

Research Responsibilities:

  • Burnett Center for Beef Cattle Research and Instruction

Research Areas:

  • Animal health and nutrition interactions
  • Feed intake prediction and management
  • Nutritional effects on growth and carcass merit of beef cattle
  • Metabolic disorders of finishing beef cattle
  • Digestive physiology of ruminants

Free Downloadable Files:

The following files have been developed over the years for a variety of reasons.   They are grouped by category, and a brief description follows each file. Caution! These files are works-in-progress. They have been checked for accuracy, but errors might still exist. As a result, use them at your own risk.
****To save, click on "Download," and use the "Save" option to specify a location.****

   
 

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 trial-and-error formulation. It contains the complete NRC (1996) feed library and provides output of all major nutrients and trace minerals, as well as dietary cation-anion 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 Add-In 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 Add-In 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.

TI-80 Series Calculator NEm and NEg Calculations (neperf.8xp) – This file is programmed in the Texas Instruments Basic language for use on TI-80 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 TI-80 series calculator using TI Connect or TI GRAPH LINK software.

Programmed Gain Calculations (pgm_gain.xls) – This Excel spreadsheet uses the NRC (1996) energy equations to determine the intake needed to achieve a user-defined average daily gain by growing-finishing beef cattle.

Fermentation Balance Calculations (ferm_bal.xls) – This Excel spreadsheet can be used to calculate values for hexose fermented and CO2, CH4, and H2O produced given molar proportions of ruminal VFA.

 

 

 

 

 

  Statistical Aids
Sample Size Calculations I (s_size.xls) – This Excel spreadsheet can be used to determine the sample size needed to detect a difference (specified as a percentage of the control treatment) given the coefficient of variation, a specified significance level, and the power of the test.

Sample Size Calculations II (s_size_II.xls) – This Excel spreadsheet can be used to determine the sample size needed to detect a difference (specified as a unit of measurement) given the error mean square for the measurement, the number of treatments, a specified significance level, and the power of the test.

Random Number Generator (ran_gen.xls) – This Excel spreadsheet will generate up to 10 sequences of up to 100 unique random number integers.

Contrast Calculator (testing_contrasts.xls) – This Excel spreadsheet uses treatment means, the pooled standard error of the means, and the number of observations per treatment to test the significance of user-defined single-degree-of-freedom contrasts.  Completely random or randomized complete block designs with up to six treatments may be evaluated, and the program also checks for orthogonality of the contrasts.

Orthogonal Coefficient Calculator (unequal_orthog.xls) – This Excel spreadsheet can be used to calculate coefficients for orthogonal contrasts for independent variables with up to five levels (e.g., linear, quadratic, cubic, and quartic), regardless or whether the levels are equally or unequally spaced.

Orthogonal Coefficients for Unequally Spaced Treatments (orthog.doc) – This Microsoft Word file describes how to use Proc IML in SAS to calculate coefficients for orthogonal contrasts.  This information can be used in lieu of the Orthogonal Coefficient Calculator when the levels of the independent variable exceed five.  Examples of SAS code and output are included.

 

 

Miscellaneous Programs and Files

Converto-Matic! (convert.xls) – This Excel spreadsheet provides a convenient means of performing 65 different Metric-English and English-Metric conversions (length, area, volume, mass, concentration, energy, temperature, and pressure).

Breakeven Calculator (b_even.xls) – This Excel spreadsheet can be used to calculate a simple breakeven analysis for feedlot cattle.

Beta-Agonist Value Calculator (beta-agonist calc.xls) – This Excel spreadsheet can be used to compare Optaflexx and Zilmax to non-treated controls, with profit-loss projections based on either live- or grid-based sales.
Implant Value Calculator (implant calc.xls) – This Excel spreadsheet can be used to compare single implant and re-implant programs to non-treated controls, with profit-loss projections based on either live- or grid-based sales.

Laboratory Procedures in Animal Nutrition Research (lab_man.pdf) – This is an Adobe Acrobat (pdf) file of a laboratory manual originally developed for use at New Mexico State University. The manual was updated in 1997 for use at West Texas A&M University.  You will need to use the Adobe Acrobat Reader to view and print this file.

 

Last Modified: 05/15/09