30DodgePanel Posted March 17 Share Posted March 17 (edited) I'm curious how many on here use Excel while researching automotive parts or while comparing models produced for historical data. Have you found tricks that make it useful or have you found it to be too much work to input the many parts numbers and descriptions? I realize parts stores and some areas of the modern industry use Excel for searching and categorizing parts numbers (and other uses), but they have paid workers to design and build those spreadsheets within their systems. I'm strictly asking about the research aspect while comparing models produced and how each year may have shared a common interchangeable part as a novice Excel user. Here is the reason I'm wanting to take on this project and why I feel it's so important. Graham and Dodge Brothers truck literature is the only way to uncover some of the long lost answers. However, that literature is spread throughout the world thanks to resell and the internet. As a researcher, it makes it nearly impossible to compare literature because it is simply unavailable to any one person. For this reason, I hope by comparing parts numbers per model it may uncover some of those answers. Surely this has been tried before and other researchers have run into the same issues. What have you found that works or doesn't work? Looking to hear any pros and cons before I attempt to tackle a lengthy project. Below is a small incomplete example of the BE model of Graham/Dodge Brothers trucks I've categorized chronologically by frame and engine numbers. Some are existing trucks and some are from registration copies I've found while searching the internet (I've blotted out both frame and engine numbers for obvious reasons). Out of 33 base models produced in the E series trucks from 1928-1932 the BE is just one of those models that began production after July 1928. Since I can now show the chronological order of frames that were Detroit built trucks, Evansville built, Stockton built we now have the potential to recognize more quickly when changes took place according to frame or engine numbers used in the Master Parts Books and other literature, "IF" I can find a standarized and simple method of adding 50 pages of parts #'s. This (in theory) would not only help with recognizing changes but also may shed light on lost details in regards to why these trucks were produced in random weight ratings back to back on the assembly line. For example the E series 1 1/4 ton were made randomly as they were ordered alongside 3/4 ton and 3 ton trucks even as the new F series rolled out. Yes, a confusing mess for any researcher as none of these points have ever been easily defined without countless hours of research not to mention the cost of the literature. The next model built after the BE in the 130" wheelbase was the DA130. However, to date no DA130 owners have come forth and I've found nothing on file (yet) in the club rosters but my work is in progress. Since there are no DA130 truck details I will show a 124" wheelbase truck the DA124 model showing the higher frame numbers which shows the exact time of the change over from the previous models as frame # D2213xx Edited March 17 by 30DodgePanel (see edit history) Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now