| Author |
 Topic  |
|
|
eggshel344
Gabber Extraordinaire
USA
391 Posts |
 Posted - 12/18/2005 : 08:23:03 AM
|
Hi all-
The time has come to officially make an inventory of the stash- it's getting out of hand and hopefully knowing what I have will help out... while I know this really just a pipe dream and an excuse to play with my yarn I am going to do it anyways... 
But... what I need is some expert advice on how to catagorize my yarn... does anyone have any spreadsheets they can share or other ways they keep their inventory that they can suggest for me to do mine? There seem to be endless ways to do this and I am clueless as to what the best way might be...
Thanks!
Samantha
"Failure is only an opportunity to begin agian more intellegently."
When Henry Ford said that I doubt he had knitting in mind, but if the sweater fits... |
|
|
Atavistic
Permanent Resident
6604 Posts |
Posted - 12/18/2005 : 08:34:04 AM
|
I can send you one as an attachment if you PM me with your email address.
Otherwise, across the top I have:
Brand/Name
Weight (word description, Aran, fingering, worsted, etc)
Color (my description and the number if there is one)
Lot
Put Up (g/yards)
Number of balls/skeins
Gauge
Material (the fiber composition)
I then list the yarns in alphabetical order and within that by color number order. For example:
Cascade 220 worsted 4147(B?) (bright yellow)
Cascade 220 worsted 7807 (dark purple)
Cascade 220 worsted 7818 (clear, bright blue)
Cascade 220 worsted 2411 (brown-red)
Cascade 220 worsted 8010 (natural)
Cascade 220 worsted 8393 (navy)
Cascade 220 worsted 8393 (navy)
Cascade 220 worsted 8400 (mid-dark grey)
Cascade 220 worsted 8401 (light grey)
Cascade 220 worsted 8505 (white)
Amanda
"Is that my Not-Mine Sweater? Whoever gets that Not-Mine Sweater is very lucky." |
 |
|
|
eggshel344
Gabber Extraordinaire
USA
391 Posts |
Posted - 12/18/2005 : 08:48:32 AM
|
that would be great- pm on the way! thanks
"Failure is only an opportunity to begin agian more intellegently."
When Henry Ford said that I doubt he had knitting in mind, but if the sweater fits... |
|
|
|
azblueskies
Permanent Resident
2294 Posts |
Posted - 12/18/2005 : 08:53:41 AM
|
| Wow, you guys are organized! I've used a spreadsheet to map out the felted clog pattern so I could follow it easily for whatever size I wanted to make, but haven't used it for stash. As it grows I may have to think about doing that. |
|
|
|
Knitrageous
Permanent Resident
USA
1445 Posts |
Posted - 12/18/2005 : 09:22:09 AM
|
My friends really teased me for doing this, but I used the Tasks or To-Do list on my Palm as an inventory. That way I had it with me when I went somewhere. How? I created a topic that was yarn name (or brand) and then as the 'task' I listed the color. You rank these by priority (1-5) and that is how I kept track of how many I had. If I did have more than 5 of something (I was doing scarves mostly, so had scarf yarn inventory on it)I just made a note when I added the color. Then when I used one or got another I lowered or upped the 'priority'. Kinda dumb I guess but it worked for me.
~~~~Jamye |
|
|
|
anderknit
Permanent Resident
USA
2550 Posts |
Posted - 12/18/2005 : 09:35:22 AM
|
I too have an excel spreadsheet for my inventory. The columns I use are:
Manufacturer
Yarn Name
Color
Class (worsted, etc.)
Quantity
Yardage per skein
Total yardage
Fiber content
Stated gauge
Gauge per inch
US Needle size (recommended)
Color number
Lot number
Price
Source (Place and date)
Comment (Ex: what project I had in mind)
Yes, it took a lot of time when I first did this, but now it's easy to add new yarns, and it's great to have. I usually keep it sorted by gauge per inch, but I can obviously sort in other ways if I need to. I sometimes sort by total yardage - that's great for figuring out my options for certain scarf projects.
I went further and have other worksheets with a needle inventory, a pattern inventory, a magazine inventory, and a book inventory. Now if only the rest of my life were as organized!
"Courage doesn't always roar. Sometimes courage is the quiet voice at the end of the day saying, 'I will try again tomorrow.' " |
|
|
|
eggshel344
Gabber Extraordinaire
USA
391 Posts |
Posted - 12/18/2005 : 09:50:38 AM
|
Yeah, I know it's going to take quite a while, and my stash isn't even "that" big yet, but I think it will be worth while in the end. I will have to start a blog when I am done just to share it!
"Failure is only an opportunity to begin agian more intellegently."
When Henry Ford said that I doubt he had knitting in mind, but if the sweater fits... |
|
|
|
Stacey14
Permanent Resident
1120 Posts |
Posted - 12/19/2005 : 06:51:42 AM
|
I do a similar thing with an Excel spreadsheet as anderknit. I also have another tab for projects (source, name,description,gauge,yrds needed,yarn used,needle,etc) that I can print out and take with me - I usually print it twice - once sorted by gauge (so if I find yarn I can find a pattern to fit it) and once by yarn name (so if I find that particular yarn I can find the pattern!)
My Blog:On And Off the Needles
|
|
|
|
Wen
Permanent Resident
Australia
3242 Posts |
Posted - 12/19/2005 : 3:45:05 PM
|
I've toyed with this idea and have a tab for the stash, a tab for books and a tab for projects. I was able to get all the info together and work out which books were the best value based on use and what each project cost me.
I obviously had too much time on my hands....I haven't kept it up to date this year.
I also played with a set up in Access that works well but I didn't maintain that one either.
Really if you are not a list maker don't bother, you have to be consistent in using these things. I just like the challenge of getting it to work.
Wen
2005 stats: 7 FO, 9 WIP, 1 frogpond.
http://photos.yahoo.com/whdayus |
|
|
|
azblueskies
Permanent Resident
2294 Posts |
Posted - 12/19/2005 : 6:07:05 PM
|
| Hmmm...maybe this could be a VBNet project. |
|
|
| |
Topic |
|
|
|
| Knitter's Review Forums |
© 2001-2013 Knitter's Review |
|
|
|
|
Topic Locked
