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 <[email protected]> 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: [email protected] > [mailto:[email protected]] On Behalf Of Eric Swartz - > WA6HHQ, > Elecraft > Sent: Wednesday, May 23, 2012 7:23 PM > To: Dave Agsten > Cc: [email protected] > 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: [email protected] <[email protected]> > > 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:[email protected] > > > > 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:[email protected] > > 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:[email protected] > > 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:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
