Update to Fuel Mileage Tracking Web-App

Create new entry

A few months ago, I whipped up a few PHP pages which saved gas mileage statistics to a Google Spreadsheet and called it a web app. Now I have totally gutted the UI and replaced it with a jQuery Mobile front end. The result is a much more phone-friendly interface, great for using at the pump. It is now live at gas.randomland.net.

I have and placed the project on github. A copy will remain on the Randomland SVN for the time being. And, as with the original code, I'm releasing it under the Apache 2.0 license. Clone and fork at will!

View fill-up history

Also as before, the code connects to your Google Docs account. To get started, open the master spreadsheet on a desktop computer and click File->Make a Copy. Give it a name ending with (rlgaslog) (subject to change!) (mobilemiles). Then go to gas.randomland.net and authorize access to your Google Docs from your mobile device.

The rest should be pretty much self explanatory. There are really only three options: list available docs, list existing entries, and add a new entry.

There are still a number of performance and usability issues I plan to address. If you have any suggestions or bug reports, blurt them out in the comments section of this post or on github. Enjoy!

P.S. In case you're wondering, the stats in the screenshots are real, from my 16-year-old daily-driver Toyota Camry Smile


I like the new interface!

Looks good. Can it be tied in to any graphs or charts? And, what do you think of removing the tie in to google docks and making it post to a database and associated acess pages? Or have an option for both!

It's official

Charts and graphs have always been in the back of my mind. It's good, logical addition and is thus official Smile

The back end could actually be switched to a database faily easily. I'll separate and abstract things a little more when I get time. Almost all you'd have to do is swap out the ajax_ files. Everything but authentication is passed back and forth via JSON-encoded AJAX calls, so as long as you take in and spit out data in the right format, the front end is none the wiser.