[Elecraft] KX3 Order Number Decoding

Wed May 23 21:28:01 EDT 2012

The decoded time is UTC (GMT).

73,

Eric
---
www.elecraft.com

On 5/23/2012 6:26 PM, Arthur Burke wrote:
> 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 <kk5na at kk5na.com 
> <mailto:kk5na at kk5na.com>> 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: elecraft-bounces at mailman.qth.net
>     <mailto:elecraft-bounces at mailman.qth.net>
>     [mailto: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 <mailto: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 <http://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 <mailto:w7cf.david at gmail.com>
>     <david at davidjenni.com <mailto: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
>     <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
>     <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
>     <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
>
>