Wednesday, October 26, 2011

Chevron Design Worksheet {Free Download}

I love my bedroom wall, can't you tell?  This is the third day that I'm posting about it, but I promise it'll be the last.  Although, I'm sure you'll see glimpses of it again as I dress up the bed and the nightstands.  One step at a time...


(If you want to know how to make these picture frames, go here.)


First of all, you need to know that my husband, Brian, helped (and humored) me a ton with this project.

I had a really hard time visualizing how many chevrons I wanted and how steep and thick and so on.  When he couldn't handle my indecision any longer (his words), he made an Excel macro to help me see exactly how the chevrons would turn out.  The macro even gave me the coordinates for the chevron points.  I love my husband!  And you will too, because he has made this user friendly.  

It took 2 minutes to decide what I wanted with the macro.




This Excel program has two main functions:

1.  It helps you design your chevron by displaying a scale version of your pattern.

2. Once your parameters are chosen, it gives you a list of (x,y) coordinates that you can mark on your wall as guides.  This makes taping much, much faster. 

How to use the Chevron Designer:

Download and open ChevronDesigner.xlsm.  


You'll probably need Excel 2007 or later to open the file.  If you have Excel 2003, there are compatibility plugins you can install.  The .xlsm extension means "Excel macro-enabled worksheet."  Your default macro security settings will not allow the macro program to run in the spreadsheet, so either a popup or a security bar warning will appear.

Click on "Options"


Then click "Enable this content"


I'm not sure how this will run on all versions of Excel, so if you have problems, please contact me.  I'd love to help.

The first sheet of the workbook labeled "Design Sheet" lets you modify the wall dimensions (width and height) and the chevron parameters, such as the number of segments, chevron depth, distance between chevrons, number of chevrons, start height, and thickness of each chevron.  It sounds complicated now, but once you start playing around with the numbers, you'll see how each parameter affects the design.  Only change the numbers in the yellow boxes.  I used units of inches, but everything will scale correctly as long as you're consistent.


The display will update itself when you change most settings.  When you first change the wall dimensions or change the chevron thickness, you'll have to hit the "Update..." button.  This runs the macro, which does two things:

1.) It changes the shape of the graph to the actual aspect ratio of your wall

2.) It changes the thickness of the chevron. 

So, most of the time you can change the numbers without hitting update, but be sure to update whenever you change the thickness or the wall dimensions.

Example:  Here, I made the room wider and added more segments.  The display is inaccurate until I hit update:

Before hitting "Update"

After hitting "Update"

You'll probably want to use something between 2-5 for the diagram size.  Notice that when you do this and hit update, the display gets bigger, but all the ratios are kept the same.

One thing I did was add correctly-sized blue boxes on top of the display to represent different furniture (in this case, a bed, two nightstands, and a shelf).  It really helps you visualize what the final product will look like.



Once you've made all your choices, go to the second sheet in the workbook labeled "XY Coordinates."

Starting with the top chevron, these are the coordinates of the center of each zag.  The reference points you draw for taping will be half the vertical thickness above and below that point.  For example, if my vertical thickness is 8in, then you will put a small mark 4in above and 4in below each of the (x,y) points listed.  Also, remember that the (x,y) locations are all referenced to the lower-left corner of the wall, which is (0,0).    I rounded the points to the nearest 1/16th, since most people will be using inches.


After the wall is marked up with the coordinates, all that's left to do is tape it up!



Take a few minutes to play with the program and I think you'll get the feel of how it works. Remember to enable macros in your security settings.

Please don't hesitate to email me with questions! 

quelindacrafts@gmail.com

Also, please send me pictures of your chevron projects that you've done using this program.  I'd love to see it put to use!


I'm linking this tutorial to several blogs this week.
Also linking to Remodelaholic and Today's Creative Blog







14 comments:

  1. I never would have thought to use Excel to do this. What a great idea! I would have just gotten out some graph paper and tried to sketch it, but it would have taken forever. I love that you can just plug in the numbers. I imagine you could use something similar to do stripes too. Hmm...

    ReplyDelete
  2. Thanks Kyra! You can design horizontal stripes by setting the chevron depth to 0.

    ReplyDelete
  3. Sweet! What if I want to end with a zig?

    lol.

    ReplyDelete
  4. Just put an odd number in for # of segments and you'll have a zig at the ends.

    ReplyDelete
  5. Hi, Janny

    You put a lot of work into painting your bedroom wall. I don't think I could have done it. It looks great! Thanks for stopping by www.homesweetbutterfly.com. I appreciate your kind words.

    Vanessa

    ReplyDelete
  6. Hi! This is very cool! I love it! Thanks for sharing this at the Crazy Cute party @ Between U & Me! Don't forget to come back and enter for a chance to win the giveaway! :D

    www.betweenuandme.com

    ReplyDelete
  7. I just wanted to let you know that I featured your project today on "You Sew Rock Me Fridays" on my blog Sew Rockin'. Awesome job! I can't wait to see what you come up with in the future!

    You can find the post at http://www.sewrockin.com/2011/10/28/you-sew-rock-me-fridays-2/

    Jamie @ sewrockin.com

    ReplyDelete
  8. You've been featured!

    http://delightfulorder.blogspot.com/2011/10/top-ten-features-from-10262011.html

    Thanks for linking to the party! Hope to see you back this Thursday.

    DaNita

    ReplyDelete
  9. Wow Janny you are so ambitious. The lines look great way to go!

    ReplyDelete
  10. I featured this post today on my blog! Thanks for sharing! :D

    www.betweenuandme.com

    ReplyDelete
  11. Oh wow. I wouldve never figured this out. Your wall looks amazing! New follower. Would love it if you would stop by and share this at my linky party :) http://everything-underthemoon.blogspot.com/2011/11/bedazzle-me-monday-7_6572.html

    Also, PRETTY PLEASE stop by and check out Random Acts of Kindness Week going on all next week!! I would love it if you could participate!! More info here:
    http://everything-underthemoon.blogspot.com/2011/11/kindness-and-thanksgiving.html

    ReplyDelete
  12. Genius!! I have procrastinated on doing anything chevron because my brain does not work when I have to figure these types of measurements. Thank you, thank you, thank you!

    ReplyDelete
  13. This template designer totally saved my Chevron striping project. I was racking my brain trying to get the math right to make it look perfect. You and your husband are GENIUS! Thank you for sharing with the DIY world!!!

    ReplyDelete
    Replies
    1. Thank you! You're the first one to let me know how it turned out. I'm so glad that it helped you!

      Delete