{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["User Guide","Explanation of Inputs","Spreadsheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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 Guide","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"USER-GUIDE: Calculating Energy Access Impact"]
[]
[null,"This Excel-Tool can be used to calculate the number of people receiving access to electricity by electricity on-grid progammes. It is to be seen as supplement to the discussion paper: \"Methodologies and Principles for Monitoring Access to Modern Energy: Access to Modern Electricity via on-grid electricity projects: Calculation and Attribution of Achievements to Different Stakeholders\". This tool as well as the discussion paper are draft versions. Any comments are highly welcome. "]
[]
[null,"The current Excel-tool was developed in order to facilitate calculation of electricity access achieved through the building of new or the rehabilitation of existing power plants. The underlying assumption is that the additional electricity generated by the power plant can be used to supply newly connected consumers in the electricity grid. Further spreadsheets e.g. for transmission or demand-side energy efficiency projects will be added in upcoming updates of this Excel tool."]
[]
[null,"Fields highlighted in red, green, and yellow indicate those fields where inputs can be made. Red fields are for general project information, comments, and additional information about the input numbers used. Green fields indicate those which are required for the calculation. Depending on the available input data, there are two alternative calculation paths (columns F and G) which can be used for the calculation, both delivering the same results. "]
[]
[null,"Apart from specific information about the project itself, path 1 requires information about the share of households in total electricity consumption, average annual household electricity consumption and average household size in the project country. Path 2 requires information about total annual electricity consumption and the number of people connected to the electricity grid. The required inputs for path 2 may often be easier to obtain."]
[]
[null,"However, for both paths there may be cases where the numbers required as inputs in the green fields are not directly available, but need to be calculated beforehand. These are indicated by a red frame around those fields - these contain a calculation formula. The formulas require inputs in the yellow fields below. For example: if in path 1 the share of household use in total electricity consumption (line 12) is not known, this will be calculated by dividing the annual electricity consumption of all households (line 13) by the annual total electricity consumption (line 14). But note that the yellow fields only need to be filled in case the input for a green field with a red frame is not known. If the input for a green field with a red frame is available, the formula in that field can simply be overwritten and the yellow fields do not require any input."]
[]
[null,"With all green fields of either path 1 or path 2 filled, the Excel-tool calculates the number of persons which can be supplied with electricity from the project (line 27). However, this result is then compared to the number of actual new connections which can be expected to occur in the country (independently of the new power plant) over a period of two years in order to check its plausibility. For instance, let’s assume, that the electricity generated by the power plant could theoretically supply 500,000 persons, but only 100,000 persons will actually be newly connected to the grid through electrification programs within two years after completion of the power plant – then the new power plant can only supply those 100.000 new customers with electricity. The result of this cross-check is given in line 28. The remaining electricity which is not used for new connected consumers (line 32) would be used for increased consumption of previously existing consumers (line 34). "]
[]
[null,"After the plausibility check, the donor institution’s financing share in total donor contributions to the project is considered (line 29), since only that share of the result can be attributed to the respective donor. "]
[]
[null,"Finally, a security margin is applied (currently set at 20%) to account for uncertainties in the input parameters and for the fact that some of the people who are newly connected to the grid may have already had other forms of electricity access before. The final result of persons receiving electricity access through the project is given in line 30 of the Excel-tool. "]
[]
[null,"Detailed instructions on filling out the spreadsheet are given on the following page: \"Explanation of Inputs\"."]
[]
[null,"Categories (Input List for Programme Sheets)"]
[null,"New Power Plants"]
[null,"Rehabilitation of Power Plants"]

{"sheet":"Explanation of Inputs","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,2]]}
["Line","Item","Explanation"]
["Line 9","Additional yearly electricity generation","Only if the project results in an additional quantifiable amount of electricity, it can contribute to creating new access. The additional electricity generation is to be entered in GWh per year."]
["Line 10","Anticipated technical grid losses","Technical grid losses in the project country/grid area (as a total of transmission and distribution losses in % of total electricity generation) are a required input because they reduce the amount of additional electricity which is actually available for the creation of access."]
["Line 11","Financing share in donor contributions","The share of the reporting donor's financial contribution to total donor financing of the project which is to be entered as a percentage."]
["Line 12","Share of household use in total electricity consumption","Only part of the project country's/grid area's total electricity consumption is used by households. Their corresponding share is to be entered as a percentage."]
["Line 13","Annual electricity consumption of all households","The total amount of electricity consumed on household level in the project country/grid area in GWh per year."]
["Line 14","Annual total electricity consumption","The total amount of electricity consumed by all sectors in the project country/grid area in GWh per year."]
["Line 15","Average annual household electricity consumption","The average amount of electricity which is consumed by households which are connected to the grid in the project country/grid area. It is to be entered as a value in kWh per year."]
["Line 16","Annual electricity consumption of all households","Same as line 13."]
["Line 17","Number of connected households","The total number of all households which are connected to the grid in the project country/grid area."]
["Line 18","Number of connected people","The total number of all persons which have a grid connection in the project country/grid area."]
["Line 19","Total population","The project country's/grid area's total population."]
["Line 20","Electrification rate before the intervention","The project country's/grid area's electrification rate at the time before the project started in percent."]
["Line 21","Average household size","The average number of persons living in each household in the project country/grid area."]
["Line 22","Total population","Same as line 19."]
["Line 23","Number of households","The total number of households in the project country/grid area."]
["Line 24","Actual number of people receiving new connections (over two years)","The number of people who are to be (in the case of ex-ante estimates) or were actually connected (in the case of ex-post measurements) to the grid in the project country/grid area over a period of two years after finalization of the project. This input is required for the plausibility check of the calculated result. The required expansion of distribution grids for new connections to take place does not have to be financed by the reporting donor’s funds, but can also be funded by third parties."]
["Line 25","Security margin","In order to account for uncertainties in the input parameters a security margin needs to be applied. A value of 20 % is recommended. "]
[]
[null,"NOTE: In case the project is implemented in a regional grid of a country and not in a nationwide grid, the respective numbers for that regional grid area are to be used as inputs, if available."]

{"sheet":"Spreadsheet","index":2,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[[35,1,35,4],[28,1,28,4],[27,1,27,4],[29,1,29,4],[30,1,30,4],[33,1,33,4],[34,1,34,4],[31,1,31,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[41,2,41,7],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[13,2,13,4],[26,1,26,4],[15,2,15,4],[16,2,16,4],[17,1,17,2],[17,3,17,4],[18,1,18,3],[19,1,19,3],[20,1,20,2],[20,3,20,4],[21,1,21,3],[22,1,22,3],[23,1,23,4],[24,1,24,4],[1,6,1,10],[2,6,4,10],[14,1,14,4],[7,1,7,4],[7,5,7,6],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[12,2,12,4]]}
[]
[null,"Project:",null,null,"Name",null,"Comments"]
[null,"Country/Region:",null,null,"Country"]
[null,"Project Number:",null,null,"No."]
[null,"Additional Number:",null,null,"No."]
[null,"Project Manager:",null,null,"Name"]
[null,"Category:",null,null,null,"Path 1","Path 2"]
[null,"Item",null,null,null,"Value",null,"Unit","Data-Sources (see Discussion Paper)","Year","Comment"]
[null,"Additional yearly electricity generation",{"$nulls":5},"GWh/a"]
[null,"Grid losses",{"$nulls":5},"%"]
[null,"Financing share in donor contributions",{"$nulls":5},"%"]
[null,"Share of household use in total electricity consumption",null,null,null,{"$f":"F13/F14","v":{"$error":"#DIV/0!"}},null,"%"]
[null,null,"Annual electricity consumption of all households",{"$nulls":4},"GWh/a"]
[null,null,"Annual total electricity consumption",{"$nulls":4},"GWh/a"]
[null,"Average annual household electricity consumption",null,null,null,{"$f":"F16*1000000/F17","v":{"$error":"#DIV/0!"}},null,"kWh/a/household"]
[null,null,"Annual electricity consumption of all households",{"$nulls":4},"GWh/a"]
[null,null,"Number of connected households",null,null,{"$f":"F18/F21","v":{"$error":"#DIV/0!"}},null,"Households"]
[null,null,null,"Number of connected people",null,{"$f":"F19*F20","v":0},{"$f":"G19*G20","v":0},"Persons"]
[{"$nulls":4},"Total population",null,null,"Persons"]
[{"$nulls":4},"Electrification rate before the intervention",null,null,"%"]
[null,null,null,"Average household size",null,{"$f":"F22/F23","v":{"$error":"#DIV/0!"}},null,"Persons"]
[{"$nulls":4},"Total population",null,null,"Persons"]
[{"$nulls":4},"Number of households",null,null,"Households"]
[null,"Actual number of people receiving new connections (over two years)",{"$nulls":5},"Persons"]
[null,"Security margin",null,null,null,0.2,0.2,"%"]
[]
[null,"Calculated number of new access created",null,null,null,{"$f":"F9*1000000*(1-F10)*F12/F15*F21","v":{"$error":"#DIV/0!"}},{"$f":"G9*(1-G10)*G18/G14","v":{"$error":"#DIV/0!"}},"Persons"]
[null,"Access created after plausibility check",null,null,null,{"$f":"IF(F27>F24,F24,F27)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G27>G24,G24,G27)","v":{"$error":"#DIV/0!"}},"Persons"]
[null,"Access created after consideration of financing share",null,null,null,{"$f":"F28*F11","v":{"$error":"#DIV/0!"}},{"$f":"G28*G11","v":{"$error":"#DIV/0!"}},"Persons"]
[null,"Access created after consideration of security margin",null,null,null,{"$f":"F29*(1-F25)","v":{"$error":"#DIV/0!"}},{"$f":"G29*(1-G25)","v":{"$error":"#DIV/0!"}},"Persons"]
[null,"Electrification rate after the intervention",null,null,null,{"$f":"(F18+F30)/F19","v":{"$error":"#DIV/0!"}},{"$f":"(G18+G30)/G19","v":{"$error":"#DIV/0!"}},"%"]
[null,"Remaining electricity not used for new access",null,null,null,{"$f":"(F9*(1-F10)*F12*F11)-((F30/F21*F15)/(1-F25)/1000000)","v":{"$error":"#DIV/0!"}},{"$f":"(G9*(1-G10)*G12*G11)-((G30/G21*G15)/(1-G25)/1000000)","v":{"$error":"#DIV/0!"}},"GWh/a"]
[]
[null,"Increase in annual average household consumption",null,null,null,{"$f":"(F32*1000000)/(F17+F30/F21)","v":{"$error":"#DIV/0!"}},{"$f":"(G32*1000000)/(G17+G30/G21)","v":{"$error":"#DIV/0!"}},"kWh/a"]
[null,"Average annual household consumption before the intervention",null,null,null,{"$f":"F15","v":{"$error":"#DIV/0!"}},{"$f":"G15","v":0},"kWh/a"]
[null,"Tier before the intervention",null,null,null,{"$f":"IF(F15<3,0,IF(F15<67,1,IF(F15<322,2,IF(F15<1319,3,IF(F15<2122,4,5)))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(G15<3,0,IF(G15<67,1,IF(G15<322,2,IF(G15<1319,3,IF(G15<2122,4,5)))))","v":0}]
[null,"Acess index before the intervention",null,null,null,{"$f":"F20*F36","v":{"$error":"#DIV/0!"}},{"$f":"G20*G36","v":0}]
[null,"Average annual household consumption after the intervention",null,null,null,{"$f":"F35+F34","v":{"$error":"#DIV/0!"}},{"$f":"G35+G34","v":{"$error":"#DIV/0!"}},"kWh/a"]
[null,"Tier after the intervention",null,null,null,{"$f":"IF(F38<3,0,IF(F38<67,1,IF(F38<322,2,IF(F38<1319,3,IF(F38<2122,4,5)))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(G38<3,0,IF(G38<67,1,IF(G38<322,2,IF(G38<1319,3,IF(G38<2122,4,5)))))","v":{"$error":"#DIV/0!"}}]
[null,"Acess index after the intervention",null,null,null,{"$f":"F31*F39","v":{"$error":"#DIV/0!"}},{"$f":"G31*G39","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Additional Information"]
[null,null,"People without access before the intervention",null,null,{"$f":"F19*(1-F20)","v":0},{"$f":"G19*(1-G20)","v":0},"Persons"]
[null,null,"Per-capita household consumption before the intervention",null,null,{"$f":"F15/F21","v":{"$error":"#DIV/0!"}},{"$f":"G15/G21","v":{"$error":"#DIV/0!"}},"kWh/a"]
[null,null,"Per-capita total consumption before the intervention",null,null,{"$f":"F14*1000000/F19","v":{"$error":"#DIV/0!"}},{"$f":"G14*1000000/G19","v":{"$error":"#DIV/0!"}},"kWh/a"]