# Checking Bulb calculations on Bill

Trying to update the pricing so I get accurate costings on my spreadsheet.
Gas Sept sept-18 Bulb…

Read start 9418 end 9294 Units used 124
Energy 1381 kWh @ 2.73 =£37.67

I calculate that as £37.70 using Bulbs figures and not £37.67, I also calculate the kWH as 1380.79 not 1381.
Standing charge £7.25

Fuel discount -£1.21
Cost of gas £43.71
VAT £2.19
Total £45.90

I had this working accurately before the Aug price rise but had to spend some time working out what was rounded up and what down and how many decimal points Bulb used when calculating. To save me doing this again would Bulb please advise on what is rounded up / down and what figures are used to how many decimal points in order to calculate the Bill.

@scudo

I haven’t carried out a search of the forum but there was a very similar discussion possibly about two months ago, which received a response from Bulb (can’t remember the details).

@scudo

I haven’t carried out a search of the forum but there was a very similar discussion possibly about two months ago, which received a response from Bulb (can’t remember the details).

Check this out: http://community.bulb.co.uk/discussion/comment/18694

Yes that is the same issue I have with the decimal points, I did query this when I joined but eventually fudged the figures like Zac to get a match.
If Bulb are going to use 4 decimal points then I would prefer this listed on all calculations, then of course we need to know if any are rounded up or down or not at all. It is only a few pence but is frustrating when you cant get the figures to match.

@scudo I am afraid this is an issue with the amount of significant figures we are quoting. You can see your full rates through this link by putting in your postcode: Tariff | Bulb

OK I have that now, are there any figures that are rounded when compiling the monthly statement?

@scudo No figures are rounded in the calculations until the final cost.

Ok thanks for the info.

If you do a price comparison on the website below prices for all suppliers seem to be listed to 3 decimal places if you click the blue “more info” tab.
https://energylinx.co.uk/

I had this working accurately before the Aug price rise but had to spend some time working out what was rounded up and what down and how many decimal points Bulb used when calculating.

Ah, so it’s not just me then.
@“DanP at Bulb” Can you please provide the ex-VAT unit prices for West Midlands, to however many decimal places as are used in calculating the bill?

All regions rates for a 1-rate electricity meter, excluding VAT. @198kHz @scudo

Many thanks @“DanP at Bulb”
And the gas?

DanP at Bulb November 5, 2018 9:53AM Flag @scudo I am afraid this is an issue with the amount of significant figures we are quoting. You can see your full rates through this link by putting in your postcode: https://bulb.co.uk/tariff/

@scudo Yes, the VAT inc prices. For spreadsheet purposes, I’d like to know how many decimal places in the ex-VAT price.

DanP at Bulb November 5, 2018 9:53AM Flag I am afraid this is an issue with the amount of significant figures we are quoting.
I dont quite understand the issue.
@scudo Yes, the VAT inc prices. For spreadsheet purposes, I'd like to know how many decimal places in the ex-VAT price.
Its frustrating as the prices are vat and then non vat and then 3 decimal points and then just 2 decimal points depending on where the figures are sourced, they are all over the place. Its only a few pence but when you think you have got the formulas correct on the spreadsheet they dont balance up with Bulbs calculations.

The one that surprises me is that the actual figures they issue on the monthly statement are actually incorrect and don’t add up.
Bulb has on statement… Energy 1381 kWh @ 2.73 =£37.67 that actually equates to £37.70.

The one that surprises me is that the actual figures they issue on the monthly statement are actually incorrect and don’t add up.
Bulb has on statement… Energy 1381 kWh @ 2.73 =£37.67 that actually equates to £37.70.

This point is the one raised by another customer some time ago, see http://community.bulb.co.uk/discussion/comment/18694.

I would guess that the unit cost in your example to three decimal places is 2.728p, which means energy 1381 @2.728 = £37.673 to three decimal places or 37.67 to two decimal places.

As you know I also keep a spreadsheet of my energy usage and costs, and use the unit costs shown on my statement to arrive at my own bill calculations. This sometimes leads to my final costs not being the same as on the statement, nominally out by a couple of pence. Where this happens I have to overwrite the equation calculated costs by the figures shown on my statement.

If Bulb showed the actual unit costs to the correct number of places then this problem as you have already mentioned would alleviate any difference between Bulb total costs and customer calculated costs.

Its frustrating as the prices are vat and then non vat and then 3 decimal points and then just 2 decimal points depending on where the figures are sourced, they are all over the place. Its only a few pence but when you think you have got the formulas correct on the spreadsheet they dont balance up with Bulbs calculations.

The one that surprises me is that the actual figures they issue on the monthly statement are actually incorrect and don’t add up.

Quite so - and it’s hard to challenge if you don’t know precisely what figure they’re using.
@“DanP at Bulb” has kindly provided the info I wanted for electric - just waiting for the info for gas.

And the other part to this is the kWh calculation which is rounded down or up depending on less/more than .5. Although easily sorted on spreadsheet when its known they do this.

@198kHz And the gas:

Let me know if you need anything else

Thanks @“DanP at Bulb” - I appreciate the information.
Electric looks fine, but the Midlands ex-VAT gas rate of 3·752 equates to a VAT inclusive price of 3·9396.
3·751 ex-VAT is closer, giving a VAT inclusive price of 3·93855.
3·750 ex-VAT gives a VAT inclusive price of 3·9375, which to three decimal places matches your published rate of 3·938.