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

Collapse

NodeBB

A SAK dating beginner tool in excel

Scheduled Pinned Locked Moved Swiss Army Knights Forum
23 Posts 1 Posters 5.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.
  • gustophersmobG
    gustophersmobG
    gustophersmob
    wrote on last edited by
    #12

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

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

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

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

            @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
            0
            • comisC
              comisC
              comis
              wrote on last edited by
              #17

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

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

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

                    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
                    0
                    • AdmSlcA
                      AdmSlcA
                      AdmSlc
                      wrote on last edited by
                      #21

                      Great work!!

                      1 Reply Last reply
                      0
                      • windsonW
                        windsonW
                        windson
                        wrote on last edited by
                        #22

                        @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
                        0
                        • LeaFL
                          LeaFL
                          LeaF
                          wrote on last edited by
                          #23

                          Great work, thanks!

                          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