wp55b0dd48.png
wpd530b04e.png
wp91074f43.jpg
wpa4923fff.jpg
wp0fe7637b.jpg
wp54b53ef2.jpg

Harold Hall

wpff6a4396.png
wpcbf9ee95.png

The following is a simulated screen print for a spread sheet calculating the hole coordinates for holes placed in an enclosing diameter. Note the following--

 

a. The column headings A, B, C, etc. and the row numbers, 1, 2, 3, etc.

 

b. There are just two user entered items A6 and B6. That is  5 and 0.650.

 

c. From the two entered items the sheet calculates, Hole diameter (B11), Radius at hole centre (C11), angle between holes (D11) and the coordinates for both methods, that is as Sk.1 (Circle centre) and Sk.2 (extreme coordinates)

 

d. With the cursor resting on a cell the formula within that cell, if any, is shown at the bottom of the page, B16 being shown in this case.

Metalworking

Workshop Processes

 

 File/Print  Cut/Paste  Layout  Advanced                   OUTERPCD.CAL

          A      |       B       |       C       |       D      |       E      |

1    CALCULATES CO-ORDINATES OF HOLES IN AN ENCLOSING OUTSIDE DIAMETER          |

2   ----------------------------------------------------------------------------|

3         USER ENTERED ITEMS      |               |              |              |

4   NUMBER OF     |     OUTER     |               |              |              |

5   HOLES         |     RADIUS    |               |              |              |

6         5       |     0.650     |               |              |              |

7   ----------------------------------------------------------------------------|

8                             PROGRAM CALCULATED ITEMS                          |

9                 | Hole diameter |   Radius at   |    Angle     |              |

10                |               |  hole centre  | Between Holes|              |

11                |     0.481     |     0.409     |    72.000    |              |

12  ----------------------------------------------------------------------------|

13                |         RELATIVE TO           |         RELATIVE TO         |

14                |        CIRCLE CENTRE          |     EXTREME COORDINATES     |

15  HOLE NUMBER   | Co-ordinate X | Co-ordinate Y |      X       |      Y       |

16        1       |      0.409    |         0     |    0.819     |    0.409     |

17        2       |      0.127    |     0.389     |    0.536     |    0.020     |

18        3       |     -0.331    |     0.241     |    0.078     |    0.169     |

19        4       |     -0.331    |    -0.241     |    0.078     |    0.650     |

20        5       |      0.127    |    -0.389     |    0.536     |    0.799     |

21        0       |          0    |         0     |        0     |        0     |

                                                                      

B16/Formula: C11*COS((A16-1)*(((2*PI)/360)*D11))

wpff6a4396.png