Create an Excel file for electricity costs?

Hello everyone,

I'm currently in the process of creating an Excel tool.

The aim of the tool is to allow me to always enter my current meter reading and then immediately see what I currently have to pay.

Anyone have an idea how I can do it?

I've already started partially with it (see photo).

LG and thanks

(1 votes)
Loading...

Similar Posts

Subscribe
Notify of
1 Answer
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
daCypher
1 year ago

To explain that would be a little too extensive. I used to think about some adjustments and formulas.

The Excel file can be found here: Electricity costs Excel

The column “Saldo” is virtually your “energy account balance”. So if there’s a positive value, you’ll get it back and if there’s a negative value, you’ll have to repay it.

I just took over the values in your table. Unfortunately, I couldn’t sort out what’s next to the right because the date between the first and second lines would have to be, but the counter reading between the second and third lines would have to be. Also, Excel cannot handle price changes