SAK dating info

[windson]

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)

[detron]

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

[detron]

found a bug in the spreadsheet.   

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

[detron]

problem fixed,  here is the updated sheet

Download from Dropbox

[FolderBeholder]

Handyman with XLT: