This is for those of you that like me want to "play it safe" in regards to homeowners insurance with your home based workshop....
How are you going about making / maintaining a current shop inventory and assessing the values?
After working the truck transmission problem, I had a chance to realize that my tool inventory might not be as complete as it needs to be, and that I am missing some high value items. (Several of my older Snap On specialty impact sockets are nearly $200.00 each...).
In the past, I have been maintaining a spreadsheet with the MFG name, Item name / number, brief description (I.E. Upgraded plane iron for #5 Jack plane), functional group (I.E. shaping, cutting, sanding, dust collection, Auto Testing etc...), a photo, of either the actual item as it is in the shop, or of like equipment, but I try to have photos of MY actual stuff... Quantity, cost per unit, typically either current retail, or what I paid, and I am thinking about adding a used cost column.
I have 2 problems. One is how do I assess the value of a no longer in production / sale tool such as the BT3100, and the second is more technological. With all the values / binary data I have here, I am thinking I am at the point where a database makes more sense...
Now I am not a database guy, never claimed to be. So I was actually hoping those with more database experience might be able to help me out here...
I am thinking about using OpenOffice.org / LibreOffice Base to build the database (that way I can share it among my Linux / Windows / Android devices...
Can anyone give me any pointers on how to import the data from my Excel spreadsheet into a Base database?
How are you going about making / maintaining a current shop inventory and assessing the values?
After working the truck transmission problem, I had a chance to realize that my tool inventory might not be as complete as it needs to be, and that I am missing some high value items. (Several of my older Snap On specialty impact sockets are nearly $200.00 each...).
In the past, I have been maintaining a spreadsheet with the MFG name, Item name / number, brief description (I.E. Upgraded plane iron for #5 Jack plane), functional group (I.E. shaping, cutting, sanding, dust collection, Auto Testing etc...), a photo, of either the actual item as it is in the shop, or of like equipment, but I try to have photos of MY actual stuff... Quantity, cost per unit, typically either current retail, or what I paid, and I am thinking about adding a used cost column.
I have 2 problems. One is how do I assess the value of a no longer in production / sale tool such as the BT3100, and the second is more technological. With all the values / binary data I have here, I am thinking I am at the point where a database makes more sense...
Now I am not a database guy, never claimed to be. So I was actually hoping those with more database experience might be able to help me out here...
I am thinking about using OpenOffice.org / LibreOffice Base to build the database (that way I can share it among my Linux / Windows / Android devices...
Can anyone give me any pointers on how to import the data from my Excel spreadsheet into a Base database?
Comment