Thread: Workshop tool inventory

I put everything onto an Excel spreadsheet. Not fancy, but easy to use. Most people already have it...

Second using Excel, easy to insert and resize images.

Probably not a good idea to keep a running total of purchase prices though

I use Excel for description and serial numbers and also keep a photo album using I photo. This gives me written description and photo.
Maybe useful.

Excel like everyone else with pages for categories. You could use Access but the trouble to learn it is not worth the result.

I found a couple of things, there are a bunch of web/databased projects that can be customised but most people would want it kept on their own computer.

Some of the picture organisation programs allow you to tag the photos and then search through the different tags. picassa from google may do the job.

http://www.primasoft.com/tour_invent...are_tour01.htm

http://www.tucows.com/preview/422814

If you're going to use a desktop program like Excel, Access, etc., please make sure that you have an effective OFF-SITE backup of your inventory file.

Hi All,

I'm assuming that one of the reasons you want this is for insurance purposes?

If so, then whatever software you use, print out a hardcopy or save a second copy of it somewhere outside of your house. You will appreciate this if someone breaks in and steals your computer.


Cheers,
Nathan.

Why would you want to spend time setting up and maintaining a list of your tools when you could be in the shed using them.

HH.

excel is not big enough and I don't have enough time left on this earth to inventory every single tool and jig/gaget in my shed, and when dad shucks this mortal coil and I have to sort out his shed. oh hell !!!!!

Kev,

Use Excel and put links in there for pictures if you need to. Thats the simplest way. Back it up and keep a copy somewhere else. You can never have too many backups. Print it out if you need to.

Rat,

That's the problem i'll have. He's 82 and still going strong and he got all of his fathers tools and still he's collecting more. It will probably take me a lifetime to go through it all.



Steve

Originally Posted by rat52

excel is not big enough and I don't have enough time left on this earth to inventory every single tool and jig/gaget in my shed, and when dad shucks this mortal coil and I have to sort out his shed. oh hell !!!!!

I think that's the first time I have ever heard of Excel not being big enough, it is big enough to use for retail shop inventoriesdepending how it is ser up
I have yet to run out of space for my shop
Wolffie

Wollfie, that thought struck me too so I googled Microsoft and they reckon:

Worksheet size 65,536 rows by 256 columns

Column width 255 characters

Row height 409 points

Page breaks 1000 horizontal and vertical

Length of cell contents (text) 32,767 characters.

Only 1,024 display in a cell; all 32,767 display in the formula bar.

That's got to be one helluva big shed!!

Ian

I was joking fellas. I was joking. Scheeche

Originally Posted by rat52

I was joking fellas. I was joking. Scheeche

How are p[eople supposed to know that without a or a or a or a at the end of the sentence
Wolffie