
Home  Forums  Rules  Articles  The diyAudio Store  Gallery  Blogs  Register  Donations  FAQ  Calendar  Search  Today's Posts  Mark Forums Read  Search 

Please consider donating to help us continue to serve you.
Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving 

Thread Tools  Search this Thread 
12th August 2010, 12:12 AM  #1 
diyAudio Member
Join Date: Nov 2007

Spreadsheet for Folded Horn Layouts...
To avoid any further threadjacking of another thread, I'm starting a new thread to cover this idea: an Excel spreadsheet that can be used to quickly determine panel dimensions for certain folded bass horns. To use it, you basically enter the relevant parameters for the chosen bass horn you'd like to build, and then determine the panel dimensions via the builtin "Goal Seek" function. The spreadsheet also includes a graph that shows the crosssection of the folded horn.
If there are any similar spreadsheets available on the Internet, please let me know, so wheelinventing can be avoided . At the moment, only one "fold" is included in the attached spreadsheet, but it should be possible to include other folding schemes, once they can be described mathematically. Some notes on the attached spreadsheet: 1. Figures in bold blue are the ones you get to play with. 2. Enter the TH's basic parameters into the corresponding cells  S1 (throat, cm^2), S4 (mouth, cm^2) and path length L (cm). 3. For "p", enter the thickness of the wood or ply (cm) that you plan to use for this design. 4. Choose an initial internal depth and height for the box that you'd like to use to implement your chosen TH and enter under "d" and "h". Adjust until the value for "Lcheck" is close or equal to "L". Easiest way to do this is to use Excel's "Goal Seek" function to find a value for "d" or "h" that sets "Lcheck" to the same value as "L". I recommend keeping a square profile for the box (e.g. set "h" equal to "d"). 5. Examine "L1Check" and "dL". These indicate the possible error that your chosen geometry (ratio of height to depth) might introduce. If it's too high, then repeat step 4 with different values for "d" and "h". 6. Use Excel's goalseek function to set the value for "balance" to zero by changing the value for "w". This result will be the required internal width for the box to achieve the target TH alignment with the folding scheme illustrated in the spreadsheet. 7. Once you've completed steps 2  6, the crosssection of your TH will be illustrated in the righthand graph. If you've completed the steps right, the graph should illustrate a crosssection consisting of panels of equal thickness. If you haven't completed the steps correctly, the crosssection will not look right. 8. The dimensions for each required panel are given in the green table at the bottom of the spreadsheet. All dimensions are in cm. Note  the bracing panels are not included in this list of panels, but you should be able to figure these out on your own. The calculations don't take the effect of bracing into effect, but once the the braces are kept small, their effect on the horn's response shouldn't be significant. If you're concerned about the effect of any bracing, try starting with a slightly larger value for S1 than suggested by the HornResp sim, then design your bracing to bring the crosssections at different points at the horn back into close alignment with the HornResp sim. 9. The panel dimensions given assume that buttjoints are used throughout. 
12th August 2010, 12:58 AM  #2 
diyAudio Member
Join Date: Nov 2007

One issue that's come up is calculated horn length.
I used the "centerline" method to determine horn length. I've also not included any "end effects" in the calculation. I used the spreadsheet to produce the layout for my POC2 TH. It predicted a horn length of 245cm (as required by HornResp). However, when I measured the TH's lowest resonance frequency, it turned out to be more like 43 Hz, not 40 Hz as predicted by HornResp. Reverseengineering this in HornResp (i.e. adjusting the path length until the predicted resonance frequency increased to 43 Hz) results in an effective path length of 231 cm, which is much shorter than that given by either the centerline method or the squareroot method. Any ideas? 
12th August 2010, 09:04 AM  #3 
Mark Kravchenko
diyAudio Member

You are worried about 3 hz?
For one thing Fs usually goes up when a driver is actually in a horn. The air mass loading inside the box is different than outside. Especially in a tapped horn as compact as yours. Another thing is how well broken in is the driver? That 3 hz should even out After a bit oh exercise. Playing with the spreadsheet is pretty cool. Still have to figure out the auto function but it seems to do what you designed it for. I'll mess with it some more tonight. I'll punch in a couple other horns. Now many I have designed are up to S5 in the sections. I have taken for granted that you are simply looking for beginning area, path length and mouth area. Is this correct? One question is if you could set it up with sections as Hornresp could you then calculate horns with a partial negative flare rate? Lots of my designs seem to function better with a section that acts more like a resonator than a true horn flare. Mark 
12th August 2010, 01:42 PM  #4  
diyAudio Member
Join Date: Nov 2007

Yup . More correctly, I'm worried about a measured result that's 7.5% off the predicted result.
Quote:
Quote:


12th August 2010, 01:52 PM  #5 
diyAudio Member
Join Date: Jan 2009
Location: Columbus, Ohio

Is the different panel colors an option...example: red for incorrect length & blue for correct length?

12th August 2010, 02:59 PM  #6 
diyAudio Member
Join Date: Nov 2007

I've attached an updated version of the spreadsheet that does this. When the graph is red, the panel dimensions have not been optimized. When optimized, the graph turns blue.

12th August 2010, 05:30 PM  #7 
diyAudio Member
Join Date: Jan 2009
Location: Columbus, Ohio

Nice!!! How about swapping the locations of the Horn Expansion and CrossSection charts for us blind folks?

12th August 2010, 06:11 PM  #8 
diyAudio Member
Join Date: Jan 2009
Location: Columbus, Ohio

How was I able to obtain a 132.82L blue enclosure when my inputs are for a 210L enclosure?
L = 274.32 108.00 balance = 0.00 S1 = 516.13 Lcheck = 172.2 hmin = 6.42 L'check = 167.8 S4 = 1032.26 dL = 4.4 hmax = 12.84 2.5% p = 1.91 0.75 d = 40.64 16.00 17.50 h = 40.64 16.00 17.50 w = 80.42 31.66 33.16 delta = 0.02 Vol (1) = 212.38 l. 7.50 cu.ft. Vol (2) = 166.42 l. 5.88 cu.ft. Last edited by BP1Fanatic; 12th August 2010 at 06:22 PM. 
12th August 2010, 06:32 PM  #9  
diyAudio Member
Join Date: Nov 2007

Quote:
It looks like you have to complete steps 4 and 6 about three times to get the correct results (the chart plotting component that swaps the colours in the graph only checks the "balance" figure, not the "Lcheck" figure). 

12th August 2010, 08:16 PM  #10  
diyAudio Member
Join Date: Dec 2005
Location: Georgia

Quote:
I haven't looked at your sheet yet. Is it unlocked? You will have better luck if you can get the program to use SQRT(Inside path*Outside path) as the length of each section. This is the easiest way to get the average path length. 

Thread Tools  Search this Thread 


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Folded horn length  Don Snyder  Subwoofers  3  2nd May 2009 12:14 AM 
how to go from horn response to a folded bass horn design?  paulspencer  Subwoofers  8  4th November 2005 11:44 PM 
Looking For Folded Horn Sub Plans  nniwelt  Subwoofers  16  29th August 2005 05:43 AM 
Folded horn for Tannoy?  panos29  MultiWay  12  17th October 2003 09:59 AM 
New To Site?  Need Help? 