I should’ve put this up last week but oh well – I have a masterclass about using Excel in Issue 72 of The Knitter! Out right now!
I haven’t properly upped the nerd quotient around these parts and this tutorial is a step in the right direction. I feel like Excel is a handy (not saying it’s the best!) place to start picking up the concept of using computers as logic tools, linking together lots of simple operations into a complex database processing machine. That’s without getting into simple macro-writing, which I like to futz around with occasionally. Anyway, the above masterclass is nothing so complicated, just a way to dip your toes into applying gauge changes to a pattern.
Having an example spreadsheet saved on my computer has actually worked out really well: I have decided to knit Hetty by Andi Satterland, but in 4-ply instead of worsted/aran weight. It’s pretty much doubling the amount of stitches per inch. So whilst changing the numbers is easy enough, some other changes are needed to keep the original look. Specifically I have doubled the width and height of lace motif. This way the pattern will stay proportional even in thinner yarn (Jamieson & Smith 2-ply again, on sale!)