Annex 2 — Calculation tables

Every table of this appendix is read from one workbook, which can be downloaded here; each sheet holds one table, its name is given in the table’s caption, and the sheet Contents lists them all.

⬇ Download PB_calculation_tables.xlsx

Historic control regression

Table 9: Regression of the weighted control stocking index on year over the retained years of the historic period, to and including t = 0 (2018) (workbook sheet A_historic_regression).

Ex-post performance benchmark

Table 10: Slopes, standard errors, test statistic and benchmark for each monitoring year, cumulative from t = 0 (2018) (workbook sheet B_expost_benchmark).

Ex-ante stocking index by management stream

Table 11: Ex-ante stocking index series derived from the biomass-to-index regression, by management stream, with the control series and the annual increments (workbook sheet C_exante_si).

Ex-ante performance benchmark

Table 12: The ex-ante benchmark over the crediting period (workbook sheet D_exante_benchmark).

Note on the control series of this table. The ex-ante control stocking index is constant over the crediting period (Table 11): the historic control slope is negative, so the control is projected at its 2019 value with no increment. The ordinary least-squares regression of a constant series has a slope of exactly zero and a standard error of zero, for which the statistics library used returns undefined values; the ex-ante script assigns instead the exact values for a flat line: slope 0, standard error 0 and p-value 1. The table is computed on the series of Table 11 as it stands. The previous edition of this table was computed on a control series entered as −0.35 at t = 1 and −0.345 thereafter, with the Acacia to Pine biomass rounded to whole numbers; on the series as it stands the PBt is the same in every year for both management streams.

PBt for Acacia to Eucalyptus is 0 at t = 52 and t = 54, by the rule; the previous edition left these two cells blank. No removals occur in either year.

Biomass and stocking index observations

Table 13: The paired aboveground biomass and stocking index observations from which the biomass-to-index relationship is estimated (workbook sheet E_biomass_si).

Remote sensing datasets and time stamps

Table 14: The annual composites from which the stocking index was derived, as required by VM0047, Section 9.3.1(4). Each year is the median of cloud- and shadow-masked observations between 1 May and 31 August (workbook sheet F_imagery).

Stocking index per plot and year

Table 15: The stocking index of each project plot and of its four matched control plots, by year, with the weights applied to the controls. The core of the database required by VM0047, Section 9.3.1 (workbook sheet G_si_per_plot_year).