Vent Hole Size Calculator Spreadsheet

The Rocketry Forum

Help Support The Rocketry Forum:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
Joined
Jan 4, 2011
Messages
126
Reaction score
0
No sure what vent hole size to use? Jackson made the attached vent hole size calculator for his minimum diameter N5800 project. The spreadsheet uses pressure data from RockSim to calculate the maximum amount of force that will build up inside the area to be vented during the flight’s ascent.

For ordinary flights, it is easy to approximate the vent hole size based on what has worked for other flights. But, there is not always sufficient opportunity to test the vent hole size on a high mach flight. We knew we only had one shot at it. Better to do some calculating in advance.

The spreadsheet uses recursion of a formula based on an analogy to an RC filter. The RC filter and the formula were first conceptualized by David Schultz. Schultz’s original work is referenced in the spreadsheet.

The spreadsheet contains both a data sheet, and an instructions page. Read the instructions page. But, the basic gist of it is: sim your rocket and export the pressure data. Then, put this data into the spreadsheet. Enter the length and diameter of the area to vent. Then, enter a vent hole size. You will have to use the sheet recursively. Continue to try various sizes until the max force that is calculated is small enough for your own comfort zone. Remember that 2-56 nylon screws fail at 25 pounds. The max force should be less than what your shear pins will hold.

We have attached an Excel spreadsheet. We also have a Numbers version, but could not upload that file. PM us if you want the numbers version.

View attachment Vent Hole.xls
 
Having trouble getting this spread sheet to work. Need help with venting two rockets.

1) main bay is 1.25 in diameter x 7 inches for a volume of 8.6 cu in; apogee bay 1.25 x 5.75 in for a volume of 7.
This rocket will reach 3000-3500 with peak velocity of .63 mach

2) main bay is 5.4 in diameter x 20 inches for a volume of 458 cu in; apogee bay 5.4 x 14 in for a volume of 320
This rocket will reach peak altitude about 6000 with peak velocity of about .73 mach.

Thanks to anyone who can be of help here.
 
Back
Top