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

    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

    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.

    repeat for each trait

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

    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

    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.

    1 Reply Last reply
    0
    • comisC
      comisC
      comis
      wrote on last edited by
      #2

      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:

      1 Reply Last reply
      0
      • detronD
        detronD
        detron
        wrote on last edited by
        #3

        I will do, thank you.

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

        1 Reply Last reply
        0
        • comisC
          comisC
          comis
          wrote on last edited by
          #4

          Thank you, and much appreciated it! :cheers:

          1 Reply Last reply
          0
          • E
            E
            eddie1115
            wrote on last edited by
            #5

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

            1 Reply Last reply
            0
            • MonrogueM
              MonrogueM
              Monrogue
              wrote on last edited by
              #6

              Very nice Detron, and good work :salute:

              1 Reply Last reply
              0
              • Rich SR
                Rich SR
                Rich S
                wrote on last edited by
                #7

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

                  Great idea and nicely executed!

                  1 Reply Last reply
                  0
                  • S
                    S
                    Storky
                    wrote on last edited by
                    #9

                    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
                    0
                    • AlephZeroA
                      AlephZeroA
                      AlephZero
                      wrote on last edited by
                      #10

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

                      1 Reply Last reply
                      0
                      • detronD
                        detronD
                        detron
                        wrote on last edited by detron
                        #11

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

                                          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