{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["User's instructions","Input","Data","ES (Synth table)","Report Indic-Comp","ES-Scores","PivotTable","Report Indic (Radar)","Dim_PEFA","Profile","colors"],"not_rendered":{"charts":5,"images":2,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":1},"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":"Input","index":1,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,1,3,2],[2,10,3,10]]}
[]
[null,null,{"$f":"Profile!G3","v":"Team Leader"}]
[null,null,{"$f":"Profile!G4","v":"Country"},"Pefalia",null,null,null,null,"Status",null,{"$f":"Profile!G6","v":"Evaluation PEFA Gender"}]
[null,{"$f":"Profile!G5","v":"Evaluation year"},null,2019,"Evaluation précédente",null,"Evaluation précédente"]
[]
[null,null,null,"Global numerical scoring",{"$f":"AVERAGE(H10,H13,H15,H17,H19,H22,H24,H26,H28)","v":0},{"$f":"AVERAGE(I10,I13,I15,I17,I19,I22,I24,I26,I28)","v":1.5}]
[null,null,null,"Global scoring",{"$f":"IF(E6>3.65,\"A\",\nIF(E6>=3.25,\"B+\",\nIF(E6>2.5,\"B\",\nIF(E6>=2.25,\"C+\",\nIF(E6>1.25,\"C\",\nIF(E6>1.25,\"D+\",\nIF(E6>0,\"D\",\n\"\"\n)))))))","v":""},{"$f":"IF(F6>3.65,\"A\",\nIF(F6>=3.25,\"B+\",\nIF(F6>2.5,\"B\",\nIF(F6>=2.25,\"C+\",\nIF(F6>1.25,\"C\",\nIF(F6>1.25,\"D+\",\nIF(F6>0,\"D\",\n\"\"\n)))))))","v":"C"},null,null,null,{"$f":"IF(H6>=3.25,\"A\",\nIF(H6>=3.25,\"B+\",\nIF(H6>2.5,\"B\",\nIF(H6>=2.25,\"C+\",\nIF(H6>1.25,\"C\",\nIF(H6>1.25,\"D+\",\nIF(AND(H6<=1.25,J6>0),\"D\",\n\"\"\n)))))))","v":""}]
[null,null,null,"Performance",{"$f":"IF(E6>=3.25,\"AVANCE\",\nIF(E6>2.5,\"BON\",\nIF(E6>1.25,\"BASIQUE\",\nIF(E6>=1,\"FAIBLE\",\n\"\"\n))))","v":""},{"$f":"IF(F6>=3.25,Profile!$G$7,\nIF(F6>2.5,Profile!$G$8,\nIF(F6>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"2. BASIC"}]
["Type","Method","ID","Dimension",{"$f":"J4","v":0},{"$f":"\"Score \"&D4","v":"Score 2019"},"Comparable (1/0)","Score num (Prev)","Score num (Curr)","Evolution",{"$f":"\"Justification \"&D4","v":"Justification 2019"},{"$f":"Profile!G2","v":"Justification for the evolution"},{"$f":"\"Performance \"&D4","v":"Performance 2019"},{"$f":"\"Performance \"&E9","v":"Performance 0"},"Desag"]
["Indic","M1","GRPFM-1",{"$f":"VLOOKUP(C10,Dim_PEFA!A:B,2,FALSE)","v":"Gender impact analysis of budget policy proposals"},{"$f":"IF(AND(E11=\"NU\",E12=\"NU\"),\"NU\",\nIF(AND(OR(E11=\"NA\",E11=\"NU\"),OR(E12=\"NA\",E12=\"NU\")),\"NA\",\nIF(H10>=3.25,\"A\",\nIF(H10>=3.25,\"B+\",\nIF(H10>2.5,\"B\",\nIF(H10>=2.25,\"C+\",\nIF(H10>1.25,\"C\",\nIF(H10>1.25,\"D+\",\nIF(AND(H10<=1.25,H10>0),\"D\",\n\"\"\n)))))))))","v":""},{"$f":"IF(AND(F11=\"NU\",F12=\"NU\"),\"NU\",\nIF(AND(OR(F11=\"NA\",F11=\"NU\"),OR(F12=\"NA\",F12=\"NU\")),\"NA\",\nIF(I10>3.65,\"A\",\nIF(I10>=3.25,\"B+\",\nIF(I10>2.65,\"B\",\nIF(I10>=2.25,\"C+\",\nIF(I10>1.75,\"C\",\nIF(I10>1.25,\"D+\",\nIF(AND(I10<=1.25,I10>0),\"D\",\n\"\"\n)))))))))","v":"D+"},{"$f":"AVERAGE(G11:G12)","v":1},{"$f":"IFERROR(IF($B10=\"M1\",IF(ROUND(AVERAGEIF(H11:H12,\">0\"),1)=ROUND(_xlfn.MINIFS(H11:H12,H11:H12,\">0\"),1),ROUND(AVERAGEIF(H11:H12,\">0\"),1),_xlfn.MINIFS(H11:H12,H11:H12,\">0\")+0.5),AVERAGEIF(H11:H12,\">0\")),0)","v":0},{"$f":"IFERROR(IF($B10=\"M1\",IF(ROUND(AVERAGEIF(I11:I12,\">0\"),1)=ROUND(_xlfn.MINIFS(I11:I12,I11:I12,\">0\"),1),ROUND(AVERAGEIF(I11:I12,\">0\"),1),_xlfn.MINIFS(I11:I12,I11:I12,\">0\")+0.5),AVERAGEIF(I11:I12,\">0\")),0)","v":1.5},{"$f":"IFERROR(IF(G10=1,IF(I10-H10<0,\"-\",IF(I10-H10>0,\"+\",\"=\")),\"N.C\"),\"N.C.\")","v":"+"},null,null,{"$f":"IF(I10>=3.25,Profile!$G$7,\nIF(I10>2.5,Profile!$G$8,\nIF(I10>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"2. BASIC"},{"$f":"IF(H10>=3.25,\"4. AVANCE\",\nIF(H10>2.5,\"3. BON\",\nIF(H10>1.25,\"2. BASIQUE\",\n\"1. FAIBLE\"\n)))","v":"1. FAIBLE"},2]
["Comp",null,"GRPFM-1.1",{"$f":"VLOOKUP(C11,Dim_PEFA!C:D,2,FALSE)","v":"Gender impact analysis of expenditure policy proposals"},null,"D",1,{"$f":"IF(TRIM(CLEAN(E11))=\"A\",4)+IF(TRIM(CLEAN(E11))=\"B+\",3.5)+IF(TRIM(CLEAN(E11))=\"B\",3)+IF(TRIM(CLEAN(E11))=\"C+\",2.5)+IF(TRIM(CLEAN(E11))=\"C\",2)+IF(TRIM(CLEAN(E11))=\"D+\",1.5)+IF(TRIM(CLEAN(E11))=\"D\",1)+IF(TRIM(CLEAN(E11))=\"D*\",1)+IF(TRIM(CLEAN(E11))=\"NU\",0)+IF(TRIM(CLEAN(E11))=\"NA\",0)+IF(TRIM(CLEAN(E11))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F11))=\"A\",4)+IF(TRIM(CLEAN(F11))=\"B+\",3.5)+IF(TRIM(CLEAN(F11))=\"B\",3)+IF(TRIM(CLEAN(F11))=\"C+\",2.5)+IF(TRIM(CLEAN(F11))=\"C\",2)+IF(TRIM(CLEAN(F11))=\"D+\",1.5)+IF(TRIM(CLEAN(F11))=\"D\",1)+IF(TRIM(CLEAN(F11))=\"D*\",1)+IF(TRIM(CLEAN(F11))=\"NU\",0)+IF(TRIM(CLEAN(F11))=\"NA\",0)+IF(TRIM(CLEAN(F11))=\"\",)","v":1},{"$f":"IF(G11=1,IF(I11-H11<0,\"-\",IF(I11-H11>0,\"+\",\"=\")),\"N.C\")","v":"+"},"New spending proposals, as well as proposed measures to improve public expenditure management, are not followed by a gender impact analysis.",null,{"$f":"IF(I11>=3.25,Profile!$G$7,\nIF(I11>2.5,Profile!$G$8,\nIF(I11>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",2]
["Comp",null,"GRPFM-1.2",{"$f":"VLOOKUP(C12,Dim_PEFA!C:D,2,FALSE)","v":"Gender impact analysis of revenue policy proposals"},null,"A",1,{"$f":"IF(TRIM(CLEAN(E12))=\"A\",4)+IF(TRIM(CLEAN(E12))=\"B+\",3.5)+IF(TRIM(CLEAN(E12))=\"B\",3)+IF(TRIM(CLEAN(E12))=\"C+\",2.5)+IF(TRIM(CLEAN(E12))=\"C\",2)+IF(TRIM(CLEAN(E12))=\"D+\",1.5)+IF(TRIM(CLEAN(E12))=\"D\",1)+IF(TRIM(CLEAN(E12))=\"D*\",1)+IF(TRIM(CLEAN(E12))=\"NU\",0)+IF(TRIM(CLEAN(E12))=\"NA\",0)+IF(TRIM(CLEAN(E12))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F12))=\"A\",4)+IF(TRIM(CLEAN(F12))=\"B+\",3.5)+IF(TRIM(CLEAN(F12))=\"B\",3)+IF(TRIM(CLEAN(F12))=\"C+\",2.5)+IF(TRIM(CLEAN(F12))=\"C\",2)+IF(TRIM(CLEAN(F12))=\"D+\",1.5)+IF(TRIM(CLEAN(F12))=\"D\",1)+IF(TRIM(CLEAN(F12))=\"D*\",1)+IF(TRIM(CLEAN(F12))=\"NU\",0)+IF(TRIM(CLEAN(F12))=\"NA\",0)+IF(TRIM(CLEAN(F12))=\"\",)","v":4},{"$f":"IF(G12=1,IF(I12-H12<0,\"-\",IF(I12-H12>0,\"+\",\"=\")),\"N.C\")","v":"+"},"The 2020 budget preparation documents do not include an ex-ante gender impact analysis of new revenue proposals.",null,{"$f":"IF(I12>=3.25,Profile!$G$7,\nIF(I12>2.5,Profile!$G$8,\nIF(I12>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"4. ADVANCED"},"1. FAIBLE",2]
["Indic","M1","GRPFM-2",{"$f":"VLOOKUP(C13,Dim_PEFA!A:B,2,FALSE)","v":"Gender responsive public investment management"},{"$f":"IF(E14=\"\",\"\",E14)","v":""},{"$f":"IF(F14=\"\",\"\",\nIF(F14=\"D*\",\"D\",F14))","v":"A"},{"$f":"G14","v":0},{"$f":"IF($B13=\"M1\",IF(AVERAGE(H14)=MIN(H14),H14,MIN(H14)+0.5),AVERAGE(H14))","v":0},{"$f":"IF($B13=\"M1\",IF(AVERAGE(I14)=MIN(I14),I14,MIN(I14)+0.5),AVERAGE(I14))","v":4},{"$f":"IFERROR(IF(G13=1,IF(I13-H13<0,\"-\",IF(I13-H13>0,\"+\",\"=\")),\"N.C\"),\"N.C.\")","v":"N.C"},null,null,{"$f":"IF(I13>=3.25,Profile!$G$7,\nIF(I13>2.5,Profile!$G$8,\nIF(I13>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"4. ADVANCED"},"1. FAIBLE",1]
["Comp",null,"GRPFM-2.1",{"$f":"VLOOKUP(C14,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive public investment management"},null,"A",0,{"$f":"IF(TRIM(CLEAN(E14))=\"A\",4)+IF(TRIM(CLEAN(E14))=\"B+\",3.5)+IF(TRIM(CLEAN(E14))=\"B\",3)+IF(TRIM(CLEAN(E14))=\"C+\",2.5)+IF(TRIM(CLEAN(E14))=\"C\",2)+IF(TRIM(CLEAN(E14))=\"D+\",1.5)+IF(TRIM(CLEAN(E14))=\"D\",1)+IF(TRIM(CLEAN(E14))=\"D*\",1)+IF(TRIM(CLEAN(E14))=\"NU\",0)+IF(TRIM(CLEAN(E14))=\"NA\",0)+IF(TRIM(CLEAN(E14))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F14))=\"A\",4)+IF(TRIM(CLEAN(F14))=\"B+\",3.5)+IF(TRIM(CLEAN(F14))=\"B\",3)+IF(TRIM(CLEAN(F14))=\"C+\",2.5)+IF(TRIM(CLEAN(F14))=\"C\",2)+IF(TRIM(CLEAN(F14))=\"D+\",1.5)+IF(TRIM(CLEAN(F14))=\"D\",1)+IF(TRIM(CLEAN(F14))=\"D*\",1)+IF(TRIM(CLEAN(F14))=\"NU\",0)+IF(TRIM(CLEAN(F14))=\"NA\",0)+IF(TRIM(CLEAN(F14))=\"\",)","v":4},{"$f":"IF(G14=1,IF(I14-H14<0,\"-\",IF(I14-H14>0,\"+\",\"=\")),\"N.C\")","v":"N.C"},"The procedure manual for programming and monitoring-evaluation of public investments does not include a requirement for gender analysis.  In 2020, of the 33 investment projects received, only those financed by technical and financial partners (TFPs) were subject to economic analyses with gender impacts. Of the 10 largest projects, only 3 projects (financed by TFPs) were subject to economic analyses with gender impacts.",null,{"$f":"IF(I14>=3.25,Profile!$G$7,\nIF(I14>2.5,Profile!$G$8,\nIF(I14>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"4. ADVANCED"},"1. FAIBLE",1]
["Indic","M1","GRPFM-3",{"$f":"VLOOKUP(C15,Dim_PEFA!A:B,2,FALSE)","v":"Gender responsive budget circular"},{"$f":"IF(E16=\"\",\"\",E16)","v":""},{"$f":"IF(F16=\"\",\"\",\nIF(F16=\"D*\",\"D\",F16))","v":"C"},{"$f":"G16","v":1},{"$f":"IF($B15=\"M1\",IF(AVERAGE(H16)=MIN(H16),H16,MIN(H16)+0.5),AVERAGE(H16))","v":0},{"$f":"IF($B15=\"M1\",IF(AVERAGE(I16)=MIN(I16),I16,MIN(I16)+0.5),AVERAGE(I16))","v":2},{"$f":"IFERROR(IF(G15=1,IF(I15-H15<0,\"-\",IF(I15-H15>0,\"+\",\"=\")),\"N.C\"),\"N.C.\")","v":"+"},null,null,{"$f":"IF(I15>=3.25,Profile!$G$7,\nIF(I15>2.5,Profile!$G$8,\nIF(I15>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"2. BASIC"},"1. FAIBLE",1]
["Comp",null,"GRPFM-3.1",{"$f":"VLOOKUP(C16,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive budget circular"},null,"C",1,{"$f":"IF(TRIM(CLEAN(E16))=\"A\",4)+IF(TRIM(CLEAN(E16))=\"B+\",3.5)+IF(TRIM(CLEAN(E16))=\"B\",3)+IF(TRIM(CLEAN(E16))=\"C+\",2.5)+IF(TRIM(CLEAN(E16))=\"C\",2)+IF(TRIM(CLEAN(E16))=\"D+\",1.5)+IF(TRIM(CLEAN(E16))=\"D\",1)+IF(TRIM(CLEAN(E16))=\"D*\",1)+IF(TRIM(CLEAN(E16))=\"NU\",0)+IF(TRIM(CLEAN(E16))=\"NA\",0)+IF(TRIM(CLEAN(E16))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F16))=\"A\",4)+IF(TRIM(CLEAN(F16))=\"B+\",3.5)+IF(TRIM(CLEAN(F16))=\"B\",3)+IF(TRIM(CLEAN(F16))=\"C+\",2.5)+IF(TRIM(CLEAN(F16))=\"C\",2)+IF(TRIM(CLEAN(F16))=\"D+\",1.5)+IF(TRIM(CLEAN(F16))=\"D\",1)+IF(TRIM(CLEAN(F16))=\"D*\",1)+IF(TRIM(CLEAN(F16))=\"NU\",0)+IF(TRIM(CLEAN(F16))=\"NA\",0)+IF(TRIM(CLEAN(F16))=\"\",)","v":2},{"$f":"IF(G16=1,IF(I16-H16<0,\"-\",IF(I16-H16>0,\"+\",\"=\")),\"N.C\")","v":"+"},"The budget circular published on 19 March 2019 by the Ministry of Finance for the preparation of the 2020 budget, reaffirms the government's desire to continue and consolidate the gender budgeting process.  However, it does not ask ministries to provide information on the gender impacts of the spending they plan to propose. Nor does the budget circular require ministries to present sex-disaggregated data for the expected outcomes of budget policies.",null,{"$f":"IF(I16>=3.25,Profile!$G$7,\nIF(I16>2.5,Profile!$G$8,\nIF(I16>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"2. BASIC"},"1. FAIBLE",1]
["Indic","M1","GRPFM-4",{"$f":"VLOOKUP(C17,Dim_PEFA!A:B,2,FALSE)","v":"Gender responsive budget proposal documentation"},{"$f":"IF(E18=\"\",\"\",E18)","v":""},{"$f":"IF(F18=\"\",\"\",\nIF(F18=\"D*\",\"D\",F18))","v":"NA"},{"$f":"G18","v":1},{"$f":"IF($B17=\"M1\",IF(AVERAGE(H18)=MIN(H18),H18,MIN(H18)+0.5),AVERAGE(H18))","v":0},{"$f":"IF($B17=\"M1\",IF(AVERAGE(I18)=MIN(I18),I18,MIN(I18)+0.5),AVERAGE(I18))","v":0},{"$f":"IFERROR(IF(G17=1,IF(I17-H17<0,\"-\",IF(I17-H17>0,\"+\",\"=\")),\"N.C\"),\"N.C.\")","v":"="},null,null,{"$f":"IF(I17>=3.25,Profile!$G$7,\nIF(I17>2.5,Profile!$G$8,\nIF(I17>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",1]
["Comp",null,"GRPFM-4.1",{"$f":"VLOOKUP(C18,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive budget proposal documentation"},null,"NA",1,{"$f":"IF(TRIM(CLEAN(E18))=\"A\",4)+IF(TRIM(CLEAN(E18))=\"B+\",3.5)+IF(TRIM(CLEAN(E18))=\"B\",3)+IF(TRIM(CLEAN(E18))=\"C+\",2.5)+IF(TRIM(CLEAN(E18))=\"C\",2)+IF(TRIM(CLEAN(E18))=\"D+\",1.5)+IF(TRIM(CLEAN(E18))=\"D\",1)+IF(TRIM(CLEAN(E18))=\"D*\",1)+IF(TRIM(CLEAN(E18))=\"NU\",0)+IF(TRIM(CLEAN(E18))=\"NA\",0)+IF(TRIM(CLEAN(E18))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F18))=\"A\",4)+IF(TRIM(CLEAN(F18))=\"B+\",3.5)+IF(TRIM(CLEAN(F18))=\"B\",3)+IF(TRIM(CLEAN(F18))=\"C+\",2.5)+IF(TRIM(CLEAN(F18))=\"C\",2)+IF(TRIM(CLEAN(F18))=\"D+\",1.5)+IF(TRIM(CLEAN(F18))=\"D\",1)+IF(TRIM(CLEAN(F18))=\"D*\",1)+IF(TRIM(CLEAN(F18))=\"NU\",0)+IF(TRIM(CLEAN(F18))=\"NA\",0)+IF(TRIM(CLEAN(F18))=\"\",)","v":0},{"$f":"IF(G18=1,IF(I18-H18<0,\"-\",IF(I18-H18>0,\"+\",\"=\")),\"N.C\")","v":"="},"The budget documents submitted to the National Assembly for approval (including the gender equality report) with the draft 2020 budget do not contain a general presentation of public priorities for improving gender equality, nor detailed information on budgetary measures to strengthen gender equality, nor an assessment of the effects of budgetary policies.",null,{"$f":"IF(I18>=3.25,Profile!$G$7,\nIF(I18>2.5,Profile!$G$8,\nIF(I18>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",1]
["Indic","M2","GRPFM-5",{"$f":"VLOOKUP(C19,Dim_PEFA!A:B,2,FALSE)","v":"Sex-disaggregated performance information "},{"$f":"IF(AND(E20=\"NU\",E21=\"NU\"),\"NU\",\nIF(AND(OR(E20=\"NA\",E20=\"NU\"),OR(E21=\"NA\",E21=\"NU\")),\"NA\",\nIF(H19>=3.25,\"A\",\nIF(H19>=3.25,\"B+\",\nIF(H19>2.5,\"B\",\nIF(H19>=2.25,\"C+\",\nIF(H19>1.25,\"C\",\nIF(H19>1.25,\"D+\",\nIF(AND(H19<=1.25,H19>0),\"D\",\n\"\"\n)))))))))","v":""},{"$f":"IF(AND(F20=\"NU\",F21=\"NU\"),\"NU\",\nIF(AND(OR(F20=\"NA\",F20=\"NU\"),OR(F21=\"NA\",F21=\"NU\")),\"NA\",\nIF(I19>3.65,\"A\",\nIF(I19>=3.25,\"B+\",\nIF(I19>2.65,\"B\",\nIF(I19>=2.25,\"C+\",\nIF(I19>1.75,\"C\",\nIF(I19>1.25,\"D+\",\nIF(AND(I19<=1.25,I19>0),\"D\",\n\"\"\n)))))))))","v":"D"},{"$f":"AVERAGE(G20:G21)","v":1},{"$f":"IFERROR(IF($B19=\"M1\",IF(ROUND(AVERAGEIF(H20:H21,\">0\"),1)=ROUND(_xlfn.MINIFS(H20:H21,H20:H21,\">0\"),1),ROUND(AVERAGEIF(H20:H21,\">0\"),1),_xlfn.MINIFS(H20:H21,H20:H21,\">0\")+0.5),AVERAGEIF(H20:H21,\">0\")),0)","v":0},{"$f":"IFERROR(IF($B19=\"M1\",IF(ROUND(AVERAGEIF(I20:I21,\">0\"),1)=ROUND(_xlfn.MINIFS(I20:I21,I20:I21,\">0\"),1),I20,_xlfn.MINIFS(I20:I21,I20:I21,\">0\")+0.5),AVERAGEIF(I20:I21,\">0\")),0)","v":1},{"$f":"IFERROR(IF(G19=1,IF(I19-H19<0,\"-\",IF(I19-H19>0,\"+\",\"=\")),\"N.C\"),\"N.C.\")","v":"+"},null,null,{"$f":"IF(I19>=3.25,Profile!$G$7,\nIF(I19>2.5,Profile!$G$8,\nIF(I19>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",2]
["Comp",null,"GRPFM-5.1",{"$f":"VLOOKUP(C20,Dim_PEFA!C:D,2,FALSE)","v":"Sex-disaggregated performance plans for service delivery"},null,"D",1,{"$f":"IF(TRIM(CLEAN(E20))=\"A\",4)+IF(TRIM(CLEAN(E20))=\"B+\",3.5)+IF(TRIM(CLEAN(E20))=\"B\",3)+IF(TRIM(CLEAN(E20))=\"C+\",2.5)+IF(TRIM(CLEAN(E20))=\"C\",2)+IF(TRIM(CLEAN(E20))=\"D+\",1.5)+IF(TRIM(CLEAN(E20))=\"D\",1)+IF(TRIM(CLEAN(E20))=\"D*\",1)+IF(TRIM(CLEAN(E20))=\"NU\",0)+IF(TRIM(CLEAN(E20))=\"NA\",0)+IF(TRIM(CLEAN(E20))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F20))=\"A\",4)+IF(TRIM(CLEAN(F20))=\"B+\",3.5)+IF(TRIM(CLEAN(F20))=\"B\",3)+IF(TRIM(CLEAN(F20))=\"C+\",2.5)+IF(TRIM(CLEAN(F20))=\"C\",2)+IF(TRIM(CLEAN(F20))=\"D+\",1.5)+IF(TRIM(CLEAN(F20))=\"D\",1)+IF(TRIM(CLEAN(F20))=\"D*\",1)+IF(TRIM(CLEAN(F20))=\"NU\",0)+IF(TRIM(CLEAN(F20))=\"NA\",0)+IF(TRIM(CLEAN(F20))=\"\",)","v":1},{"$f":"IF(G20=1,IF(I20-H20<0,\"-\",IF(I20-H20>0,\"+\",\"=\")),\"N.C\")","v":"+"},"The multi-annual expenditure programming documents and the annual performance project (2021-2023) of the ministries providing services such as health, education, agriculture, water and sanitation are made public and available on the Ministry of Finance website, but the information is not disaggregated by gender.   ",null,{"$f":"IF(I20>=3.25,Profile!$G$7,\nIF(I20>2.5,Profile!$G$8,\nIF(I20>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",2]
["Comp",null,"GRPFM-5.2",{"$f":"VLOOKUP(C21,Dim_PEFA!C:D,2,FALSE)","v":"Sex-disaggregated performance achieved for service delivery"},null,"D",1,{"$f":"IF(TRIM(CLEAN(E21))=\"A\",4)+IF(TRIM(CLEAN(E21))=\"B+\",3.5)+IF(TRIM(CLEAN(E21))=\"B\",3)+IF(TRIM(CLEAN(E21))=\"C+\",2.5)+IF(TRIM(CLEAN(E21))=\"C\",2)+IF(TRIM(CLEAN(E21))=\"D+\",1.5)+IF(TRIM(CLEAN(E21))=\"D\",1)+IF(TRIM(CLEAN(E21))=\"D*\",1)+IF(TRIM(CLEAN(E21))=\"NU\",0)+IF(TRIM(CLEAN(E21))=\"NA\",0)+IF(TRIM(CLEAN(E21))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F21))=\"A\",4)+IF(TRIM(CLEAN(F21))=\"B+\",3.5)+IF(TRIM(CLEAN(F21))=\"B\",3)+IF(TRIM(CLEAN(F21))=\"C+\",2.5)+IF(TRIM(CLEAN(F21))=\"C\",2)+IF(TRIM(CLEAN(F21))=\"D+\",1.5)+IF(TRIM(CLEAN(F21))=\"D\",1)+IF(TRIM(CLEAN(F21))=\"D*\",1)+IF(TRIM(CLEAN(F21))=\"NU\",0)+IF(TRIM(CLEAN(F21))=\"NA\",0)+IF(TRIM(CLEAN(F21))=\"\",)","v":1},{"$f":"IF(G21=1,IF(I21-H21<0,\"-\",IF(I21-H21>0,\"+\",\"=\")),\"N.C\")","v":"+"},"The annual performance reports of the ministries providing services are not available. ",null,{"$f":"IF(I21>=3.25,Profile!$G$7,\nIF(I21>2.5,Profile!$G$8,\nIF(I21>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",2]
["Indic","M1","GRPFM-6",{"$f":"VLOOKUP(C22,Dim_PEFA!A:B,2,FALSE)","v":"Tracking budget expenditure for gender equality"},{"$f":"IF(E23=\"\",\"\",E23)","v":""},{"$f":"IF(F23=\"\",\"\",\nIF(F23=\"D*\",\"D\",F23))","v":"C"},{"$f":"G23","v":1},{"$f":"IF($B22=\"M1\",IF(AVERAGE(H23)=MIN(H23),H23,MIN(H23)+0.5),AVERAGE(H23))","v":0},{"$f":"IF($B22=\"M1\",IF(AVERAGE(I23)=MIN(I23),I23,MIN(I23)+0.5),AVERAGE(I23))","v":2},{"$f":"IFERROR(IF(G22=1,IF(I22-H22<0,\"-\",IF(I22-H22>0,\"+\",\"=\")),\"N.C\"),\"N.C.\")","v":"+"},null,null,{"$f":"IF(I22>=3.25,Profile!$G$7,\nIF(I22>2.5,Profile!$G$8,\nIF(I22>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"2. BASIC"},"1. FAIBLE",1]
["Comp",null,"GRPFM-6.1",{"$f":"VLOOKUP(C23,Dim_PEFA!C:D,2,FALSE)","v":"Tracking budget expenditure for gender equality"},null,"C",1,{"$f":"IF(TRIM(CLEAN(E23))=\"A\",4)+IF(TRIM(CLEAN(E23))=\"B+\",3.5)+IF(TRIM(CLEAN(E23))=\"B\",3)+IF(TRIM(CLEAN(E23))=\"C+\",2.5)+IF(TRIM(CLEAN(E23))=\"C\",2)+IF(TRIM(CLEAN(E23))=\"D+\",1.5)+IF(TRIM(CLEAN(E23))=\"D\",1)+IF(TRIM(CLEAN(E23))=\"D*\",1)+IF(TRIM(CLEAN(E23))=\"NU\",0)+IF(TRIM(CLEAN(E23))=\"NA\",0)+IF(TRIM(CLEAN(E23))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F23))=\"A\",4)+IF(TRIM(CLEAN(F23))=\"B+\",3.5)+IF(TRIM(CLEAN(F23))=\"B\",3)+IF(TRIM(CLEAN(F23))=\"C+\",2.5)+IF(TRIM(CLEAN(F23))=\"C\",2)+IF(TRIM(CLEAN(F23))=\"D+\",1.5)+IF(TRIM(CLEAN(F23))=\"D\",1)+IF(TRIM(CLEAN(F23))=\"D*\",1)+IF(TRIM(CLEAN(F23))=\"NU\",0)+IF(TRIM(CLEAN(F23))=\"NA\",0)+IF(TRIM(CLEAN(F23))=\"\",)","v":2},{"$f":"IF(G23=1,IF(I23-H23<0,\"-\",IF(I23-H23>0,\"+\",\"=\")),\"N.C\")","v":"+"},"For the last financial year, the used a nomenclature in line with international best practice. Although this nomenclature complies with EU requirements, it does not include gender-specific classification elements. ",null,{"$f":"IF(I23>=3.25,Profile!$G$7,\nIF(I23>2.5,Profile!$G$8,\nIF(I23>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"2. BASIC"},"1. FAIBLE",1]
["Indic","M1","GRPFM-7",{"$f":"VLOOKUP(C24,Dim_PEFA!A:B,2,FALSE)","v":"Gender responsive reporting"},{"$f":"IF(E25=\"\",\"\",E25)","v":""},{"$f":"IF(F25=\"\",\"\",\nIF(F25=\"D*\",\"D\",F25))","v":"D"},{"$f":"G25","v":1},{"$f":"IF($B24=\"M1\",IF(AVERAGE(H25)=MIN(H25),H25,MIN(H25)+0.5),AVERAGE(H25))","v":0},{"$f":"IF($B24=\"M1\",IF(AVERAGE(I25)=MIN(I25),I25,MIN(I25)+0.5),AVERAGE(I25))","v":1},{"$f":"IFERROR(IF(G24=1,IF(I24-H24<0,\"-\",IF(I24-H24>0,\"+\",\"=\")),\"N.C\"),\"N.C.\")","v":"+"},null,null,{"$f":"IF(I24>=3.25,Profile!$G$7,\nIF(I24>2.5,Profile!$G$8,\nIF(I24>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",1]
["Comp",null,"GRPFM-7.1",{"$f":"VLOOKUP(C25,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive reporting"},null,"D",1,{"$f":"IF(TRIM(CLEAN(E25))=\"A\",4)+IF(TRIM(CLEAN(E25))=\"B+\",3.5)+IF(TRIM(CLEAN(E25))=\"B\",3)+IF(TRIM(CLEAN(E25))=\"C+\",2.5)+IF(TRIM(CLEAN(E25))=\"C\",2)+IF(TRIM(CLEAN(E25))=\"D+\",1.5)+IF(TRIM(CLEAN(E25))=\"D\",1)+IF(TRIM(CLEAN(E25))=\"D*\",1)+IF(TRIM(CLEAN(E25))=\"NU\",0)+IF(TRIM(CLEAN(E25))=\"NA\",0)+IF(TRIM(CLEAN(E25))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F25))=\"A\",4)+IF(TRIM(CLEAN(F25))=\"B+\",3.5)+IF(TRIM(CLEAN(F25))=\"B\",3)+IF(TRIM(CLEAN(F25))=\"C+\",2.5)+IF(TRIM(CLEAN(F25))=\"C\",2)+IF(TRIM(CLEAN(F25))=\"D+\",1.5)+IF(TRIM(CLEAN(F25))=\"D\",1)+IF(TRIM(CLEAN(F25))=\"D*\",1)+IF(TRIM(CLEAN(F25))=\"NU\",0)+IF(TRIM(CLEAN(F25))=\"NA\",0)+IF(TRIM(CLEAN(F25))=\"\",)","v":1},{"$f":"IF(G25=1,IF(I25-H25<0,\"-\",IF(I25-H25>0,\"+\",\"=\")),\"N.C\")","v":"+"},"No 2020 report on gender equality results is available. Similarly, no data on gender-related expenditure and no data on budget employment in the administration broken down by gender are available. Finally, no evaluation of the implementation of budgetary policies and their effects on gender equality is available.",null,{"$f":"IF(I25>=3.25,Profile!$G$7,\nIF(I25>2.5,Profile!$G$8,\nIF(I25>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",1]
["Indic","M1","GRPFM-8",{"$f":"VLOOKUP(C26,Dim_PEFA!A:B,2,FALSE)","v":"Evaluation of gender impacts of service delivery"},{"$f":"IF(E27=\"\",\"\",E27)","v":""},{"$f":"IF(F27=\"\",\"\",\nIF(F27=\"D*\",\"D\",F27))","v":"D"},{"$f":"G27","v":1},{"$f":"IF($B26=\"M1\",IF(AVERAGE(H27)=MIN(H27),H27,MIN(H27)+0.5),AVERAGE(H27))","v":0},{"$f":"IF($B26=\"M1\",IF(AVERAGE(I27)=MIN(I27),I27,MIN(I27)+0.5),AVERAGE(I27))","v":1},{"$f":"IFERROR(IF(G26=1,IF(I26-H26<0,\"-\",IF(I26-H26>0,\"+\",\"=\")),\"N.C\"),\"N.C.\")","v":"+"},null,null,{"$f":"IF(I26>=3.25,Profile!$G$7,\nIF(I26>2.5,Profile!$G$8,\nIF(I26>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",1]
["Comp",null,"GRPFM-8.1",{"$f":"VLOOKUP(C27,Dim_PEFA!C:D,2,FALSE)","v":"Evaluation of gender impacts of service delivery"},null,"D",1,{"$f":"IF(TRIM(CLEAN(E27))=\"A\",4)+IF(TRIM(CLEAN(E27))=\"B+\",3.5)+IF(TRIM(CLEAN(E27))=\"B\",3)+IF(TRIM(CLEAN(E27))=\"C+\",2.5)+IF(TRIM(CLEAN(E27))=\"C\",2)+IF(TRIM(CLEAN(E27))=\"D+\",1.5)+IF(TRIM(CLEAN(E27))=\"D\",1)+IF(TRIM(CLEAN(E27))=\"D*\",1)+IF(TRIM(CLEAN(E27))=\"NU\",0)+IF(TRIM(CLEAN(E27))=\"NA\",0)+IF(TRIM(CLEAN(E27))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F27))=\"A\",4)+IF(TRIM(CLEAN(F27))=\"B+\",3.5)+IF(TRIM(CLEAN(F27))=\"B\",3)+IF(TRIM(CLEAN(F27))=\"C+\",2.5)+IF(TRIM(CLEAN(F27))=\"C\",2)+IF(TRIM(CLEAN(F27))=\"D+\",1.5)+IF(TRIM(CLEAN(F27))=\"D\",1)+IF(TRIM(CLEAN(F27))=\"D*\",1)+IF(TRIM(CLEAN(F27))=\"NU\",0)+IF(TRIM(CLEAN(F27))=\"NA\",0)+IF(TRIM(CLEAN(F27))=\"\",)","v":1},{"$f":"IF(G27=1,IF(I27-H27<0,\"-\",IF(I27-H27>0,\"+\",\"=\")),\"N.C\")","v":"+"},"The government does not produce any specific report assessing the effectiveness and efficiency of public services and including a gender impact analysis. ",null,{"$f":"IF(I27>=3.25,Profile!$G$7,\nIF(I27>2.5,Profile!$G$8,\nIF(I27>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",1]
["Indic","M2","GRPFM-9",{"$f":"VLOOKUP(C28,Dim_PEFA!A:B,2,FALSE)","v":"Legislative scrutiny of gender impacts of the budget"},{"$f":"IF(AND(E29=\"NU\",E30=\"NU\"),\"NU\",\nIF(AND(OR(E29=\"NA\",E29=\"NU\"),OR(E30=\"NA\",E30=\"NU\")),\"NA\",\nIF(H28>=3.25,\"A\",\nIF(H28>=3.25,\"B+\",\nIF(H28>2.5,\"B\",\nIF(H28>=2.25,\"C+\",\nIF(H28>1.25,\"C\",\nIF(H28>1.25,\"D+\",\nIF(AND(H28<=1.25,H28>0),\"D\",\n\"\"\n)))))))))","v":""},{"$f":"IF(AND(F29=\"NU\",F30=\"NU\"),\"NU\",\nIF(AND(OR(F29=\"NA\",F29=\"NU\"),OR(F30=\"NA\",F30=\"NU\")),\"NA\",\nIF(I28>3.65,\"A\",\nIF(I28>=3.25,\"B+\",\nIF(I28>2.65,\"B\",\nIF(I28>=2.25,\"C+\",\nIF(I28>1.75,\"C\",\nIF(I28>1.25,\"D+\",\nIF(AND(I28<=1.25,I28>0),\"D\",\n\"\"\n)))))))))","v":"D"},{"$f":"AVERAGE(G29:G30)","v":1},{"$f":"IFERROR(IF($B28=\"M1\",IF(ROUND(AVERAGEIF(H29:H30,\">0\"),1)=ROUND(_xlfn.MINIFS(H29:H30,H29:H30,\">0\"),1),ROUND(AVERAGEIF(H29:H30,\">0\"),1),_xlfn.MINIFS(H29:H30,H29:H30,\">0\")+0.5),AVERAGEIF(H29:H30,\">0\")),0)","v":0},{"$f":"IFERROR(IF($B28=\"M1\",IF(ROUND(AVERAGEIF(I29:I30,\">0\"),1)=ROUND(_xlfn.MINIFS(I29:I30,I29:I30,\">0\"),1),I29,_xlfn.MINIFS(I29:I30,I29:I30,\">0\")+0.5),AVERAGEIF(I29:I30,\">0\")),0)","v":1},{"$f":"IFERROR(IF(G28=1,IF(I28-H28<0,\"-\",IF(I28-H28>0,\"+\",\"=\")),\"N.C\"),\"N.C.\")","v":"+"},null,null,{"$f":"IF(I28>=3.25,Profile!$G$7,\nIF(I28>2.5,Profile!$G$8,\nIF(I28>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",2]
["Comp",null,"GRPFM-9.1",{"$f":"VLOOKUP(C29,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive legislative scrutiny of budgets"},null,"D",1,{"$f":"IF(TRIM(CLEAN(E29))=\"A\",4)+IF(TRIM(CLEAN(E29))=\"B+\",3.5)+IF(TRIM(CLEAN(E29))=\"B\",3)+IF(TRIM(CLEAN(E29))=\"C+\",2.5)+IF(TRIM(CLEAN(E29))=\"C\",2)+IF(TRIM(CLEAN(E29))=\"D+\",1.5)+IF(TRIM(CLEAN(E29))=\"D\",1)+IF(TRIM(CLEAN(E29))=\"D*\",1)+IF(TRIM(CLEAN(E29))=\"NU\",0)+IF(TRIM(CLEAN(E29))=\"NA\",0)+IF(TRIM(CLEAN(E29))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F29))=\"A\",4)+IF(TRIM(CLEAN(F29))=\"B+\",3.5)+IF(TRIM(CLEAN(F29))=\"B\",3)+IF(TRIM(CLEAN(F29))=\"C+\",2.5)+IF(TRIM(CLEAN(F29))=\"C\",2)+IF(TRIM(CLEAN(F29))=\"D+\",1.5)+IF(TRIM(CLEAN(F29))=\"D\",1)+IF(TRIM(CLEAN(F29))=\"D*\",1)+IF(TRIM(CLEAN(F29))=\"NU\",0)+IF(TRIM(CLEAN(F29))=\"NA\",0)+IF(TRIM(CLEAN(F29))=\"\",)","v":1},{"$f":"IF(G29=1,IF(I29-H29<0,\"-\",IF(I29-H29>0,\"+\",\"=\")),\"N.C\")","v":"+"},"No report on the National Assembly's consideration of the draft 2020 budget was available.",null,{"$f":"IF(I29>=3.25,Profile!$G$7,\nIF(I29>2.5,Profile!$G$8,\nIF(I29>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",2]
["Comp",null,"GRPFM-9.2",{"$f":"VLOOKUP(C30,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive legislative scrutiny of audit reports"},null,"D",1,{"$f":"IF(TRIM(CLEAN(E30))=\"A\",4)+IF(TRIM(CLEAN(E30))=\"B+\",3.5)+IF(TRIM(CLEAN(E30))=\"B\",3)+IF(TRIM(CLEAN(E30))=\"C+\",2.5)+IF(TRIM(CLEAN(E30))=\"C\",2)+IF(TRIM(CLEAN(E30))=\"D+\",1.5)+IF(TRIM(CLEAN(E30))=\"D\",1)+IF(TRIM(CLEAN(E30))=\"D*\",1)+IF(TRIM(CLEAN(E30))=\"NU\",0)+IF(TRIM(CLEAN(E30))=\"NA\",0)+IF(TRIM(CLEAN(E30))=\"\",)","v":0},{"$f":"IF(TRIM(CLEAN(F30))=\"A\",4)+IF(TRIM(CLEAN(F30))=\"B+\",3.5)+IF(TRIM(CLEAN(F30))=\"B\",3)+IF(TRIM(CLEAN(F30))=\"C+\",2.5)+IF(TRIM(CLEAN(F30))=\"C\",2)+IF(TRIM(CLEAN(F30))=\"D+\",1.5)+IF(TRIM(CLEAN(F30))=\"D\",1)+IF(TRIM(CLEAN(F30))=\"D*\",1)+IF(TRIM(CLEAN(F30))=\"NU\",0)+IF(TRIM(CLEAN(F30))=\"NA\",0)+IF(TRIM(CLEAN(F30))=\"\",)","v":1},{"$f":"IF(G30=1,IF(I30-H30<0,\"-\",IF(I30-H30>0,\"+\",\"=\")),\"N.C\")","v":"+"},"No report on the review of the audit reports (2018, 2019 and 2020) by the National Assembly was available.",null,{"$f":"IF(I30>=3.25,Profile!$G$7,\nIF(I30>2.5,Profile!$G$8,\nIF(I30>1.25,Profile!$G$9,\nProfile!$G$10)))","v":"1. WEAK"},"1. FAIBLE",2]

{"sheet":"Data","index":2,"n_rows":43,"n_cols":26,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["#","PEFA Methdology","Locality Name","ID_Locality","Period","Year","Month","Date","ID_Ind","ID_Comp","ID","Method","Code_Indic","Indicator","Code_Comp","Component","Dimension Order","Type Indic","Score","Score Num","Performance","AVG Num","Min Num","Min NumC","Sum Num","AVG PEFA"]
[{"$f":"ROW(A1)","v":1},"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,1,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.1"},1,"GRPFM-1",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender impact analysis of budget policy proposals"},null,null,1,1,{"$f":"VLOOKUP($M2,Input!$C$10:$I$30,4,FALSE)","v":"D+"},{"$f":"VLOOKUP($M2,Input!$C$10:$I$30,7,FALSE)","v":1.5},{"$f":"IF(T2>=3.25,\"4. AVANCE\",\nIF(T2>2.5,\"3. BON\",\nIF(T2>1.25,\"2. BASIQUE\",\n\"1. FAIBLE\"\n)))","v":"2. BASIQUE"},{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2.1666666666666665},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},{"$f":"IF(V2=W2,V2,W2+0.5)","v":0.5},{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":8},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[2,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,2,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.2"},1,"GRPFM-2",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive public investment management"},null,null,2,1,{"$f":"VLOOKUP($M3,Input!$C$10:$I$30,4,FALSE)","v":"A"},{"$f":"VLOOKUP($M3,Input!$C$10:$I$30,7,FALSE)","v":4},"4. AVANCE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":4},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":12},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[3,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,3,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.3"},1,"GRPFM-3",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive budget circular"},null,null,3,1,{"$f":"VLOOKUP($M4,Input!$C$10:$I$30,4,FALSE)","v":"C"},{"$f":"VLOOKUP($M4,Input!$C$10:$I$30,7,FALSE)","v":2},"2. BASIQUE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":6},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[4,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,4,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.4"},1,"GRPFM-4",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive budget proposal documentation"},null,null,4,1,{"$f":"VLOOKUP($M5,Input!$C$10:$I$30,4,FALSE)","v":"NA"},{"$f":"VLOOKUP($M5,Input!$C$10:$I$30,7,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":0},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":0},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0}]
[5,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,5,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.5"},2,"GRPFM-5",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Sex-disaggregated performance information "},null,null,5,1,{"$f":"VLOOKUP($M6,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($M6,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[6,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,6,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.6"},1,"GRPFM-6",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Tracking budget expenditure for gender equality"},null,null,6,1,{"$f":"VLOOKUP($M7,Input!$C$10:$I$30,4,FALSE)","v":"C"},{"$f":"VLOOKUP($M7,Input!$C$10:$I$30,7,FALSE)","v":2},"2. BASIQUE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":6},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[7,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,7,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.7"},1,"GRPFM-7",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive reporting"},null,null,7,1,{"$f":"VLOOKUP($M8,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($M8,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":3},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[8,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,8,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.8"},1,"GRPFM-8",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Evaluation of gender impacts of service delivery"},null,null,8,1,{"$f":"VLOOKUP($M9,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($M9,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":3},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[9,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,9,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.9"},2,"GRPFM-9",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Legislative scrutiny of gender impacts of the budget"},null,null,9,1,{"$f":"VLOOKUP($M10,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($M10,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[10,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,1,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.11"},1,"GRPFM-1",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender impact analysis of budget policy proposals"},"GRPFM-1.1","Gender impact analysis of expenditure policy proposals",2,2,{"$f":"VLOOKUP($O11,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($O11,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2.1666666666666665},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},{"$f":"IF(V11=W11,V11,W11+0.5)","v":0.5},{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":8},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[11,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,1,2,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.12"},1,"GRPFM-1",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender impact analysis of budget policy proposals"},"GRPFM-1.2","Gender impact analysis of revenue policy proposals",3,2,{"$f":"VLOOKUP($O12,Input!$C$10:$I$30,4,FALSE)","v":"A"},{"$f":"VLOOKUP($O12,Input!$C$10:$I$30,7,FALSE)","v":4},"4. AVANCE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2.1666666666666665},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":8},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[12,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,2,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.21"},1,"GRPFM-2",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive public investment management"},"GRPFM-2.1","Gender responsive public investment management",5,2,{"$f":"VLOOKUP($O13,Input!$C$10:$I$30,4,FALSE)","v":"A"},{"$f":"VLOOKUP($O13,Input!$C$10:$I$30,7,FALSE)","v":4},"4. AVANCE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":4},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":12},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[13,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,3,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.31"},1,"GRPFM-3",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive budget circular"},"GRPFM-3.1","Gender responsive budget circular",7,2,{"$f":"VLOOKUP($O14,Input!$C$10:$I$30,4,FALSE)","v":"C"},{"$f":"VLOOKUP($O14,Input!$C$10:$I$30,7,FALSE)","v":2},"2. BASIQUE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":6},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[14,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,4,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.41"},1,"GRPFM-4",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive budget proposal documentation"},"GRPFM-4.1","Gender responsive budget proposal documentation",9,2,{"$f":"VLOOKUP($O15,Input!$C$10:$I$30,4,FALSE)","v":"NA"},{"$f":"VLOOKUP($O15,Input!$C$10:$I$30,7,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":0},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":0},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0}]
[15,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,5,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.51"},2,"GRPFM-5",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Sex-disaggregated performance information "},"GRPFM-5.1","Sex-disaggregated performance plans for service delivery",11,2,{"$f":"VLOOKUP($O16,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($O16,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[16,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,5,2,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.52"},2,"GRPFM-5",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Sex-disaggregated performance information "},"GRPFM-5.2","Sex-disaggregated performance achieved for service delivery",12,2,{"$f":"VLOOKUP($O17,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($O17,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[17,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,6,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.61"},1,"GRPFM-6",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Tracking budget expenditure for gender equality"},"GRPFM-6.1","Tracking budget expenditure for gender equality",14,2,{"$f":"VLOOKUP($O18,Input!$C$10:$I$30,4,FALSE)","v":"C"},{"$f":"VLOOKUP($O18,Input!$C$10:$I$30,7,FALSE)","v":2},"2. BASIQUE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":6},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[18,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,7,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.71"},1,"GRPFM-7",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive reporting"},"GRPFM-7.1","Gender responsive reporting",16,2,{"$f":"VLOOKUP($O19,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($O19,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":3},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[19,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,8,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.81"},1,"GRPFM-8",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Evaluation of gender impacts of service delivery"},"GRPFM-8.1","Evaluation of gender impacts of service delivery",18,2,{"$f":"VLOOKUP($O20,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($O20,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":3},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[20,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,9,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.91"},2,"GRPFM-9",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Legislative scrutiny of gender impacts of the budget"},"GRPFM-9.1","Gender responsive legislative scrutiny of budgets",20,2,{"$f":"VLOOKUP($O21,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($O21,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[21,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Current",{"$f":"Input!$D$4","v":2019},null,null,9,2,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.92"},2,"GRPFM-9",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Legislative scrutiny of gender impacts of the budget"},"GRPFM-9.2","Gender responsive legislative scrutiny of audit reports",21,2,{"$f":"VLOOKUP($O22,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($O22,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[22,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,1,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.1"},1,"GRPFM-1",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender impact analysis of budget policy proposals"},null,null,1,1,{"$f":"VLOOKUP($M23,Input!$C$10:$I$30,4,FALSE)","v":"D+"},{"$f":"VLOOKUP($M23,Input!$C$10:$I$30,7,FALSE)","v":1.5},"2. BASIQUE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1.5},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":8},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[23,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,2,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.2"},1,"GRPFM-2",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive public investment management"},null,null,2,1,{"$f":"VLOOKUP($M24,Input!$C$10:$I$30,4,FALSE)","v":"A"},{"$f":"VLOOKUP($M24,Input!$C$10:$I$30,7,FALSE)","v":4},"4. AVANCE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":4},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":12},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[24,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,3,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.3"},1,"GRPFM-3",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive budget circular"},null,null,3,1,{"$f":"VLOOKUP($M25,Input!$C$10:$I$30,4,FALSE)","v":"C"},{"$f":"VLOOKUP($M25,Input!$C$10:$I$30,7,FALSE)","v":2},"2. BASIQUE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":6},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[25,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,4,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.4"},1,"GRPFM-4",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive budget proposal documentation"},null,null,4,1,{"$f":"VLOOKUP($M26,Input!$C$10:$I$30,4,FALSE)","v":"NA"},{"$f":"VLOOKUP($M26,Input!$C$10:$I$30,7,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":0},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":0},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0}]
[26,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,5,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.5"},2,"GRPFM-5",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Sex-disaggregated performance information "},null,null,5,1,{"$f":"VLOOKUP($M27,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($M27,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[27,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,6,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.6"},1,"GRPFM-6",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Tracking budget expenditure for gender equality"},null,null,6,1,{"$f":"VLOOKUP($M28,Input!$C$10:$I$30,4,FALSE)","v":"C"},{"$f":"VLOOKUP($M28,Input!$C$10:$I$30,7,FALSE)","v":2},"2. BASIQUE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":6},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[28,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,7,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.7"},1,"GRPFM-7",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive reporting"},null,null,7,1,{"$f":"VLOOKUP($M29,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($M29,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":3},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[29,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,8,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.8"},1,"GRPFM-8",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Evaluation of gender impacts of service delivery"},null,null,8,1,{"$f":"VLOOKUP($M30,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($M30,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":3},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[30,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,9,null,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.9"},2,"GRPFM-9",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Legislative scrutiny of gender impacts of the budget"},null,null,9,1,{"$f":"VLOOKUP($M31,Input!$C$10:$I$30,4,FALSE)","v":"D"},{"$f":"VLOOKUP($M31,Input!$C$10:$I$30,7,FALSE)","v":1},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[31,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,1,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.11"},1,"GRPFM-1",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender impact analysis of budget policy proposals"},"GRPFM-1.1","Gender impact analysis of expenditure policy proposals",2,2,{"$f":"VLOOKUP($O32,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O32,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1.5},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},{"$f":"IF(V32=W32,V32,W32+0.5)","v":0.5},{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":8},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[32,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,1,2,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.12"},1,"GRPFM-1",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender impact analysis of budget policy proposals"},"GRPFM-1.2","Gender impact analysis of revenue policy proposals",3,2,{"$f":"VLOOKUP($O33,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O33,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1.5},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":8},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[33,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,2,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.21"},1,"GRPFM-2",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive public investment management"},"GRPFM-2.1","Gender responsive public investment management",5,2,{"$f":"VLOOKUP($O34,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O34,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":4},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":12},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[34,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,3,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.31"},1,"GRPFM-3",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive budget circular"},"GRPFM-3.1","Gender responsive budget circular",7,2,{"$f":"VLOOKUP($O35,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O35,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":6},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[35,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,4,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.41"},1,"GRPFM-4",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive budget proposal documentation"},"GRPFM-4.1","Gender responsive budget proposal documentation",9,2,{"$f":"VLOOKUP($O36,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O36,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":0},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":0},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0}]
[36,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,5,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.51"},2,"GRPFM-5",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Sex-disaggregated performance information "},"GRPFM-5.1","Sex-disaggregated performance plans for service delivery",11,2,{"$f":"VLOOKUP($O37,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O37,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[37,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,5,2,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.52"},2,"GRPFM-5",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Sex-disaggregated performance information "},"GRPFM-5.2","Sex-disaggregated performance achieved for service delivery",12,2,{"$f":"VLOOKUP($O38,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O38,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[38,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,6,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.61"},1,"GRPFM-6",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Tracking budget expenditure for gender equality"},"GRPFM-6.1","Tracking budget expenditure for gender equality",14,2,{"$f":"VLOOKUP($O39,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O39,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":2},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":6},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[39,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,7,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.71"},1,"GRPFM-7",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Gender responsive reporting"},"GRPFM-7.1","Gender responsive reporting",16,2,{"$f":"VLOOKUP($O40,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O40,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":3},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[40,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,8,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.81"},1,"GRPFM-8",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Evaluation of gender impacts of service delivery"},"GRPFM-8.1","Evaluation of gender impacts of service delivery",18,2,{"$f":"VLOOKUP($O41,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O41,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":3},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":0.5}]
[41,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,9,1,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.91"},2,"GRPFM-9",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Legislative scrutiny of gender impacts of the budget"},"GRPFM-9.1","Gender responsive legislative scrutiny of budgets",20,2,{"$f":"VLOOKUP($O42,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O42,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]
[42,"GRPFM",{"$f":"Input!$D$3","v":"Pefalia"},{"$f":"LEFT(Table1[[#This Row],[Locality Name]],5)","v":"Pefal"},"Previous",{"$f":"Input!$J$4","v":0},null,null,9,2,{"$f":"Table1[[#This Row],[ID_Locality]]&\".\"&Table1[[#This Row],[ID_Ind]]&Table1[[#This Row],[ID_Comp]]","v":"Pefal.92"},2,"GRPFM-9",{"$f":"VLOOKUP(Table1[[#This Row],[Code_Indic]],Dim_PEFA!$A$2:$B$13,2,FALSE)","v":"Legislative scrutiny of gender impacts of the budget"},"GRPFM-9.2","Gender responsive legislative scrutiny of audit reports",21,2,{"$f":"VLOOKUP($O43,Input!$C$10:$I$30,3,FALSE)","v":0},{"$f":"VLOOKUP($O43,Input!$C$10:$I$30,6,FALSE)","v":0},"1. FAIBLE",{"$f":"IFERROR(AVERAGEIFS(Table1[Score Num],Table1[Year],Table1[[#This Row],[Year]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\"),0)","v":1},{"$f":"_xlfn.MINIFS(Table1[Score Num],Table1[Date],Table1[[#This Row],[Date]],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]],Table1[Score Num],\">0\")","v":0},0.5,{"$f":"SUMIFS(Table1[Score Num],Table1[Code_Indic],Table1[[#This Row],[Code_Indic]])","v":4},{"$f":"(IF(Table1[[#This Row],[Method]]=1,Table1[[#This Row],[Min NumC]],Table1[[#This Row],[AVG Num]]))","v":1}]

{"sheet":"ES (Synth table)","index":3,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,3,2,4]]}
[null,null,null,null,{"$f":"Profile!G11&\" \"&Input!D3&\" - \"&Profile!G12&\" \"&Input!D4","v":"Pefa Gender Pefalia - Year 2019"}]
[]
["Method",null,null,"Indicadores",null,1,2]
[null,null,1,{"$f":"Dim_PEFA!A3","v":"GRPFM-1"},{"$f":"Dim_PEFA!B3","v":"Gender impact analysis of budget policy proposals"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(F$3=Data!$J$11:$J$22)*($C4=Data!$I$11:$I$22), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(G$3=Data!$J$11:$J$22)*($C4=Data!$I$11:$I$22), 0)),\"\")","v":"A"}]
[null,null,2,{"$f":"Dim_PEFA!A4","v":"GRPFM-2"},{"$f":"Dim_PEFA!B4","v":"Gender responsive public investment management"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(F$3=Data!$J$11:$J$22)*($C5=Data!$I$11:$I$22), 0)),\"\")","v":"A"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(G$3=Data!$J$11:$J$22)*($C5=Data!$I$11:$I$22), 0)),\"\")","v":""}]
[null,null,3,{"$f":"Dim_PEFA!A5","v":"GRPFM-3"},{"$f":"Dim_PEFA!B5","v":"Gender responsive budget circular"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(F$3=Data!$J$11:$J$22)*($C6=Data!$I$11:$I$22), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(G$3=Data!$J$11:$J$22)*($C6=Data!$I$11:$I$22), 0)),\"\")","v":""}]
[null,null,4,{"$f":"Dim_PEFA!A6","v":"GRPFM-4"},{"$f":"Dim_PEFA!B6","v":"Gender responsive budget proposal documentation"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(F$3=Data!$J$11:$J$22)*($C7=Data!$I$11:$I$22), 0)),\"\")","v":"NA"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(G$3=Data!$J$11:$J$22)*($C7=Data!$I$11:$I$22), 0)),\"\")","v":""}]
[null,null,5,{"$f":"Dim_PEFA!A7","v":"GRPFM-5"},{"$f":"Dim_PEFA!B7","v":"Sex-disaggregated performance information "},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(F$3=Data!$J$11:$J$22)*($C8=Data!$I$11:$I$22), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(G$3=Data!$J$11:$J$22)*($C8=Data!$I$11:$I$22), 0)),\"\")","v":"D"}]
[null,null,6,{"$f":"Dim_PEFA!A9","v":"GRPFM-6"},{"$f":"Dim_PEFA!B9","v":"Tracking budget expenditure for gender equality"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(F$3=Data!$J$11:$J$22)*($C9=Data!$I$11:$I$22), 0)),\"\")","v":"C"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(G$3=Data!$J$11:$J$22)*($C9=Data!$I$11:$I$22), 0)),\"\")","v":""}]
[null,null,7,{"$f":"Dim_PEFA!A10","v":"GRPFM-7"},{"$f":"Dim_PEFA!B10","v":"Gender responsive reporting"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(F$3=Data!$J$11:$J$22)*($C10=Data!$I$11:$I$22), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(G$3=Data!$J$11:$J$22)*($C10=Data!$I$11:$I$22), 0)),\"\")","v":""}]
[null,null,8,{"$f":"Dim_PEFA!A11","v":"GRPFM-8"},{"$f":"Dim_PEFA!B11","v":"Evaluation of gender impacts of service delivery"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(F$3=Data!$J$11:$J$22)*($C11=Data!$I$11:$I$22), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(G$3=Data!$J$11:$J$22)*($C11=Data!$I$11:$I$22), 0)),\"\")","v":""}]
[null,null,9,{"$f":"Dim_PEFA!A12","v":"GRPFM-9"},{"$f":"Dim_PEFA!B12","v":"Legislative scrutiny of gender impacts of the budget"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(F$3=Data!$J$11:$J$22)*($C12=Data!$I$11:$I$22), 0)),\"\")","v":"D"},{"$f":"_xlfn.IFNA(INDEX(Data!$S$11:$S$22, MATCH(1,(G$3=Data!$J$11:$J$22)*($C12=Data!$I$11:$I$22), 0)),\"\")","v":"D"}]

{"sheet":"Report Indic-Comp","index":4,"n_rows":47,"n_cols":33,"rows_kept":47,"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,null,"Indic","Indic","Indic"]
[null,null,null,null,{"$f":"Profile!G13","v":"Scores by dimensions"},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,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,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,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,"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,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,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,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,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,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,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,null,4,0,"A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Dimension","Indicator","Code_Indic","Code_Comp",{"$f":"Profile!G19","v":"ADVANCED"},{"$f":"Profile!G20","v":"GOOD"},{"$f":"Profile!G21","v":"BASIC"},{"$f":"Profile!G22","v":"LOW"},"Score"]
[null,{"$f":"VLOOKUP(E36,Dim_PEFA!C:D,2,FALSE)","v":"Gender impact analysis of expenditure policy proposals"},{"$f":"VLOOKUP(D36,Dim_PEFA!A:B,2,FALSE)","v":"Gender impact analysis of budget policy proposals"},"GRPFM-1","GRPFM-1.1",{"$f":"IF($J36>3.65,$J36,\"\")","v":""},{"$f":"IF(AND($J36<3.25,$J36>2.5),$J36,\"\")","v":""},{"$f":"IF(AND($J36<=2.5,$J36>1.25),$J36,\"\")","v":""},{"$f":"IF(AND($J36<=1.25,$J36>=1),$J36,\"\")","v":1},{"$f":"VLOOKUP(E36,Input!C:I,7,FALSE)","v":1}]
[null,{"$f":"VLOOKUP(E37,Dim_PEFA!C:D,2,FALSE)","v":"Gender impact analysis of revenue policy proposals"},null,"GRPFM-1","GRPFM-1.2",4,"","","",{"$f":"VLOOKUP(E37,Input!C:I,7,FALSE)","v":4}]
[null,{"$f":"VLOOKUP(E38,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive public investment management"},{"$f":"VLOOKUP(D38,Dim_PEFA!A:B,2,FALSE)","v":"Gender responsive public investment management"},"GRPFM-2","GRPFM-2.1",4,"","","",{"$f":"VLOOKUP(E38,Input!C:I,7,FALSE)","v":4}]
[null,{"$f":"VLOOKUP(E39,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive budget circular"},{"$f":"VLOOKUP(D39,Dim_PEFA!A:B,2,FALSE)","v":"Gender responsive budget circular"},"GRPFM-3","GRPFM-3.1","","",2,"",{"$f":"VLOOKUP(E39,Input!C:I,7,FALSE)","v":2}]
[null,{"$f":"VLOOKUP(E40,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive budget proposal documentation"},{"$f":"VLOOKUP(D40,Dim_PEFA!A:B,2,FALSE)","v":"Gender responsive budget proposal documentation"},"GRPFM-4","GRPFM-4.1","","","","",{"$f":"VLOOKUP(E40,Input!C:I,7,FALSE)","v":0}]
[null,{"$f":"VLOOKUP(E41,Dim_PEFA!C:D,2,FALSE)","v":"Sex-disaggregated performance plans for service delivery"},{"$f":"VLOOKUP(D41,Dim_PEFA!A:B,2,FALSE)","v":"Sex-disaggregated performance information "},"GRPFM-5","GRPFM-5.1","","","",1,{"$f":"VLOOKUP(E41,Input!C:I,7,FALSE)","v":1}]
[null,{"$f":"VLOOKUP(E42,Dim_PEFA!C:D,2,FALSE)","v":"Sex-disaggregated performance achieved for service delivery"},null,"GRPFM-5","GRPFM-5.2","","","",1,{"$f":"VLOOKUP(E42,Input!C:I,7,FALSE)","v":1}]
[null,{"$f":"VLOOKUP(E43,Dim_PEFA!C:D,2,FALSE)","v":"Tracking budget expenditure for gender equality"},{"$f":"VLOOKUP(D43,Dim_PEFA!A:B,2,FALSE)","v":"Tracking budget expenditure for gender equality"},"GRPFM-6","GRPFM-6.1","","",2,"",{"$f":"VLOOKUP(E43,Input!C:I,7,FALSE)","v":2}]
[null,{"$f":"VLOOKUP(E44,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive reporting"},{"$f":"VLOOKUP(D44,Dim_PEFA!A:B,2,FALSE)","v":"Gender responsive reporting"},"GRPFM-7","GRPFM-7.1","","","",1,{"$f":"VLOOKUP(E44,Input!C:I,7,FALSE)","v":1}]
[null,{"$f":"VLOOKUP(E45,Dim_PEFA!C:D,2,FALSE)","v":"Evaluation of gender impacts of service delivery"},{"$f":"VLOOKUP(D45,Dim_PEFA!A:B,2,FALSE)","v":"Evaluation of gender impacts of service delivery"},"GRPFM-8","GRPFM-8.1","","","",1,{"$f":"VLOOKUP(E45,Input!C:I,7,FALSE)","v":1}]
[null,{"$f":"VLOOKUP(E46,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive legislative scrutiny of budgets"},{"$f":"VLOOKUP(D46,Dim_PEFA!A:B,2,FALSE)","v":"Legislative scrutiny of gender impacts of the budget"},"GRPFM-9","GRPFM-9.1","","","",1,{"$f":"VLOOKUP(E46,Input!C:I,7,FALSE)","v":1}]
[null,{"$f":"VLOOKUP(E47,Dim_PEFA!C:D,2,FALSE)","v":"Gender responsive legislative scrutiny of audit reports"},null,"GRPFM-9","GRPFM-9.2","","","",1,{"$f":"VLOOKUP(E47,Input!C:I,7,FALSE)","v":1}]

{"sheet":"ES-Scores","index":5,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"\"Number of dimensions by scores - Year \"&Input!D4","v":"Number of dimensions by scores - Year 2019"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"Profile!$G$15","v":"Number of indicators per score"}]
[null,"Ind",{"$f":"\"PEFA \"&Input!D4","v":"PEFA 2019"}]
[null,"A",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B5)","v":1}]
[null,"B+",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B6)","v":0}]
[null,"B",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B7)","v":0}]
[null,"C+",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B8)","v":0}]
[null,"C",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B9)","v":2}]
[null,"D+",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B10)","v":1}]
[null,"D",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B11)","v":4}]
[null,"NR",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B12)","v":0}]
[null,"NU",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B13)","v":0}]
[null,"NA",{"$f":"COUNTIFS(Input!A:A,\"Indic\",Input!F:F,B14)","v":1}]
[null,"Total",{"$f":"SUM(C5:C14)","v":9}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"Profile!$G$16","v":"Number of dimensions per score"}]
[]
[null,"Comp",{"$f":"\"PEFA \"&Input!D4","v":"PEFA 2019"}]
[null,"A",{"$f":"COUNTIFS(Input!A:A,\"Comp\",Input!F:F,B24)","v":2}]
[null,"B",{"$f":"COUNTIFS(Input!A:A,\"Comp\",Input!F:F,B25)","v":0}]
[null,"C",{"$f":"COUNTIFS(Input!A:A,\"Comp\",Input!F:F,B26)","v":2}]
[null,"D",{"$f":"COUNTIFS(Input!A:A,\"Comp\",Input!F:F,B27)","v":7}]
[null,"D*",{"$f":"COUNTIFS(Input!A:A,\"Comp\",Input!F:F,B28)","v":7}]
[null,"NU",{"$f":"COUNTIFS(Input!A:A,\"Comp\",Input!F:F,B29)","v":0}]
[null,"NA",{"$f":"COUNTIFS(Input!A:A,\"Comp\",Input!F:F,B30)","v":1}]
[null,"Total",{"$f":"SUM(C24:C30)","v":19}]

{"sheet":"PivotTable","index":6,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Method","(Multiple Items)"]
[]
["Average of Score num (Curr)"]
["ID","Total"]
["GRPFM-1",1.5]
["GRPFM-2",4]
["GRPFM-3",2]
["GRPFM-4",0]
["GRPFM-5",1]
["GRPFM-6",2]
["GRPFM-7",1]
["GRPFM-8",1]
["GRPFM-9",1]

{"sheet":"Report Indic (Radar)","index":7,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,{"$f":"Profile!G14","v":"Scores by indicators"}]

{"sheet":"Dim_PEFA","index":8,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["ID_Ind","Indicator","ID_Comp","Component"]
["GRPFM-1","Gender impact analysis of budget policy proposals","GRPFM-1.1","Gender impact analysis of expenditure policy proposals"]
["GRPFM-1","Gender impact analysis of budget policy proposals","GRPFM-1.2","Gender impact analysis of revenue policy proposals"]
["GRPFM-2","Gender responsive public investment management","GRPFM-2.1","Gender responsive public investment management"]
["GRPFM-3","Gender responsive budget circular","GRPFM-3.1","Gender responsive budget circular"]
["GRPFM-4","Gender responsive budget proposal documentation","GRPFM-4.1","Gender responsive budget proposal documentation"]
["GRPFM-5","Sex-disaggregated performance information ","GRPFM-5.1","Sex-disaggregated performance plans for service delivery"]
["GRPFM-5","Sex-disaggregated performance information ","GRPFM-5.2","Sex-disaggregated performance achieved for service delivery"]
["GRPFM-6","Tracking budget expenditure for gender equality","GRPFM-6.1","Tracking budget expenditure for gender equality"]
["GRPFM-7","Gender responsive reporting","GRPFM-7.1","Gender responsive reporting"]
["GRPFM-8","Evaluation of gender impacts of service delivery","GRPFM-8.1","Evaluation of gender impacts of service delivery"]
["GRPFM-9","Legislative scrutiny of gender impacts of the budget","GRPFM-9.1","Gender responsive legislative scrutiny of budgets"]
["GRPFM-9","Legislative scrutiny of gender impacts of the budget","GRPFM-9.2","Gender responsive legislative scrutiny of audit reports"]

{"sheet":"Profile","index":9,"n_rows":105,"n_cols":26,"rows_kept":105,"cut":false,"hidden":true,"merged":[]}
["Year","Month","Score","Comparable","Status","PEFA check","names"]
[2016,"Jan","A",0,"Draft1","Yes","Justification for the evolution"]
[2017,"Février","B",1,"Draft2","No","Team Leader"]
[2018,"Mar","C",null,"Draft3",null,"Country"]
[2019,"Avr","D",null,"Final",null,"Evaluation year"]
[2020,"Mai","D*",null,null,null,"Evaluation PEFA Gender"]
[2021,"Juin","NA",null,null,null,"4. ADVANCED"]
[2022,"Juillet","NU",null,null,null,"3. GOOD"]
[2023,"Août",null,null,null,null,"2. BASIC"]
[2024,"Sept",null,null,null,null,"1. WEAK"]
[2025,"Oct.",null,null,null,null,"Pefa Gender"]
[2026,"Nov",null,null,null,null,"Year"]
[2027,"Déc.",null,null,null,null,"Scores by dimensions"]
[2028,null,null,null,null,null,"Scores by indicators"]
[2029,null,null,null,null,null,"Number of indicators per score"]
[2030,null,null,null,null,null,"Number of dimensions per score"]
[2031,null,null,null,null,null,"Evolution over time by indicators "]
[2032,null,null,null,null,null,"Evolution over time by dimension "]
[2033,null,null,null,null,null,"ADVANCED"]
[2034,null,null,null,null,null,"GOOD"]
[2035,null,null,null,null,null,"BASIC"]
[2036,null,null,null,null,null,"LOW"]
[2037]
[2038]
[2039]
[2040]
[2041]
[2042]
[2043]
[2044]
[2045]
[2046]
[2047]
[2048]
[2049]
[2050]
[]
[]
[]
[]
[null,null,"Score 2011 FMK","Score 2016 FMK","Comp","Names"]
[null,null,"A","A","Yes","Pillar"]
[null,null,"B","B","No","Indicator"]
[null,null,"C","C",null,"Dimensions"]
[null,null,"D","D",null,"1. Overall Budget Discipline"]
[null,null,"NU","D*",null,"2. Strategic allocation of resources "]
[null,null,"NA","NU",null,"3. Effective service delivery "]
[null,null,"NR","NA",null,"Team Leader"]
[null,null,null,null,null,"Country"]
[null,null,null,null,null,"Overall Rating"]
[null,null,null,null,null,"Current assessment"]
[null,null,null,null,null,"Previous assessment"]
[null,null,null,null,null,"Score by pillar / indicator"]
[null,null,null,null,null,"Indicators / Dimensions "]
[null,null,null,null,null,"Number of dimensions per score "]
[null,null,null,null,null,"Year "]
[null,null,null,null,null,"PEFA scores by indicators "]
[null,null,null,null,null,"PEFA scores by dimension"]
[null,null,null,null,null,"Evolution of scores (2016 Table)"]
[null,null,null,null,null,"Scores - Year "]
[null,null,null,null,null,"2011 Fmk"]
[null,null,null,null,null,"Justification of PEFA scores  "]
[null,null,null,null,null,"2016 Fmk"]
[null,null,null,null,null,"Scores evolution for indicators "]
[null,null,null,null,null,"Scores evolution for dimensions "]
[null,null,null,null,null,"Score Evolution "]
[null,null,null,null,null,"Scores by pillar "]
[null,null,null,null,null,"1. Low"]
[null,null,null,null,null,"2. Basic"]
[null,null,null,null,null,"3. Good"]
[null,null,null,null,null,"4. Very good"]
[null,null,null,null,null,"Strength"]
[null,null,null,null,null,"Weakness"]
[null,null,null,null,null,"Average"]
[null,null,null,null,null,"Rationale for the assessment"]
[null,null,null,null,null,"Ranking of indicators according to their score"]
[null,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,"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 (Synth table): Sec!Pefa2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input:Sec!Pefa2018"]
[null,null,null,null,null,"Report Indic-Comp: 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,"ES-Scores: Sec!Pefa2018",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,"Report Indic (Radar): Sec!Pefa2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report Indic-Comp: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-Scores: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,"PivotTable:Indic"]
[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,"Report Indic (Radar):Sec!Pefa2018"]
[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,"Dim_PEFA: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,"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,"General password:Indic"]

{"sheet":"colors","index":10,"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,"Report Indic-Comp",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,4,4]
[4,"Avancé"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Column1"]