{"id":502,"date":"2021-05-16T16:12:46","date_gmt":"2021-05-16T16:12:46","guid":{"rendered":"https:\/\/aliandlizzy.com\/?p=502"},"modified":"2021-12-12T18:02:11","modified_gmt":"2021-12-12T18:02:11","slug":"creating-perfect-circles-part-1-two-dimensional-for-embroidery","status":"publish","type":"post","link":"https:\/\/aliandlizzy.com\/index.php\/2021\/05\/16\/creating-perfect-circles-part-1-two-dimensional-for-embroidery\/","title":{"rendered":"Calculating perfect circles for embroidery &#8211; part 1 Excel"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"413\" height=\"500\" src=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/51JZpSnTWcL.jpg\" alt=\"\" class=\"wp-image-503\" srcset=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/51JZpSnTWcL.jpg 413w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/51JZpSnTWcL-248x300.jpg 248w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><figcaption><em>Cross stitch collages by Alyssa Westhoek<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p>Have you ever tried to create a perfect circle or ball for your cross stitch-, crochet- or knitwork? In this article I will explain how to create a perfect 2-dimensional circle with the use of excel. <\/p>\n\n\n\n<p>I came across the book by Alyssa Westhoek and started to randomly cross stitch a sea and beach-life scenery. Then, as a background, I wanted to create a bigger circle than Alyssa&#8217;s examples. And it also needed to be a nice and even circle&#8230;. It is very hard to create a good one without the use of any tools. If your canvas\/circle is still quite small you might want to consider to bind a pencil on a rope while using graph paper. For bigger circles I found a good method by using the Excel program and with the help of my formulas and the excel sheet that you can download further below, you will be able to create a perfect circle in Excel by yourself. <\/p>\n\n\n\n<p><strong>Parameters of a circle<\/strong><\/p>\n\n\n\n<p>Just a bit of background on how to describe a circle with it&#8217;s parameters. These are used to further calculate dimensions from. It is not necessary to completely understand all the details of the formulas in this article but it will ease the use of the formulas in the Excel sheet further below&#8230;. <br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"227\" height=\"227\" src=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters.jpg\" alt=\"\" class=\"wp-image-504\" srcset=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters.jpg 227w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters-150x150.jpg 150w\" sizes=\"auto, (max-width: 227px) 100vw, 227px\" \/><figcaption><em>diameter, radius and circumference of a circle<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p>First some general parameters:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>d is the diameter <\/li><li>r is the radius <\/li><li>r is half of the diameter:   r=1\/2d<\/li><li>c = the circumference= 2\u03c0r<\/li><li>\u03c0= 3.14 (rounded) and is a fixed number that is used for calculations on circles<\/li><li>\u03b1= angle: each circle has 360 degrees if you go round, e.g. a quarter has 90 degrees<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters-v2b.jpg\" alt=\"\" class=\"wp-image-530\" width=\"443\" height=\"443\" srcset=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters-v2b.jpg 591w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters-v2b-300x300.jpg 300w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters-v2b-150x150.jpg 150w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><figcaption><em>Example for a quarter: here the value of x changes in 16 equal steps, the changes in y and the angle \u03b1 differ per step. The r remains the same<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p>For the circle, the r always remains the same when you are on the circle. The x changes in equal steps (from 0-16) and the alpha and the y are the unknowns.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"200\" height=\"200\" src=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters-v3.jpg\" alt=\"\" class=\"wp-image-510\" srcset=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters-v3.jpg 200w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Circle-parameters-v3-150x150.jpg 150w\" sizes=\"auto, (max-width: 200px) 100vw, 200px\" \/><figcaption><em>Visualization of the angle \u03b1, x =4, y is unknown yet and the radius r=16 in this example.<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p>So now that we know some parameters of a circle, we will need to define how big the circle needs to be. When looking at your stitch canvas, you will work with cross-stitches per cm. For example 14ct -&gt; 5.4 cross stitches per cm. 3 cm radius will mean 3&#215;5.4=16,2 cross stitches in the radius, rounded off 16, so then r=16 cross stitches.<\/p>\n\n\n\n<p><strong>The formulas required to calculate a circle<\/strong> <strong>\/ triangles<\/strong><\/p>\n\n\n\n<p>Now we need to introduce the mathematical functions, sinus and cosinus. These functions we will require to calculate the x and the y. You will not really need to know what the background is of these functions, however these are the ones that are used in the excel formulas:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>y= sin(\u03b1) *r<\/li><li>y\/r=sin(\u03b1)<\/li><li>x= cos(\u03b1) *r<\/li><li>x\/r=cos(\u03b1)<\/li><li>\u03b1=acos(x\/r)<\/li><\/ul>\n\n\n\n<p><strong>Inserting the parameters and formulas into Excel<\/strong><\/p>\n\n\n\n<p>Look at the excel table, picture copied in below. You know the values in the green square, so you can fill these in. You also  know how many rows you have which is the x (in this example x ranges from 0-16, and the highest number 16 is always the value of radius r) which you can fill in for fields C9-C25 (the number of rows in column c you will need to adapt to your own example, based on the radius).<\/p>\n\n\n\n<p>Since we know the x and we know the r, we can therefore simply fill in the formulas:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>row 1, x=1; r=16  (r is the radius which is the same for each row)<\/li><li>Using acos (x\/r) = \u03b1 = acos (1\/16) = \u00b11,51 -&gt; this is the angle \u03b1, see table. <\/li><li>See further all calculated angles \u03b1 in the table, column E. <br><br>Once you have the \u03b1 for each row, you can use the formula y=sin(\u03b1)*r to calculate y, see column F. For row 1 this is y=sin(1,51)*16=\u00b116<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"519\" src=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/excel-table-1.jpg\" alt=\"\" class=\"wp-image-513\" srcset=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/excel-table-1.jpg 450w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/excel-table-1-260x300.jpg 260w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><figcaption><em>excel table, it calculates the values based on the formulas<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p>For calculating within Excel it means entering the following formulas into the fields: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>column D9 and further: example D9: &#8220;=C9\/$D6&#8221; which means &#8220;=x\/r&#8221; (the x is in column C and the r is in D6).  D10: &#8220;=C10\/$D6&#8221; etc etc. <\/li><li>column E9 and further: &#8220;=acos(D9)&#8221; which means &#8220;=acos(x\/r)&#8221; which gives us the \u03b1 of D9.<\/li><li>column F9 and further: &#8220;=sin(E9)&#8221; which means &#8220;=sin(\u03b1)&#8221; and this is the intermediate step to get to to calculate y for row 9.<\/li><li>column G9 and further:  =ROUNDUP(F9*D$6,0) which means &#8220;sin(\u03b1)*r=y round up to 0 decimals&#8221; The F9 refers to the &#8220;sin(\u03b1): that was calculated for x in F9. <\/li><\/ul>\n\n\n\n<p>And voila: you now have in column C the x and in column G the y. This example is for a quarter of a circle and you can easily mirror  it for the other quarters. The below picture is a graphical visualization of the quarter that you just calculated.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Excel-graph.jpg\" alt=\"\" class=\"wp-image-519\" width=\"434\" height=\"284\" srcset=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Excel-graph.jpg 578w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Excel-graph-300x196.jpg 300w\" sizes=\"auto, (max-width: 434px) 100vw, 434px\" \/><figcaption><em>x and y in excel graph: a visualization of the quarter of a circle that was calculated with the above explained excel sheet<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/bweb-circle-excel-coloured.jpg\" alt=\"\" class=\"wp-image-532\" width=\"400\" height=\"400\" srcset=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/bweb-circle-excel-coloured.jpg 800w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/bweb-circle-excel-coloured-300x300.jpg 300w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/bweb-circle-excel-coloured-150x150.jpg 150w, https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/bweb-circle-excel-coloured-768x768.jpg 768w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption><em>table and graph manually translated into colored scheme: the dark green is the quarter that was calculated, the light green the mirroring of it<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Creating-a-circle-with-excel.xlsx\">Here you can download the excel sheet which contains the formulas as described<\/a><a href=\"https:\/\/aliandlizzy.com\/wp-content\/uploads\/2021\/05\/Creating-a-circle-with-excel.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever tried to create a perfect circle or ball for your cross stitch-, crochet- or knitwork? In this article I will explain how to create a perfect 2-dimensional circle with the use of excel. I came across the book by Alyssa Westhoek and started to randomly cross stitch a sea and beach-life scenery.<span class=\"post-excerpt-end\">&hellip;<\/span><\/p>\n<p class=\"more-link\"><a href=\"https:\/\/aliandlizzy.com\/index.php\/2021\/05\/16\/creating-perfect-circles-part-1-two-dimensional-for-embroidery\/\" class=\"themebutton\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":532,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3],"tags":[86,80,81,82,79,85,75,41,4,78,83,87,84,76],"class_list":["post-502","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-embroidery","tag-alpha","tag-ball","tag-calculate","tag-calculation","tag-circle","tag-cosinus","tag-cross-stitch","tag-diy","tag-embroidery","tag-excel","tag-mathematics","tag-radius","tag-sinus","tag-stitch"],"_links":{"self":[{"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/posts\/502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/comments?post=502"}],"version-history":[{"count":31,"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/posts\/502\/revisions"}],"predecessor-version":[{"id":599,"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/posts\/502\/revisions\/599"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/media\/532"}],"wp:attachment":[{"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/categories?post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aliandlizzy.com\/index.php\/wp-json\/wp\/v2\/tags?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}