http://www.fuelly.com/ - Page 2 - Fuelly Forums

Android Users - Coming Soon! - Migrating from aCar 4.8 to 5.0

Reply
 
Thread Tools Display Modes
 
Old 10-01-2008, 06:18 PM   #11
Registered Member
 
theholycow's Avatar
 
Join Date: Apr 2008
Posts: 6,624
Country: United States
Send a message via ICQ to theholycow Send a message via AIM to theholycow Send a message via MSN to theholycow Send a message via Yahoo to theholycow
Keep this thread alive. When I have time AND energy simultaneously, I'll figure out a way to automate the work. I should be able to make a CSV by saving the gaslog as html or text, cleaning it up a bit (vertical selection feature in Notepad++ FTW!), and so on.

Actually, come to think of it, if you're willing to use Internet Explorer and Microsoft Office for a moment, you may be able to just drag the page from IE into Excel. There's some really good integration there, and I recently made a CSV of a table on another website that way.
__________________

__________________
This sig may return, some day.
theholycow is offline   Reply With Quote
Old 10-03-2008, 08:25 AM   #12
Registered Member
 
theholycow's Avatar
 
Join Date: Apr 2008
Posts: 6,624
Country: United States
Send a message via ICQ to theholycow Send a message via AIM to theholycow Send a message via MSN to theholycow Send a message via Yahoo to theholycow
Ok, another thread just reminded me. I tried using Excel, works like a charm. Here's what I wrote in that thread:

Quote:
Originally Posted by theholycow View Post
Got Microsoft Excel? If so, do this:
1. Open your gaslog in Internet Explorer.
2. Select the data (try to get the headings in your selection but not the graph image).
3. Copy to clipboard.
4. Paste into Excel.
5. Delete any extra stuff you didn't want, like the graph image that you couldn't help but select.
6. Crunch the numbers.

You know all that overcooked bullcrap Microsoft does? It occasionally pays off...

I just tried it with IE7 and Excel 2007, works great. Total miles: 12085.06. Total fuel used: 371.788. Average cost per gallon: 3.477051.
To make it a CSV:
- skip step 6 above
- delete any columns and rows you don't want (don't just delete the data, delete the actual column/row: use Edit->Delete in reasonable versions or Delete from the Home ribbon in 2007 (stupid ribbon crap))
- rearrange the columns if necessary
- File->Save As
- select CSV format
- enjoy

Edit: You can also do it with OpenOffice or online with Google Spreadsheets, and you don't need to use IE -- in fact, if you don't use IE and/or don't use Excel your results will be better.
__________________

__________________
This sig may return, some day.
theholycow 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


Powered by vBadvanced CMPS v3.2.3


All times are GMT -8. The time now is 01:12 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.