Spreadsheet for Folded Horn Layouts...
1 Attachment(s)
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. 
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? 
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 
Quote:
Quote:
Quote:

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

1 Attachment(s)
Quote:

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

How was I able to obtain a 132.82L blue enclosure when my inputs are for a 210L enclosure?
http://dingo.care2.com/pictures/c2c/.../5/9529744.jpg http://dingo.care2.com/pictures/c2c/.../5/9529747.jpg 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. http://dingo.care2.com/pictures/c2c/.../5/9529753.jpg 
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). 
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. 
All times are GMT. The time now is 09:26 PM. 
vBulletin Optimisation provided by
vB Optimise (Pro) 
vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Copyright ©19992016 diyAudio