Here is an Excel spreadsheet that will help you design a few different things in Hornresp. It will model a single/multiple driver horn in TH, Nd, and OD configurations, in 3 or 4 sections. It will also do a BP type of quarter-wave resonator, and T-TQWT.
The following few posts will show how to use the program, and what to expect.
Before I forget, let's thank Marshal Leach, Richard Long, and Tom Danley. They did all the real work.
The majority of the math I used can be found here: http://users.ece.gatech.edu/~mleach/papers/HornPaper/HornPaper.pdf
Thanks go out to David McBean as well. Without his program there would be no need for this.
I tried to make the program as easy to use as possible. To that end all cells that the user can change are colored yellow. All normal outputs are light blue cells with dark blue writing.
Everything you generally need to use the program is shown in the picture in the first post. I tried to centrally locate as much functionality as possible.
The first thing you want to do is to input the needed Driver parameters. You can find these cells here:
You can use the dropdown menu to pick a previously saved Driver, or enter a new Driver by filling in the yellow cells. There are around 60 driver pre-entered into the Data Bass right now. You can then click the Save Driver button to save it into the sheet. If you need to change something just alter the yellow cell in question. If you want to save the new change, just click the Save Driver/Changes button again.
If you scroll down some you will find a new area to enter even more Driver info. It is partly there to allow you to create a detailed driver data base for your own use, and some of the info will be needed in future updates.
Some have found the parameter inputs a little lacking, as there are some major parameters not input. The reason for this is that the sheet calculates them to the right of the main section for you.
Now it is time to start setting up the enclosure. This is done here:
All three input can be input manually, or you can input two and calculate the third.
The first parameter is the Horn Flare. The is the "m" parameter from the Leach paper. It determines the rate of change of the horns area as it moves between the throat and mouth. The specified range to the right is the range in which the Reactance Annulling math should be correct. As you get further way from this range it gets less accurate. This is were Hornresp would be used to alter things slightly to pull things back inline.
The Low Corner -3dB is just what you thing it is. This is the -3dB point below the Low Corner. It is most accurate with THs, as that is what everything is geared for. With the other alignments you will find the LC a little below this figure.
High Cutoff Freq. is the -3dB figure on the high side. This pertains to the horn loading, so is more inline with power response.
Below these three you see two cells named fL and fO. These are used to set the horns Reactance Annulment. fL is based off you Low Corner. You alter the Horn Flare and High Cutoff to adjust fO to equal fL as close as you feel is needed.
Further down you will find two buttons, Find Flare and Find HC Freq. Find Flare takes the LC and HC you input above, and finds the Horn Flare that fits them. Find HC Freq uses the LC and Horn Flare to find the correct HC for the pair.
It's now time to start looking at the enclosure outputs (Hornresp Inputs.)
If you notice the default Horn Flare Profile in the center is None. This is a hold over from the first versions of the sheet. It was designed to allow you to get into the Loudspeaker Wizard as fast as possible, and as such it gives you 1's in the cells that HR will auto calculate for you from the others. The new version of HR may have me taking this option out.
You can change this by clicking into the None cell. This will allow you to pick the Hornresp Con, Exp, or Par options.
If you look back to the left at the Compression cells, and it is higher than you want it (or lower,) you can also click on the None there to engage the Compression Override. This will alter the horn parameters for you.
The Vented Sub outputs are there for a quick comparison/reality check on your horns in Hornresp.
The Custom HYP Flare Calc is there to allow you to pick your own distances between point with the Length parameter. It allows you to enter a Width, and outputs a Height as well if you want to do some thing outside of Hornresp.
Sometimes you can get something like this to happen:
It happens when you start trying to tune an enclosure with a high LC Freq.
If you are doing a Nd/Od horn just input the parameters, and move on.
If you are after a TH the horn cutoff is too high, and the physical horn path is not long enough to place the Rear Tap the right distance from the throat. If you really want to make this combo work you will have to input it "as is" in Hornresp, and play with the Loudspeaker Wizard.
In the T-TQWT you can just substitute 1cm for the negative number. I'll have it automatically do that in a future update.
The Vented Sub is just tuned too high for the enclosure space.
I have been getting some questions about the AE drivers, and why there is no dimensional info on them.
It's because the info is a pain to get too, as it is not listed with the driver parameters themselves. I went back and added in the easy to find models info. I'll post a picture here, and add a zip file. You can either copy paste from the zip, or manually input them from the pic.
If anyone has the remaining missing parameters please feel free to post them here.
That is odd. The attachments should download with no problems.
I just rechecked on my end, and they all work in IE, FF, and Opera for me.
Try right clicking the attachment, and selecting Copy Link Location. Then paste it into the address bar, and hit Enter. Now choose Save File, and you should be good to go. If not, you are having a major configuration issue.
Hi, I am using win 7 home pro. I had another file stop loading as well from another site but fixed that by reassociating it to winrar again. :huh:
When I find a solution I will let you know.
Hi Soho,
i can't get the horn excel zip file opened. i get a blanc page. Is your file still available?
I tried to copy the link with the right button and open it in an new page. it didn't work. :help:
with kind regards.
Koen
I also couldn't download the file... it would only open a 1-pixel gif. Firefox, IE, Chrome, on both WinXP and 7.
The file download at AVS also had an error, but the copy soho54 posted on DIYAudio worked
Hello all,
My first post, and I am UK based, so first a big hello to all.
So.... I would like to build a large subwoofer, this is to be used in a large poor acoustic/room around 80ft by 60ft with a suspended ceiling and some reflective surfaces, it is a large workshop within a large warehouse...
Hello all I am new to this site from over the pond
I have four Kicker CompVR 15" woofers that I took out of my US Truck that was imported. Initially, I figured I would sell them but I thought I might be able to use them for HT woofers.
I am a complete novice to woofers, however have built many...
Does anyone have any enclosures they're not currently using or just taking up space in store. I'm willing to pickup in California but Bay Area Preferred
open to 8"/12"/15"/18"
vented/sealed/horn/passive radiator
LMK What you might have before I go and buy a whole lot of MDF and make a huge...
What I want is a pair of home stereo subs that can do 16 Hz with MINIMUM distortion and HIGH amplitude. I'm thinking that to do this, I'll need some serious cone area (15" minimum?) and a relatively BIG box. I'm open to using either a sealed or ported box. Rather than use a plate amp, I have...
What is the best option regarding the sound: Two subs in parallel (mono 4ohms) and 1x500W, or 2subs 8ohms stereo 2x200W?
I have built two BR subs with BMS 12S330, 8ohms, 60 litres/ 33Hz -3dB. I will use DSP and cross at 60 - 80Hz.
Subs are intended for music only! I consider Hypex Ncore...
A forum community dedicated to home theater owners and enthusiasts. Come join the discussion about home audio/video, home theaters, troubleshooting, projects, DIY’s, product reviews and more!
