[Elecraft] KX3 Order Number Decoding

[kk5na]

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: elecraft-bounces at mailman.qth.net
[mailto:elecraft-bounces at mailman.qth.net] On Behalf Of Eric Swartz - WA6HHQ,
Elecraft
Sent: Wednesday, May 23, 2012 7:23 PM
To: Dave Agsten
Cc: elecraft at mailman.qth.net
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:     w7cf.david at gmail.com <david at davidjenni.com>

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:Elecraft at mailman.qth.net
>
> 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/elecraft
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:Elecraft at mailman.qth.net

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html