Go Back   EcoModder Forum > EcoModding > Success Stories
Register Now
 Register Now
 

Reply  Post New Thread
 
Submit Tools LinkBack Thread Tools
Old 04-25-2012, 11:00 PM   #1 (permalink)
EcoModding Apprentice
 
Join Date: Feb 2012
Location: Florida
Posts: 105

The 'Vic - '96 Honda Civic DX
Team Honda
90 day: 39.3 mpg (US)
Thanks: 6
Thanked 18 Times in 15 Posts
iOS Numbers App fuel tracker spreadsheet

I have built a really nice spreadsheet that tracks EVERYTHING on my car. I love making spreadsheets and keeping data on everything. I built it from a very basic template in Numbers but it really tells me a lot of information. If you have Numbers for iOS I'd be happy to share it with you. Numbers is a $10 app in the app store. It isn't compatible with excel because of the way Numbers formats native spreadsheets. I believe it would work in Numbers for Mac but I haven't tested it. It works with iPhone and iPad and is how I keep track of my fuel costs at the pump. There is a data entry form which makes it extremely easy to enter the fill info and it also will sync with your iPad through iCloud. Not trying to advertise but it's a nice setup.

From the fuel data that you add in, which isn't pictured, it calculates all of the data you see here automatically. The information for the last 31 days is for the last month and adjusts the formula and title for the length of the previous month. It's set up to calculate about all of the information that I have wanted to know about my car. It updates daily, automatically. The maintenance form also tracks all costs and the two spreadsheets are linked so you can account for both maintenance and fuel costs and both for total cost. What isn't in it are insurance, registration, or purchase costs. This could be added if someone said how they would like to see it. Also, the fuel savings cell for both the last 31 days and total are based on my previous cars recorded mpg but I could configure it for your old car's consumption and even add for premium fuel vs. unleaded.


Attached Thumbnails
Click image for larger version

Name:	2012-04-25T21-40-01_1.jpg
Views:	1148
Size:	115.1 KB
ID:	10735  
__________________


Civic Build Thread
Your grammar is appreciated.

3.788 Civic CX final drive, air dam, 1st gen HCH 14" wheels and Michelin Defender 175/65R14 LRR tires
  Reply With Quote
The Following User Says Thank You to hawk2100n For This Useful Post:
graesack (04-26-2012)
Alt Today
Popular topics

Other popular topics in this forum...

   
Old 04-26-2012, 10:52 AM   #2 (permalink)
EcoModding Lurker
 
Join Date: Nov 2009
Location: Lacey, WA
Posts: 38

Pc3 - '12 Toyota Prius c 3
90 day: 49.3 mpg (US)
Thanks: 17
Thanked 5 Times in 4 Posts
Great job!
  Reply With Quote
Old 04-26-2012, 11:04 AM   #3 (permalink)
Eco-ventor
 
jakobnev's Avatar
 
Join Date: Oct 2010
Location: sweden
Posts: 1,630

Princess - '92 Mazda MX-3 GS
House of Tudor
Team Mazda
90 day: 53.54 mpg (US)

Shirubāarō (*´ω`*) - '05 Toyota Prius Executive
Team Toyota
90 day: 54.88 mpg (US)

Blue Thunder - '20 Hyundai IONIQ Trend PHEV
Team Hyundai
Plug-in Hybrids
90 day: 587.16 mpg (US)
Thanks: 74
Thanked 701 Times in 444 Posts
Send a message via MSN to jakobnev
What's distance to moon used for? Are you taking different routes depending on the current strenght of gravity?
__________________




2016: 128.75L for 1875.00km => 6.87L/100km (34.3MPG US)
2017: 209.14L for 4244.00km => 4.93L/100km (47.7MPG US)
  Reply With Quote
Old 04-26-2012, 11:15 AM   #4 (permalink)
EcoModding Apprentice
 
Join Date: Feb 2012
Location: Florida
Posts: 105

The 'Vic - '96 Honda Civic DX
Team Honda
90 day: 39.3 mpg (US)
Thanks: 6
Thanked 18 Times in 15 Posts
Quote:
Originally Posted by jakobnev View Post
What's distance to moon used for? Are you taking different routes depending on the current strenght of gravity?
Ha well seeing that the moon is roughly 239,000 miles from earth, I added that to see how far along I was if the car had just driven straight there. I guess that would be a good ecomodding goal. Seeing that the Saturn V only was running for 16 minutes and 50 seconds and the rest of the 3 day trip was EOC. And all it knows is P&G with only 4 big pulses to make it the whole way there.
__________________


Civic Build Thread
Your grammar is appreciated.

3.788 Civic CX final drive, air dam, 1st gen HCH 14" wheels and Michelin Defender 175/65R14 LRR tires
  Reply With Quote
Old 11-19-2014, 02:33 PM   #5 (permalink)
EcoModding Lurker
 
Join Date: Nov 2014
Location: prosser, wa
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
I want one

i would love a copy of that spreadsheet. Found your post looking for one, Not many out there. Thanks. Plumbtimothy. At. Gmail
  Reply With Quote
Old 11-19-2014, 07:50 PM   #6 (permalink)
EcoModding Apprentice
 
Join Date: Feb 2012
Location: Florida
Posts: 105

The 'Vic - '96 Honda Civic DX
Team Honda
90 day: 39.3 mpg (US)
Thanks: 6
Thanked 18 Times in 15 Posts
Quote:
Originally Posted by Mybusa08 View Post
i would love a copy of that spreadsheet. Found your post looking for one, Not many out there. Thanks. Plumbtimothy. At. Gmail
Sent, cheers.
__________________


Civic Build Thread
Your grammar is appreciated.

3.788 Civic CX final drive, air dam, 1st gen HCH 14" wheels and Michelin Defender 175/65R14 LRR tires
  Reply With Quote
Old 11-19-2014, 09:03 PM   #7 (permalink)
Spaced out...
 
spacemanspif's Avatar
 
Join Date: Jul 2013
Location: Dirty Jersey
Posts: 748

The New Focus - '07 Ford Focus ZX5
90 day: 32.44 mpg (US)
Thanks: 142
Thanked 205 Times in 149 Posts
Very nice and organized sheet. Looks quite professional. I went the simple route and use my google drive and downloaded "Google sheets" on my iPhone to keep track of costs. Mine is much more simple with everything just added in the next line down with a section for "notes" such gas, parts, registration etc.. I wasn't really looking for a cost breakdown, though, just tracking costs. So far I'm at $0.59/mile.

I love data!!!
__________________
-Mike

2007 Ford Focus ZX5 - 91k - SGII, pending upper and lower grill bocks - auto trans
1987 Monte Carlo SS - 5.3/4L80E swap - 13.67 @ 106
2007 Ford Focus Estate - 230k - 33mpg - Retired 4/2018
1995 Saturn SL2 - 256K miles - 44mpg - Retired 9/2014

Cost to Operate Spreadsheet for "The New Focus"

  Reply With Quote
Old 11-19-2014, 11:21 PM   #8 (permalink)
EcoModding Apprentice
 
Join Date: Feb 2012
Location: Florida
Posts: 105

The 'Vic - '96 Honda Civic DX
Team Honda
90 day: 39.3 mpg (US)
Thanks: 6
Thanked 18 Times in 15 Posts
Quote:
Originally Posted by spacemanspif View Post
Very nice and organized sheet. Looks quite professional. I went the simple route and use my google drive and downloaded "Google sheets" on my iPhone to keep track of costs. Mine is much more simple with everything just added in the next line down with a section for "notes" such gas, parts, registration etc.. I wasn't really looking for a cost breakdown, though, just tracking costs. So far I'm at $0.59/mile.

I love data!!!
Just logging the data is the big step. Once you have it you can always move on to another way of tracking.

It's funny that this thread came back up. I've put 60,000 miles on my car since I first posted this spreadsheet. Still use it at every tank. Approaching 200 fill ups.
__________________


Civic Build Thread
Your grammar is appreciated.

3.788 Civic CX final drive, air dam, 1st gen HCH 14" wheels and Michelin Defender 175/65R14 LRR tires
  Reply With Quote
Old 01-01-2015, 06:05 PM   #9 (permalink)
EcoModding Lurker
 
Join Date: Jan 2015
Location: Toronto
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
would love a copy of that spreadsheet

I too would love to get a copy of the spreadsheet. Found this thread looking for one. Also rather surprised that it's still active all this time later.
Thanks in advance.
jcw289
at
gmail
dot
com
  Reply With Quote
Old 01-01-2015, 06:13 PM   #10 (permalink)
EcoModding Apprentice
 
Join Date: Feb 2012
Location: Florida
Posts: 105

The 'Vic - '96 Honda Civic DX
Team Honda
90 day: 39.3 mpg (US)
Thanks: 6
Thanked 18 Times in 15 Posts
Quote:
Originally Posted by jcw289 View Post
I too would love to get a copy of the spreadsheet. Found this thread looking for one. Also rather surprised that it's still active all this time later.
Thanks in advance.
jcw289
at
gmail
dot
com
I get notifications from the site so I see if someone posts in a thread I started but I'm not active anymore. Tried to send it and it was rejected by gmail. Checked and it is exactly as you said. Have another email? You can PM me if you want

__________________


Civic Build Thread
Your grammar is appreciated.

3.788 Civic CX final drive, air dam, 1st gen HCH 14" wheels and Michelin Defender 175/65R14 LRR tires
  Reply With Quote
Reply  Post New Thread


Thread Tools




Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.5.2
All content copyright EcoModder.com