Multitool.org Forum
 
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.


SAK dating info 5227

Hero Member Posts: 616 Observe - Evaluate - Control
Re: SAK dating info
« Reply #30 on: November 17, 2015, 12:19:18 AM »
so I decided to try a new approach at an inventory spreadsheet that helps date the SAK as well.  I am trying to make this into a database, but I know excel so much better than Access, so I wanted to test my proof of concept in a format I understand.

I know this is NOT the way many people would do it, but I thought if anyone wanted my sheet, then I would share it

the video description of this spreadhsheet can be watched here

https://youtu.be/vUuZ46gAJko


after watching the video, read below

near the end of the video I discus the pin hole on the scales.  as it turns out those scales were replaced, so the SAK is 1987-1990, not TRANS 1990-1991 as I said.  I was too lazy to do that video over.

the file is located here

now, another thing I am working on slowly with this spreadsheet is using pictures in comments.  if you go to the "front tools table" sheet and hover over the different can openers, you will see them pop up.

This is great! (Spreadsheets FTW)
« Last Edit: November 17, 2015, 10:26:46 AM by zoidberg »

Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: SAK dating info
« Reply #31 on: November 17, 2015, 12:25:23 AM »
so I decided to try a new approach at an inventory spreadsheet that helps date the SAK as well.  I am trying to make this into a database, but I know excel so much better than Access, so I wanted to test my proof of concept in a format I understand.

I know this is NOT the way many people would do it, but I thought if anyone wanted my sheet, then I would share it

the video description of this spreadhsheet can be watched here

https://youtu.be/vUuZ46gAJko


after watching the video, read below

near the end of the video I discus the pin hole on the scales.  as it turns out those scales were replaced, so the SAK is 1987-1990, not TRANS 1990-1991 as I said.  I was too lazy to do that video over.

the file is located here

now, another thing I am working on slowly with this spreadsheet is using pictures in comments.  if you go to the "front tools table" sheet and hover over the different can openers, you will see them pop up.

this should have said 1987 - 1990, not 1978-1990. 

MODs,  can you fix that in the post to avoid further confusion?  thank you
« Last Edit: November 17, 2015, 10:27:16 AM by zoidberg »

If I can help, let me know 
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: SAK dating info
« Reply #32 on: November 22, 2015, 05:16:41 AM »
found a bug in the spreadsheet.   :facepalm:

I will have it fixed and uploaded in the next day or so.  I forgot to lock some cell references, so the first entry will work great,  but subsequent rows will be wrong. 

I will post here when done

If I can help, let me know 
Absolutely No Life Club Posts: 7,546 Tool Carrying Linux User
Re: SAK dating info
« Reply #33 on: November 23, 2015, 02:49:10 PM »
problem fixed,  here is the updated sheet

Download from Dropbox

If I can help, let me know 
Absolutely No Life Club Posts: 6,030
Re: SAK dating info
« Reply #34 on: March 28, 2018, 10:18:47 PM »
Handyman with XLT:



Rest in peace ColoSwiss, you will not be forgotten.

 

Donations

Operational Funds

Help us keep the Unworkable working!
Donate with PayPal!
December Goal: $300.00
Due Date: Dec 31
Total Receipts: $54.54
PayPal Fees: $3.94
Net Balance: $50.60
Below Goal: $249.40
Site Currency: USD
17% 
December Donations

Community Links


Powered by EzPortal
SMF 2.0.18 | SMF © 2020, Simple Machines
Page created in 0.041 seconds with 42 queries.
© 2018 Defender Web & Tool