Gila County Extension University of Arizona College of Agriculture and Life Sciences


 

"RANGE SPREADSHEETS":

 
 
This spreadsheet (Excel 2000, 2002 format) tracks grazing by Animal Unit Months and grazing class for pastures on the ranch. Items in red (animal class, weight, number of livestock, pasture ID# and name, acres, permitted AUM's by pasture, drought reduction percentage, and days in pasture) are entered in the sheet entitled 2001 AUM Grazing Planner. This worksheet is for operations with four classes of livestock using up to 20 pastures per month. After entering values in the 2001 AUM Grazing Planner worksheet, information automatically feeds into the worksheet entitled 2001 AUM Grazing Report for a summary report. To change the names of the worksheets listed above, double click on the name tab.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
         

 


This spreadsheet is similar to the one described above except that more classes of livestock (7) and less pastures (10) may be tracked each month for AUM's used.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

         
 

range landscape
RANGE MONITORING SPREADSHEETS

This range monitoring spreadsheet (Excel2002 format) contains data forms and computerized summaries of data sheets for range monitoring. The spreadsheet is downloadable as either an Excel spreadsheet (FORAGDTA.XLS, 626 Kb) or in the zipped version of the same (FORAGDTA.zip 129 Kb). Information on the 31 worksheets contained in this spreadsheet file and how to use the worksheets are contained in the accompanying Forage Data Spreadsheets Info. Information on where to obtain monitoring protocols to accompany each monitoring procedure are contained in the article Setting Up a Range Monitoring Program for Your Ranch. http://cals.arizona.edu/gila/animalsciences/documents/reading_range_newsletter.pdf .
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

Jim Sprinkle
Gila County Cooperative Extension

P.O. Box 2844
Payson, Arizona 85547
Phone (928) 474-4160
FAX (928) 468-8289


http://cals.arizona.edu/gila/animalsciences/rangesprdshts.html
Last Reviewed and Updated: April 7, 2006
Extension Webmaster:pleonard@ag.arizona.edu
Phone: (928) 425-7179 ext. 8585
Content Questions/Comments: sprinkle@ag.arizona.edu
Legal Disclaimer