I recently finished inputting all my issues of CW&C into an Microsoft Excel database.
If anyone is interested send me a PM and I'll send you a copy.It took me a few weeks to get all the info in and I went through every page of each issue I own.
I've included:
Issue # -- Publication Date -- Pattern or Article Name -- Pg # -- Section -- Pattern Designer or Article Author -- Pattern Type -- # of Patterns -- Other Pattern Notes
I went from the most current backwards to issue 45 (#'s 182 - 45) I also included a few more I have from 1992 - 1995. I also have 5 of the 6 "Wood Ornaments" issues.
The file is 174KB so I can't really attach it here.
I would like to complete the database with issues I am missing so if someone can help - let me know.
The file is marked as final, but you can edit it if you wish. I really don't want anyone to post it anywhere without letting me know. I really don't need the credit for doing it, but I don't want anyone else to do so incorrectly.
The information is as accurate as I can ascertain by perusing each issue. There were some mistakes by CW&C in the exact location in the pattern pages for the patterns, but I've corrected based on the pattern description on the packet - not the magazine.
There may be typos as I spent sometimes hours typing this in and my eyes and fingers got screwy after a while!
I've left authors and pattern makers names as they appeared in each issue although some changed over time.
I didn't include articles which were reviews for items which were really adverts for the product.
I realized after getting all this done that I have only purchased one pattern which I actually had in one of the issues!
Also after typing and looking at all the patterns I believe the number on printed pattern in any form (fret, intarsia, ornament, clock, segmentation, etc.) was an Eagle. There was a time when it appeared an eagle appeared in each consecutive issue.
I also think Dan and Ray Wilckens had the longest run of pattern providers. I really didn't do an analysis of this, but I'd say Dirk Boelman was probably second. Sheila Landry and Robert J. Hlavacek, Sr. would be close to next.
As for who had the most - that is hard to tell, because a number of pattern makers did Christmas ornaments in groups of 20, 25, 30 or 50 for each year. If I were to guess I'd say Dirk Boelman had the most!
Anyway if you are interested in what I put together -
let me know and I will send it to you.Also I want to thank Cathy Skipper (cskipper) for her database she sent to me for review. It gave me the confidence to go and do my own. I thought it would be difficult to do, but with Microsoft Excel (which was on my computer) it went pretty easy.
I am also thankful I took typing when I was in High School - it helped tremendously!
Karl
