Erle C. Ellis, Rong Gang Li, Lin Zhang Yang and Xu Cheng. 2000. Long-term Change in Village-Scale Ecosystems in China Using Landscape and Statistical Methods. Ecological Applications 10:1057-1073.
Supplement 1: Data Quality Pedigree Calculator.
Ecological Archives A010-006-S1.
Erle C. Ellis
Department of Environmental Studies
Center for Agroecology and Sustainable Food Systems
University of California
Santa Cruz, CA 95064Li Ronggang
Rural Energy and Environmental Protection Office
The Jiangsu Department of Agriculture and Forestry
34 North Zhongshan Road
Nanjing, Jiangsu, 210009 P.R. ChinaYang Linzhang
Department of Soil Ecology
Institute of Soil Science
P.O. Box No. 821
71 East Beijing Road
Nanjing, Jiangsu 210008 P.R. ChinaCheng Xu
Department of Agronomy & Agroecology
China Agricultural University
Beijing, 100094 P.R. China
For all correspondence:
Erle C. Ellis
Department of Environmental Studies
Center for Agroecology and Sustainable Food Systems
University of California
Santa Cruz, CA 95064
email: ece@umbc.edu
This supplement contains a Microsoft Excel® 97 for Windows® workbook file, pedigree.xls, that supports the calculation of data quality pedigrees using the Microsoft Excel Visual Basic program referenced in Ellis et al. (2000). This file includes the pedigree calculation program, and can be used to enter and calculate pedigrees for variables in standardized worksheets. The file also includes an interactive demonstration using example worksheets to demonstrate the use of the pedigree calculation program and a blank standardized worksheet for entering and calculating pedigrees of one's own. An html document, pedigree_manual, provides a manual for the use of the pedigree calculation program and demonstration worksheets in pedigree.xls. We recommend printing the manual before using pedigree.xls so that it can be used while pedigree.xls occupies the entire computer screen. Additional notes on the algorithms used by the pedigree calculation program in pedigree.xls are provided in an html document, pedigree_notes.
The pedigree.xls file is designed to run on computers with MS Windows® 95, 98, NT 4.0 or higher, and Excel 97, 2000, or higher. It should also run on Macintosh® computers with Microsoft Excel 98, but this has not been tested. The demonstration works best on computers with screen settings of 1024 × 768 or greater and color is required. When opening pedigree.xls in Excel, make sure to enable macros if queried about this. To calculate variables using probability distributions (PDFs) and Monte Carlo simulation, @RISK® software for Excel (Palisade Corporation) must be installed. However, this demonstration assumes that @RISK is not installed, and that variables will be represented by their mean values.