ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This workbook acts as a template for {mocaredd} the Monte Carlo simulations tool for REDD+ uncertainty analysis
2
3
Users can build as many tabs as desired but need the 4 building blocks to process a REDD+ carbon accouting and the asosciated incertainty:
4
user_inputs:
describes a few parameters to allow the tool to handle as many configurations as possible.

time_periods:
describes the diiferent time periods used for building the reference period and the monitoring period(s).

AD_lu_transitions:
describes the areas of land use/land cover change that generate emissions and or removals.

c_stocks:
describes the carbon elements necessary to build emission and removal factors associated with the land use transitions
5
6
Core interactions
7
1. The land use IDs entered in the tab "AD_lu_transitions" (lu_initial_id" and "lu_final_id") must be the same as the land use IDs described in "c_stocks" to match activity data and emission factors

2. Carbon pools AGB and BGB (if not expressed as a root-to-shoot ratio) are either reported as tons of dry matter (DM) or of carbon. If dry matter, a carbon fraction must be entered in "user_inputs" with, if possible, a standard error so that random simulations with be generated for the caron fraction.

3. Degraded land uses must be coded with the same ID as their intact equivalent with a consistent extension (for ex. "ev_deg" is the degraded land use of "ev") and the extension should be noted in the field "dg_ext"of the tab "user_inputs".
8
9
How is the data used by {mocaredd}
10
Upon uploading the data, the app runs 4 processes: (1) check the data to ensure it allows to construct emission factors matching the activity data and generate emission reductions, (2) build the carbon accounting calculations with arithmetic means to give a first idea of the volume of emission reductions, (3) run monte carlo simulations and provide simulation-based emission reductions for the monitoring period(s) desired with their aggregated uncertainty level and (4) turn off the variability of part of the input data to determine their contribution to the overall uncertainty (sensitivity analysis).
11
12
Note
13
For the sake of comparability, all calculations related tro emission factors are rounded to 3 digits and al calculations related to activity data, emissions and removals are rounded to the nearest integer (0 digits).
14
The tabs SIMS_io and SIMS showcase the calculations with MS Excel for 10 simulations. For backward compatibility, array-based formulas are not used
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100