Key Post Spreadsheet for Calculating Electricity Bills

mathepac

Frequent Poster
Messages
6,873
Speaking to friends, tracking electricity use and calculating bills in advance seems like a black art to them. Reading posts on AAM over the years electricity bills seem to have proven problematic on a regular basis.

Below is a link to a simple Microsoft Excel spreadsheet that helps track your electricity usage in units and in money terms and calculates the bills based on currently published ESB rates.

To make the spreadsheet work, all you need do is type in two numbers and two dates.

  • Under the blue heading "Last Reading" (this appears on your last bill) type in your last meter reading. The cell currently displays "20789".
  • Under the next blue heading labelled "Current Reading" type in your current meter reading. Type this into the cell that currently displays "21441".
Next type in two dates.

  • Type the date of your last meter reading, again from your last bill, into the cell that currently displays "19-Jul-2017" You can use "date shorthand" when typing e.g. typing "19/7/17" will display as "6-Jan-2012".
  • Type the date of your current reading (or to-day's date if you want to do a "between readings estimate" of your usage) into the cell that displays "2-Sep-2017".
If there was a rounding credit done on your last bill, type this into the row labelled "Credit or Debit from last Bill" where "-0.31" appears. (To create a minus number, type the "-" first then ".31". Watch out for that decimal point)

That's it. The Balance Due is displayed in the row labelled "Balance Due (if no SW Credits)" or if you are credited with units etc by the Dept for Social Protection's Household Benefits Package, the amount you pay is displayed in the row labelled "Net Bill to Pay (if SW Credits apply)"

If you have any issues, problems or spot mistakes or have ideas to improve this little spreadsheet or my instructions for using it, please post in this thread. Do not PM me as the idea of Askaboutmoney.com is that we all learn, so with Brendan's permission, I will not be responding to PMs about the spreadsheet.

Aha, they cry, what about the bit at the end? That's for the next two-monthly bill, to make it easy to enter the last bill's information onto the current one, and I've duplicated the sheet to give another 4 month's worth of bills (two billing cycles) in the workbook.

To download the spreadsheet, click here.

For the technically minded, the spreadsheet will work with all versions of Excel / Microsoft Office back to 1997 and up to Office for Mac 2016 / Windows Office 2010.

It has also been tested and works with:
  • IBM's Symphony
  • NeoOffice
  • LibreOffice
  • OpenOffice
 
Last edited:

gipimann

Frequent Poster
Messages
4,761
Some information on the Household Benefits Package, which includes the electricity allowance, often referred to as the "free electricity".

Allowance:

If the SW customer is with Electric Ireland (formerly ESB), the allowance is 1800 units per year (300 per 2-month bill), plus the standing charge, the PSO (public service obligation) levy, and VAT on the levy.

If the SW customer is not with Electric Ireland, then the cash equivalent of the above allowance is paid directly to the customer and not to the utility company.

Qualifying Criteria:

(A) Age over 70 or
(B) In receipt of Carer's Allowance or
(C) Age 66-70 and in receipt of one of the following:
- State Pension (Contributory or Non-Contributory)
- Widows/Widowers/Surviving Civil Partners Pension (Contributory)
- Garda Widow's Pension
- Equivalent Social Security Pension from abroad or
(D) Age 66-70 and satisfy a Means Test or
(E) Age under 66 and in receipt of one of the following:
- Invalidity Pension
- Blind Pension
- Disability Allowance
- Incapacity Supplement with Disablement Pension (at least 12 mths)
- Equivalent Social Security Pension from abroad

For conditions C, D and E above, the customer must live alone or with certain excepted persons (generally an adult dependant/qualified adult, children, a carer or caree).

Link to the Household Benefits information on SW website:

http://www.welfare.ie/EN/Schemes/HouseholdBenefits/Pages/hb.aspx
 

mathepac

Frequent Poster
Messages
6,873
I've just posted V2 which calculates daily and weekly electricity usage in units and in financial terms, making it a bit easier to see the effects of reduced usage on bills.
 

mathepac

Frequent Poster
Messages
6,873
Thanks, but just to sound a note of caution. Watch out for the rate changes as of 1-Dec-2012 and the change in the way credits from the Household Benefits Package are applied in 2013, cash instead of units for ESB. I'll update both elements in the New Year.
 

mathepac

Frequent Poster
Messages
6,873
I've updated the spread-sheet to reflect the ESB Electric Ireland electricity rate-changes from last year and the change in SW credits for this year.

A note of caution: I have been unable to access any information about how unused or excess credits are brought forward (or is that carried forward?) so the spread-sheet is still incomplete.
 

mathepac

Frequent Poster
Messages
6,873
Changes to the spreadsheet:

To make the spreadsheet work, all you need do is type in two numbers and two dates.

  • Under the blue heading "Last Meter Rdng" (this appears on your last bill) type in your last meter reading. The cell currently displays "24462".
  • Under the next blue heading labelled "Current Meter Rdng" type in your current meter reading. Type this into the cell that currently displays "24750".

I have updated the spreadsheet to calculate:

  • Average Weekly Electricity usage in both units and money terms
  • Average Daily Electricity usage in both units and money terms and the next
  • Projected Bill at Current Run Rates (Note: both the date and the money amount shown here are ESTIMATES. Please don't panic if your actual bill is different.)
 
Last edited:

mathepac

Frequent Poster
Messages
6,873
Update 6 June 2017

Two additional lines inserted to allow for rate changes to "Units Used" or "Standing Charge" in the middle of a billing period.
 
Top