I had been searching my computer for this info and have eventually found it.
Maybe someone can point out where I am going wrong.
If the UK in 2005 produced 1,870,000 barrels of oil per day in 2005 and there are 158.7 litres of oil in a barrel then that equals 297,143,000 litres per day (1,870,000x158.9)or 105,782,908,000 litres per year (297,143,000x356) and the UK charges $1 of taxes on every litre of oil and the current exchange rate between the dollar and the Pound is 65p per dollar then that amounts to £68,758,890,200 per year (105,782,908,000x0.65) going into the UK treasury.
Isn't that considerable more than we get from the Barnett formula? Surely I've made a mistake somewhere?
http://www.eia.gov/countries/country-data.cfm?fips=UK
http://en.wikipedia.org/wiki/Barrel_(volume)
http://www.opec.org/opec_web/en/data_graphs/333.htm
http://www.x-rates.com/d/GBP/USD/graph120.html