** updated version ** electric bills calculator for holiday homes

BeeKeeper


Joined: 29/09/2009
Posts: 137

Message Posted:
27/07/2010 13:41

If you ever have people stay in a house in Northern Cyprus and want to charge them for the electricity they have used during their stay, you may find this spreadsheet useful. Simply fill in the blue boxes (days in month, no. of days in day, electricitiy meter reading on arrival and electricity meter reading on departure) and it will work out what I think is a reasonably accurate estimate of the cost of electricity used.



It takes account of the different price bands, and calculates used pro-rata so that the cheap electricity bands are shared out fairly for all days in the month.



For a stay which spans months of different lengths, I suggest taking an average (i.e. 30+31 divided into 2 = 30.5).



You can download it at http://www.levantvillas.com/spreadsheet.htm



While I post this in good faith, I make no legal guarantees for this spreadsheet's accuracy - use at your own risk. If you can see any mistakes/room for improvement please post!

BeeKeeper


Joined: 29/09/2009
Posts: 137

Message Posted:
27/07/2010 18:02

Just editing this post to keep it near the top to try and get the message to anyone who downloaded it last night that an improved version is now out there.

kavenkoy


Joined: 10/04/2008
Posts: 1787

Message Posted:
27/07/2010 19:20

does it matter if you have energy saving light bulbs fitted ?



kav

Newboy


Joined: 21/02/2008
Posts: 80

Message Posted:
27/07/2010 19:43

Too beer kav, electric is electric.

No1Doyen


Joined: 04/07/2008
Posts: 16617

Message Posted:
27/07/2010 19:52

Beerkeeper. Works very good. thanks

BeeKeeper


Joined: 29/09/2009
Posts: 137

Message Posted:
28/07/2010 19:38

Just resaving this for a last time - if you downloaded the faulty original version of the spreadsheet you should update to V2, which was uploaded yesterday morning.

janjin



Joined: 10/04/2008
Posts: 488

Message Posted:
28/07/2010 21:32

Thanks Beekeeper

BeeKeeper


Joined: 29/09/2009
Posts: 137

Message Posted:
30/07/2010 13:30

Just resaving this in case anyone hasn't seen it - if you downloaded the faulty original version of the spreadsheet you should update to V2. It's available at http://www.levantvillas.com/spreadsheet.htm - if you find this useful you may wish to save this to your favourites because I will try to update the spreadsheet when rates change etc.