 |
| Copyright inspirationrealisation |
Showing posts with label Excel 2 Knit. Show all posts
Showing posts with label Excel 2 Knit. Show all posts
Saturday, 28 November 2015
Calculating increases and decreases in excel
Copyright Lotta Breyer 2007
READ ORIGINAL POST HERE
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
Yarn calculator
by katedaviesdesigns
READ ORIGINAL POST HERE
READ ORIGINAL POST HERE
To use the calculator you will need to have a recent version of Microsoft Excel.
CONCATENATE in Excel: combine text strings, cells and columns
READ ORIGINAL POST HERE
In this tutorial, you will learn various ways to concatenate text strings, cells, ranges, columns and rows in Excel using the CONCATENATE function and "&" operator.
In your Excel workbooks, the data is not always structured according to your needs. Often you may want to split the content of one cell into individual cells, or do the opposite - combine data from two or more columns into a single column. Common examples that require concatenation in Excel are joining names and address parts, combining text with a formula-driven value, displaying dates and times in the desired format, to name a few.
In this tutorial, we are going to explore various techniques of Excel string concatenation so that you can choose the method best suited for your worksheets.
Set-in Sleeve Calculator
by Elinor Brown
READ ORIGINAL POST HERE
Although raglan and yoke constructions (and even Elizabeth Zimmermann’s set-in model) are seamless, I regrettfully find them ill-fitting on my body.
Like it or not, traditional set-in sleeves just fit me better.
However, calculating the armhole and sleeve cap shape is time consuming and rather unwieldy for patterns with multiple sizes. This winter, I designed several garments for publication with set-in sleeves.
I created an Excel spreadsheet to calculate the armscye measurement, the perimeter of the armhole.
Still, the spreadsheet required tinkering here and there and was not a very good solution.
When I explained my frustration to Aaron, he decided there had to be a better way.
Using Jenna Wilson’s (girl from auntie) impeccably thorough armscye tutorial in Knitty as a guide, he wrote a web application that would take in the necessary information regarding gauge and armhole shaping to produce meaningful information about sleeve cap shaping.
The application can be found for free here.
READ ORIGINAL POST HERE
 |
| Copyright: Elinor Brown |
Although raglan and yoke constructions (and even Elizabeth Zimmermann’s set-in model) are seamless, I regrettfully find them ill-fitting on my body.
Like it or not, traditional set-in sleeves just fit me better.
However, calculating the armhole and sleeve cap shape is time consuming and rather unwieldy for patterns with multiple sizes. This winter, I designed several garments for publication with set-in sleeves.
I created an Excel spreadsheet to calculate the armscye measurement, the perimeter of the armhole.
Still, the spreadsheet required tinkering here and there and was not a very good solution.
When I explained my frustration to Aaron, he decided there had to be a better way.
Using Jenna Wilson’s (girl from auntie) impeccably thorough armscye tutorial in Knitty as a guide, he wrote a web application that would take in the necessary information regarding gauge and armhole shaping to produce meaningful information about sleeve cap shaping.
The application can be found for free here.
INCREASE EVENLY ALONG A ROW USING EXCEL
READ ORIGINAL POST HERE
Before we start, you need these figures:
SC: starting stitch count
DC: desired stitch count
IC: the increase count, ie difference between SC and DC.
Note: if working flat, make sure you don't include your edge stitches in these counts.
Example numbers:
SC = 56
DC = 78
IC = 22
First, understand the problem. In most cases of course your starting stitch count won't divide neatly by your increase count and you'll be left with a possibly large remainder – the extra stitches left at the end of the row if you rounded down your increase interval to the next whole number. (For instance, 56/22 gives you a remainder of 12.) With sleeve shaping, I spread those extra rows out over the bottom of the sleeve, slightly lengthening the decrease intervals and reducing the slope of that portion. But this time, I don't particularly want to have all my extra stitches lopsidedly spread out on one side of a single row – I want them spread evenly across the row.
To achieve this, I plan to alternate between two different increase intervals (the basic interval, and that interval plus one of the "remainder" stitches). Ie, my pattern will have an instruction to repeat "m1, kA, m1, kB".
So let's get started.
1. Halve IC (HC) to find out how many increase repeats we need – how many times we'll work that "m1, kA, m1, kB" repeat.
Excel formula: =IC/2
Example: 22/2=11
2. Divide the starting count by this halved increase count. This gives you the number of total stitches in each increase repeat; call it total repeat, or TR.
Excel formula: =SC/HC
Example: 56/11=5
3. Within each of these repeats you need to increase two stitches. So halve TR and round up and down to get your higher and lower increase intervals (HI and LI), respectively – ie the number of whole stitches between increases. If TR is an even number, HI and LI will be equal.
Excel formulas: =ROUNDUP(TR/2,0) and =ROUNDDOWN(TR/2,0)
Note: the 0 means that we are rounding to zero decimal points.
Example: 2 and 3
4. Time to see what's left over if we work this repeat along the row – the remainder (RM).
Excel formula: =MOD(SC/HC)
Example: 56/11 leaves a remainder of 1.
5. Stick this number at the very start of your row or round, and you're done!
Your pattern instructions will look like this (assuming a plain knit row):
K RM, (m1, LI, m1, HI) to end.
Example: K1, (m1, k2, m1, k3) to end.
Bonus tip: If you have a reasonably sized remainder, you could take a few of those stitches over to the end of your row, for better balance. It's not practical to include instructions for that in a multiple-sizes pattern, though.
 |
| Copyright: studio-miranda |
SC: starting stitch count
DC: desired stitch count
IC: the increase count, ie difference between SC and DC.
Note: if working flat, make sure you don't include your edge stitches in these counts.
Example numbers:
SC = 56
DC = 78
IC = 22
First, understand the problem. In most cases of course your starting stitch count won't divide neatly by your increase count and you'll be left with a possibly large remainder – the extra stitches left at the end of the row if you rounded down your increase interval to the next whole number. (For instance, 56/22 gives you a remainder of 12.) With sleeve shaping, I spread those extra rows out over the bottom of the sleeve, slightly lengthening the decrease intervals and reducing the slope of that portion. But this time, I don't particularly want to have all my extra stitches lopsidedly spread out on one side of a single row – I want them spread evenly across the row.
To achieve this, I plan to alternate between two different increase intervals (the basic interval, and that interval plus one of the "remainder" stitches). Ie, my pattern will have an instruction to repeat "m1, kA, m1, kB".
So let's get started.
1. Halve IC (HC) to find out how many increase repeats we need – how many times we'll work that "m1, kA, m1, kB" repeat.
Excel formula: =IC/2
Example: 22/2=11
2. Divide the starting count by this halved increase count. This gives you the number of total stitches in each increase repeat; call it total repeat, or TR.
Excel formula: =SC/HC
Example: 56/11=5
3. Within each of these repeats you need to increase two stitches. So halve TR and round up and down to get your higher and lower increase intervals (HI and LI), respectively – ie the number of whole stitches between increases. If TR is an even number, HI and LI will be equal.
Excel formulas: =ROUNDUP(TR/2,0) and =ROUNDDOWN(TR/2,0)
Note: the 0 means that we are rounding to zero decimal points.
Example: 2 and 3
4. Time to see what's left over if we work this repeat along the row – the remainder (RM).
Excel formula: =MOD(SC/HC)
Example: 56/11 leaves a remainder of 1.
5. Stick this number at the very start of your row or round, and you're done!
Your pattern instructions will look like this (assuming a plain knit row):
K RM, (m1, LI, m1, HI) to end.
Example: K1, (m1, k2, m1, k3) to end.
Bonus tip: If you have a reasonably sized remainder, you could take a few of those stitches over to the end of your row, for better balance. It's not practical to include instructions for that in a multiple-sizes pattern, though.
Subscribe to:
Posts (Atom)