Skip to content
  • Categories
  • Recent
  • Popular
  • World
Skins
  • Light
  • Dark

Collapse

NodeBB

SAK dating info

Scheduled Pinned Locked Moved Swiss Army Knights Forum
40 Posts 1 Posters 9.9k Views
  • 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.
  • detronD
    detronD
    detron
    wrote on last edited by detron
    #21

    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
    0
    • detronD
      detronD
      detron
      wrote on last edited by
      #22

      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
      0
      • sLaughterMedS
        sLaughterMedS
        sLaughterMed
        wrote on last edited by
        #23

        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
        0
        • SAK GuyS
          SAK GuyS
          SAK Guy
          wrote on last edited by
          #24

          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
          0
          • detronD
            detronD
            detron
            wrote on last edited by
            #25

            @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
            0
            • detronD
              detronD
              detron
              wrote on last edited by
              #26

              @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
              0
              • sLaughterMedS
                sLaughterMedS
                sLaughterMed
                wrote on last edited by
                #27

                @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
                0
                • SAK GuyS
                  SAK GuyS
                  SAK Guy
                  wrote on last edited by
                  #28

                  @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
                  0
                  • detronD
                    detronD
                    detron
                    wrote on last edited by
                    #29

                    @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
                    0
                    • SAK GuyS
                      SAK GuyS
                      SAK Guy
                      wrote on last edited by
                      #30

                      @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
                      0
                      • windsonW
                        windsonW
                        windson
                        wrote on last edited by windson
                        #31

                        @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
                        0
                        • detronD
                          detronD
                          detron
                          wrote on last edited by detron
                          #32

                          @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
                          0
                          • detronD
                            detronD
                            detron
                            wrote on last edited by
                            #33

                            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
                            0
                            • detronD
                              detronD
                              detron
                              wrote on last edited by
                              #34

                              problem fixed, here is the updated sheet

                              Download from Dropbox

                              1 Reply Last reply
                              0
                              • FolderBeholderF
                                FolderBeholderF
                                FolderBeholder
                                wrote on last edited by
                                #35

                                Handyman with XLT:


                                1 Reply Last reply
                                0
                                • YanossauroY
                                  YanossauroY
                                  Yanossauro
                                  wrote on last edited by
                                  #36

                                  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
                                  0
                                  • N
                                    N
                                    nate j
                                    wrote on last edited by
                                    #37

                                    @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
                                    0
                                    • HuntsmanH
                                      HuntsmanH
                                      Huntsman
                                      Global Moderators
                                      wrote on last edited by
                                      #38

                                      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
                                      0
                                      • YanossauroY
                                        YanossauroY
                                        Yanossauro
                                        wrote on last edited by
                                        #39

                                        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
                                        0
                                        • HuntsmanH
                                          HuntsmanH
                                          Huntsman
                                          Global Moderators
                                          wrote on last edited by
                                          #40

                                          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
                                          0

                                          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

                                          • Login

                                          • Don't have an account? Register

                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Popular
                                          • World