Keyboard Shortcuts
Likes
Search
Dividing head spreadsheet, automagic.
¿ªÔÆÌåÓýHi Gang: I just posted my spreadsheet for dividing heads. It can be adjusted for any ratio dividing head. 1) cell B1 is the input for the ratio. Change this number and everything updates. 2) the first four fields are figures for the four standard plate that come with Bridgeport heads. 3) the big field covers all division up to 120, and then some random divisions. 4) the cells in columns B, C, D and G contain formulas, so don't edit them. 5) column E is where you input the hole plate you can use, these numbers are adjusted for a 40:1 head. If you change ratio, these may need to change. Partial turn column reduces the partial turn to a fraction that will give you a clue to which plate to use: so for 7 division it shows 5/7, so the plate needs to be a 7 hole or a multiple of 7: 14,21,28,35 etc. It is fun to play with, once you adjust it to your head print a copy and keep it handy. Good luck. Carl. |