Posted by
kk5na on
May 24, 2012; 1:02am
URL: http://elecraft.85.s1.nabble.com/KX3-Order-Number-Decoding-tp7556470p7556478.html
Nice decode...but even decoded and I have been showing as abt next on the
Spreadsheet all day...no shipping or confirmation yet.... :(
...almost wore out my "Check email" button today!!! :)
Joe KK5NA
-----Original Message-----
From:
[hidden email]
[mailto:
[hidden email]] On Behalf Of Eric Swartz - WA6HHQ,
Elecraft
Sent: Wednesday, May 23, 2012 7:23 PM
To: Dave Agsten
Cc:
[hidden email]
Subject: Re: [Elecraft] KX3 Order Number Decoding
Turns out there is a way to decode the confirmation number. W7CF figured it
out. See below.
73,
Eric
---
www.elecraft.com
-------- Original Message --------
Subject: RE: [KX3] Re: Shipping status page updated
Date: Tue, 22 May 2012 21:48:39 +0000
From:
[hidden email] <
[hidden email]>
For those who haven't noticed, the confirmation number does indeed encode
the date & time when the confirmation was issued. I plugged some
confirmation numbers into a excel worksheet and started to play with it.
Yeah, out of "desperation" while I wait for my KX3, I started to pattern
match... :-)
The first 8 numbers encode the days & minutes of the confirmation, and in
good Unix tradition the "zero order time" is 1/1/1970
To convert, use the following formula (interesting how identical Excel and
googleDocs formulas are...):
=( VALUE(LEFT(B1,4))*10000 + VALUE(MID(B1,6,4)) ) / (60*24) + 25569
For the curious, 25569 is the number of days between 1/1/1970 and 1/1/1900,
the latter is the zero date for Excel.
Place confirmation numbers into a spreadsheet, e.g. into column B and add
the following formula to the next column C. Now format the column C "Date
time" and you'd get the readout below.
A B C
factory: 2208-4637-9147 12/28/2011 13:17:00
kits: 2208-4064-4730 12/28/2011 3:44:00
Confirmation numbers are from today's (5/22) status page update, column C
shows the actual order times calculated with above formula.
73, Dave W7CF
On 5/23/2012 4:54 PM, Dave Agsten wrote:
> I have not figured out the decoding process for the KX3 as they are being
posted on the Elecraft website. I ordered the KX3 on 12/28/11 at 11:44AM
EDT. I received the confirmation order number 2208-4844-0913. I can't decode
how that correlates to the numbers being posted on the website other than a
smaller number is earlier.
>
>
> KX3-F 2208-4685-4272
>
> KX3-K 2208-4068-6852
>
> I revised my order to go with the factory version on Jan. 18th, long
before any KX3s were shipped. I'm wondering how that factors in? The order
number remained the same but it was now for a KX3-F.
______________________________________________________________
Elecraft mailing list
Home:
http://mailman.qth.net/mailman/listinfo/elecraftHelp:
http://mailman.qth.net/mmfaq.htmPost: mailto:
[hidden email]
This list hosted by:
http://www.qsl.netPlease help support this email list:
http://www.qsl.net/donate.html______________________________________________________________
Elecraft mailing list
Home:
http://mailman.qth.net/mailman/listinfo/elecraftHelp:
http://mailman.qth.net/mmfaq.htmPost: mailto:
[hidden email]
This list hosted by:
http://www.qsl.netPlease help support this email list:
http://www.qsl.net/donate.html