There is a critical piece of info missing from this. That is MWh used per month. These are 2021 data. Using this will allow you to get to electrical cost per person per month compared to income.
Hopefully I did the math right, if this-> =(E2*C2)/(B2*12)*100 is wrong as a formula for calculating energy cost as a percentage of net income, please disregard this data.
The link you sent didn’t have data for all the countries in my original list, so I supplemented with 2014 data (in yellow cells) from worldpopulationreview.com/…
Wow so for some of the countries the cost is almost equal to the average income? Geez, I thought they’d be better off. Thank you for this excellent work!
Decided to do spreadsheets to make this easily readable for everyone, sorted by cost of a MWh/average net income:
Sources: Hellenic Regulatory Authority for Energy, Wikipedia
There is a critical piece of info missing from this. That is MWh used per month. These are 2021 data. Using this will allow you to get to electrical cost per person per month compared to income.
Hopefully I did the math right, if this->
=(E2*C2)/(B2*12)*100is wrong as a formula for calculating energy cost as a percentage of net income, please disregard this data.The link you sent didn’t have data for all the countries in my original list, so I supplemented with 2014 data (in yellow cells) from worldpopulationreview.com/…
Nice work. The formula is absolutely right. Crazy that some need to spend a full third of their take home pay on electricity.
Wow so for some of the countries the cost is almost equal to the average income? Geez, I thought they’d be better off. Thank you for this excellent work!