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.


SAK dating info 3949

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




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,662 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




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,662 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,662 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 
No Life Club Posts: 4,248
Re: SAK dating info
« Reply #34 on: March 28, 2018, 10:18:47 PM »
Handyman with XLT:



 

Donations

Operational Funds

Help us keep the Unworkable working!
Donate with PayPal!
August Goal: $300.00
Due Date: Aug 31
Total Receipts: $66.00
PayPal Fees: $4.37
Net Balance: $61.63
Below Goal: $238.37
Site Currency: USD
21% 
August Donations

Community Links


Powered by EzPortal
SMF 2.0.15 | SMF © 2017, Simple Machines
Page created in 0.072 seconds with 33 queries.
© 2018 Defender Web & Tool