Excell wiz needed, maybe

Welcome to the all new Geo Metro Forum. We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are features you can't use and images you can't see. Registration is simple, fast, and completely free. If you're already a member please log in to your account to access all of our features:

Join our community!

Excell wiz needed, maybe; Fuel log help.
Tweet Topic Started: Jan 21 2012, 03:43 PM (787 Views)
climbinghalfdome	Jan 21 2012, 03:43 PM Post #1
MPG OCD Posts: 366 Group: Valued Members Member #4,287 Joined: Jan 31, 2011 Location Albion IDAHO Year/Make/Model 1993 Stock XFI +13' WHEELS, +racing wheel covers.	When I bought the car from the P.O. I discovered he had kept a little spiral note book in the glove box. I saw the he recorded the odometer on each tank he bought since the car had 28 miles on it. Now the car has 162,000+ miles. On my windows phone (Like a smart phone) there is an app that calculates your MPG's. So not one to waste time I got right to it. I typed in all 572 tanks into the phone. I have an email option where I can send the logs. They look just like this in the email; Date, Odometer, Quantity, WasTankFilled, CostPerUnitFuel 9/9/2011 12:03:51 PM, 154383, 3.314, True, 4.049 9/25/2011 12:04:32 PM, 154867, 8.58, True, 3.859 10/6/2011 12:05:25 PM, 155380, 9.53, True, 4.059 10/9/2011 12:07:03 PM, 155802.7, 8.526, True, 3.9993 10/14/2011 12:08:16 PM, 156150.2, 5.818, True, 3.9 10/17/2011 12:09:39 PM, 156600, 8.404, True, 3.889 10/27/2011 12:10:50 PM, 156989.8, 7.4, True, 3.85 11/4/2011 12:12:03 PM, 157450, 8.866, True, 3.755 11/8/2011 12:12:50 PM, 157606.5, 3, True, 3.78 11/10/2011 12:14:41 PM, 158038.5, 8.365, True, 3.719 11/20/2011 12:16:51 PM, 158484.5, 8.56, True, 3.589 11/29/2011 11:58:13 AM, 159004, 10, True, 3.77 12/23/2011 11:53:14 AM, 159500, 8.335, True, 3.589 12/8/2011 11:50:31 AM, 160000, 8.7, True, 3.58 12/10/2011 11:48:35 AM, 160126, 2.47, True, 3.54 12/16/2011 11:05:38 PM, 160632, 8.24, True, 0 12/17/2011 6:44:48 PM, 160848, 4.522, True, 0 12/20/2011 8:38:24 AM, 160992, 2.9, True, 0 12/20/2011 11:25:39 PM, 161302, 5.393, True, 0 12/25/2011 2:31:01 PM, 161706, 7.162, True, 3.339 12/29/2011 4:01:30 PM, 162135, 8, True, 3.19 1/7/2012 11:44:30 PM, 162700, 10, True, 0 OK These are just 22 of the 572 logs. As you can see the first set of numbers is the date (MM/DD/YYYY) then there is the time of day I typed the long into the phone. (Don't care) Then there is the odometer reading with out comas after that is the number of gallons used to fill the tank, followed by the word "True" I guess if the tank was brought to full and lastly the price per gallon. I've only kept track of the price per gallon sometimes in my log. Here is my question. Do I really have to go back and do the math on each distance traveled between each tank then retype every one of the 527 entries. To add more insult, Ecomodder likes the date in (YYYY/MM/DD) format. What other options are there? Kevin



Coche Blanco	Jan 21 2012, 03:55 PM Post #2
Troll Certified Posts: 21,983 Group: Valued Members Member #982 Joined: Jul 15, 2009 Location North Alabama Year/Make/Model 1993 3/5	Why not just start fresh? Don't worry about the other 572 tanks.



climbinghalfdome	Jan 21 2012, 04:23 PM Post #3
MPG OCD Posts: 366 Group: Valued Members Member #4,287 Joined: Jan 31, 2011 Location Albion IDAHO Year/Make/Model 1993 Stock XFI +13' WHEELS, +racing wheel covers.	Hey Blanco, I like the newer avitar. I must say the dude next to you with the robbinhood hat wasn't as cool as he though he was. I've thought of starting fresh, but it would be super cool to see the progression of every tank of gas over the lifetime of the car. Otherwise all the effort of the P.O. was in vain. I just think if I have this oppertunity to graph the lifetime of tanks, I should do it. Kevin



billy508	Jan 21 2012, 04:54 PM Post #4
billy508 Posts: 3,383 Group: Valued Members Member #192 Joined: Nov 10, 2008 Location Pensacola Florida Year/Make/Model 93 geo metro vert, 1980 f150 truck,	You can copy and paste then save the string of numbers into wordpad and save as text. Then in excel you can open it as a csv file using commas as the separating character. From there it is just a simple formula: last time's odo minus this time's odo divided by the number of miles. If you want the excel file, send me your email address to billy508@gmail.com and I'll forward it to you. (This is Rita)



Old Man	Jan 21 2012, 04:56 PM Post #5
Posts: 9,836 Group: Valued Members Member #5,381 Joined: May 3, 2011 Location Bay Center, Washington on the Coast Year/Make/Model 1991 Geo Metro Convertible and 1990 XFI	Time and patience and then post the results. It would be neat to see the result of your efforts.



climbinghalfdome	Jan 21 2012, 05:31 PM Post #6
MPG OCD Posts: 366 Group: Valued Members Member #4,287 Joined: Jan 31, 2011 Location Albion IDAHO Year/Make/Model 1993 Stock XFI +13' WHEELS, +racing wheel covers.	billy508 Jan 21 2012, 04:54 PM email address to billy508@gmail.com and I'll forward it to you. (This is Rita) OK you asked for it. LOL My entire log is in your inbox. kevin_likes_to_climb_much@hotmail.com



billy508	Jan 21 2012, 07:26 PM Post #7
billy508 Posts: 3,383 Group: Valued Members Member #192 Joined: Nov 10, 2008 Location Pensacola Florida Year/Make/Model 93 geo metro vert, 1980 f150 truck,	Reply sent. Let me know if it works.



climbinghalfdome	Jan 21 2012, 10:00 PM Post #8
MPG OCD Posts: 366 Group: Valued Members Member #4,287 Joined: Jan 31, 2011 Location Albion IDAHO Year/Make/Model 1993 Stock XFI +13' WHEELS, +racing wheel covers.	Worked great. Because there are so many entries, I had to devide the log in half. You sent me the first half, Mile 28 to 82,990. If its not too much to ask, could you do it again for the 82,991 to preasent. You are awesome!!! Kevin



econoboxer	Jan 22 2012, 11:02 PM Post #9
I am the one on the left. Posts: 4,115 Group: Valued Members Member #4,315 Joined: Feb 3, 2011 Location Salt Lake City (Kearns), Utah Year/Make/Model 94 3/5 HB. 92 auto to manual conv. vert overbored 0.02 218/350 cam/3Tech perf.head +10 timing gear	This sounds like what I do. I write in a spiral book date, location, how many gallons, total cost. I always fill up unless otherwise noted. I calc mileage every couple of tanks, but every once in a while I will go back and recalc all the ones that hadn't been done. This lets me know how much gas I use in each vehicle. I am hyperaware of where each gallon is going.



billy508	Jan 22 2012, 11:20 PM Post #10
billy508 Posts: 3,383 Group: Valued Members Member #192 Joined: Nov 10, 2008 Location Pensacola Florida Year/Make/Model 93 geo metro vert, 1980 f150 truck,	Did you get the 2nd half? It looked interesting. Rita is very good with Excell.



climbinghalfdome	Jan 23 2012, 01:52 AM Post #11
MPG OCD Posts: 366 Group: Valued Members Member #4,287 Joined: Jan 31, 2011 Location Albion IDAHO Year/Make/Model 1993 Stock XFI +13' WHEELS, +racing wheel covers.	billy508 Jan 22 2012, 11:20 PM Did you get the 2nd half? It looked interesting. Rita is very good with Excell. You bet. I've been cranking away at data entry. Pluggin in these 527 tanks of gas is a slow process. With this spiral notebook, the owner wrote down the total cost of fuel but not the price per gallon. I'm toying with the idea of going back and making another collum for the tank cost then I could divide the tank cost with number of gallons to come up with price per gallon. It would be interesting to see the price chage over the years. But I'd bet a chart like that can be found on the net already. ecomodder keeps track of your average price per mile, so far I'm at $0.08 per mile. I like that feature! If you are super bored you can see my fuel log if you go to ecomodder and search for "climbinghalfdome". The more tanks I add the smaller the chart gets. I'm about half way done (not quite) so the chart is going to be pretty small when all the tanks are finished. Kevin



climbinghalfdome	Mar 11 2012, 04:46 PM Post #12
MPG OCD Posts: 366 Group: Valued Members Member #4,287 Joined: Jan 31, 2011 Location Albion IDAHO Year/Make/Model 1993 Stock XFI +13' WHEELS, +racing wheel covers.	Ok everyone. (not that many of you were loosing sleep) but here is the results of a month of effort. If you look at my signature, you'll see over 500 tanks of gas that I and the PO filled. Ecomodder can only fit so many tanks on their chart so I had to combine a few tanks together, but all in all its fairly accurate. I wish I had a way to make an even more accurate chart with out modifications to conform to Ecomodders web sie. Well thanks to those who helped. Kevin



1 user reading this topic (1 Guest and 0 Anonymous)


« Previous Topic · The Geo Metro Lounge · Next Topic »