How To Monitor Rangeland Resources: Monitoring Residual Dry Matter

Free Companion Worksheets Monitoring rangeland or other vegetation by determining residual dry matter is important for evaluating rangeland health. This series of five Excel spreadsheets provides convenient forms, and performs the necessary calculations for, monitoring resid ual dry matter. The spreadsheets are based on the double sampling method. This is explained, along with other monitoring methods in the publication How To Monitor Rangeland Resources, available from: Rangeland Manual c/o Rhonda Gildersleeve UCCE Inyo-Mono Counties 207 W. South St Bishop, Ca. 93514 (760) 873-7854

The spreadsheets require Excel 5.0 or higher. The program was partially funded by the Renewable Resources Extension Act. If you find errors or have questions kindly notify djdrake@ucdavis.edu


To download a free copy of these worksheets (39 KB) click here:


The worksheet files are provided in a compressed state in the RANGE.EXE file. This executable file decompresses the five spreadsheet files (rdm10_1.xls, rdm10_2.xls, rdm10_3.xls, rdm10_4.xls and rdm10_5.xls):

  1. Create a new directory on your hard drive named C:\RANGE.
  2. Download the RANGE.EXE file and save it in the new C:\RANGE directory.
  3. From Windows File Manager, change directory to the C:\RANGE directory.
  4. Double click on the RANGE.EXE file. This decompresses the files into the C:\RANGE directory.
  5. The five worksheet files are now installed on your system.


  1. From Windows, run Excel 5.0 or higher.
  2. Open the desired file from the subdirectory that you specified (C:\RANGE), usually starting with rdm10_1.xls.
  3. Print spreadsheets as forms for the field and/or enter appropriate data.