I started an analysis of my knitting future a while back. This is the kind of thing math geeks do for fun.
- Download stash from Ravelry into an Excel s/s.
- Total up the “yards remaining” column. (140,000, more or less)
- Make a list of all the projects I have finished in the last few years.* (Yay, Ravelry! No way I could have done this w/o you!)
- Look up how much yarn each one used.** (Yay, Ravelry!)
- Total up the yards of yarn used.
- Divide total yards used by whatever number of years (or months, whatever) to determine how much yarn I use per year/month/whatever. Convert to yards/year.
- Look up life expectancy for women age 68.25. (It’s 18.9, in case you were wondering.)
- Multiply the number of yards knit up per year by 18.9.
- Compare result to #6, above.
This will tell me whether I have actually reached S.A.B.L.E. I fear I already know the answer.
* This wasn’t really accurate because because it didn’t include all the knitting I had done on the mitered square afghan. I should do the calc again now that the afghan is finished and will be included in the Finished category.
** This is where I stalled out in the calc. Looking up the yardage for every project was too tedious even to contemplate.***
*** Upon further thought I realize now that I wouldn’t have to look up every project, only one of each type. Every pair of worsted weight fingerless gloves would use approximately the same amount of yarn, for example