Clever Little Mouse

  • Home
  • About
  • Sewing
    • Sewing Tutorials
    • Sewing 101
  • Crafts
    • Craft Tutorials
    • Silhouette Projects
    • Homemade Health & Beauty
  • Holidays
    • Valentine’s Day
    • St. Patrick’s Day
    • Easter
    • Mother’s Day
    • Graduation/Back to School
    • 4th of July
    • Autumn
    • Halloween
    • Christmas
  • Shop
  • Contact

Quilt Planning with MS Excel

November 9, 2015 by Pam 1 Comment

I’ve been experimenting with ideas for a fall table runner. I started off with graph paper and colored pencils – one of my favorite ways to rough out new designs – but I had so many potential patterns running through head I switched over to the computer so I could play with them more easily.

Quilt planning with Microsoft Excel

I don’t use anything fancy for planning. While it won’t work for more complex shapes, for simple quilt designs based on squares Microsoft Excel is actually my tool of choice. I just set the row height and column width to the same size and fill in the cell colors to lay out a design.

Once I get to a design (or three) I like, I use letters to label the different color cells and a simple “count” formula to add them up. Like this: =COUNTIF(B2:H20, “a”).

Screen Shot 2015-10-30 at 9.27.50 PM

In this example, the formula counts all the tan squares because they’re the ones I labelled “a”. Once they’re all added up, it’s easy to figure out how much fabric I need for the project.

Who says you can’t be creative AND analytical?

post-signature
Pin31
Share6
Tweet
37 Shares

Filed Under: Blog, Sewing, Sewing Basics, Tutorials

« Beaded ID Badge Holder
Quilted Table Runner Tutorial »

Comments

  1. Kristina & Millie says

    November 10, 2015 at 1:25 am

    simply brilliant!!

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Pinterest
  • Instagram
  • Facebook
  • Contact

Copyright

All text, images, or other content on this blog are the property of Clever Little Mouse unless noted otherwise. You may not copy, duplicate, or reproduce any photographs, articles, downloadable files or material on this blog without the express permission of the owner. However, you may link to articles on this blog and feature a brief excerpt or image without permission as long as you include the blog’s full name in your link.

This error message is only visible to WordPress admins

Error: No connected account.

Please go to the Instagram Feed settings page to connect an account.

Amazon Affiliate

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites. As an Amazon Associate I earn from qualifying purchases.

Copyright © 2021 · Delightful theme by Restored 316 | Privacy Policy | Terms and Conditions | Comment Policy

Copyright © 2021 · Delightful Pro Theme on Genesis Framework · WordPress · Log in