{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["KPI","JQRR","Data Validation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"KPI","index":0,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[27,0,33,0],[27,1,33,1],[27,2,28,2],[30,2,33,2],[12,6,13,6],[14,0,26,0],[14,1,26,1],[14,2,25,2],[1,1,3,5],[4,1,5,5],[6,1,7,7],[12,4,13,4],[12,5,13,5],[8,1,9,5],[12,8,13,8],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,7,13,7],[12,3,13,3]]}
[]
[null,"Liberia",null,null,null,null,"Compact Signing Date: ",null,"2015-10-02"]
[null,null,null,null,null,null,"Entry into Force Date: ",null,"2016-01-20"]
[null,null,null,null,null,null,"End of Compact Date: ",null,"2021-01-19"]
[null,"Key Performance Indicators ",null,null,null,null,"Compact Closeout Period:",null,"2021-05-19"]
[null,null,null,null,null,null,"Current Compact Budget: ",null,256726000]
[null,"(Quarter 10 Results: April to June  2018)"]
[]
[null,"Report Date: July 10, 2018"]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
["Project/Outcome","Projected Economic Benefits and Beneficiaries","Activity/Outcome","Result","Key Performance Indicators","Baseline","End of Compact Target","Quarter 1 through Quarter 10 Actuals\n(June 2018)","Percent Compact Target Satisfied \n(June 2018)"]
[null,null,null,null,null,null,null,null,null,null,null,"80-100%"]
["Energy Project\nObjective : Provide access to more reliable and affordable electricity.","Economic beneficiaries are estimated  at 460,000 people.","Mount Coffee Rehabilitation Activity\nOutcome: Address the lack of access to affordable and reliable electricity by increasing the amount of electricity generated, facilitating a decrease in the overall electricity tariff, and helping to increase reliability and adequacy of electricity","Increased consumption of electricity","Total electricity sold (MWH)",36956,289396,26421,{"$f":"(H15-F15)/(G15-F15)","v":-4.1732688955791478E-2}]
[null,null,null,"Increased number of firms, institutions, and households connected to grid","Customers connected to the grid",34321,"Pending",53260,"Pending "]
[null,null,null,"Increased reliability and adequacy of electricity","System Average Interruption Frequency Index (SAIFI)",25.1,"No Target",22.7,"No Target"]
[null,null,null,"Increased reliability and adequacy of electricity","System Average Interruption Duration Index (SAIDI)",109.5,"No Target",25.06,"No Target"]
[null,null,null,"Reduced tariffs","Electricity Tariff (US Dollars)",0.52,"Pending",0.35,"Pending "]
[null,null,null,"Increased share of electricity from hydropower","Percentage of electricity supplied by Mt Coffee Hydropower Plant",0,"No Target",0.99099999999999999,"No Target"]
[null,null,null,"Increased generation","Total electricity supply (MWH)",48975,"Pending",64238.6,"Pending "]
[null,null,null,"Infrastructure constructed or rehabilitated","Generation capacity added (Megawatts)",0,88,66,{"$f":"(H22-F22)/(G22-F22)","v":0.75}]
[null,null,null,"Infrastructure constructed or rehabilitated","Transmission substation capacity added (Megavolt Ampere)",0,200,84,{"$f":"(H23-F23)/(G23-F23)","v":0.42}]
[null,null,null,"Infrastructure constructed or rehabilitated","Kilometers of transmission lines upgraded or built",0,51,24,{"$f":"(H24-F24)/(G24-F24)","v":0.47058823529411764}]
[null,null,null,"Rehabilitate MCHPP and Construct and rehabilitate transmission infrastructure from MCHPP to electricity grid","Value disbursed of power infrastructure construction contracts (US Dollars)",0,146800000,130768202.06999999,{"$f":"(H25-F25)/(G25-F25)","v":0.89079156723433239}]
[null,null,null,"Rehabilitate MCHPP and Construct and rehabilitate transmission infrastructure from MCHPP to electricity grid","Value disbursed for Mt. Coffee Hydropower Plant rehabilitation",137924885,356762257,323015601,{"$f":"(H26-F26)/(G26-F26)","v":0.84579116587088243}]
[null,null,"Other Energy Activities\n(TBD)\nOutcomes:  TBD",null,"TBD","TBD","TBD","Pending ","TBD"]
["Roads Project\nObjective: Improve the planning and execution of routine, periodic and emergency road maintenance.",null,null,null,"National Road fund operational","Date","2017-04-01","Pending ","Pending "]
[null,null,null,null,"Road fund passed and signed into law","Date","2016-10-01","2016-10-01","Complete"]
[null,null,"National Road Maintenance Activity\nOutcomes: Finance periodic road maintenance works through an incentive matching fund (Matching Road Maintenance Fund)","Road maintenance funded","Funds provided to the road fund (US Dollars)",0,"Pending","Pending ","Pending "]
[null,null,"Roads Sector Reform Activity: \nOutcomes: to build capacity and provide technical assistance at the national and regional level through the development of a national  road asset management system","Road maintenance management systems created with assets inventoried","Road Maintenance Management system accepted","Date","2018-03-31","Pending ","Pending "]
[null,null,null,null,"Axle Load Control Law passed and signed into law","Date","2016-10-01","2015-10-23","Complete"]
[null,null,null,"Collection of road data","Roadway inventory developed","Date","2017-12-31","Pending ","Pending "]
[null,null,null,"Collection of road data","Traffic counts conducted","Date","2018-06-30","Pending ","Pending "]

{"sheet":"JQRR","index":1,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[27,0,33,0],[27,1,33,1],[27,2,28,2],[30,2,33,2],[12,5,13,5],[12,0,13,0],[12,1,13,1],[12,11,12,12],[14,0,26,0],[14,1,26,1],[14,2,25,2],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,2,13,2],[12,3,13,3],[12,4,13,4],[1,1,3,5],[4,1,5,5],[6,1,7,8],[7,11,7,12],[8,1,9,5]]}
[]
[null,"Liberia",null,null,null,null,null,null,null,null,"Compact Signing Date: ",null,"2015-10-02"]
[null,null,null,null,null,null,null,null,null,null,"Entry into Force Date: ",null,"2016-01-20"]
[null,null,null,null,null,null,null,null,null,null,"End of Compact Date: ",null,"2021-01-19"]
[null,"Compact Results Review",null,null,null,null,null,null,null,null,"Compact Closeout Period:",null,"2021-05-19"]
[null,null,null,null,null,null,null,null,null,null,"Current Compact Budget: ",null,256726000]
[null,"(Quarter 10 Results: April to June 2018)"]
[null,null,null,null,null,null,null,null,null,null,null,"FY 2018 Scorecard Performance"]
[null,"Report Date: July 10, 2018",null,null,null,null,null,null,null,null,null,"þ","Control of Corruption"]
[null,null,null,null,null,null,null,null,null,null,null,"þ","Democratic Rights",null," "]
[null,null,null,null,null,null,null,null,null,null,null,"þ","Pass Half Overall (10/20)"]
[]
["Project/Outcome","Projected Economic Benefits and Beneficiaries","Activity/Outcome","Result","Key Performance Indicators","Baseline","Year 3 Target","End of Compact Target","Quarter 1 through Quarter 10 Actuals\n(June 2018)","Percent of\nYear 3 Target Satisfied","Percent Compact Target Satisfied \n(June 2018)","Department of Compact Operations' Assessment of Probability of Achieving End of Compact Target"]
[null,null,null,null,null,null,null,null,null,null,null,"Percentage of Target Likely to be Achieved","Notes",null,null,"80-100%"]
["Energy Project\n($201.6 Million Current Budget)\nObjective : Provide access to more reliable and affordable electricity.","Economic beneficiaries are estimated  at 460,000 people.","Mount Coffee Rehabilitation Activity\nOutcome: Address the lack of access to affordable and reliable electricity by increasing the amount of electricity generated, facilitating a decrease in the overall electricity tariff, and helping to increase reliability and adequacy of electricity","Increased consumption of electricity","Total electricity sold (MWH)",36956,"TBD",289396,46210,"Pending",{"$f":"(I15-F15)/(H15-F15)","v":3.665821581365869E-2},null,"M&E Comments: Data for this indicator was only available through the first month of Q10 (April), so it is likely that the figure does not reflect the full perfomance that can be expected for Q10 (FY18 Q3). \n\nNote that the Compact target reflects a full year of electricity sales, while the Q10 value reflects just over a quarter of sales."]
[null,null,null,"Increased number of firms, institutions, and households connected to grid","Customers connected to the grid",34321,"TBD","Pending",53260,"TBD","Pending ",null,"M&E Comments: This indicator is currently reported based on the number of customers connected at the end of a quarter.  Thus, the data for this indicator represents the months of Jan-March 2018  (i.e., Q9), so is likely somewhat lower than the current total. GIven that Libango is the only entity with accurate knowledge of the number of customers connected to LEC's network and actively vending, concerns about the quality of data for this indicator remain. "]
[null,null,null,"Increased reliability and adequacy of electricity","System Average Interruption Frequency Index (SAIFI)",25.1,null,"No Target",22.7,null,"No Target",null,"M&E Comments: Data for this indicator was only available through the first month of Q10 (April). \n\n"]
[null,null,null,"Increased reliability and adequacy of electricity","System Average Interruption Duration Index (SAIDI)",109.5,null,"No Target",25.06,null,"No Target",null,"M&E Comments: Data for this indicator was only available through the first month of Q10 (April). \n\n"]
[null,null,null,"Reduced tariffs","Electricity Tariff (US Dollars)",0.52,"TBD","Pending",0.35,"TBD","Pending ",null,"\nENG Comment:  This result is problematic because the rate is unlikely to be a cost reflective tariff. "]
[null,null,null,"Increased share of electricity from hydropower","Percentage of electricity supplied by Mt Coffee Hydropower Plant",0,null,"No Target",0.99099999999999999,null,"No Target",null,"M&E Comments: The data for this indicator represents the months of Jan-March 2018  (FY18 Q2), which is the most curent data available."]
[null,null,null,"Increased generation","Total electricity supply (MWH)",48975,"TBD","Pending",64238.6,"Pending","Pending ",null,"M&E Comments: Data for this indicator was only available through the first month of Q10 (April), so it is likely that the figure does not reflect the full perfomance that can be expected for Q10 (FY18 Q3). \n\nThat said, the baseline value reflects a full year of electricity supply, while the current actual reflects just over one quarter of supply."]
[null,null,null,"Infrastructure constructed or rehabilitated","Generation capacity added (Megawatts)",0,88,88,66,{"$f":"(I22-F22)/(G22-F22)","v":0.75},{"$f":"(I22-F22)/(H22-F22)","v":0.75},null,"M&E Comments:  The ITT won't be updated until the 4th turbine has been officially handed over to LEC."]
[null,null,null,"Infrastructure constructed or rehabilitated","Transmission substation capacity added (Megavolt Ampere)",0,200,200,84,{"$f":"(I23-F23)/(G23-F23)","v":0.42},{"$f":"(I23-F23)/(H23-F23)","v":0.42},null,"M&E Comments:  M&E recently learned that the target of 200 was incorrect, so it will be updated to 122 MVA during the next M&E Plan revision. In other words, what remains is the 28MVA associated with the uncommissioned 4th turbine and the 10MVA of auxillary capacity that is planned."]
[null,null,null,"Infrastructure constructed or rehabilitated","Kilometers of transmission lines upgraded or built",0,51,51,24,0.47058823529411764,{"$f":"(I24-F24)/(H24-F24)","v":0.47058823529411764}]
[null,null,null,"Rehabilitate MCHPP and Construct and rehabilitate transmission infrastructure from MCHPP to electricity grid","Value disbursed of power infrastructure construction contracts (US Dollars)",0,146800000,146800000,130768202.06999999,0.89079156723433239,{"$f":"(I25-F25)/(H25-F25)","v":0.89079156723433239}]
[null,null,null,"Rehabilitate MCHPP and Construct and rehabilitate transmission infrastructure from MCHPP to electricity grid","Value disbursed for Mt. Coffee Hydropower Plant rehabilitation",137924885,356762257,356762257,323015601,0.84579116587088243,{"$f":"(I26-F26)/(H26-F26)","v":0.84579116587088243},null,"M&E Comments: This indicator is currently reported based on the amount disbursed at the end of a quarter.  Thus, the data for this indicator represents the months of Jan-March 2018  (i.e., Q9), so is likely somewhat lower than the current total"]
[null,null,"Other Energy Activities\n(TBD)\nOutcomes:  TBD",null,"TBD","TBD","TBD","TBD","Pending ",{"$f":"K27","v":"TBD"},"TBD",null,"M&E Comments: Indicators to be added during M&E Plan revision."]
["Roads Project\n($21.07 Million Current Budget) \nObjective: Improve the planning and execution of routine, periodic and emergency road maintenance.",null,null,null,"National Road fund operational","Date","2017-04-01","2017-04-01","Pending ",null,"Pending ","40-60%","TVS Comment: National Road Fund law is in place and effective; however, the GOL has not been able to make the NRF operational - fully staffed and funded - for 18 months now. NRF Manager was appointed May-June 2018."]
[null,null,null,null,"Road fund passed and signed into law","Date","2016-10-01","2016-10-01","2016-10-01",null,"Complete","80-100%"]
[null,null,"National Road Maintenance Activity\nOutcomes: Finance periodic road maintenance works through an incentive matching fund (Matching Road Maintenance Fund)","Road maintenance funded","Funds provided to the road fund (US Dollars)",0,null,"Pending","Pending ",null,"Pending ","40-60%","TVS Comment: The lack of funding of the NRF signals GOL's lack of commitment or prioritization of road maintenance."]
[null,null,"Roads Sector Reform Activity: \nOutcomes: to build capacity and provide technical assistance at the national and regional level through the development of a national  road asset management system","Road maintenance management systems created with assets inventoried","Road Maintenance Management system accepted","Date",null,"2018-03-31","Pending ",null,"Pending ","40-60%","TVS Comment: Road inventory and other data for the management system will be available by the end of the Compact. Whether the GOL will adopt and utilize the management system is still an open question."]
[null,null,null,null,"Axle Load Control Law passed and signed into law","Date",null,"2016-10-01","2015-10-23","Complete ","Complete","80-100%"]
[null,null,null,"Collection of road data","Roadway inventory developed","Date",null,"2017-12-31","Pending ",null,"Pending ","60-80%","M&E Comment:  A road inventory and condition survey is currently underway for primary roads."]
[null,null,null,"Collection of road data","Traffic counts conducted","Date",null,"2018-06-30","Pending ",null,"Pending ","80-100%","TVS Comment: Traffic Counts were completed in 2017; Currently road inventory and condition survey for primary roads being conducted."]

{"sheet":"Data Validation","index":2,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Percent Complete "]
["80-100%"]
["60-80%"]
["40-60%"]
["20-40%"]
["0-20%"]