52 Tying Tips #5, Inventory Your Materials

Week 5 –  Keep Track of Your Tying Materials
I first wrote about the following method of inventorying and keeping track of your fly tying materials on Dressed Irons for FlyMasters. You can read the whole article if you want but the short version is that you can use a spreadsheet to keep track of (inventory) your fly tying materials. The process is quite simple. The actual follow through on keeping up with it can be more difficult.
Here is how it works.
  1. Inventory Spreadsheet.Create a new spreadsheet. 
  2. Label worksheets for different categories of materials (i.e. hackles, dubbing, hooks, threads, etc…)
  3. Place the various colors for the specific materials across the top.
  4. On the left place the name of the specific material.
  5. Where the color and the name intersect you can place an 'X' to indicate you have it or a number to indicate how many units of that item you have.

Now you have to go through all your stuff and add it to the spreadsheet. The nice thing is you can upload it to a Dropbox folder and keep updated copies on you smart phone at all times. That way when you are in your favorite fly shop picking up some materials for a new fly you can check to see if you already have the Estaz you need instead of buying yet another one.

Here are a couple links to empty spreadsheets to get you started.

Microsoft Excel version                Open Office version

Simply right click on the above link and select 'Save Link/Target as…' to save them to your hard drive.

Comments are closed.