Speed, Distance, Time Left, Petrol Consumption

10 09 2013


Average Speed

This is not complicated but it’s what I did as I was travelling from A to B on a long bus journey: I set up a spreadsheet to deal with the following.

Although there should have been nothing to worry about, I wanted to be sure that I would make my connection at my destination.

So I wanted to know how fast we were going. There were kilometre posts on the road side for most of the journey and my phone has a stopwatch utility. I found the speed of the bus by combining the distance travelled, one kilometre; and time taken to travel it. I could check our speed whenever I wanted to now!

Then I wanted to know how long it would take us at the last recorded speed to get to our destination B. All I needed to know was the distance to B and then use my knowledge of speed to estimate the time remaining. I could find the distance to B every now and again from the sign posts on the road that told us!

That’s all I really needed to know but then I enhanced my spreadsheet by adding these calculations too:

Time to cover one kilometre:

In minutes
In seconds

I considered creating a table to record all of the speeds I found together with distances remaining etc but decided that was academic!

Finally, this spreadsheet can cope with kilometres or miles … and can convert from one to the other.

Petrol Consumption

As I bought a new car recently I decided I would keep a record of all of the petrol I buy for it. I have also kept a record of the kilometres driven. I record the litres of petrol bought, odometer reading at the time I bought the petrol, cost of petrol, type of petrol: my car can use either E20 or gasohol 91 petrol.

My very simple spreadsheet shows all of the above data and the calculation of kilometres driven per litre of petrol and average cost per litre.

At this stage there are very few data points and the consumption averages have yet to settle down.

Duncan Williamson

3 Responses to “Speed, Distance, Time Left, Petrol Consumption”

  1. m88 Says:

    My brother recommended I might like this website.
    He used to be totally right. This post truly made my day.
    You cann’t believe just how so much time I had spent for this info!
    Thank you!

  2. black hoodie Says:

    Thanks a lot for sharing this with all folks you actually understand
    what you’re talking approximately! Bookmarked.

    Kindly additionally talk over with my site =). We will have a link change contract
    among us


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: