http://elecraft.85.s1.nabble.com/KX3-Order-Number-Decoding-tp7556470p7556480.html
Now I gotta find that spreadsheet and put my number in. Hope I don't "bump"
> 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.
> >
> > 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/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/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>