So you can check if you are paying more or less with the new electricity bill

Just today marks a week since the new electricity bill came into effect. Since days before, and since then, there is a lot of controversy on social networks about the changes. It should be remembered that for those households that were in the regulated market, with a PVPC or TUR rate, It is passed from one or two to three periods:






10:00 - 14:00

18:00 - 22: 00h

Full morning and afternoon.



08:00 am - 10: 00h

14:00 - 18: 00h

22:00 - 24: 00h

First thing in the morning, noon and night



00:00 - 08: 00h

24h on weekends and holidays

Early morning and holidays.

But, in addition, the change has coincided with the highest prices that are remembered for kWh. So to see how it affected me, I decided to use my household consumption data in a simulator that already has the changes integrated. So I have been able to see if (for the moment, as this changes every day), the changes benefit me or not.

How to obtain our consumption data to be able to use them in the simulator

The new bill affects each household very unevenlyBy habits and because maybe before had a single period and now has three and a price per kWh considerably higher than a month ago. Therefore, although we can get an approximate idea without this, we need to obtain the electricity consumption data in .csv files provided by our distributor (not to be confused with marketer).

To check which distributor works for you if it is not one of the big ones, it is best to consult the electricity bill. To have an approach without consultation, you can look at the map of the tweet.

To register in the one that corresponds to us we will have to go to their web pages, which are these:

The normal thing is that for the record They ask you for data of the contract holder such as address, ID, etc. Once you have submitted all documentation must validate. At that time, we can finally access the data of our consumption. In my case, since I only have access to one house with Endesa Distribución, I will explain how to obtain the daily consumption data with this distributor, but all of them usually offer export to .csv files, which are the ones we will work with.


Web distributor Endesa have signed once.

Once we have started the session on the website of our distributor, we will have to look for an option similar to that of 'Your consumption' on the top web. By clicking on it, it explains that "here you can view the graphical representation of your load curves for the selected period. You can also download consumption data and, where appropriate, self-consumed energy or discharged to the grid".

How will the new electricity bill affect you (and how not) with discriminated hours

In the following image, we can see how to define the days for which we want to obtain consumption data. In the case of Endesa Distribución, I can see the consumption up to the day before.

Light Simulator

As we will see below, if we go to the bottom of the web, we have the option of 'Download .CSV consumptions'of the days we have chosen. It is important to check the option "Compatible with FacturaLuz"

Get Csv

How to use the Electricity Bill Simulator

Using the downloaded .csv, we can now deliver our data to the great Electricity Bill Simulator website, which in my case has always nailed my bills even before Endesa Energía XXI sent them to me.

Its developer has communicated that it already takes into account the data of the new invoice and the different periods: "The calculation is already prepared for the new types of tariffs that have arisen when the 2 powers appear". "The PVPC 2.0DHA rate has been reactivated in the simulator, and although they are no longer publishing their prices, it can be deducted from the 2.0TD. This will allow us to compare the new rate with the old one," reads the Web.

With the .csv file and the data of our contract, as contracted power, as well as possible discounts, and indicating the date of the invoice or period to study (this data has to be in the .csv), like this:

New Simulator

And this is the calculation that the simulator returns:

Light calculation

As we can see, with "my current plan", and that of many users from day 1, the new PVPC - 2.0TD, which is the one that contemplates the three periods, I pay 14 cents more than what I would have paid with the old plan, the PVPC 2.0DHA, of having had it these days with hourly discrimination of two periods.

The difference is not greater because although the three periods do not benefit me, it does benefit me that I pay less for the contracted power (0.88 euros less, first column). With the new June invoice, I pay 13 cents more than if I had continued with the old plan, and up to € 1 more than current Iberdrola plans.

Yes indeed, this is counting prices, which have risen sharply in 2021, having nothing to do with the new invoice. With this same consumption, in 2020 he would have paid considerably less. But not only because of the new bill, but because, I repeat, the June prices, which are an anomaly, but they have been since January.

© Best Of Giz India. All rights reserved. Distributed by . Distributed by