This "magazine" pretends to be a compilation of the best articles in knitting and crochet.
It is a virtual "note book" for the avid knitter and crochetter ... always needing to learn more.
Please read my HOME PAGE

Saturday, 28 November 2015

Calculating increases and decreases in excel

Copyright Lotta Breyer 2007


Here is what you need to type in into the cells to make your own spreadsheet. 
If you start at the corner of a spreadsheet, your column for calculations will be C. 
The First cell with a number is C3. 
That is where I have the number 56 above for head circumference.

Enter into cells:
C3 enter your measured head circumference
C4 enter counted stitches from swatch, E4 enter width of the area of the swatch you counted the stitches from
C5 enter counted rows from swatch, E5 enter total height of the counted rows
C6 enter =C4/E4*10
C7 enter =C5/E5*10
C8 blank
C9 enter =ROUNDDOWN(C6*C3/10,0)
C10 enter =ROUNDDOWN(C9/2,0)
C11 blank
C12 enter size of entrelac square (7)
C13 enter =EVEN(C9/C12)
C14 enter =C13*C12
C15 enter =C14-C9
C16 enter =ROUNDDOWN(C9/C15, 0)
C17 enter =4-(C12-7)
C18 blank
C19 enter =C13*4
C20 enter =C19-(C22*(C23+2))
C21 enter =ROUNDDOWN(C19/6.28*C7/C6,0)
C22 enter =ROUNDDOWN(C19/C21,0)
C23 enter =ROUNDDOWN(C19/C22,0)-2 and E23 enter =C23

No comments:

Post a Comment