Back in the summer of 2006 I tallied up my entire yarn stash, and put it in a spreadsheet. I then I set it up to calculate the number of kilometres of yarn that I own. I just tell it how many balls of the yarn I have, metres per ball, and how many balls of said yarn I have used so far.
Every now and then I make a note on one side of what the stash was sitting at on a certain date.
July 2006 (when I did started the sheet): 8.33km
Jan 1 2007: 7.65km
Today: 6.5km (about 4 miles for the Americans)
I’m doing rather well, especially as I’ve bought yarn this year. I do have to confess though, that it’s only so amazing today because I sold 12 skeins of brown Waterspun on eBay recently. That’s 1.4 km of yarn. Then again, 900m went into Rambling Rose, and close to that has gone into the Capecho so far. Clapotis was 500m, it all adds up. But, managing the stash isn’t just about making stuff out of the yarn, it’s about thinking about what you will actually use. I didn’t think I’d use my novelty yarn, so I donated it. I was tired of this brown yarn, so I sold it.
Also, I may have alluded to a large Webs order. I was feeling bad about that, even though I can afford it. I also had promised myself that I would constrain my yarn stash to one drawer unit, and I need room for the coming Webs stuff. I may need to get rid of more… But there isn’t anything else that screams ‘sell me!!’, so I’ll just have to get knitting.