Forum Discussion
Sigma Formula for Carbon Estimation
Hi, I'm so sorry for this late reply. Well, I referred to the reference document which provides a table like below:
'Drr' and 'Grr' for each i,j,k
'Apa' value for each i,j,k
And the expected result should be like below (highlighted number):
What I tried in the excel file was to obtain that result. I also want to confirm, does the formula that I wrote in the file is correct?
According to this screenshot, the Drr and Grr values are percentages, so their values in your sample workbook are a factor 100 too large.
The value you want is the sum of the EBLs for the four forest types.
Your screenshots do not show the C, Cnf and Csf values, so I cannot check the outcome of your formula against that in the last screenshot.
Hi Hans, thank you for still interested in this topic. Really appreciate it. Value for C, Cnf, and Csf provided below:
My apologies, I'm totally unfamiliar with the subject, so the following is undoubtedly very stupid. Does this mean that
1) The C for Secondary Peat Swamp and Secondary Riparian is 0?
2) The Csf for Peat Swamp and Riparian is 0?
3) The Cnf for all the above types is 0?
Hi Hans, sorry I made it more complex.
Referring to 'Drr' and 'Grr' screenshot above, all types of forest i, j, k has deforested value, so I used 'Deforestated land' (Cnf) value (33 Mg C ha-1) constantly for each i, j, k, and it applies to C also, means every forest has 'C' value.
As I read in reference, secondary forest is the degraded forest and it is the lowest level of forest status (no more degradation would quantify there). So that's why every secondary forest doesn't have a 'Cnf' value, which means 0.