Trek Serial Number Database
Hi there good people I have been a casual and basic filemaker user for a number of years, starting with the simple form that was included with ClarisWorks all those years ago. I recently decided to challenge myself to write a database to help easily decipher and record manufacturing codes for a hobby I am involved with - Vintage BMX Bikes. To say the least I have stumped myself well and truly and am looking for some assistance. Here is my dilemma: I know for certain the meaning of the sequence of the numbers and letters in the stamped serial number but I can't get my head around transforming it to a database! EG: Bike frame stamped 9143D I know that this can be broken down to: 9th month (September), 1981, 43rd in sequence, Welded by Darrell Kendall Frame stamped 501161D Is 5th month (May), 1980, 1161st in sequence, welded by Darrell Kendall There is physical evidence on the frame of the model change so that can be marked in the database. What I really need help to work out is what is the best way to be able to type in the number and character stamped on the frame and have it decoded??? Hopefully someone can point me in the right direction.
Many thanks in advance. Are all bikes manufactured in the eighties? How many welders are there? Is the welder always identified by a single letter? We think all bikes are manufactured in the eighties - you would not believe how hard it was to crack this code - the bikes made in the seventies have totally different serials - which still haven't been deciphered yet 2.
Dec 31, 2017 - Download Naruto Shippuden Episode 165 Sub Indo. One Piece Episode 814 Sub Indo, BD, Bluray, Bluray disc, Bluray disk, mkv, 480p, 720p,. FAST DOWNLOAD. TAGS: 3gp Naruto Shippuden Episode 165 Subtitle Indonesia 360p mkv 480p mkv 720p mp4 mHD MP4HD. Share to: Facebook Twitter. Download naruto shippuden episodes mp4. Naruto Shippuuden 166.3gp NARUTO EPISODE 153 SUB INDO MP4 MP3 Download. 164 Eps 165 Eps 166 Eps 167 Eps 168. Download and watch online latest. 480p 720p 360p autop 3GP 144p 3GP 240p Alternative Servers: (Save as. Jun 17, 2010 - Watch Naruto Shippuden: The Two Saviors Episode 165, Nine Tails, Captured!, on Crunchyroll. Gamabunta and the other toads are defeated. Jun 4, 2013 - Naruto Shippuden Episode 165 Subtitle Indonesia Download Film Anime. Download Video Anime Naruto Shippuden 165 Subtitle Indonesia Naruto. Naruto Shippuden 165 Subtitle Indonesia.MKV. (70 Mb) [ 480p].
From what we can tell there were 3 welders all identified by a single letter - their first initial (there are also prefixes for special edition bikes but they are quite rare and can be dealt with on a case to case basis ie T for team rider bike). What I'm not clear about is what they did in October, November or December, as there appears to be only a single digit for the month. HTH Brian That is what confused us for some time! Following the sequence, purely for illustrations sake, the last December 1981 frame, build sequence 256 welded by Mark Bradshaw bike would be stamped 121256M then a January 1982 welded by Darrell would be 12257D When we only had a few frames as reference you could understand our difficulty in establishing their heritage Cheers Ben. Brian's remark is right on the money: how can you tell that '121256M' is not January 1982, #1256 or that '12257D' is not December 1982, #57? Now you encountered the difficulty of my task It is known that there are two models - the second commencing in September 1981 eg: 918D Unfortunately we feel there might be an overlap from version one to version 2 of maybe a month or so So in summary - the code for the stamping remained the same but was re-set with no additional acknowledgement So we also know that the first edition frames were stamped in the same way but from (we think) September 1981 the build sequence was reset to '1' Luckily visual appearance can tell these two apart.
Now you could possible have an idea why I have been tearing my hair out!!! I am afraid I don't follow this fully. If there are two 'versions' of the frame number and each needs to be interpreted differently, then the version should be entered into another field (assuming it's not apparent from the frame number alone). Now I would suggest you sit down with a piece of paper and write down the steps you would take to identify the month and the year without a computer (think of this as writing directions for a stupid but reliable person). Then the actual calculation will become easy to construct - assuming the task is possible in the first place. Hi Ben, and Welcome to the Forum, I've been toying with your sample data in TextWrangler, and I think it might be possible to do the lion's share of this parsing out using grep patterns in TextWrangler or BBEdit.
The real challenge is the Oct - Jan productions, however, I was able to parse out the Dec and Jan example you gave, using a couple of greps. However, the real test would be with real data. Are you trying to breakout this data on bikes you own, bikes you want to purchase, or are you doing this for all of the bikes manufactured by these two?
Do you have a complete list of those you want to parse out? If so, why not post it as an attachment to a Reply, so that I can get a better feel for the complete picture?
HTH Lee Edited September 20, 2010 by Guest. Hi Lee and thanks others for your replies What we are trying to create is a couple of things in one for the enthusiasts of this particular Australian made brand.
Firstly a decoder of the number stamped on the frames Secondly an historical archive of the frames themselves including some other aspects such as paint finishes and the like Here's the breakdown as we established it, in a little greater detail For the frame stamped 501161D as an example 5= May some serials began with 10, 11, or 12 for October, November or December. Eg 110xxxx X 0= 1980 they used the last digit of the year & will always be 9,0,1,2,or 3. 1161= the serial number of the frame.
This can be as short as one digit, ie, 911 for Sept, 1981, frame number 1. D= Darrell Kendell, the man who actually built the frame in the factory. Other code letters used as a suffix are M= Mark Bradley who was a frame welder, a designer, test rider & Factory Team rider. R= Ray Williams.
He is currently the state Liberal member for Hawksbury. X= Not currently known but thought to have been used on Factory Team race bikes. Prefix codes were sometimes included and can also be used as qualifiers TF= Team Frame. This was used on the 'Team' models, which was their production race model from December 1979 to August 1981 TH= Team Helium. This was the replacement race frame for the Team & was manufactured from September 1981.
It was available until the end of manufacture in 1983. (these also had their own serial numbers starting from 1 - it is thought only 150 of these were made) 24. This was seen on the earliest of the 24' Cruiser models & was followed by a one or two digit serial but no date code. This was used on later 24' Cruiser models. Very low production numbers but part of the general serial sequence we think CR. This was used on 26' Cruiser models. Same as 24' models M.
This would indicate the Mountain Bike model that was largely based on the 26' Cruiser frame. Other classification items that can be included are made by a visual inspection and could be simple radio buttons or check boxes - this is what would help discern the 'September Crossover' frames which we have termed Series 1 and Series 2 - the area where the rear wheel connects was the change between these models so any 91XXX serial number will also have to be qualified by checking one of these boxes as well.
Trek Bike Serial Number
Other classification items that can be included are made by a visual inspection and could be simple radio buttons or check boxes - this is what would help discern the 'September Crossover' frames which we have termed Series 1 and Series 2 - the area where the rear wheel connects was the change between these models so any 91XXX serial number will also have to be qualified by checking one of these boxes as well. I am sorry, but you are only confusing me even more. If I understand correctly, after removing the prefix and the welder's code you are left with a sequence of digits. I think you have now also narrowed the years to 1979 - 1983. And I believe the serial number cannot start with a zero.
Therefore, if the sequence begins with one of these: 109 101 102 103 119 111 112 113 129 121 122 123 we need something more to tell us what these mean. Everything else should be very easy (unless I am missing something again). I am sorry, but you are only confusing me even more. If I understand correctly, after removing the prefix and the welder's code you are left with a sequence of digits.
I think you have now also narrowed the years to 1979 - 1983. And I believe the serial number cannot start with a zero. I don't care if you write it out as text - as long as it becomes an algorithm (i.e. Something that a stupid machine like a computer can follow blindly, without any judgment calls of its own). You can skip the prefix and welder extraction part - these are pretty clear, I think. Start with the following input as being known: FrameNumber - a variable number of digits; Prefix - as per the list of possible prefixes you have provided (incl.
'24') Location - a Boolean value, I think? Edited September 21, 2010 by Guest. I don't care if you write it out as text - as long as it becomes an algorithm (i.e. Something that a stupid machine like a computer can follow blindly, without any judgment calls of its own). You can skip the prefix and welder extraction part - these are pretty clear, I think. Start with the following input as being known: FrameNumber - a variable number of digits; Prefix - as per the list of possible prefixes you have provided (incl. '24') Location - a Boolean value, I think?
Trek Serial Number Wtu
Trek Serial Number Lookup
OK how is this then - I have made a flow chart of sorts to help (all the symbol boxes made it spread too far over the page so I coded the text in colour instead - the legend for the colours is at the bottom of the page) Thank you ever so much for your patience and effort so far!