'I've kept a spreadsheet of fuel prices for 16 years'

Rebecca Cook is holding a laptop computer with a spreadsheet of fuel costs collected over time. She is wearing glasses, has medium length grey hair and is wearing a dark top with white flowers on it

Petrol prices are now at their highest level since November 2022 - and the ups and downs of fuel hikes are a familiar subject of fascination for Rebecca Cook.

The tearoom owner from York has kept a spreadsheet of what she has paid to fill her tank for the past 16 years, and can track global market shocks such as the Covid lockdowns, the war in Ukraine and recent unrest in Iran.

"It's interesting how quickly prices can shoot up (in the UK)," she says.

"I've looked back at when the Covid lockdown occurred, and the war in Ukraine and noticed how quickly these things happen.

"Until you actually see the spreadsheet and see what you're adding, you don't always clock whether it's going up or down."

The decision to keep data logging how much she was paying for fuel initially began as part of her job for a marketing company in 2010.

She found it interesting so she just kept doing it, and now can't imagine stopping.

Rebecca admits she does not bother keeping track of any other purchases such as food shopping or household bills.

"I don't log anything else, it's just a habit. I fill up, I get a receipt and log it," she says.

A grey Apple Macbook showing a Microsoft Excel spreadsheet

Rebecca's spreadsheet includes the dates of purchase, how much it cost per litre, how much fuel she bought and the total cost.

She says she uses a variety of petrol stations in York and North Yorkshire to purchase her fuel, but most often fills up at Tesco in Clifton Moor.

When she bought her Renault Scenic car in 2015, diesel cost 97p per litre.

A quick examination of Rebecca's records shows times when the price per litre has doubled.

Since 2010, major events have been cited as reasons for causing spikes to fuel costs for motorists in the UK, most recently the conflict in the Gulf and Russia's ongoing war in Ukraine.

Rebecca continues to fill up on a regular basis for commuting to her tearoom in Easingwold and has recently changed to a hybrid vehicle.

She says a friend's husband also tracks the costs of running his electric car.

"If you go full EV, how do you calculate? I guess there's a point to doing that, but I won't be for years as I've just bought a new car."

Her unusual hobby has only just become known to her friends.

"My best friend now knows I log my costs, but I don't think she did before. She found out after an interview I did."

She admits that despite keeping an extensive log of her purchases she is not sure if anyone would find it useful, but would happily share the data with them.

"It's just the miles on my car and the prices," she says.

Get in touch

Listen to highlights from North Yorkshire on BBC Sounds, catch up with the latest episode of Look North.

Original source 'I've kept a spreadsheet of fuel prices for 16 years'

Back to home