PC-Active 328 contains an interesting reader’s tip from mr. Albert Bergers. In it he looks at his energy bill and shows how to check the prices of the energy contract via an Excel file that you will find with this article.
Albert Bergers
Recently, the energy market has gone wild and many people are looking critically at their energy consumption. However, some are less critical of the supplier and its price. Although: a commonly used strategy is to look for the cheapest contract, but is that the right one? For the past two days I have thrown myself into my own energy contract with the question of how the supplier now arrives at those invoice amounts. That led to an Excel file in which I did go to extremes.
Conclusions:
(1) It is certainly useful to know what is included in the energy price you pay and to check whether this is in line with the total price that the supplier proposes to you.
(2) It is also very advisable to keep a finger on the pulse of the supplier’s monthly billing statements and your actual consumption and the correct costs.
(3) Don’t believe a supplier if he gives an ‘average’ total price for electricity and gas (in my case I pay almost 400 euros too much after 8 months!). The total price turns out not to be the correct average price, but a safe (read higher) price than the actual average price.
(4) Not netting monthly in this overview also painfully exposes what you are paying wrongly.
So to make the ‘burden of proof’ visible, I made an Excel file. In the first tab Explanation you read, among other things, that the sheet is protected and only the white cells can be filled with data. The sheet is also made for a contract duration of one year with a permanent contract and the start date can be chosen yourself.
Download the Energy Calculation Excel file here.