http://elecraft.85.s1.nabble.com/KX3-Order-Number-Decoding-tp7556470p7556481.html
> Took the info from the formula.
> My order number is:
>
> 2208-4835-5827
>
> Using the formula I get:
>
> 12/28/2011 4:35 PM
>
> Since the order info came *from* Elecraft, may I assume the 4:35 PM is
> Pacific
> Standard Time? If so, then I think the conversion to UTC would be
> 12/29/2011 0035.
> Did I do that correctly?
>
> Now I gotta find that spreadsheet and put my number in. Hope I don't
> "bump" too many people in the wrong direction! LOL
>
> Art - N4PJ
>
>
> On Wed, May 23, 2012 at 9:02 PM, kk5na <
[hidden email]
> <mailto:
[hidden email]>> wrote:
>
> 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]>
> [mailto:
[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] <mailto:
[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 <
http://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] <mailto:
[hidden email]>
> <
[hidden email] <mailto:
[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]
> <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]
> <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]
> <mailto:
[hidden email]>
>
> This list hosted by:
http://www.qsl.net> Please help support this email list:
http://www.qsl.net/donate.html>
>