Gizmo's Freeware Forum

Gizmo's Freeware Forum (
-   ChitChat (
-   -   Help please with spreadsheet (

tony 06. Sep 2013 11:02 PM

Help please with spreadsheet
Hi guys, I am hoping that someone is good at spreadsheets. When it comes to figures my mind just can't sort them out. I can do basic spread sheet stuff, but this has just gotten me beat! If you look at the last miles to the gallon, it states that my wee car has done an amazing 187 miles to the gallon! So somewhere its not right. So does anyone know what I can do to resolve this. Quite simply I take the miles I have done and change the liters to gallons. As I wanna know how the car is performing. I am on a tight budget and this helps me know how much the car needs for journeys. Hope you can assist as its driving me crazy. And the gallons are UK on USA.

Info/DetailsDateMileage at fill upLtrsConvert to GallonsMiles from last fill upMiles to GallonGeneral notes
Bought car 3004    Note Ltrs into Galls 4.54609
First fill up Tesco Boston14. November 20123160.2286.1591389524156.2  
Tesco Sleaford7. December 20123438.429.026.3835075856278.243.5810557547 
Tesco top of Lincoln14. December 20123533122.639630979694.635.8383428333 
Tesco top of Lincoln28. December 20123708163.519507972817549.722859375 
Tesco top of Lincoln23. January 20133951296.379108200724338.0930989655 
Tesco bottom of Lincoln6. February 20134113173.739477221116243.3215635294 
Tesco Boston15. February 20134238112.419661731312551.6601136364 
Tesco bottom of Lincoln20. February 2013430781.75975398646939.21002625 
Tesco Top of Lincoln11. March 20134478163.519507972817148.586336875 
Tesco Top of Lincoln22. March 20134607143.079569476212941.8889721429 
Co-Op, North Lincoln8. April 20134765163.519507972815844.89263875 
Tesco top of Lincoln17. April 20134898143.079569476213343.187855 
Tesco top of Lincoln15. May 20135186286.159138952428846.7597828571 
Tesco top of Lincoln21. May 20135328132.859600227914249.6572907692 
Tesco top of Lincoln10. June 20135675316.819046697334750.8868783871 
Tesco top of Lincoln28.June 20135938235.059292710926351.9835508696 
Tesco top of Lincoln03.July 20136054112.419661731311647.9405854545 
Morrison Lincoln08.July 20136271194.179415717721751.9211331579 
Tesco top of Lincoln26. July 20136591286.159138952432051.9553142857 
Tesco top of Lincoln2. August 20136779153.299538724518856.9776613333 
Tesco top of Lincoln16.August 201137007214.619354214322849.3575485714 
Sainsbury, Lincoln22. August 20137123102.19969248311652.734644 
Meanwells5. September 201374187.151.5727801253295187.565951049 

bo.elam 07. Sep 2013 12:15 AM

Hi Tony, I believe 3.785 Liters is a gallon.

According to your numbers, you have traveled 4414 miles using 425 Liters/112.32 gallons. If you divide 4414 miles into 112.32 gallons, the figure that comes up is 39.29 miles per gallon. Approximately, that's the mileage that you are getting out of your car. Not bad.


Jojo Yee 07. Sep 2013 02:08 AM

Hi Tony, I've copied your spreadsheet over and inserted some formulas.

I don't see any mistakes there. The unusual miles per gallon can possibly due to human errors in recording either mileage at fill-ups or litres for 5th Sept, or missing out a record before that date. The conversion from litre to imperial gallon is correct.

Remah 07. Sep 2013 03:50 AM


Originally Posted by bo.elam (Post 92188)
Hi Tony, I believe 3.785 Liters is a gallon.

Bo, the US gallon and the Imperial gallon are different volumes. Tony's conversion is correct for England, Australia, NZ, etc.

bo.elam 07. Sep 2013 05:06 AM

Hi Remah, Tony used the word "Liter" and mentioned USA. The word Liter is used in the US, you guys use Litre instead. In the Americas, our gallon is equal to 3.78541178 Liters. I used the conversion that I use everyday.


Remah 07. Sep 2013 05:52 AM


Spelling real English is always a challenge on a website with a US dictionary. That's why people use US spellings here.

All the destinations are Lincolnshire in the UK.


And the gallons are UK on USA.
I'm not sure what this means in the original post.

[Edit: I think it means the gallons are UK not USA.]


Jojo Yee 07. Sep 2013 06:13 AM

Mathematically either we use imperial or US gallons, we'll get the same result of unusual high mileage for 5th Sept so long as either of the conversion rates is consistently applied to all transactions.

bo.elam 07. Sep 2013 07:00 AM

The human error for Sept 5 is obvious, it can be ignored as it doesn't make any difference, the bottom line is that he is getting great mileage out of his car.

Remah, I hate assuming and never do, even when its obvious that it is safe to do so (like here, Tony is in England so he means...).:)


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.