In case you’ve not seen this neat way of making a swatch for an in-the-round project, here’s how to do it.
Use a pair of double-pointed needles. Cast on the required number of stitches. *Don’t turn the work, but instead push the sts back to the other end of the needle. Draw the yarn loosely across the back of the swatch. Work the next row as if it is the next round. Repeat from * for the required length of swatch. Cast off. Cut the strings at the back. Block and treat as the project is to be treated. Pin out and measure.
As with all swatches, measure across the central sts as the edge sts may be distorted.
Here are pics of a (small) swatch worked in this manner (a) from the front; (b) from the back and (c) pinned out for measuring with the strings cut.
Note, if the yarn is slippy, you may have to secure the edgemost stitches so that they don’t unravel. You can do this with a sewing machine or by crocheting the edge as you might do with a steek. It helps to have long lengths of yarn at the back.
A discussion on rav revealed that some designers would like to export data from Ravelry Pro to manipulate in excel and in particular, create a chart of Purchases by Month. Here I go through the steps to work up the chart yourself, and at the bottom of the page is a link to a dummy excel file you can use. If you use the dummy file, you can just pop your Ravelry Pro exported data into the Purchases tab, but going through the steps will help you figure out how to to it yourself and maybe get different data out.
Then open that in a new excel document. The date of purchase column is column A.
You will need to use text-to-columns on column A to turn it into date format as just converting the data to “date” won’t work. Text-to-columns is on the data tab in my version (2010). Rename this excel sheet “Purchases”.
On a new excel sheet, set up 2 columns as follows
Call this sheet “Purchases per Month”. (January 2010 is an example. Best to use your first month with sales.)
Put the following into cell A3, then copy and paste into the rest of column A until it shows December 2014. This formula adds one month per cell. =DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))
Put the following into B2 and then copy and paste it into the rest of the cells below it. This formula basically says “count all purchases where
The “paid” column is not empty AND
The date is greater than or equal to the first of the month AND
The date is less than the first of the next month
*Please note, this last formula only works up to 10,000 purchases, but OTOH, if you have more than 10,000 purchases, I can, for a small (teeny, weeny) fee, write a spreadsheet for you!
**Sorry it runs off the page, but I don’t want to add spaces cos that will break the formula if the spaces are pasted too.
And then to make the chart, just select the data in columns A and B on the “Purchases per Month” sheet and click on the barchart from the Insert tab.
Finally, here, for your downloading pleasure, is the mock_purchases spreadsheet.
If you use the spreadsheet, you will need to do the Text-to-columns thing in step 3) everytime you copy in the data from rav.
I am delighted to announce I’ll be running a workshop in Puddleducks in Ardee, Co. Louth on Saturday week (August 3rd).
We’ll be using Wildacres as the workshop pattern.
There are many ways to make your knits your own. First and foremost, once you understand all the information set out in the pattern, you can plan how you want to change it. The next step is to choose whether to substitute the yarn type and colour. There are also many techniques for modifying as you go or working decorations into or onto your piece. This class will go through the pattern, teaching you the standard pattern elements so you can change what you want to make it unique. We will cover:
– Choosing yarn
– Elements of a pattern
– Changing it up
– If there’s time, surface embellishments (beading & embroidery).
Wildacres is knit in the round. There will be an opportunity to learn to knit in the round if you have not tried this before.
Materials for Wildacres: leftover DK yarn and 4.5mm circular needles (80cm long) (or size required to get gauge 20sts x 28rows / 10cm over st st)
Optional: If you have them, please bring a st st or ribbed square or even an old knit that could do with some “je ne sais quoi”!
This workshop costs 45 euro and is being hosted by Clare of Puddleducks.ght lunch and refresh
A light lunch and refreshments are included in the price.
Ring Clare with any queries
Puddleducks is a craft cafe (with lots of yummy cakes in both of the most important varieties… yarn cakes and chocolate!)
Puddleducks, Kells Road, Ardee, Co-Louth
spaces are limited and a non refundable
booking deposit of 25 euro is required.