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
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.
__________________