I came to the conclusion a few weeks ago that my stash was starting to get a little bit out of hand, when I realised that I couldn’t really remember much of what was in there. This is a problem for me because if I can’t remember what’s in there, I have little chance of being able to plan projects with it, so I’m never going to actually work through any of it. I’m sure you have probably noticed by now that I am as much a geek as I am a knitter, so there was only one possible solution to this problem: A Spreadsheet

Yes, dear readers, I went straight to Google Drive* and drew up a brand new yarn stash spreadsheet. What information could possibly be needed in such a document? Let me tell you…

• Brand
• Colour/Shade
• Weight
• Number of balls
• Metreage per ball
• Total metreage (calculated automatically from the number of balls and metreage per ball, obviously)
• Project(s) assigned to the yarn

Now I have my entire stash at my fingertips wherever I am! If I stumble across a pattern in a shop or online that I like the look of, I don’t have to go and rummage through my stash to find out if I have something that might be suitable.

The spreadsheet is sorted with yarns that are already assigned to future projects at the top, followed by yarns for which I haven’t yet chosen a project underneath. Those yarns are also sorted by metreage, highest first, allowing me to see of which yarns I have the most available for new projects.

Lastly, there is a motivating element of shame in this spreadsheet, thanks to the inclusion of a grand total metreage. I now know that I have over 8 km (5 mi) of yarn in my stash. That amount would stretch from Trent Bridge to Radcliffe-On-Trent, and that’s not as the crow flies! So, yes, I definitely need to tip my knitting:acquisition ratio a little further the other way in 2014.

*Naturally the spreadsheet must be available on my mobile devices when I’m on the go, as well as on my laptop at home.