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! |
| Excel Spreadsheet For Those Who Want To Track Their Savings | |
|---|---|
| Tweet Topic Started: Jan 15 2011, 10:12 PM (1,176 Views) | |
| honestabe | Jan 15 2011, 10:12 PM Post #1 |
![]()
|
Hey all, I just spent the last hour or so building a spreadsheet and inputing all the formulas so that you can track all this info on every fill-up by entering just a few bits of data (date, fuel price, fuel bill [since gas stations round and have fees sometimes], and odometer reading): -Date -Odometer -Price/Gallon -Distance -Fuel Bill -Gallons Used -MPG -Gallons Saved This Tank over a certain MPG (I have a formula inputed that you can change the MPG value of the car being compared) -Cash Saved This Tank over a certain MPG -Gallons Saved Total -Cash Saved Total -Total Distance -Total Gallons Used -Total Cash Spent on Gas I have the spreadsheet saved in MS Office 2007 Excel, so if anybody wants a copy of the spreadsheet LMK and I'll e-mail it to you (unless of course there's a way I can attach the file on here). Adam |
![]() |
|
| Spock | Jan 15 2011, 11:27 PM Post #2 |
|
Live Long and Prosper.
![]()
|
I'd like to see it/have it if you are sharing. |
![]() |
|
| honestabe | Jan 15 2011, 11:30 PM Post #3 |
![]()
|
I posted for all to enjoy my hard work. Shoot me a pm with your e-mail address and I'll send it. Lmk if you have any questions about using it. |
![]() |
|
| bogs | Jan 16 2011, 01:50 AM Post #4 |
|
Duct tape heals all wounds
![]()
|
Wow, Nice job
|
![]() |
|
| rmcelwee | Jan 16 2011, 02:05 AM Post #5 |
![]()
|
I would take a copy but it is depressing seeing how little I save. This summer when I start driving the V8 Miata more the savings will be easier to see. |
![]() |
|
| honestabe | Jan 16 2011, 02:10 AM Post #6 |
![]()
|
rmcelwee, what do you mean when you say "how little I save?" You drive a Geo Metro, the worst possible FE you can get is in the low 30's (and even that takes some work to get that low). Every little bit adds up. Currently I'm at 21,092 miles logged with a savings of $1720.59 and 604.007 gallons of gas. On average I save $30.24 every fill-up over a 20 MPG car. My fuel log allows you to edit the value of the FE rating of the vehicle being compared so you can compare it to a Prius or V8 Miata or whatever else you want. Like I said, I just need an e-mail address to send the file to, so shoot me a PM if you want a copy Here's what my hard copy version looks like. It's in a small green notebook I keep in my glovebox.
Edited by honestabe, Jan 16 2011, 02:18 AM.
|
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · The Geo Metro Lounge · Next Topic » |


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





Here's what my hard copy version looks like. It's in a small green notebook I keep in my glovebox.
7:14 PM Jul 10