Skip to content
Collapse
? [[global:guest]]
Unread Recent
HOME SEARCH PROFILE NOTIFICATIONS 0 MESSAGES 0 BOOKMARKS MEMBERS BADGES
Multitool.Org Forum
MultiTool.org • Community Header Space • Watch This Space

SAK dating info

Scheduled Pinned Locked Moved Swiss Army Knights Forum
40 Posts 1 Posters 9.9k Views
  1. Home
  2. Tool Talk
  3. Swiss Army Knights Forum
  4. SAK dating info
SAK dating info
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • detron Offline
    detron
    Posts: 7,546
    detron Offline
    detron
    wrote on last edited by detron
    #20 Quote Reply

      so I decided to try a new approach at an inventory spreadsheet that helps date the SAK as well. I am trying to make this into a database, but I know excel so much better than Access, so I wanted to test my proof of concept in a format I understand.

      I know this is NOT the way many people would do it, but I thought if anyone wanted my sheet, then I would share it

      the video description of this spreadhsheet can be watched here

      https://youtu.be/vUuZ46gAJko

      after watching the video, read below

      near the end of the video I discus the pin hole on the scales. as it turns out those scales were replaced, so the SAK is 1987-1990, not TRANS 1990-1991 as I said. I was too lazy to do that video over.

      the file is located here

      now, another thing I am working on slowly with this spreadsheet is using pictures in comments. if you go to the "front tools table" sheet and hover over the different can openers, you will see them pop up.

      1 Reply Last reply
      • detron Offline
        detron
        Posts: 7,546
        detron Offline
        detron
        wrote on last edited by
        #21 Quote Reply

          the tables are all stored in the other sheets (Front Tools Table, Back Tools Table, Tang, and Other Tables) and the the "Model Name" is pulled from the "91mm ID" sheet if you have a model not in the drop down, just simple add it to the table in question and it will show up in the drop down.

          1 Reply Last reply
          • sLaughterMed Offline
            sLaughterMed
            Posts: 3,450
            sLaughterMed Offline
            sLaughterMed
            wrote on last edited by
            #22 Quote Reply

              Detron, I think this excel spreadsheet thing is probably a very good idea, but I cant help but feel very intimidated by it (and im a pretty young guy, and fairly computer literate, to boot). Admittedly, I havent watched the video yet, but I can only imagine how some of our computer illiterate members feel reading that.

              So my point is... Is there a manual I can read? :think:

              1 Reply Last reply
              • SAK Guy Offline
                SAK Guy
                Posts: 23,929
                SAK Guy Offline
                SAK Guy
                wrote on last edited by
                #23 Quote Reply

                  I don't have MS Office so it won't open.....I was hoping there was a giant jpeg or pdf of of the chart that I could look at. :facepalm:

                  1 Reply Last reply
                  • detron Offline
                    detron
                    Posts: 7,546
                    detron Offline
                    detron
                    wrote on last edited by
                    #24 Quote Reply

                      @SAK Guy said:
                      I don't have MS Office so it won't open.....I was hoping there was a giant jpeg or pdf of of the chart that I could look at. :facepalm:

                      if you have open office or Libre Office I will save in a format you can use. if not I will make it work for you one way or another

                      1 Reply Last reply
                      • detron Offline
                        detron
                        Posts: 7,546
                        detron Offline
                        detron
                        wrote on last edited by
                        #25 Quote Reply

                          @sLaughterMed said:
                          Detron, I think this excel spreadsheet thing is probably a very good idea, but I cant help but feel very intimidated by it (and im a pretty young guy, and fairly computer literate, to boot). Admittedly, I havent watched the video yet, but I can only imagine how some of our computer illiterate members feel reading that.

                          So my point is... Is there a manual I can read? :think:

                          the video is a short manual

                          1 Reply Last reply
                          • sLaughterMed Offline
                            sLaughterMed
                            Posts: 3,450
                            sLaughterMed Offline
                            sLaughterMed
                            wrote on last edited by
                            #26 Quote Reply

                              @detron said:

                              @sLaughterMed said:

                              Detron, I think this excel spreadsheet thing is probably a very good idea, but I cant help but feel very intimidated by it (and im a pretty young guy, and fairly computer literate, to boot). Admittedly, I havent watched the video yet, but I can only imagine how some of our computer illiterate members feel reading that.

                              So my point is... Is there a manual I can read? :think:

                              the video is a short manual

                              Just finished watching. Gotta say, that was much easier looking than I thought. Great job! :tu:

                              1 Reply Last reply
                              • SAK Guy Offline
                                SAK Guy
                                Posts: 23,929
                                SAK Guy Offline
                                SAK Guy
                                wrote on last edited by
                                #27 Quote Reply

                                  @detron said:

                                  @SAK Guy said:

                                  I don't have MS Office so it won't open.....I was hoping there was a giant jpeg or pdf of of the chart that I could look at. :facepalm:

                                  if you have open office or Libre Office I will save in a format you can use. if not I will make it work for you one way or another

                                  Thank you! I don't have any office apps on my laptop.

                                  1 Reply Last reply
                                  • detron Offline
                                    detron
                                    Posts: 7,546
                                    detron Offline
                                    detron
                                    wrote on last edited by
                                    #28 Quote Reply

                                      @SAK Guy said:

                                      @detron said:

                                      @SAK Guy said:

                                      I don't have MS Office so it won't open.....I was hoping there was a giant jpeg or pdf of of the chart that I could look at. :facepalm:

                                      if you have open office or Libre Office I will save in a format you can use. if not I will make it work for you one way or another

                                      Thank you! I don't have any office apps on my laptop.

                                      I will export this into a format you can use, but in the mean time, Libre Office is free, runs on Windows, Mac, or Linux, and is really nice.

                                      1 Reply Last reply
                                      • SAK Guy Offline
                                        SAK Guy
                                        Posts: 23,929
                                        SAK Guy Offline
                                        SAK Guy
                                        wrote on last edited by
                                        #29 Quote Reply

                                          @detron said:

                                          @SAK Guy said:

                                          @detron said:

                                          @SAK Guy said:

                                          I don't have MS Office so it won't open.....I was hoping there was a giant jpeg or pdf of of the chart that I could look at. :facepalm:

                                          if you have open office or Libre Office I will save in a format you can use. if not I will make it work for you one way or another

                                          Thank you! I don't have any office apps on my laptop.

                                          I will export this into a format you can use, but in the mean time, Libre Office is free, runs on Windows, Mac, or Linux, and is really nice.

                                          I'll work on getting Libre Office downloaded. :tu:

                                          1 Reply Last reply
                                          • windson Offline
                                            windson
                                            Posts: 616
                                            windson Offline
                                            windson
                                            wrote on last edited by windson
                                            #30 Quote Reply

                                              @detron said:
                                              so I decided to try a new approach at an inventory spreadsheet that helps date the SAK as well. I am trying to make this into a database, but I know excel so much better than Access, so I wanted to test my proof of concept in a format I understand.

                                              I know this is NOT the way many people would do it, but I thought if anyone wanted my sheet, then I would share it

                                              the video description of this spreadhsheet can be watched here

                                              https://youtu.be/vUuZ46gAJko

                                              after watching the video, read below

                                              near the end of the video I discus the pin hole on the scales. as it turns out those scales were replaced, so the SAK is 1987-1990, not TRANS 1990-1991 as I said. I was too lazy to do that video over.

                                              the file is located here

                                              now, another thing I am working on slowly with this spreadsheet is using pictures in comments. if you go to the "front tools table" sheet and hover over the different can openers, you will see them pop up.

                                              This is great! (Spreadsheets FTW)

                                              1 Reply Last reply
                                              • detron Offline
                                                detron
                                                Posts: 7,546
                                                detron Offline
                                                detron
                                                wrote on last edited by detron
                                                #31 Quote Reply

                                                  @detron said:
                                                  so I decided to try a new approach at an inventory spreadsheet that helps date the SAK as well. I am trying to make this into a database, but I know excel so much better than Access, so I wanted to test my proof of concept in a format I understand.

                                                  I know this is NOT the way many people would do it, but I thought if anyone wanted my sheet, then I would share it

                                                  the video description of this spreadhsheet can be watched here

                                                  https://youtu.be/vUuZ46gAJko

                                                  after watching the video, read below

                                                  near the end of the video I discus the pin hole on the scales. as it turns out those scales were replaced, so the SAK is 1987-1990, not TRANS 1990-1991 as I said. I was too lazy to do that video over.

                                                  the file is located here

                                                  now, another thing I am working on slowly with this spreadsheet is using pictures in comments. if you go to the "front tools table" sheet and hover over the different can openers, you will see them pop up.

                                                  this should have said 1987 - 1990, not 1978-1990.

                                                  MODs, can you fix that in the post to avoid further confusion? thank you

                                                  1 Reply Last reply
                                                  • detron Offline
                                                    detron
                                                    Posts: 7,546
                                                    detron Offline
                                                    detron
                                                    wrote on last edited by
                                                    #32 Quote Reply

                                                      found a bug in the spreadsheet. :facepalm:

                                                      I will have it fixed and uploaded in the next day or so. I forgot to lock some cell references, so the first entry will work great, but subsequent rows will be wrong.

                                                      I will post here when done

                                                      1 Reply Last reply
                                                      • detron Offline
                                                        detron
                                                        Posts: 7,546
                                                        detron Offline
                                                        detron
                                                        wrote on last edited by
                                                        #33 Quote Reply

                                                          problem fixed, here is the updated sheet

                                                          Download from Dropbox

                                                          1 Reply Last reply
                                                          • FolderBeholder Offline
                                                            FolderBeholder
                                                            Posts: 7,795
                                                            FolderBeholder Offline
                                                            FolderBeholder
                                                            wrote on last edited by
                                                            #34 Quote Reply

                                                              Handyman with XLT:


                                                              1 Reply Last reply
                                                              • Yanossauro Offline
                                                                Yanossauro
                                                                Posts: 179
                                                                Yanossauro Offline
                                                                Yanossauro
                                                                wrote on last edited by
                                                                #35 Quote Reply

                                                                  I have been trying to get to it all morning but I just get an error message from Dropbox.

                                                                  Is everything all right?

                                                                  @detron said:
                                                                  problem fixed, here is the updated sheet

                                                                  Download from Dropbox

                                                                  1 Reply Last reply
                                                                  • nate j Offline
                                                                    nate j
                                                                    Posts: 6,226
                                                                    nate j Offline
                                                                    nate j
                                                                    wrote on last edited by
                                                                    #36 Quote Reply

                                                                      @Yanossauro said:
                                                                      I have been trying to get to it all morning but I just get an error message from Dropbox.

                                                                      Is everything all right?

                                                                      You’re trying to pull up a spreadsheet from a member’s personal dropbox that was originally posted 9+ years ago, when that member hasn’t been online here for 3+ years. So, I’m not shocked that the link no longer works.

                                                                      If you have SAK dating questions, note that all the info is in SAKwiki; the spreadsheet was just an attempt to put it into an easier-to-use format. And if you can’t find the answer to your question in SAKwiki, you can always post your question here, though I would recommend starting a new thread for it.
                                                                      :cheers:

                                                                      1 Reply Last reply
                                                                      • Huntsman Offline
                                                                        Huntsman
                                                                        Global Moderators
                                                                        Posts: 5,781
                                                                        Huntsman Offline
                                                                        Huntsman
                                                                        Global Moderators
                                                                        wrote on last edited by
                                                                        #37 Quote Reply

                                                                          Thanks Nate - Spot on

                                                                          However @Yanaussauro - I do have a copy of Detron's sheet - So if you PM me an email address I can send it to you.

                                                                          Hopefully you have also seen this table, which works just as well
                                                                          /topic/51872

                                                                          And the other posts in this thread
                                                                          /topic/75774

                                                                          1 Reply Last reply
                                                                          • Yanossauro Offline
                                                                            Yanossauro
                                                                            Posts: 179
                                                                            Yanossauro Offline
                                                                            Yanossauro
                                                                            wrote on last edited by
                                                                            #38 Quote Reply

                                                                              Yes, I know it is an old topic, and am aware that the member is out od contact, and yes, I have been dating my SAKs through SAKWiki for the last couple of three years, but this would be an easier way of getting 40+ SAKs dated in an evening.

                                                                              Well, back to 5 pages open to date a knife.

                                                                              @nate j said:
                                                                              You’re trying to pull up a spreadsheet from a member’s personal dropbox that was originally posted 9+ years ago, when that member hasn’t been online here for 3+ years. So, I’m not shocked that the link no longer works.

                                                                              If you have SAK dating questions, note that all the info is in SAKwiki; the spreadsheet was just an attempt to put it into an easier-to-use format. And if you can’t find the answer to your question in SAKwiki, you can always post your question here, though I would recommend starting a new thread for it.
                                                                              :cheers:

                                                                              1 Reply Last reply
                                                                              • Huntsman Offline
                                                                                Huntsman
                                                                                Global Moderators
                                                                                Posts: 5,781
                                                                                Huntsman Offline
                                                                                Huntsman
                                                                                Global Moderators
                                                                                wrote on last edited by
                                                                                #39 Quote Reply

                                                                                  You don't need five pages open to date a knife - You just need this

                                                                                  Find the tools/features in your knife in the top row - Go down the column for each tool until you get to the version that matches each tool. When you have done this it should just give you a single row or group of rows. Go to the first column for that row (those rows) and you have a date or date range your knife!

                                                                                  I found this a lot easier to use than Detron's spreadsheet - But I could be a little biased
                                                                                  Will send it Detron's to you anyway.

                                                                                  1 Reply Last reply

                                                                                  Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                                                                                  Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                                                                                  With your input, this post could be even better 💗

                                                                                  Register Login

                                                                                  1. Home
                                                                                  2. Tool Talk
                                                                                  3. Swiss Army Knights Forum
                                                                                  4. SAK dating info
                                                                                  Reply
                                                                                  • Reply as topic
                                                                                  Log in to reply
                                                                                  COMMUNITY LINKS
                                                                                  EDC-TV SAKWiki GearFeed SAKSelector
                                                                                  Operational Funds

                                                                                  Help us keep the Unworkable working!

                                                                                  Make A Donation
                                                                                  November Goal: $300.00
                                                                                  Due Date: Nov 30
                                                                                  Total Receipts: $0.00
                                                                                  Below Goal: $300.00
                                                                                  0% funded
                                                                                  • Login

                                                                                  • Don't have an account? Register

                                                                                  • Login or register to search.
                                                                                  • First post
                                                                                    Last post
                                                                                  0