{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["User's instructions","Data Input","Data","ES-Indic","ES-Scores","ES-Synth table","Outcomes","Profile","colors","Dimension (FR)","Dimension (UK)","Dimension Outcomes","Scoring","Methodology","DimOutput","DimIndic","DimPillar"],"not_rendered":{"charts":12,"images":4,"macros":1,"external_links":0,"defined_names":16,"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":"User's instructions","index":0,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"1. Unblock the Excel file after downloading the Excel file from the Internet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"More detailed instructions are available on the following link: : https://www.buyexceltemplates.com/pages/excel-unblock-file-properties-windows-10-after-downloading-internet"]
[]
[]
[null,null,"2. Click on the \"Refresh\" button in the top left-hand corner of some graph sheets to refresh the graphs after updating the data (see example below)."]

{"sheet":"Data Input","index":1,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,7,4,7]]}
[]
[null,null,null,null,{"$f":"Profile!E2","v":"Team leader"},null,null,null,null,null,null,null,null,"PEFA CLIMATE ASSESSMENT "]
[null,null,null,null,{"$f":"Profile!E3","v":"Country"},"Pefalia"]
[null,null,null,null,{"$f":"Profile!E4","v":"Year of assessment"},2021]
[]
[null,null,null,null,null,"Global score",{"$f":"IFERROR(AVERAGEIFS(J12:J36,$D12:$D36,\"Indic\",J12:J36,\">0\"),0)","v":1.25},{"$f":"AVERAGEIFS(K12:K36,$D12:$D36,\"Indic\",K12:K36,\">0\")","v":1.2142857142857142}]
[null,null,null,null,null,"Global score",{"$f":"IF(G6>3.65,\"A\",\nIF(G6>=3.25,\"B+\",\nIF(G6>2.65,\"B\",\nIF(G6>=2.25,\"C+\",\nIF(G6>1.75,\"C\",\nIF(G6>1.25,\"D+\",\nIF(AND(G6<=1.25,G6>0),\"D\",\n\"NA\"\n)))))))","v":"D"},{"$f":"IF(H6>=3.25,\"ADVANCED\",\nIF(H6>=3,\"GOOD\",\nIF(H6>=2,\"BASIC\",\nIF(H6>=1,\"BELOW BASIC\",\n\"\"\n))))","v":"BELOW BASIC"}]
[]
["Country","ID","Method","Type","Indic","Label",{"$f":"IF(I4=\"\",\" \",I4)","v":" "},{"$f":"F4","v":2021},"Comparable",{"$f":"\"Num_Temp\"","v":"Num_Temp"},{"$f":"\"Num-\"&$H9","v":"Num-2021"},{"$f":"\"Perf-\"&$H9","v":"Perf-2021"},"Evol","Justification","Legislation","Procedures","Section"]
[{"$f":"$F$3","v":"Pefalia"},1,"M1","Indic","CRPFM-1",{"$f":"VLOOKUP(B10,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"1 Budget alignment with climate change strategies "},{"$f":"IF(G11=\"\",\"\",G11)","v":""},{"$f":"IF(J10>3.65,\"A\",\nIF(J10>=3.25,\"B+\",\nIF(J10>2.65,\"B\",\nIF(J10>=2.25,\"C+\",\nIF(J10>1.75,\"C\",\nIF(J10>1.25,\"D+\",\nIF(AND(J10<=1.25,J10>0),\"D\",\n\"NA\"\n)))))))","v":"B"},{"$f":"I11","v":"Yes"},{"$f":"IF($C10=\"M1\",IF(AVERAGE(J11)=MIN(J11),J11,MIN(J11)+0.5),AVERAGE(J11))","v":3},{"$f":"IF($H10=\"D\",1,\nIF($H10=\"D+\",1.5,\nIF($H10=\"C\",2,\nIF($H10=\"C+\",2.5,\nIF($H10=\"B\",3,\nIF($H10=\"B+\",3.5,\nIF($H10=\"A\",4,\n)))))))","v":3},{"$f":"IF(H10=\"D\",\"1. BELOW BASIC\",\nIF(H10=\"D+\",\"1. BELOW BASIC\",\nIF(H10=\"C\",\"2. BASIC\",\nIF(H10=\"C+\",\"2. BASIC\",\nIF(H10=\"B+\",\"3. SOUND\",\nIF(H10=\"B\",\"3. SOUND\",\nIF(H10=\"A\",\"4. HIGH\",\"\")))))))","v":"3. SOUND"},null,null,null,null,{"$f":"Q11","v":1}]
["Pefalia",1.1000000000000001,null,"Comp","CRPFM-1",{"$f":"VLOOKUP(B11,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"1.1 Budget alignment with climate change strategies"},null,"B","Yes",{"$f":"IF(TRIM(CLEAN(H11))=\"A\",4)+IF(TRIM(CLEAN(H11))=\"B+\",3.5)+IF(TRIM(CLEAN(H11))=\"B\",3)+IF(TRIM(CLEAN(H11))=\"C+\",2.5)+IF(TRIM(CLEAN(H11))=\"C\",2)+IF(TRIM(CLEAN(H11))=\"D+\",1.5)+IF(TRIM(CLEAN(H11))=\"D\",1)+IF(TRIM(CLEAN(H11))=\"D*\",1)+IF(TRIM(CLEAN(H11))=\"NU\",0)+IF(TRIM(CLEAN(H11))=\"NA\",0)","v":3},{"$f":"IF(TRIM(CLEAN(H11))=\"A\",4)+IF(TRIM(CLEAN(H11))=\"B+\",3.5)+IF(TRIM(CLEAN(H11))=\"B\",3)+IF(TRIM(CLEAN(H11))=\"C+\",2.5)+IF(TRIM(CLEAN(H11))=\"C\",2)+IF(TRIM(CLEAN(H11))=\"D+\",1.5)+IF(TRIM(CLEAN(H11))=\"D\",1)+IF(TRIM(CLEAN(H11))=\"D*\",1)+IF(TRIM(CLEAN(H11))=\"NU\",0)+IF(TRIM(CLEAN(H11))=\"NA\",0)","v":3},"3. SOUND",{"$f":"IF(G11=\"\",\"\",IF(OR(G11=\"NA\",H11=\"NA\"),\"N.C\",\nIF(OR(G11=\"NU\",H11=\"NU\"),\"N.C\",\nIF(I11=\"Yes\",IF(K11 -J11<0,\" -\",IF(K11 -J11>0,\" +\",\" =\")),\"N.C\"))))","v":""},"Six elements are fulfilled: basic (i) sector strategic plans; (ii) costed projects in plans; (iii) climate projects in public investment plans; advanced (i) climate change policies apply to public corporations; (ii) climate strategies identify gaps; and (iii) there is a central point of coordination for CC strategies and implementation.",null,null,1]
[{"$f":"$F$3","v":"Pefalia"},2,"M1","Indic","CRPFM-2",{"$f":"VLOOKUP(B12,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"2 Tracking climate related expenditure"},{"$f":"IF(J12>3.65,\"A\",\nIF(J12>=3.25,\"B+\",\nIF(J12>2.65,\"B\",\nIF(J12>=2.25,\"C+\",\nIF(J12>1.75,\"C\",\nIF(J12>1.25,\"D+\",\nIF(AND(J12<=1.25,J12>0),\"D\",\n\"\"\n)))))))","v":"D"},{"$f":"IF(J12>3.65,\"A\",\nIF(J12>=3.25,\"B+\",\nIF(J12>2.65,\"B\",\nIF(J12>=2.25,\"C+\",\nIF(J12>1.75,\"C\",\nIF(J12>1.25,\"D+\",\nIF(AND(J12<=1.25,J12>0),\"D\",\n\"NA\"\n)))))))","v":"D"},{"$f":"I13","v":"Yes"},{"$f":"IF($C12=\"M1\",IF(MIN(J13)=MIN(J13),J13,MIN(J13)+0.5),MIN(J13))","v":1},{"$f":"IF($H12=\"D\",1,\nIF($H12=\"D+\",1.5,\nIF($H12=\"C\",2,\nIF($H12=\"C+\",2.5,\nIF($H12=\"B\",3,\nIF($H12=\"B+\",3.5,\nIF($H12=\"A\",4,\n)))))))","v":1},"1. BELOW BASIC",null,null,null,null,{"$f":"Q13","v":3}]
["Pefalia",2.1,null,"Comp","CRPFM-2",{"$f":"VLOOKUP(B13,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"2.1 Tracking climate related expenditure"},null,"D","Yes",{"$f":"IF(TRIM(CLEAN(H13))=\"A\",4)+IF(TRIM(CLEAN(H13))=\"B+\",3.5)+IF(TRIM(CLEAN(H13))=\"B\",3)+IF(TRIM(CLEAN(H13))=\"C+\",2.5)+IF(TRIM(CLEAN(H13))=\"C\",2)+IF(TRIM(CLEAN(H13))=\"D+\",1.5)+IF(TRIM(CLEAN(H13))=\"D\",1)+IF(TRIM(CLEAN(H13))=\"D*\",1)+IF(TRIM(CLEAN(H13))=\"NU\",0)+IF(TRIM(CLEAN(H13))=\"NA\",0)","v":1},{"$f":"IF(TRIM(CLEAN(H13))=\"A\",4)+IF(TRIM(CLEAN(H13))=\"B+\",3.5)+IF(TRIM(CLEAN(H13))=\"B\",3)+IF(TRIM(CLEAN(H13))=\"C+\",2.5)+IF(TRIM(CLEAN(H13))=\"C\",2)+IF(TRIM(CLEAN(H13))=\"D+\",1.5)+IF(TRIM(CLEAN(H13))=\"D\",1)+IF(TRIM(CLEAN(H13))=\"D*\",1)+IF(TRIM(CLEAN(H13))=\"NU\",0)+IF(TRIM(CLEAN(H13))=\"NA\",0)","v":1},"1. BELOW BASIC","","The mandatory basic element (1) has not been met and neither have any of the other basic or additional requirements met.",null,null,3]
["Pefalia",3,"M1","Indic","CRPFM-3",{"$f":"VLOOKUP(B14,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"3 Climate responsive budget circular "},{"$f":"IF(J14>3.65,\"A\",\nIF(J14>=3.25,\"B+\",\nIF(J14>2.65,\"B\",\nIF(J14>=2.25,\"C+\",\nIF(J14>1.75,\"C\",\nIF(J14>1.25,\"D+\",\nIF(AND(J14<=1.25,J14>0),\"D\",\n\"\"\n)))))))","v":"D"},{"$f":"IF(J14>3.65,\"A\",\nIF(J14>=3.25,\"B+\",\nIF(J14>2.65,\"B\",\nIF(J14>=2.25,\"C+\",\nIF(J14>1.75,\"C\",\nIF(J14>1.25,\"D+\",\nIF(AND(J14<=1.25,J14>0),\"D\",\n\"NA\"\n)))))))","v":"D"},{"$f":"I15","v":"Yes"},{"$f":"IF($C14=\"M1\",IF(MIN(J15)=MIN(J15),J15,MIN(J15)+0.5),MIN(J15))","v":1},{"$f":"IF($H14=\"D\",1,\nIF($H14=\"D+\",1.5,\nIF($H14=\"C\",2,\nIF($H14=\"C+\",2.5,\nIF($H14=\"B\",3,\nIF($H14=\"B+\",3.5,\nIF($H14=\"A\",4,\n)))))))","v":1},"1. BELOW BASIC",null,null,null,null,{"$f":"Q15","v":2}]
["Pefalia",3.1,null,"Comp","CRPFM-3",{"$f":"VLOOKUP(B15,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"3.1 Budget circular"},null,"D","Yes",{"$f":"IF(TRIM(CLEAN(H15))=\"A\",4)+IF(TRIM(CLEAN(H15))=\"B+\",3.5)+IF(TRIM(CLEAN(H15))=\"B\",3)+IF(TRIM(CLEAN(H15))=\"C+\",2.5)+IF(TRIM(CLEAN(H15))=\"C\",2)+IF(TRIM(CLEAN(H15))=\"D+\",1.5)+IF(TRIM(CLEAN(H15))=\"D\",1)+IF(TRIM(CLEAN(H15))=\"D*\",1)+IF(TRIM(CLEAN(H15))=\"NU\",0)+IF(TRIM(CLEAN(H15))=\"NA\",0)","v":1},{"$f":"IF(TRIM(CLEAN(H15))=\"A\",4)+IF(TRIM(CLEAN(H15))=\"B+\",3.5)+IF(TRIM(CLEAN(H15))=\"B\",3)+IF(TRIM(CLEAN(H15))=\"C+\",2.5)+IF(TRIM(CLEAN(H15))=\"C\",2)+IF(TRIM(CLEAN(H15))=\"D+\",1.5)+IF(TRIM(CLEAN(H15))=\"D\",1)+IF(TRIM(CLEAN(H15))=\"D*\",1)+IF(TRIM(CLEAN(H15))=\"NU\",0)+IF(TRIM(CLEAN(H15))=\"NA\",0)","v":1},"1. BELOW BASIC","","The Budget Circular does not provide guidance on how to factor climate change mitigation or adaptation planned expenditure into budget proposals.",null,null,2]
["Pefalia",4,"M2","Indic","CRPFM-4",{"$f":"VLOOKUP(B16,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"4 Legislative scrutiny"},{"$f":"IF(J16>3.65,\"A\",\nIF(J16>=3.25,\"B+\",\nIF(J16>2.65,\"B\",\nIF(J16>=2.25,\"C+\",\nIF(J16>1.75,\"C\",\nIF(J16>1.25,\"D+\",\nIF(AND(J16<=1.25,J16>0),\"D\",\n\"\"\n)))))))","v":"D+"},{"$f":"IF(J16>3.65,\"A\",\nIF(J16>=3.25,\"B+\",\nIF(J16>2.65,\"B\",\nIF(J16>=2.25,\"C+\",\nIF(J16>1.75,\"C\",\nIF(J16>1.25,\"D+\",\nIF(AND(J16<=1.25,J16>0),\"D\",\n\"NA\"\n)))))))","v":"D+"},{"$f":"IF(OR(I17=\"Yes\",I18=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR(IF($C16=\"M1\",IF(ROUND(AVERAGEIF(J17:J18,\">0\"),1)=ROUND(MIN(IF(J17:J18>0,J17:J18)),1),J17,MIN(IF(J17:J18>0,J17:J18))+0.5),AVERAGEIF(J17:J18,\">0\")),0)","v":1.5},{"$f":"IF($H16=\"D\",1,\nIF($H16=\"D+\",1.5,\nIF($H16=\"C\",2,\nIF($H16=\"C+\",2.5,\nIF($H16=\"B\",3,\nIF($H16=\"B+\",3.5,\nIF($H16=\"A\",4,\n)))))))","v":1.5},"1. BELOW BASIC",null,null,null,null,{"$f":"Q17","v":1}]
["Pefalia",4.0999999999999996,null,"Comp","CRPFM-4",{"$f":"VLOOKUP(B17,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"4.1 Legislative scrutiny of budget"},null,"D","Yes",{"$f":"IF(TRIM(CLEAN(H17))=\"A\",4)+IF(TRIM(CLEAN(H17))=\"B+\",3.5)+IF(TRIM(CLEAN(H17))=\"B\",3)+IF(TRIM(CLEAN(H17))=\"C+\",2.5)+IF(TRIM(CLEAN(H17))=\"C\",2)+IF(TRIM(CLEAN(H17))=\"D+\",1.5)+IF(TRIM(CLEAN(H17))=\"D\",1)+IF(TRIM(CLEAN(H17))=\"D*\",1)+IF(TRIM(CLEAN(H17))=\"NU\",0)+IF(TRIM(CLEAN(H17))=\"NA\",0)","v":1},{"$f":"IF(TRIM(CLEAN(H17))=\"A\",4)+IF(TRIM(CLEAN(H17))=\"B+\",3.5)+IF(TRIM(CLEAN(H17))=\"B\",3)+IF(TRIM(CLEAN(H17))=\"C+\",2.5)+IF(TRIM(CLEAN(H17))=\"C\",2)+IF(TRIM(CLEAN(H17))=\"D+\",1.5)+IF(TRIM(CLEAN(H17))=\"D\",1)+IF(TRIM(CLEAN(H17))=\"D*\",1)+IF(TRIM(CLEAN(H17))=\"NU\",0)+IF(TRIM(CLEAN(H17))=\"NA\",0)","v":1},"1. BELOW BASIC","","Legislative scrutiny of budget fulfills four elements: (ii) impact assessment review of  CC programs; (iii) review of positive, neutral or negative contribution to CC of programs or actions not directly related to CC; (iv) review of climate related annual details of expenditure and revenue; and (v) review of climate related fiscal risks ",null,null,1]
["Pefalia",4.2,null,"Comp","CRPFM-4",{"$f":"VLOOKUP(B18,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"4.2 Legislative scrutiny of audit and evaluation reports"},null,"C","Yes",2,{"$f":"IF(TRIM(CLEAN(H18))=\"A\",4)+IF(TRIM(CLEAN(H18))=\"B+\",3.5)+IF(TRIM(CLEAN(H18))=\"B\",3)+IF(TRIM(CLEAN(H18))=\"C+\",2.5)+IF(TRIM(CLEAN(H18))=\"C\",2)+IF(TRIM(CLEAN(H18))=\"D+\",1.5)+IF(TRIM(CLEAN(H18))=\"D\",1)+IF(TRIM(CLEAN(H18))=\"D*\",1)+IF(TRIM(CLEAN(H18))=\"NU\",0)+IF(TRIM(CLEAN(H18))=\"NA\",0)","v":2},"2. BASIC","","Legislative scrutiny of audit and evaluation reports fulfills four elements: (i) technical support; (ii) review of climate related executed expenditure and revenue at a level comparable with the approved budget; (v) issuance of climate related recommendations; and (vi) follow-up of recommendations",null,null,1]
["Pefalia",5,"M2","Indic","CRPFM-5",{"$f":"VLOOKUP(B19,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"5 Climate responsive public investment management"},{"$f":"IF(J19>3.65,\"A\",\nIF(J19>=3.25,\"B+\",\nIF(J19>2.65,\"B\",\nIF(J19>=2.25,\"C+\",\nIF(J19>1.75,\"C\",\nIF(J19>1.25,\"D+\",\nIF(AND(J19<=1.25,J19>0),\"D\",\n\"\"\n)))))))","v":"D"},{"$f":"IF(J19>3.65,\"A\",\nIF(J19>=3.25,\"B+\",\nIF(J19>2.65,\"B\",\nIF(J19>=2.25,\"C+\",\nIF(J19>1.75,\"C\",\nIF(J19>1.25,\"D+\",\nIF(AND(J19<=1.25,J19>0),\"D\",\n\"NA\"\n)))))))","v":"D"},{"$f":"IF(OR(I20=\"Yes\",I21=\"Yes\",I22=\"Yes\",I23=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR(IF($C19=\"M1\",IF(ROUND(AVERAGEIF(J20:J23,\">0\"),1)=ROUND(MIN(IF(J20:J23>0,J20:J23)),1),MIN(J20:J23),MIN(IF(J20:J23>0,J20:J23))+0.5),AVERAGEIF(J20:J23,\">0\")),0)","v":1},{"$f":"IF($H19=\"D\",1,\nIF($H19=\"D+\",1.5,\nIF($H19=\"C\",2,\nIF($H19=\"C+\",2.5,\nIF($H19=\"B\",3,\nIF($H19=\"B+\",3.5,\nIF($H19=\"A\",4,\n)))))))","v":1},"1. BELOW BASIC",null,null,null,null,{"$f":"Q20","v":1}]
["Pefalia",5.0999999999999996,null,"Comp","CRPFM-5",{"$f":"VLOOKUP(B20,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"5.1 Climate related provisions in regulatory framework for public investment management"},null,"D","Yes",{"$f":"IF(TRIM(CLEAN(H20))=\"A\",4)+IF(TRIM(CLEAN(H20))=\"B+\",3.5)+IF(TRIM(CLEAN(H20))=\"B\",3)+IF(TRIM(CLEAN(H20))=\"C+\",2.5)+IF(TRIM(CLEAN(H20))=\"C\",2)+IF(TRIM(CLEAN(H20))=\"D+\",1.5)+IF(TRIM(CLEAN(H20))=\"D\",1)+IF(TRIM(CLEAN(H20))=\"D*\",1)+IF(TRIM(CLEAN(H20))=\"NU\",0)+IF(TRIM(CLEAN(H20))=\"NA\",0)","v":1},{"$f":"IF(TRIM(CLEAN(H20))=\"A\",4)+IF(TRIM(CLEAN(H20))=\"B+\",3.5)+IF(TRIM(CLEAN(H20))=\"B\",3)+IF(TRIM(CLEAN(H20))=\"C+\",2.5)+IF(TRIM(CLEAN(H20))=\"C\",2)+IF(TRIM(CLEAN(H20))=\"D+\",1.5)+IF(TRIM(CLEAN(H20))=\"D\",1)+IF(TRIM(CLEAN(H20))=\"D*\",1)+IF(TRIM(CLEAN(H20))=\"NU\",0)+IF(TRIM(CLEAN(H20))=\"NA\",0)","v":1},"1. BELOW BASIC","","The CC Policy 2017 and SDS provide guidance on the objectives for CC adaptation and mitigation.",null,null,1]
[null,5.2,null,"Comp","CRPFM-5",{"$f":"VLOOKUP(B21,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"5.2 Climate related project selection"},null,"D","Yes",1,1,"1. BELOW BASIC","","Good guidance is available on how to consider and include national strategies and objectives into operational plans and projects.  Identified infrastructure projects are screened against a prepared selection criterion, but the criteria do not assist in prioritization."]
[null,5.3,null,"Comp","CRPFM-5",{"$f":"VLOOKUP(B22,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"5.3 Climate related provisions for project appraisal"},null,"D","Yes",1,1,"1. BELOW BASIC","","Identified infrastructure projects are screened against a prepared selection criterion. Many of the major infrastructure project design is done and/or supervised by major development partners which require screening for climate risk and inclusion of resilience measures.\r\nAt a specific project level, The EIA do not specifically provide for appraisals to specifically evaluate CC (mitigation or adaptation) impacts of projects, but this may not be an appropriate instrument to do such screening and resilience measure. "]
[null,5.4,null,"Comp","CRPFM-5",{"$f":"VLOOKUP(B23,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"5.4 Reporting from entities in charge of implementation"},null,"D","Yes",1,1,"1. BELOW BASIC","","EBUs and public corporations produce statements of corporate objectives every three years and report back to the central government on an annual basis. Some entities (such as EPC and LTA) include climate objectives, targets and indicators. Statements of Corporate Intent and Annual reports don’t include reporting on funding for climate resilience or mitigation specifically"]
["Pefalia",6,"M1","Indic","CRPFM-6",{"$f":"VLOOKUP(B24,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"6 Climate responsive asset management"},{"$f":"IF(J24>3.65,\"A\",\nIF(J24>=3.25,\"B+\",\nIF(J24>2.65,\"B\",\nIF(J24>=2.25,\"C+\",\nIF(J24>1.75,\"C\",\nIF(J24>1.25,\"D+\",\nIF(AND(J24<=1.25,J24>0),\"D\",\n\"\"\n)))))))","v":"D"},{"$f":"IF(J24>3.65,\"A\",\nIF(J24>=3.25,\"B+\",\nIF(J24>2.65,\"B\",\nIF(J24>=2.25,\"C+\",\nIF(J24>1.75,\"C\",\nIF(J24>1.25,\"D+\",\nIF(AND(J24<=1.25,J24>0),\"D\",\n\"NA\"\n)))))))","v":"D"},{"$f":"I25","v":"Yes"},{"$f":"IF($C24=\"M1\",IF(MIN(J25)=MIN(J25),J25,MIN(J25)+0.5),MIN(J25))","v":1},{"$f":"IF($H24=\"D\",1,\nIF($H24=\"D+\",1.5,\nIF($H24=\"C\",2,\nIF($H24=\"C+\",2.5,\nIF($H24=\"B\",3,\nIF($H24=\"B+\",3.5,\nIF($H24=\"A\",4,\n)))))))","v":1},"1. BELOW BASIC",null,null,null,null,{"$f":"Q25","v":3}]
["Pefalia",6.1,null,"Comp","CRPFM-6",{"$f":"VLOOKUP(B25,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"6.1 Climate responsive non-financial assets management"},null,"D","Yes",{"$f":"IF(TRIM(CLEAN(H25))=\"A\",4)+IF(TRIM(CLEAN(H25))=\"B+\",3.5)+IF(TRIM(CLEAN(H25))=\"B\",3)+IF(TRIM(CLEAN(H25))=\"C+\",2.5)+IF(TRIM(CLEAN(H25))=\"C\",2)+IF(TRIM(CLEAN(H25))=\"D+\",1.5)+IF(TRIM(CLEAN(H25))=\"D\",1)+IF(TRIM(CLEAN(H25))=\"D*\",1)+IF(TRIM(CLEAN(H25))=\"NU\",0)+IF(TRIM(CLEAN(H25))=\"NA\",0)","v":1},{"$f":"IF(TRIM(CLEAN(H25))=\"A\",4)+IF(TRIM(CLEAN(H25))=\"B+\",3.5)+IF(TRIM(CLEAN(H25))=\"B\",3)+IF(TRIM(CLEAN(H25))=\"C+\",2.5)+IF(TRIM(CLEAN(H25))=\"C\",2)+IF(TRIM(CLEAN(H25))=\"D+\",1.5)+IF(TRIM(CLEAN(H25))=\"D\",1)+IF(TRIM(CLEAN(H25))=\"D*\",1)+IF(TRIM(CLEAN(H25))=\"NU\",0)+IF(TRIM(CLEAN(H25))=\"NA\",0)","v":1},"1. BELOW BASIC","","Work has just commenced on establishing the asset register.   The asset register is decentralized and the template does not require the recording of what is a climate sensitive asset, and it is not mentioned in the asset management strategy (AMS)",null,null,3]
["Pefalia",7,"M2","Indic","CRPFM-7",{"$f":"VLOOKUP(B26,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"7 Climate related liabilities"},{"$f":"IF(J26>3.65,\"A\",\nIF(J26>=3.25,\"B+\",\nIF(J26>2.65,\"B\",\nIF(J26>=2.25,\"C+\",\nIF(J26>1.75,\"C\",\nIF(J26>1.25,\"D+\",\nIF(AND(J26<=1.25,J26>0),\"D\",\n\"\"\n)))))))","v":"D+"},{"$f":"IF(J26>3.65,\"A\",\nIF(J26>=3.25,\"B+\",\nIF(J26>2.65,\"B\",\nIF(J26>=2.25,\"C+\",\nIF(J26>1.75,\"C\",\nIF(J26>1.25,\"D+\",\nIF(AND(J26<=1.25,J26>0),\"D\",\n\"NA\"\n)))))))","v":"D+"},{"$f":"IF(OR(I27=\"Yes\",I28=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR(IF($C26=\"M1\",IF(ROUND(AVERAGEIF(J27:J28,\">0\"),1)=ROUND(MIN(IF(J27:J28>0,J27:J28)),1),J27,MIN(IF(J27:J28>0,J27:J28))+0.5),AVERAGEIF(J27:J28,\">0\")),0)","v":1.5},{"$f":"IF($H26=\"D\",1,\nIF($H26=\"D+\",1.5,\nIF($H26=\"C\",2,\nIF($H26=\"C+\",2.5,\nIF($H26=\"B\",3,\nIF($H26=\"B+\",3.5,\nIF($H26=\"A\",4,\n)))))))","v":1.5},"1. BELOW BASIC",null,null,null,null,{"$f":"Q27","v":2}]
["Pefalia",7.1,null,"Comp","CRPFM-7",{"$f":"VLOOKUP(B27,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"7.1 Climate related fiscal risks"},null,"D","Yes",{"$f":"IF(TRIM(CLEAN(H27))=\"A\",4)+IF(TRIM(CLEAN(H27))=\"B+\",3.5)+IF(TRIM(CLEAN(H27))=\"B\",3)+IF(TRIM(CLEAN(H27))=\"C+\",2.5)+IF(TRIM(CLEAN(H27))=\"C\",2)+IF(TRIM(CLEAN(H27))=\"D+\",1.5)+IF(TRIM(CLEAN(H27))=\"D\",1)+IF(TRIM(CLEAN(H27))=\"D*\",1)+IF(TRIM(CLEAN(H27))=\"NU\",0)+IF(TRIM(CLEAN(H27))=\"NA\",0)","v":1},{"$f":"IF(TRIM(CLEAN(H27))=\"A\",4)+IF(TRIM(CLEAN(H27))=\"B+\",3.5)+IF(TRIM(CLEAN(H27))=\"B\",3)+IF(TRIM(CLEAN(H27))=\"C+\",2.5)+IF(TRIM(CLEAN(H27))=\"C\",2)+IF(TRIM(CLEAN(H27))=\"D+\",1.5)+IF(TRIM(CLEAN(H27))=\"D\",1)+IF(TRIM(CLEAN(H27))=\"D*\",1)+IF(TRIM(CLEAN(H27))=\"NU\",0)+IF(TRIM(CLEAN(H27))=\"NA\",0)","v":1},"1. BELOW BASIC","","The government does not produce a report which consolidates climate related fiscal risks.",null,null,2]
["Pefalia",7.2,null,"Comp","CRPFM-7",{"$f":"VLOOKUP(B28,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"7.2 Climate related debt and guarantees"},null,"C","Yes",2,{"$f":"IF(TRIM(CLEAN(H28))=\"A\",4)+IF(TRIM(CLEAN(H28))=\"B+\",3.5)+IF(TRIM(CLEAN(H28))=\"B\",3)+IF(TRIM(CLEAN(H28))=\"C+\",2.5)+IF(TRIM(CLEAN(H28))=\"C\",2)+IF(TRIM(CLEAN(H28))=\"D+\",1.5)+IF(TRIM(CLEAN(H28))=\"D\",1)+IF(TRIM(CLEAN(H28))=\"D*\",1)+IF(TRIM(CLEAN(H28))=\"NU\",0)+IF(TRIM(CLEAN(H28))=\"NA\",0)","v":2},"2. BASIC","","There are no restrictions to government borrowing for climate related activities, this extends to public corporations.",null,null,2]
["Pefalia",8,"M2","Indic","CRPFM-8",{"$f":"VLOOKUP(B29,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"8 Climate responsive procurement"},{"$f":"IF(J29>3.65,\"A\",\nIF(J29>=3.25,\"B+\",\nIF(J29>2.65,\"B\",\nIF(J29>=2.25,\"C+\",\nIF(J29>1.75,\"C\",\nIF(J29>1.25,\"D+\",\nIF(AND(J29<=1.25,J29>0),\"D\",\n\"\"\n)))))))","v":"D+"},{"$f":"IF(J29>3.65,\"A\",\nIF(J29>=3.25,\"B+\",\nIF(J29>2.65,\"B\",\nIF(J29>=2.25,\"C+\",\nIF(J29>1.75,\"C\",\nIF(J29>1.25,\"D+\",\nIF(AND(J29<=1.25,J29>0),\"D\",\n\"NA\"\n)))))))","v":"D+"},{"$f":"IF(OR(I30=\"Yes\",I31=\"Yes\",I32=\"Yes\",I33=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR(IF($C29=\"M1\",IF(ROUND(AVERAGEIF(J30:J33,\">0\"),1)=ROUND(MIN(IF(J30:J33>0,J30:J33)),1),MIN(J30:J33),MIN(IF(J30:J33>0,J30:J33))+0.5),AVERAGEIF(J30:J33,\">0\")),0)","v":1.75},{"$f":"IF($H29=\"D\",1,\nIF($H29=\"D+\",1.5,\nIF($H29=\"C\",2,\nIF($H29=\"C+\",2.5,\nIF($H29=\"B\",3,\nIF($H29=\"B+\",3.5,\nIF($H29=\"A\",4,\n)))))))","v":1.5},"1. BELOW BASIC",null,null,null,null,{"$f":"Q30","v":4}]
["Pefalia",8.1,null,"Comp","CRPFM-8",{"$f":"VLOOKUP(B30,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"8.1 Climate responsive procurement framework"},null,"C","Yes",{"$f":"IF(TRIM(CLEAN(H30))=\"A\",4)+IF(TRIM(CLEAN(H30))=\"B+\",3.5)+IF(TRIM(CLEAN(H30))=\"B\",3)+IF(TRIM(CLEAN(H30))=\"C+\",2.5)+IF(TRIM(CLEAN(H30))=\"C\",2)+IF(TRIM(CLEAN(H30))=\"D+\",1.5)+IF(TRIM(CLEAN(H30))=\"D\",1)+IF(TRIM(CLEAN(H30))=\"D*\",1)+IF(TRIM(CLEAN(H30))=\"NU\",0)+IF(TRIM(CLEAN(H30))=\"NA\",0)","v":2},{"$f":"IF(TRIM(CLEAN(H30))=\"A\",4)+IF(TRIM(CLEAN(H30))=\"B+\",3.5)+IF(TRIM(CLEAN(H30))=\"B\",3)+IF(TRIM(CLEAN(H30))=\"C+\",2.5)+IF(TRIM(CLEAN(H30))=\"C\",2)+IF(TRIM(CLEAN(H30))=\"D+\",1.5)+IF(TRIM(CLEAN(H30))=\"D\",1)+IF(TRIM(CLEAN(H30))=\"D*\",1)+IF(TRIM(CLEAN(H30))=\"NU\",0)+IF(TRIM(CLEAN(H30))=\"NA\",0)","v":2},"2. BASIC",{"$f":"IF(G30=\"\",\"\",IF(OR(G30=\"NA\",H30=\"NA\"),\"N.C\",\nIF(OR(G30=\"NU\",H30=\"NU\"),\"N.C\",\nIF(I30=\"Yes\",IF(K30 -J30<0,\" -\",IF(K30 -J30>0,\" +\",\" =\")),\"N.C\"))))","v":""},"There are no means by which to verify whether contract awards and implementation are consistent with climate responsive specifications, procurement database does not store information on climate responsive aspects of the tenders.",null,null,4]
["Pefalia",8.1999999999999993,null,"Comp","CRPFM-8",{"$f":"VLOOKUP(B31,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"8.2 Climate responsive public procurement operations"},null,"C","Yes",2,2,"2. BASIC","","Simplified procedures exist to expedite procurement in response to climate induced disasters.  Standard bidding templates do not set out any climate responsive standards.",null,null,4]
["Pefalia",8.3000000000000007,null,"Comp","CRPFM-8",{"$f":"VLOOKUP(B32,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"8.3 Climate responsive public procurement monitoring"},null,"C","Yes",2,2,"2. BASIC","","Procurement databases do not contain information on climate responsiveness but contain information on emergency procurement\r\nCompliance of contract awards.",null,null,4]
["Pefalia",8.4,null,"Comp","CRPFM-8",{"$f":"VLOOKUP(B33,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"8.4 Climate responsive public procurement reporting"},null,"D*","Yes",1,1,"","","No statistical reports are provided on climate responsive procurement and emergency procurement is not reported.",null,null,4]
["Pefalia",9,"M2","Indic","CRPFM-9",{"$f":"VLOOKUP(B34,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"9 Climate responsive revenue administration"},{"$f":"IF(J34>3.65,\"A\",\nIF(J34>=3.25,\"B+\",\nIF(J34>2.65,\"B\",\nIF(J34>=2.25,\"C+\",\nIF(J34>1.75,\"C\",\nIF(J34>1.25,\"D+\",\nIF(AND(J34<=1.25,J34>0),\"D\",\n\"\"\n)))))))","v":""},{"$f":"IF(J34>3.65,\"A\",\nIF(J34>=3.25,\"B+\",\nIF(J34>2.65,\"B\",\nIF(J34>=2.25,\"C+\",\nIF(J34>1.75,\"C\",\nIF(J34>1.25,\"D+\",\nIF(AND(J34<=1.25,J34>0),\"D\",\n\"NA\"\n)))))))","v":"NA"},{"$f":"IF(OR(I35=\"Yes\",I36=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR(IF($C34=\"M1\",IF(ROUND(AVERAGEIF(J35:J36,\">0\"),1)=ROUND(MIN(IF(J35:J36>0,J35:J36)),1),J35,MIN(IF(J35:J36>0,J35:J36))+0.5),AVERAGEIF(J35:J36,\">0\")),0)","v":0},{"$f":"IF($H34=\"D\",1,\nIF($H34=\"D+\",1.5,\nIF($H34=\"C\",2,\nIF($H34=\"C+\",2.5,\nIF($H34=\"B\",3,\nIF($H34=\"B+\",3.5,\nIF($H34=\"A\",4,\n)))))))","v":0},"",null,null,null,null,{"$f":"Q35","v":1}]
["Pefalia",9.1,null,"Comp","CRPFM-9",{"$f":"VLOOKUP(B35,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"9.1 Climate related tax management, audit and investigation"},null,"NA","Yes",{"$f":"IF(TRIM(CLEAN(H35))=\"A\",4)+IF(TRIM(CLEAN(H35))=\"B+\",3.5)+IF(TRIM(CLEAN(H35))=\"B\",3)+IF(TRIM(CLEAN(H35))=\"C+\",2.5)+IF(TRIM(CLEAN(H35))=\"C\",2)+IF(TRIM(CLEAN(H35))=\"D+\",1.5)+IF(TRIM(CLEAN(H35))=\"D\",1)+IF(TRIM(CLEAN(H35))=\"D*\",1)+IF(TRIM(CLEAN(H35))=\"NU\",0)+IF(TRIM(CLEAN(H35))=\"NA\",0)","v":0},{"$f":"IF(TRIM(CLEAN(H35))=\"A\",4)+IF(TRIM(CLEAN(H35))=\"B+\",3.5)+IF(TRIM(CLEAN(H35))=\"B\",3)+IF(TRIM(CLEAN(H35))=\"C+\",2.5)+IF(TRIM(CLEAN(H35))=\"C\",2)+IF(TRIM(CLEAN(H35))=\"D+\",1.5)+IF(TRIM(CLEAN(H35))=\"D\",1)+IF(TRIM(CLEAN(H35))=\"D*\",1)+IF(TRIM(CLEAN(H35))=\"NU\",0)+IF(TRIM(CLEAN(H35))=\"NA\",0)","v":0},"","","There are currently no climate related taxes in place in Pefalia. ",null,null,1]
["Pefalia",9.1999999999999993,null,"Comp","CRPFM-9",{"$f":"VLOOKUP(B36,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"9.2 Climate related tax arrears"},null,"NA","Yes",0,{"$f":"IF(TRIM(CLEAN(H36))=\"A\",4)+IF(TRIM(CLEAN(H36))=\"B+\",3.5)+IF(TRIM(CLEAN(H36))=\"B\",3)+IF(TRIM(CLEAN(H36))=\"C+\",2.5)+IF(TRIM(CLEAN(H36))=\"C\",2)+IF(TRIM(CLEAN(H36))=\"D+\",1.5)+IF(TRIM(CLEAN(H36))=\"D\",1)+IF(TRIM(CLEAN(H36))=\"D*\",1)+IF(TRIM(CLEAN(H36))=\"NU\",0)+IF(TRIM(CLEAN(H36))=\"NA\",0)","v":0},"","","There are currently no climate related taxes in place in Pefalia. ",null,null,1]
["Pefalia",10,"M2","Indic","CRPFM-10",{"$f":"VLOOKUP(B37,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"10 Compliance of climate related expenditure"},{"$f":"IF(J37>3.65,\"A\",\nIF(J37>=3.25,\"B+\",\nIF(J37>2.65,\"B\",\nIF(J37>=2.25,\"C+\",\nIF(J37>1.75,\"C\",\nIF(J37>1.25,\"D+\",\nIF(AND(J37<=1.25,J37>0),\"D\",\n\"\"\n)))))))","v":"C+"},{"$f":"IF(J37>3.65,\"A\",\nIF(J37>=3.25,\"B+\",\nIF(J37>2.65,\"B\",\nIF(J37>=2.25,\"C+\",\nIF(J37>1.75,\"C\",\nIF(J37>1.25,\"D+\",\nIF(AND(J37<=1.25,J37>0),\"D\",\n\"NA\"\n)))))))","v":"C+"},{"$f":"IF(OR(I38=\"Yes\",I39=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR(IF($C37=\"M1\",IF(ROUND(AVERAGEIF(J38:J39,\">0\"),1)=ROUND(MIN(IF(J38:J39>0,J38:J39)),1),J38,MIN(IF(J38:J39>0,J38:J39))+0.5),AVERAGEIF(J38:J39,\">0\")),0)","v":2.5},{"$f":"IF($H37=\"D\",1,\nIF($H37=\"D+\",1.5,\nIF($H37=\"C\",2,\nIF($H37=\"C+\",2.5,\nIF($H37=\"B\",3,\nIF($H37=\"B+\",3.5,\nIF($H37=\"A\",4,\n)))))))","v":2.5},"2. BASIC",null,null,null,null,{"$f":"Q38","v":3}]
["Pefalia",10.1,null,"Comp","CRPFM-10",{"$f":"VLOOKUP(B38,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"10.1 Effectiveness of the systems of controls"},null,"C","Yes",{"$f":"IF(TRIM(CLEAN(H38))=\"A\",4)+IF(TRIM(CLEAN(H38))=\"B+\",3.5)+IF(TRIM(CLEAN(H38))=\"B\",3)+IF(TRIM(CLEAN(H38))=\"C+\",2.5)+IF(TRIM(CLEAN(H38))=\"C\",2)+IF(TRIM(CLEAN(H38))=\"D+\",1.5)+IF(TRIM(CLEAN(H38))=\"D\",1)+IF(TRIM(CLEAN(H38))=\"D*\",1)+IF(TRIM(CLEAN(H38))=\"NU\",0)+IF(TRIM(CLEAN(H38))=\"NA\",0)","v":2},{"$f":"IF(TRIM(CLEAN(H38))=\"A\",4)+IF(TRIM(CLEAN(H38))=\"B+\",3.5)+IF(TRIM(CLEAN(H38))=\"B\",3)+IF(TRIM(CLEAN(H38))=\"C+\",2.5)+IF(TRIM(CLEAN(H38))=\"C\",2)+IF(TRIM(CLEAN(H38))=\"D+\",1.5)+IF(TRIM(CLEAN(H38))=\"D\",1)+IF(TRIM(CLEAN(H38))=\"D*\",1)+IF(TRIM(CLEAN(H38))=\"NU\",0)+IF(TRIM(CLEAN(H38))=\"NA\",0)","v":2},"2. BASIC","","A comprehensive system of ex-ante control in is place that ensures that climate related transactions, along with all other transaction types and categories are compliant with their budget intent, and procedures and approval requirements.  There is however no evidence of any audit of the systems of control in the last three fiscal years. ",null,null,3]
["Pefalia",10.199999999999999,null,"Comp","CRPFM-10",{"$f":"VLOOKUP(B39,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"10.2 Compliance of transactions"},null,"B","Yes",3,{"$f":"IF(TRIM(CLEAN(H39))=\"A\",4)+IF(TRIM(CLEAN(H39))=\"B+\",3.5)+IF(TRIM(CLEAN(H39))=\"B\",3)+IF(TRIM(CLEAN(H39))=\"C+\",2.5)+IF(TRIM(CLEAN(H39))=\"C\",2)+IF(TRIM(CLEAN(H39))=\"D+\",1.5)+IF(TRIM(CLEAN(H39))=\"D\",1)+IF(TRIM(CLEAN(H39))=\"D*\",1)+IF(TRIM(CLEAN(H39))=\"NU\",0)+IF(TRIM(CLEAN(H39))=\"NA\",0)","v":3},"3. SOUND","","There is comprehensive full coverage of each and every transaction, so  it is reasonably assumed that climate related transactions, like all other categories and type of transactions, are subject to any audit and fraud investigation, and recovery procedure.",null,null,3]
["Pefalia",11,"M2","Indic","CRPFM-11",{"$f":"VLOOKUP(B40,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"11 Climate responsive fiscal decentralization framework"},{"$f":"IF(J40>3.65,\"A\",\nIF(J40>=3.25,\"B+\",\nIF(J40>2.65,\"B\",\nIF(J40>=2.25,\"C+\",\nIF(J40>1.75,\"C\",\nIF(J40>1.25,\"D+\",\nIF(AND(J40<=1.25,J40>0),\"D\",\n\"\"\n)))))))","v":""},{"$f":"IF(J40>3.65,\"A\",\nIF(J40>=3.25,\"B+\",\nIF(J40>2.65,\"B\",\nIF(J40>=2.25,\"C+\",\nIF(J40>1.75,\"C\",\nIF(J40>1.25,\"D+\",\nIF(AND(J40<=1.25,J40>0),\"D\",\n\"NA\"\n)))))))","v":"NA"},{"$f":"IF(OR(I41=\"Yes\",I42=\"Yes\",I43=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR((IF($C40=\"M1\",IF(ROUND(AVERAGEIF(J41:J43,\">0\"),1)=ROUND(MIN(IF(J41:J43>0,J41:J43)),1),MIN(J41:J43),MIN(IF(J41:J43>0,J41:J43))+0.5),AVERAGEIF(J41:J43,\">0\"))),0)","v":0},{"$f":"IF($H40=\"D\",1,\nIF($H40=\"D+\",1.5,\nIF($H40=\"C\",2,\nIF($H40=\"C+\",2.5,\nIF($H40=\"B\",3,\nIF($H40=\"B+\",3.5,\nIF($H40=\"A\",4,\n)))))))","v":0},"",null,null,null,null,{"$f":"Q41","v":4}]
["Pefalia",11.1,null,"Comp","CRPFM-11",{"$f":"VLOOKUP(B41,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"11.1 Climate responsive fiscal decentralization arrangements"},null,"NA","Yes",{"$f":"IF(TRIM(CLEAN(H41))=\"A\",4)+IF(TRIM(CLEAN(H41))=\"B+\",3.5)+IF(TRIM(CLEAN(H41))=\"B\",3)+IF(TRIM(CLEAN(H41))=\"C+\",2.5)+IF(TRIM(CLEAN(H41))=\"C\",2)+IF(TRIM(CLEAN(H41))=\"D+\",1.5)+IF(TRIM(CLEAN(H41))=\"D\",1)+IF(TRIM(CLEAN(H41))=\"D*\",1)+IF(TRIM(CLEAN(H41))=\"NU\",0)+IF(TRIM(CLEAN(H41))=\"NA\",0)","v":0},{"$f":"IF(TRIM(CLEAN(H41))=\"A\",4)+IF(TRIM(CLEAN(H41))=\"B+\",3.5)+IF(TRIM(CLEAN(H41))=\"B\",3)+IF(TRIM(CLEAN(H41))=\"C+\",2.5)+IF(TRIM(CLEAN(H41))=\"C\",2)+IF(TRIM(CLEAN(H41))=\"D+\",1.5)+IF(TRIM(CLEAN(H41))=\"D\",1)+IF(TRIM(CLEAN(H41))=\"D*\",1)+IF(TRIM(CLEAN(H41))=\"NU\",0)+IF(TRIM(CLEAN(H41))=\"NA\",0)","v":0},"",{"$f":"IF(G41=\"\",\"\",IF(OR(G41=\"NA\",H41=\"NA\"),\"N.C\",\nIF(OR(G41=\"NU\",H41=\"NU\"),\"N.C\",\nIF(I41=\"Yes\",IF(K41 -J41<0,\" -\",IF(K41 -J41>0,\" +\",\" =\")),\"N.C\"))))","v":""},"There is no decentralization in Pefalia. ",null,null,4]
["Pefalia",11.2,null,"Comp","CRPFM-11",{"$f":"VLOOKUP(B42,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"11.2 Climate responsive fiscal transfers"},null,"NA","Yes",0,0,"","","There is no decentralization in Pefalia. ",null,null,4]
["Pefalia",11.3,null,"Comp","CRPFM-11",{"$f":"VLOOKUP(B43,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"11.3 Climate responsive PFM arrangements applied by subnational governments"},null,"NA","Yes",0,0,"","","There is no decentralization in Pefalia. ",null,null,4]
["Pefalia",12,"M2","Indic","CRPFM-12",{"$f":"VLOOKUP(B44,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"12 Climate related performance information"},{"$f":"IF(J44>3.65,\"A\",\nIF(J44>=3.25,\"B+\",\nIF(J44>2.65,\"B\",\nIF(J44>=2.25,\"C+\",\nIF(J44>1.75,\"C\",\nIF(J44>1.25,\"D+\",\nIF(AND(J44<=1.25,J44>0),\"D\",\n\"\"\n)))))))","v":"C+"},{"$f":"IF(J44>3.65,\"A\",\nIF(J44>=3.25,\"B+\",\nIF(J44>2.65,\"B\",\nIF(J44>=2.25,\"C+\",\nIF(J44>1.75,\"C\",\nIF(J44>1.25,\"D+\",\nIF(AND(J44<=1.25,J44>0),\"D\",\n\"NA\"\n)))))))","v":"C+"},{"$f":"IF(OR(I45=\"Yes\",I46=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR(IF($C44=\"M1\",IF(ROUND(AVERAGEIF(J45:J46,\">0\"),1)=ROUND(MIN(IF(J45:J46>0,J45:J46)),1),J45,MIN(IF(J45:J46>0,J45:J46))+0.5),AVERAGEIF(J45:J46,\">0\")),0)","v":2.5},{"$f":"IF($H44=\"D\",1,\nIF($H44=\"D+\",1.5,\nIF($H44=\"C\",2,\nIF($H44=\"C+\",2.5,\nIF($H44=\"B\",3,\nIF($H44=\"B+\",3.5,\nIF($H44=\"A\",4,\n)))))))","v":2.5},"2. BASIC",null,null,null,null,{"$f":"Q45","v":3}]
["Pefalia",12.1,null,"Comp","CRPFM-12",{"$f":"VLOOKUP(B45,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"12.1 Climate related information in performance plans"},null,"B","Yes",{"$f":"IF(TRIM(CLEAN(H45))=\"A\",4)+IF(TRIM(CLEAN(H45))=\"B+\",3.5)+IF(TRIM(CLEAN(H45))=\"B\",3)+IF(TRIM(CLEAN(H45))=\"C+\",2.5)+IF(TRIM(CLEAN(H45))=\"C\",2)+IF(TRIM(CLEAN(H45))=\"D+\",1.5)+IF(TRIM(CLEAN(H45))=\"D\",1)+IF(TRIM(CLEAN(H45))=\"D*\",1)+IF(TRIM(CLEAN(H45))=\"NU\",0)+IF(TRIM(CLEAN(H45))=\"NA\",0)","v":3},{"$f":"IF(TRIM(CLEAN(H45))=\"A\",4)+IF(TRIM(CLEAN(H45))=\"B+\",3.5)+IF(TRIM(CLEAN(H45))=\"B\",3)+IF(TRIM(CLEAN(H45))=\"C+\",2.5)+IF(TRIM(CLEAN(H45))=\"C\",2)+IF(TRIM(CLEAN(H45))=\"D+\",1.5)+IF(TRIM(CLEAN(H45))=\"D\",1)+IF(TRIM(CLEAN(H45))=\"D*\",1)+IF(TRIM(CLEAN(H45))=\"NU\",0)+IF(TRIM(CLEAN(H45))=\"NA\",0)","v":3},"3. SOUND","","Performance indicators by output are provided in the 2020/21 budget document. For both MoF and MNRE. This includes an indicator directly related to objectives in the SDS and NDC for renewable energy targets.  This is submitted to the Legislative Assembly and published.",null,null,3]
["Pefalia",12.2,null,"Comp","CRPFM-12",{"$f":"VLOOKUP(B46,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"12.2 Climate related information in performance reports"},null,"C","Yes",2,2,"2. BASIC","","Performance indicator, targets and achieved outputs are reported in the 2020/21 budget document for some sectors including fisheries and community resilience. EPC report to the parliament also provides performance and achieved outputs on the renewable energy targets.",null,null,3]
["Pefalia",13,"M2","Indic","CRPFM-13",{"$f":"VLOOKUP(B47,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"13 Climate related performance evaluation"},{"$f":"IF(J47>3.65,\"A\",\nIF(J47>=3.25,\"B+\",\nIF(J47>2.65,\"B\",\nIF(J47>=2.25,\"C+\",\nIF(J47>1.75,\"C\",\nIF(J47>1.25,\"D+\",\nIF(AND(J47<=1.25,J47>0),\"D\",\n\"\"\n)))))))","v":"D+"},{"$f":"IF(J47>3.65,\"A\",\nIF(J47>=3.25,\"B+\",\nIF(J47>2.65,\"B\",\nIF(J47>=2.25,\"C+\",\nIF(J47>1.75,\"C\",\nIF(J47>1.25,\"D+\",\nIF(AND(J47<=1.25,J47>0),\"D\",\n\"NA\"\n)))))))","v":"D+"},{"$f":"IF(OR(I49=\"Yes\",I48=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR(IF($C47=\"M1\",IF(ROUND(AVERAGEIF(J48:J49,\">0\"),1)=ROUND(MIN(IF(J48:J49>0,J48:J49)),1),J49,MIN(IF(J48:J49>0,J48:J49))+0.5),AVERAGEIF(J48:J49,\">0\")),0)","v":1.5},{"$f":"IF($H47=\"D\",1,\nIF($H47=\"D+\",1.5,\nIF($H47=\"C\",2,\nIF($H47=\"C+\",2.5,\nIF($H47=\"B\",3,\nIF($H47=\"B+\",3.5,\nIF($H47=\"A\",4,\n)))))))","v":1.5},"1. BELOW BASIC",null,null,null,null,{"$f":"Q49","v":3}]
["Pefalia",13.2,null,"Comp","CRPFM-13",{"$f":"VLOOKUP(B48,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"13.2 Climate related evaluation of taxes"},null,"C","Yes",{"$f":"IF(TRIM(CLEAN(H48))=\"A\",4)+IF(TRIM(CLEAN(H48))=\"B+\",3.5)+IF(TRIM(CLEAN(H48))=\"B\",3)+IF(TRIM(CLEAN(H48))=\"C+\",2.5)+IF(TRIM(CLEAN(H48))=\"C\",2)+IF(TRIM(CLEAN(H48))=\"D+\",1.5)+IF(TRIM(CLEAN(H48))=\"D\",1)+IF(TRIM(CLEAN(H48))=\"D*\",1)+IF(TRIM(CLEAN(H48))=\"NU\",0)+IF(TRIM(CLEAN(H48))=\"NA\",0)","v":2},{"$f":"IF(TRIM(CLEAN(H48))=\"A\",4)+IF(TRIM(CLEAN(H48))=\"B+\",3.5)+IF(TRIM(CLEAN(H48))=\"B\",3)+IF(TRIM(CLEAN(H48))=\"C+\",2.5)+IF(TRIM(CLEAN(H48))=\"C\",2)+IF(TRIM(CLEAN(H48))=\"D+\",1.5)+IF(TRIM(CLEAN(H48))=\"D\",1)+IF(TRIM(CLEAN(H48))=\"D*\",1)+IF(TRIM(CLEAN(H48))=\"NU\",0)+IF(TRIM(CLEAN(H48))=\"NA\",0)","v":2},"2. BASIC",{"$f":"IF(G48=\"\",\"\",IF(OR(G48=\"NA\",H48=\"NA\"),\"N.C\",\nIF(OR(G48=\"NU\",H48=\"NU\"),\"N.C\",\nIF(I48=\"Yes\",IF(K48 -J48<0,\" -\",IF(K48 -J48>0,\" +\",\" =\")),\"N.C\"))))","v":""},null,null,null,3]
["Pefalia",13.1,null,"Comp","CRPFM-13",{"$f":"VLOOKUP(B49,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"13.1 Climate related evaluation of expenditure"},null,"D","Yes",1,{"$f":"IF(TRIM(CLEAN(H49))=\"A\",4)+IF(TRIM(CLEAN(H49))=\"B+\",3.5)+IF(TRIM(CLEAN(H49))=\"B\",3)+IF(TRIM(CLEAN(H49))=\"C+\",2.5)+IF(TRIM(CLEAN(H49))=\"C\",2)+IF(TRIM(CLEAN(H49))=\"D+\",1.5)+IF(TRIM(CLEAN(H49))=\"D\",1)+IF(TRIM(CLEAN(H49))=\"D*\",1)+IF(TRIM(CLEAN(H49))=\"NU\",0)+IF(TRIM(CLEAN(H49))=\"NA\",0)","v":1},"1. BELOW BASIC",{"$f":"IF(G49=\"\",\"\",IF(OR(G49=\"NA\",H49=\"NA\"),\"N.C\",\nIF(OR(G49=\"NU\",H49=\"NU\"),\"N.C\",\nIF(I49=\"Yes\",IF(K49 -J49<0,\" -\",IF(K49 -J49>0,\" +\",\" =\")),\"N.C\"))))","v":""},"There has been no partial or full evaluation of the overall tax and customs policy in respect to climate change objectives.",null,null,3]
["Pefalia",14,"M2","Indic","CRPFM-14",{"$f":"VLOOKUP(B50,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"14 Expenditure outturn for climate activities"},{"$f":"IF(J50>3.65,\"A\",\nIF(J50>=3.25,\"B+\",\nIF(J50>2.65,\"B\",\nIF(J50>=2.25,\"C+\",\nIF(J50>1.75,\"C\",\nIF(J50>1.25,\"D+\",\nIF(AND(J50<=1.25,J50>0),\"D\",\n\"\"\n)))))))","v":""},{"$f":"IF(J50>3.65,\"A\",\nIF(J50>=3.25,\"B+\",\nIF(J50>2.65,\"B\",\nIF(J50>=2.25,\"C+\",\nIF(J50>1.75,\"C\",\nIF(J50>1.25,\"D+\",\nIF(AND(J50<=1.25,J50>0),\"D\",\n\"NA\"\n)))))))","v":"NA"},{"$f":"IF(OR(I51=\"Yes\",I52=\"Yes\"),\"Yes\",\"Yes\")","v":"Yes"},{"$f":"IFERROR(IF($C50=\"M1\",IF(ROUND(AVERAGEIF(J51:J52,\">0\"),1)=ROUND(MIN(IF(J51:J52>0,J51:J52)),1),J51,MIN(IF(J51:J52>0,J51:J52))+0.5),AVERAGEIF(J51:J52,\">0\")),0)","v":0},{"$f":"IF($H50=\"D\",1,\nIF($H50=\"D+\",1.5,\nIF($H50=\"C\",2,\nIF($H50=\"C+\",2.5,\nIF($H50=\"B\",3,\nIF($H50=\"B+\",3.5,\nIF($H50=\"A\",4,\n)))))))","v":0},"",null,null,null,null,{"$f":"Q51","v":3}]
["Pefalia",14.1,null,"Comp","CRPFM-14",{"$f":"VLOOKUP(B51,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"14.1 Aggregate climate related expenditure outturn"},null,"NA","Yes",{"$f":"IF(TRIM(CLEAN(H51))=\"A\",4)+IF(TRIM(CLEAN(H51))=\"B+\",3.5)+IF(TRIM(CLEAN(H51))=\"B\",3)+IF(TRIM(CLEAN(H51))=\"C+\",2.5)+IF(TRIM(CLEAN(H51))=\"C\",2)+IF(TRIM(CLEAN(H51))=\"D+\",1.5)+IF(TRIM(CLEAN(H51))=\"D\",1)+IF(TRIM(CLEAN(H51))=\"D*\",1)+IF(TRIM(CLEAN(H51))=\"NU\",0)+IF(TRIM(CLEAN(H51))=\"NA\",0)","v":0},{"$f":"IF(TRIM(CLEAN(H51))=\"A\",4)+IF(TRIM(CLEAN(H51))=\"B+\",3.5)+IF(TRIM(CLEAN(H51))=\"B\",3)+IF(TRIM(CLEAN(H51))=\"C+\",2.5)+IF(TRIM(CLEAN(H51))=\"C\",2)+IF(TRIM(CLEAN(H51))=\"D+\",1.5)+IF(TRIM(CLEAN(H51))=\"D\",1)+IF(TRIM(CLEAN(H51))=\"D*\",1)+IF(TRIM(CLEAN(H51))=\"NU\",0)+IF(TRIM(CLEAN(H51))=\"NA\",0)","v":0},"",{"$f":"IF(G51=\"\",\"\",IF(OR(G51=\"NA\",H51=\"NA\"),\"N.C\",\nIF(OR(G51=\"NU\",H51=\"NU\"),\"N.C\",\nIF(I51=\"Yes\",IF(K51 -J51<0,\" -\",IF(K51 -J51>0,\" +\",\" =\")),\"N.C\"))))","v":""},null,null,null,3]
["Pefalia",14.2,null,"Comp","CRPFM-14",{"$f":"VLOOKUP(B52,'Dimension (UK)'!$A$2:$C$53,3,FALSE)","v":"14.2 Climate related expenditure composition outturn"},null,"NA","Yes",0,{"$f":"IF(TRIM(CLEAN(H52))=\"A\",4)+IF(TRIM(CLEAN(H52))=\"B+\",3.5)+IF(TRIM(CLEAN(H52))=\"B\",3)+IF(TRIM(CLEAN(H52))=\"C+\",2.5)+IF(TRIM(CLEAN(H52))=\"C\",2)+IF(TRIM(CLEAN(H52))=\"D+\",1.5)+IF(TRIM(CLEAN(H52))=\"D\",1)+IF(TRIM(CLEAN(H52))=\"D*\",1)+IF(TRIM(CLEAN(H52))=\"NU\",0)+IF(TRIM(CLEAN(H52))=\"NA\",0)","v":0},"",{"$f":"IF(G52=\"\",\"\",IF(OR(G52=\"NA\",H52=\"NA\"),\"N.C\",\nIF(OR(G52=\"NU\",H52=\"NU\"),\"N.C\",\nIF(I52=\"Yes\",IF(K52 -J52<0,\" -\",IF(K52 -J52>0,\" +\",\" =\")),\"N.C\"))))","v":""},null,null,null,3]

{"sheet":"Data","index":2,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Country","Fmk","Year","Period","Type","ID","ID_Ind_Num","ID-Ind","ID_Comp","Method","ID_Pilar","Pilar","Label","Score","Score Num","Performance","AVG Num","Min Num","Min NumC","Score PEFA","Justification"]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",1,1,{"$f":"\"CRPFM-\"&G2","v":"CRPFM-1"},null,"M2",null,null,null,{"$f":"IF($D2=\"Current\",VLOOKUP(F2,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F2,'Data Input'!$B$9:$N$52,6,FALSE))","v":"B"},{"$f":"IFERROR(IF($B2=\"Climat\",IF($D2=\"Current\",VLOOKUP($F2,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F2,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D2=\"Current\",VLOOKUP($F2,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F2,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":3},{"$f":"IF(O2>=3.25,\"4. HIGH\",\nIF(O2>=3,\"3. SOUND\",\nIF(O2>=2,\"2. BASIC\",\nIF(O2>=1,\"1. BELOW BASIC\",\n\"\"\n))))","v":"3. SOUND"},{"$f":"IFERROR(AVERAGEIFS($O$2:$O$44,$B$2:$B$44,$B2,$G$2:$G$44,$G2,$C$2:$C$44,$C2,$E$2:$E$44,\"Comp\",$O$2:$O$44,\">0\"),0)","v":3},{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B2,IF($C$2:$C$45=$C2,IF($H$2:$H$45=$H2,$O$2:$O$45)))))","v":3},{"$f":"IF($Q2=$R2,$Q2,$R2+0.5)","v":3},{"$f":"(IF($J2=\"M1\",$S2,$Q2))","v":3}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",1.1000000000000001,1,{"$f":"\"CRPFM-\"&G3","v":"CRPFM-1"},1,null,{"$f":"VLOOKUP($F3,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"1 - Alignement du budget sur les stratégies climat"},{"$f":"VLOOKUP($F3,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"IV"},{"$f":"VLOOKUP($F3,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":1.1000000000000001},{"$f":"IF($B3=\"Climat\",IF($D3=\"Current\",VLOOKUP($F3,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F3,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D3=\"Current\",VLOOKUP($F3,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F3,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"B"},{"$f":"IFERROR(IF($B3=\"Climat\",IF($D3=\"Current\",VLOOKUP($F3,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F3,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D3=\"Current\",VLOOKUP($F3,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F3,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":3},"3. SOUND",3,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B3,IF($C$2:$C$45=$C3,IF($H$2:$H$45=$H3,$O$2:$O$45)))))","v":3},3,3,{"$f":"IF($D3=\"Current\",VLOOKUP($F3,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",2,2,"CRPFM-2",null,"M2",null,null,null,{"$f":"IF($D4=\"Current\",VLOOKUP(F4,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F4,'Data Input'!$B$9:$N$52,6,FALSE))","v":"D"},{"$f":"IFERROR(IF($B4=\"Climat\",IF($D4=\"Current\",VLOOKUP($F4,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F4,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D4=\"Current\",VLOOKUP($F4,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F4,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B4,IF($C$2:$C$45=$C4,IF($H$2:$H$45=$H4,$O$2:$O$45)))))","v":1},1,1]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",2.1,2,"CRPFM-2",1,null,{"$f":"VLOOKUP($F5,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"2 - Suivi des dépenses liées au climat"},{"$f":"VLOOKUP($F5,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"II"},{"$f":"VLOOKUP($F5,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":2.1},{"$f":"IF($B5=\"Climat\",IF($D5=\"Current\",VLOOKUP($F5,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F5,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D5=\"Current\",VLOOKUP($F5,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F5,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B5=\"Climat\",IF($D5=\"Current\",VLOOKUP($F5,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F5,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D5=\"Current\",VLOOKUP($F5,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F5,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B5,IF($C$2:$C$45=$C5,IF($H$2:$H$45=$H5,$O$2:$O$45)))))","v":1},1,1,{"$f":"IF($D5=\"Current\",VLOOKUP($F5,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",3,3,"CRPFM-3",null,"M2",null,null,null,{"$f":"IF($D6=\"Current\",VLOOKUP(F6,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F6,'Data Input'!$B$9:$N$52,6,FALSE))","v":"D"},{"$f":"IFERROR(IF($B6=\"Climat\",IF($D6=\"Current\",VLOOKUP($F6,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F6,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D6=\"Current\",VLOOKUP($F6,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F6,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B6,IF($C$2:$C$45=$C6,IF($H$2:$H$45=$H6,$O$2:$O$45)))))","v":1},1,1]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",3.1,3,"CRPFM-3",1,null,{"$f":"VLOOKUP($F7,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"3 - Circulaire budgétaire sensible au climat"},{"$f":"VLOOKUP($F7,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"IV"},{"$f":"VLOOKUP($F7,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":3.1},{"$f":"IF($B7=\"Climat\",IF($D7=\"Current\",VLOOKUP($F7,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F7,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D7=\"Current\",VLOOKUP($F7,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F7,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B7=\"Climat\",IF($D7=\"Current\",VLOOKUP($F7,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F7,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D7=\"Current\",VLOOKUP($F7,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F7,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B7,IF($C$2:$C$45=$C7,IF($H$2:$H$45=$H7,$O$2:$O$45)))))","v":1},1,1,{"$f":"IF($D7=\"Current\",VLOOKUP($F7,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",4,4,"CRPFM-4",null,"M2",null,null,null,{"$f":"IF($D8=\"Current\",VLOOKUP(F8,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F8,'Data Input'!$B$9:$N$52,6,FALSE))","v":"D+"},{"$f":"IFERROR(IF($B8=\"Climat\",IF($D8=\"Current\",VLOOKUP($F8,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F8,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D8=\"Current\",VLOOKUP($F8,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F8,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1.5},"1. BELOW BASIC",1.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B8,IF($C$2:$C$45=$C8,IF($H$2:$H$45=$H8,$O$2:$O$45)))))","v":1},1.5,1.5]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",4.0999999999999996,4,"CRPFM-4",1,null,{"$f":"VLOOKUP($F9,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"4 - Examen par le pouvoir législatif"},{"$f":"VLOOKUP($F9,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"IV"},{"$f":"VLOOKUP($F9,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":4.0999999999999996},{"$f":"IF($B9=\"Climat\",IF($D9=\"Current\",VLOOKUP($F9,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F9,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D9=\"Current\",VLOOKUP($F9,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F9,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B9=\"Climat\",IF($D9=\"Current\",VLOOKUP($F9,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F9,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D9=\"Current\",VLOOKUP($F9,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F9,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B9,IF($C$2:$C$45=$C9,IF($H$2:$H$45=$H9,$O$2:$O$45)))))","v":1},1.5,1.5,{"$f":"IF($D9=\"Current\",VLOOKUP($F9,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",4.2,4,"CRPFM-4",2,null,{"$f":"VLOOKUP($F10,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"4 - Examen par le pouvoir législatif"},{"$f":"VLOOKUP($F10,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"VII"},{"$f":"VLOOKUP($F10,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":4.2},{"$f":"IF($B10=\"Climat\",IF($D10=\"Current\",VLOOKUP($F10,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F10,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D10=\"Current\",VLOOKUP($F10,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F10,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"C"},{"$f":"IFERROR(IF($B10=\"Climat\",IF($D10=\"Current\",VLOOKUP($F10,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F10,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D10=\"Current\",VLOOKUP($F10,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F10,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2},"2. BASIC",1.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B10,IF($C$2:$C$45=$C10,IF($H$2:$H$45=$H10,$O$2:$O$45)))))","v":1},1.5,1.5,{"$f":"IF($D10=\"Current\",VLOOKUP($F10,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",5,5,"CRPFM-5",null,"M2",null,null,null,{"$f":"IF($D11=\"Current\",VLOOKUP(F11,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F11,'Data Input'!$B$9:$N$52,6,FALSE))","v":"D"},{"$f":"IFERROR(IF($B11=\"Climat\",IF($D11=\"Current\",VLOOKUP($F11,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F11,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D11=\"Current\",VLOOKUP($F11,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F11,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B11,IF($C$2:$C$45=$C11,IF($H$2:$H$45=$H11,$O$2:$O$45)))))","v":1},1,1]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",5.0999999999999996,5,"CRPFM-5",1,null,{"$f":"VLOOKUP($F12,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"5 - Gestion sensible au climat des investissements publics"},{"$f":"VLOOKUP($F12,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"III"},{"$f":"VLOOKUP($F12,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":5.0999999999999996},{"$f":"IF($B12=\"Climat\",IF($D12=\"Current\",VLOOKUP($F12,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F12,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D12=\"Current\",VLOOKUP($F12,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F12,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B12=\"Climat\",IF($D12=\"Current\",VLOOKUP($F12,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F12,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D12=\"Current\",VLOOKUP($F12,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F12,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B12,IF($C$2:$C$45=$C12,IF($H$2:$H$45=$H12,$O$2:$O$45)))))","v":1},1,1,{"$f":"IF($D12=\"Current\",VLOOKUP($F12,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",5.2,5,"CRPFM-5",2,null,{"$f":"VLOOKUP($F13,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"5 - Gestion sensible au climat des investissements publics"},{"$f":"VLOOKUP($F13,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"III"},{"$f":"VLOOKUP($F13,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":5.2},{"$f":"IF($B13=\"Climat\",IF($D13=\"Current\",VLOOKUP($F13,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F13,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D13=\"Current\",VLOOKUP($F13,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F13,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B13=\"Climat\",IF($D13=\"Current\",VLOOKUP($F13,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F13,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D13=\"Current\",VLOOKUP($F13,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F13,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B13,IF($C$2:$C$45=$C13,IF($H$2:$H$45=$H13,$O$2:$O$45)))))","v":1},1,1,{"$f":"IF($D13=\"Current\",VLOOKUP($F13,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",5.3,5,"CRPFM-5",3,null,{"$f":"VLOOKUP($F14,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"5 - Gestion sensible au climat des investissements publics"},{"$f":"VLOOKUP($F14,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"III"},{"$f":"VLOOKUP($F14,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":5.3},{"$f":"IF($B14=\"Climat\",IF($D14=\"Current\",VLOOKUP($F14,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F14,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D14=\"Current\",VLOOKUP($F14,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F14,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B14=\"Climat\",IF($D14=\"Current\",VLOOKUP($F14,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F14,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D14=\"Current\",VLOOKUP($F14,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F14,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B14,IF($C$2:$C$45=$C14,IF($H$2:$H$45=$H14,$O$2:$O$45)))))","v":1},1,1,{"$f":"IF($D14=\"Current\",VLOOKUP($F14,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",5.4,5,"CRPFM-5",4,null,{"$f":"VLOOKUP($F15,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"5 - Gestion sensible au climat des investissements publics"},{"$f":"VLOOKUP($F15,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"III"},{"$f":"VLOOKUP($F15,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":5.4},{"$f":"IF($B15=\"Climat\",IF($D15=\"Current\",VLOOKUP($F15,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F15,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D15=\"Current\",VLOOKUP($F15,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F15,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B15=\"Climat\",IF($D15=\"Current\",VLOOKUP($F15,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F15,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D15=\"Current\",VLOOKUP($F15,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F15,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B15,IF($C$2:$C$45=$C15,IF($H$2:$H$45=$H15,$O$2:$O$45)))))","v":1},1,1,{"$f":"IF($D15=\"Current\",VLOOKUP($F15,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",6,6,"CRPFM-6",null,"M2",null,null,null,{"$f":"IF($D16=\"Current\",VLOOKUP(F16,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F16,'Data Input'!$B$9:$N$52,6,FALSE))","v":"D"},{"$f":"IFERROR(IF($B16=\"Climat\",IF($D16=\"Current\",VLOOKUP($F16,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F16,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D16=\"Current\",VLOOKUP($F16,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F16,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B16,IF($C$2:$C$45=$C16,IF($H$2:$H$45=$H16,$O$2:$O$45)))))","v":1},1,1]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",6.1,6,"CRPFM-6",1,null,{"$f":"VLOOKUP($F17,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"6 - Gestion sensible au climat des actifs non financiers"},{"$f":"VLOOKUP($F17,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"III"},{"$f":"VLOOKUP($F17,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":6.1},{"$f":"IF($B17=\"Climat\",IF($D17=\"Current\",VLOOKUP($F17,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F17,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D17=\"Current\",VLOOKUP($F17,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F17,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B17=\"Climat\",IF($D17=\"Current\",VLOOKUP($F17,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F17,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D17=\"Current\",VLOOKUP($F17,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F17,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B17,IF($C$2:$C$45=$C17,IF($H$2:$H$45=$H17,$O$2:$O$45)))))","v":1},1,1,{"$f":"IF($D17=\"Current\",VLOOKUP($F17,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",7,7,"CRPFM-7",null,"M2",null,null,null,{"$f":"IF($D18=\"Current\",VLOOKUP(F18,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F18,'Data Input'!$B$9:$N$52,6,FALSE))","v":"D+"},{"$f":"IFERROR(IF($B18=\"Climat\",IF($D18=\"Current\",VLOOKUP($F18,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F18,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D18=\"Current\",VLOOKUP($F18,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F18,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1.5},"1. BELOW BASIC",1.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B18,IF($C$2:$C$45=$C18,IF($H$2:$H$45=$H18,$O$2:$O$45)))))","v":1},1.5,1.5]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",7.1,7,"CRPFM-7",1,null,{"$f":"VLOOKUP($F19,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"7 - Passifs liés au climat"},{"$f":"VLOOKUP($F19,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"III"},{"$f":"VLOOKUP($F19,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":7.1},{"$f":"IF($B19=\"Climat\",IF($D19=\"Current\",VLOOKUP($F19,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F19,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D19=\"Current\",VLOOKUP($F19,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F19,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B19=\"Climat\",IF($D19=\"Current\",VLOOKUP($F19,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F19,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D19=\"Current\",VLOOKUP($F19,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F19,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B19,IF($C$2:$C$45=$C19,IF($H$2:$H$45=$H19,$O$2:$O$45)))))","v":1},1.5,1.5,{"$f":"IF($D19=\"Current\",VLOOKUP($F19,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",7.2,7,"CRPFM-7",2,null,{"$f":"VLOOKUP($F20,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"7 - Passifs liés au climat"},{"$f":"VLOOKUP($F20,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"III"},{"$f":"VLOOKUP($F20,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":7.2},{"$f":"IF($B20=\"Climat\",IF($D20=\"Current\",VLOOKUP($F20,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F20,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D20=\"Current\",VLOOKUP($F20,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F20,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"C"},{"$f":"IFERROR(IF($B20=\"Climat\",IF($D20=\"Current\",VLOOKUP($F20,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F20,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D20=\"Current\",VLOOKUP($F20,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F20,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2},"2. BASIC",1.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B20,IF($C$2:$C$45=$C20,IF($H$2:$H$45=$H20,$O$2:$O$45)))))","v":1},1.5,1.5,{"$f":"IF($D20=\"Current\",VLOOKUP($F20,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",8,8,"CRPFM-8",null,"M2",null,null,null,{"$f":"IF($D21=\"Current\",VLOOKUP(F21,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F21,'Data Input'!$B$9:$N$52,6,FALSE))","v":"D+"},{"$f":"IFERROR(IF($B21=\"Climat\",IF($D21=\"Current\",VLOOKUP($F21,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F21,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D21=\"Current\",VLOOKUP($F21,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F21,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1.5},"1. BELOW BASIC",1.75,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B21,IF($C$2:$C$45=$C21,IF($H$2:$H$45=$H21,$O$2:$O$45)))))","v":1},1.5,1.75]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",8.1,8,"CRPFM-8",1,null,{"$f":"VLOOKUP($F22,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"8 - Marchés publics sensibles au climat"},{"$f":"VLOOKUP($F22,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"V"},{"$f":"VLOOKUP($F22,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":8.1},{"$f":"IF($B22=\"Climat\",IF($D22=\"Current\",VLOOKUP($F22,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F22,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D22=\"Current\",VLOOKUP($F22,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F22,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"C"},{"$f":"IFERROR(IF($B22=\"Climat\",IF($D22=\"Current\",VLOOKUP($F22,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F22,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D22=\"Current\",VLOOKUP($F22,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F22,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2},"2. BASIC",1.75,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B22,IF($C$2:$C$45=$C22,IF($H$2:$H$45=$H22,$O$2:$O$45)))))","v":1},1.5,1.75,{"$f":"IF($D22=\"Current\",VLOOKUP($F22,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",8.1999999999999993,8,"CRPFM-8",2,null,{"$f":"VLOOKUP($F23,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"8 - Marchés publics sensibles au climat"},{"$f":"VLOOKUP($F23,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"V"},{"$f":"VLOOKUP($F23,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":8.1999999999999993},{"$f":"IF($B23=\"Climat\",IF($D23=\"Current\",VLOOKUP($F23,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F23,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D23=\"Current\",VLOOKUP($F23,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F23,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"C"},{"$f":"IFERROR(IF($B23=\"Climat\",IF($D23=\"Current\",VLOOKUP($F23,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F23,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D23=\"Current\",VLOOKUP($F23,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F23,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2},"2. BASIC",1.75,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B23,IF($C$2:$C$45=$C23,IF($H$2:$H$45=$H23,$O$2:$O$45)))))","v":1},1.5,1.75,{"$f":"IF($D23=\"Current\",VLOOKUP($F23,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",8.3000000000000007,8,"CRPFM-8",3,null,{"$f":"VLOOKUP($F24,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"8 - Marchés publics sensibles au climat"},{"$f":"VLOOKUP($F24,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"V"},{"$f":"VLOOKUP($F24,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":8.3000000000000007},{"$f":"IF($B24=\"Climat\",IF($D24=\"Current\",VLOOKUP($F24,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F24,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D24=\"Current\",VLOOKUP($F24,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F24,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"C"},{"$f":"IFERROR(IF($B24=\"Climat\",IF($D24=\"Current\",VLOOKUP($F24,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F24,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D24=\"Current\",VLOOKUP($F24,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F24,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2},"2. BASIC",1.75,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B24,IF($C$2:$C$45=$C24,IF($H$2:$H$45=$H24,$O$2:$O$45)))))","v":1},1.5,1.75,{"$f":"IF($D24=\"Current\",VLOOKUP($F24,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",8.4,8,"CRPFM-8",4,null,{"$f":"VLOOKUP($F25,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"8 - Marchés publics sensibles au climat"},{"$f":"VLOOKUP($F25,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"V"},{"$f":"VLOOKUP($F25,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":8.4},{"$f":"IF($B25=\"Climat\",IF($D25=\"Current\",VLOOKUP($F25,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F25,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D25=\"Current\",VLOOKUP($F25,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F25,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D*"},{"$f":"IFERROR(IF($B25=\"Climat\",IF($D25=\"Current\",VLOOKUP($F25,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F25,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D25=\"Current\",VLOOKUP($F25,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F25,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1.75,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B25,IF($C$2:$C$45=$C25,IF($H$2:$H$45=$H25,$O$2:$O$45)))))","v":1},1.5,1.75,{"$f":"IF($D25=\"Current\",VLOOKUP($F25,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",9,9,{"$f":"\"CRPFM-\"&G26","v":"CRPFM-9"},null,"M2",null,null,null,{"$f":"IF($D26=\"Current\",VLOOKUP(F26,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F26,'Data Input'!$B$9:$N$52,6,FALSE))","v":"NA"},{"$f":"IFERROR(IF($B26=\"Climat\",IF($D26=\"Current\",VLOOKUP($F26,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F26,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D26=\"Current\",VLOOKUP($F26,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F26,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B26,IF($C$2:$C$45=$C26,IF($H$2:$H$45=$H26,$O$2:$O$45)))))","v":0},0,0]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",9.1,9,{"$f":"\"CRPFM-\"&G27","v":"CRPFM-9"},1,null,{"$f":"VLOOKUP($F27,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"9 - Gestion des recettes de la fiscalité climat"},{"$f":"VLOOKUP($F27,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"V"},{"$f":"VLOOKUP($F27,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":9.1},{"$f":"IF($B27=\"Climat\",IF($D27=\"Current\",VLOOKUP($F27,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F27,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D27=\"Current\",VLOOKUP($F27,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F27,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"NA"},{"$f":"IFERROR(IF($B27=\"Climat\",IF($D27=\"Current\",VLOOKUP($F27,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F27,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D27=\"Current\",VLOOKUP($F27,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F27,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B27,IF($C$2:$C$45=$C27,IF($H$2:$H$45=$H27,$O$2:$O$45)))))","v":0},0,0,{"$f":"IF($D27=\"Current\",VLOOKUP($F27,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",9.1999999999999993,9,{"$f":"\"CRPFM-\"&G28","v":"CRPFM-9"},2,null,{"$f":"VLOOKUP($F28,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"9 - Gestion des recettes de la fiscalité climat"},{"$f":"VLOOKUP($F28,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"V"},{"$f":"VLOOKUP($F28,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":9.1999999999999993},{"$f":"IF($B28=\"Climat\",IF($D28=\"Current\",VLOOKUP($F28,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F28,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D28=\"Current\",VLOOKUP($F28,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F28,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"NA"},{"$f":"IFERROR(IF($B28=\"Climat\",IF($D28=\"Current\",VLOOKUP($F28,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F28,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D28=\"Current\",VLOOKUP($F28,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F28,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B28,IF($C$2:$C$45=$C28,IF($H$2:$H$45=$H28,$O$2:$O$45)))))","v":0},0,0,{"$f":"IF($D28=\"Current\",VLOOKUP($F28,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",10,10,"CRPFM-10",null,"M2",null,null,null,{"$f":"IF($D29=\"Current\",VLOOKUP(F29,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F29,'Data Input'!$B$9:$N$52,6,FALSE))","v":"C+"},{"$f":"IFERROR(IF($B29=\"Climat\",IF($D29=\"Current\",VLOOKUP($F29,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F29,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D29=\"Current\",VLOOKUP($F29,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F29,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2.5},"2. BASIC",2.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B29,IF($C$2:$C$45=$C29,IF($H$2:$H$45=$H29,$O$2:$O$45)))))","v":2},2.5,2.5]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",10.1,10,"CRPFM-10",1,null,{"$f":"VLOOKUP($F30,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"10 - Conformité des dépenses liées au climat"},{"$f":"VLOOKUP($F30,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"V"},{"$f":"VLOOKUP($F30,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":10.1},{"$f":"IF($B30=\"Climat\",IF($D30=\"Current\",VLOOKUP($F30,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F30,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D30=\"Current\",VLOOKUP($F30,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F30,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"C"},{"$f":"IFERROR(IF($B30=\"Climat\",IF($D30=\"Current\",VLOOKUP($F30,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F30,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D30=\"Current\",VLOOKUP($F30,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F30,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2},"2. BASIC",2.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B30,IF($C$2:$C$45=$C30,IF($H$2:$H$45=$H30,$O$2:$O$45)))))","v":2},2.5,2.5,{"$f":"IF($D30=\"Current\",VLOOKUP($F30,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",10.199999999999999,10,"CRPFM-10",2,null,{"$f":"VLOOKUP($F31,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"10 - Conformité des dépenses liées au climat"},{"$f":"VLOOKUP($F31,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"V"},{"$f":"VLOOKUP($F31,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":10.199999999999999},{"$f":"IF($B31=\"Climat\",IF($D31=\"Current\",VLOOKUP($F31,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F31,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D31=\"Current\",VLOOKUP($F31,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F31,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"B"},{"$f":"IFERROR(IF($B31=\"Climat\",IF($D31=\"Current\",VLOOKUP($F31,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F31,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D31=\"Current\",VLOOKUP($F31,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F31,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":3},"3. SOUND",2.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B31,IF($C$2:$C$45=$C31,IF($H$2:$H$45=$H31,$O$2:$O$45)))))","v":2},2.5,2.5,{"$f":"IF($D31=\"Current\",VLOOKUP($F31,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",11,11,"CRPFM-11",null,"M2",null,null,null,{"$f":"IF($D32=\"Current\",VLOOKUP(F32,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F32,'Data Input'!$B$9:$N$52,6,FALSE))","v":"NA"},{"$f":"IFERROR(IF($B32=\"Climat\",IF($D32=\"Current\",VLOOKUP($F32,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F32,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D32=\"Current\",VLOOKUP($F32,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F32,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B32,IF($C$2:$C$45=$C32,IF($H$2:$H$45=$H32,$O$2:$O$45)))))","v":0},0,0]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",11.1,11,"CRPFM-11",1,null,{"$f":"VLOOKUP($F33,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"11 - Cadre de décentralisation budgétaire sensible au climat"},{"$f":"VLOOKUP($F33,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"II"},{"$f":"VLOOKUP($F33,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":11.1},{"$f":"IF($B33=\"Climat\",IF($D33=\"Current\",VLOOKUP($F33,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F33,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D33=\"Current\",VLOOKUP($F33,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F33,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"NA"},{"$f":"IFERROR(IF($B33=\"Climat\",IF($D33=\"Current\",VLOOKUP($F33,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F33,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D33=\"Current\",VLOOKUP($F33,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F33,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B33,IF($C$2:$C$45=$C33,IF($H$2:$H$45=$H33,$O$2:$O$45)))))","v":0},0,0,{"$f":"IF($D33=\"Current\",VLOOKUP($F33,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",11.2,11,"CRPFM-11",2,null,{"$f":"VLOOKUP($F34,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"11 - Cadre de décentralisation budgétaire sensible au climat"},{"$f":"VLOOKUP($F34,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"II"},{"$f":"VLOOKUP($F34,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":11.2},{"$f":"IF($B34=\"Climat\",IF($D34=\"Current\",VLOOKUP($F34,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F34,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D34=\"Current\",VLOOKUP($F34,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F34,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"NA"},{"$f":"IFERROR(IF($B34=\"Climat\",IF($D34=\"Current\",VLOOKUP($F34,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F34,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D34=\"Current\",VLOOKUP($F34,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F34,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B34,IF($C$2:$C$45=$C34,IF($H$2:$H$45=$H34,$O$2:$O$45)))))","v":0},0,0,{"$f":"IF($D34=\"Current\",VLOOKUP($F34,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",11.3,11,"CRPFM-11",3,null,{"$f":"VLOOKUP($F35,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"11 - Cadre de décentralisation budgétaire sensible au climat"},{"$f":"VLOOKUP($F35,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"II"},{"$f":"VLOOKUP($F35,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":11.3},{"$f":"IF($B35=\"Climat\",IF($D35=\"Current\",VLOOKUP($F35,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F35,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D35=\"Current\",VLOOKUP($F35,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F35,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"NA"},{"$f":"IFERROR(IF($B35=\"Climat\",IF($D35=\"Current\",VLOOKUP($F35,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F35,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D35=\"Current\",VLOOKUP($F35,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F35,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B35,IF($C$2:$C$45=$C35,IF($H$2:$H$45=$H35,$O$2:$O$45)))))","v":0},0,0,{"$f":"IF($D35=\"Current\",VLOOKUP($F35,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",12,12,"CRPFM-12",null,"M2",null,null,null,{"$f":"IF($D36=\"Current\",VLOOKUP(F36,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F36,'Data Input'!$B$9:$N$52,6,FALSE))","v":"C+"},{"$f":"IFERROR(IF($B36=\"Climat\",IF($D36=\"Current\",VLOOKUP($F36,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F36,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D36=\"Current\",VLOOKUP($F36,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F36,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2.5},"2. BASIC",2.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B36,IF($C$2:$C$45=$C36,IF($H$2:$H$45=$H36,$O$2:$O$45)))))","v":2},2.5,2.5]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",12.1,12,"CRPFM-12",1,null,{"$f":"VLOOKUP($F37,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"12 - Informations sur les performances liées au climat"},{"$f":"VLOOKUP($F37,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"II"},{"$f":"VLOOKUP($F37,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":12.1},{"$f":"IF($B37=\"Climat\",IF($D37=\"Current\",VLOOKUP($F37,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F37,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D37=\"Current\",VLOOKUP($F37,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F37,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"B"},{"$f":"IFERROR(IF($B37=\"Climat\",IF($D37=\"Current\",VLOOKUP($F37,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F37,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D37=\"Current\",VLOOKUP($F37,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F37,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":3},"3. SOUND",2.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B37,IF($C$2:$C$45=$C37,IF($H$2:$H$45=$H37,$O$2:$O$45)))))","v":2},2.5,2.5,{"$f":"IF($D37=\"Current\",VLOOKUP($F37,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",12.2,12,"CRPFM-12",2,null,{"$f":"VLOOKUP($F38,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"12 - Informations sur les performances liées au climat"},{"$f":"VLOOKUP($F38,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"II"},{"$f":"VLOOKUP($F38,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":12.2},{"$f":"IF($B38=\"Climat\",IF($D38=\"Current\",VLOOKUP($F38,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F38,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D38=\"Current\",VLOOKUP($F38,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F38,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"C"},{"$f":"IFERROR(IF($B38=\"Climat\",IF($D38=\"Current\",VLOOKUP($F38,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F38,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D38=\"Current\",VLOOKUP($F38,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F38,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2},"2. BASIC",2.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B38,IF($C$2:$C$45=$C38,IF($H$2:$H$45=$H38,$O$2:$O$45)))))","v":2},2.5,2.5,{"$f":"IF($D38=\"Current\",VLOOKUP($F38,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",13,13,"CRPFM-13",null,"M2",null,null,null,{"$f":"IF($D39=\"Current\",VLOOKUP(F39,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F39,'Data Input'!$B$9:$N$52,6,FALSE))","v":"D+"},{"$f":"IFERROR(IF($B39=\"Climat\",IF($D39=\"Current\",VLOOKUP($F39,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F39,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D39=\"Current\",VLOOKUP($F39,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F39,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1.5},"1. BELOW BASIC",1.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B39,IF($C$2:$C$45=$C39,IF($H$2:$H$45=$H39,$O$2:$O$45)))))","v":1},1.5,1.5]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",13.1,13,"CRPFM-13",1,null,{"$f":"VLOOKUP($F40,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"13 - Evaluation liée au climat"},{"$f":"VLOOKUP($F40,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"II"},{"$f":"VLOOKUP($F40,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":13.1},{"$f":"IF($B40=\"Climat\",IF($D40=\"Current\",VLOOKUP($F40,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F40,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D40=\"Current\",VLOOKUP($F40,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F40,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"D"},{"$f":"IFERROR(IF($B40=\"Climat\",IF($D40=\"Current\",VLOOKUP($F40,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F40,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D40=\"Current\",VLOOKUP($F40,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F40,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":1},"1. BELOW BASIC",1.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B40,IF($C$2:$C$45=$C40,IF($H$2:$H$45=$H40,$O$2:$O$45)))))","v":1},1.5,1.5,{"$f":"IF($D40=\"Current\",VLOOKUP($F40,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",13.2,13,"CRPFM-13",2,null,{"$f":"VLOOKUP($F41,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"13 - Evaluation liée au climat"},{"$f":"VLOOKUP($F41,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"VII"},{"$f":"VLOOKUP($F41,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":13.2},{"$f":"IF($B41=\"Climat\",IF($D41=\"Current\",VLOOKUP($F41,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F41,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D41=\"Current\",VLOOKUP($F41,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F41,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"C"},{"$f":"IFERROR(IF($B41=\"Climat\",IF($D41=\"Current\",VLOOKUP($F41,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F41,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D41=\"Current\",VLOOKUP($F41,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F41,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":2},"2. BASIC",1.5,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B41,IF($C$2:$C$45=$C41,IF($H$2:$H$45=$H41,$O$2:$O$45)))))","v":1},1.5,1.5,{"$f":"IF($D41=\"Current\",VLOOKUP($F41,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Indic",14,14,"CRPFM-14",null,"M2",null,null,null,{"$f":"IF($D42=\"Current\",VLOOKUP(F42,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP(F42,'Data Input'!$B$9:$N$52,6,FALSE))","v":"NA"},{"$f":"IFERROR(IF($B42=\"Climat\",IF($D42=\"Current\",VLOOKUP($F42,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F42,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D42=\"Current\",VLOOKUP($F42,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F42,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B42,IF($C$2:$C$45=$C42,IF($H$2:$H$45=$H42,$O$2:$O$45)))))","v":0},0,0]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",14.1,14,"CRPFM-14",1,null,{"$f":"VLOOKUP($F43,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"14 - Résultat des dépenses pour les actions climatiques"},{"$f":"VLOOKUP($F43,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"I"},{"$f":"VLOOKUP($F43,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":14.1},{"$f":"IF($B43=\"Climat\",IF($D43=\"Current\",VLOOKUP($F43,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F43,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D43=\"Current\",VLOOKUP($F43,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F43,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"NA"},{"$f":"IFERROR(IF($B43=\"Climat\",IF($D43=\"Current\",VLOOKUP($F43,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F43,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D43=\"Current\",VLOOKUP($F43,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F43,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B43,IF($C$2:$C$45=$C43,IF($H$2:$H$45=$H43,$O$2:$O$45)))))","v":0},0,0,{"$f":"IF($D43=\"Current\",VLOOKUP($F43,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]
[{"$f":"'Data Input'!$F$3","v":"Pefalia"},"Climat",{"$f":"'Data Input'!$F$4","v":2021},"Current","Comp",14.2,14,"CRPFM-14",2,null,{"$f":"VLOOKUP($F44,'Dimension (FR)'!$A$2:$G$52,5,FALSE)","v":"14 - Résultat des dépenses pour les actions climatiques"},{"$f":"VLOOKUP($F44,'Dimension (FR)'!$A$2:$G$52,6,FALSE)","v":"I"},{"$f":"VLOOKUP($F44,'Dimension (FR)'!$A$2:$G$52,2,FALSE)","v":14.2},{"$f":"IF($B44=\"Climat\",IF($D44=\"Current\",VLOOKUP($F44,'Data Input'!$B$9:$N$52,7,FALSE),VLOOKUP($F44,'Data Input'!$B$9:$N$52,6,FALSE)),IF($D44=\"Current\",VLOOKUP($F44,'Data Input'!$B$12:$N$53,7,FALSE),VLOOKUP($F44,'Data Input'!$B$12:$N$53,6,FALSE)))","v":"NA"},{"$f":"IFERROR(IF($B44=\"Climat\",IF($D44=\"Current\",VLOOKUP($F44,'Data Input'!$B$9:$N$52,10,FALSE),VLOOKUP($F44,'Data Input'!$B$9:$N$52,9,FALSE)),IF($D44=\"Current\",VLOOKUP($F44,'Data Input'!$B$12:$N$53,10,FALSE),VLOOKUP($F44,'Data Input'!$B$12:$N$53,9,FALSE))),\"\")","v":0},"",0,{"$f":"MIN(IF($O$2:$O$45>0,IF($B$2:$B$45=$B44,IF($C$2:$C$45=$C44,IF($H$2:$H$45=$H44,$O$2:$O$45)))))","v":0},0,0,{"$f":"IF($D44=\"Current\",VLOOKUP($F44,'Data Input'!$B$9:$N$52,12,FALSE),\"\")","v":""}]

{"sheet":"ES-Indic","index":3,"n_rows":191,"n_cols":38,"rows_kept":191,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indic","Indic","Indic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AD","AD","AD",null,null,null,null,null,null,null,null,null,null,null,"AD"]
[]
[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,4,0,"A"]
[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,3.5,0,"B+"]
[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,3,0,"B+"]
[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,"xyChart","Value",null,null,2.5,0,"C+"]
[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,1,0,null,null,2,0,"C"]
[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,1.5,0,null,null,1.5,0,"D+"]
[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,2,0,null,null,1,0,"D"]
[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,2.5,0,null,null,0.5,0,"D*"]
[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,3,0,null,null,0,0,"NA"]
[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,3.5,0,null,null,0,null,"NU"]
[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,4,0,"A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ID","Indic","4. HIGH","3. SOUND","2. BASIC","1. BELOW BASIC","Score Num"]
[null,null,1,{"$f":"\"CRPFM-\"&C42","v":"CRPFM-1"},{"$f":"IF($I42>3.5,$I42,\"\")","v":""},{"$f":"IF(AND($I42<3.5,$I42>=3),$I42,\"\")","v":3},{"$f":"IF(AND($I42<3,$I42>=2),$I42,\"\")","v":""},{"$f":"IF(AND($I42<1.75,$I42>=1),$I42,\"\")","v":""},{"$f":"VLOOKUP(C42,'Data Input'!$B$9:$K$52,10,FALSE)","v":3}]
[null,null,2,{"$f":"\"CRPFM-\"&C43","v":"CRPFM-2"},"","","",{"$f":"IF(AND($I43<1.75,$I43>=1),$I43,\"\")","v":1},{"$f":"VLOOKUP(C43,'Data Input'!$B$9:$K$52,10,FALSE)","v":1}]
[null,null,3,"CRPFM-3","","","",1,{"$f":"VLOOKUP(C44,'Data Input'!$B$9:$K$52,10,FALSE)","v":1}]
[null,null,4,"CRPFM-4","","","",1.5,{"$f":"VLOOKUP(C45,'Data Input'!$B$9:$K$52,10,FALSE)","v":1.5}]
[null,null,5,"CRPFM-5","","","",1,{"$f":"VLOOKUP(C46,'Data Input'!$B$9:$K$52,10,FALSE)","v":1}]
[null,null,6,"CRPFM-6","","","",1,{"$f":"VLOOKUP(C47,'Data Input'!$B$9:$K$52,10,FALSE)","v":1}]
[null,null,7,"CRPFM-7","","","",1.5,{"$f":"VLOOKUP(C48,'Data Input'!$B$9:$K$52,10,FALSE)","v":1.5}]
[null,null,8,"CRPFM-8","","","",1.5,{"$f":"VLOOKUP(C49,'Data Input'!$B$9:$K$52,10,FALSE)","v":1.5}]
[null,null,9,"CRPFM-9","","","","",{"$f":"VLOOKUP(C50,'Data Input'!$B$9:$K$52,10,FALSE)","v":0}]
[null,null,10,"CRPFM-10","","",2.5,"",{"$f":"VLOOKUP(C51,'Data Input'!$B$9:$K$52,10,FALSE)","v":2.5}]
[null,null,11,"CRPFM-11","","","","",{"$f":"VLOOKUP(C52,'Data Input'!$B$9:$K$52,10,FALSE)","v":0}]
[null,null,12,"CRPFM-12","","",2.5,"",{"$f":"VLOOKUP(C53,'Data Input'!$B$9:$K$52,10,FALSE)","v":2.5}]
[null,null,13,"CRPFM-13","","","",1.5,{"$f":"VLOOKUP(C54,'Data Input'!$B$9:$K$52,10,FALSE)","v":1.5}]
[null,null,14,"CRPFM-14","","","","",{"$f":"VLOOKUP(C55,'Data Input'!$B$9:$K$52,10,FALSE)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"SCORE","PERF","NB"]
[null,null,null,"NU","NON USED",1]
[null,null,null,"NA","NON USED",1]
[null,null,null,"D*","1. BELOW BASIC",1]
[null,null,null,"D","1. BELOW BASIC",1]
[null,null,null,"D+","1. BELOW BASIC",1]
[null,null,null,"C","2. BASIC",1]
[null,null,null,"C+","2. BASIC",1]
[null,null,null,"B","3. BON",1]
[null,null,null,"B+","3. BON",1]
[null,null,null,"A","4. TRES BON",1]

{"sheet":"ES-Scores","index":4,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"ID-Ind",{"$f":"'Data Input'!$G$9","v":" "},{"$f":"'Data Input'!$H$9","v":2021}]
[null,"A",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$G$12:$G$49,\"A\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Indic\",'Data Input'!$H$10:$H$54,\"A\")","v":0}]
[null,"B+",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$G$12:$G$49,\"B+\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Indic\",'Data Input'!$H$10:$H$54,\"B+\")","v":0}]
[null,"B",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$G$12:$G$49,\"B\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Indic\",'Data Input'!$H$10:$H$54,\"B\")","v":1}]
[null,"C+",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$G$12:$G$49,\"C+\")","v":2},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Indic\",'Data Input'!$H$10:$H$54,\"C+\")","v":2}]
[null,"C",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$G$12:$G$49,\"C\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Indic\",'Data Input'!$H$10:$H$54,\"C\")","v":0}]
[null,"D+",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$G$12:$G$49,\"D+\")","v":4},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Indic\",'Data Input'!$H$10:$H$54,\"D+\")","v":4}]
[null,"D",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$G$12:$G$49,\"D\")","v":4},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Indic\",'Data Input'!$H$10:$H$54,\"D\")","v":4}]
[null,"NU",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$G$12:$G$49,\"NU\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Indic\",'Data Input'!$H$10:$H$54,\"NU\")","v":0}]
[null,"NA",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$G$12:$G$49,\"NA\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Indic\",'Data Input'!$H$10:$H$54,\"NA\")","v":3}]
[null,"Total",{"$f":"SUM(C4:C12)","v":10},{"$f":"SUM(D4:D12)","v":14}]
[]
[]
[]
[]
[]
[]
[null,"ID-Comp",{"$f":"'Data Input'!$G$9","v":" "},{"$f":"'Data Input'!$H$9","v":2021}]
[null,"A",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$G$12:$G$49,\"A\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Comp\",'Data Input'!$H$10:$H$54,\"A\")","v":0}]
[null,"B",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$G$12:$G$49,\"B\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Comp\",'Data Input'!$H$10:$H$54,\"B\")","v":3}]
[null,"C",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$G$12:$G$49,\"C\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Comp\",'Data Input'!$H$10:$H$54,\"C\")","v":8}]
[null,"D",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$G$12:$G$49,\"D\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Comp\",'Data Input'!$H$10:$H$54,\"D\")","v":10}]
[null,"D*",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$G$12:$G$49,\"D*\")-C24","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Comp\",'Data Input'!$H$10:$H$54,\"D*\")-COUNTIFS('Data Input'!$D$10:$D$54,\"Comp\",'Data Input'!$H$10:$H$54,\"D\")","v":1}]
[null,"NU",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$G$12:$G$49,\"NU\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Comp\",'Data Input'!$H$10:$H$54,\"NU\")","v":0}]
[null,"NA",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$G$12:$G$49,\"NA\")","v":0},{"$f":"COUNTIFS('Data Input'!$D$10:$D$54,\"Comp\",'Data Input'!$H$10:$H$54,\"NA\")","v":7}]
[null,"Total",{"$f":"SUM(C21:C27)","v":0},{"$f":"SUM(D21:D27)","v":29}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ID-Ind","Evol"]
[null,"-",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$M$12:$M$49,\" -\")","v":0},"-"]
[null,"+",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$M$12:$M$49,\" +\")","v":0}]
[null,"=",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$M$12:$M$49,\" =\")","v":0}]
[null,"N.C",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Indic\",'Data Input'!$M$12:$M$49,\"N.C\")","v":0}]
[null,"Total",{"$f":"SUM(C38:C41)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ID-Comp","Evol"]
[null,"-",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$M$12:$M$49,\" -\")","v":0}]
[null,"+",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$M$12:$M$49,\" +\")","v":0}]
[null,"=",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$M$12:$M$49,\" =\")","v":0}]
[null,"N.C",{"$f":"COUNTIFS('Data Input'!$D$12:$D$49,\"Comp\",'Data Input'!$M$12:$M$49,\"N.C\")","v":0}]
[null,"Total",{"$f":"SUM(C54:C57)","v":0}]

{"sheet":"ES-Synth table","index":5,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,{"$f":"\"PEFA climat \"&'Data Input'!F3&\" - Year \"&'Data Input'!F4","v":"PEFA climat Pefalia - Year 2021"}]
[]
["M2",null,"Performance Indicator ",null," Indicator",1,2,3,4,null," "]
["Method",null,1,{"$f":"\"CRPFM-\"&C4","v":"CRPFM-1"},{"$f":"VLOOKUP(C4,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"1 Budget alignment with climate change strategies "},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C4=Data!$G$2:$G$44), 0)),\"\")","v":"B"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C4=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C4=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C4=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C4=Data!$G$2:$G$44), 0)),\"\")","v":"B"}]
["M2",null,2,"CRPFM-2",{"$f":"VLOOKUP(C5,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"2 Tracking climate related expenditure"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C5=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C5=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C5=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C5=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C5=Data!$G$2:$G$44), 0)),\"\")","v":"D"}]
["M2",null,3,"CRPFM-3",{"$f":"VLOOKUP(C6,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"3 Climate responsive budget circular "},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C6=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C6=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C6=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C6=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C6=Data!$G$2:$G$44), 0)),\"\")","v":"D"}]
["M1",null,4,"CRPFM-4",{"$f":"VLOOKUP(C7,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"4 Legislative scrutiny"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C7=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C7=Data!$G$2:$G$44), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C7=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C7=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C7=Data!$G$2:$G$44), 0)),\"\")","v":"D+"}]
["M1",null,5,"CRPFM-5",{"$f":"VLOOKUP(C8,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"5 Climate responsive public investment management"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C8=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C8=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C8=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C8=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C8=Data!$G$2:$G$44), 0)),\"\")","v":"D"}]
["M2",null,6,"CRPFM-6",{"$f":"VLOOKUP(C9,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"6 Climate responsive asset management"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C9=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C9=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C9=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C9=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C9=Data!$G$2:$G$44), 0)),\"\")","v":"D"}]
["M1",null,7,"CRPFM-7",{"$f":"VLOOKUP(C10,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"7 Climate related liabilities"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C10=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C10=Data!$G$2:$G$44), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C10=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C10=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C10=Data!$G$2:$G$44), 0)),\"\")","v":"D+"}]
["M2",null,8,"CRPFM-8",{"$f":"VLOOKUP(C11,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"8 Climate responsive procurement"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C11=Data!$G$2:$G$44), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C11=Data!$G$2:$G$44), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C11=Data!$G$2:$G$44), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C11=Data!$G$2:$G$44), 0)),\"\")","v":"D*"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C11=Data!$G$2:$G$44), 0)),\"\")","v":"D+"}]
["M1",null,9,"CRPFM-9",{"$f":"VLOOKUP(C12,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"9 Climate responsive revenue administration"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C12=Data!$G$2:$G$44), 0)),\"\")","v":"NA"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C12=Data!$G$2:$G$44), 0)),\"\")","v":"NA"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C12=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C12=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C12=Data!$G$2:$G$44), 0)),\"\")","v":"NA"}]
["M2",null,10,"CRPFM-10",{"$f":"VLOOKUP(C13,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"10 Compliance of climate related expenditure"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C13=Data!$G$2:$G$44), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C13=Data!$G$2:$G$44), 0)),\"\")","v":"B"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C13=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C13=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C13=Data!$G$2:$G$44), 0)),\"\")","v":"C+"}]
["M1",null,11,"CRPFM-11",{"$f":"VLOOKUP(C14,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"11 Climate responsive fiscal decentralization framework"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C14=Data!$G$2:$G$44), 0)),\"\")","v":"NA"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C14=Data!$G$2:$G$44), 0)),\"\")","v":"NA"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C14=Data!$G$2:$G$44), 0)),\"\")","v":"NA"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C14=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C14=Data!$G$2:$G$44), 0)),\"\")","v":"NA"}]
["M2",null,12,"CRPFM-12",{"$f":"VLOOKUP(C15,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"12 Climate related performance information"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C15=Data!$G$2:$G$44), 0)),\"\")","v":"B"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C15=Data!$G$2:$G$44), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C15=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C15=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C15=Data!$G$2:$G$44), 0)),\"\")","v":"C+"}]
["M2",null,13,"CRPFM-13",{"$f":"VLOOKUP(C16,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"13 Climate related performance evaluation"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C16=Data!$G$2:$G$44), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C16=Data!$G$2:$G$44), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C16=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C16=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C16=Data!$G$2:$G$44), 0)),\"\")","v":"D+"}]
["M1",null,14,"CRPFM-14",{"$f":"VLOOKUP(C17,'Dimension (UK)'!$A$2:$C$52,3,FALSE)","v":"14 Expenditure outturn for climate activities"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(F$3=Data!$I$2:$I$44)*($C17=Data!$G$2:$G$44), 0)),\"\")","v":"NA"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(G$3=Data!$I$2:$I$44)*($C17=Data!$G$2:$G$44), 0)),\"\")","v":"NA"},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(H$3=Data!$I$2:$I$44)*($C17=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(I$3=Data!$I$2:$I$44)*($C17=Data!$G$2:$G$44), 0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Data!$N$2:$N$44, MATCH(1,(J$3=Data!$I$2:$I$44)*($C17=Data!$G$2:$G$44), 0)),\"\")","v":"NA"}]

{"sheet":"Outcomes","index":6,"n_rows":46,"n_cols":40,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Indicator score ranking by Outcome",null,null,null,null,null,null,null,null,null,null,null,"AL",null,null,null,null,null,null,null,null,null,null,null,null,"AL"]
[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,4,0,"A"]
[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,3.5,0,"B+"]
[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,3,0,"B+"]
[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,2.5,0,"C+"]
[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,2,0,"C"]
[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,1.5,0,"D+"]
[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,1,0,"D"]
[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,0.5,0,"D*"]
[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,0,0,"NA"]
[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,0,0,"NR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Average:",{"$f":"AVERAGE(H39:H45)","v":1.5},null,null,null,null,null,null,null,null,"Average:",{"$f":"AVERAGE(AVERAGE(R39:R42),AVERAGE(R45:R46))","v":1.4375}]
[null,null,"Performance",{"$f":"IF(D34>3.5,\"4. HIGH\",\nIF(D34>=3,\"3. SOUND\",\nIF(D34>=2,\"2. BASIC\",\nIF(D34>=1,\"1. BELOW BASIC\",\n\"\"\n))))","v":"1. BELOW BASIC"},null,null,null,null,null,null,null,null,"Performance",{"$f":"IF(N34>3.5,\"4. HIGH\",\nIF(N34>=3,\"3. SOUND\",\nIF(N34>=2,\"2. BASIC\",\nIF(N34>=1,\"1. BELOW BASIC\",\n\"\"\n))))","v":"1. BELOW BASIC"},null,null,null,null,null,null,"Average:",{"$f":"AVERAGE(Z41:Z46)","v":1.3333333333333333}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performance",{"$f":"IF(V35>3.5,\"4. HIGH\",\nIF(V35>=3,\"3. SOUND\",\nIF(V35>=2,\"2. BASIC\",\nIF(V35>=1,\"1. BELOW BASIC\",\n\"\"\n))))","v":"1. BELOW BASIC"}]
[]
[null,"ID","Indicator","4. HIGH","3. SOUND","2. BASIC","1. BELOW BASIC","Score Num",null,null,null,"ID","Indicator","4. HIGH","3. SOUND","2. BASIC","1. BELOW BASIC","Score Num",null,"ID","Indicator","4. HIGH","3. SOUND","2. BASIC","1. BELOW BASIC","Score Num"]
[null,14,{"$f":"\"CRPFM-\"&B39","v":"CRPFM-14"},{"$f":"IF($H39>3.5,$H39,\"\")","v":""},{"$f":"IF(AND($H39<3.5,$H39>=3),$H39,\"\")","v":""},{"$f":"IF(AND($H39<3,$H39>=2),$H39,\"\")","v":""},{"$f":"IF(AND($H39<1.75,$H39>=1),$H39,\"\")","v":""},{"$f":"VLOOKUP(B39,'Data Input'!$B:$K,10,FALSE)","v":0},null,null,null,11,{"$f":"\"CRPFM-\"&L39","v":"CRPFM-11"},{"$f":"IF($R39>3.5,$R39,\"\")","v":""},{"$f":"IF(AND($R39<3.5,$R39>=3),$R39,\"\")","v":""},{"$f":"IF(AND($R39<3,$R39>=2),$R39,\"\")","v":""},{"$f":"IF(AND($R39<1.75,$R39>=1),$R39,\"\")","v":""},{"$f":"VLOOKUP(L39,'Data Input'!$B:$K,10,FALSE)","v":0},null,13,{"$f":"\"CRPFM-\"&T39","v":"CRPFM-13"},{"$f":"IF($Z39>3.5,$Z39,\"\")","v":""},{"$f":"IF(AND($Z39<3.5,$Z39>=3),$Z39,\"\")","v":""},{"$f":"IF(AND($Z39<3,$Z39>=2),$Z39,\"\")","v":""},{"$f":"IF(AND($Z39<1.75,$Z39>=1),$Z39,\"\")","v":1.5},{"$f":"VLOOKUP(T39,'Data Input'!$B:$K,10,FALSE)","v":1.5}]
[null,10,"CRPFM-10","","",{"$f":"IF(AND($H40<3,$H40>=2),$H40,\"\")+1.5","v":4},"",{"$f":"VLOOKUP(B40,'Data Input'!$B:$K,10,FALSE)","v":2.5},null,null,null,10,{"$f":"\"CRPFM-\"&L40","v":"CRPFM-10"},"","",2.5,"",{"$f":"VLOOKUP(L40,'Data Input'!$B:$K,10,FALSE)","v":2.5},null,12,"CRPFM-12","","",2.5,"",{"$f":"VLOOKUP(T40,'Data Input'!$B:$K,10,FALSE)","v":2.5}]
[null,7,"CRPFM-7","","","",1.5,{"$f":"VLOOKUP(B41,'Data Input'!$B:$K,10,FALSE)","v":1.5},null,null,null,9,"CRPFM-9","","","","",{"$f":"VLOOKUP(L41,'Data Input'!$B:$K,10,FALSE)","v":0},null,11,"CRPFM-11","","","","",{"$f":"VLOOKUP(T41,'Data Input'!$B:$K,10,FALSE)","v":0}]
[null,6,{"$f":"\"CRPFM-\"&B42","v":"CRPFM-6"},"","","",1,{"$f":"VLOOKUP(B42,'Data Input'!$B:$K,10,FALSE)","v":1},null,null,null,5,"CRPFM-5","","","",1,{"$f":"VLOOKUP(L42,'Data Input'!$B:$K,10,FALSE)","v":1},null,10,"CRPFM-10","","",2.5,"",{"$f":"VLOOKUP(T42,'Data Input'!$B:$K,10,FALSE)","v":2.5}]
[null,5,"CRPFM-5","","","",1,{"$f":"VLOOKUP(B43,'Data Input'!$B:$K,10,FALSE)","v":1},null,null,null,4,{"$f":"\"CRPFM-\"&L43","v":"CRPFM-4"},"","","",1.5,{"$f":"VLOOKUP(L43,'Data Input'!$B:$K,10,FALSE)","v":1.5},null,9,"CRPFM-9","","","","",{"$f":"VLOOKUP(T43,'Data Input'!$B:$K,10,FALSE)","v":0}]
[null,1,{"$f":"\"CRPFM-\"&B44","v":"CRPFM-1"},"",3,"","",{"$f":"VLOOKUP(B44,'Data Input'!$B:$K,10,FALSE)","v":3},null,null,null,3,"CRPFM-3","","","",1,{"$f":"VLOOKUP(L44,'Data Input'!$B:$K,10,FALSE)","v":1},null,8,"CRPFM-8","","","",1.5,{"$f":"VLOOKUP(T44,'Data Input'!$B:$K,10,FALSE)","v":1.5}]
[null,null,null,null,null,null,null,null,null,null,null,2,"CRPFM-2","","","",1,{"$f":"VLOOKUP(L45,'Data Input'!$B:$K,10,FALSE)","v":1},null,5,"CRPFM-5","","","",1,{"$f":"VLOOKUP(T45,'Data Input'!$B:$K,10,FALSE)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,1,"CRPFM-1","",3,"","",{"$f":"VLOOKUP(L46,'Data Input'!$B:$K,10,FALSE)","v":3},null,1,"CRPFM-1","",3,"","",{"$f":"VLOOKUP(T46,'Data Input'!$B:$K,10,FALSE)","v":3}]

{"sheet":"Profile","index":7,"n_rows":111,"n_cols":26,"rows_kept":111,"cut":false,"hidden":true,"merged":[]}
["Years",null,"Score ","Comp","Meta"]
[2000,null,"A","Yes","Team leader"]
[2001,null,"B","No","Country"]
[2002,null,"C",null,"Year of assessment"]
[2003,null,"D"]
[2004,null,"D*"]
[2005,null,"NU"]
[2006,null,"NA"]
[2007]
[2008]
[2009]
[2010]
[2011]
[2012]
[2013]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]
[2031]
[2032]
[2033]
[2034]
["NA"]
[]
[]
[]
["Years",null,"Score 2011 FMK","Score 2016 FMK","Comp","Names"]
[2000,null,"A","A","Yes","Pillar"]
[2001,null,"B","B","No","Indicator"]
[2002,null,"C","C",null,"Dimensions"]
[2003,null,"D","D",null,"1. Overall Budget Discipline"]
[2004,null,"NU","D*",null,"2. Strategic allocation of resources "]
[2005,null,"NA","NU",null,"3. Effective service delivery "]
[2006,null,"NR","NA",null,"Team Leader"]
[2007,null,null,null,null,"Country"]
[2008,null,null,null,null,"Overall Rating"]
[2009,null,null,null,null,"Current assessment"]
[2010,null,null,null,null,"Previous assessment"]
[2011,null,null,null,null,"Score by pillar / indicator"]
[2012,null,null,null,null,"Indicators / Dimensions "]
[2013,null,null,null,null,"Number of dimensions per score "]
[2014,null,null,null,null,"Year "]
[2015,null,null,null,null,"PEFA scores by indicators "]
[2016,null,null,null,null,"PEFA scores by dimension"]
[2017,null,null,null,null,"Evolution of scores (2016 Table)"]
[2018,null,null,null,null,"Scores - Year "]
[2019,null,null,null,null,"2011 Fmk"]
[2020,null,null,null,null,"Justification of PEFA scores  "]
[2021,null,null,null,null,"2016 Fmk"]
[2022,null,null,null,null,"Scores evolution for indicators "]
[2023,null,null,null,null,"Scores evolution for dimensions "]
[2024,null,null,null,null,"Score Evolution "]
[2025,null,null,null,null,"Scores by pillar "]
[2026,null,null,null,null,"1. Low"]
[2027,null,null,null,null,"2. Basic"]
[2028,null,null,null,null,"3. Good"]
[2029,null,null,null,null,"4. Very good"]
[2030,null,null,null,null,"Strength"]
[2031,null,null,null,null,"Weakness"]
[2032,null,null,null,null,"Average"]
[2033,null,null,null,null,"Rationale for the assessment"]
[2034,null,null,null,null,"Ranking of indicators according to their score"]
["NA",null,null,null,null,"Cross-tabulation of PEFA indicators and budget results"]
[null,null,null,null,null,"Numbers"]
[null,null,null,null,null,"Change in scores compared with the previous assessment (2016 framework)"]
[null,null,null,null,null,"Change in scores compared with the previous assessment (2011 framework)"]
[null,null,null,null,null,"Global score"]
[null,null,null,null,null,"PEFA assessment - 2016 Framework"]
[null,null,null,null,null,"PEFA assessment - 2011 Framework"]
[null,null,null,null,null,"Number of indicators/dimensions by scores (2016 fmk)"]
[null,null,null,null,null,"Number of indicators by scores (2016 fmk)"]
[null,null,null,null,null,"Number of dimensions by scores (2016 fmk)"]
[null,null,null,null,null,"Evolution of the number of indicators/dimensions by scores (2016 fmk)"]
[null,null,null,null,null,"Evolution of the number of indicators by scores (2016 fmk)"]
[null,null,null,null,null,"Evolution of the number of dimensions by scores (2016 fmk)"]
[null,null,null,null,null,"Evolution of the number of indicators/dimensions by scores (2011 fmk)"]
[null,null,null,null,null,"Evolution of the number of indicators by scores (2011 fmk)"]
[null,null,null,null,null,"Evolution of the number of dimensions by scores (2011 fmk)"]
[null,null,null,null,null,"Justification of the evolution"]
[null,null,null,null,null,"Sheets passwords",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheets passwords"]
[null,null,null,null,null,"Data Input : Sec!Pefa2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User's instructions:Indic"]
[null,null,null,null,null,"ES-Scores: Sec!Pefa2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Input:Sec!Pefa2018"]
[null,null,null,null,null,"ES-Synth table: Sec!Pefa2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data:Indic"]
[null,null,null,null,null,"Outcomes: Sec!Pefa2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ES-Indic:Indic"]
[null,null,null,null,null,"ES-Indic: Indic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ES-Scores:Sec!Pefa2018"]
[null,null,null,null,null,"General password : Indic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ES-Synth table:Sec!Pefa2018"]
[null,null,null,null,null,"Hidden tables:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outcomes:Sec!Pefa2018"]
[null,null,null,null,null,"Profile",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"colors:Indic"]
[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,"Dimension (FR):Indic"]
[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,"Dimension (UK):Indic"]
[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,"Dimension Outcomes:Indic"]
[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,"Scoring:Indic"]
[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,"Methodology:Indic"]
[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,"DimOutput:Indic"]
[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,"DimIndic:Indic"]
[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,"DimPillar:Indic"]
[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,"General password:Indic"]

{"sheet":"colors","index":8,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[1,"ELEMENTAIRE","Sec!Pefa2018",null,"Sheets with Charts with numeric data labels data",null,"Sheets with tables"]
[2,"BASIQUE",null,null,"ES-Indic",null,"Sheet Name","Numeric Data Labels?","Start row","Start Column","Column used to find last row"]
[3,"3. Suffisant",null,null,null,null,"ES-Synth table","N",3,3,3]
[4,"Avancé"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Column1"]

{"sheet":"Dimension (FR)","index":9,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["ID","ID-Dim3","Dimension Niv 3","ID-Dim2","Dimension Niv 2","ID-Dim1","Dimension Niv 1"]
[1.1000000000000001,1.1000000000000001,"1.1. Alignement du budget sur les stratégies de lutte contre le changement climatique  ",1,"1 - Alignement du budget sur les stratégies climat",{"$f":"VLOOKUP($A2,DimPillar!$A$2:$C$30,2,FALSE)","v":"IV"}," Stratégie budgétaire et budgétisation fondées sur des politiques "]
[2.1,2.1,"2.1. Suivi des dépenses liées au climat  ",2,"2 - Suivi des dépenses liées au climat",{"$f":"VLOOKUP($A3,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"}," Transparence "]
[3.1,3.1,"3.1. Circulaire budgétaire",3,"3 - Circulaire budgétaire sensible au climat",{"$f":"VLOOKUP($A4,DimPillar!$A$2:$C$30,2,FALSE)","v":"IV"}," Stratégie budgétaire et budgétisation fondées sur les politiques publiques "]
[4.0999999999999996,4.0999999999999996,"4.1. Contrôle législatif des budgets",4,"4 - Examen par le pouvoir législatif",{"$f":"VLOOKUP($A5,DimPillar!$A$2:$C$30,2,FALSE)","v":"IV"}," Stratégie budgétaire et budgétisation fondées sur des politiques "]
[4.2,4.2,"4.2. Examen législatif des rapports d'audit et d'évaluation",4,"4 - Examen par le pouvoir législatif",{"$f":"VLOOKUP($A6,DimPillar!$A$2:$C$30,2,FALSE)","v":"VII"}," Contrôle et audit externes "]
[5.0999999999999996,5.0999999999999996,"5.1. Dispositions relatives au climat dans le cadre réglementaire de la gestion des investissements publics",5,"5 - Gestion sensible au climat des investissements publics",{"$f":"VLOOKUP($A7,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"}," Gestion des actifs et des passifs "]
[5.2,5.2,"5.2. Sélection des projets liés au climat",5,"5 - Gestion sensible au climat des investissements publics",{"$f":"VLOOKUP($A8,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"}," Gestion des actifs et des passifs "]
[5.3,5.3,"5.3. Dispositions relatives au climat pour l'évaluation des projets",5,"5 - Gestion sensible au climat des investissements publics",{"$f":"VLOOKUP($A9,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"}," Gestion des actifs et des passifs "]
[5.4,5.4,"5.4. Rapports des entités chargées de la mise en œuvre",5,"5 - Gestion sensible au climat des investissements publics",{"$f":"VLOOKUP($A10,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"}," Gestion des actifs et des passifs "]
[6.1,6.1,"6.1. Gestion des actifs non financiers adaptée au climat",6,"6 - Gestion sensible au climat des actifs non financiers",{"$f":"VLOOKUP($A11,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"}," Gestion des actifs et des passifs "]
[7.1,7.1,"7.1. Risques fiscaux liés au climat  ",7,"7 - Passifs liés au climat",{"$f":"VLOOKUP($A12,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"}," Gestion des actifs et des passifs "]
[7.2,7.2,"7.2. Dette et garanties liées au climat  ",7,"7 - Passifs liés au climat",{"$f":"VLOOKUP($A13,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"}," Gestion des actifs et des passifs "]
[8.1,8.1,"8.1. Cadre pour des marchés publics sensibles au climat",8,"8 - Marchés publics sensibles au climat",{"$f":"VLOOKUP($A14,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"}," Prévisibilité et contrôle de l'exécution du budget "]
[8.1999999999999993,8.1999999999999993,"8.2. Opérations de passation de marchés publics sensibles au climat dispositifs de décentralisation",8,"8 - Marchés publics sensibles au climat",{"$f":"VLOOKUP($A15,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"}," Prévisibilité et contrôle de l'exécution du budget "]
[8.3000000000000007,8.3000000000000007,"8.3. Suivi des marchés publics sensibles au climat",8,"8 - Marchés publics sensibles au climat",{"$f":"VLOOKUP($A16,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"}," Prévisibilité et contrôle de l'exécution du budget "]
[8.4,8.4,"8.4. Rapport sur les marchés publics sensibles au climat",8,"8 - Marchés publics sensibles au climat",{"$f":"VLOOKUP($A17,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"}," Prévisibilité et contrôle de l'exécution du budget "]
[9.1,9.1,"9.1. Gestion, audit et enquête sur les taxes liées au climat",9,"9 - Gestion des recettes de la fiscalité climat",{"$f":"VLOOKUP($A18,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"}," Prévisibilité et contrôle de l'exécution du budget "]
[9.1999999999999993,9.1999999999999993,"9.2. Arriérés de taxes liées au climat",9,"9 - Gestion des recettes de la fiscalité climat",{"$f":"VLOOKUP($A19,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"}," Prévisibilité et contrôle de l'exécution du budget "]
[10.1,10.1,"10.1. Efficacité du système de contrôle",10,"10 - Conformité des dépenses liées au climat",{"$f":"VLOOKUP($A20,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"}," Prévisibilité et contrôle de l'exécution du budget "]
[10.199999999999999,10.199999999999999,"10.2. Audit de la conformité des transactions",10,"10 - Conformité des dépenses liées au climat",{"$f":"VLOOKUP($A21,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"}," Prévisibilité et contrôle de l'exécution du budget "]
[11.1,11.1,"11.1. Fiscale adaptés au climat",11,"11 - Cadre de décentralisation budgétaire sensible au climat",{"$f":"VLOOKUP($A22,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"}," Transparence "]
[11.2,11.2,"11.2. Transferts fiscaux sensibles au climat",11,"11 - Cadre de décentralisation budgétaire sensible au climat",{"$f":"VLOOKUP($A23,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"}," Transparence "]
[11.3,11.3,"11.3. Dispositifs de GFP sensibles au climat appliqués par les gouvernements infranationaux",11,"11 - Cadre de décentralisation budgétaire sensible au climat",{"$f":"VLOOKUP($A24,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"}," Transparence "]
[12.1,12.1,"12.1. Informations relatives au climat dans les plans de performance",12,"12 - Informations sur les performances liées au climat",{"$f":"VLOOKUP($A25,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"}," Transparence "]
[12.2,12.2,"12.2. Informations relatives au climat dans les rapports de performance  ",12,"12 - Informations sur les performances liées au climat",{"$f":"VLOOKUP($A26,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"}," Transparence "]
[13.1,13.1,"13.1. Évaluation des dépenses liées au climat",13,"13 - Evaluation liée au climat",{"$f":"VLOOKUP($A27,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"}," Transparence "]
[13.2,13.2,"13.2. Évaluation des taxes liées au climat",13,"13 - Evaluation liée au climat",{"$f":"VLOOKUP($A28,DimPillar!$A$2:$C$30,2,FALSE)","v":"VII"}," Contrôle et audit externes "]
[14.1,14.1,"14.1. Résultat global des dépenses liées au climat  ",14,"14 - Résultat des dépenses pour les actions climatiques",{"$f":"VLOOKUP($A29,DimPillar!$A$2:$C$30,2,FALSE)","v":"I"}," Fiabilité du budget "]
[14.2,14.2,"14.2. Composition des dépenses liées au climat - résultat  ",14,"14 - Résultat des dépenses pour les actions climatiques",{"$f":"VLOOKUP($A30,DimPillar!$A$2:$C$30,2,FALSE)","v":"I"}," Fiabilité du budget "]
[1,1,"1 - Alignement du budget sur les stratégies climat"]
[2,2,"2 - Suivi des dépenses liées au climat"]
[3,3,"3 - Circulaire budgétaire sensible au climat"]
[4,4,"4 - Examen par le pouvoir législatif"]
[5,5,"5 - Gestion sensible au climat des investissements publics"]
[6,6,"6 - Gestion sensible au climat des actifs non financiers"]
[7,7,"7 - Passifs liés au climat"]
[8,8,"8 - Marchés publics sensibles au climat"]
[9,9,"9 - Gestion des recettes de la fiscalité climat"]
[10,10,"10 - Conformité des dépenses liées au climat"]
[11,11,"11 - Cadre de décentralisation budgétaire sensible au climat"]
[12,12,"12 - Informations sur les performances liées au climat"]
[13,13,"13 - Evaluation liée au climat"]
[14,14,"14 - Résultat des dépenses pour les actions climatiques"]

{"sheet":"Dimension (UK)","index":10,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["ID","ID-Dim3","Dimension Niv 3","ID-Dim2","Dimension Niv 2","ID-Dim1","Dimension Niv 1"]
[1.1000000000000001,1.1000000000000001,"1.1 Budget alignment with climate change strategies",1,{"$f":"VLOOKUP(D2,DimIndic!$A$2:$B$15,2,FALSE)","v":"1 Budget alignment with climate change strategies "},{"$f":"VLOOKUP($A2,DimPillar!$A$2:$C$30,2,FALSE)","v":"IV"},{"$f":"VLOOKUP($A2,DimPillar!$A$2:$C$30,3,FALSE)","v":" Policy-based fiscal strategy and budgeting "}]
[2.1,2.1,"2.1 Tracking climate related expenditure",2,{"$f":"VLOOKUP(D3,DimIndic!$A$2:$B$15,2,FALSE)","v":"2 Tracking climate related expenditure"},{"$f":"VLOOKUP($A3,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"},{"$f":"VLOOKUP($A3,DimPillar!$A$2:$C$30,3,FALSE)","v":" Transparency "}]
[3.1,3.1,"3.1 Budget circular",3,{"$f":"VLOOKUP(D4,DimIndic!$A$2:$B$15,2,FALSE)","v":"3 Climate responsive budget circular "},{"$f":"VLOOKUP($A4,DimPillar!$A$2:$C$30,2,FALSE)","v":"IV"},{"$f":"VLOOKUP($A4,DimPillar!$A$2:$C$30,3,FALSE)","v":" Policy-based fiscal strategy and budgeting "}]
[4.0999999999999996,4.0999999999999996,"4.1 Legislative scrutiny of budget",4,{"$f":"VLOOKUP(D5,DimIndic!$A$2:$B$15,2,FALSE)","v":"4 Legislative scrutiny"},{"$f":"VLOOKUP($A5,DimPillar!$A$2:$C$30,2,FALSE)","v":"IV"},{"$f":"VLOOKUP($A5,DimPillar!$A$2:$C$30,3,FALSE)","v":" Policy-based fiscal strategy and budgeting "}]
[4.2,4.2,"4.2 Legislative scrutiny of audit and evaluation reports",4,{"$f":"VLOOKUP(D6,DimIndic!$A$2:$B$15,2,FALSE)","v":"4 Legislative scrutiny"},{"$f":"VLOOKUP($A6,DimPillar!$A$2:$C$30,2,FALSE)","v":"VII"},{"$f":"VLOOKUP($A6,DimPillar!$A$2:$C$30,3,FALSE)","v":" External scrutiny and audit "}]
[5.0999999999999996,5.0999999999999996,"5.1 Climate related provisions in regulatory framework for public investment management",5,{"$f":"VLOOKUP(D7,DimIndic!$A$2:$B$15,2,FALSE)","v":"5 Climate responsive public investment management"},{"$f":"VLOOKUP($A7,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"},{"$f":"VLOOKUP($A7,DimPillar!$A$2:$C$30,3,FALSE)","v":" Management of assets and liabilities "}]
[5.2,5.2,"5.2 Climate related project selection",5,{"$f":"VLOOKUP(D8,DimIndic!$A$2:$B$15,2,FALSE)","v":"5 Climate responsive public investment management"},{"$f":"VLOOKUP($A8,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"},{"$f":"VLOOKUP($A8,DimPillar!$A$2:$C$30,3,FALSE)","v":" Management of assets and liabilities "}]
[5.3,5.3,"5.3 Climate related provisions for project appraisal",5,{"$f":"VLOOKUP(D9,DimIndic!$A$2:$B$15,2,FALSE)","v":"5 Climate responsive public investment management"},{"$f":"VLOOKUP($A9,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"},{"$f":"VLOOKUP($A9,DimPillar!$A$2:$C$30,3,FALSE)","v":" Management of assets and liabilities "}]
[5.4,5.4,"5.4 Reporting from entities in charge of implementation",5,{"$f":"VLOOKUP(D10,DimIndic!$A$2:$B$15,2,FALSE)","v":"5 Climate responsive public investment management"},{"$f":"VLOOKUP($A10,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"},{"$f":"VLOOKUP($A10,DimPillar!$A$2:$C$30,3,FALSE)","v":" Management of assets and liabilities "}]
[6.1,6.1,"6.1 Climate responsive non-financial assets management",6,{"$f":"VLOOKUP(D11,DimIndic!$A$2:$B$15,2,FALSE)","v":"6 Climate responsive asset management"},{"$f":"VLOOKUP($A11,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"},{"$f":"VLOOKUP($A11,DimPillar!$A$2:$C$30,3,FALSE)","v":" Management of assets and liabilities "}]
[7.1,7.1,"7.1 Climate related fiscal risks",7,{"$f":"VLOOKUP(D12,DimIndic!$A$2:$B$15,2,FALSE)","v":"7 Climate related liabilities"},{"$f":"VLOOKUP($A12,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"},{"$f":"VLOOKUP($A12,DimPillar!$A$2:$C$30,3,FALSE)","v":" Management of assets and liabilities "}]
[7.2,7.2,"7.2 Climate related debt and guarantees",7,{"$f":"VLOOKUP(D13,DimIndic!$A$2:$B$15,2,FALSE)","v":"7 Climate related liabilities"},{"$f":"VLOOKUP($A13,DimPillar!$A$2:$C$30,2,FALSE)","v":"III"},{"$f":"VLOOKUP($A13,DimPillar!$A$2:$C$30,3,FALSE)","v":" Management of assets and liabilities "}]
[8.1,8.1,"8.1 Climate responsive procurement framework",8,{"$f":"VLOOKUP(D14,DimIndic!$A$2:$B$15,2,FALSE)","v":"8 Climate responsive procurement"},{"$f":"VLOOKUP($A14,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"},{"$f":"VLOOKUP($A14,DimPillar!$A$2:$C$30,3,FALSE)","v":" Predictability and control in budget execution "}]
[8.1999999999999993,8.1999999999999993,"8.2 Climate responsive public procurement operations",8,{"$f":"VLOOKUP(D15,DimIndic!$A$2:$B$15,2,FALSE)","v":"8 Climate responsive procurement"},{"$f":"VLOOKUP($A15,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"},{"$f":"VLOOKUP($A15,DimPillar!$A$2:$C$30,3,FALSE)","v":" Predictability and control in budget execution "}]
[8.3000000000000007,8.3000000000000007,"8.3 Climate responsive public procurement monitoring",8,{"$f":"VLOOKUP(D16,DimIndic!$A$2:$B$15,2,FALSE)","v":"8 Climate responsive procurement"},{"$f":"VLOOKUP($A16,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"},{"$f":"VLOOKUP($A16,DimPillar!$A$2:$C$30,3,FALSE)","v":" Predictability and control in budget execution "}]
[8.4,8.4,"8.4 Climate responsive public procurement reporting",8,{"$f":"VLOOKUP(D17,DimIndic!$A$2:$B$15,2,FALSE)","v":"8 Climate responsive procurement"},{"$f":"VLOOKUP($A17,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"},{"$f":"VLOOKUP($A17,DimPillar!$A$2:$C$30,3,FALSE)","v":" Predictability and control in budget execution "}]
[9.1,9.1,"9.1 Climate related tax management, audit and investigation",9,{"$f":"VLOOKUP(D18,DimIndic!$A$2:$B$15,2,FALSE)","v":"9 Climate responsive revenue administration"},{"$f":"VLOOKUP($A18,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"},{"$f":"VLOOKUP($A18,DimPillar!$A$2:$C$30,3,FALSE)","v":" Predictability and control in budget execution "}]
[9.1999999999999993,9.1999999999999993,"9.2 Climate related tax arrears",9,{"$f":"VLOOKUP(D19,DimIndic!$A$2:$B$15,2,FALSE)","v":"9 Climate responsive revenue administration"},{"$f":"VLOOKUP($A19,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"},{"$f":"VLOOKUP($A19,DimPillar!$A$2:$C$30,3,FALSE)","v":" Predictability and control in budget execution "}]
[10.1,10.1,"10.1 Effectiveness of the systems of controls",10,{"$f":"VLOOKUP(D20,DimIndic!$A$2:$B$15,2,FALSE)","v":"10 Compliance of climate related expenditure"},{"$f":"VLOOKUP($A20,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"},{"$f":"VLOOKUP($A20,DimPillar!$A$2:$C$30,3,FALSE)","v":" Predictability and control in budget execution "}]
[10.199999999999999,10.199999999999999,"10.2 Compliance of transactions",10,{"$f":"VLOOKUP(D21,DimIndic!$A$2:$B$15,2,FALSE)","v":"10 Compliance of climate related expenditure"},{"$f":"VLOOKUP($A21,DimPillar!$A$2:$C$30,2,FALSE)","v":"V"},{"$f":"VLOOKUP($A21,DimPillar!$A$2:$C$30,3,FALSE)","v":" Predictability and control in budget execution "}]
[11.1,11.1,"11.1 Climate responsive fiscal decentralization arrangements",11,{"$f":"VLOOKUP(D22,DimIndic!$A$2:$B$15,2,FALSE)","v":"11 Climate responsive fiscal decentralization framework"},{"$f":"VLOOKUP($A22,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"},{"$f":"VLOOKUP($A22,DimPillar!$A$2:$C$30,3,FALSE)","v":" Transparency "}]
[11.2,11.2,"11.2 Climate responsive fiscal transfers",11,{"$f":"VLOOKUP(D23,DimIndic!$A$2:$B$15,2,FALSE)","v":"11 Climate responsive fiscal decentralization framework"},{"$f":"VLOOKUP($A23,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"},{"$f":"VLOOKUP($A23,DimPillar!$A$2:$C$30,3,FALSE)","v":" Transparency "}]
[11.3,11.3,"11.3 Climate responsive PFM arrangements applied by subnational governments",11,{"$f":"VLOOKUP(D24,DimIndic!$A$2:$B$15,2,FALSE)","v":"11 Climate responsive fiscal decentralization framework"},{"$f":"VLOOKUP($A24,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"},{"$f":"VLOOKUP($A24,DimPillar!$A$2:$C$30,3,FALSE)","v":" Transparency "}]
[12.1,12.1,"12.1 Climate related information in performance plans",12,{"$f":"VLOOKUP(D25,DimIndic!$A$2:$B$15,2,FALSE)","v":"12 Climate related performance information"},{"$f":"VLOOKUP($A25,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"},{"$f":"VLOOKUP($A25,DimPillar!$A$2:$C$30,3,FALSE)","v":" Transparency "}]
[12.2,12.2,"12.2 Climate related information in performance reports",12,{"$f":"VLOOKUP(D26,DimIndic!$A$2:$B$15,2,FALSE)","v":"12 Climate related performance information"},{"$f":"VLOOKUP($A26,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"},{"$f":"VLOOKUP($A26,DimPillar!$A$2:$C$30,3,FALSE)","v":" Transparency "}]
[13.1,13.1,"13.1 Climate related evaluation of expenditure",13,{"$f":"VLOOKUP(D27,DimIndic!$A$2:$B$15,2,FALSE)","v":"13 Climate related performance evaluation"},{"$f":"VLOOKUP($A27,DimPillar!$A$2:$C$30,2,FALSE)","v":"II"},{"$f":"VLOOKUP($A27,DimPillar!$A$2:$C$30,3,FALSE)","v":" Transparency "}]
[13.2,13.2,"13.2 Climate related evaluation of taxes",13,{"$f":"VLOOKUP(D28,DimIndic!$A$2:$B$15,2,FALSE)","v":"13 Climate related performance evaluation"},{"$f":"VLOOKUP($A28,DimPillar!$A$2:$C$30,2,FALSE)","v":"VII"},{"$f":"VLOOKUP($A28,DimPillar!$A$2:$C$30,3,FALSE)","v":" External scrutiny and audit "}]
[14.1,14.1,"14.1 Aggregate climate related expenditure outturn",14,{"$f":"VLOOKUP(D29,DimIndic!$A$2:$B$15,2,FALSE)","v":"14 Expenditure outturn for climate activities"},{"$f":"VLOOKUP($A29,DimPillar!$A$2:$C$30,2,FALSE)","v":"I"},{"$f":"VLOOKUP($A29,DimPillar!$A$2:$C$30,3,FALSE)","v":" Budget reliability "}]
[14.2,14.2,"14.2 Climate related expenditure composition outturn",14,{"$f":"VLOOKUP(D30,DimIndic!$A$2:$B$15,2,FALSE)","v":"14 Expenditure outturn for climate activities"},{"$f":"VLOOKUP($A30,DimPillar!$A$2:$C$30,2,FALSE)","v":"I"},{"$f":"VLOOKUP($A30,DimPillar!$A$2:$C$30,3,FALSE)","v":" Budget reliability "}]
[1,1,"1 Budget alignment with climate change strategies "]
[2,2,"2 Tracking climate related expenditure"]
[3,3,"3 Climate responsive budget circular "]
[4,4,"4 Legislative scrutiny"]
[5,5,"5 Climate responsive public investment management"]
[6,6,"6 Climate responsive asset management"]
[7,7,"7 Climate related liabilities"]
[8,8,"8 Climate responsive procurement"]
[9,9,"9 Climate responsive revenue administration"]
[10,10,"10 Compliance of climate related expenditure"]
[11,11,"11 Climate responsive fiscal decentralization framework"]
[12,12,"12 Climate related performance information"]
[13,13,"13 Climate related performance evaluation"]
[14,14,"14 Expenditure outturn for climate activities"]

{"sheet":"Dimension Outcomes","index":11,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Outcome","PEFA Climate Indicator ","Component","Column1","Column2"]
["Aggregate fiscal discipline ","CRPFM–10 Compliance of climate related expenditure ",10.199999999999999,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":3}]
["Aggregate fiscal discipline ","CRPFM–10 Compliance of climate related expenditure ",10.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":2}]
["Aggregate fiscal discipline ","CRPFM–1 Budget alignment with climate change strategies  ",1.1000000000000001,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":3}]
["Efficient service delivery ","CRPFM-9 Climate responsive revenue administration ",9.1999999999999993,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Efficient service delivery ","CRPFM-13 Climate related performance evaluation ",13.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Efficient service delivery ","CRPFM–10 Compliance of climate related expenditure ",10.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":2}]
["Efficient service delivery ","CRPFM–5 Climate responsive public investment management ",5.4,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Efficient service delivery ","CRPFM–8 Climate responsive procurement ",8.3000000000000007,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":2}]
["Efficient service delivery ","CRPFM–8 Climate responsive procurement ",8.4,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Efficient service delivery ","CRPFM–8 Climate responsive procurement ",8.1999999999999993,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":2}]
["Efficient service delivery ","CRPFM-9 Climate responsive revenue administration ",9.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Efficient service delivery ","CRPFM–8 Climate responsive procurement ",8.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":2}]
["Efficient service delivery ","CRPFM–1 Budget alignment with climate change strategies  ",1.1000000000000001,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":3}]
["Efficient service delivery ","CRPFM–10 Compliance of climate related expenditure ",10.199999999999999,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":3}]
["Efficient service delivery ","CRPFM-13 Climate related performance evaluation ",13.2,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":2}]
["Efficient service delivery ","CRPFM–4 Legislative scrutiny ",4.2,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":2}]
["Efficient service delivery ","CRPFM–12 Climate related performance information ",12.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":3}]
["Efficient service delivery ","CRPFM–12 Climate related performance information ",12.2,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":2}]
["Efficient service delivery ","CRPFM–11 Climate responsive fiscal decentralization framework ",11.2,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Efficient service delivery ","CRPFM–11 Climate responsive fiscal decentralization framework ",11.3,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Strategic allocation of resources ","CRPFM–14 Expenditure outturn for climate activities ",14.2,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Strategic allocation of resources ","CRPFM-9 Climate responsive revenue administration ",9.1999999999999993,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Strategic allocation of resources ","CRPFM-9 Climate responsive revenue administration ",9.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Strategic allocation of resources ","CRPFM–14 Expenditure outturn for climate activities ",14.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Strategic allocation of resources ","CRPFM–11 Climate responsive fiscal decentralization framework ",11.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Strategic allocation of resources ","CRPFM–11 Climate responsive fiscal decentralization framework ",11.2,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Strategic allocation of resources ","CRPFM–11 Climate responsive fiscal decentralization framework ",11.3,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":0}]
["Strategic allocation of resources ","CRPFM–3 Climate responsive budget circular  ",3.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Strategic allocation of resources ","CRPFM–4 Legislative scrutiny ",4.0999999999999996,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Strategic allocation of resources ","CRPFM–2 Tracking climate related expenditure ",2.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Strategic allocation of resources ","CRPFM–6 Climate responsive asset management ",6.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Strategic allocation of resources ","CRPFM–7 Climate related liabilities ",7.1,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Strategic allocation of resources ","CRPFM–7 Climate related liabilities ",7.2,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":2}]
["Strategic allocation of resources ","CRPFM–5 Climate responsive public investment management ",5.0999999999999996,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Strategic allocation of resources ","CRPFM–5 Climate responsive public investment management ",5.2,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]
["Strategic allocation of resources ","CRPFM–5 Climate responsive public investment management ",5.3,{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,12,FALSE)","v":""},{"$f":"VLOOKUP(Table1_2[[#This Row],[Component]],'Data Input'!$B:$N,10,FALSE)","v":1}]

{"sheet":"Scoring","index":12,"n_rows":120,"n_cols":5,"rows_kept":120,"cut":false,"hidden":true,"merged":[]}
["ID","Score","Justification"]
[1.1000000000000001,"A","The system in place fulfills 8 elements, including at least 4 basic elements (1-6). "]
[1.1000000000000001,"B","The system in place fulfills 6 elements, including at least 3 basic elements (1-6). "]
[1.1000000000000001,"C","The system in place fulfills at least 3 basic elements (1-6). "]
[1.1000000000000001,"D","Performance is less than required for a C score.  "]
[2.1,"A","The system in place to track climate related expenditure fulfills 7 elements, including Element 1 and at least 3 other basic elements (2-5). "]
[2.1,"B","The system in place to track climate related expenditure fulfills 5 elements, including Element 1 and at least 3 other basic elements (2-5). "]
[2.1,"C","The system in place to track climate related expenditure fulfills at least 3 basic elements, including Element 1 (2-5). "]
[2.1,"D","Performance is less than required for a C score.  "]
[3.1,"A","The budget circular provides a methodology to track climate change related expenditure, as well as expenditures that are counter to climate policy. It contains guidance on how to factor climate change mitigation and adaptation planned expenditure into budget proposals, and on how to limit expenditures that are counter to climate. It refers to the national climate change strategies.  "]
[3.1,"B","The budget circular provides a methodology to track climate change related expenditure. It contains guidance on how to factor climate change mitigation and adaptation planned expenditure into budget proposals and refers to the national climate change strategies.  "]
[3.1,"C","The budget circular contains guidance on how to factor climate change mitigation or adaptation planned expenditure into budget proposals.  "]
[3.1,"D","Performance is less than required for a C score.  "]
[4.0999999999999996,"A","The legislature’s scrutiny of the proposed budget meets five criteria. "]
[4.0999999999999996,"B","The legislature’s scrutiny of the proposed budget meets four criteria. "]
[4.0999999999999996,"C","The legislature’s scrutiny of the proposed budget meets two criteria. "]
[4.0999999999999996,"D","Performance is less than required for a C score.  "]
[4.2,"A","The legislature’s scrutiny of audit and evaluation reports meets five criteria. "]
[4.2,"B","The legislature’s scrutiny of audit and evaluation reports meets four criteria. "]
[4.2,"C","The legislature’s scrutiny of audit and evaluation reports meets two criteria. "]
[4.2,"D","Performance is less than required for a C score.  "]
[5.0999999999999996,"A","The legal or regulatory framework describes the objectives and requirements for investment programs or projects in relation to climate change mitigation and adaptation. Requirements include the mandatory assessment of new significant investment projects with an impact on national mitigation targets and climate vulnerabilities.  There is a high level of compliance of investment project proposals with the climate related objectives and requirements. The scope of climate related objectives and requirements covers central government and public corporations.  "]
[5.0999999999999996,"B","The legal or regulatory framework describes the objectives and requirements for investment programs or projects in relation to climate change mitigation or adaptation. There is a high level of compliance of investment project proposals with the climate related objectives or requirements. The scope of climate related objectives and requirements covers central government. "]
[5.0999999999999996,"C","The legal or regulatory framework describes the objectives and requirements for investment programs or projects in relation to climate change mitigation or adaptation. \r\nThe scope of climate related objectives and requirements covers central government. "]
[5.0999999999999996,"D","Performance is less than required for a C score.  "]
[5.2,"A","Published climate assessment and prioritization criteria are used to select new investment projects. Climate assessment criteria cover the climate impact of the project and its exposure to climate risks, based on adequate hazard and exceedance data (OR based on adequate hazard and available data). "]
[5.2,"B","Climate assessment and prioritization criteria are used to select new investment projects. Climate assessment criteria cover the climate impact of the project or its exposure to climate risks. "]
[5.2,"C","Climate assessment and prioritization criteria are used to select new investment projects. "]
[5.2,"D","Performance is less than required for a C score.  "]
[5.3,"A","National guidelines for projects appraisal require the evaluation of climate change impacts of new investment projects and provide a methodology. They also require adaptation measures in the project design to address climate risks. Climate change impacts are reviewed by an entity other than the sponsoring entity. The appraisal results are published. "]
[5.3,"B","National guidelines for projects appraisal require the evaluation of climate change impacts of new investment projects.  They also require adaptation measures in the project design to address climate risks.  "]
[5.3,"C","Guidelines for projects appraisal recommend the evaluation of climate change impacts of new investment projects and adaptation measures in the project design to address climate risks. "]
[5.3,"D","Performance is less than required for a C score.  "]
[5.4,"A","The government requires extra budgetary units and public corporations in charge of implementing public investment projects to incorporate specific climate objectives, targets and indicators in their performance contracts or statement of corporate intent. All entities report back within six months of the end of the fiscal year. Reporting covers the use of climate related funding they received from the government to implement \r\ninvestment projects and results against objectives, targets and indicators  "]
[5.4,"B","The government requires extra budgetary units and public corporations in charge of implementing public investment projects to incorporate specific climate objectives, targets and indicators in their performance contracts or statement of corporate intent. Most entities report back within six months of the end of the fiscal year. Reporting covers climate related funding they received from the government to implement investment projects and results against these objectives, targets and indicators. "]
[5.4,"C","The government requires extra budgetary units and public corporations in charge of implementing public investment projects to incorporate specific climate objectives, targets and indicators in their performance contracts or statement of corporate intent.  Most entities report back within nine months of the end of the fiscal year. Reporting covers climate related funding they received from the government to implement investment projects and results against these objectives, targets and indicators "]
[5.4,"D","Performance is less than required for a C score.  "]
[6.1,"A","Exposure and sensitivity of public lands, buildings, and infrastructures to climate variability, extreme weather events and transition risks are identified for the relevant assets. Information is included in the register. Contribution to emission and capture of GHG of relevant non-financial assets is identified. Procedures and rules for the disposal, transfer, and use of lands and subsoils provide climate related arrangements and are complied with. "]
[6.1,"B","Exposure and sensitivity of public lands, buildings, and infrastructures to climate variability, extreme weather events and transition risks are identified for the relevant assets. Information is included in the register. Procedures and rules on disposal, transfer, and use of lands and subsoils provide climate related arrangements. "]
[6.1,"C","Exposure and sensitivity of relevant fixed assets to climate variability, extreme weather events and transition risks are identified for the relevant assets. "]
[6.1,"D","Performance is less than required for a C score.  "]
[7.1,"A ","The government publishes a report consolidating climate related fiscal risks. The report includes a quantitative and qualitative assessment of climate related fiscal risks. It considers impacts of such fiscal risks on expenditure and revenue."]
[7.1,"B","The government produces a report consolidating climate related fiscal risks. The report includes a qualitative assessment of climate related fiscal risks. It considers impacts of such fiscal risks on expenditure and revenue. "]
[7.1,"C","The government produces a report consolidating climate related fiscal risks. "]
[7.1,"D","Performance is less than required for a C score.  "]
[7.2,"A ","The purposes for which the government can borrow, as specified in the legal framework, allow to cover climate related liabilities. The legal or regulatory framework specifies arrangements for SNGs and public corporations. It also refers to a methodology to identify projects eligible to climate finance. Mandatory climate related reporting is produced in a timely way."]
[7.2,"B","The purposes for which the government can borrow, as specified in the legal framework, allow to cover climate related liabilities. The legal or regulatory framework specifies arrangements for SNGs and public corporations. Mandatory climate related reporting is produced in a timely way. "]
[7.2,"C","The legal or regulatory framework specifies arrangements for SNGs and public corporations.  Mandatory climate related reporting is produced. "]
[7.2,"D","Performance is less than required for a C score.  "]
[8.1,"A ","The framework establishes clear criteria to determine what products or services count as climate responsive and the scope of procurement operations subject to climate responsive procurement principles. It sets quantitative targets, priorities and timeframes. Quantitative targets have been reached during the last completed fiscal year. There is an operational body, unit or team in charge of the development of the framework, and support to the users."]
[8.1,"B ","The framework establishes clear criteria to determine what products or services count as climate responsive and the scope of procurement operations subject to climate responsive procurement principles. It sets quantitative targets, priorities and timeframes. "]
[8.1,"C ","The framework establishes clear criteria to determine what products or services count as climate responsive and the scope of procurement operations subject to climate responsive procurement principles."]
[8.1,"D ","Performance is less than required for a C score.  "]
[8.1999999999999993,"A","Climate responsive standards are used to help determine tender requirements and specifications, or award criteria. Climate responsive criteria are included in contract performance clauses. Climate responsive procurement examples or templates are included into framework agreements for commonly procured goods. Life-cycle costing is included as a cost element at the award stage of a procurement procedure. There are simplified procedures and templates to expedite procurement for response to climate induced disasters. Circumstances of their activation are clearly defined. "]
[8.1999999999999993,"B","Climate responsive standards are used to help determine tender requirements and specifications, or award criteria. Climate responsive criteria are included in contract performance clauses. Climate responsive procurement examples or templates are included into framework agreements for commonly procured goods. There are simplified procedures and templates to expedite procurement for response to climate induced disasters. Circumstances of their activation are clearly defined. "]
[8.1999999999999993,"C","Climate responsive standards are used to help determine tender requirements and specifications, or award criteria. There are simplified procedures and templates to expedite procurement for response to climate induced disasters. \t "]
[8.1999999999999993,"D","Performance is less than required for a C score.  "]
[8.3000000000000007,"A","There is a high-level of compliance of contract awards and implementation with climate responsive specifications of tenders and contracts. There is an operational system in place for ensuring the compliance of emergency procedures used in case of climate induced disasters. Procurement operations related to climate induced disasters were compliant with emergency procedures. Procurement databases or records capture specific information on climate responsive procurement and include emergency procurement. \r\nThere are no material concerns about their completeness and accuracy.   "]
[8.3000000000000007,"B","Compliance of contract awards and implementation with climate responsive specifications of tenders and contracts is verified. There is an operational system in place for ensuring the compliance of emergency procedures used in case of climate induced disasters. Procurement databases or records capture specific information on climate responsive procurement and include emergency procurement. Their completeness and accuracy are verified. "]
[8.3000000000000007,"C","Compliance of contract awards and implementation with climate responsive specifications of tenders and contracts is verified. There is an operational system in place for ensuring the compliance of emergency procedures used in case of climate induced disasters. Procurement databases or records capture specific information on climate responsive procurement and include emergency procurement. "]
[8.3000000000000007,"D","Performance is less than required for a C score.  "]
[8.4,"A","A report on climate responsive procurement, which includes statistics and refers to the targets and priorities set in the national framework, is published and submitted to the legislature. Benefits and outcomes of climate responsive procurement have been assessed at least once during the last three completed fiscal years. Indicators of performance for public procurement include indicators on climate responsive procurement. A report on emergency procurement operations, which includes an analysis of their implementation, is published. "]
[8.4,"B","A report on climate responsive procurement, which includes statistics and refers to the targets and priorities set in the national framework, is published and submitted to the legislature. A report on emergency procurement operations is published. "]
[8.4,"C","A statistical report on climate responsive procurement is produced. Emergency procurement operations are reported.  "]
[8.4,"D","Performance is less than required for a C score.  "]
[9.1,"A","For climate related taxes, a structured and systematic approach for assessing and prioritizing compliance risk, is used. GHG emitters are registered in a database, which is accurate and comprehensive, and linked to the taxpayer database. A documented compliance improvement plan exists comprising mitigation activities in respect of identified high risks covering climate related taxes. Planned audit and investigations have been completed as intended.  Penalties for non-compliance exist and are effective. "]
[9.1,"B","For climate related taxes, a structured and systematic approach for assessing and prioritizing compliance risk, is used. GHG emitters are registered in a database, which is linked to the taxpayer database. Accuracy and completeness of the emitters’ database are regularly controlled. A documented compliance improvement plan exists comprising mitigation activities in respect of identified high risks covering climate related taxes. \r\nPlanned audit and investigations have been completed as intended. "]
[9.1,"C","For climate related taxes, a partly structured and systematic approach for assessing and prioritizing compliance risk, is used. GHG emitters are registered in a database, which may not be fully and consistently linked with the taxpayer database. Part of the planned audit and investigations have been completed.   "]
[9.1,"D","Performance is less than required for a C score.  "]
[9.1999999999999993,"A","The stock of total climate related tax arrears at the end of the last completed fiscal year is below 10 percent of the total climate related tax arrears collection for the year. "]
[9.1999999999999993,"B","The stock of total climate related tax arrears at the end of the last completed fiscal year is below 20 percent of the total climate related tax arrears collection for the year. "]
[9.1999999999999993,"C","The stock of total climate related tax arrears at the end of the last completed fiscal year is below 40 percent of the total climate related tax arrears collection for the year. "]
[9.1999999999999993,"D","Performance is less than required for a C score.  "]
[10.1,"A ","The legal or regulatory framework provides a system of controls of the climate conditionalities of transactions. Controls are performed at the commitment and payment stage. Evidence shows that the control system is effective, covers all categories of climate related transactions, and that emergency payments are compliant with the procedures. The control system has been audited at least once during the last three completed fiscal years."]
[10.1,"B","The legal and regulatory framework provides a system of controls of the climate conditionalities of transactions. Controls are performed at least at payment stage. Evidence shows that the control system is effective, covers the major categories of climate related transactions, and that emergency payments are compliant with the procedures. The control system has been partially audited at least once during the last three completed fiscal years. "]
[10.1,"C","The legal and regulatory framework provides a system of controls of the climate conditionalities of transactions procedures. Controls are performed at least at payment stage. Evidence shows that the control system is partially effective and provides partial coverage. "]
[10.1,"D","Performance is less than required for a C score.  "]
[10.199999999999999,"A","Audits and fraud investigations are conducted for all categories of climate related transactions to ascertain that public monies have been used for the proper climate objectives. They include the use of climate related monies by receiving entities. There is an effective mechanism for recovering undue transactions. "]
[10.199999999999999,"B","Audits and fraud investigations are conducted for the major categories of climate related transactions to ascertain that public monies have been used for the proper climate objectives. They include the use of climate related monies by receiving entities. There is a mechanism for recovering undue transactions. "]
[10.199999999999999,"C","Audits and fraud investigations are conducted for climate related transactions to ascertain that public monies have been used for the proper climate objectives, but their coverage is partial.  "]
[10.199999999999999,"D","Performance is less than required for a C score.  "]
[11.1,"A","The legal and regulatory framework clearly states the competencies and mandates of SNGs related to climate change mitigation and adaptation. Resources allocated to SNGs allow them to implement their competencies and mandates related to climate change. Evaluation of the implementation of these mandates and competencies has been conducted and published at least once during the last three completed fiscal years.  "]
[11.1,"B","The legal and regulatory framework clearly states the competencies and mandates of SNGs related to climate change mitigation and adaptation. Evaluation of the implementation of these mandates and competencies has been conducted at least once during the last three completed fiscal years. "]
[11.1,"C","The legal and regulatory framework clearly states the competencies and mandates of SNGs related to climate change mitigation and adaptation. "]
[11.1,"D","Performance is less than required for a C score.  "]
[11.2,"A","Climate change related conditional transfers are associated with objectives aligned with the national climate change strategy. SNGs report annually to central government on the use of climate related transfers from CG. The horizontal allocation of unconditional transfers is partly based on climate related criteria and/or in case of performance-based transfers, climate change is considered as part of the performance indicators.  "]
[11.2,"B","Climate change related conditional transfers are associated with objectives aligned with the national climate change strategy. SNGs report annually to central government on the use of climate related transfers from central government.  "]
[11.2,"C","Climate change related conditional transfers are associated with objectives aligned with the national climate change strategy.  "]
[11.2,"D","Performance is less than required for a C score.  "]
[11.3,"A","At least Four of the following elements are fulfilled. "]
[11.3,"B","Three of the following elements are fulfilled. "]
[11.3,"C","Two of the following elements are fulfilled. "]
[11.3,"D","Performance is less than required for a C score.  "]
[11.3,"A","4 criteria met ","3 criteria met ","2 criteria met "]
[11.3,"B","2 criteria met ","2 criteria met ","1 criterion met  "]
[11.3,"C","1 criterion met ","1 criterion met "]
[12.1,"A","Climate related objectives, key performance indicators, outputs AND outcomes are assigned to climate related programs and activities. Indicators are consistent with those established in the national climate change strategy/plan. Performance information is available in the budget or supporting documentation submitted to the legislature and published. "]
[12.1,"B","Climate related objectives, key performance indicators, outputs OR outcomes are assigned to climate related programs and activities.  Performance information is available in the budget or supporting documentation submitted to the legislature and published. "]
[12.1,"C","Performance targets are assigned to climate related programs and activities. Performance information is available in the budget or supporting documentation submitted to the legislature. "]
[12.1,"D","Performance is less than required for a C score.  "]
[12.2,"A","Climate related achieved outcomes AND produced outputs are reported for climate related programs and activities. Performance is reported against indicators that are consistent with those established in the national climate change strategy/plan. Reports are submitted to the legislature and published.  "]
[12.2,"B","Climate related achieved outcomes OR produced outputs are reported for climate related programs and activities. Reports are submitted to the legislature and published. "]
[12.2,"C","Achieved performance is reported for climate related programs and activities. Reports are submitted to the legislature. "]
[12.2,"D","Performance is less than required for a C score.  "]
[13.1,"A","Independent evaluation of climate related programs and activities has been carried out and published at least once in the last three years. Evaluation of programs and activities indirectly contributing to climate change adaptation and mitigation, including programs and activities that undermine climate policy, have included a part devoted to impact on climate. "]
[13.1,"B","Evaluation of climate related programs and activities has been carried out and published at least once in the last three years. "]
[13.1,"C","Evaluation of climate related programs and activities has been carried out at least once in the last three years. "]
[13.1,"D","Performance is less than required for a C score.  "]
[13.2,"A","Independent evaluation of the contribution of the tax policy to climate change has been carried out and published at least once in the last three years. It includes both the climate related taxes and the taxes that are likely to undermine climate policy goals.   "]
[13.2,"B","Evaluation of the contribution of climate related taxes to climate change has been carried out and published at least once in the last three years. "]
[13.2,"C","Evaluation of the contribution of climate related taxes to climate change has been carried out at least once in the last three years. "]
[13.2,"D","Performance is less than required for a C score.  "]
[14.1,"A","Aggregate climate related expenditure outturn was between 95% and 105% of the approved aggregate expenditure for climate actions in at least two of the last three years. "]
[14.1,"B","Aggregate climate related expenditure outturn was between 90% and 110% of the approved aggregate expenditure for climate actions in at least two of the last three years. "]
[14.1,"C","Aggregate climate related expenditure outturn was between 85% and 115% of the approved aggregate expenditure for climate actions in at least two of the last three years. "]
[14.1,"D","Performance is less than required for a C score.  "]
[14.2,"A","Variance in climate related expenditure composition by program, administrative or functional classification was less than 5% in at least two of the last three years.  "]
[14.2,"B","Variance in climate related expenditure composition by program, administrative or functional classification was less than 10% in at least two of the last three years. "]
[14.2,"C","Variance in climate related expenditure composition by program, administrative or functional classification was less than 15% in at least two of the last three years. "]
[14.2,"D","Performance is less than required for a C score. "]

{"sheet":"Methodology","index":13,"n_rows":113,"n_cols":3,"rows_kept":113,"cut":false,"hidden":true,"merged":[]}
["Indicator","Score","Justification"]
["CRPFM—1.1. BUDGET ALIGNMENT WITH CLIMATE CHANGE STRATEGIES  ","A","The system in place fulfills 8 elements, including at least 4 basic elements (1-6). "]
[null,"B","The system in place fulfills 6 elements, including at least 3 basic elements (1-6). "]
[null,"C","The system in place fulfills at least 3 basic elements (1-6). "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—2.1. TRACKING CLIMATE RELATED EXPENDITURE  ","A","The system in place to track climate related expenditure fulfills 7 elements, including Element 1 and at least 3 other basic elements (2-5). "]
[null,"B","The system in place to track climate related expenditure fulfills 5 elements, including Element 1 and at least 3 other basic elements (2-5). "]
[null,"C","The system in place to track climate related expenditure fulfills at least 3 basic elements, including Element 1 (2-5). "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—3.1. BUDGET CIRCULAR","A","The budget circular provides a methodology to track climate change related expenditure, as well as expenditures that are counter to climate policy. It contains guidance on how to factor climate change mitigation and adaptation planned expenditure into budget proposals, and on how to limit expenditures that are counter to climate. It refers to the national climate change strategies.  "]
[null,"B","The budget circular provides a methodology to track climate change related expenditure. It contains guidance on how to factor climate change mitigation and adaptation planned expenditure into budget proposals and refers to the national climate change strategies.  "]
[null,"C","The budget circular contains guidance on how to factor climate change mitigation or adaptation planned expenditure into budget proposals.  "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—4.1. LEGISLATIVE SCRUTINY OF BUDGETS","A ","The legislature’s scrutiny of the proposed budget meets five criteria."]
[null,"B ","The legislature’s scrutiny of the proposed budget meets four criteria."]
[null,"C ","The legislature’s scrutiny of the proposed budget meets two criteria."]
[null,"D ","Performance is less than required for a C score. "]
["CRPFM—4.2. LEGISLATIVE SCRUTINY OF AUDIT AND EVALUATION REPORTS","A ","The legislature’s scrutiny of audit and evaluation reports meets five criteria."]
[null,"B ","The legislature’s scrutiny of audit and evaluation reports meets four criteria."]
[null,"C ","The legislature’s scrutiny of audit and evaluation reports meets two criteria."]
[null,"D ","Performance is less than required for a C score. "]
["CRPFM—5.1. CLIMATE RELATED PROVISIONS IN REGULATORY FRAMEWORK FOR PUBLIC INVESTMENT MANAGEMENT","A","The legal or regulatory framework describes the objectives and requirements for investment programs or projects in relation to climate change mitigation and adaptation. Requirements include the mandatory assessment of new significant investment projects with an impact on national mitigation targets and climate vulnerabilities.  There is a high level of compliance of investment project proposals with the climate related objectives and requirements. The scope of climate related objectives and requirements covers central government and public corporations.  "]
[null,"B","The legal or regulatory framework describes the objectives and requirements for investment programs or projects in relation to climate change mitigation or adaptation. There is a high level of compliance of investment project proposals with the climate related objectives or requirements. The scope of climate related objectives and requirements covers central government. "]
[null,"C","The legal or regulatory framework describes the objectives and requirements for investment programs or projects in relation to climate change mitigation or adaptation. \r\nThe scope of climate related objectives and requirements covers central government. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—5.2. CLIMATE RELATED PROJECT SELECTION","A","Published climate assessment and prioritization criteria are used to select new investment projects. Climate assessment criteria cover the climate impact of the project and its exposure to climate risks, based on adequate hazard and exceedance data (OR based on adequate hazard and available data). "]
[null,"B","Climate assessment and prioritization criteria are used to select new investment projects. Climate assessment criteria cover the climate impact of the project or its exposure to climate risks. "]
[null,"C","Climate assessment and prioritization criteria are used to select new investment projects. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—5.3. CLIMATE RELATED PROVISIONS FOR PROJECT APPRAISAL","A","National guidelines for projects appraisal require the evaluation of climate change impacts of new investment projects and provide a methodology. They also require adaptation measures in the project design to address climate risks. Climate change impacts are reviewed by an entity other than the sponsoring entity. The appraisal results are published. "]
[null,"B","National guidelines for projects appraisal require the evaluation of climate change impacts of new investment projects.  They also require adaptation measures in the project design to address climate risks.  "]
[null,"C","Guidelines for projects appraisal recommend the evaluation of climate change impacts of new investment projects and adaptation measures in the project design to address climate risks. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—5.4. REPORTING FROM ENTITIES IN CHARGE OF IMPLEMENTATION","A","The government requires extra budgetary units and public corporations in charge of implementing public investment projects to incorporate specific climate objectives, targets and indicators in their performance contracts or statement of corporate intent. All entities report back within six months of the end of the fiscal year. Reporting covers the use of climate related funding they received from the government to implement \r\ninvestment projects and results against objectives, targets and indicators  "]
[null,"B","The government requires extra budgetary units and public corporations in charge of implementing public investment projects to incorporate specific climate objectives, targets and indicators in their performance contracts or statement of corporate intent. Most entities report back within six months of the end of the fiscal year. Reporting covers climate related funding they received from the government to implement investment projects and results against these objectives, targets and indicators. "]
[null,"C","The government requires extra budgetary units and public corporations in charge of implementing public investment projects to incorporate specific climate objectives, targets and indicators in their performance contracts or statement of corporate intent.  Most entities report back within nine months of the end of the fiscal year. Reporting covers climate related funding they received from the government to implement investment projects and results against these objectives, targets and indicators "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—6.1. CLIMATE RESPONSIVE NON-FINANCIAL ASSET MANAGEMENT","A","Exposure and sensitivity of public lands, buildings, and infrastructures to climate variability, extreme weather events and transition risks are identified for the relevant assets. Information is included in the register. Contribution to emission and capture of GHG of relevant non-financial assets is identified. Procedures and rules for the disposal, transfer, and use of lands and subsoils provide climate related arrangements and are complied with. "]
[null,"B","Exposure and sensitivity of public lands, buildings, and infrastructures to climate variability, extreme weather events and transition risks are identified for the relevant assets. Information is included in the register. Procedures and rules on disposal, transfer, and use of lands and subsoils provide climate related arrangements. "]
[null,"C","Exposure and sensitivity of relevant fixed assets to climate variability, extreme weather events and transition risks are identified for the relevant assets. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—7.1. CLIMATE RELATED FISCAL RISKS  ","A ","The government publishes a report consolidating climate related fiscal risks. The report includes a quantitative and qualitative assessment of climate related fiscal risks. It considers impacts of such fiscal risks on expenditure and revenue."]
[null,"B ","The government produces a report consolidating climate related fiscal risks. The report includes a qualitative assessment of climate related fiscal risks. It considers impacts of such fiscal risks on expenditure and revenue."]
[null,"C ","The government produces a report consolidating climate related fiscal risks."]
[null,"D ","Performance is less than required for a C score. "]
["CRPFM—7.2. CLIMATE RELATED DEBT AND GUARANTEES  ","A ","The purposes for which the government can borrow, as specified in the legal framework, allow to cover climate related liabilities. The legal or regulatory framework specifies arrangements for SNGs and public corporations. It also refers to a methodology to identify projects eligible to climate finance. Mandatory climate related reporting is produced in a timely way."]
[null,"B ","The purposes for which the government can borrow, as specified in the legal framework, allow to cover climate related liabilities. The legal or regulatory framework specifies arrangements for SNGs and public corporations. Mandatory climate related reporting is produced in a timely way."]
[null,"C ","The legal or regulatory framework specifies arrangements for SNGs and public corporations.  Mandatory climate related reporting is produced."]
[null,"D ","Performance is less than required for a C score. "]
["CRPFM—8.I. CLIMATE RESPONSIVE PUBLIC PROCUREMENT FRAMEWORK","A","The framework establishes clear criteria to determine what products or services count as climate responsive and the scope of procurement operations subject to climate responsive procurement principles. It sets quantitative targets, priorities and timeframes. Quantitative targets have been reached during the last completed fiscal year. There is an operational body, unit or team in charge of the development of the framework, and support to the users. "]
[null,"B","The framework establishes clear criteria to determine what products or services count as climate responsive and the scope of procurement operations subject to climate responsive procurement principles. It sets quantitative targets, priorities and timeframes.  "]
[null,"C","The framework establishes clear criteria to determine what products or services count as climate responsive and the scope of procurement operations subject to climate responsive procurement principles. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—8.2. CLIMATE RESPONSIVE PUBLIC PROCUREMENT OPERATIONS","A","Climate responsive standards are used to help determine tender requirements and specifications, or award criteria. Climate responsive criteria are included in contract performance clauses. Climate responsive procurement examples or templates are included into framework agreements for commonly procured goods. Life-cycle costing is included as a cost element at the award stage of a procurement procedure. There are simplified procedures and templates to expedite procurement for response to climate induced disasters. Circumstances of their activation are clearly defined. "]
[null,"B","Climate responsive standards are used to help determine tender requirements and specifications, or award criteria. Climate responsive criteria are included in contract performance clauses. Climate responsive procurement examples or templates are included into framework agreements for commonly procured goods. There are simplified procedures and templates to expedite procurement for response to climate induced disasters. Circumstances of their activation are clearly defined. "]
[null,"C","Climate responsive standards are used to help determine tender requirements and specifications, or award criteria. There are simplified procedures and templates to expedite procurement for response to climate induced disasters. \t "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—8.3. CLIMATE RESPONSIVE PUBLIC PROCUREMENT MONITORING","A","There is a high-level of compliance of contract awards and implementation with climate responsive specifications of tenders and contracts. There is an operational system in place for ensuring the compliance of emergency procedures used in case of climate induced disasters. Procurement operations related to climate induced disasters were compliant with emergency procedures. Procurement databases or records capture specific information on climate responsive procurement and include emergency procurement. \r\nThere are no material concerns about their completeness and accuracy.   "]
[null,"B","Compliance of contract awards and implementation with climate responsive specifications of tenders and contracts is verified. There is an operational system in place for ensuring the compliance of emergency procedures used in case of climate induced disasters. Procurement databases or records capture specific information on climate responsive procurement and include emergency procurement. Their completeness and accuracy are verified. "]
[null,"C","Compliance of contract awards and implementation with climate responsive specifications of tenders and contracts is verified. There is an operational system in place for ensuring the compliance of emergency procedures used in case of climate induced disasters. Procurement databases or records capture specific information on climate responsive procurement and include emergency procurement. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—8.4. CLIMATE RESPONSIVE PUBLIC PROCUREMENT REPORTING","A","A report on climate responsive procurement, which includes statistics and refers to the targets and priorities set in the national framework, is published and submitted to the legislature. Benefits and outcomes of climate responsive procurement have been assessed at least once during the last three completed fiscal years. Indicators of performance for public procurement include indicators on climate responsive procurement. A report on emergency procurement operations, which includes an analysis of their implementation, is published. "]
[null,"B","A report on climate responsive procurement, which includes statistics and refers to the targets and priorities set in the national framework, is published and submitted to the legislature. A report on emergency procurement operations is published. "]
[null,"C","A statistical report on climate responsive procurement is produced. Emergency procurement operations are reported.  "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—9.1. CLIMATE RELATED TAX MANAGEMENT, AUDIT AND INVESTIGATION","A","For climate related taxes, a structured and systematic approach for assessing and prioritizing compliance risk, is used. GHG emitters are registered in a database, which is accurate and comprehensive, and linked to the taxpayer database. A documented compliance improvement plan exists comprising mitigation activities in respect of identified high risks covering climate related taxes. Planned audit and investigations have been completed as intended.  Penalties for non-compliance exist and are effective. "]
[null,"B","For climate related taxes, a structured and systematic approach for assessing and prioritizing compliance risk, is used. GHG emitters are registered in a database, which is linked to the taxpayer database. Accuracy and completeness of the emitters’ database are regularly controlled. A documented compliance improvement plan exists comprising mitigation activities in respect of identified high risks covering climate related taxes. \r\nPlanned audit and investigations have been completed as intended. "]
[null,"C","For climate related taxes, a partly structured and systematic approach for assessing and prioritizing compliance risk, is used. GHG emitters are registered in a database, which may not be fully and consistently linked with the taxpayer database. Part of the planned audit and investigations have been completed.   "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—9.2. CLIMATE RELATED TAX ARREARS","A","The stock of total climate related tax arrears at the end of the last completed fiscal year is below 10 percent of the total climate related tax arrears collection for the year. "]
[null,"B","The stock of total climate related tax arrears at the end of the last completed fiscal year is below 20 percent of the total climate related tax arrears collection for the year. "]
[null,"C","The stock of total climate related tax arrears at the end of the last completed fiscal year is below 40 percent of the total climate related tax arrears collection for the year. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—10.1. EFFECTIVENESS OF THE SYSTEM OF CONTROLS","A","Audits and fraud investigations are conducted for all categories of climate related transactions to ascertain that public monies have been used for the proper climate objectives. They include the use of climate related monies by receiving entities. There is an effective mechanism for recovering undue transactions. "]
[null,"B","Audits and fraud investigations are conducted for the major categories of climate related transactions to ascertain that public monies have been used for the proper climate objectives. They include the use of climate related monies by receiving entities. There is a mechanism for recovering undue transactions. "]
[null,"C","Audits and fraud investigations are conducted for climate related transactions to ascertain that public monies have been used for the proper climate objectives, but their coverage is partial.  "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—10.2. AUDIT OF THE COMPLIANCE OF TRANSACTIONS","A","The legal and regulatory framework clearly states the competencies and mandates of SNGs related to climate change mitigation and adaptation. Resources allocated to SNGs allow them to implement their competencies and mandates related to climate change. Evaluation of the implementation of these mandates and competencies has been conducted and published at least once during the last three completed fiscal years.  "]
[null,"B","The legal and regulatory framework clearly states the competencies and mandates of SNGs related to climate change mitigation and adaptation. Evaluation of the implementation of these mandates and competencies has been conducted at least once during the last three completed fiscal years. "]
[null,"C","The legal and regulatory framework clearly states the competencies and mandates of SNGs related to climate change mitigation and adaptation. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—11.1. CLIMATE RESPONSIVE FISCAL DECENTRALIZATION ARRANGEMENTS","A","Climate change related conditional transfers are associated with objectives aligned with the national climate change strategy. SNGs report annually to central government on the use of climate related transfers from CG. The horizontal allocation of unconditional transfers is partly based on climate related criteria and/or in case of performance-based transfers, climate change is considered as part of the performance indicators.  "]
[null,"B","Climate change related conditional transfers are associated with objectives aligned with the national climate change strategy. SNGs report annually to central government on the use of climate related transfers from central government.  "]
[null,"C","Climate change related conditional transfers are associated with objectives aligned with the national climate change strategy.  "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—11.2. CLIMATE RESPONSIVE FISCAL TRANSFERS","A","At least Four of the following elements are fulfilled. "]
[null,"B","Three of the following elements are fulfilled. "]
[null,"C","Two of the following elements are fulfilled. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—11.3. CLIMATE RESPONSIVE PFM ARRANGEMENTS APPLIED BY SUBNATIONAL GOVERNMENTS","A","Climate related objectives, key performance indicators, outputs AND outcomes are assigned to climate related programs and activities. Indicators are consistent with those established in the national climate change strategy/plan. Performance information is available in the budget or supporting documentation submitted to the legislature and published. "]
[null,"B","Climate related objectives, key performance indicators, outputs OR outcomes are assigned to climate related programs and activities.  Performance information is available in the budget or supporting documentation submitted to the legislature and published. "]
[null,"C","Performance targets are assigned to climate related programs and activities. Performance information is available in the budget or supporting documentation submitted to the legislature. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—12.1. CLIMATE RELATED INFORMATION IN PERFORMANCE PLANS","A","Climate related achieved outcomes AND produced outputs are reported for climate related programs and activities. Performance is reported against indicators that are consistent with those established in the national climate change strategy/plan. Reports are submitted to the legislature and published.  "]
[null,"B","Climate related achieved outcomes OR produced outputs are reported for climate related programs and activities. Reports are submitted to the legislature and published. "]
[null,"C","Achieved performance is reported for climate related programs and activities. Reports are submitted to the legislature. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—12.2. CLIMATE RELATED INFORMATION IN PERFORMANCE REPORTS  ","A","Independent evaluation of climate related programs and activities has been carried out and published at least once in the last three years. Evaluation of programs and activities indirectly contributing to climate change adaptation and mitigation, including programs and activities that undermine climate policy, have included a part devoted to impact on climate. "]
[null,"B","Evaluation of climate related programs and activities has been carried out and published at least once in the last three years. "]
[null,"C","Evaluation of climate related programs and activities has been carried out at least once in the last three years. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—14.1. AGGREGATE CLIMATE RELATED EXPENDITURE OUTTURN  ","A","Independent evaluation of the contribution of the tax policy to climate change has been carried out and published at least once in the last three years. It includes both the climate related taxes and the taxes that are likely to undermine climate policy goals.   "]
[null,"B","Evaluation of the contribution of climate related taxes to climate change has been carried out and published at least once in the last three years. "]
[null,"C","Evaluation of the contribution of climate related taxes to climate change has been carried out at least once in the last three years. "]
[null,"D","Performance is less than required for a C score.  "]
["CRPFM—14.2. CLIMATE RELATED EXPENDITURE COMPOSITION OUTTURN  ","A","Aggregate climate related expenditure outturn was between 95% and 105% of the approved aggregate expenditure for climate actions in at least two of the last three years. "]
[null,"B","Aggregate climate related expenditure outturn was between 90% and 110% of the approved aggregate expenditure for climate actions in at least two of the last three years. "]
[null,"C","Aggregate climate related expenditure outturn was between 85% and 115% of the approved aggregate expenditure for climate actions in at least two of the last three years. "]
[null,"D","Performance is less than required for a C score.  "]
[null,"A","Variance in climate related expenditure composition by program, administrative or functional classification was less than 5% in at least two of the last three years.  "]
[null,"B","Variance in climate related expenditure composition by program, administrative or functional classification was less than 10% in at least two of the last three years. "]
[null,"C","Variance in climate related expenditure composition by program, administrative or functional classification was less than 15% in at least two of the last three years. "]
[null,"D","Performance is less than required for a C score. "]

{"sheet":"DimOutput","index":14,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Dimension ","ID-Indic","ID-Output","Output"]
[1.1000000000000001,1,"O-1","Aggregate fiscal discipline"]
[5.0999999999999996,5,"O-1","Aggregate fiscal discipline"]
[6.1,6,"O-1","Aggregate fiscal discipline"]
[7.1,7,"O-1","Aggregate fiscal discipline"]
[7.2,7,"O-1","Aggregate fiscal discipline"]
[1.1000000000000001,1,"O-2","Strategic allocation of resources "]
[3.1,3,"O-2","Strategic allocation of resources "]
[4.0999999999999996,4,"O-2","Strategic allocation of resources "]
[2.1,2,"O-2","Strategic allocation of resources "]
[11.1,11,"O-2","Strategic allocation of resources "]
[11.2,11,"O-2","Strategic allocation of resources "]
[11.3,11,"O-2","Strategic allocation of resources "]
[5.2,5,"O-2","Strategic allocation of resources "]
[5.3,5,"O-2","Strategic allocation of resources "]
[14.1,14,"O-2","Strategic allocation of resources "]
[14.2,14,"O-2","Strategic allocation of resources "]
[1.1000000000000001,1,"O-3","Efficient service delivery "]
[11.3,11,"O-3","Efficient service delivery "]
[12.1,12,"O-3","Efficient service delivery "]
[12.2,12,"O-3","Efficient service delivery "]
[13.1,13,"O-3","Efficient service delivery "]
[5.4,5,"O-3","Efficient service delivery "]
[8.1,8,"O-3","Efficient service delivery "]
[8.1999999999999993,8,"O-3","Efficient service delivery "]
[8.3000000000000007,8,"O-3","Efficient service delivery "]
[8.4,8,"O-3","Efficient service delivery "]
[9.1,9,"O-3","Efficient service delivery "]
[9.1999999999999993,9,"O-3","Efficient service delivery "]
[10.1,10,"O-3","Efficient service delivery "]
[10.199999999999999,10,"O-3","Efficient service delivery "]
[4.2,4,"O-3","Efficient service delivery "]
[13.2,13,"O-3","Efficient service delivery "]
[14.1,14,"O-3","Efficient service delivery "]
[14.2,14,"O-3","Efficient service delivery "]

{"sheet":"DimIndic","index":15,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["ID-Indic","Indicator"]
[1,"1 Budget alignment with climate change strategies "]
[2,"2 Tracking climate related expenditure"]
[3,"3 Climate responsive budget circular "]
[4,"4 Legislative scrutiny"]
[5,"5 Climate responsive public investment management"]
[6,"6 Climate responsive asset management"]
[7,"7 Climate related liabilities"]
[8,"8 Climate responsive procurement"]
[9,"9 Climate responsive revenue administration"]
[10,"10 Compliance of climate related expenditure"]
[11,"11 Climate responsive fiscal decentralization framework"]
[12,"12 Climate related performance information"]
[13,"13 Climate related performance evaluation"]
[14,"14 Expenditure outturn for climate activities"]

{"sheet":"DimPillar","index":16,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Dimension ","ID_Pilar","Pilar"]
[1.1000000000000001,"IV"," Policy-based fiscal strategy and budgeting "]
[3.1,"IV"," Policy-based fiscal strategy and budgeting "]
[4.0999999999999996,"IV"," Policy-based fiscal strategy and budgeting "]
[2.1,"II"," Transparency "]
[11.1,"II"," Transparency "]
[11.2,"II"," Transparency "]
[11.3,"II"," Transparency "]
[12.1,"II"," Transparency "]
[12.2,"II"," Transparency "]
[13.1,"II"," Transparency "]
[5.0999999999999996,"III"," Management of assets and liabilities "]
[5.2,"III"," Management of assets and liabilities "]
[5.3,"III"," Management of assets and liabilities "]
[5.4,"III"," Management of assets and liabilities "]
[6.1,"III"," Management of assets and liabilities "]
[7.1,"III"," Management of assets and liabilities "]
[7.2,"III"," Management of assets and liabilities "]
[8.1,"V"," Predictability and control in budget execution "]
[8.1999999999999993,"V"," Predictability and control in budget execution "]
[8.3000000000000007,"V"," Predictability and control in budget execution "]
[8.4,"V"," Predictability and control in budget execution "]
[9.1,"V"," Predictability and control in budget execution "]
[9.1999999999999993,"V"," Predictability and control in budget execution "]
[10.1,"V"," Predictability and control in budget execution "]
[10.199999999999999,"V"," Predictability and control in budget execution "]
[4.2,"VII"," External scrutiny and audit "]
[13.2,"VII"," External scrutiny and audit "]
[14.1,"I"," Budget reliability "]
[14.2,"I"," Budget reliability "]