We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Bill Calculator

timbozy
timbozy Posts: 5 Forumite
in Energy
Hi, I've been trying to work out my energy bills and get my finances in order and in the process ended up making a handy spreadsheet which I would like to share with you all.

I've only just finished tidying it all up and there's probably quite a few bugs in it so please test it to destruction and post your comments

http://www.!!!!!!/file/73112449/2c5b7613/bill_calculator2.html



Hope you like it


Tim

Comments

  • Mine's_a_guinness
    Mine's_a_guinness Posts: 123 Forumite
    Looks really good, although I haven't got all the information I need to use it to hand yet. How do I know if I have a metric or imperial meter, or will it say on the meter itself? I've got economy 7, is it possible to account for that on the spreadsheet?
  • timbozy
    timbozy Posts: 5 Forumite
    Mine just says cubic feet on the meter.

    Could be a bit of a minefield incorporating economy 7 but I shall certainly have a play with it.

    btw I've just updated the spreadsheet, there was an error in one of the formulae.
  • JCB2020
    JCB2020 Posts: 143 Forumite
    Feet is an imperial measure and should be converted with a factor of 2.83.

    Good start, however I suspect there are a lot more variables.

    Such as the units at the higher rate each quater.
    My summer quarter only had 1 unit ,31 kWh as we where away for most of it.
  • filmnoir
    filmnoir Posts: 150 Forumite
    As highlighted by JCB2020 CuFt or Cubic Feet need to be multiplied by factor of 2.83 to convert to Meters Cubed or M3. It is shown on the meter and easy to identify. After taking todays read form yesterdays multiply by 2.83 then by the CV then CF and divide by 3.6 to get the kWh.

    Also ensure you read you meter correctly when processing through the calculator. Always read black or white dials and no red on imperial meters. Otherwise your reading 10's or 1's of cubic feet. You always read up to and including100 cubic feet dial on imperial meters.
    12345xx

    Also if working out your potential invoice before the invoice arives note that calorific value may change (quality of gas) , however the correction factor 1.02264 is set for domestic meters. (Height above sea level, average UK temperature.)

    I have one some where for Prime and Sub meters, it clalculates who used what in kWh espially when ones Metric and ones Cubic feet. Ill post it when I find what I did with it :)

    Common mistakes for Gas Suppliers is charging Meteric for Imperial and vice versa or reading the dials incorrectly on an imperial meter and being a factor of 10 out.
    "Self trained industry expert who has worked in Electricty Distribution, Electricity & Gas Supply and currently works as an independent consultant in industry processes to particapants in the industry" :eek:
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 351.7K Banking & Borrowing
  • 253.4K Reduce Debt & Boost Income
  • 454K Spending & Discounts
  • 244.7K Work, Benefits & Business
  • 600.1K Mortgages, Homes & Bills
  • 177.3K Life & Family
  • 258.3K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture