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?