Renewables: "talking 'bout my generation"

sly_dog_jonah

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:

[Anorak hat]
Export payments are separate to FIT payments, so have to be calculated independently on a statement. For example, you can opt not to receive export payments at all, although quite why you would want to I don't know.

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/]

sly_dog_jonah

jackieblack wrote: »

What Indian Summer?

Just checked wikipedia... I guess September hasn't been very warm, but on the back of a poor summer this rings quite true:

In the United Kingdom an Indian summer is often used to describe warm weather that comes later in the year, after unusually cool summer months.

Where's that MET office anomaly chart when you need it?

Oscargrouch

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/]

Thank you for that major info; if you don't mind, I will PM you for more info on what formula to use....Thank you..:)

jackieblack

diode wrote: »

jackieblack we are having an Indian summer. (It is the monsoon season).

:rotfl:

sly_dog_jonah

A 10.4kWh to start the month off and today's not looking too bad either in Cider country. PVGIS Classic estimate is 6.39kWh/day or 198kWh for October (96 less than Sept) so we're off to a good start.

jackieblack

sly_dog_jonah wrote: »

A 10.4kWh to start the month off and today's not looking too bad either in Cider country.

I hope that weather comes my way - 1kWh yesterday, pathetic

Oscargrouch

5.8 kWh today, not too bad considering the cloud cover for most of the day..:cool:

Oscargrouch

Being done on my Generation payment:-

Last year; November, meter was on 33151.
End of Sept 2012 was on 34888 so imported to date 1733 kWh
Fed in 2281.7 to date, so I am only using 24% of what I generate, yet it's assumed I use 50%! Skanked Again :mad:
Roll out smart meters....quick; for the extra pittance. :beer:

[Deleted User]

14.1 kWh today though still ticking over at 26w or something like that.

sly_dog_jonah

9kWh yesterday & 13.9kWh today, well above the PVGIS target of 6.4kWh/day.