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

91mm Identification spreadsheet

Scheduled Pinned Locked Moved Swiss Army Knights Forum
14 Posts 1 Posters 2.4k Views
  1. Home
  2. Tool Talk
  3. Swiss Army Knights Forum
  4. 91mm Identification spreadsheet
91mm Identification spreadsheet
  • 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.
  • CanadianLMfan Offline
    CanadianLMfan
    Posts: 3,334
    CanadianLMfan Offline
    CanadianLMfan
    wrote on last edited by
    #1 Quote Reply

      Very helpful!

      1 Reply Last reply
      • detron Offline
        detron
        Posts: 7,546
        detron Offline
        detron
        wrote on last edited by
        #2 Quote Reply

          OK, so I see Google Drive gives some stupid preview.

          I recommend downloading the file, and using the filter drop-downs to match tools with.

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

              It won't let me zoom in on my phone but by straining to look close it looks really good

              1 Reply Last reply
              • detron Offline
                detron
                Posts: 7,546
                detron Offline
                detron
                wrote on last edited by
                #4 Quote Reply

                  the visual grid is OK, but using the filter buttons to filter columns is the biggest help. this slowly whittles the list down making it easier to match a SAK (VIC 91) to it's name

                  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
                    #5 Quote Reply

                      Maybe this will help those who are unsure about the filters.

                      - YouTube

                      Auf YouTube findest du die angesagtesten Videos und Tracks. Außerdem kannst du eigene Inhalte hochladen und mit Freunden oder gleich der ganzen Welt teilen.

                      favicon

                      (www.youtube.com)

                      this video I just made is me using this spreadsheet's filters to drill down to identify SAKs

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

                          The only way to enable the filters on a Google Doc spreadsheet is to have it as a GD spreadsheet (rather than an Excel spreadsheet) and then enable editing for people that it's shared with.

                          Hosted on my account are the two below, the first one is editable and the second isn't, meaning if some twat deletes everything you can put it back using the second doc :)

                          Link Preview Image
                          SAK 91 Identifier

                          favicon

                          Google Docs (docs.google.com)

                          SAK 91 Identifier locked

                          favicon

                          Google Docs (docs.google.com)

                          1 Reply Last reply
                          • enki_ck Offline
                            enki_ck
                            Global Moderators
                            Posts: 20,936
                            enki_ck Offline
                            enki_ck
                            Global Moderators
                            wrote on last edited by
                            #7 Quote Reply

                              Very nice work. :hatsoff:

                              Is there a way to change text direction on GD? For the tool options fields.

                              Merit Badges
                              Juice Collector Level 1 Mod User Hacker Scale Changer EDCSource Buyer Multitool Encyclopedia User OCD Squad SAKWiki User Flashlight Time Lord Level 3
                              1 Reply Last reply
                              • detron Offline
                                detron
                                Posts: 7,546
                                detron Offline
                                detron
                                wrote on last edited by
                                #8 Quote Reply

                                  @enki_ck said:
                                  Very nice work. :hatsoff:

                                  Is there a way to change text direction on GD? For the tool options fields.

                                  Not sure, I was going to just upload it to the site, but xls nor xlsx were not approved extensions.

                                  It is on GD just as a place to download it from.
                                  I figured if people downloaded it, then they could use it or change it however they wanted, like highlighting the ones they have, or printing custom small lists, or whatever.

                                  Some time today I will convert it to av Google drive document and add another link

                                  Sent from my SPH-L720 using Tapatalk 2

                                  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
                                    #9 Quote Reply

                                      @Cupboard said:
                                      The only way to enable the filters on a Google Doc spreadsheet is to have it as a GD spreadsheet (rather than an Excel spreadsheet) and then enable editing for people that it's shared with.

                                      Hosted on my account are the two below, the first one is editable and the second isn't, meaning if some smurf deletes everything you can put it back using the second doc :)

                                      Link Preview Image
                                      SAK 91 Identifier

                                      favicon

                                      Google Docs (docs.google.com)

                                      SAK 91 Identifier locked

                                      favicon

                                      Google Docs (docs.google.com)

                                      Thank you for doing this, on my phone the tool titles are not showing up, I will try to make a better Web version

                                      Sent from my SPH-L720 using Tapatalk 2

                                      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
                                        #10 Quote Reply

                                          Excellent excellent work!

                                          Detron,

                                          I tried the spreadsheet on my excel, and one thing I notice is if I sort by layers of tools (from smallest to highest or highest to smallest), somehow the tool name on the left(or the features on the right) didn't change after sort. Am I missing something?

                                          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
                                            #11 Quote Reply

                                              OK, so Google drive will not let you change text direction, without doing word art for each cell. :think:

                                              So, if you have Microsoft Excel, Libra Office, Open Office, star office, and I am sure there are tons of open source spreadsheet applications, just download the file if you want.

                                              I like having something like this on my phone (not accessed by my phone from the internet) when I am at a flea market. cell service at a level that can do data is not always available.

                                              it took a good 8 or 9 hours to go through the info on SAKWiki and make this, so I really do not want to invest time to make it into any other format. if you want to do that, please feel free. I hope to do this for other sizes as time permits, but the 91mm was most important to me. I also like the fact that a spreadsheet can be sorted anyway the user wants, or new fields added to the existing data (weight, release year, discontinued, etc)

                                              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
                                                #12 Quote Reply

                                                  @comis said:
                                                  Excellent excellent work!

                                                  Detron,

                                                  I tried the spreadsheet on my excel, and one thing I notice is if I sort by layers of tools (from smallest to highest or highest to smallest), somehow the tool name on the left(or the features on the right) didn't change after sort. Am I missing something?

                                                  first what version of excel? (97, 2000, XP, 2003, 07,10)

                                                  also, I recommend any sorting be done by first selecting everything, either CTRL-A, or click the box in the upper left corner that is between the row numbers and the cell numbers.

                                                  it is possible to sort a single field, and it sounds like that is what you did. I recommend you download a fresh copy before trying again, just in case you did miss align the data.

                                                  if you need further help, let me know, I would be happy to help

                                                  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
                                                    #13 Quote Reply

                                                      @detron said:

                                                      @comis said:

                                                      Excellent excellent work!

                                                      Detron,

                                                      I tried the spreadsheet on my excel, and one thing I notice is if I sort by layers of tools (from smallest to highest or highest to smallest), somehow the tool name on the left(or the features on the right) didn't change after sort. Am I missing something?

                                                      first what version of excel? (97, 2000, XP, 2003, 07,10)

                                                      also, I recommend any sorting be done by first selecting everything, either CTRL-A, or click the box in the upper left corner that is between the row numbers and the cell numbers.

                                                      it is possible to sort a single field, and it sounds like that is what you did. I recommend you download a fresh copy before trying again, just in case you did miss align the data.

                                                      if you need further help, let me know, I would be happy to help

                                                      Thanks for the reply, problem solved.

                                                      I am working with an Office 2010.

                                                      I notice even if I highlight everything or any area that contains data, the sort still wouldn't do it for me. But if I highlight just the column of 'layers', and then use 'sort and filter' on the upper right of screen, 'expand selection', then the whole table will be sorted accordingly.

                                                      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

                                                      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. Home
                                                      2. Tool Talk
                                                      3. Swiss Army Knights Forum
                                                      4. 91mm Identification spreadsheet
                                                      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