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.


Supplements

Supplement 1: Data Quality Pedigree Calculator.
Ecological Archives A010-006-S1.

Authors
File list
Description

Copyright


Authors

Erle C. Ellis
Department of Environmental Studies
Center for Agroecology and Sustainable Food Systems
University of California
Santa Cruz, CA 95064

Li Ronggang
Rural Energy and Environmental Protection Office
The Jiangsu Department of Agriculture and Forestry
34 North Zhongshan Road
Nanjing, Jiangsu, 210009 P.R. China

Yang Linzhang
Department of Soil Ecology
Institute of Soil Science
P.O. Box No. 821
71 East Beijing Road
Nanjing, Jiangsu 210008 P.R. China

Cheng 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


File List


Description

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.



ESA Publications | Ecological Archives | Permissions | Citation | Contacts