On Thu, 14 May 2009 07:32:00 -0700 (PDT),
Tim wrote:
Thanks muchly for your efforts on this, but I don't think it's going
to help as it's mostly gobbledygook to me!!! I just wish the online
journey history wasn't so complicated to make sense of (let alone
reflect the journey history accurately, which was the origin of this
thread!).
Regards
I've found it's very much easier than that :-)
You can import the "printer ready" version of the journey history
straight into openoffice.
I've build a spreadsheet where all you need to do is:
1. Save the printer ready journey history to a file
2. Insert-Sheet From File and select the file created in 1
3. Change Cell B1 on the "Journeys" sheet to the name of the sheet you
created in 2.
That's it. Enjoy your journey history.
http://www.woodall.me.uk/journeycalc/journeycalc.ods
http://www.openoffice.org/
(Note that I'm using version 2.4 of openoffice. I assume later versions
will open this file without any problems)
I've included two sheets of my journey history just so you can see how
it works, including what happens when there are missing items in the
journey history.
The sheet "Workings" is used for internal calculations, just ignore it
unless you want to enhance the way it calculates the start and end of
journeys. At the moment the logic is that if a row happens more than two
hours after the previous row then it's a journey start, otherwise it's
a journey continuation.
(For anyone who wants to improve this, the two critical columns are H
and I on this page. As long as these are right, everything else should
automatically be correct - bugs excepted)
Openoffice does have the option to save as an excel file but as I have
not way to test this I've not done it.
Note also that I have a very boring life on oyster. I've got no capped
journeys, no cash top-ups etc. These may not work properly. If anyone
wants to provide printer ready journey histories with these in I'll try
and enhance the spreadsheet to handle them properly
Tim.
p.s. I've protected the two critical sheets (other than cell B1 on
Journeys.) There's no password set to this can just be turned off if you
want to change things.
--
God said, "div D = rho, div B = 0, curl E = - @B/@t, curl H = J + @D/@t,"
and there was light.
http://www.woodall.me.uk/