Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
190x Filetype XLSX File size 0.31 MB Source: winrock.org
Sheet 1: Intro
| Winrock's CDM A/R Sample Plot Calculator Spreadsheet Tool | ||||||||||||
| Walker, S.M., Pearson, T., Brown, S. 2007, 2014 Version | ||||||||||||
| This spreadsheet tool calculates the number of sample plots needed to estimate terrestrial carbon stocks, based on a specified targeted precision. It can be used for both baseline and monitoring measurements. This tool is appropriate for use in afforestation/reforestation projects with defined strata and stratum areas. | ||||||||||||
| This tool also assists the user to estimate the financial and time resources that will be required to complete the field measurements. | ||||||||||||
| This file applies the equations in: CDM A/R Methodological Tool "Calculation of the number of sample plots for measurements within A/R CDM project activities" Version 2.1.0 | ||||||||||||
| http://cdm.unfccc.int/methodologies/ARmethodologies/tools/ar-am-tool-03-v2.1.0.pdf | ||||||||||||
| Please follow the steps delineated in this tool when using this spreadsheet tool | ||||||||||||
| This spreadsheet tool can be used as a companion to: | ||||||||||||
| Sourcebook for Land Use, Land Use Change, and Forestry Projectsa | ||||||||||||
| Please reference the above manual for methods to obtain information required for calculations in this spreadsheet tool. This manual along with others can be found at: www.winrock.org | ||||||||||||
| If you have obtained this file 'unlocked', e.g. cells other than red bordered cells can be selected, do not use this file as changes in formulas may have inadvertently occurred. The most recent version of this file can be downloaded for free at: | ||||||||||||
| http://www.winrock.org/resources/winrock-sample-plot-calculator | ||||||||||||
| Submit questions or comments to carbonservices@winrock.org | ||||||||||||
| a. Pearson, T., Walker, S.M., Brown, S., 2006 Sourcebook for Land Use, Land Use Change, and Forestry Projects. BioCarbonFund, Winrock International | ||||||||||||
| CDM A/R Methodological Tool | ||||||||||||||||||||||||||||||||
| "Calculation of the number of sample plots for measurements within A/R CDM project activities" | ||||||||||||||||||||||||||||||||
| Biomass stocks | ||||||||||||||||||||||||||||||||
| Enter values into the white/red border cells. Use the "Tab" or "Enter" key to jump to the next white/red border cell. If less than 20 stratum exist, leave cells blank. | ||||||||||||||||||||||||||||||||
| STEP 1 Input level of acceptable error and confidence level | ||||||||||||||||||||||||||||||||
| REQUIRED ERROR AND CONFIDENCE LEVEL | ||||||||||||||||||||||||||||||||
| Level of error (%) | 10.0% | from CDM tool: "A default value of 10% may be used unless a different value is prescribed in a methodology" | ||||||||||||||||||||||||||||||
| Confidence level | 90% | Allowable entries: 80%, 90%, 95%, 98%, 99%. | ||||||||||||||||||||||||||||||
| from CDM tool: "Use the 90% confidence level for determination of biomass stock in A/R CDM project activities, | ||||||||||||||||||||||||||||||||
| unless a different confidence level is prescribed in a methodology" | ||||||||||||||||||||||||||||||||
| #NAME? | ||||||||||||||||||||||||||||||||
| warning: data for at least one stratum must be included | ||||||||||||||||||||||||||||||||
| STEP 2 Input Stratum information | STEP 3 Intermediate Results Calculations completed automatically |
STEP 4 - Results Total number of plots and number of plots per stratum. Calculated using correct equation, based on 'sampling fraction'. Results rounded into an integer |
STEP 5 - Final estimate of plots NOTE: This step is NOT included in the CDM A/R Methodological tool |
|||||||||||||||||||||||||||||
| Intermediate Calculations | Equation 3 | Equation 2 | Calculated sampling fraction size: | The CDM tool presents the required number of plots based on specific targeted precision. However, it is advisable additional plots be installed as a precaution. Actual conditions may vary from those found in preliminary data. | ||||||||||||||||||||||||||||
| Sampling Characteristics of each stratum | Intermediate Calculations | Stratum | Stratum Name | Equation 1 | Equation 1 | Sampling faction (large = area sampled >5% of project area, small = area sampled <5% of project area) |
Use only if have Large Sampling Fraction (>5%) | OR | Use only if have Small Sampling Fraction (<5%) | Stratum | Stratum Name | Small fraction (Equation 2 used) |
Percent additional plots: | 10% | It is recommended that at least 10-20% more plots be installed than CDM tool equations calculate | |||||||||||||||||
| Stratum | Stratum Name | Area (ha) |
Mean Biomass | Standard Deviation | Plot size | Plot Quantity (n) First Iteration |
Plot Quantity (n) Second Iteration (if n<30) |
Sampling Area (ha) | Plot quantity (n) adjusted for large sampling fraction | Plot quantity (n) simplified for small sampling fraction | Plot quantity (n) simplified for small sampling fraction | Stratum | Stratum Name | Final plot quantity (n) | ||||||||||||||||||
| (t dry matter ha-1) | (t dry matter ha-1) | (ha) | Ni | wi | wi * si | wi * si2 | Total Sample Size | 0.000% | Total Sample Size | #VALUE! | Total Sample Size | |||||||||||||||||||||
| stratum 1 | stratum 1 | stratum 1 | stratum 1 | |||||||||||||||||||||||||||||
| stratum 2 | stratum 2 | stratum 2 | stratum 2 | |||||||||||||||||||||||||||||
| stratum 3 | stratum 3 | stratum 3 | stratum 3 | |||||||||||||||||||||||||||||
| stratum 4 | stratum 4 | stratum 4 | stratum 4 | |||||||||||||||||||||||||||||
| stratum 5 | stratum 5 | stratum 5 | stratum 5 | |||||||||||||||||||||||||||||
| stratum 6 | stratum 6 | stratum 6 | stratum 6 | |||||||||||||||||||||||||||||
| stratum 7 | stratum 7 | stratum 7 | stratum 7 | |||||||||||||||||||||||||||||
| stratum 8 | stratum 8 | stratum 8 | stratum 8 | |||||||||||||||||||||||||||||
| stratum 9 | stratum 9 | stratum 9 | stratum 9 | |||||||||||||||||||||||||||||
| stratum 10 | stratum 10 | stratum 10 | stratum 10 | |||||||||||||||||||||||||||||
| stratum 11 | stratum 11 | stratum 11 | stratum 11 | |||||||||||||||||||||||||||||
| stratum 12 | stratum 12 | stratum 12 | stratum 12 | |||||||||||||||||||||||||||||
| stratum 13 | stratum 13 | stratum 13 | stratum 13 | |||||||||||||||||||||||||||||
| stratum 14 | stratum 14 | stratum 14 | stratum 14 | |||||||||||||||||||||||||||||
| stratum 15 | stratum 15 | stratum 15 | stratum 15 | |||||||||||||||||||||||||||||
| stratum 16 | stratum 16 | stratum 16 | stratum 16 | |||||||||||||||||||||||||||||
| stratum 17 | stratum 17 | stratum 17 | stratum 17 | |||||||||||||||||||||||||||||
| stratum 18 | stratum 18 | stratum 18 | stratum 18 | |||||||||||||||||||||||||||||
| stratum 19 | stratum 19 | stratum 19 | stratum 19 | |||||||||||||||||||||||||||||
| stratum 20 | stratum 20 | stratum 20 | stratum 20 | |||||||||||||||||||||||||||||
| INTERMEDIATE CALCULATIONS | CDM A/R Methodological Tool | |||||||||||||||||||||||||||||||
| Sample statistic tval (infinite degrees of freedom) | 1.65 | "Calculation of the number of sample plots for measurements within A/R CDM project activites" | ||||||||||||||||||||||||||||||
| Sample statistic tval (degrees of freedom=n-1) | #VALUE! | only used where 1st iteration n<30 | ||||||||||||||||||||||||||||||
| N = sum Ni | 0.00 | |||||||||||||||||||||||||||||||
| Total Area | 0.00 | hectares | ||||||||||||||||||||||||||||||
| Weighted Mean t dry matter /ha | 0.00 | tonnes d.m. ha-1 | ||||||||||||||||||||||||||||||
| Weighted Plot Size | 0.00 | ha | ||||||||||||||||||||||||||||||
| Weighted SD | #DIV/0! | tonnes d.m. ha-1 | ||||||||||||||||||||||||||||||
| n = Number of sample plots required for estimation of biomass stocks within project boundary | ||||||||||||||||||||||||||||||||
| na=Adjusted number of sample plots required for estimation of biomass stocks within the project boundary; dimensionless | ||||||||||||||||||||||||||||||||
| ni = Number of sample plots allocated to stratum i | ||||||||||||||||||||||||||||||||
| N = Total number of possible sample plots within the project boundary | ||||||||||||||||||||||||||||||||
| tval = Two-sided Student's t-value, at infinite degrees of freedom, for the required confidence level | ||||||||||||||||||||||||||||||||
| wi = Relative weight of the area of stratum I (i.e. the area of stratum i divided by project area) | ||||||||||||||||||||||||||||||||
| si = Estimated standard deviation of biomass stock in stratum i | ||||||||||||||||||||||||||||||||
| Copyright 2014 © | E = Acceptable margin of error (i.e. one-half the confidence interval) in estimation of biomass stock | |||||||||||||||||||||||||||||||
| Please do not alter excel file without permission from Winrock International: | within project boundary | |||||||||||||||||||||||||||||||
| www.winrock.org | Calculated by multiplying the mean biomass stock by the desired precision (i.e. mean biomass stock * 0.1 (for 10 % precision) or 0.2 (for 20 % precision) | |||||||||||||||||||||||||||||||
| CarbonServices@winrock.org | ||||||||||||||||||||||||||||||||
no reviews yet
Please Login to review.
