Thursday, August 25, 2011

In which Leon shows his love, in Excel

Leon has been home from work for the last two days with the same virus as I still have. I struggled through my day at work and came home. I've spun all my prepared fibre for Idlewood and wanted to ply, and I thought it would be a good idea to measure the first lot of plied fibre and , using maths, work out from that whether I would have enough or whether I will have to card some more fibre, and spin some more singles before proceeding. Leon said "I must be such a disappointment to you, with my inability to do maths". I said "It's not so much maths, as a formula" "Oh" said Leon and went and made a whole routine in Excel to work out the total yardage based on a sample. You put in the length and weight of the sample and it tells you how much that would be with your total weight. Here's a screen shot from today's sample:

Only I needed that total to read 770. I guess I'd better get the drum carder back out.
(Leon knows there is a typo in there, when I pointed it out he said "I'm taking time out from making fresh pasta for dinner, I'll fix it later)


  1. makes knitting formulas AND fresh pasta, such a winner!

  2. Nothing says "I love you" like code in excel :)