Row Robin 2012/2013

Old 10-04-2012, 04:32 PM
  #291  
Senior Member
 
TheMamaHauser's Avatar
 
Join Date: May 2012
Location: Great Falls, MT
Posts: 810
Default

Originally Posted by Melody MO/KS View Post
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
TheMamaHauser is offline  
Old 10-04-2012, 05:00 PM
  #292  
Member
 
Join Date: Sep 2012
Location: Missouri and Kansas
Posts: 37
Default

Originally Posted by TheMamaHauser View Post
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!
Melody MO/KS is offline  
Old 10-04-2012, 05:33 PM
  #293  
Super Member
Thread Starter
 
Qbee's Avatar
 
Join Date: Aug 2010
Location: Kentucky
Posts: 4,091
Default

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
Qbee is offline  
Old 10-04-2012, 05:39 PM
  #294  
Super Member
 
Dragonfly Nana's Avatar
 
Join Date: Feb 2010
Location: inland part of Virginia Beach
Posts: 2,655
Default

Originally Posted by TheMamaHauser View Post
I resized it using my super-ninja microsoft excel skills. I
LOL We have a ninja in our group!
Dragonfly Nana is offline  
Old 10-04-2012, 06:29 PM
  #295  
Senior Member
 
Whigrose's Avatar
 
Join Date: Oct 2011
Location: Pine cone and tassel state
Posts: 978
Default

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]
Whigrose is offline  
Old 10-04-2012, 06:50 PM
  #296  
Senior Member
 
TheMamaHauser's Avatar
 
Join Date: May 2012
Location: Great Falls, MT
Posts: 810
Default

Originally Posted by Whigrose View Post
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.
TheMamaHauser is offline  
Old 10-05-2012, 05:54 AM
  #297  
Super Member
 
buslady's Avatar
 
Join Date: Jul 2010
Location: Thumb of Michigan
Posts: 2,250
Talking 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]


Last edited by buslady; 10-05-2012 at 05:56 AM.
buslady is offline  
Old 10-05-2012, 06:03 AM
  #298  
Senior Member
 
Whigrose's Avatar
 
Join Date: Oct 2011
Location: Pine cone and tassel state
Posts: 978
Default

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 View Post
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.
Whigrose is offline  
Old 10-05-2012, 02:00 PM
  #299  
Super Member
Thread Starter
 
Qbee's Avatar
 
Join Date: Aug 2010
Location: Kentucky
Posts: 4,091
Default

MistyMarie has been found!! 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
Qbee is offline  
Old 10-05-2012, 03:50 PM
  #300  
Super Member
 
QuilterMomma's Avatar
 
Join Date: Jan 2011
Location: Eastern Washington
Posts: 6,514
Default

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.
QuilterMomma is offline  
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Qbee
Member Swaps and Round/Row Robins
171
05-02-2014 02:32 AM
Qbee
Member Swaps and Round/Row Robins
283
09-14-2013 07:21 PM
Qbee
Member Swaps and Round/Row Robins
246
08-22-2013 07:49 PM
Qbee
Member Swaps and Round/Row Robins
329
08-07-2013 12:19 PM
JudyG
Member Swaps and Round/Row Robins
520
10-24-2011 04:56 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


FREE Quilting Newsletter