Renewables: "talking 'bout my generation"

Oscargrouch wrote: »

Here is an interesting one for all budding Anorak mathamaticians:-
When NPower worked out a payment it is 742.32 X 0.21p FIT payment = £155.8872p (Try it with a calculator)
Export is 371.16p (which is ½ of the Gen Meter reading above) at 0.032p = £ 11.87712p

They then round up FIT payment to £155.89p because the decimal after 88p above is a 7.
And they round up Export payment to £ 11.88p because the decimal after 87p above is also a 7. Finally coming up with a number of £167.77p.

What I think they should be doing, is add the two together first: which would give; £167.76432p because the decimal number after the 76p is less than 5, it should stay at £167.76p.

The reason I ask the question, is that there is no way I can get an XL spreadsheet to come up with an incorrect amount.

Todays brain teaser for you ......:rotfl:

FiT: =ROUND(0.21*742.32,2)
Export: =ROUND(0.032*742.32,2)
Total: =[Export]+[FiT]

sly_dog_jonah wrote: »

[Anorak hat]

Therefore the export payment and FIT payment have to be calculated independently, rounded appropriately (either up or to the nearest pence), then summed to give the total payment amount. You can calculate this in your own spreadsheet as follows:

FiT: =ROUND(0.21*742.32,2)
Export: =ROUND(0.032*742.32,2)
Total: =[Export]+[FiT]

That will round to the nearest pence, but you can also ROUNDDOWN or ROUNDUP if that's what your supplier does. You should also bear in mind that most suppliers round the meter reading to the nearest kWh before calculating the payout.

[Anorak hat/]