Skip to content
Collapse
? [[global:guest]]
Unread Recent
HOME SEARCH PROFILE 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.
  • enki_ck Offline
    enki_ck
    Global Moderators
    Posts: 20,936
    enki_ck Offline
    enki_ck
    Global Moderators
    wrote on last edited by
    #19 Quote Reply

      Looking forward to the sample chapter. :tu:

      1 Reply Last reply
      • 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

                                                                                  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
                                                                                  • 2
                                                                                  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