Some Excel nerdery for you today. I’m sharing two handy functions: MOD and QUOTIENT. This tip is very useful if you use Excel for knitwear design and grading. Strap in!
First, a quick summary of terms:
- NUMERATOR = the number you want to divide by or share into smaller units;
- DIVISOR = the number of smaller units you want the numerator to be divided by or shared into;
- QUOTIENT = the amount of whole number or complete divisions generated by the numerator and divisor;
- MOD = the whole number remainder following the quotient calculation.
MOD and QUOTIENT are handy for setting and arranging stitch repeats because they allow you to divide by whole numbers only. Below you can see I’m calculating an increase row for a transition from lacy leaf diamonds to double moss stitch. This calculation was needed for the Falling Leaves sweater. (Please click on the Excel image to enlarge it.)
Because the increases take place at regular intervals, you can consider them to be a pattern repeat. In this case I need to increase from 79 to 87 stitches, which is a difference of 8.
Using QUOTIENT in Excel
To work out the increase repeat, you input:
=QUOTIENT(numerator,divisor)
In this case, that is:
=QUOTIENT(79,8)
This gives me an answer of 9, so I have 9 stitches between my increases, and there are 8 stitches to increase in total.
Using MOD in Excel
To find the stitches remaining after the repeats have been calculated using QUOTIENT, you use the MOD function. This is input exactly as for the QUOTIENT function.
=MOD(numerator,divisor)
=MOD(79,8)
In this case I have 7 stitches left over after 9 full repeats.
Balancing the repeat | Bringing it all together in Excel for your knitting design
The final step is to distribute the stitches evenly so that the repeat is balanced. This is calculated by adding the repeat interval of 9 stitches to the remainder of 7 stitches, and dividing that total by 2. In this case:
9 + 7 = 16 ————–> 16 / 2 = 8
So my increase row for this size will read:
P8, m1, (p9, m1) 7 times, p8.
And that’s it (ha)! You can now set out your increases symmetrically, without having to resort to instructions like “increase X sts evenly across entire row”.
I hope you found this helpful – and if you have any other tips about MOD and QUOTIENT, or using Excel for knitwear design, please share them below. And Ko-Fi tips are always welcome 🙂
You might also enjoy my taster course on knitting pattern drafting and applied maths:
Pattern Drafting: Applied maths and the geometry of sleeves | Knitwear Design Initiation taster course
Knitwear Design Initiation | Pattern Drafting taster course
This knitwear design short course is especially recommended if you want to design sweaters, cardigans, and other types of pullover.
This taster course on pattern drafting for knitwear covers two important principles: applied maths and sleeve lift. Understanding human anatomy and how the arm moves gives you the perfect foundation for designing all styles of sleeve.
Knowing how to use mathematical formulas to calculate the stitches and rows you need for a pattern is key. Why mathematical formulas? You’ll need to use the MSG equation triangle to calculate the dimensions needed for EVERY knitting pattern you’ll design, whether for yourself or others. Take a sneak peek at MSG here if you’re more of a reader.
A mix of theory and practical makes the knitting pattern drafting taster course stand out. Be prepared to cut and stick pieces of paper together to create mini patterns or toiles!
Pingback:A quick MROUND the block - Natalie in Stitches
Pingback:For Designers: How to harness the power of Excel - Natalie in Stitches