GMTK-MVMTS Excel Spreadsheet
-
- G-Lieutenant Colonel
- Posts: 1098
- Joined: Sun Jun 20, 2010 5:04 am
- Location: Charles Town, WV
- Contact:
GMTK-MVMTS Excel Spreadsheet
I developed this for myself so I could make customizable "shopping lists" to carry with me to the flea market. By hiding columns and adding a check box I can inventory what I have. I worked off of the stickies here and the posted scans. Some are not visible anymore due to Photobucket. I cannot guarantee I don't have any errors. So if you see a mistake on my part please tell me. I took some liberties with naming convention such as using the term "Universal" for my own sanity when I'm at the flea market. I know what a "Universal" is for sockets. but "Joint" might leave me scratching my head on a Saturday morning. I'll be happy to share the file with anybody. Just let me know where to email it.
I have not yet added in the broken out components of the sets that in the later SNL's received their own stock numbers. Also I used the stock number as my benchmark. Therefore changes to the standard and consequently changes to tools that are not reflected in a different stock number are not reflected here. Therefore it's possible a tool that appears to be identical from 1938 through post-war may in fact not be. I'm simply not as versed as the more experienced members here on the details. Also I went strictly off the stock lists not from the pictures.
I welcome suggestions for improvements and notification of errors.
Matt
I have not yet added in the broken out components of the sets that in the later SNL's received their own stock numbers. Also I used the stock number as my benchmark. Therefore changes to the standard and consequently changes to tools that are not reflected in a different stock number are not reflected here. Therefore it's possible a tool that appears to be identical from 1938 through post-war may in fact not be. I'm simply not as versed as the more experienced members here on the details. Also I went strictly off the stock lists not from the pictures.
I welcome suggestions for improvements and notification of errors.
Matt
1970 Kaiser Jeep DJ-5A Left Hand Drive
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
-
- G-First Lieutenant
- Posts: 681
- Joined: Thu Jun 06, 2013 12:53 am
- Location:
Re: GMTK-MVMTS Excel Spreadsheet
Matt,
That is a great spreadsheet. Very handy and, as you point out, it works nicely as a check list. I’ll take a closer look at what you have posted when I’m back at a full size computer to see if I have any “suggested” corrections. but at first glance it looks fine.
I’m sure others on here will have additional comments and thoughts as they are far more knowledgeable than me.
Having said all of that I’ll pm you regarding getting an electronic copy of your spreadsheet as I would love to have one.
Thank you,
Henry
That is a great spreadsheet. Very handy and, as you point out, it works nicely as a check list. I’ll take a closer look at what you have posted when I’m back at a full size computer to see if I have any “suggested” corrections. but at first glance it looks fine.
I’m sure others on here will have additional comments and thoughts as they are far more knowledgeable than me.
Having said all of that I’ll pm you regarding getting an electronic copy of your spreadsheet as I would love to have one.
Thank you,
Henry
- Wingnutt
- G-Lieutenant General
- Posts: 5029
- Joined: Mon Oct 24, 2011 1:17 pm
- Location:
Re: GMTK-MVMTS Excel Spreadsheet
Yikes! Did you keep track of which ones, Matt?! If any were mine, let me know.
All,
As good a time as any to warn everyone that ALL of my charts and cheatsheets etc will all go poof at some point. Last time I checked they were still there. I think I have all of them on my hard drive, but I am putting off the replacement process until Photobucket actually cuts me off. As a small monthly fee-paying member, I did not get cut off when all the freeloaders did last year. I did get a notice in December that I had 30 days to upgrade to the ridiculous monthly fee for hyperlinking, but that came and went and I am still up and still hyperlinking. Maybe I am grandfathered for being a loyal customer, and maybe I'll wake up one day and all my charts will be gone.
Nice work. I used to keep my charts (page 2 on this thread here) - less abbreviated than yours - printed off and in my flea market bag for information and checklisting and annotations, but I replaced that approach with the Whiz.Rustman wrote: I welcome suggestions for improvements and notification of errors.
One thing I noticed were the headings. Your last column can be moved up to April 1945 from July 1945. There were some very minor changes in the July 1945 ORD 6 SNL G-27 that were not in the April 1945 ORD 6 SNL G-27, but as a whole, most of the specs you attribute to July were actually in place in April, for anyone who cares about that. If you really want to gnat's-ass it, you have to add a column for April, as I did in my charts.
As for accuracy, I'm not going to double-check your charts against mine with a fine-tooth comb, which is painstaking work, but glancing through it, it looks pretty good on re-capturing the major changes across time, at least at the set level for the sets.
One thing that popped out at me at a glance, though, was the hex wrenches. The four (4) sizes you have listed are the correct sizes for July 1944 on (your columns 3, 4, and 5). But they are incorrect for October 1942 to June 1944 (your column 2), when they were exactly twice the mid- to late-war sizes.
TEMPORARY DUTY
-
- G-Lieutenant Colonel
- Posts: 1098
- Joined: Sun Jun 20, 2010 5:04 am
- Location: Charles Town, WV
- Contact:
Re: GMTK-MVMTS Excel Spreadsheet
Wingnutt thanks for your vote of confidence! The April 45 is the one that has vanished. That's why I have it down as July. That one was still visible. I'll have to go back and fix my mistakes on the hex wrenches. Also if no one else has noticed, I have, I need to go back and add a 1 after the 4 in several of the stock numbers. Minor fix.
It's a work in progress and it's expanding. Today I added a second page with the first of the 2nd Echelon sets.
Matt
It's a work in progress and it's expanding. Today I added a second page with the first of the 2nd Echelon sets.
Matt
1970 Kaiser Jeep DJ-5A Left Hand Drive
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
-
- G-First Lieutenant
- Posts: 681
- Joined: Thu Jun 06, 2013 12:53 am
- Location:
Re: GMTK-MVMTS Excel Spreadsheet
Matt,
At the risk of sounding like a shill for Greg... his GMTK “Whizz” is awesome. If you have not seen it or heard of it yet. It is a double sided tri-fold laminated sheet (that folds down to about and 8.5” x 11” footprint)... depicting the full size outline of all of the tools in the GMTK so the user can just place a prospective tool on its outline and be fairly certain that it is “spot on” for inclusion in the GMTK. Additionally it has annotations next to the outlines of the pertinent size specs for sockets sizes, wrench openings, screwdriver shank lengths etc. as well as time periods when a particular tool was introduced into or removed from the GMTK. Finally, it has a side column on the edge of one side that provides information on the various manufacturers and “brands” that would be appropriate for the WWII era to further aid the user in choosing a WWII era produced tool versus its modern equivalent.
All in all a very handy reference!
Thank you,
Henry
At the risk of sounding like a shill for Greg... his GMTK “Whizz” is awesome. If you have not seen it or heard of it yet. It is a double sided tri-fold laminated sheet (that folds down to about and 8.5” x 11” footprint)... depicting the full size outline of all of the tools in the GMTK so the user can just place a prospective tool on its outline and be fairly certain that it is “spot on” for inclusion in the GMTK. Additionally it has annotations next to the outlines of the pertinent size specs for sockets sizes, wrench openings, screwdriver shank lengths etc. as well as time periods when a particular tool was introduced into or removed from the GMTK. Finally, it has a side column on the edge of one side that provides information on the various manufacturers and “brands” that would be appropriate for the WWII era to further aid the user in choosing a WWII era produced tool versus its modern equivalent.
All in all a very handy reference!
Thank you,
Henry
-
- G-First Lieutenant
- Posts: 681
- Joined: Thu Jun 06, 2013 12:53 am
- Location:
Re: GMTK-MVMTS Excel Spreadsheet
Second echelon sets!!! Now you really piqued my interest!It's a work in progress and it's expanding. Today I added a second page with the first of the 2nd Echelon sets.
Thank you,
Henry
-
- G-Lieutenant Colonel
- Posts: 1098
- Joined: Sun Jun 20, 2010 5:04 am
- Location: Charles Town, WV
- Contact:
Re: GMTK-MVMTS Excel Spreadsheet
Oooh I would very much like to see this WHiZZ. Greg how do I obtain a copy? Where do I send my 3 monthly payments to?
As for the higher echelon tools. I'm working off of these:
http://g503.com/forums/viewtopic.php?f=48&t=281430
I've done Set 1, next I'll do Set 2. I'm working off of Chad's 33rdsignal photos and Silly's MB scans.
Matt
As for the higher echelon tools. I'm working off of these:
http://g503.com/forums/viewtopic.php?f=48&t=281430
I've done Set 1, next I'll do Set 2. I'm working off of Chad's 33rdsignal photos and Silly's MB scans.
Matt
1970 Kaiser Jeep DJ-5A Left Hand Drive
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
- d42jeep
- G-Brigadier General
- Posts: 2290
- Joined: Tue Feb 25, 2014 4:06 pm
- Location: Albany/Fallen Leaf Lake, CA
- Contact:
Re: GMTK-MVMTS Excel Spreadsheet
Matt,
I was going through your valuable spreadsheet and noticed that you have the oiler listed as 3" across. That spec. Is generally considered to be an early typo and the oilers that actually match the capacity listed are 4" across.
-Don
I was going through your valuable spreadsheet and noticed that you have the oiler listed as 3" across. That spec. Is generally considered to be an early typo and the oilers that actually match the capacity listed are 4" across.
-Don
Ford GPW 76344 DOD 11/42 Built in Richmond, CA
-
- G-Lieutenant Colonel
- Posts: 1098
- Joined: Sun Jun 20, 2010 5:04 am
- Location: Charles Town, WV
- Contact:
Re: GMTK-MVMTS Excel Spreadsheet
Ah well that's a good thing since my oiler is more then 3 inches across I thought I recalled reading that. It would be prudent of myself to update that.
Thank you.
Matt
1970 Kaiser Jeep DJ-5A Left Hand Drive
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
- gpw_42
- Sergeant Major of the Gee
- Posts: 399
- Joined: Sun Nov 22, 2009 4:18 pm
- Location:
Re: GMTK-MVMTS Excel Spreadsheet
Matt,
Well done at making the spreadsheets into your own tool. You'll remember the information MUCH better that way, rather than just copying someone else's work.
Wingnutt, thanks for the warning on the shelf life of your products. As a result, I've already copied and pasted your spreadsheets from the retrospective onto my hard drive. Photobucket is really going to hurt the wealth of knowledge out there on the net, as various collectors from numerous different fields choose not to pay the ransom. Climbing down off the soap box, I probably need to go in search of more spreadsheets here on the Tool Forum.
Steve
Well done at making the spreadsheets into your own tool. You'll remember the information MUCH better that way, rather than just copying someone else's work.
Wingnutt, thanks for the warning on the shelf life of your products. As a result, I've already copied and pasted your spreadsheets from the retrospective onto my hard drive. Photobucket is really going to hurt the wealth of knowledge out there on the net, as various collectors from numerous different fields choose not to pay the ransom. Climbing down off the soap box, I probably need to go in search of more spreadsheets here on the Tool Forum.
Steve
-
- G-Lieutenant Colonel
- Posts: 1098
- Joined: Sun Jun 20, 2010 5:04 am
- Location: Charles Town, WV
- Contact:
Re: GMTK-MVMTS Excel Spreadsheet
And here is why I should also look at the specifications closely. Notice how the sizes changed but the stock number does not. Here I will lay out the description from early to late on ONE of the wrenches. This took me a few minutes to uncover and now it makes sense. And now I can make sure to get the CORRECT size wrench...Wingnutt wrote: ↑Tue Mar 20, 2018 8:30 am
One thing that popped out at me at a glance, though, was the hex wrenches. The four (4) sizes you have listed are the correct sizes for July 1944 on (your columns 3, 4, and 5). But they are incorrect for October 1942 to June 1944 (your column 2), when they were exactly twice the mid- to late-war sizes.
October 1942:
41-W-2450 WRENCH, Safety Screw 1/4 in. hex.
July 1944:
41-W-2450 WRENCH, Safety Head Set Screw, 1/8 in. hex.
October 1944:
41-W-2450 WRENCH, Safety Head Set Screw, 1/8 in. hex.
July 1945:
41-W-2450 WRENCH, Set or cap screw (hollow head) hex., plug type, regular short arm series, hex diam. 1/8 in., screw, size No. 1/4 in., cap no. 8 socket, no. 10 flat
I believe I am reading this that the July 1945 specification spelled out that this is an 1/8" size WRENCH for a 1/4" size SCREW. I read this that 41-W-2450 is the same wrench the entire time, but the method of defining the size changed somewhere between October 1942 and July 1944.
Matt
1970 Kaiser Jeep DJ-5A Left Hand Drive
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
1945 Corps of Engineers Welder & Trailer
1943 G518 "Ben Hur" Trailer Steel Body
194* G518 "Ben Hur" Trailer Composite Body
http://g518parts.com/
- Wingnutt
- G-Lieutenant General
- Posts: 5029
- Joined: Mon Oct 24, 2011 1:17 pm
- Location:
Re: GMTK-MVMTS Excel Spreadsheet
We talked about this before, but I can't remember what thread and I am too lazy to try to find it. It makes sense, and many of us found it odd that the spec could change that dramatically (essentially, an order of magnitude) - which implies set screws with hex openings that were twice as large suddenly being twice as small, and probably implying the same for the diameter of the screw, which the April and July 1945 specs seem to suggest - without changing the FSN. But the 1942 SNL isn't specifying the screw, it's specifying the wrench. It reads, WRENCH, safety screw, 3/16" hexagon (and so forth for the other sizes as well). That's not just a different method, that's explicit. A different method for a set screw wrench with a 3/32" hex opening would've been, WRENCH, safety screw, screw size 3/16 in. or perhaps WRENCH, safety screw, 3/16". It's that "hexagon" following the size that's hard to read any other way. The term "3/16" hex" doesn't make me think of a 3/16" set screw with a 3/32" hex opening. If that's what they intended, it's not just wrong, but woefully so.Rustman wrote: ↑Thu Mar 22, 2018 4:28 amI believe I am reading this that the July 1945 specification spelled out that this is an 1/8" size WRENCH for a 1/4" size SCREW. I read this that 41-W-2450 is the same wrench the entire time, but the method of defining the size changed somewhere between October 1942 and July 1944.
Hopefully we can find a 3rd party document some day to resolve it.
I usually grab any "Allen" wrenches I can find from 3/32" to 3/8" and cover all the bases.
TEMPORARY DUTY
Who is online
Users browsing this forum: No registered users and 43 guests