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

A SAK dating beginner tool in excel

Scheduled Pinned Locked Moved Swiss Army Knights Forum
23 Posts 1 Posters 5.9k Views
  1. Home
  2. Tool Talk
  3. Swiss Army Knights Forum
  4. A SAK dating beginner tool in excel
A SAK dating beginner tool in excel
  • 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
    Quote Reply

      First, the information used to make this comes from many members here on this forum, I have used every scrap of data I could find, and that is only possible because people here share. thank you.

      my desire was first a filtered sheet that as you filter more and more, the date range shrinks. I still use this, but I thought I would try a different approach.
      so this sheet allows you to use a drop down, and choose "Yes" and as you continue to do this, shrink the creation range.
      this is no where near as in-depth as users like @jazzbass can determine, but for a new collector, it might be very useful.

      so, how does it work,

      well you have this sheet

      You may have to click the bar to make the image larger

      <a href="http://s833.photobucket.com/user/detronphillips/media/excel/Microsoft Excel - SAK Master.xlsx_005.png.html" target="_blank" rel="noopener noreferrer"><img src="http://i833.photobucket.com/albums/zz255/detronphillips/excel/Microsoft Excel - SAK Master.xlsx_005.png" alt="banner" style="max-width: 100%; height: auto;" /></a>

      in the "Trait" column find a row that has a trait that your knife has and then in the "Present?" column, click and select "Yes" from the drop down.

      <a href="http://s833.photobucket.com/user/detronphillips/media/excel/Microsoft Excel - SAK Master.xlsx_008.png.html" target="_blank" rel="noopener noreferrer"><img src="http://i833.photobucket.com/albums/zz255/detronphillips/excel/Microsoft Excel - SAK Master.xlsx_008.png" alt="banner" style="max-width: 100%; height: auto;" /></a>

      repeat for each trait

      <a href="http://s833.photobucket.com/user/detronphillips/media/excel/Microsoft Excel - SAK Master.xlsx_009.png.html" target="_blank" rel="noopener noreferrer"><img src="http://i833.photobucket.com/albums/zz255/detronphillips/excel/Microsoft Excel - SAK Master.xlsx_009.png" alt="banner" style="max-width: 100%; height: auto;" /></a>

      ignore that "No" in the picture, that is not really there, but made it to my screen shot

      <a href="http://s833.photobucket.com/user/detronphillips/media/excel/Microsoft Excel - SAK Master.xlsx_010.png.html" target="_blank" rel="noopener noreferrer"><img src="http://i833.photobucket.com/albums/zz255/detronphillips/excel/Microsoft Excel - SAK Master.xlsx_010.png" alt="banner" style="max-width: 100%; height: auto;" /></a>

      notice out to the right the "Age Range" and the green "Valid Configuration"

      if you select a mixture that should not exist, the sheet tries to let you know.

      from our example, we have a SAK from 1983 through 1985, but if we say it has a cybertool (that came out in 1999) the sheet warns about this and you can tell based on the date range why it does this

      <a href="http://s833.photobucket.com/user/detronphillips/media/excel/Microsoft Excel - SAK Master.xlsx_011.png.html" target="_blank" rel="noopener noreferrer"><img src="http://i833.photobucket.com/albums/zz255/detronphillips/excel/Microsoft Excel - SAK Master.xlsx_011.png" alt="banner" style="max-width: 100%; height: auto;" /></a>

      for those who care, Each time you select a trait, it adds the start date of that trait to a cell, and the end date to another.
      to narrow down the range, I took the MAX start date, for the lower date, and the MIN end date for the higher date.
      if the start date is greater than the end date, an error is displayed.

      if you are interested in this basic spreadsheet, please let me know here and I will share it through a link.

      Merit Badges
      Hacker EDCSource Buyer Time Lord Level 3 Paracord MTO Tool Scaler User Hook User Scale Changer OCD Squad
      1 Reply Last reply
      • comis Offline
        comis
        Posts: 11,394
        comis Offline
        comis
        wrote on last edited by
        #1 Quote Reply

          Hi, Detron.

          I am very interested in this spreadsheet, could you please kindly share a link for download this? I'd love to give it a try. :drool:

          Merit Badges
          OCD Squad Hook User Flashlight One Piece Collector Time Lord Level 3 MTO Tool BO Tools Level 3 Juice Collector Level 1 Charge Collector ALOX with Scissors Mod User Scale Changer ALOX Colors Level 3 Stayglow SAK SAKMC Axe User Sporkman Toothpick User Duct Tape Fire Making Camo SAK The SUPER Challenge GEC Challenge Carabiner User MTo Anniversary Challenge 111mm Collector Level 3 Hacker Scaler User Fixed Blade Challenge Explorer 30 Day Challenge EDCSource Buyer Jack'O Lantern Badge 30 Day Axe Challenge Airgun User Discontinued SAK/MT Challenge PST 30 Day Challenge Slasher User Calendar 2020 Buck 112 Ranger 30 Day Challenge Fieldmaster 30 Day Challenge Victorinox SwissTool Challenge SAK STACK Challenge 30 Days Soldier 30 Day Challenge 30 Blades 30 Days Traditional Folder Challenge Spyderco 30 Day Challenge The Nessmuk Challenge MTo Store User Buck User Skeletool 30 Day Challenge Minimal SAK Challenge 30 day EDC Challenge 30 Day Weight-loss Challenge Chili Award 111mm SAK Challenge Poker Face Challenge Mad Max Challenge Titanium Hobo User Buck 110 Challenge Folding Hunter 30 days Challenge Gas Station MRE challenge 30 day challenge - 58, 65 and 74mm SAKs Daredevil challenge Delemont 30 Day Challenge Chuck Yeager Challenge Soldier On 90 Day Challenge Pen Challenge Loaded Pockets 30 Day Challenge Photographer 30 Day TWEEN Challenge - 84 and 85mm SAKs Case XX 30 Day Challenge Alox Addict Challenge Country of Origin 30 Day Challenge Spirit 60 Day Challenge 30 Day Flashlight Challenge
          1 Reply Last reply
          • detron Offline
            detron
            Posts: 7,546
            detron Offline
            detron
            wrote on last edited by
            #2 Quote Reply

              I will do, thank you.

              give me a day to clean it up and upload it. I will post here once it is available

              Merit Badges
              Hacker EDCSource Buyer Time Lord Level 3 Paracord MTO Tool Scaler User Hook User Scale Changer OCD Squad
              1 Reply Last reply
              • comis Offline
                comis
                Posts: 11,394
                comis Offline
                comis
                wrote on last edited by
                #3 Quote Reply

                  Thank you, and much appreciated it! :cheers:

                  Merit Badges
                  OCD Squad Hook User Flashlight One Piece Collector Time Lord Level 3 MTO Tool BO Tools Level 3 Juice Collector Level 1 Charge Collector ALOX with Scissors Mod User Scale Changer ALOX Colors Level 3 Stayglow SAK SAKMC Axe User Sporkman Toothpick User Duct Tape Fire Making Camo SAK The SUPER Challenge GEC Challenge Carabiner User MTo Anniversary Challenge 111mm Collector Level 3 Hacker Scaler User Fixed Blade Challenge Explorer 30 Day Challenge EDCSource Buyer Jack'O Lantern Badge 30 Day Axe Challenge Airgun User Discontinued SAK/MT Challenge PST 30 Day Challenge Slasher User Calendar 2020 Buck 112 Ranger 30 Day Challenge Fieldmaster 30 Day Challenge Victorinox SwissTool Challenge SAK STACK Challenge 30 Days Soldier 30 Day Challenge 30 Blades 30 Days Traditional Folder Challenge Spyderco 30 Day Challenge The Nessmuk Challenge MTo Store User Buck User Skeletool 30 Day Challenge Minimal SAK Challenge 30 day EDC Challenge 30 Day Weight-loss Challenge Chili Award 111mm SAK Challenge Poker Face Challenge Mad Max Challenge Titanium Hobo User Buck 110 Challenge Folding Hunter 30 days Challenge Gas Station MRE challenge 30 day challenge - 58, 65 and 74mm SAKs Daredevil challenge Delemont 30 Day Challenge Chuck Yeager Challenge Soldier On 90 Day Challenge Pen Challenge Loaded Pockets 30 Day Challenge Photographer 30 Day TWEEN Challenge - 84 and 85mm SAKs Case XX 30 Day Challenge Alox Addict Challenge Country of Origin 30 Day Challenge Spirit 60 Day Challenge 30 Day Flashlight Challenge
                  1 Reply Last reply
                  • eddie1115 Offline
                    eddie1115
                    Posts: 1,760
                    eddie1115 Offline
                    eddie1115
                    wrote on last edited by
                    #4 Quote Reply

                      This is excellent! I'd love the link as well when it's ready :salute:

                      Merit Badges
                      Camping Scaler User BO Tools Level 1 Flashlight Mod User ALOX Colors Level 1 Time Lord Level 2 ALOX with Scissors OCD Squad EDCSource Buyer LM Squirt Challenge Level 3 Hacker
                      1 Reply Last reply
                      • Monrogue Offline
                        Monrogue
                        Posts: 23,312
                        Monrogue Offline
                        Monrogue
                        wrote on last edited by
                        #5 Quote Reply

                          Very nice Detron, and good work :salute:

                          Merit Badges
                          Japanese PST The SUPER Challenge Hacker Mod User Flashlight Birth Year SAK Scaler User Time Lord Level 1 EDC Pocket Dump Challenge Def's 50k Challenge LM Rebar Challenge Titanium SAKMC Ignore LM Signal Challenge Modified SAK Challenge ALOX with Scissors MTO Tool MTo Store User SAK STACK Challenge 30 Days MTo Anniversary Challenge
                          1 Reply Last reply
                          • Rich S Offline
                            Rich S
                            Posts: 812
                            Rich S Offline
                            Rich S
                            wrote on last edited by
                            #6 Quote Reply

                              Neat idea. I tried something sort of like that from the data/info on sakwiki, but gave up; to complicated for a flow chart approach; the spread sheet just might work well. Looking forward to trying it out.
                              Rich

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

                                  Great idea and nicely executed!

                                  Merit Badges
                                  Time Lord Level 1 Hook User ALOX with Scissors Flashlight Stargazer
                                  1 Reply Last reply
                                  • Storky Offline
                                    Storky
                                    Posts: 586
                                    Storky Offline
                                    Storky
                                    wrote on last edited by
                                    #8 Quote Reply

                                      Great idea and excellent work. Thanks for that :salute:
                                      I'm also very interessted in trying the sheet.
                                      Thanks and regards.

                                      Markus

                                      Merit Badges
                                      Hook User SAKMC
                                      1 Reply Last reply
                                      • AlephZero Offline
                                        AlephZero
                                        Posts: 7,637
                                        AlephZero Offline
                                        AlephZero
                                        wrote on last edited by
                                        #9 Quote Reply

                                          Excellent work, Detron, that will definitely come in handy! :tu: :cheers:

                                          Merit Badges
                                          Flashlight Paracord Photographer MTO Tool EDCSource Buyer Scale Changer ALOX Colors Level 1 BO Tools Level 1 Stargazer OCD Squad Ignore Duct Tape Carabiner User Titanium Time Lord Level 1 Sporkman Zip Tie User
                                          1 Reply Last reply
                                          • detron Offline
                                            detron
                                            Posts: 7,546
                                            detron Offline
                                            detron
                                            wrote on last edited by detron
                                            #10 Quote Reply

                                              here is the link shared via Google Drive, if this does not work, I will put it up on Dropbox tonight when I get home.

                                              Please download and use it, do not let Google Docs be your viewer.

                                              https://drive.google.com/file/d/0B96d3YZxO2vrNUw0WWZvTkhTVGc/view?usp=sharing

                                              there are other tabs that allow a person to ID a SAK based on tool configuration (for most sizes of Vics anyway)
                                              and a tab that uses the filter approach to date a SAK (the data that inspired my other sheet)

                                              PS. the last two "traits" that deal with Tang stamps are ONLY for 1974 and newer, in my collection this is the vast majority of my SAKs. there is a lot more tang info in the forum

                                              Merit Badges
                                              Hacker EDCSource Buyer Time Lord Level 3 Paracord MTO Tool Scaler User Hook User Scale Changer OCD Squad
                                              1 Reply Last reply
                                              • gustophersmob Offline
                                                gustophersmob
                                                Posts: 5,170
                                                gustophersmob Offline
                                                gustophersmob
                                                wrote on last edited by
                                                #11 Quote Reply

                                                  Very cool, and useful! Thanks!

                                                  I did notice if you select "can Opener Current," the age range is 1980 - 2016. I have several knives from the 70's with a current can opener, no "+PAT." Or am I misunderstanding it?

                                                  Merit Badges
                                                  SAKMC Fire Making Ignore Zip Tie User ALOX Colors Level 1 Birth Year SAK Time Lord Level 3 Mod User Photographer Camping Flashlight Mora User Paracord Slasher User Titanium MTo Store User EDC Pocket Dump Challenge SAKWiki User Gun User ALOX with Scissors MTO Tool Santa Hook User OCD Squad Duct Tape Carabiner User 111mm SAK Challenge Scale Changer Hacker Buck User EDCSource Buyer Minimal SAK Challenge Victorinox Spirit Challenge Jack'O Lantern Badge Toothpick User Outdoor Cook Fishing Chainsaw User Alox Addict Challenge Wally Badge Meme Creator Badge Axe User 30 Day Ratchet Challenge  Classic 30 Day Challenge Soldier 30 Day Challenge 20th Anniversary Anything Goes Challenge
                                                  1 Reply Last reply
                                                  • detron Offline
                                                    detron
                                                    Posts: 7,546
                                                    detron Offline
                                                    detron
                                                    wrote on last edited by
                                                    #12 Quote Reply

                                                      @gustophersmob said:
                                                      Very cool, and useful! Thanks!

                                                      I did notice if you select "can Opener Current," the age range is 1980 - 2016. I have several knives from the 70's with a current can opener, no "+PAT." Or am I misunderstanding it?

                                                      you are correct, all I had to go by is the data I had, which is sometimes wrong. good catch and info though

                                                      Merit Badges
                                                      Hacker EDCSource Buyer Time Lord Level 3 Paracord MTO Tool Scaler User Hook User Scale Changer OCD Squad
                                                      1 Reply Last reply
                                                      • detron Offline
                                                        detron
                                                        Posts: 7,546
                                                        detron Offline
                                                        detron
                                                        wrote on last edited by
                                                        #13 Quote Reply

                                                          if anyone has info that can be changed (more specific date ranges) let me know and I will update the sheet.

                                                          Merit Badges
                                                          Hacker EDCSource Buyer Time Lord Level 3 Paracord MTO Tool Scaler User Hook User Scale Changer OCD Squad
                                                          1 Reply Last reply
                                                          • windson Offline
                                                            windson
                                                            Posts: 616
                                                            windson Offline
                                                            windson
                                                            wrote on last edited by
                                                            #14 Quote Reply

                                                              This is a really useful resource! Thank you for putting in the work.

                                                              Now, about the updates and small revisions; before you are starting to introduce decimal version numbers, why not make public on Google Drive with read access and everyone can use the latest version without having to update it again and again.

                                                              Merit Badges
                                                              Time Lord Level 1 Hook User ALOX with Scissors Flashlight Stargazer
                                                              1 Reply Last reply
                                                              • detron Offline
                                                                detron
                                                                Posts: 7,546
                                                                detron Offline
                                                                detron
                                                                wrote on last edited by
                                                                #15 Quote Reply

                                                                  @windson said:
                                                                  This is a really useful resource! Thank you for putting in the work.

                                                                  Now, about the updates and small revisions; before you are starting to introduce decimal version numbers, why not make public on Google Drive with read access and everyone can use the latest version without having to update it again and again.

                                                                  I can do that, it is shared via Google docs right now, but I will see about making it wide open to the public.

                                                                  maybe tomorrow

                                                                  Merit Badges
                                                                  Hacker EDCSource Buyer Time Lord Level 3 Paracord MTO Tool Scaler User Hook User Scale Changer OCD Squad
                                                                  1 Reply Last reply
                                                                  • comis Offline
                                                                    comis
                                                                    Posts: 11,394
                                                                    comis Offline
                                                                    comis
                                                                    wrote on last edited by
                                                                    #16 Quote Reply

                                                                      Hey, Detron.

                                                                      Just downloaded the sheet and playing with it, very cool and awesome function. Haven't tested it with some of my dated SAKs, but this certainly is a big step forward from the last SAK 58-74-75-84-91 Identifier! Great Job! :cheers:

                                                                      Merit Badges
                                                                      OCD Squad Hook User Flashlight One Piece Collector Time Lord Level 3 MTO Tool BO Tools Level 3 Juice Collector Level 1 Charge Collector ALOX with Scissors Mod User Scale Changer ALOX Colors Level 3 Stayglow SAK SAKMC Axe User Sporkman Toothpick User Duct Tape Fire Making Camo SAK The SUPER Challenge GEC Challenge Carabiner User MTo Anniversary Challenge 111mm Collector Level 3 Hacker Scaler User Fixed Blade Challenge Explorer 30 Day Challenge EDCSource Buyer Jack'O Lantern Badge 30 Day Axe Challenge Airgun User Discontinued SAK/MT Challenge PST 30 Day Challenge Slasher User Calendar 2020 Buck 112 Ranger 30 Day Challenge Fieldmaster 30 Day Challenge Victorinox SwissTool Challenge SAK STACK Challenge 30 Days Soldier 30 Day Challenge 30 Blades 30 Days Traditional Folder Challenge Spyderco 30 Day Challenge The Nessmuk Challenge MTo Store User Buck User Skeletool 30 Day Challenge Minimal SAK Challenge 30 day EDC Challenge 30 Day Weight-loss Challenge Chili Award 111mm SAK Challenge Poker Face Challenge Mad Max Challenge Titanium Hobo User Buck 110 Challenge Folding Hunter 30 days Challenge Gas Station MRE challenge 30 day challenge - 58, 65 and 74mm SAKs Daredevil challenge Delemont 30 Day Challenge Chuck Yeager Challenge Soldier On 90 Day Challenge Pen Challenge Loaded Pockets 30 Day Challenge Photographer 30 Day TWEEN Challenge - 84 and 85mm SAKs Case XX 30 Day Challenge Alox Addict Challenge Country of Origin 30 Day Challenge Spirit 60 Day Challenge 30 Day Flashlight Challenge
                                                                      1 Reply Last reply
                                                                      • detron Offline
                                                                        detron
                                                                        Posts: 7,546
                                                                        detron Offline
                                                                        detron
                                                                        wrote on last edited by
                                                                        #17 Quote Reply

                                                                          https://docs.google.com/spreadsheets/d/1li6pMLCt4TYWrqMHyAWzSJwM-LfIDDXJFfe-nIi2N-A/edit?usp=sharing

                                                                          here is a new link that hopefully gives edit rights to users.

                                                                          there is a tab called "Change Log" if you make a change, please just give info there that will help others know what was changed

                                                                          the issue with using Google Docs as the editor, is it cannot handle my vertical text. so I still recommend editing it in Excel or even Libre Office Calc.

                                                                          Merit Badges
                                                                          Hacker EDCSource Buyer Time Lord Level 3 Paracord MTO Tool Scaler User Hook User Scale Changer OCD Squad
                                                                          1 Reply Last reply
                                                                          • detron Offline
                                                                            detron
                                                                            Posts: 7,546
                                                                            detron Offline
                                                                            detron
                                                                            wrote on last edited by
                                                                            #18 Quote Reply

                                                                              @comis said:
                                                                              Hey, Detron.

                                                                              Just downloaded the sheet and playing with it, very cool and awesome function. Haven't tested it with some of my dated SAKs, but this certainly is a big step forward from the last SAK 58-74-75-84-91 Identifier! Great Job! :cheers:

                                                                              thanks, all that data is from SAKWiki, I just prefer using a filter to help narrow choices down. it took months to make those sheets.
                                                                              I am trying to learn new things and tricks in Excel, and if they become beneficial for the SAK sheet, I will include them.

                                                                              Merit Badges
                                                                              Hacker EDCSource Buyer Time Lord Level 3 Paracord MTO Tool Scaler User Hook User Scale Changer OCD Squad
                                                                              1 Reply Last reply
                                                                              • detron Offline
                                                                                detron
                                                                                Posts: 7,546
                                                                                detron Offline
                                                                                detron
                                                                                wrote on last edited by
                                                                                #19 Quote Reply

                                                                                  also if you un-hide the columns that are hidden, you can see the ranges for the traits. some people might like that better.

                                                                                  Merit Badges
                                                                                  Hacker EDCSource Buyer Time Lord Level 3 Paracord MTO Tool Scaler User Hook User Scale Changer OCD Squad
                                                                                  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. A SAK dating beginner tool in excel
                                                                                  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