http://elecraft.85.s1.nabble.com/KX3-Order-Number-Decoding-tp7556470p7556477.html
Start the day off slow...then taper off.....
> 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>