Download the spreadsheet file by clicking this link : Check Valve Calculator Spreadsheet

Using MS Edge as an example this will download the file to your Downloads folder – click the Open File option:

As this is a file downloaded from the internet Excel may prompt you to Enable Editing – you need to click the button at the top of the screen:

 

Changing the bore size materially affects the ball chamber minimum height and diameter dimensions, albeit not by a great amount. As the bore sizes are not standard drill sizes this is inevitable.
The separate interactive line illustrates the difference when the bore for a ¼ inch ball is changed from the optimum 0.177 to the drill size 0.187 (3/16) inch.
Using the interactive line solves the problem.
As it appears in this printout, the chart is only displaying the columns of interest to the user.
Should you find the calculations interesting they can be fully disclosed by ‘unhiding’ all columns between A and Q.

 

The spreadsheet is also available to be downloaded in a compressed (zipped) form from <Check Valve Calculator Zip> – this will require extracting before use.

We have also created an Online calculator based on the formulas in Martins spreadsheet : Online Check Valve Calculator