Found a "Shop Inventory" spread sheet....

[Ray-CA]

I've been intending to do a complete inventory of both the mechanical as well as the wood/dirty work shop(s) for a number of years now. In one of the recent "Woodsmith" magazines I read an article on shop inventories and the author included the following link (http://www.woodsmith.com/magazine/extras)

You'll want the "Excel Document Shop Inventory" link. I've downloaded it and started on my inventory and it looks like it's going to work out really well for me, and it helps that I don't have to start from scratch.

Ray

 

[rpcraft]

I surmise you could also just open up Excel and start typing in items one by one?

To help people from having to hunt for it, here is an actual link to the spreadsheet itself:

http://www.woodsmith.com/magazine/extras/237/shop-inventory/

 

[PFSard]

Ray > Thanks for the link. I'm going to be taking inventory in the fall after I get done rearranging my garage/shop. After the heat blows through here.

All > I'd be interested if anyone uses this and what alterations they might make (or suggest).

 

[Fueler]

I have been using this for a few years now. Slowly getting it filled up.
My insurance guy appreciates it.

http://www.mycroftcomputing.com/eiown.html

 

[Falcon67]

FWIW - There was an article about insurance and the fires in CA. One takeaway was that State Farm was paying about 75% of claimed value lost without a complete inventory of house and etc. Like very spoon, fork, coaster, shirt, pair of pants, etc. Reports also said that once that info became more public, State Farm "modified" it's policy. What modified means was not clear.

 

[L5wolvesf]

I have most of the bigger items I own on Excel. Have them broken up on tabs Power tools, Battery tools, etc. Have yet to put all my wrenches, ratchets and hand tools on . . . yet. Good find Ray

 

[JJohns3WG]

I see this as being a good thing for insurance, my next door neighbor had a garage fire realized I'd be in deep s*** if it would have come over the fence. Also would be good for your heirs at some point, maybe not so much if your getting divorced. JJ

 

[Ray-CA]

Well, I started my inventory this afternoon. Started in the small shop (9x18) the wood/dirty stuff shop and did just power tools (stationary/cordless/corded/bench etc.) No drill bit sets, no hand tools or boxes of screws/nails etc.. I filled 42 lines!

I'm kinda dreading what I'll fill up from the big shop!!!!!!!!!

Ray

 

[James-W]

The thing about an inventory is, a lot of times what costs the most is the small stuff and not the "big ticket items" that we think costs the most. So you really need to keep track of the small stuff in case someone breaks in and steals you blind.

For example, your metal lathe was no doubt an expensive item when you bought it. But consider how much money you have ******* in tooling for the lathe. I suspect you have more money invested in tooling than you do in the lathe.

Another example, I have a bunch of woodworking machines, which were not cheap when I bought them. But when I consider how money I have ******* in saw blades, planing knives, molding knives, carbide cutters to make raised panel doors, a whole bunch of carbide router bits, things of that nature, the price of the machines are the least of the cost.

Anyway, my point is that you really need to list each and every small item that you have. The cost to replace them is going to shock you when you finally sit down and figure it all out.

 

[Ray-CA]

Anyway, my point is that you really need to list each and every small item that you have. The cost to replace them is going to shock you when you finally sit down and figure it all out.

Yep, I understand that completely. But, I had to start somewhere and had a limited amount of time today to get started. Going to complete the small shop before I tackle the larger one.

Ray