or Connect
AVS › AVS Forum › Audio › DIY Speakers and Subs › Easy Horn Spreadsheet for Dummies
New Posts  All Forums:Forum Nav:

Easy Horn Spreadsheet for Dummies - Page 3

post #61 of 105
I forgot to post it that it works well in office 2007. I have to enable macros and they work well.

I have been working very long hours but I will take a good look shortly at the latest offering.

Nice interface!

Mark
post #62 of 105
Thread Starter 
Yet another update placed in the OP. v.7a

This time you can choose between None-Con-Exp-Par settings from the spreadsheet, and you can alter the compression here as well. You asked for it, so here it is.

If you guys have any suggestions for things to add, please let me know. The driver data base, and an extra equation or two should roll out next time. I feel this is getting towards the end of the regular updates for this part of things though.

post #63 of 105
Thread Starter 
Alright, v.8a is out. It's in the OP.

The driver data base has been added. It allows loading, saving new drivers, and rewrites.

I threw ~50 drivers in there from the usual suspects to get you started.

Under the main section is also a resonator length calculator, and a unit conversion area. The conversion box is also located on the driver data page as well. The extra driver parameters can also be input down there.

The needed parameters are still up top. The ones at the bottom, are just for reference right now, and the missing ones are calculated by the main sheet to the right already.

When I get the folding part done (don't expect it soon) it will use these other parameters.

I'm also going to redo the how-to part of the thread to reflect the newer changes.
post #64 of 105
Sweet!

I'll take it for a spin in the morning.

Thanks Soho

Mark
post #65 of 105
Thread Starter 
Just to mess with you I added a driver sag percentage readout, and uploaded it under the same name.
post #66 of 105
Driver sag as in non-centered voicecoil from sitting upadaside down?

To much! My little brain is gonna esplode!

Now I just have to figure how much my drivers are sagging and tada....

It actually does vary the output of the enclosure. You get a non-linear BL curve that reflects the actual position of the voice coil from it's rest position while it is upside down.



Mark
post #67 of 105
Thread Starter 
I don't know how many of you guys are playing with this out there, but I want to ask you guys to try something out.

In the latest build to the right under the Derived Horn Parameters column are two new bits Ral & Rat. Up above is Vb, and further up is Total Vas.

Try setting the Low Corner to the suggested LC, and solving for HC. Then check Ral & Rat, and get them to equalize as best as you can by changing the m(horn flare) parameter, and resolving for HC. When they equalize Vb should be half of Total Vas. (Vb is in another unit, the decimal should be moved over 3 places to the left =Vb/1000)

If the Vb does not equal 1/2 Total Vas when Ral & Rat are equalized you have to change the LC. If Vb is larger, then try moving the low corner up.

Use the 4 section TH parameters, and check things out. I'm getting interesting results with the drivers I'm trying.
post #68 of 105
Thread Starter 
I will add some drivers will not work out unless you add two, and other just will not do this.

The ones that do, are all in DSL horns or are similar to them. From what I see so far.

EDIT: the default Anarchy just doesn't want to work for me for example.
post #69 of 105
That is interesting. Tried it first with the W8-740P just to see what it looked like, and then tried it again with the SDX10.

I can almost get it to work with the SDX, but not quite. Best I can do is about Vb 80% of total Vas. Even so, it still came out looking great.

I'll have to remember this little trick.
post #70 of 105
I tink I said at least once that a tapped horn likes few drivers. Or was few drivers like tapped horns.

Quote:
I will add some drivers will not work out unless you add two, and other just will not do this.

The ones that do, are all in DSL horns or are similar to them. From what I see so far.

EDIT: the default Anarchy just doesn't want to work for me for example.
Proof either I'm not crazy or soho and I are crazy.

More things to mess with and I'm to sleep deprived to get anything really going. Maybe on the weekend.

Mark
post #71 of 105
Quote:
Originally Posted by mwmkravchenko View Post
I tink I said at least once that a tapped horn likes few drivers. Or was few drivers like tapped horns.
I would say TH's love only a few drivers. They like a few more drivers. And then they dislike the majority of drivers

I was considering the TC Sounds Epic 10 instead of the SDX's. That one is in the "love" category (as I've just found out thanks to this trick), and matches up with my goals better. But the SDX is close enough to do the job, and from a Canadian company. I'd say the SDX is at the upper end of "like" with my Tang Band woofers at the lower end of the same category.
post #72 of 105
Thread Starter 
This is a small update.

I fixed the driver nominal size non-sorting error.
Added more of the Leach math to the right of the main inputs.
I also added some minor extra calculators, and a new driver data base parameter.

File in located in First Post.
post #73 of 105
Maybe just one day when I have no hair at all I will finally get my head around this spreadsheet! You are a wizard Soho.

Thanks once again.

Mark
post #74 of 105
sorry im such a rookie at this process, but i want to start learning tapped horns rather than leeching. this is in regards to tapped horns

regardless of the numbers in the picture, do i take the numbers from column 1 or column 2 from the spreadsheet to input into Hornresponse.

in the spreadsheet do i set the horn profile to con/par for tapped horns?
LL
post #75 of 105
Thread Starter 
We all have to start somewhere. Feel free to ask away. I'll keep answering as long as you are asking.

You want to stay away from Column 2, and most all of the stuff to the right in the white area for now. All the info you need is shown in the main window. The stuff to the right is more a "show your work" area, with a few more advanced calculations, for some of the people who may want them.

You shouldn't have the green triangles. It seems I forgot to lock the program down. Give me about two minutes, and I'll upload a new copy with it back on, so you can't type anything into the wrong box. That's my bad.

Back to your question about CON/PAR, you can use either one. It really depends on how you plan on doing the folding. I would just stick with PAR to begin with.
post #76 of 105
Thread Starter 
I have also been getting some questions about how to change to/from CON/PAR/EXP.

Here is a pic.


You just click on the yellow "None" cell, and a dropdown pops up. You activate the Compression Override the same way.
post #77 of 105
appreciate it greatly soho. Ive always just built tapped horns (7) this year mainly from lilmike, hes got me addicted and I'm going to need an intervention shortly. for now id just like to understand the simulations and getting that dialed in.

based on using the 'par' profile in the spreadsheet, i then need to change the inputs in hornreponse to 'par' from 'con' correct?

could i stick with 'con' and be okay? whenever i look at everyone else's sims, they always have 'con' in hornreponse.

thanks again
post #78 of 105
Thread Starter 
Quote:
based on using the 'par' profile in the spreadsheet, i then need to change the inputs in hornreponse to 'par' from 'con' correct?
Yes, if you input something other than None into the spreadsheet you want to use the same setting in HR. None is for using the HR Wizard, with the S2 Variable option on.

Quote:
could i stick with 'con' and be okay? whenever i look at everyone else's sims, they always have 'con' in hornreponse.
Yes, you can. The difference isn't great, with a 4 segment horn.

The key to which to use depends on if you are using 3 or 4 segments, and the method you are going to use to fold the horn.

The common folding methods illustrated lend themselves to a PAR flare.

There was a post awhile back in the thread where I was asked a similar question, and went a little in-depth. I am trying to find a simpler way of expressing things, but haven't found the right words yet. Until them check out the old post #58.
http://www.avsforum.com/avs-vb/showp...7&postcount=58
post #79 of 105
Another newb question here. I find that most of the drivers I select in the drop-down violate the >= .5 and <= .707 Horn Flare thresholds. What are the repurcussions of this?

Thanks!
post #80 of 105
Thread Starter 
You had me scratching my head for a minute there.

Then I realized you are setting the Low Corner and High Cutoff, and solving for the Flare, yes?

In the case, it can turn out an m parameter above or below the suggested range. The further away from this range you get, the less the "reactance annulling" portion of the equations work. If you aren't worried about "RA" it is no big deal. If you are you can correct the Vb, or alter the horn profile a little to adjust for it in Hornresp. Most of the time is it still pretty close.

Most of the time this is a function of going way over the drivers mass roll off frequency with the HC. You can find the equation to the right under "fH pos high" the equation is =(2*fs)/Qts from Keele.

For a sub, I set the Flare and LC, and solve for HC. Sometime you just end up with a low HC. The TH-50 has a suggested bandwidth of 21-70Hz, and if you put the driver through the sheet you will see why.
post #81 of 105
Yes, I was solving for the flare as you noted. I will play around with it some more and see how it goes.

I appreciate your help.
post #82 of 105
What does it mean when the S2, S3, etc parameters are calculated as 1.0? What do I enter in hornresp? Thanks for making this btw.
post #83 of 105
Ah, never mind. Your screen shot 6 posts up answered my question. I just needed to select a horn profile.
post #84 of 105
Thread Starter 
You're welcome.

EDIT: I type too slow sometimes.

The S#s come out as 1.00 when the Hornresp Flare Profile is set to "None." If you click "None" a dropbox will pop up, and allow you to choose None, Con, EXP, or PAR.

You can use the None option when you are going to be using the Loudspeaker Wizard in Hornresp, as it saves a little input time. You just input the 1.00 as they are, and then in the Wizard change Horn-S2 Fixed to S2 Variable, and HR will alter the 1.00s itself.

I think I will redo the dropdown box to always show the drop arrow like the Driver Choice one. I'll do the Compression Override while I'm at it.
post #85 of 105
I just noticed this thread. Nice job, Soho!
post #86 of 105
soho,

Do you have an ETA for the re-worked tutorial at the beginning of the thread?

thanks!
post #87 of 105
Thread Starter 
Quote:
Originally Posted by PrimeMover View Post
Do you have an ETA for the re-worked tutorial at the beginning of the thread?
Not really. It keeps getting bumped, by other projects, and continued work on the other unfinished portions of this spreadsheet project.

The wife and kid are gone for the weekend, so I should have time to get it done over the next few days.
post #88 of 105
Thanks, your effort is greatly appreciated!
post #89 of 105
Thread Starter 
I added in the updated instructions to the first few posts. I think I covered most everything. If I left anything out, or some of it still doesn't make any sense let me know, and I'll add some more to it.
post #90 of 105
Great, I will get started tomorrow!
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: DIY Speakers and Subs
AVS › AVS Forum › Audio › DIY Speakers and Subs › Easy Horn Spreadsheet for Dummies