« project tracking | Main | crochet and socks »

Gifts for the anal-retentive

I decided that not only did I want to track my projects in Excel, but I also wanted to make a needle/hook inventory. This idea was inspired by Heidi, who took her inspiration from Andrea. (Check out her sidebar for her groovy html version).
While creating my Excel version, I realized there was no reason not to share my insanity with others. Soooo, I present some blank Excel templates for tracking your projects and taking a needle inventory.

1. Project tracking: I've modified this a bit since I took the screen capture. This workbook has three worksheets: Current, FOs, and Future. They all have the same headers, so you can cut and paste them between sheets as needed.
Download file


2. Needle inventory. This took some thinking, but I decided on making it so you could use it either as a checklist (i.e. putting an X in the grid location of a certain needle) or a more specific inventory where you can specify the brand and/or material of needle. You dig? Also, it seems like circulars come in a variety of lengths that I didn't know about, so I just included the most common (16", 24", 32") and included another row for "other circulars." The straights I limited to 10" and 14", although there are certainly some manufacturers who make other sizes, feel free to add a row. DPNs, similiarly, I left as one category, because there seem to be a lot of various lengths, but if you want to break it down further based on your needle collection, do so! I have metric/crochet hook equivalences documented up to 15, and beyond that it is just what big needles I have (17, 35, 36).
Download file

needleinventory.jpg

Comments

Fabulous!

I have tried for a long time to get with the Excel. Perhaps now I will try even harder because your project tracker is very cool.

I just stole your excel chart! Thanks for posting it.

Thanks for sharing those excel files. I was just about to create something, but now I can just use your templates.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)