Gizmos Freeware Reviews  

Go Back   Gizmo's Freeware Forum > Debating Chamber > ChitChat

Reply
 
Thread Tools Display Modes
Old 06. Sep 2013, 11:02 PM   #1 (permalink)
Foundation Editor
 
tony's Avatar
 
Join Date: Apr 2008
Location: Lincolnshire (unfortunately)
Posts: 153
Default 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 
tony is offline   Reply With Quote
Old 07. Sep 2013, 12:15 AM   #2 (permalink)
Senior Member
 
bo.elam's Avatar
 
Join Date: Nov 2009
Posts: 1,714
Default

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.

Bo
bo.elam is offline   Reply With Quote
Old 07. Sep 2013, 02:08 AM   #3 (permalink)
Maestro di Search
 
Jojo Yee's Avatar
 
Join Date: Jul 2008
Posts: 7,835
Default

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

https://docs.google.com/spreadsheet/...kE&usp=sharing

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.
Jojo Yee is offline   Reply With Quote
Old 07. Sep 2013, 03:50 AM   #4 (permalink)
Senior Member
 
Join Date: Jul 2010
Location: New Zealand
Posts: 1,741
Default

Quote:
Originally Posted by bo.elam View Post
Hi Tony, I believe 3.785 Liters is a gallon.
...
Bo
Bo, the US gallon and the Imperial gallon are different volumes. Tony's conversion is correct for England, Australia, NZ, etc.

http://en.wikipedia.org/wiki/Gallon
__________________
Better to light a candle ... than to curse the darkness.

Last edited by Remah; 07. Sep 2013 at 03:51 AM. Reason: Add link
Remah is offline   Reply With Quote
Old 07. Sep 2013, 05:06 AM   #5 (permalink)
Senior Member
 
bo.elam's Avatar
 
Join Date: Nov 2009
Posts: 1,714
Default

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.

Bo
bo.elam is offline   Reply With Quote
Old 07. Sep 2013, 05:52 AM   #6 (permalink)
Senior Member
 
Join Date: Jul 2010
Location: New Zealand
Posts: 1,741
Default

Bo

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.

Quote:
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.]

Remah
__________________
Better to light a candle ... than to curse the darkness.

Last edited by Remah; 07. Sep 2013 at 05:54 AM. Reason: Lightbulb moment
Remah is offline   Reply With Quote
Old 07. Sep 2013, 06:13 AM   #7 (permalink)
Maestro di Search
 
Jojo Yee's Avatar
 
Join Date: Jul 2008
Posts: 7,835
Default

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.
Jojo Yee is offline   Reply With Quote
Old 07. Sep 2013, 07:00 AM   #8 (permalink)
Senior Member
 
bo.elam's Avatar
 
Join Date: Nov 2009
Posts: 1,714
Default

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...).

Bo
bo.elam is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT +1. The time now is 04:54 PM.


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