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

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.
  • 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:

      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:

          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!

                  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

                      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:

                          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

                              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?

                                  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

                                      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.

                                          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.

                                              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

                                                  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:

                                                      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.

                                                          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.

                                                              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.

                                                                  1 Reply Last reply
                                                                  • AdmSlc Offline
                                                                    AdmSlc
                                                                    Posts: 776
                                                                    AdmSlc Offline
                                                                    AdmSlc
                                                                    wrote on last edited by
                                                                    #20 Quote Reply

                                                                      Great work!!

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

                                                                          @detron said:
                                                                          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.

                                                                          Awesome. This should prevent duplicate work.

                                                                          1 Reply Last reply
                                                                          • LeaF Offline
                                                                            LeaF
                                                                            Posts: 570
                                                                            LeaF Offline
                                                                            LeaF
                                                                            wrote on last edited by
                                                                            #22 Quote Reply

                                                                              Great work, thanks!

                                                                              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