Quiltingboard Forums

Quiltingboard Forums (https://www.quiltingboard.com/)
-   Member Swaps and Round/Row Robins (https://www.quiltingboard.com/member-swaps-round-row-robins-f11/)
-   -   Row Robin 2012/2013 (https://www.quiltingboard.com/member-swaps-round-row-robins-f11/row-robin-2012-2013-a-t197378.html)

TheMamaHauser 10-04-2012 04:32 PM


Originally Posted by Melody MO/KS (Post 5562278)
At this point I think I will just do 5 blocks I've never done before and call it wonderful!

For our row, I took all my blocks off of posts on Pinterest - if the pattern wasn't already 12.5", I resized it using my super-ninja microsoft excel skills. I can help you with that if you'd like :)

Melody MO/KS 10-04-2012 05:00 PM


Originally Posted by TheMamaHauser (Post 5562545)
For our row, I took all my blocks off of posts on Pinterest - if the pattern wasn't already 12.5", I resized it using my super-ninja microsoft excel skills. I can help you with that if you'd like :)

Thanks for your offer. I will remember your super nija skills w/ Excel, believe me! I have come with a plan and have been working on it so I'm good. Will keep you posted!

Qbee 10-04-2012 05:33 PM

So.....it looks like we have not heard from three (3) folks: MistyMarie, MHobbs and Areinn.
I am hoping to hear something by Monday or I will start filing in the gaps with our ladies in waiting...LOL :D

Dragonfly Nana 10-04-2012 05:39 PM


Originally Posted by TheMamaHauser (Post 5562545)
I resized it using my super-ninja microsoft excel skills. I:)

LOL We have a ninja in our group!

Whigrose 10-04-2012 06:29 PM

Hey TheMamaHauser,
Super-ninja MS Excel skills, eh? I'll bit, how is it done? ( I love learning new things!)

TIA,
best,
d
QUOTE=TheMamaHauser;5562545]For our row, I took all my blocks off of posts on Pinterest - if the pattern wasn't already 12.5", I resized it using my super-ninja microsoft excel skills. I can help you with that if you'd like :)[/QUOTE]

TheMamaHauser 10-04-2012 06:50 PM


Originally Posted by Whigrose (Post 5562743)
Hey TheMamaHauser,
Super-ninja MS Excel skills, eh? I'll bit, how is it done? ( I love learning new things!)

Well, you pull up a new spreadsheet and then you can resize the columns and rows to be equally sized squares (I generally use 50 pixel x 50 pixel).

From there, I look at the pattern to see if it will be easier to recreate using 1" increments or 1/2" increments. This technique works best with patterns that are "grid" designs - say 3x3 blocks within the overall pattern or 4x4, etc. It is the ones that aren't easily divisible (like 5x5 grids) that I tend to use the 1/2" incrementing.

I will then make a square outline of however many rows and columns I need to get to the size of the block = so for a 12.5" block, I will highlight the equivalent of 12" of rows/columns. If I have decided each row/column is 1", then I use a 12x12 grid. If I say that the row/column is 1/2", then I use a 24x24 grid. I have found sticking with either 1" or 1/2" is really ideal (you'll see why later).

From there, I use the border tool to "draw" the pattern. When I know a particular "chunk" is going to be solid, I do a merge-all to make all of the little sub-blocks into one giant block. If I have to draw a diagonal cut across a block (think a shoo-fly block, for example) I will merge the chunk and then use the manual draw-border tool to create that diagonal.

Then, when the entire design is re-created, I use the row/columns to determine what I should be cutting. This is kind of hard to keep straight at first (for me, at least). Basically, I highlight each chunk and I count the number of rows/columns that chunk requires. So, say I have a 12x12 overall grid and I have a chunk that is 3x3. I will make the cutting measurement to be 3.5" x 3.5" to factor in seam allowance.

The part that confuses me (frequently) is when I'm using the 1/2" increments - because when you count how many rows/columns, you divide by 2 and THEN add on the .5" seam allowance.

So, that's the basic breakdown of how I do it. I keep all the blocks I've resized/redesigned/created in one spreadsheet and just keep making new pages each time.

When you first start using this, I suggest making an extra mark at the center points at both the top and the bottom and on the sides (outside the grid) to help you keep track of center. If anyone is interested, I'd be happy to send a copy of my spreadsheet so you don't have to recreate the wheel. It's hard to really explain in words but it's pretty easy to understand when you're looking at it in front of you.

If you want a copy, PM me your email address and I'll send it out tomorrow after I get back from school.

buslady 10-05-2012 05:54 AM

Excel GuRu
 
I thought it could be done, but I had not tried it. I would actually love to have a copy of your spreadsheet, it would be easy to use yours already set up. AND, I am assuming you will send the workbook so we would have all the blocks you have already created on it. LOL How is that for plagerism!!! [email protected]

:D

Whigrose 10-05-2012 06:03 AM

You gave a pretty terrific, and lenghty, explanation of how you go about your process. Thank you. Isn't technology wonderful?

best,
d

Originally Posted by TheMamaHauser (Post 5562772)
Well, you pull up a new spreadsheet and then you can resize the columns and rows to be equally sized squares (I generally use 50 pixel x 50 pixel).

From there, I look at the pattern to see if it will be easier to recreate using 1" increments or 1/2" increments. This technique works best with patterns that are "grid" designs - say 3x3 blocks within the overall pattern or 4x4, etc. It is the ones that aren't easily divisible (like 5x5 grids) that I tend to use the 1/2" incrementing.

I will then make a square outline of however many rows and columns I need to get to the size of the block = so for a 12.5" block, I will highlight the equivalent of 12" of rows/columns. If I have decided each row/column is 1", then I use a 12x12 grid. If I say that the row/column is 1/2", then I use a 24x24 grid. I have found sticking with either 1" or 1/2" is really ideal (you'll see why later).

From there, I use the border tool to "draw" the pattern. When I know a particular "chunk" is going to be solid, I do a merge-all to make all of the little sub-blocks into one giant block. If I have to draw a diagonal cut across a block (think a shoo-fly block, for example) I will merge the chunk and then use the manual draw-border tool to create that diagonal.

Then, when the entire design is re-created, I use the row/columns to determine what I should be cutting. This is kind of hard to keep straight at first (for me, at least). Basically, I highlight each chunk and I count the number of rows/columns that chunk requires. So, say I have a 12x12 overall grid and I have a chunk that is 3x3. I will make the cutting measurement to be 3.5" x 3.5" to factor in seam allowance.

The part that confuses me (frequently) is when I'm using the 1/2" increments - because when you count how many rows/columns, you divide by 2 and THEN add on the .5" seam allowance.

So, that's the basic breakdown of how I do it. I keep all the blocks I've resized/redesigned/created in one spreadsheet and just keep making new pages each time.

When you first start using this, I suggest making an extra mark at the center points at both the top and the bottom and on the sides (outside the grid) to help you keep track of center. If anyone is interested, I'd be happy to send a copy of my spreadsheet so you don't have to recreate the wheel. It's hard to really explain in words but it's pretty easy to understand when you're looking at it in front of you.

If you want a copy, PM me your email address and I'll send it out tomorrow after I get back from school.


Qbee 10-05-2012 02:00 PM

MistyMarie has been found!! :D Now we are just waiting to hear from MHobbs and Areinn
Hopefully we will hear from them by Monday or I will fill the spots with our ladies in waiting :D

QuilterMomma 10-05-2012 03:50 PM

Areinn has been missing for over a month now. I hope all is well with her. She is in our boom 8 swap group and has not repsonded to anyone. Not sure what has happened. Just a FYI for you.


All times are GMT -8. The time now is 09:44 PM.