I am attaching a worksheet to figure out the balls per pound. The sheet is setup for PURE LEAD. If you are using other types lead, the number will be different. The density of the lead must know accurately for the calculation. The input cells are GREEN and the output cells are YELLOW. To start select ENABLE EDITING or you will not able to change anything. Next, inter the number balls in the GREEN cell and see the result in the YELLOW cell or inter the diameter of ball in GREEN cell and see the result in the YELLOW cell. I have a sample input loads in the right column in RED at the GREEN cell. The results are also shown in RED at the YELLOW cell. If you have problems, please let me know. This sheet will calculate from 1 ball to 100 balls, but remember this PURE LEAD.
The next worksheet shows Balls, Bore, Max, Min, Grains, Drams, and Ounces for balls 1 through 100. The Max and Min are for bore diameter. In the smaller diameters Max, Bore, and Min get very close. Some of them even get crazy do to rounding of calculations. I did the best I could with the numbers.
I think I have everything covered. Any questions please ask
The next worksheet shows Balls, Bore, Max, Min, Grains, Drams, and Ounces for balls 1 through 100. The Max and Min are for bore diameter. In the smaller diameters Max, Bore, and Min get very close. Some of them even get crazy do to rounding of calculations. I did the best I could with the numbers.
I think I have everything covered. Any questions please ask