Tool Inventory Project

Status
Not open for further replies.
R

rickc

After reading the thread about the very unfortunate fire at one of our member's shop, I got to thinking about how difficult it would be to replace my own, small shop.

To that end, I was wondering if I could get some help on a project that came to mind - a shop inventory application of some sort. It will be either in Excel or MS Access. When done, I would post it in the files section so people might be able to use it for their own shops.

I figure we would need to have "detail" information covering: Quantity, manufacturer, date bought, price paid, replacement value, description and either some way to link to a picture or insert one. I also think this will take a little bit but would like to have it finished for the fall.

The list below is a beginning point to identify the most common tools in our shops. Could I please ask our members to add to it? I have created initial categories, so when responding, please use one of the following categories:

Tools for Measuring and Leveling

  1. [FONT=&quot]Tools for Measuring and Leveling[/FONT]
  2. [FONT=&quot]Power Tools for Cutting and Drilling[/FONT]
  3. [FONT=&quot]Hand Tools for Sawing and Chiseling[/FONT]
  4. [FONT=&quot]Tools for Attaching Assembling, and Dismantling
    [/FONT]
  5. [FONT=&quot]Tools for Finishing Work[/FONT]
  6. [FONT=&quot]Pneumatic Tools[/FONT]
  7. [FONT=&quot]Miscellaneous Tools[/FONT]

....and here is the starting point:

[FONT=&quot]Tools for Measuring and Leveling[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] * Steel tape measure[/FONT]
[FONT=&quot] * Torpedo level[/FONT]
[FONT=&quot] * 2' to 4' level[/FONT]
[FONT=&quot] * Carpenter's square[/FONT]
[FONT=&quot] * Plumb bob[/FONT]
[FONT=&quot] * Chalk line[/FONT]
[FONT=&quot] * Combination square[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Power Tools for Cutting and Drilling[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] * Circular saw[/FONT]
[FONT=&quot] * Band saw[/FONT]
[FONT=&quot] * Jig saw[/FONT]
*Scroll saw
[FONT=&quot][/FONT]
[FONT=&quot] * 3/8" variable-speed drill[/FONT]
[FONT=&quot] * Reciprocating saw[/FONT]
[FONT=&quot] * Table saw (Bench saw)[/FONT]
[FONT=&quot] * Cordless drill[/FONT]
[FONT=&quot] * Router[/FONT]
[FONT=&quot] * Radial-arm saw[/FONT]
[FONT=&quot] *Drill Press[/FONT]
[FONT=&quot] *Planer[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Hand Tools for Sawing and Chiseling[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] * Crosscut saw[/FONT]
[FONT=&quot] * Chisel[/FONT]
[FONT=&quot] * Rip saw[/FONT]
[FONT=&quot] * Combination saw[/FONT]
[FONT=&quot] * Hacksaw[/FONT]
[FONT=&quot] * Back saw and miter box[/FONT]
[FONT=&quot] * Keyhole saw[/FONT]
[FONT=&quot] * Coping saw[/FONT]
[FONT=&quot] * Mallet[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Tools for Attaching Assembling, and Dismantling [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Hammers[/FONT]
[FONT=&quot] * Claw hammer[/FONT]
[FONT=&quot] * Ripping hammer[/FONT]
[FONT=&quot] * Tack hammer[/FONT]
[FONT=&quot] * Ball peen hammer[/FONT]
[FONT=&quot] * Sledge hammer[/FONT]
[FONT=&quot] * Nail set[/FONT]
[FONT=&quot] * Pry bar[/FONT]
[FONT=&quot] * Brads, nails, and spikes[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Screwdrivers[/FONT]
[FONT=&quot] * Conventional screwdrivers[/FONT]
[FONT=&quot] * Phillips-head screwdrivers[/FONT]
[FONT=&quot] * Cordless screwdriver[/FONT]
[FONT=&quot] * Wood screws[/FONT]
[FONT=&quot] * Sheet metal screws[/FONT]
[FONT=&quot] * Machine screws[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Wrenches[/FONT]
[FONT=&quot] * Open-end wrench[/FONT]
[FONT=&quot] * Box or socket wrench[/FONT]
[FONT=&quot] * Allen wrench[/FONT]
[FONT=&quot] * Locking wrench[/FONT]
[FONT=&quot] * Strap wrench[/FONT]
[FONT=&quot] * Pipe wrenches [/FONT]
[FONT=&quot] * Lag screws[/FONT]
[FONT=&quot] * Bolts[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Pliers[/FONT]
[FONT=&quot] * Slip joint pliers[/FONT]
[FONT=&quot] * Lineman's pliers[/FONT]
[FONT=&quot] * Channel lock pliers[/FONT]
[FONT=&quot] * Long-nosed pliers[/FONT]
[FONT=&quot] * End-cutting nippers[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot][/FONT] [FONT=&quot]Clamps[/FONT]
[FONT=&quot] * C-clamp[/FONT]
[FONT=&quot] * Bar clamp[/FONT]
[FONT=&quot] * Spring clamp[/FONT]
[FONT=&quot] * Hand screw[/FONT]
[FONT=&quot] * Vise[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Tools for Finishing Work[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Power Sanders[/FONT]
[FONT=&quot] * Orbital sander[/FONT]
[FONT=&quot] * Belt sander[/FONT]
[FONT=&quot] * Disk sander[/FONT]
[FONT=&quot] *Drum Sander[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Planes[/FONT]
[FONT=&quot] * Block plane[/FONT]
[FONT=&quot] * Trimming plane[/FONT]
[FONT=&quot] * Smooth plane[/FONT]
[FONT=&quot] * Scrub plane[/FONT]
[FONT=&quot] * Jack plane[/FONT]
[FONT=&quot] * Fore and joiner planes[/FONT]
[FONT=&quot] * Rabbit plane[/FONT]
[FONT=&quot] * Grooving plane[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Hand Sanders[/FONT]
[FONT=&quot] * Sanding block[/FONT]
[FONT=&quot] * Sanding cloth[/FONT]
[FONT=&quot] * Sandpapers[/FONT]
[FONT=&quot] * Steel wool[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Files[/FONT]
[FONT=&quot] * Single cut[/FONT]
[FONT=&quot] * Double cut[/FONT]
[FONT=&quot] * Rasp[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Pneumatic Tools[/FONT]
[FONT=&quot] * Air Compressor[/FONT]
[FONT=&quot] * Quick-connect couplers[/FONT]
[FONT=&quot] * Spray gun[/FONT]
[FONT=&quot] * Air drill[/FONT]
[FONT=&quot] * Blow-gun[/FONT]
[FONT=&quot] * Air ratchet[/FONT]
[FONT=&quot] * Caulking gun[/FONT]
[FONT=&quot] * Air sander[/FONT]
[FONT=&quot] * Stapler[/FONT]
[FONT=&quot] * Air hammer/chisel[/FONT]
[FONT=&quot] * Nail gun[/FONT]
[FONT=&quot] * Impact wrench[/FONT]
[FONT=&quot] * Sandblaster[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Miscellaneous Tools[/FONT]
[FONT=&quot] * Sawhorses[/FONT]
[FONT=&quot] *Paint brushes[/FONT]
[FONT=&quot][/FONT]
[FONT=&quot] * Shop vacuum[/FONT]
*Dust collector
 
S

Sully

New User
jay
Rick,

I think you have a good idea and I'm certainly not trying to dissuade you from pursuing it. However, you might think about using the following existing database as a starting point:

http://www.inthewoodshop.org/software/software.shtml

The 4th link down on that page is:
Woodshop Inventory Database File.


Standard disclaimer applies: I have no affiliation with any of the above, just passing along info that I happened to have bookmarked for future use.

Best,
J
 
DavidF

DavidF

New User
David
Add Jointer

Power Tools for Cutting and Drilling

[FONT=&quot]* Circular saw[/FONT]
[FONT=&quot]* Band saw[/FONT]
[FONT=&quot]* Jig saw[/FONT]
*Scroll saw

[FONT=&quot]* 3/8" variable-speed drill[/FONT]
[FONT=&quot]* Reciprocating saw[/FONT]
[FONT=&quot]* Table saw (Bench saw)[/FONT]
[FONT=&quot]* Cordless drill[/FONT]
[FONT=&quot]* Router[/FONT]
[FONT=&quot]* Radial-arm saw[/FONT]
[FONT=&quot]*Drill Press[/FONT]
[FONT=&quot]*Planer[/FONT]
*Jointer
 
rywilson

rywilson

New User
Ryan
I would also think that model/serial number would be a column.
In regards to replacement value... wouldn't that only be calculated in the event you were actually replacing it and not during the time of adding the item to the list?
 
R

rickc

jwaterdawg said:
Rick,

I think you have a good idea and I'm certainly not trying to dissuade you from pursuing it. However, you might think about using the following existing database as a starting point:

http://www.inthewoodshop.org/software/software.shtml
Click to expand...

That appears to be something like I had in mind. However, when I tried to convert it, there are several missing components that appear to be associated with MS Access 97 (listed as the requirement).

Heaven knows if there is already something out there, I would not re-invent the wheel. I may see if I can debug it. Thanks for pointing it out!
 
R

rickc

rywilson said:
I would also think that model/serial number would be a column.
In regards to replacement value... wouldn't that only be calculated in the event you were actually replacing it and not during the time of adding the item to the list?
Click to expand...

Replacement value, would also apply to those older tools of which you have no idea what you paid for them - maybe things passed down, or picked up at a yard sale. Ex: A contractor table saw you get at a yard sale for $100. However, if had to go to the local BORG, it would cost you $500.

Serial number - good catch!
 
cskipper

cskipper

Moderator
Cathy
The link below the database one opens an blank excel files with the pertinent columns. Not sure they are all there, but I had difficulty opening the access file.
 
RandyJ

RandyJ

Randy
Corporate Member
Would various bits be appropriate? i.e. router bits, forstner bits, hole saws,etc.


Also you may want to ADD:

[FONT=&quot]Tools for Measuring and Leveling[/FONT]

*Steel/aluminum rulers/yardsticks/straight edges

[FONT=&quot]Power Tools for Cutting and Drilling

[/FONT]*Biscuit joiner
*Lathe/chucks/tools (can't leave out the Dark Side!)

[FONT=&quot]Hand Tools for Sawing and Chiseling[/FONT]

*Flush cut saws (Japanese type)

[FONT=&quot]Tools for Attaching Assembling, and Dismantling [/FONT]

*Pocket hole jigs
*Tenoning jig
*Center punches
*Nail sets

[FONT=&quot]Miscellaneous Tools[/FONT]

*Metal detector
*Respirator/Face shields
*Air filtration Unit

HTH,
 
Travis Porter

Travis Porter

Travis
Corporate Member
Clamps

F body clamps
K body clamps
band clamps

Tools for Measuring and Leveling
french curves

What about finishing equipment, sprayers, compressors, HVLP guns, etc?
 
Vanilla Gorilla

Vanilla Gorilla

New User
Marco Principio
This is a great thread guys. I have been thinking about this type of thing a lot after a friend of mine's house burned down. Taking inventory of your posessions is a great idea, as sometimes I forget I even own certain things!!!:rotflm:
 
A

Alan in Little Washington

Alan Schaffter
Corporate Member
Replacement value is of no use until the worst happens. It is a moving target and based on what is available at the time - original or new, similar replacement, what a new/replacement costs, and of course what the economy is doing at the time.
 
R

rickc

There are several inventory applications around, and the one referenced is good as well. What my vision is one that minimizes the amount of typing and subsequent typographical errors. I would like to have drop down selections for categories, and a list of tools in each category, that can be selected or added to as needed. I have done this in the past, (including support of pictures).

Right now I am trying to build the values to put in the selections, and build it with the good ole KISS principle in mind. After all - think of it like the blade guard on a table saw: If it is too much of a pain to use, where does it end up? :wink_smil

I appreciate the additions to date. Thanks everyone - you are going to keep me busy!
 
R

rickc

Alan in Little Washington said:
Replacement value is of no use until the worst happens. It is a moving target and based on what is available at the time - original or new, similar replacement, what a new/replacement costs, and of course what the economy is doing at the time.
Click to expand...


Very true. What I am thinking of, is two ways to populate it.

1) As time allows. It will give you a rough estimate of the replacement value of your tools.

2) Printing a "shopping list", that in the event of a loss, you can print what you have and have a line/blank spot to enter on a paper report, or go back and populate the field for those things you have loss, to give to the insurance company.

Trying to think ahead. Sometimes it is easier to do at one's leisure than it is in the middle of a crisis. Like any field that will be included, it will not be required. Thanks for your feedback - keeps me on my toes! :gar-La;
 
cskipper

cskipper

Moderator
Cathy
I can brush up on my Access if you want. If someone else knows it and can write it quickly I won't bother right now.

I put a sample starter spreadsheet in the download library.

Add turning tools
Gouges/scrapers....
Chucks
Face Plates
Face Shield
Mandrels
Bushings
Pen press
Sanders

Carving Tools
Knives
THUMB GUARDS
GLOVES
 
Last edited:
R

rickc

cskipper said:
I can brush up on my Access if you want. If someone else knows it and can write it quickly I won't bother right now.
Click to expand...

Thanks for the additions. Access is what I will probably end up with, as that is what I am most familiar with to do what I want. Excel may be the "feeder" to the Access Database.
 
cskipper

cskipper

Moderator
Cathy
rcorne01 said:
Thanks for the additions. Access is what I will probably end up with, as that is what I am most familiar with to do what I want. Excel may be the "feeder" to the Access Database.
Click to expand...

That's what is sounded like. The bulk load will be building the tables for the drop down menus.
 
Status
Not open for further replies.

Premier Sponsor

Our Sponsors

LATEST FOR SALE LISTINGS

Top