This content has been marked as final.
Show 2 replies

Formula to Calculate a Bolt Hole Pattern
Martin Stevens Aug 29, 2007 7:29 AM (in response to Guest )I just stumbled across your question. If you've not figured thisout by now...
I will still make a suggestion for others who also 'stumble across'this topic.
Though i've not tried to set this up myself, I do use the formulato calculate chord length often. Here goes: 180 / number of holes =a
chordlength = sin a * P.C.D.
Just remember that if you want to use any trig formula in Excelthat all angles have to be converted to radians before the functionis applied to the value.
e.g. for same formula above: 180 / number of holes = a
a* pi / 180 = r
chordlength = sin r * P.C.D.
Refer to the help file in Excel how to use formulas. For example pi/ 180 should be entered as PI()/180
Hope this helps someone! 
Formula to Calculate a Bolt Hole Pattern
Eddie Cyganik Sep 4, 2007 4:40 PM (in response to Guest )Hey Macgeyver,
What kind of question is that?
I remember in one of your earlier episodes,
...you took a washer, pocket lint, a piece of chewing gum and some clam shells to triggerout how to defuse an atom bomb.
...Come on, use your noodle.