Multitool.org
 
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
+-

Hello Lurker! Remove this ad and much more by logging in.


A SAK dating beginner tool in excel 1780

Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
A SAK dating beginner tool in excel
« on: September 16, 2015, 12:45:45 AM »
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.

If I can help, let me know 
Absolutely No Life Club Posts: 6,638
Re: A SAK dating beginner tool in excel
« Reply #1 on: September 16, 2015, 02:49:18 AM »
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:

Follow us on MTO Unleashed Challenge this month!
Free Magnets! Nessmuk Challenge in Sept
Comis Gear Youtube Channel
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: A SAK dating beginner tool in excel
« Reply #2 on: September 16, 2015, 03:06:08 AM »
I will do,  thank you.

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

If I can help, let me know 
Absolutely No Life Club Posts: 6,638
Re: A SAK dating beginner tool in excel
« Reply #3 on: September 16, 2015, 04:12:37 AM »
Thank you, and much appreciated it!  :cheers:

Follow us on MTO Unleashed Challenge this month!
Free Magnets! Nessmuk Challenge in Sept
Comis Gear Youtube Channel
No Life Club Posts: 1,760
Re: A SAK dating beginner tool in excel
« Reply #4 on: September 16, 2015, 05:14:35 AM »
This is excellent!  I'd love the link as well when it's ready :salute:
Absolute Zombie Club Posts: 23,211 Wooooo!
Re: A SAK dating beginner tool in excel
« Reply #5 on: September 16, 2015, 05:17:59 AM »
Very nice Detron, and good work :salute:

K-Tibbs
Hero Member Posts: 558 Wanted: Red Alox Tinker!!
Re: A SAK dating beginner tool in excel
« Reply #6 on: September 16, 2015, 06:12:05 AM »
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

------------------
There's intelligent life in the universe;
I just don't know where.
Hero Member Posts: 616 Observe - Evaluate - Control
Re: A SAK dating beginner tool in excel
« Reply #7 on: September 16, 2015, 08:50:10 AM »
Great idea and nicely executed!
Hero Member Posts: 586 A happy fart never comes from a miserable ass.
Re: A SAK dating beginner tool in excel
« Reply #8 on: September 16, 2015, 09:26:22 AM »
Great idea and excellent work. Thanks for that  :salute:
I'm also very interessted in trying the sheet.
Thanks and regards.

Markus
Absolutely No Life Club Posts: 7,487 Smurf smash!
Re: A SAK dating beginner tool in excel
« Reply #9 on: September 16, 2015, 09:46:42 AM »
Excellent work, Detron, that will definitely come in handy!  :tu: :cheers:

"Hoarder of weirdness,
Always posting random things,
I'm AlephZero" :ninja:
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: A SAK dating beginner tool in excel
« Reply #10 on: September 16, 2015, 04:04:15 PM »
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
« Last Edit: September 16, 2015, 04:05:23 PM by detron »

If I can help, let me know 
No Life Club Posts: 3,770 <><
Re: A SAK dating beginner tool in excel
« Reply #11 on: September 16, 2015, 09:44:32 PM »
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?

If the trees blew down the wind and no one was around, would the alphabet song really go backwards?
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: A SAK dating beginner tool in excel
« Reply #12 on: September 16, 2015, 10:50:34 PM »
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

If I can help, let me know 
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: A SAK dating beginner tool in excel
« Reply #13 on: September 16, 2015, 10:53:45 PM »
if anyone has info that can be changed (more specific date ranges) let me know and I will update the sheet.

If I can help, let me know 
Hero Member Posts: 616 Observe - Evaluate - Control
Re: A SAK dating beginner tool in excel
« Reply #14 on: September 16, 2015, 10:58:54 PM »
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.
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: A SAK dating beginner tool in excel
« Reply #15 on: September 17, 2015, 02:06:26 AM »
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

If I can help, let me know 
Absolutely No Life Club Posts: 6,638
Re: A SAK dating beginner tool in excel
« Reply #16 on: September 17, 2015, 02:15:46 AM »
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:

Follow us on MTO Unleashed Challenge this month!
Free Magnets! Nessmuk Challenge in Sept
Comis Gear Youtube Channel
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: A SAK dating beginner tool in excel
« Reply #17 on: September 17, 2015, 02:16:15 AM »
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.

If I can help, let me know 
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: A SAK dating beginner tool in excel
« Reply #18 on: September 17, 2015, 02:18:22 AM »
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.

If I can help, let me know 
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: A SAK dating beginner tool in excel
« Reply #19 on: September 17, 2015, 02:20:33 AM »
also if you un-hide  the columns that are hidden, you can see the ranges for the traits.  some people might like that better.

If I can help, let me know 
Hero Member Posts: 776 adm.slc@icloud.com
Re: A SAK dating beginner tool in excel
« Reply #20 on: September 17, 2015, 02:59:56 AM »
Great work!!
Hero Member Posts: 616 Observe - Evaluate - Control
Re: A SAK dating beginner tool in excel
« Reply #21 on: September 17, 2015, 08:48:19 AM »
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.
Sr. Member Posts: 491
Re: A SAK dating beginner tool in excel
« Reply #22 on: September 17, 2015, 02:05:03 PM »
Great work, thanks!

 

Donations

Operational Funds

Help us keep the Unworkable working!
Donate with PayPal!
June Goal: $300.00
Due Date: Jun 30
Total Receipts: $5.00
PayPal Fees: $0.49
Net Balance: $4.51
Below Goal: $295.49
Site Currency: USD
 2%
June Donations

Community Links


Powered by EzPortal
SMF 2.0.17 | SMF © 2019, Simple Machines
Page created in 0.057 seconds with 32 queries.
© 2018 Defender Web & Tool