« project tracking | Main | crochet and socks »
May 17, 2005
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
Posted by Betsy at May 17, 2005 05:52 AM
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.
Posted by: Heidi at May 17, 2005 09:11 AM
I just stole your excel chart! Thanks for posting it.
Posted by: sara at July 19, 2005 11:58 AM
Thanks for sharing those excel files. I was just about to create something, but now I can just use your templates.
Posted by: Kameko at February 5, 2006 11:45 PM