cearbhall.omeadhra at blbc.ie
Thu Sep 24 18:09:01 BST 2009
I use the formula below in an excel spread sheet to compute the iD at the
time of conversion.
Remarks from Excel Help:
". Microsoft Excel stores dates as sequential serial numbers so they can be
used in calculations. By default, January 1, 1900 is serial number 1, and
1, 2008 is serial number 39448 because it is 39,448 days after January 1,
. The NOW function changes only when the worksheet is calculated or when a
macro that contains the function is run. It is not updated continuously."
In my formula above, the figure 25569 is the number of days from 1900 to
1970 ( the Unix date that the loadstone program uses) and thus I am
calculating the number of days from 01/01/1970 to the present day. the last
figure, 86400, is the number of seconds in one day.
This formula gives a 10 digit ID number and thus fits in with the Loadstone
requirement for a 10-digit id.
As I use it for batch processing POIs this gives me a reliable ID number
incremented by 1 for each POI.
All the best,
Meeting the Leadership Challenge
T:(01) 2864623 M: 083 33 234 87 E: cearbhall.omeadhra at blbc.ie
From: loadstone-bounces at loadstone-gps.com
[mailto:loadstone-bounces at loadstone-gps.com] On Behalf Of Lex
Sent: 24 September 2009 14:46
To: loadstone at loadstone-gps.com
Subject: Re: [Loadstone] ID.
24.09.2009 11:58, Kit ?????:
> BTW, is there any program which I could use to convert offline, like a
> small tool program in my computer?
If you use NVDA screen reader, you can easily get current timestamp by
press ctrl+NVDA+z to start the python console; type "from time import time"
without quotes; type "time()" with out quotes.
The timestamp will be announced. you can press f6 to switch to output field
and then select and copy it into clipboard.
each time you will type "time()" the current timestamp will be spoken.
Loadstone mailing list
Loadstone at loadstone-gps.com
More information about the Loadstone