Posted by
Eric Swartz - WA6HHQ on
May 24, 2012; 12:23am
URL: http://elecraft.85.s1.nabble.com/KX3-Order-Number-Decoding-tp7556470p7556473.html
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.
>
> Any cryptologists out there? :-)
>
>
> 73,
> Dave N8AG
> ______________________________________________________________
> Elecraft mailing list
> Home:
http://mailman.qth.net/mailman/listinfo/elecraft> Help:
http://mailman.qth.net/mmfaq.htm> Post: mailto:
[hidden email]
>
> This list hosted by:
http://www.qsl.net> Please 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