Assessing Grid Affordability for Universal Electricity Access in Sub-Saharan Africa

Average_affordability_by_country.xlsx: This dataset contains the average country-level household affordability results for each energy tier. The affordability results are calculated based on the methodology described in the paper, where country-specific income distributions are constructed using population, GDP per capita, and the Gini index, and compared with monthly residential electricity bills at different MTF-based energy tiers. The values in this dataset represent the average affordability across all population percentiles for each country under each energy tier. Additional details are available in the Methods and Results sections of the paper and the associated GitHub repository.

Electricity_Tariff_Calculator.xlsx: This database includes the latest residential electricity tariffs for 48 Sub-Saharan African (SSA) countries and estimates monthly residential electricity bills based on the Multi-Tier Framework (MTF).

Exchange_rate.xls: This file contains country-level exchange rate data sourced from the World Bank. For countries where World Bank data were unavailable, alternative data sources were used, as detailed in the paper’s Data Availability section.

Gini index.xlsx: This file contains country-level Gini index data sourced from the World Bank. For countries where World Bank data were unavailable, alternative data sources were used, as detailed in the paper’s Data Availability section.

GNI per capita 2023.xlsx: This file contains country-level GNI per capita data sourced from the World Bank. For countries where World Bank data were unavailable, alternative sources were used, as detailed in the paper’s Data Availability section.

Population.xlsx: This file contains country population data for 2024 sourced from the World Bank.

Residential_Electricity_Demand.xlsx: This dataset compiles and estimates actual residential electricity consumption across SSA countries as a proxy for electricity demand. The International Energy Agency (IEA) provides total residential electricity consumption data for 32 countries. For the remaining 16 countries where IEA data were unavailable, per capita electricity consumption data were sourced from Index Mundi. Further details are provided in the Methods section of the paper. This dataset supports the analysis presented in the “Affordability vs. Residential Electricity Demand” section of the Results.

SSA_Tariff_Documents.zip: This archive contains the original tariff structure documents for each country used in the analysis.

Summary_Electricity_Bills.xlsx: This dataset contains the calculated monthly residential electricity bills for each tier across 48 SSA countries, standardised to 2024 US dollars.

UPNEAT(World Bank)-Net profit margin.xlsx: This dataset provides proxy indicators of power utility financial performance for each country. Detailed calculation methods are described in the paper’s Data Availability section.