{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["READ BEFORE STARTING!","Reference Sheet","Section 4.1","Section 4.2","Section 4.3","Section 7.2","Section 7.3","Section 8","Annex 4 Section 8.4","Support sheet (hidden)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"READ BEFORE STARTING!","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,3,8],[5,1,30,8]]}
[]
[null,"READ BEFORE STARTING!"]
[]
[]
[]
[null,"Please enable macros in order to use all interactive features in this workbook.\n\n1. When you first open the file\n- A security warning (“Enable Content” or “Macros have been disabled”) appears under the ribbon.\n- Click Enable Content (Windows) or Enable Macros (Mac) to allow the VBA code to run.\nNote: Once you turn on the macros and make file a trusted document, the next time you open the workbook, the security warning will not appear. \n\n2. If you declined the macros accidentally, you can either simply re-open the workbook and repeat Step 1 above, or follow the steps below\n\n- Windows Excel\n  > Go to File > Info\n  > Click Enable Content next to the Security Warning.\n  > If no warning is visible, go to File > Options > Trust Center > Trust Center Settings… > Macro Settings, choose “Enable all macros”, click OK, then close & reopen the workbook.\n\n- Mac Excel\n  > Go to Excel > Preferences… > Security & Privacy\n  > Under Macro Security, select “Enable all macros” or “Enable macros for this workbook”\n  > Close & reopen the workbook.\n\n3. Why?\n- All of the interactive show/hide logic, pop‑up reminders, and cell‑locking in this file is driven by VBA.\n- If macros remain disabled, those features will not work and some tables may remain hidden.\n\nTip: If you ever see unexpected blanks or missing tables, check that macros are enabled and then reopen the file.\t\t\t\t"]

{"sheet":"Reference Sheet","index":1,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[10,6,14,12],[5,16,6,17],[15,2,15,3],[5,6,7,12],[7,14,7,15],[24,3,24,4],[24,1,24,2],[23,3,23,4],[23,1,23,2],[0,0,2,0],[1,1,2,4],[5,3,5,4],[5,1,5,2],[10,1,10,2],[11,1,13,3]]}
[]
[null,"REFERENCE SHEET\nAlways Copy and Paste using Match Destination Formatting or Paste Values"]
[]
[]
[]
[null,"Reporting Period",null,"Monitoring Period",null,null,"Instructions\n\nEnter the Reporting and Monitoring Period Start and End Dates in the cells highlighted in red (B8 to E8). Once a date is entered, the cell will turn blue to indicate it remains editable.\n\n1. Reporting Period: Means each time period, as part of the Crediting Period for which the Program Entity has to measure and report on ERs generated under the ER Program in the form of ER Monitoring Reports. \n\n2. Monitoring Period: Means the time period, typically covering full calendar years, during which the REDD+ Country Participant estimates GHG emissions and removals used to quantify ERs for an ER-MR, and which may extend beyond the contractual Reporting Period to enable alignment with available monitoring data and systems.\n\nNote: In the first Reporting Period, the Monitoring Period may differ from the Reporting Period to allow alignment with available monitoring data. In subsequent Reporting Periods, the Monitoring Period must be identical to the Reporting Period."]
[null,"Start Date\n(YYYY-MM-DD)","End Date\n(YYYY-MM-DD)","Start Date\n(YYYY-MM-DD)","End Date\n(YYYY-MM-DD)"]
[]
[]
[]
[null,"Select the Applicable Option:",null,"Select Option",{"$f":"IF(D11=\"Select Option\", \"⚠️ Please select a valid Option\", \"\")","v":"⚠️ Please select a valid Option"},null,"Instructions  HFLD Selection\n\nUse thedropdown menu in D11 to indicate whether you wish to label the ERs as HFLD.\n\nOption 1: Yes – I want to apply the HFLD label to FCPF ERs. If yes, please provide:\n  > The max adjustment to average historical emissions (HFLD) in cell C16.\n  > The ERs sold, assigned or otherwise used by any other entity for sale, public relations, compliance or any other purpose including ERs accounted separately under other GHG accounting schemes or ERs that have been set-aside to meet Reversal management requirements under other GHG accounting schemes in C19 to G19, if applicable. \nPlease ensure this calculation also incorporates the ERs held in the applicable GHG Program Buffer Pool.\n\nOption 2: No – I do not want to apply the HFLD label.\nSelecting No will hide all HFLD-related calculation tables automatically alongside the workbook."]
[null,"Are you a REDD Country Participant wishing to label FCPF ERs as High Forest Low Deforestation (HFLD) resulting from the application of an adjustment to average historical emissions?\n- Option 1: Yes, I would like to label FCPF ERs as HFLD.\n- Option 2: No, I would not like to label FCPF ERs as HFLD. "]
[]
[]
[]
[null,"Max adjustment to average historical emissions (HFLD) (tCO2-e)"]
[]
[null,"Year of Monitoring / Reporting Period t",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","",""]
[null,"ERs sold, assigned or otherwise used by any other entity for sale, public relations, compliance or any other purpose including ERs accounted separately under other GHG accounting schemes or ERs that have been set-aside to meet Reversal management requirements under other GHG accounting schemes\n(tCO2-e)"]
[null,"Effective Start Date",{"$f":"IF(OR(B8=\"\",D8=\"\"),\"\",MAX(B8, D8))","v":""}]
[null,"Effective End Date",{"$f":"IF(OR(C8=\"\",E8=\"\"),\"\",MIN(C8,E8))","v":""}]
[null,"Days in overlap",{"$f":"IF(C21>=C20,C21-C20 + 1,0)","v":{"$error":"#VALUE!"}}]
[]
[null,"Length of Reporting Period in Days",null,"Length of Monitoring Period in Days"]
[null,{"$f":"MAX(0, MIN($C$8,$E$8) - MAX($B$8,$D$8) + 1)","v":1},null,{"$f":"$E$8-$D$8 + 1","v":1}]
[]
[null,"Years of Monitoring t","Effective Start Date","Effective End Date","Days in overlap"]
[null,{"$f":"IF($B$43:$B$47=0,\"\",$B$43:$B$47)","v":""},{"$f":"IF(B28=\"\", \"\", MAX($B$8, C36))","v":""},{"$f":"IF(B28=\"\", \"\", MIN($C$8, D36))","v":""},{"$f":"IF(B28=\"\", \"\", IF(D28 >= C28, D28 - C28 +1, 0))","v":""}]
[null,"",{"$f":"IF(B29=\"\", \"\", MAX($B$8, C37))","v":""},{"$f":"IF(B29=\"\", \"\", MIN($C$8, D37))","v":""},{"$f":"IF(B29=\"\", \"\", IF(D29 >= C29, D29 - C29 +1, 0))","v":""}]
[null,"","",{"$f":"IF(B30=\"\", \"\", MIN($C$8, D38))","v":""},""]
[null,"","","",""]
[null,"","","",""]
[]
[]
[null,"Years of Monitoring t","Year Start Date (Monitoring Year t)\n(YYYY-MM-DD)","Year End Date (Monitoring Year t)\n(YYYY-MM-DD)"]
[null,{"$f":"IF($B$43:$B$47=0,\"\",$B$43:$B$47)","v":""},{"$f":"IF($B36=\"\",\"\",MAX($D$8,DATE($B36,1,1)))","v":""},{"$f":"IF($B36=\"\",\"\",MIN($E$8,DATE($B36,12,31)))","v":""}]
[null,"",{"$f":"IF($B37=\"\",\"\",MAX($D$8,DATE($B37,1,1)))","v":""},{"$f":"IF($B37=\"\",\"\",MIN($E$8,DATE($B37,12,31)))","v":""}]
[null,"","",""]
[null,"","",""]
[null,"","",""]
[]
[null,"Years of Monitoring t"]
[null,{"$f":"IF(OR($D$8=\"\", $E$8=\"\"), \"\", IF(ROW()-ROW($B$43)<=YEAR($E$8)-YEAR($D$8), YEAR($D$8)+ROW()-ROW($B$43), \"\"))","v":""}]
[null,{"$f":"IF(OR($D$8=\"\", $E$8=\"\"), \"\", IF(ROW()-ROW($B$43)<=YEAR($E$8)-YEAR($D$8), YEAR($D$8)+ROW()-ROW($B$43), \"\"))","v":""}]
[null,""]
[null,""]
[null,""]

{"sheet":"Section 4.1","index":2,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[17,4,18,6],[17,1,18,3],[4,1,5,3],[1,1,2,7],[4,4,5,6]]}
[]
[null,"Section 4.1 - ER Program Reference Level for the Monitoring Period covered in the ER-MR"]
[]
[]
[null," Input Data (With Decimals)\nAlways Copy and Paste using Match Destination Formatting or Paste Values",null,null,"1. Copy and paste the original values here with all decimals, as reported in the ER Program’s own calculation spreadsheet (i.e. the national spreadsheet developed by the ER Program).Fill out the cells highlighted in red.\nIf a value is not applicable, enter “0” instead of leaving the cell blank.\nOnce filled, red cells will turn blue to indicate that they remain editable (as opposed to white, which are locked).\n2. Do not manually truncate, please."]
[]
[]
[null," Year of Monitoring / Reporting Period t","Average annual historical Emissions from deforestation over the Reference Period (tCO2-e/yr)","If applicable, average annual historical Emissions from forest degradation over the Reference Period (tCO2-e/yr)","If applicable, average annual historical enhanced Removals from afforestation/reforestation (AR) (tCO2-e/yr)","If applicable, average annual historical enhanced Removals from other activities besides A/R (tCO2-e/yr)","Adjustment, if applicable (tCO2-e/yr)","Reference Level (tCO2-e/yr)"]
[null,{"$f":"IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47)","v":""},null,null,null,null,null,{"$f":"IF(COUNT($C9, $D9, $E9, $F9, $G9)=0, \"\", SUM($C9:$G9))","v":""}]
[null,"",null,null,null,null,null,{"$f":"IF(COUNT($C10, $D10, $E10, $F10, $G10)=0, \"\", SUM($C10:$G10))","v":""}]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"Total",{"$f":"IF(COUNTA($C$9:$C$13)=0, \"\", SUM($C$9:$C$13))","v":""},{"$f":"IF(COUNTA($D$9:$D$13)=0, \"\", SUM($D$9:$D$13))","v":""},{"$f":"IF(COUNTA($E$9:$E$13)=0, \"\", SUM($E$9:$E$13))","v":""},{"$f":"IF(COUNTA($F$9:$F$13)=0, \"\", SUM($F$9:$F$13))","v":""},{"$f":"IF(COUNTA($G$9:$G$13)=0, \"\", SUM($G$9:$G$13))","v":""},""]
[null,null,{"$f":"SUMPRODUCT(($B$9:$B$13<>\"\")*(C9:C13=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$9:$B$13<>\"\")*(D9:D13=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$9:$B$13<>\"\")*(E9:E13=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$9:$B$13<>\"\")*(F9:F13=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$9:$B$13<>\"\")*(G9:G13=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$9:$B$13<>\"\")*(H9:H13=\"\"))","v":0}]
[]
[]
[null,"Adjusted Data (Truncated Automatically)",null,null,"1. Values to be used in the ER-MR with decimals adjusted automatically.\n2. Do not make manual modifications. The table below is protected, no modifications are allowed.\n3. Copy and paste is permitted. "]
[]
[]
[null," Year of Monitoring / Reporting Period t","Average annual historical Emissions from deforestation over the Reference Period (tCO2-e/yr)","If applicable, average annual historical Emissions from forest degradation over the Reference Period (tCO2-e/yr)","If applicable, average annual historical enhanced Removals from afforestation/reforestation (AR) (tCO2-e/yr)","If applicable, average annual historical enhanced Removals from other activities besides A/R (tCO2-e/yr)","Adjustment, if applicable (tCO2-e/yr)","Reference Level (tCO2-e/yr)","Reference Level without adjustment (tCO2-e/yr)"]
[null,{"$f":"IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47)","v":""},{"$f":"IF(C9=\"\",\"\",TRUNC(C9,0))","v":""},"","","","",{"$f":"IF(SUM(C22:G22)=0,\"\",SUM(C22:G22))","v":""},{"$f":"IF(OR(H22=\"\",H22=0),\"\",TRUNC(H22 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"","","","","","",{"$f":"IF(SUM(C23:G23)=0,\"\",SUM(C23:G23))","v":""},{"$f":"IF(OR(H23=\"\",H23=0),\"\",TRUNC(H23 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"","","","","","","",{"$f":"IF(OR(H24=\"\",H24=0),\"\",TRUNC(H24 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"","","","","","","",{"$f":"IF(OR(H25=\"\",H25=0),\"\",TRUNC(H25 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"","","","","","","",{"$f":"IF(OR(H26=\"\",H26=0),\"\",TRUNC(H26 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"Total",{"$f":"IF(SUMPRODUCT(--($C$22:$C$26<>\"\"))=0, \"\", SUM($C$22:$C$26))","v":""},{"$f":"IF(SUMPRODUCT(--($D$22:$D$26<>\"\"))=0, \"\", SUM($D$22:$D$26))","v":""},{"$f":"IF(SUMPRODUCT(--($E$22:$E$26<>\"\"))=0, \"\", SUM($E$22:$E$26))","v":""},{"$f":"IF(SUMPRODUCT(--($F$22:$F$26<>\"\"))=0, \"\", SUM($F$22:$F$26))","v":""},{"$f":"IF(SUMPRODUCT(--($G$22:$G$26<>\"\"))=0, \"\", SUM($G$22:$G$26))","v":""},{"$f":"IF(SUMPRODUCT(--($H$22:$H$26<>\"\"))=0, \"\", SUM($H$22:$H$26))","v":""},{"$f":"IF(SUMPRODUCT(--($I$22:$I$26<>\"\"))=0, \"\", SUM($I$22:$I$26))","v":""}]
[null,null,{"$f":"SUMPRODUCT(($B$22:$B$26<>\"\")*(C22:C26=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$22:$B$26<>\"\")*(D22:D26=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$22:$B$26<>\"\")*(E22:E26=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$22:$B$26<>\"\")*(F22:F26=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$22:$B$26<>\"\")*(G22:G26=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$22:$B$26<>\"\")*(H22:H26=\"\"))","v":0}]

{"sheet":"Section 4.2","index":3,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[21,6,22,6],[7,2,8,2],[7,3,8,3],[7,6,8,6],[7,1,8,1],[7,4,8,4],[21,1,22,1],[21,4,22,4],[7,5,8,5],[21,5,22,5],[21,2,22,2],[21,3,22,3],[1,1,2,6],[4,1,5,3],[18,1,19,3],[4,4,5,5],[18,4,19,5]]}
[]
[null,"Section 4.2 - Estimation of Emissions by Sources and Removals by Sinks included in the ER Program’s scope"]
[]
[]
[null," Input Data (With Decimals)\nAlways Copy and Paste using Match Destination Formatting or Paste Values ",null,null,"1. Copy and paste the original values here with all decimals, as reported in the ER Program’s own calculation spreadsheet (i.e. the national spreadsheet developed by the ER Program).Fill out the cells highlighted in red.\nIf a value is not applicable, enter “0” instead of leaving the cell blank.\nOnce filled, red cells will turn blue to indicate that they remain editable (as opposed to white, which are locked).\n2. Do not manually truncate, please."]
[]
[]
[null,"Year of Monitoring / Report Period t","Emissions from deforestation (tCO2-e/yr)","If applicable, Emissions from forest degradation (tCO2-e/yr)*","If applicable, enhanced Removals from afforestation/reforestation (AR) (tCO2-e/yr)","If applicable, enhanced Removals from other activities besides A/R (tCO2-e/yr)","Net Emissions and Removals (tCO2-e/yr)"]
[]
[null,{"$f":"IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47)","v":""},null,null,null,null,{"$f":"IF(COUNT(C10, D10, E10, F10)=0, \"\", SUM(C10:F10))","v":""}]
[null,"",null,null,null,null,{"$f":"IF(COUNT(C11, D11, E11, F11)=0, \"\", SUM(C11:F11))","v":""}]
[null,"",null,null,null,null,""]
[null,"",null,null,null,null,""]
[null,"",null,null,null,null,""]
[null,"Total",{"$f":"IF(COUNTA($C$10:$C$14)=0, \"\", SUM($C$10:$C$14))","v":""},{"$f":"IF(COUNTA($D$10:$D$14)=0, \"\", SUM($D$10:$D$14))","v":""},{"$f":"IF(COUNTA($E$10:$E$14)=0, \"\", SUM($E$10:$E$14))","v":""},{"$f":"IF(COUNTA($F$10:$F$14)=0, \"\", SUM($F$10:$F$14))","v":""},""]
[null,null,{"$f":"SUMPRODUCT(($B$10:$B$14<>\"\")*(C10:C14=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$10:$B$14<>\"\")*(D10:D14=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$10:$B$14<>\"\")*(E10:E14=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$10:$B$14<>\"\")*(F10:F14=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$10:$B$14<>\"\")*(G10:G14=\"\"))","v":0}]
[]
[]
[null,"Adjusted Data (Truncated Automatically)",null,null,"1. Values to be used in the ER-MR with decimals adjusted automatically.\n2. Do not make manual modifications. The table below is protected, no modifications are allowed.\n3. Copy and paste is permitted. "]
[]
[]
[null,"Year of Monitoring / Report Period t","Emissions from deforestation (tCO2-e/yr)","If applicable, Emissions from forest degradation (tCO2-e/yr)*","If applicable, enhanced Removals from afforestation/reforestation (AR) (tCO2-e/yr)","If applicable, enhanced Removals from other activities besides A/R (tCO2-e/yr)","Net Emissions and Removals (tCO2-e/yr)"]
[]
[null,{"$f":"IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47)","v":""},{"$f":"IF(C10=\"\",\"\",TRUNC(C10,0))","v":""},"","","",{"$f":"IF(SUM(C24:F24)=0,\"\",SUM(C24:F24))","v":""}]
[null,"","","","","",{"$f":"IF(SUM(C25:F25)=0,\"\",SUM(C25:F25))","v":""}]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"Total",{"$f":"IF(SUMPRODUCT(--($C$24:$C$28<>\"\"))=0, \"\", SUM($C$24:$C$28))","v":""},{"$f":"IF(SUMPRODUCT(--($D$24:$D$28<>\"\"))=0, \"\", SUM($D$24:$D$28))","v":""},{"$f":"IF(SUMPRODUCT(--($E$24:$E$28<>\"\"))=0, \"\", SUM($E$24:$E$28))","v":""},{"$f":"IF(SUMPRODUCT(--($F$24:$F$28<>\"\"))=0, \"\", SUM($F$24:$F$28))","v":""},{"$f":"IF(SUMPRODUCT(--($G$24:$G$28<>\"\"))=0, \"\", SUM($G$24:$G$28))","v":""}]
[null,null,{"$f":"SUMPRODUCT(($B$24:$B$28<>\"\")*(C24:C28=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$24:$B$28<>\"\")*(D24:D28=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$24:$B$28<>\"\")*(E24:E28=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$24:$B$28<>\"\")*(F24:F28=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$24:$B$28<>\"\")*(G24:G28=\"\"))","v":0}]

{"sheet":"Section 4.3","index":4,"n_rows":55,"n_cols":55,"rows_kept":55,"cut":false,"hidden":false,"merged":[[43,42,45,44],[24,35,24,39],[25,48,25,49],[27,50,30,54],[13,48,13,49],[15,50,18,54],[18,36,19,36],[18,37,19,37],[18,38,19,38],[18,39,19,39],[18,40,19,40],[16,40,17,40],[12,42,12,46],[33,42,35,43],[33,37,34,37],[33,38,34,38],[33,39,34,39],[12,40,13,40],[14,40,15,40],[12,35,12,39],[24,42,24,46],[33,36,34,36],[1,1,2,7],[9,1,10,3],[21,1,22,3],[4,1,4,2],[5,1,7,3],[9,4,10,6],[12,10,12,14],[12,15,12,19],[12,20,12,24],[12,25,12,29],[12,30,12,34],[24,25,24,29],[24,30,24,34],[43,15,48,22],[21,4,22,6],[24,10,24,14],[24,15,24,19],[24,20,24,24],[43,2,43,7],[43,8,43,13],[33,8,33,13],[33,2,33,7],[29,2,29,7],[33,15,37,22]]}
[]
[null,"Section 4.3 - Calculation of Emission Reductions"]
[]
[]
[null,"Select the Applicable Option:",null,"Select Option",{"$f":"IF(D5=\"Select Option\", \"⚠️ Please select a valid Option\", \"\")","v":"⚠️ Please select a valid Option"}]
[null,"Please select the calculation approach for this section using the dropdown menu:\n- Option 1: The Reporting Period fully coincides with the Monitoring Period.\n- Option 2: The Reporting Period is shorter than the Monitoring Period and requires pro-rata allocation.\nNote: \n1. Only one option can be used. The table for the other option will be hidden automatically based on your selection. \n2. This calculation approach is only relevant for the first Reporting Period. In subsequent Reporting Periods, the Reporting and Monitoring Periods are expected to be the same, and Option 1 will typically apply."]
[]
[]
[]
[null,"Option 1 (Calculated and Truncated Automatically)",null,null,"1. The Reporting Period coincides with the Monitoring Period.\n2. These tables, calculated and truncated automatically, must be used in the ER-MR."]
[]
[]
[null,null,null,null,null,null,null,null,null,"T.2","Deforestation",null,null,null,null,"If applicable, forest degradation",null,null,null,null,"If applicable, enhanced Removals from afforestation/ reforestation (A/R)",null,null,null,null,"If applicable, enhanced Removals from other activities besides A/R",null,null,null,null,"Adjustment, if applicable",null,null,null,null,"Total (tCO2-e)",null,null,null,null,null,"T.5","Emission Reductions during the Reporting Period (tCO2-e)",null,null,null,null,null,"T.6 ","Year ",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","",""]
[null,"T.1","Deforestation","If applicable, forest degradation","If applicable, enhanced Removals from afforestation/ reforestation (A/R)","If applicable, enhanced Removals from other activities besides A/R*","Adjustment, if applicable","Total (tCO2-e)",null,"Year",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",null,"Year ",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",null,"Emission Reductions from enhanced Removals from afforestation/reforestation as a percentage of the total FCPF ERs (%) ",null,{"$f":"IF(AY13=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 1\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AQ16),\"\"))","v":""},{"$f":"IF(AZ13=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 1\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AR16),\"\"))","v":""},{"$f":"IF(BA13=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 1\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AS16),\"\"))","v":""},{"$f":"IF(BB13=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 1\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AT16),\"\"))","v":""},{"$f":"IF(BC13=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 1\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AU16),\"\"))","v":""}]
[null,"Emissions or Removals in the Reference Level (tCO2-e)",{"$f":"'Section 4.1'!$C$27","v":""},{"$f":"'Section 4.1'!$D$27","v":""},{"$f":"'Section 4.1'!$E$27","v":""},{"$f":"'Section 4.1'!$F$27","v":""},{"$f":"SUM(AE15:AI15)","v":0},{"$f":"'Section 4.1'!$H$27","v":""},null,"Emissions or Removals in the Reference Level (tCO2-e)",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$C$22:$C$26),\"\",'Section 4.1'!$C$22:$C$26))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$D$22:$D$26),\"\",'Section 4.1'!$D$22:$D$26))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$E$22:$E$26),\"\",'Section 4.1'!$E$22:$E$26))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$F$22:$F$26),\"\",'Section 4.1'!$F$22:$F$26))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$G$22:$G$26),\"\",'Section 4.1'!$G$22:$G$26))","v":""},"","","","",{"$f":"IF(COUNT(K15, P15, U15, Z15, AE15)=0, \"\", SUM(K15, P15, U15, Z15, AE15))","v":""},{"$f":"IF(COUNT(L15, Q15, V15, AA15, AF15)=0, \"\", SUM(L15, Q15, V15, AA15, AF15))","v":""},{"$f":"IF(COUNT(M15, R15, W15, AB15, AG15)=0, \"\", SUM(M15, R15, W15, AB15, AG15))","v":""},{"$f":"IF(COUNT(N15, S15, X15, AC15, AH15)=0, \"\", SUM(N15, S15, X15, AC15, AH15))","v":""},{"$f":"IF(COUNT(O15, T15, Y15, AD15, AI15)=0, \"\", SUM(O15, T15, Y15, AD15, AI15))","v":""},null,"Total ",{"$f":"IF(COUNT(K17, P17, U17, Z17, AE17)=0, \"\", SUM(K17, P17, U17, Z17, AE17))","v":""},{"$f":"IF(COUNT(L17, Q17, V17, AA17, AF17)=0, \"\", SUM(L17, Q17, V17, AA17, AF17))","v":""},{"$f":"IF(COUNT(M17, R17, W17, AB17, AG17)=0, \"\", SUM(M17, R17, W17, AB17, AG17))","v":""},{"$f":"IF(COUNT(N17, S17, X17, AC17, AH17)=0, \"\", SUM(N17, S17, X17, AC17, AH17))","v":""},{"$f":"IF(COUNT(O17, T17, Y17, AD17, AI17)=0, \"\", SUM(O17, T17, Y17, AD17, AI17))","v":""}]
[null,"Emissions or Removals under the ER Program during the Reporting Period (tCO2-e)",{"$f":"'Section 4.2'!$C$29","v":""},{"$f":"'Section 4.2'!$D$29","v":""},{"$f":"'Section 4.2'!$E$29","v":""},{"$f":"'Section 4.2'!$F$29","v":""},0,{"$f":"'Section 4.2'!$G$29","v":""},null,"Emissions or Removals under the ER Program during the Monitoring Period (tCO2-e)",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.2'!$C$24:$C$28),\"\",'Section 4.2'!$C$24:$C$28))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.2'!$D$24:$D$28),\"\",'Section 4.2'!$D$24:$D$28))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.2'!$E$24:$E$28),\"\",'Section 4.2'!$E$24:$E$28))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.2'!$F$24:$F$28),\"\",'Section 4.2'!$F$24:$F$28))","v":""},"","","","",{"$f":"IF(ISNUMBER(AE15), 0, \"\")","v":""},{"$f":"IF(ISNUMBER(AF15), 0, \"\")","v":""},"","","","","","","","",null,"Emission Reductions from enhanced Removals from afforestation/reforestation as a percentage of the total FCPF ERs (%) ",{"$f":"IF(COUNT(U17,AQ$15)=0,\"\",IFERROR(SIGN(U17)*ABS(U17)/ABS(AQ$15),0))","v":""},{"$f":"IF(COUNT(V17,AR$15)=0,\"\",IFERROR(SIGN(V17)*ABS(V17)/ABS(AR$15),0))","v":""},"","","",null,null,null,"Enhanced Removals Label Eligibility\n\nPer FCPF guidance, estimating “Enhanced Removals from Afforestation/Reforestation as a % of Total FCPF ERs” is optional and only permitted when both deforestation and forest degradation emission reductions exceed zero. Accordingly, each formula first verifies that the ERs for deforestation (Section 4.3 C17 or C31) and for forest degradation (Section 4.3 D17 or D31) are more than zero; if either is negative, the formula returns zero, thereby preventing the application of the enhanced removals label."]
[null,"Emission Reductions during the Reporting Period (tCO2-e)",{"$f":"IF(AND(ISNUMBER(C15), ISNUMBER(C16)), C15-C16, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(D15), ISNUMBER(D16)), D15-D16, \"\")","v":""},"","",0,{"$f":"IF(AND(ISNUMBER(H15), ISNUMBER(H16)), H15-H16, \"\")","v":""},null,"Emission Reductions during the Reporting Period (tCO2-e)",{"$f":"IF(AND(ISNUMBER(K15), ISNUMBER(K16)), K15-K16, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(L15), ISNUMBER(L16)), L15-L16, \"\")","v":""},"","","",{"$f":"IF(AND(ISNUMBER(P15), ISNUMBER(P16)), P15-P16, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(Q15), ISNUMBER(Q16)), Q15-Q16, \"\")","v":""},"","","",{"$f":"IF(AND(ISNUMBER(U15), ISNUMBER(U16)), U15-U16, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(V15), ISNUMBER(V16)), V15-V16, \"\")","v":""},"","","","","","","","",{"$f":"IF(OR(ISNUMBER(AE15), ISNUMBER(AE16)), AE15-AE16, \"\")","v":""},{"$f":"IF(OR(ISNUMBER(AF15), ISNUMBER(AF16)), AF15-AF16, \"\")","v":""},"","","",{"$f":"IF(OR(ISNUMBER(AJ15), ISNUMBER(AJ16)), AJ15-AJ16, \"\")","v":""},{"$f":"IF(OR(ISNUMBER(AK15), ISNUMBER(AK16)), AK15-AK16, \"\")","v":""},"","","",null,"If applicable, enhanced Removals from other activities besides A/R (%) ",{"$f":"IF(COUNT(Z17,AQ$15)=0,\"\",IFERROR(SIGN(Z17)*ABS(Z17)/ABS(AQ$15),0))","v":""},{"$f":"IF(COUNT(AA17,AR$15)=0,\"\",IFERROR(SIGN(AA17)*ABS(AA17)/ABS(AR$15),0))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If applicable, forest degradation (%) ",{"$f":"IF(COUNT(P17,AQ$15)=0,\"\",IFERROR(SIGN(P17)*ABS(P17)/ABS(AQ$15),0))","v":""},{"$f":"IF(COUNT(Q17,AR$15)=0,\"\",IFERROR(SIGN(Q17)*ABS(Q17)/ABS(AR$15),0))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deforestation (%) ",{"$f":"IF(COUNT(K17,AQ$15)=0,\"\",IFERROR(SIGN(K17)*ABS(K17)/ABS(AQ$15),0))","v":""},{"$f":"IF(COUNT(L17,AR$15)=0,\"\",IFERROR(SIGN(L17)*ABS(L17)/ABS(AR$15),0))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment, if applicable (%) ",{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(C43=\"\", \"\", C43), IF(COUNT(AE17, AL$15)=0, \"\", IFERROR(SIGN(AE17)*ABS(AE17)/ABS(AL$15), 0)))","v":""},{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(D43=\"\", \"\", D43), IF(COUNT(AF17, AM$15)=0, \"\", IFERROR(SIGN(AF17)*ABS(AF17)/ABS(AM$15), 0)))","v":""},{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(E43=\"\", \"\", E43), IF(COUNT(AG17, AN$15)=0, \"\", IFERROR(SIGN(AG17)*ABS(AG17)/ABS(AN$15), 0)))","v":""},{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(F43=\"\", \"\", F43), IF(COUNT(AH17, AO$15)=0, \"\", IFERROR(SIGN(AH17)*ABS(AH17)/ABS(AO$15), 0)))","v":""},{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(G43=\"\", \"\", G43), IF(COUNT(AI17, AP$15)=0, \"\", IFERROR(SIGN(AI17)*ABS(AI17)/ABS(AP$15), 0)))","v":""}]
[]
[null,"Option 2 (Calculated and Truncated Automatically)",null,null,"1. If the Reporting Period is shorter than the Monitoring Period, it is required a pro-rata allocation using Option 2.\n2. This spreadsheet uses 8 decimal places for the pro-rata calculation for accuracy.\n3. The three Tables below are calculated automatically, with the decimals adjusted to be used in the ER-MR."]
[]
[]
[null,null,null,null,null,null,null,null,null,"T.4","Deforestation",null,null,null,null,"If applicable, forest degradation",null,null,null,null,"If applicable, enhanced Removals from afforestation/ reforestation (A/R)",null,null,null,null,"If applicable, enhanced Removals from other activities besides A/R",null,null,null,null,"Adjustment, if applicable (tCO2e/yr)",null,null,null,null,"Total (tCO2-e)",null,null,null,null,null,"T.5","Emission Reductions during the Reporting Period (tCO2-e)\t\t\t\t\t",null,null,null,null,null,"T.6","Year",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","",""]
[null,"T.3","Deforestation","If applicable, forest degradation","If applicable, enhanced Removals from afforestation/ reforestation (A/R)","If applicable, enhanced Removals from other activities besides A/R","Adjustment, if applicable","Total (tCO2-e)",null,"Year",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",null,"Year",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","",null,"Emission Reductions from enhanced Removals from afforestation/reforestation as a percentage of the total FCPF ERs (%) ",null,{"$f":"IF(AY25=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 2\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AQ28),\"\"))","v":""},{"$f":"IF(AZ25=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 2\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AR28),\"\"))","v":""},{"$f":"IF(BA25=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 2\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AS28),\"\"))","v":""},{"$f":"IF(BB25=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 2\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AT28),\"\"))","v":""},{"$f":"IF(BC25=\"\",\"\",IF('Section 4.3'!$D$5=\"Option 2\",IF(OR('Section 4.3'!C17<0,'Section 4.3'!D17<0),0,'Section 4.3'!AU28),\"\"))","v":""}]
[null,"Emissions or Removals in the Reference Level (tCO2-e)",{"$f":"'Section 4.1'!$C$27","v":""},{"$f":"'Section 4.1'!$D$27","v":""},{"$f":"'Section 4.1'!$E$27","v":""},{"$f":"'Section 4.1'!$F$27","v":""},{"$f":"SUM(AE27:AI27)","v":0},{"$f":"'Section 4.1'!$H$27","v":""},null,"Emissions or Removals in the Reference Level (tCO2-e)",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$C$22:$C$26),\"\",'Section 4.1'!$C$22:$C$26))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$D$22:$D$26),\"\",'Section 4.1'!$D$22:$D$26))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$E$22:$E$26),\"\",'Section 4.1'!$E$22:$E$26))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$F$22:$F$26),\"\",'Section 4.1'!$F$22:$F$26))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.1'!$G$22:$G$26),\"\",'Section 4.1'!$G$22:$G$26))","v":""},"","","","",{"$f":"IF(COUNT(K27, P27, U27, Z27, AE27)=0, \"\", SUM(K27, P27, U27, Z27, AE27))","v":""},{"$f":"IF(COUNT(L27, Q27, V27, AA27, AF27)=0, \"\", SUM(L27, Q27, V27, AA27, AF27))","v":""},{"$f":"IF(COUNT(M27, R27, W27, AB27, AG27)=0, \"\", SUM(M27, R27, W27, AB27, AG27))","v":""},{"$f":"IF(COUNT(N27, S27, X27, AC27, AH27)=0, \"\", SUM(N27, S27, X27, AC27, AH27))","v":""},{"$f":"IF(COUNT(O27, T27, Y27, AD27, AI27)=0, \"\", SUM(O27, T27, Y27, AD27, AI27))","v":""},null,"Total",{"$f":"IF(COUNT(K31, P31, U31, Z31, AE31)=0, \"\", SUM(K31, P31, U31, Z31, AE31))","v":""},{"$f":"IF(COUNT(L31, Q31, V31, AA31, AF31)=0, \"\", SUM(L31, Q31, V31, AA31, AF31))","v":""},"","",""]
[null,"Emissions or Removals under the ER Program during the Monitoring Period (tCO2-e)",{"$f":"'Section 4.2'!$C$29","v":""},{"$f":"'Section 4.2'!$D$29","v":""},{"$f":"'Section 4.2'!$E$29","v":""},{"$f":"'Section 4.2'!$F$29","v":""},{"$f":"SUM(AE28:AI28)","v":0},{"$f":"'Section 4.2'!$G$29","v":""},null,"Emissions or Removals under the ER Program during the Monitoring Period (tCO2-e)",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.2'!$C$24:$C$28),\"\",'Section 4.2'!$C$24:$C$28))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.2'!$D$24:$D$28),\"\",'Section 4.2'!$D$24:$D$28))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.2'!$E$24:$E$28),\"\",'Section 4.2'!$E$24:$E$28))","v":""},"","","","",{"$f":"TRANSPOSE(IF(ISBLANK('Section 4.2'!$F$24:$F$28),\"\",'Section 4.2'!$F$24:$F$28))","v":""},"","","","",{"$f":"IF(ISNUMBER(AE26), 0, \"\")","v":""},{"$f":"IF(ISNUMBER(AF26), 0, \"\")","v":""},"","","","","","","","",null,"Emission Reductions from enhanced Removals from afforestation/reforestation as a percentage of the total FCPF ERs (%)",{"$f":"IF(COUNT(U31,AQ$27)=0,\"\",IFERROR(SIGN(U31)*ABS(U31)/ABS(AQ$27),0))","v":""},{"$f":"IF(COUNT(V31,AR$27)=0,\"\",IFERROR(SIGN(V31)*ABS(V31)/ABS(AR$27),0))","v":""},"","","",null,null,null,"Enhanced Removals Label Eligibility\n\nPer FCPF guidance, estimating “Enhanced Removals from Afforestation/Reforestation as a % of Total FCPF ERs” is optional and only permitted when both deforestation and forest degradation emission reductions exceed zero. Accordingly, each formula first verifies that the ERs for deforestation (Section 4.3 C17 or C31) and for forest degradation (Section 4.3 D17 or D31) are more than zero; if either is negative, the formula returns zero, thereby preventing the application of the enhanced removals label."]
[null,"Emission Reductions during the Monitoring Period (tCO2-e)",{"$f":"IF(AND(ISNUMBER(C27), ISNUMBER(C28)), C27-C28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(D27), ISNUMBER(D28)), D27-D28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E27), ISNUMBER(E28)), E27-E28, \"\")","v":""},"",0,"",null,"Emission Reductions during the Monitoring Period (tCO2-e)",{"$f":"IF(AND(ISNUMBER(K27), ISNUMBER(K28)), K27-K28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(L27), ISNUMBER(L28)), L27-L28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(M27), ISNUMBER(M28)), M27-M28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(N27), ISNUMBER(N28)), N27-N28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(O27), ISNUMBER(O28)), O27-O28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(P27), ISNUMBER(P28)), P27-P28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(Q27), ISNUMBER(Q28)), Q27-Q28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(R27), ISNUMBER(R28)), R27-R28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(S27), ISNUMBER(S28)), S27-S28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(T27), ISNUMBER(T28)), T27-T28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(U27), ISNUMBER(U28)), U27-U28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(V27), ISNUMBER(V28)), V27-V28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(W27), ISNUMBER(W28)), W27-W28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(X27), ISNUMBER(X28)), X27-X28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(Y27), ISNUMBER(Y28)), Y27-Y28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(Z27), ISNUMBER(Z28)), Z27-Z28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(AA27), ISNUMBER(AA28)), AA27-AA28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(AB27), ISNUMBER(AB28)), AB27-AB28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(AC27), ISNUMBER(AC28)), AC27-AC28, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(AD27), ISNUMBER(AD28)), AD27-AD28, \"\")","v":""},{"$f":"IF(OR(ISNUMBER(AE27), ISNUMBER(AE28)), AE27-AE28, \"\")","v":""},{"$f":"IF(OR(ISNUMBER(AF27), ISNUMBER(AF28)), AF27-AF28, \"\")","v":""},"","","","","","","","",null,"If applicable, enhanced Removals from other activities besides A/R (%)",{"$f":"IF(COUNT(Z31,AQ$27)=0,\"\",IFERROR(SIGN(Z31)*ABS(Z31)/ABS(AQ$27),0))","v":""},{"$f":"IF(COUNT(AA31,AR$27)=0,\"\",IFERROR(SIGN(AA31)*ABS(AA31)/ABS(AR$27),0))","v":""},"","",""]
[null,"Length of the Reporting period / Length of the Monitoring Period (# days/# days)",{"$f":"_xlfn.TEXTJOIN(\"; \",TRUE,IF(K26<>\"\",\"For \"&K26&\": \"&TEXT(K30,\"0.########\"),\"\"),IF(L26<>\"\",\"For \"&L26&\": \"&TEXT(L30,\"0.########\"),\"\"),IF(M26<>\"\",\"For \"&M26&\": \"&TEXT(M30,\"0.########\"),\"\"),IF(N26<>\"\",\"For \"&N26&\": \"&TEXT(N30,\"0.########\"),\"\"),IF(O26<>\"\",\"For \"&O26&\": \"&TEXT(O30,\"0.########\"),\"\"))","v":""},null,null,null,null,null,null,"Length of the Reporting period / Length of the Monitoring Period (# days/# days)",{"$f":"TRANSPOSE(IFERROR(IF((('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)=0)+ISBLANK('Reference Sheet'!C36:C40)+ISBLANK('Reference Sheet'!D36:D40),\"\",'Reference Sheet'!E28:E32/('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)),\"\"))","v":""},"","","","",{"$f":"TRANSPOSE(IFERROR(IF((('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)=0)+ISBLANK('Reference Sheet'!C36:C40)+ISBLANK('Reference Sheet'!D36:D40),\"\",'Reference Sheet'!E28:E32/('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)),\"\"))","v":""},"","","","",{"$f":"TRANSPOSE(IFERROR(IF((('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)=0)+ISBLANK('Reference Sheet'!C36:C40)+ISBLANK('Reference Sheet'!D36:D40),\"\",'Reference Sheet'!E28:E32/('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)),\"\"))","v":""},"","","","",{"$f":"TRANSPOSE(IFERROR(IF((('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)=0)+ISBLANK('Reference Sheet'!C36:C40)+ISBLANK('Reference Sheet'!D36:D40),\"\",'Reference Sheet'!E28:E32/('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)),\"\"))","v":""},"","","","",{"$f":"TRANSPOSE(IFERROR(IF((('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)=0)+ISBLANK('Reference Sheet'!C36:C40)+ISBLANK('Reference Sheet'!D36:D40),\"\",'Reference Sheet'!E28:E32/('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)),\"\"))","v":""},"","","","",{"$f":"TRANSPOSE(IFERROR(IF((('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)=0)+ISBLANK('Reference Sheet'!C36:C40)+ISBLANK('Reference Sheet'!D36:D40),\"\",'Reference Sheet'!E28:E32/('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)),\"\"))","v":""},"","","","",null,"If applicable, forest degradation (%)",{"$f":"IF(COUNT(P31,AQ$27)=0,\"\",IFERROR(SIGN(P31)*ABS(P31)/ABS(AQ$27),0))","v":""},{"$f":"IF(COUNT(Q31,AR$27)=0,\"\",IFERROR(SIGN(Q31)*ABS(Q31)/ABS(AR$27),0))","v":""},"","",""]
[null,"Emission Reductions during the Reporting Period (tCO2-e)",{"$f":"IF(SUM(K31:O31)<>0, TRUNC(SUM(K31:O31),0), \"\")","v":""},{"$f":"IF(SUM(P31:T31)<>0, TRUNC(SUM(P31:T31),0), \"\")","v":""},{"$f":"IF(SUM(U31:Y31)<>0, TRUNC(SUM(U31:Y31),0), \"\")","v":""},{"$f":"IF(SUM(Z31:AD31)<>0, TRUNC(SUM(Z31:AD31),0), \"\")","v":""},{"$f":"IF(SUM(AE31:AI31)<>0, TRUNC(SUM(AE31:AI31),0), \"0\")","v":"0"},{"$f":"IF(SUM(C31:F31)<>0, TRUNC(SUM(C31:F31),0), \"\")","v":""},null,"Emission Reductions during the Reporting Period (tCO2-e)",{"$f":"IF(AND(ISNUMBER(K29), ISNUMBER(K30)), TRUNC(K29*K30,0), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(L29), ISNUMBER(L30)), TRUNC(L29*L30,0), \"\")","v":""},"","","","","","","","","","","","","","","","","","",{"$f":"IF(AND(ISNUMBER(AE29), ISNUMBER(AE30)), TRUNC(AE29*AE30,0), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(AF29), ISNUMBER(AF30)), TRUNC(AF29*AF30,0), \"\")","v":""},"","","",{"$f":"IF(AND(ISNUMBER(AJ29), ISNUMBER(AJ30)), TRUNC(AJ29*AJ30,0), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(AK29), ISNUMBER(AK30)), TRUNC(AK29*AK30,0), \"\")","v":""},"","","",null,"Deforestation (%)",{"$f":"IF(COUNT(K31,AQ$27)=0,\"\",IFERROR(SIGN(K31)*ABS(K31)/ABS(AQ$27),0))","v":""},{"$f":"IF(COUNT(L31,AR$27)=0,\"\",IFERROR(SIGN(L31)*ABS(L31)/ABS(AR$27),0))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment, if applicable (%)",{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(C55=\"\", \"\", C55), IF(COUNT(AE31, AQ$27)=0, \"\", IFERROR(SIGN(AE31)*ABS(AE31)/ABS(AQ$27), 0)))","v":""},{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(D55=\"\", \"\", D55), IF(COUNT(AF31, AR$27)=0, \"\", IFERROR(SIGN(AF31)*ABS(AF31)/ABS(AR$27), 0)))","v":""},{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(E55=\"\", \"\", E55), IF(COUNT(AG31, AS$27)=0, \"\", IFERROR(SIGN(AG31)*ABS(AG31)/ABS(AS$27), 0)))","v":""},{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(F55=\"\", \"\", F55), IF(COUNT(AH31, AT$27)=0, \"\", IFERROR(SIGN(AH31)*ABS(AH31)/ABS(AT$27), 0)))","v":""},{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\", IF(G55=\"\", \"\", G55), IF(COUNT(AI31, AU$27)=0, \"\", IFERROR(SIGN(AI31)*ABS(AI31)/ABS(AU$27), 0)))","v":""}]
[]
[null,"T.7","Total (tCO2-e) with adjustment ",null,null,null,null,null,"Total (tCO2-e) without adjustment ",null,null,null,null,null,null,"HFLD INSTRUCTIONS\n\nThese tables are only visible because you have:\n- Selected Yes in the Reference Sheet to label FCPF ERs as High Forest Low Deforestation (HFLD), and\n- Selected your preferred calculation approach for this Section 4.3 (Option 1).\n\nPurpose:\n- To clearly show the calculation of ERs with and without the HFLD adjustment.\n- To provide the annual and total breakdowns required for reporting under the ERPA.\n\nImportant Notes:\n- These values are automatically calculated based on the data you entered elsewhere in this workbook.\n- You do not need to edit any of the cells in these tables.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\",\n  \"Note: The sum of percentages above may not equal 100% because the adjustment value accounts for ERs already sold, used, or assigned under other schemes, \" &\n  \"which are excluded from the denominator of other percentages. This interpretation applies exclusively for HFLD programs.\",\n\"\")","v":""}]
[null,"Year",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","","Total RP",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","","Total RP"]
[null,"Emissions or Removals in the Reference Level (tCO2-e)",{"$f":"IF(C$35=\"\", \"\", SUM(K15,P15,U15,Z15,AE15))","v":""},{"$f":"IF(D$35=\"\", \"\", SUM(L15,Q15,V15,AA15,AF15))","v":""},"","","",{"$f":"SUM(C36:G36)","v":0},{"$f":"IF(OR(C36=\"\",C36=0),\"\",TRUNC(C36 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"IF(OR(D36=\"\",D36=0),\"\",TRUNC(D36 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"IF(OR(E36=\"\",E36=0),\"\",TRUNC(E36 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"IF(OR(F36=\"\",F36=0),\"\",TRUNC(F36 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"IF(OR(G36=\"\",G36=0),\"\",TRUNC(G36 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"SUM(I36:M36)","v":0}]
[null,"Emissions or Removals under the ER Program during the Reporting Period (tCO2-e)",{"$f":"IF(C$35=\"\", \"\", SUM(K16,P16,U16,Z16,AE16))","v":""},{"$f":"IF(D$35=\"\", \"\", SUM(L16,Q16,V16,AA16,AF16))","v":""},"","","",{"$f":"SUM(C37:G37)","v":0},{"$f":"C37","v":""},{"$f":"D37","v":""},"","","",{"$f":"SUM(I37:M37)","v":0}]
[null,"Emission Reductions during the Reporting Period (tCO2-e)",{"$f":"IF(C$35=\"\", \"\", SUM(K17,P17,U17,Z17,AE17))","v":""},{"$f":"IF(D$35=\"\", \"\", SUM(L17,Q17,V17,AA17,AF17))","v":""},"","","",0,{"$f":"IFERROR(TRUNC(I36 - I37, 0), \"\")","v":""},{"$f":"IFERROR(TRUNC(J36 - J37, 0), \"\")","v":""},"","","",{"$f":"SUM(I38:M38)","v":0}]
[null,"ERs sold, assigned or otherwise used by any other entity for sale, public relations, compliance or any other purpose including ERs accounted separately under other GHG accounting schemes or ERs that have been set-aside to meet Reversal management requirements under other GHG accounting schemes",{"$f":"IF(C$35=\"\", \"\", 'Reference Sheet'!C19)","v":""},{"$f":"IF(D$35=\"\", \"\", 'Reference Sheet'!D19)","v":""},{"$f":"IF(E$35=\"\", \"\", 'Reference Sheet'!E19)","v":""},{"$f":"IF(F$35=\"\", \"\", 'Reference Sheet'!F19)","v":""},{"$f":"IF(G$35=\"\", \"\", 'Reference Sheet'!G19)","v":""},{"$f":"SUM(C39:G39)","v":0},{"$f":"IF(I$35=\"\", \"\", 0)","v":""},{"$f":"IF(J$35=\"\", \"\", 0)","v":""},"","","",{"$f":"SUM(I39:M39)","v":0}]
[null,"Available Emission Reductions during the Reporting Period (tCO2-e)",{"$f":"IF(AND(ISNUMBER(C38),ISNUMBER(C39)),IF(AND(C38=0,C39=0),\"\",C38-C39),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D38),ISNUMBER(D39)),IF(AND(D38=0,D39=0),\"\",D38-D39),\"\")","v":""},"","","","",{"$f":"IFERROR(I38-I39,\"\")","v":""},{"$f":"IFERROR(J38-J39,\"\")","v":""},"","","",{"$f":"IF(SUMPRODUCT(--(I40:M40<>\"\"))=0,\"\",SUM(I40:M40))","v":""}]
[]
[null,"T.9 I Year",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","","Total RP"]
[null,"Emission Reductions from HFLD as a percentage of the total FCPF Ers (%)",{"$f":"IFERROR(IF(OR(ISBLANK(C40),ISBLANK(I40)),\"\",IF(I40>0,(C40-I40)/C40,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(D40),ISBLANK(J40)),\"\",IF(J40>0,(D40-J40)/D40,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(E40),ISBLANK(K40)),\"\",IF(K40>0,(E40-K40)/E40,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(F40),ISBLANK(L40)),\"\",IF(L40>0,(F40-L40)/F40,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(G40),ISBLANK(M40)),\"\",IF(M40>0,(G40-M40)/G40,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(H40),ISBLANK(N40)),\"\",IF(N40>0,(H40-N40)/H40,1)),\"\")","v":""}]
[null,"T.8","Total (tCO2-e) with adjustment",null,null,null,null,null,"Total (tCO2-e) without adjustment",null,null,null,null,null,null,"HFLD INSTRUCTIONS\n\nThese tables are only visible because you have:\n- Selected Yes in the Reference Sheet to label FCPF ERs as High Forest Low Deforestation (HFLD), and\n- Selected your preferred calculation approach for this Section 4.3 (Option 2).\n\nPurpose:\n- To clearly show the calculation of emission reductions with and without the HFLD adjustment.\n- To provide the annual and total breakdowns required for reporting under the ERPA.\n\nImportant Notes:\n- These values are automatically calculated based on the data you entered elsewhere in this workbook.\n- You do not need to edit any of the cells in these tables.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Reference Sheet'!$D$11=\"Option 1\",\n  \"Note: The sum of percentages above may not equal 100% because the adjustment value accounts for ERs already sold, used, or assigned under other schemes, \" &\n  \"which are excluded from the denominator of other percentages. This interpretation applies exclusively for HFLD programs.\",)","v":0}]
[null,"Year",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","","Total RP",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","","Total RP"]
[null,"Emissions or Removals in the Reference Level (tCO2-e)",{"$f":"IF(C$45=\"\", \"\", SUM(K27,P27,U27,Z27,AE27))","v":""},{"$f":"IF(D$45=\"\", \"\", SUM(L27,Q27,V27,AA27,AF27))","v":""},"","","",{"$f":"SUM(C46:G46)","v":0},{"$f":"IF(OR(C46=\"\",C46=0),\"\",TRUNC(C46 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"IF(OR(D46=\"\",D46=0),\"\",TRUNC(D46 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"IF(OR(E46=\"\",E46=0),\"\",TRUNC(E46 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"IF(OR(F46=\"\",F46=0),\"\",TRUNC(F46 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"IF(OR(G46=\"\",G46=0),\"\",TRUNC(G46 - 'Reference Sheet'!$C$16,0))","v":""},{"$f":"SUM(I46:M46)","v":0}]
[null,"Emissions or Removals under the ER Program during the Reporting Period (tCO2-e)",{"$f":"IF(C$45=\"\", \"\", SUM(K28,P28,U28,Z28,AE28))","v":""},{"$f":"IF(D$45=\"\", \"\", SUM(L28,Q28,V28,AA28,AF28))","v":""},"","","",{"$f":"SUM(C47:G47)","v":0},{"$f":"C47","v":""},{"$f":"D47","v":""},{"$f":"E47","v":""},{"$f":"F47","v":""},{"$f":"G47","v":""},{"$f":"SUM(I47:M47)","v":0}]
[null,"Emission Reductions during the Monitoring Period (tCO2-e)",{"$f":"IF(C$45=\"\", \"\", SUM(K29,P29,U29,Z29,AE29))","v":""},{"$f":"IF(D$45=\"\", \"\", SUM(L29,Q29,V29,AA29,AF29))","v":""},"","","",0,{"$f":"IFERROR(TRUNC((+I46-I47),0),\"\")","v":""},{"$f":"IFERROR(TRUNC((+J46-J47),0),\"\")","v":""},"","","",{"$f":"SUM(I48:M48)","v":0}]
[null,"Length of the Reporting period / Length of the Monitoring Period (# days/# days)",{"$f":"TRANSPOSE(IFERROR(IF((('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)=0)+ISBLANK('Reference Sheet'!C36:C40)+ISBLANK('Reference Sheet'!D36:D40),\"\",'Reference Sheet'!E28:E32/('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)),\"\"))","v":""},"","","","",null,{"$f":"TRANSPOSE(IFERROR(IF((('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)=0)+ISBLANK('Reference Sheet'!C36:C40)+ISBLANK('Reference Sheet'!D36:D40),\"\",'Reference Sheet'!E28:E32/('Reference Sheet'!D36:D40-'Reference Sheet'!C36:C40+1)),\"\"))","v":""},"","","",""]
[null,"Emission Reductions during the Reporting Period (tCO2-e)",{"$f":"IF(AND(ISNUMBER(C48), ISNUMBER(C49)), TRUNC(C48*C49,0), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(D48), ISNUMBER(D49)), TRUNC(D48*D49,0), \"\")","v":""},"","","",{"$f":"SUM(C50:G50)","v":0},{"$f":"IF(AND(ISNUMBER(I48), ISNUMBER(I49)), TRUNC(I48*I49,0), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(J48), ISNUMBER(J49)), TRUNC(J48*J49,0), \"\")","v":""},"","","",{"$f":"SUM(I50:M50)","v":0}]
[null,"ERs sold, assigned or otherwise used by any other entity for sale, public relations, compliance or any other purpose including ERs accounted separately under other GHG accounting schemes or ERs that have been set-aside to meet Reversal management requirements under other GHG accounting schemes",{"$f":"IF(C$45=\"\", \"\", 'Reference Sheet'!C19)","v":""},{"$f":"IF(D$45=\"\", \"\", 'Reference Sheet'!D19)","v":""},{"$f":"IF(E$45=\"\", \"\", 'Reference Sheet'!E19)","v":""},{"$f":"IF(F$45=\"\", \"\", 'Reference Sheet'!F19)","v":""},{"$f":"IF(G$45=\"\", \"\", 'Reference Sheet'!G19)","v":""},{"$f":"SUM(C51:G51)","v":0},{"$f":"IF(I$45=\"\", \"\", 0)","v":""},{"$f":"IF(J$45=\"\", \"\", 0)","v":""},"","","",{"$f":"SUM(J51:M51)","v":0}]
[null,"Available Emission Reductions during the Reporting Period (tCO2-e)",{"$f":"IF(AND(ISNUMBER(C50),ISNUMBER(C51)),IF(AND(C50=0,C51=0),\"\",C50-C51),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D50),ISNUMBER(D51)),IF(AND(D50=0,D51=0),\"\",D50-D51),\"\")","v":""},"","","","",{"$f":"IF(AND(ISNUMBER(I50),ISNUMBER(I51)),IF(AND(I50=0,I51=0),\"\",I50-I51),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J50),ISNUMBER(J51)),IF(AND(J50=0,J51=0),\"\",J50-J51),\"\")","v":""},"","","",{"$f":"IF(SUMPRODUCT(--(I40:M40<>\"\"))=0,\"\",SUM(I40:M40))","v":""}]
[]
[null,"T.9 I Year",{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","","Total RP"]
[null,"Emission Reductions from HFLD as a percentage of the total FCPF Ers (%)",{"$f":"IFERROR(IF(OR(ISBLANK(C52),ISBLANK(I52)),\"\",IF(I52>0,(C52-I52)/C52,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(D52),ISBLANK(J52)),\"\",IF(J52>0,(D52-J52)/D52,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(E52),ISBLANK(K52)),\"\",IF(K52>0,(E52-K52)/E52,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(F52),ISBLANK(L52)),\"\",IF(L52>0,(F52-L52)/F52,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(G52),ISBLANK(M52)),\"\",IF(M52>0,(G52-M52)/G52,100%)),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(H52),ISBLANK(N52)),\"\",IF(N52>0,(H52-N52)/H52,1)),\"\")","v":""}]

{"sheet":"Section 7.2","index":5,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,9,5,13],[1,1,2,6],[29,4,30,4],[29,5,30,5],[29,6,30,6],[4,1,4,6],[5,1,5,6],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6],[32,3,33,3],[34,3,35,3],[36,3,37,3],[29,2,30,2],[27,1,27,3],[29,1,30,1],[29,3,30,3]]}
[]
[null,"Section 7.2 - Quantification of Reversals during the Reporting Period\nAlways Copy and Paste using Match Destination Formatting or Paste Values",null,null,null,null,null,null,null,"Note:\n\nThis section is optional and should only be completed if the ER Program is reporting reversal events for the current Reporting Period.\n\nIf no reversal events occurred, leave this section blank."]
[]
[]
[null,"Using the table below, please confirm and quantify any Reversals of ERs that might have occurred during the Reporting Period. "]
[null,"Refer to indicator 19.1 of the Methodological Framework and the FCPF ER Program Buffer Guidelines."]
[]
[]
[null,"A.","ER Program Reference level for this Reporting Period (tCO2-e)","from section 4.1",null,{"$f":"'Section 4.1'!$H$27","v":""}]
[]
[null,"B.","ER Program Reference level for all previous Reporting Periods in the ERPA (tCO2-e).","from section 4.1 of previous ER Monitoring Reports",null,null,"+",null,"Please enter this value manually, if applicable"]
[]
[null,"C.","Cumulative Reference Level Emissions for all Reporting Periods [A + B]",null,null,{"$f":"IF(COUNT(F9, F11)=0, \"\", IFERROR(F9+F11, 0))","v":""}]
[]
[null,"D.","Estimation of Emissions by Sources and Removals by Sinks for this Reporting Period (tCO2-e) ","from section 4.2",null,{"$f":"'Section 4.2'!$G$29","v":""}]
[]
[null,"E.","Estimation of Emissions by Sources and Removals by Sinks for all previous Reporting Periods in the ERPA (tCO2-e) ","From section 4.2 of previous ER Monitoring Reports",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"F.","Cumulative Emissions by Sources and Removals by Sinks including the current Reporting Period (as an aggregate accumulated since the Crediting Period Start Date) [D + E] ",null,null,{"$f":"IF(COUNT(F15, F17)=0, \"\", IFERROR(F15+F17, 0))","v":""},"_"]
[]
[null,"G.","Cumulative quantity of Total ERs estimated including the current Reporting Period (as an aggregate of ERs accumulated since the Crediting Period Start Date) [C – F] ",null,null,{"$f":"IF(COUNT(F13, F19)=0, \"\", IFERROR(F13-F19, 0))","v":""}]
[]
[]
[null,"H.","Cumulative quantity of Total ERs estimated for prior Reporting Periods (as an aggregate of ERs accumulated since the Crediting Period Start Date) ","from previous ER Monitoring Reports",null,null,"_",null,"Please enter this value manually, if applicable"]
[]
[null,"I.","[G – H], negative number indicates Reversals ",null,null,{"$f":"IF(COUNT(F21, F24)=0, \"\", IFERROR(F21-F24, 0))","v":""}]
[]
[null,"If I. above is negative and Reversals have occurred complete the following:"]
[]
[null,"J.","Cumulative quantity FCPF ERs (as an aggregate of FCPF ERs accumulated since the Crediting Period Start Date) ","from previous ER monitoring reports, section 8",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[]
[null,"K.","Cumulative ER Program´s Pooled Reversal Buffer contributions (as an aggregate of Pooled Reversal Buffer ERs accumulated since the Crediting Period Start Date) ","from previous ER monitoring reports, section 8",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"L.","Cumulative ER Program´s Uncertainty Buffer contributions (as an aggregate of Uncertainty Buffer ERs accumulated since the Crediting Period Start Date) ","from previous ER monitoring reports, section 8",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"M.","Cumulative ER Program´s Pooled Reversal Buffer replenishments (as an aggregate of Reversal Buffer ERs replenished since the Crediting Period Start Date) ","from previous ER monitoring reports, section 7.3",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"N.","Cumulative amount of FCPF ERs, Uncertainty and Pooled Reversal Buffer contributions and replenishments (as an aggregate since the Crediting Period Start Date) [J + K + L + M] ",null,null,{"$f":"F30+F33+F35+F37","v":0}]
[]
[null,"O.","Quantity of Buffer ERs to be canceled from the Pooled Reversal Buffer account [If I < N, report the value of I; if I > N, report the value of N] ",null,null,{"$f":"IFERROR(IF(ABS(F26)<=F39,F26,F39),\"0\")","v":"0"}]

{"sheet":"Section 7.3","index":6,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,1,4,6],[5,1,5,6],[32,1,32,6],[1,1,2,6],[1,9,5,13]]}
[]
[null,"Section 7.3 - Quantification of ooled reversal buffer replenishments \nAlways Copy and Paste using Match Destination Formatting or Paste Values",null,null,null,null,null,null,null,"Note:\n\nThis section is optional and should only be completed if the ER Program has to quantify the amount of Pooled Reversal Buffer replenishments for the current Reporting Period.\n\nIf no reversal events occurred, leave this section blank."]
[]
[]
[null,"Using the table below, please confirm and quantify the amount of Pooled Reversal Buffer replenishments applicable in the current Reporting Period."]
[null,"Refer to Indicator 19 of the Methodological Framework and the FCPF ER Program Buffer Guidelines."]
[]
[]
[null,"A.","Emission Reductions during the Reporting period (tCO2-e)","from section 4.3",null,{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!H17,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!H31,\"\"))","v":""}]
[]
[null,"B.","If applicable, number of Emission Reductions from reducing forest degradation that have been estimated using proxy-based estimation approaches (use zero if not applicable)",null,null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"C.","Number of Emission Reductions estimated using measurement approaches (A-B)",null,null,{"$f":"IF(COUNT(F9, F11)=0, \"\", IFERROR(F9-F11, 0))","v":""}]
[]
[null,"D.","Percentage of ERs (A) for which the ability to transfer Title to ERs is clear or uncontested ","from section 6.1",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"E.","ERs sold, assigned or otherwise used by any other entity for sale, public relations, compliance or any other purpose including ERs accounted separately under other GHG accounting schemes or ERs that have been set-aside to meet Reversal management requirements under other GHG accounting schemes ","from section 6.4",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"F.","Cumulative Pooled Reversal Buffer cancellations (as an aggregate since the Crediting Period Start Date) ","from previous ER Monitoring Reports section 7.2, O",null,{"$f":"'Section 7.2'!F41","v":"0"}]
[]
[null,"G.","Cumulative ER Program´s Pooled Reversal Buffer contributions (as an aggregate of Pooled Reversal Buffer ERs accumulated since the Crediting Period Start Date)","from previous ER Monitoring Reports, section 8",null,{"$f":"'Section 7.2'!F33","v":0}]
[]
[null,"H.","Proportion of cumulative Pooled Reversal Buffer cancellations/cumulative Pooled Reversal Buffer contributions [F / G] ",null,null,{"$f":"IF(COUNT(F19, F21)=0, \"\", IFERROR(F19/F21, 0))","v":0}]
[]
[null,"I.","Year of the Crediting Period where the latest Reversal took place (e.g., 1,2,3…) ","from previous ER Monitoring Reports",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"J.","Cumulative Pooled Reversal Buffer cancellations (as an aggregate since the Crediting Period Start Date) ","from previous ER Monitoring Reports and section 7.2, O ",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"K.","Cumulative previous Pooled Reversal Buffer replenishments (as an aggregate since the Crediting Period Start Date) ","from previous ER Monitoring Reports, section 7.3 Q ",null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"L. ","Proportion of cumulative previous Pooled Reversal Buffer replenishments/cumulative Pooled Reversal Buffer cancellations [K / J] ",null,null,{"$f":"IF(COUNT(F29, F27)=0, \"\", IFERROR(F29/F27, 0))","v":""}]
[]
[null,"Complete either a), b) or c) below, depending on the situation, to estimate the amount of the replenishment:"]
[]
[null,"M.","a)       If L < 0.5, Pooled Buffer replenishments equal (B+C)*D-E, noting that the replenishment should not be larger than the value of J-K ",null,null,{"$f":"IF(F31<0.5,MIN((((F11+F13)*F15)-F17)/100,F27-F29),\"0\")","v":"0"}]
[]
[null,"N.","b)       If L> 0.5, indicate the percentage of ERs generated that you wish to convert to Total ERs [0 to 0.3] ",null,null,null,null,null,"Please enter this value manually, if applicable"]
[]
[null,"O.","Pooled Buffer replenishments [(B+C)*(D-E)*N], noting that the replenishment should not be larger than the absolute value of J-K ",null,null,{"$f":"IFERROR(IF(F31>0.5,(F11+F13)*(F15-F17)*F37,\"0\"),\"0\")","v":"0"}]
[]
[null,"P.","c)       If the latest Reversal has taken place from the third year of the Crediting Period on (as per L above) or if it represents more than 50% of the current net Pooled Reversal Buffer contributions (as per H above), Pooled Buffer replenishments equal (B+C)*D-E, noting that the replenishment should not be larger than the absolute value of J-K ",null,null,{"$f":"IF(OR(F25>=3,F23>0.5),(F11+F13)*(F15-F17)/100,\"0\")","v":"0"}]
[]
[null,"Q.","Total Pooled Reversal Buffer replenishment for the Reporting Period ",null,null,{"$f":"IFERROR(IF(F35+F39+F41 > F19-F27, F19-F27, (F11+F13)*F15-F17), 0)","v":0}]

{"sheet":"Section 8","index":7,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[31,11,33,14],[28,1,28,9],[30,1,30,9],[4,1,4,4],[18,1,18,9],[20,1,20,9],[22,1,22,9],[24,1,24,9],[26,1,26,9],[8,2,8,9],[10,1,10,9],[12,1,12,9],[14,1,14,9],[16,1,16,9],[6,1,6,3],[34,1,34,9],[36,1,36,9],[1,1,2,7]]}
[]
[null,"Section 8 - Emission Reductions available for transfer to the Carbon Fund\nAlways Copy and Paste using Match Destination Formatting or Paste Values"]
[]
[]
[null,"Quantify the emission reductions available for transfer to the Carbon Fund by completing the white cells in the table below. Additional columns may be added if the country wishes to report in separate calendar years. If it does not wish to report per calendar years, the FCPF units will be distributed per calendar years pro-rata to the number of years at the time of issuance. Separation in calendar years is only applicable if the Emission Reductions in all the years of the Reporting Period are positive."]
[]
[null,"Year",null,null,{"$f":"TRANSPOSE(IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47))","v":""},"","","","","TOTAL"]
[null,"A.","Emission Reductions during the Reporting period (tCO2-e)","from section 4.3",{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!AQ15,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!AQ27,\"\"))","v":""},{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!AR15,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!AR27,\"\"))","v":""},{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!AS15,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!AS27,\"\"))","v":""},{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!AT15,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!AT27,\"\"))","v":""},{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!AU15,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!AU27,\"\"))","v":""},{"$f":"SUM(E8:I8)","v":0}]
[]
[null,"B. ","If applicable, number of Emission Reductions from reducing forest degradation that have been estimated using proxy-based estimation approaches (use zero if not applicable)",null,null,null,null,null,null,{"$f":"SUM(E10:I10)","v":0},null,"Please enter this value manually, if applicable"]
[]
[null,"C.","Number of Emission Reductions estimated using measurement approaches (A-B)",null,{"$f":"IF(OR(ISNUMBER(E8), ISNUMBER(E10)), E8-E10, \"\")","v":""},{"$f":"IF(OR(ISNUMBER(F8), ISNUMBER(F10)), F8-F10, \"\")","v":""},"","","",{"$f":"SUM(E12:I12)","v":0}]
[]
[null,"D.","Percentage of ERs (A) for which the ability to transfer Title to ERs is clear or uncontested","from section 6.1",null,null,null,null,null,null,null,"Please enter this value manually"]
[]
[null,"E.","ERs sold, assigned or otherwise used by any other entity for sale, public relations, compliance or any other purpose including ERs accounted separately under other GHG accounting schemes or ERs that have been set-aside to meet Reversal management requirements under other GHG accounting schemes","from section 6.4",null,null,null,null,null,{"$f":"SUM(E16:I16)","v":0},null,"If you selected Option 2 in the Reference Sheet cell D11, please enter this value manually, if applicable"]
[]
[null,null,"If applicable, any buffer replenishments","section 7.3 P",null,null,null,null,null,{"$f":"SUM(E18:I18)","v":0},null,"Please enter this value manually, if applicable"]
[]
[null,"F.","Total ERs [(B+C)*D-E] minus, if applicable, any replenishments as per section 7.3, P",null,{"$f":"IFERROR(TRUNC((((E10+E12)*E14-E16)-E18),0),\"\")","v":""},{"$f":"IFERROR(TRUNC((((F10+F12)*F14-F16)-F18),0),\"\")","v":""},"","","",{"$f":"SUM(E20:I20)","v":0}]
[]
[null,"G.","Conservativeness Factor to reflect the level of uncertainty from non-proxy based approaches associated with the estimation of ERs during the Crediting Period","from section 5.2",null,null,null,null,null,null,null,"Please select this value from dropdown"]
[]
[null,"H.","Quantity of ERs to be allocated to the Uncertainty Buffer (0.15*B/A*F)+(G*C/A*F)",null,{"$f":"IFERROR(TRUNC((0.15*E10/E8*E20)+(E22*E12/E8*E20),0),\"\")","v":""},{"$f":"IFERROR(TRUNC((0.15*F10/F8*F20)+(F22*F12/F8*F20),0),\"\")","v":""},"","","",{"$f":"SUM(E24:I24)","v":0}]
[]
[null,"I.","Total Reversal Risk set-aside percentage applied to the ER program ","from section 7.4",null,null,null,null,null,null,null,"Please enter this value manually"]
[]
[null,"J.","Quantity of ERs to be allocated to the Pooled Reversal Buffer (F-H)*I",null,{"$f":"IFERROR(TRUNC(((E20-E24)*E26),0),\"\")","v":""},{"$f":"IFERROR(TRUNC(((F20-F24)*F26),0),\"\")","v":""},"","","",{"$f":"SUM(E28:I28)","v":0}]
[]
[null,"K.","Number of FCPF ERs (F- H – J)",null,{"$f":"IFERROR((E20-E24-E28),\"\")","v":""},{"$f":"IFERROR((F20-F24-F28),\"\")","v":""},"","","",{"$f":"SUM(E30:I30)","v":0}]
[]
[null,"L.","Percentage of Emission reductions from enhanced removals from afforestation/reforestation as a percentage of the total FCPF ERs [Optional if the country wishes to generate enhanced removals]","From section 4.3",{"$f":"IF(E7=\"\", \"\", IF('Section 4.3'!$D$5=\"Option 1\", IF(OR('Section 4.3'!C17<0, 'Section 4.3'!D17<0), 0, 'Section 4.3'!AQ16), IF('Section 4.3'!$D$5=\"Option 2\", IF(OR('Section 4.3'!C31<0, 'Section 4.3'!D31<0), 0, 'Section 4.3'!AQ28), \"\")))","v":""},{"$f":"IF(F7=\"\", \"\", IF('Section 4.3'!$D$5=\"Option 1\", IF(OR('Section 4.3'!C17<0, 'Section 4.3'!D17<0), 0, 'Section 4.3'!AR16), IF('Section 4.3'!$D$5=\"Option 2\", IF(OR('Section 4.3'!C31<0, 'Section 4.3'!D31<0), 0, 'Section 4.3'!AR28), \"\")))","v":""},{"$f":"IF(G7=\"\", \"\", IF('Section 4.3'!$D$5=\"Option 1\", IF(OR('Section 4.3'!C17<0, 'Section 4.3'!D17<0), 0, 'Section 4.3'!AS16), IF('Section 4.3'!$D$5=\"Option 2\", IF(OR('Section 4.3'!C31<0, 'Section 4.3'!D31<0), 0, 'Section 4.3'!AS28), \"\")))","v":""},{"$f":"IF(H7=\"\", \"\", IF('Section 4.3'!$D$5=\"Option 1\", IF(OR('Section 4.3'!C17<0, 'Section 4.3'!D17<0), 0, 'Section 4.3'!AT16), IF('Section 4.3'!$D$5=\"Option 2\", IF(OR('Section 4.3'!C31<0, 'Section 4.3'!D31<0), 0, 'Section 4.3'!AT28), \"\")))","v":""},{"$f":"IF(I7=\"\", \"\", IF('Section 4.3'!$D$5=\"Option 1\", IF(OR('Section 4.3'!C17<0, 'Section 4.3'!D17<0), 0, 'Section 4.3'!AU16), IF('Section 4.3'!$D$5=\"Option 2\", IF(OR('Section 4.3'!C31<0, 'Section 4.3'!D31<0), 0, 'Section 4.3'!AU28), \"\")))","v":""},null,null,"Enhanced Removals Label Eligibility\n\nPer FCPF guidance, estimating “Enhanced Removals from Afforestation/Reforestation as a % of Total FCPF ERs” is optional and only permitted when both deforestation and forest degradation emission reductions exceed zero. Accordingly, the worksheet’s row 32 formula first verifies that the ERs for deforestation (Section 4.3 C17 or C31) and for forest degradation (Section 4.3 D17 or D31) are more than zero; if either is negative, the formula returns zero, thereby preventing the application of the enhanced removals label."]
[]
[null,"M","Number of FCPF ERs from enhanced removals from afforestation/reforestation (L * K) [Optional if the country wishes to generate enhanced removals]",null,{"$f":"IFERROR(TRUNC((E32*E30),0),\"\")","v":""},{"$f":"IFERROR(TRUNC((F32*F30),0),\"\")","v":""},"","","",{"$f":"SUM(E34:I34)","v":0}]
[]
[null,"N","Percentage of Emission Reductions from HFLD [Optional if the country wishes to label HFLD units]","From section 4.3",{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!C43,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!C55,\"\"))","v":""},{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!D43,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!D55,\"\"))","v":""},{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!E43,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!E55,\"\"))","v":""},{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!F43,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!F55,\"\"))","v":""},{"$f":"IF('Section 4.3'!$D$5=\"Option 1\",'Section 4.3'!G43,IF('Section 4.3'!$D$5=\"Option 2\",'Section 4.3'!G55,\"\"))","v":""}]
[]
[null,"O","Number of FCPF ERs from HFLD (N * K) [Optional if the country wishes to label HFLD units]",null,{"$f":"IFERROR(TRUNC((E36*E30),0),\"\")","v":""},{"$f":"IFERROR(TRUNC((F36*F30),0),\"\")","v":""},"","","",{"$f":"SUM(E38:I38)","v":0}]

{"sheet":"Annex 4 Section 8.4","index":8,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,2,7],[10,1,11,3],[10,4,11,6],[23,1,24,3],[23,4,24,6],[4,1,4,2],[4,5,8,7],[5,1,8,2]]}
[]
[null,"Annex 4 Section 8.4 - Estimated Reference Level"]
[]
[]
[null,"Select the Applicable Option:",null,"Select Option",{"$f":"IF(D5=\"Select Option\", \"⚠️ Please select a valid Option\", \"\")","v":"⚠️ Please select a valid Option"},"INSTRUCTIONS\n\nImportant: This worksheet is only applicable for the First ER-Monitoring Report under the ERPA.\n\nIf this is the second or subsequent Monitoring Report, do not truncate these values. Instead, you must copy exactly the official figures published in the first ER-Monitoring Report documentation (Word/PDF), to ensure consistency and traceability.\n"]
[null,"Please select the calculation approach for this section using the dropdown menu:\n- Option 1: This is the first ER-Monitoring Report under the ERPA. \n- Option 2: This is the second or subsequent ER-Monitoring Report under the ERPA. \nNote: Only one option can be used. The table for the other option will be hidden automatically based on your selection."]
[]
[]
[]
[]
[null," Input Data (With Decimals)\nAlways Copy and Paste using Match Destination Formatting or Paste Values",null,null,"1. Copy and paste the original values here with all decimals, as reported in the ER Program’s own calculation spreadsheet (i.e. the national spreadsheet developed by the ER Program). Fill out the cells highlighted in red.\nIf a value is not applicable, enter “0” instead of leaving the cell blank.\nOnce filled, red cells will turn blue to indicate that they remain editable (as opposed to white, which are locked).\n2. Do not manually truncate, please."]
[]
[]
[null,"Year of Monitoring / Reporting Period t ","Average annual historical Emissions from deforestation over the Reference Period (tCO2-e/yr)","If applicable, average annual historical Emissions from forest degradation over the Reference Period (tCO2-e/yr)","If applicable, average annual historical enhanced Removals from afforestation/reforestation (A/R) (tCO2-e/yr)","If applicable, average annual historical enhanced Removals from other activities besides A/R (tCO2-e/yr)","Adjustment, if applicable (tCO2-e/yr)","Reference Level (tCO2-e/yr)"]
[null,{"$f":"IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47)","v":""},null,null,null,null,null,{"$f":"IF(COUNT($C15, $D15, $E15, $F15, $G15)=0, \"\", SUM($C15:$G15))","v":""}]
[null,"",null,null,null,null,null,{"$f":"IF(COUNT($C16, $D16, $E16, $F16, $G16)=0, \"\", SUM($C16:$G16))","v":""}]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"Total",{"$f":"IF(COUNTA($C$15:$C$19)=0, \"\", SUM($C$15:$C$19))","v":""},{"$f":"IF(COUNTA($D$15:$D$19)=0, \"\", SUM($D$15:$D$19))","v":""},{"$f":"IF(COUNTA($E$15:$E$19)=0, \"\", SUM($E$15:$E$19))","v":""},{"$f":"IF(COUNTA($F$15:$F$19)=0, \"\", SUM($F$15:$F$19))","v":""},{"$f":"IF(COUNTA($G$15:$G$19)=0, \"\", SUM($G$15:$G$19))","v":""},""]
[null,null,{"$f":"SUMPRODUCT(($B$15:$B$19<>\"\")*(C15:C19=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$15:$B$19<>\"\")*(D15:D19=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$15:$B$19<>\"\")*(E15:E19=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$15:$B$19<>\"\")*(F15:F19=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$15:$B$19<>\"\")*(G15:G19=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$15:$B$19<>\"\")*(H15:H19=\"\"))","v":0}]
[]
[]
[null,"Adjusted Data (Truncated Automatically)",null,null,"1. Values to be used in the ER-MR with decimals adjusted automatically.\n2. Do not make manual modifications. The table below is protected, no modifications are allowed.\n3. Copy and paste is permitted. "]
[]
[]
[null,"Year of Monitoring / Reporting Period t ","Average annual historical Emissions from deforestation over the Reference Period (tCO2-e/yr)","If applicable, average annual historical Emissions from forest degradation over the Reference Period (tCO2-e/yr)","If applicable, average annual historical enhanced Removals from afforestation/reforestation (A/R) (tCO2-e/yr)","If applicable, average annual historical enhanced Removals from other activities besides A/R (tCO2-e/yr)","Adjustment, if applicable (tCO2-e/yr)","Reference Level (tCO2-e/yr)","Reference level without adjustment (tCO2-e/yr)"]
[null,{"$f":"IF('Reference Sheet'!$B$43:$B$47=0,\"\",'Reference Sheet'!$B$43:$B$47)","v":""},{"$f":"IF(C15=\"\",\"\",TRUNC(C15,0))","v":""},"","","","",{"$f":"IF(SUM(C28:G28)=0,\"\",SUM(C28:G28))","v":""},{"$f":"IF(OR(H28=\"\",H28=0),\"\",TRUNC(H28 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"","","","","","",{"$f":"IF(SUM(C29:G29)=0,\"\",SUM(C29:G29))","v":""},{"$f":"IF(OR(H29=\"\",H29=0),\"\",TRUNC(H29 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"","","","","","","",{"$f":"IF(OR(H30=\"\",H30=0),\"\",TRUNC(H30 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"","","","","","","",{"$f":"IF(OR(H31=\"\",H31=0),\"\",TRUNC(H31 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"","","","","","","",{"$f":"IF(OR(H32=\"\",H32=0),\"\",TRUNC(H32 - 'Reference Sheet'!$C$16,0))","v":""}]
[null,"Total",{"$f":"IF(SUMPRODUCT(--($C$28:$C$32<>\"\"))=0, \"\", SUM($C$28:$C$32))","v":""},{"$f":"IF(SUMPRODUCT(--($D$28:$D$32<>\"\"))=0, \"\", SUM($D$28:$D$32))","v":""},{"$f":"IF(SUMPRODUCT(--($E$28:$E$32<>\"\"))=0, \"\", SUM($E$28:$E$32))","v":""},{"$f":"IF(SUMPRODUCT(--($F$28:$F$32<>\"\"))=0, \"\", SUM($F$28:$F$32))","v":""},{"$f":"IF(SUMPRODUCT(--($G$28:$G$32<>\"\"))=0, \"\", SUM($G$28:$G$32))","v":""},{"$f":"IF(SUM($H$28:$H$32)=0,\"\",SUM($H$28:$H$32))","v":""},{"$f":"IF(SUM($I$28:$I$32)=0,\"\",SUM($I$28:$I$32))","v":""}]
[null,null,{"$f":"SUMPRODUCT(($B$28:$B$32<>\"\")*(C28:C32=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$28:$B$32<>\"\")*(D28:D32=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$28:$B$32<>\"\")*(E28:E32=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$28:$B$32<>\"\")*(F28:F32=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$28:$B$32<>\"\")*(G28:G32=\"\"))","v":0},{"$f":"SUMPRODUCT(($B$28:$B$32<>\"\")*(H28:H32=\"\"))","v":0}]

{"sheet":"Support sheet (hidden)","index":9,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,1,2,6]]}
[]
[null,"SUPPORT SHEET"]
[]
[]
[null,"Years of Monitoring",null,"Section 4.3 Options",null,"Dates"]
[null,null,null,"Select Option",null,"2015-01-01"]
[null,2015,null,"Option 1",null,"2029-12-31"]
[null,2016,null,"Option 2"]
[null,2017]
[null,2018]
[null,2019]
[null,2020]
[null,2021]
[null,2022]
[null,2023]
[null,2024]
[null,2025]