Author Topic: Seiko production date calculator - new one! Rev02-08/03/11 (Read 9361 times)

Cannop · « **on:** March 06, 2011, 11:06:25 PM »

As the production date calculator this site links to hasn't been working for some time I have knocked up my own version. It is just a quick and dirty excel spreadsheet but it seems to work so far! If you want to download it go here:

http://homepage.ntlworld.com/cannop/files/seikocalculator.xls

If you find any problems with it give me a shout - I am no excel guru but if I can fix any problems I will.

Edit - I have made two small changes to the spreadsheet since I posted it last night. It doesn't affect the results, it just tidies up the error messages. Oh and a bugfix now

! The latest version is Rev02-08/03/11.

Moderators - if this is against any rules here apologies, I'm just trying to give a little back to this excellent community. Please let me know and feel free to delete this thread.

Andoy, M.F. · « **Reply #1 on:** March 06, 2011, 11:20:52 PM »

I don't see how something helpful and actually works be against any rules?

Well done Bro!

Cheers.

signature1 · « **Reply #2 on:** March 06, 2011, 11:25:42 PM »

Thank you very much.

Works a treat.
Mods, this should be saved somewhere on the site for easy access.

bill

TheTigerUK · « **Reply #3 on:** March 06, 2011, 11:27:38 PM »

I see no problem with it, lets see how it runs for a short while and if there are no problems we will implement it some were

Ananta93 · « **Reply #4 on:** March 07, 2011, 04:25:01 AM »

Hi Cannop, EXCEllent work, a very good idea that complements this is done officially. A big thank you and

yet.
Cheers, J-P

Cannop · « **Reply #5 on:** March 07, 2011, 06:03:50 AM »

Quote from: Ananta93 on March 07, 2011, 04:25:01 AM

Hi Cannop, EXCEllent work

I see what you did there!

schiller841 · « **Reply #6 on:** March 07, 2011, 08:58:17 PM »

Greetings Cannop:

Great work - 1 comment: I get an error when I try to determine the date for my Seiko 5606 Lord Matic. The serial number is 002093. I've put it in both as 2093 and 002093 and each time get a serial number format incorrect message. Any thoughts?

Regards,
Mike

Technoman · « **Reply #7 on:** March 07, 2011, 09:10:00 PM »

Quote from: schiller841 on March 07, 2011, 08:58:17 PM

Greetings Cannop:

Great work - 1 comment: I get an error when I try to determine the date for my Seiko 5606 Lord Matic. The serial number is 002093. I've put it in both as 2093 and 002093 and each time get a serial number format incorrect message. Any thoughts?

Regards,
Mike

Try O rather than 0 as the second character (that would be the letter o as opposed to the number zero). Or vice versa depending on what you did the last time.

Casiojem · « **Reply #8 on:** March 07, 2011, 10:14:29 PM »

Good effort that man!

DAHASCO · « **Reply #9 on:** March 07, 2011, 10:19:56 PM »

Nice work

That is pretty slick

sharkfinDave · « **Reply #10 on:** March 07, 2011, 10:27:04 PM »

Nice!

UKRower · « **Reply #11 on:** March 07, 2011, 10:27:58 PM »

Thank you!!!

Cannop · « **Reply #12 on:** March 08, 2011, 04:35:30 AM »

Quote from: schiller841 on March 07, 2011, 08:58:17 PM

Greetings Cannop:

Great work - 1 comment: I get an error when I try to determine the date for my Seiko 5606 Lord Matic. The serial number is 002093. I've put it in both as 2093 and 002093 and each time get a serial number format incorrect message. Any thoughts?

Regards,
Mike

Technoman is right, the second character on your serial number is actually the letter "O" not a zero. Try that and it should work.

Cannop · « **Reply #13 on:** March 08, 2011, 04:44:29 PM »

I have added a guide as to where to find the movement and serial numbers for those who are unsure which is which. The latest version is: Rev02-08/03/11

Cannop · « **Reply #14 on:** March 26, 2011, 11:02:24 AM »

A couple of new models added. Latest build is now Rev03-26/03/11.

http://homepage.ntlworld.com/cannop/files/seikocalculator.xls

Enjoy

Jeje3325 · « **Reply #15 on:** March 26, 2011, 01:03:04 PM »

Thanks mate!

Real cool of ya

seiko5man · « **Reply #16 on:** March 26, 2011, 03:11:28 PM »

jkchua · « **Reply #17 on:** March 26, 2011, 05:08:18 PM »

Argh, I don't have excel in my netbook!

G-Junkie · « **Reply #18 on:** March 26, 2011, 05:24:09 PM »

Quote from: jkchua on March 26, 2011, 05:08:18 PM

Argh, I don't have excel in my netbook!

try OpenOffice. it's basically a free microsoft office clone. they have various office programs in the package. they're a bit rough and not every file is compatible, but they're sufficient enough to open and read most files. I mainly use it for typing papers and such. http://download.openoffice.org/

jkchua · « **Reply #19 on:** March 27, 2011, 01:10:21 AM »

Broadband service too slow too

I'll try to download this some other time.

Thanks An

SxSDoublegun · « **Reply #20 on:** March 27, 2011, 04:15:13 AM »

How about a 7009-8129 with SN 764xxx ?

June of 1967 or June of 1977 ?

Max

MikeyT · « **Reply #21 on:** March 27, 2011, 11:09:26 AM »

I have Open Office, and it opens only in read-only mode. It won't accept anything I put in.

Cannop · « **Reply #22 on:** March 27, 2011, 12:00:18 PM »

Quote from: SxSDoublegun on March 27, 2011, 04:15:13 AM

How about a 7009-8129 with SN 764xxx ?

June of 1967 or June of 1977 ?

Max

Possibly June 1977, although I have never heard of one quite that early so probably June 1987.

Cannop · « **Reply #23 on:** March 27, 2011, 12:07:27 PM »

Quote from: MikeyT on March 27, 2011, 11:09:26 AM

I have Open Office, and it opens only in read-only mode. It won't accept anything I put in.

Sorry about the open office incompatibility

, I created it with microsoft office as thats what is on my computer here. It seems like an open office glitch as there are two unprotected cells, the ones that you enter the movement and serial number in. I'm not sure if you can do anything about though.

Axel66 · « **Reply #24 on:** March 27, 2011, 12:55:30 PM »

I guess it's only a problem if, you directly open it (of course the sytem also downloads it, but the behaviour seems to be different). If you first download it from to your hard drive and than open it, it works at least with LibreOffice (so it should work as well with OpenOffice).

Cheers,

Axel