Last year at about this time, I decided that my resolution for 2009 was complete stash turnover. I wouldn’t stop buying yarn, but I would knit or find a new home for everything in my stash at that point.
I did pretty well at this, right up until I broke my wrist. (Damn chickens!) I’m still not back up to speed. I can only knit for an hour per session before I have to stop.
Oddly, I’ve seen a net increase in yarn over the last few months, even though I have finished a lot of projects. And I have 7,000 yards more than when I declared “stash turnover” as my goal for 2009. Hm.
Since someone always asks when I post my little graphs: I get my numbers from my Ravelry account. To download an Excel spreadsheet with your stash information, click the Excel button on your Stash page:
If you don’t have Microsoft Excel installed, you can use Open Office. It’s free, and will handle the Ravelry Excel file no problem.
Once you have opened the file, look at the “Total Yards” column. Click an empty cell at the bottom of that column, then click the “funny E” (Autosum) button.
It will add up the numbers in that column and give you the total number of yards you have on hand.
I then go the extra mile and track my numbers in a separate spreadsheet, with a fun little graph, because I like graphs. (That part isn’t, strictly speaking, necessary.)
I’m a little worried to do this with my Rav stash. You have done admirably, considering your physical setback and all.
I don’t really keep track of my stash with ravelry, but I did once calculate just how much sock yarn I had and it was over a mile, not counting lots of stray yarn balls. It can be fun and scary to calculate such things..
I’ve recently put all of my yarn on Ravelry, realizing that I’m moving in two years and need to knit down my stash. Yes, it’s large enough that I’m giving myself a two-year notice.
Now I want to start graphing yarn in vs. yarn out, and I’m glad I’m not the only one who really likes graphs!
I’m in the ‘Ignorance is Bliss’ category. I don’t know how much yarn I have stashed, and I choose not to find out…
I am so glad that I am not the only one who does this. I should do a post to share my plot too
SUCH a geek (as in “I’m going to give you SUCH a pinch!). Ravelry is for fun, not to deal with the REALITY of your stash. That’s waaay to scary. I keep selling mind off, turning my back – here “rustle RUSTLE rustle,” whip back around and somehow more stash has filled in the newly created gap. Explain THAT with an Excel spreadsheet!
Well, I obviously can’t spell as well as deal with Excel but you get the idea.