x
Calculation of Circles - BY HAYMO BOGG

It is always complicated to design circles with the Konstruktor, because circles have to be drawn as polygones. Polygones up to 8 vertices can be drawn rather easely without tools, but will they also have the right diameter? Polygones with 6 to 8 vertices are not enough to build a circle. it is better to tke 12, 16 or even better 36 corners.
I have produces a spreadsheet to calculate all ko-ordinates of the vertices of such polygones from the parameters: diameter, ko-ordinates of the lowest vertex and the number of vertices. This spreadsheet was developed with MS Excel for Windows 95, but could easely used with other spreadsheet programs (it does not contain important macros or complex functions - maybe the function PI() which is used in the formulars has to be adopted).

Guidance:
On each page of the spreadsheet 3 circles (design parts) can be calculated and documented. Each polygone can have up to 36 vertices. Note: if you need more than 36 vertices just copy the the formulars from row 42 to the number of rows you need to cover the wished number of corner points.
The yellow colored cells are input cells. The meaning of each cell is self explaining. You just must consider that the X- resp. the Z- and Y-ko-ordinate are always in the drawing area of the Konstruktor. I.e. X is the horizontal and Y the vertical axis; Z ist the distance from the XY-area (not shown in the drawing).
Circle can be located parallel or upright to the drawing area (XY-area). Is the location of the circle parallel to the XY-area enter the X- and Y-values of the lowest vertex of the polygone (Z is constant). Is the circle upright to the XY-area located enter the Y- and Z-values (X is constant). Enter the name of the variable ko-ordinate "X" or "Z" into the header cell of the relevant column. This controls the preciseness of the results in this column. If the values in this column are X-values the values will be rounded to even integers, if the values are Z-values they will be rounded to integers only.

Restriction: for polygons which do not stand on a vertex the formulars have to adopted.