Rainy Fourth, Snap Tape and Excel
Posted by thedarwinexception on July 4, 2007
So, I sewed all day – and knitted. I knitted enough to actually finish the right front on the never ending bunting! I can’t believe it. Now, all I have to do is knit the two sleeves (which have the mittens knitted right into them), and sew the hood – wash it, block it, and I’ll be done. I’m thinking I can have it done by the end of the weekend if I really work at it.
And yes, I sewed. I almost finished the little Winnie the Pooh shirt – I just have to hem the sleeves and sew the snaps on, and I started the little overalls. I’m stuck on those, though, because I need some snap tape. I’ve given up using that stupid snap tool thing. It never works. Trust me, if you use snaps a lot, just buy snap tape and forget investing in that snap tool. It’s a waste of time and money. But the overalls are done up to sewing the crotch and sewing the shoulder straps on.
Of course, I had help with the sewing – or at least “inspiration”. There was a Project Runway marathon on Bravo – and there’s nothing that will get me sewing faster than Project Runway. So I sewed and knitted all day. Paul did nothing. It rained all day, so there wasn’t much to do. He had high hopes of going for a ride on the Harley with some buddies, but, not with the rain. So he sat around moping all day because it was raining.
And now I have a question if there are any Excel gurus out there.
I couldn’t find a sewing pattern database program that would allow me to put all of my patterns into. Since I am storing them in Rubbermaid containers, I thought it would be nice to have a database program that would catalog them all. That way, when I am looking for a pattern for a children’s sweatsuit pattern, I would just have to go into the database program, type in a search on “children’s” and “sweatsuits”, and voila! There would be a list of my patterns that fir those keywords. No such animal, apparently. I was hoping this nonexistent program would have a field for a picture of the pattern, a place for notes, some keywords, a field for “size” and a category such as “men’s”, “women’s”, children’s”, “crafts”. And a place for the manufacturer and the pattern number, of course. Then, see, I would keep them in the Rubbermaid containers, in order of Manufacturer and pattern number. When I went into my database and found that the children’s sweatsuit pattern was McCall’s 9546, I would just go to the Rubbermaid containers, to the McCall’s drawer, and pick out 8546, since I would store them in numerical order.
Well, no such program exists. (And if you want to make me one, go ahead! I’ll buy it! And there are a ton of people on my sewing list who would buy it, too.) So, I made a very rough catalog in Excel. I put a field for a picture of the cover, I entered some keywords and notes, and am putting them in manufacturer order.
My question is this – is there a way to “sort” these in an excel spreadsheet on two different rows? I’d like to sort them by manufacturer, and by another “field” – and then print out the pages and keep them in a sort of “book”. But I’d like to have a “manufacturer” book sorted by different things like “children’s”. But I’m finding it hard to sort on two rows. Is that possible? Whenever I sort, it sorts just the one row I am sorting on, and leaves all the other information behind.
I hate Excel. If I can’t find a good database program by this winter, I’m thinking it would be a good winter project for me. I mean, I used to do this shit for a living, you’d think I would just make my own Access database, right? And besides, I could give it to a bunch of my mailing list friends. They’d love that. Because there really isn’t anything out there.