DIYMobileAudio.com Car Stereo Forum banner

Jazzi's tuning companion for room eq wizard

236K views 506 replies 93 participants last post by  tjk_bail  
#1 · (Edited by Moderator)
Note: See the link in my signature to download the latest version of this tool.

This spreadsheet has been a lot of fun to make! My goal is to take as much guesswork out of the tuning and installation process as possible. With this tool, you can calculate a safe high-pass crossover point for your midbass and midrange speakers, then plug those numbers into the next sheet where you choose what frequency response curve you want your overall system to have, and the tool will generate a set of custom house curve files tailored for each of your speakers. Import those directly into Room EQ Wizard and use the EQ module to find the filters for your DSP.

If you use the next sheet to calculate time delay settings for all of your speakers, and you get them to match the house curves exported from earlier, then your tuning is mostly done! I recommend spending some more time with 31-band pink noise tracks to get the center image perfectly centered, and you can download some ones I made from my dropbox at this link:

-----> 31-band pink noise tracks <-----

A bonus feature I included is an interactive chart to help you choose which size power wire and fuse for your amplifiers. The sheet will take into account the efficiency of your amplifier (effecting how much power it will need to be supplied with) as well as the condition of your car (engine on or off) and you can choose how much of a voltage drop is acceptable to you. Lastly, measure about how long the power wire needs to be and then you will see which size wire and fuse you will need. A ton of research went into this particular sheet, and I'm looking forward to everyone's feedback.

There is an included read-me with instructions for each section with some hints and cautions.

Like I mention in the included read-me, please let me know if this is useful for you and if you would like me to build more features into this spreadsheet.

Here are some screenshots:

Image


Image


Image
 
#3 ·
With the crossover curve builder, is that easily adjustable in dB/frequency? I can't open it from work.

If so, this is exactly the thing I've been looking for. I've resorted to building my own in excel but nothing on this level that allows on the fly adjustments. Much appreciated.


Edit: read your description again. Looks like it's not exactly what I thought but it still will do the job. Kudos!
 
#4 ·
I want to test this out ASAP.

I have been thus far using a house curve in REW and using the native Target Settings for a 24 dB slope crossover. But that crossover in REW is butterworth not LR.

I also tried using RePhase to generate target curves for LR24 slopes but that didn't work either.

Lastly, I tried using the ACD spreadsheets but they are incredibly complicated to use so I didn't get very far.

I'll check your spreadsheets out soon and report back.
Thanks for your efforts thus far!


Sent from my iPhone using Tapatalk
 
#8 ·
Beta version 2 has been uploaded.

-Fixed the text file export of the JBL/Andy curve
-Added more flexibility:
-Now you can select different crossover frequencies for your highpass and lowpass
-Now you can select between either a 12dB/octave Butterworth or a 24dB/octave Linkwitz-Riley crossover
-Cleaned up the interface a bunch, hid a lot of the background work

Future plans:
-If you can help me find the equations/formulas, I will add more options for crossover types such as Bessel, Chebychev, etc
-I would like to add a sheet to help you with time delay settings
-I would like to add more pictures and better instructions on how to use these text files within REW
 
#12 ·
-I would like to add a sheet to help you with time delay settings
-I would like to add more pictures and better instructions on how to use these text files within REW


If you're interested, I can send over the excel file I made that was used to build this site:
http://tracerite.com/calc.html

You can just incorporate that in to your sheet. It would save you a lot of time. I even made one with temperature/humidity considerations.

LMK if you're interested and I'll send it on over.

- Erin
 
#9 ·
Yes!!! I've been creating my own curves by manually creating a text file to align with my specific needs. I can't wait to give it a shot!
 
#11 ·
Feedback:

Just loaded up your spreadsheets. This looks really great! You've done a very good job.

Very simple and intuitive layout. You made this so easy to follow. I have tried using the ACD spreadsheets in the past, and those are so complicated that I could never figure them out. And I always thought I was good with spreadsheets. :confused:

As I mentioned above, you are meeting a need which I have hoped to see met for a long time. REW has crossover settings available but they are only Butterworth 12 or 24 dB slopes. I prefer Linkwitz so I have been trying to find a way to get a downward sloping house curve with LR24 slopes for the crossovers. Your spreadsheet does exactly that. Very cool.


I have not been able to change the Frequency settings because those cells are protected by a password. Can you unprotect those cells for user input? I would like to try this out with my car, but I need to change the Frequency settings first.
 
#20 ·
:bowdown: Dude your a bloody god send....
 
#21 ·
More review:

I used the spreadsheet for a tuning session a few days ago.

It took me a couple of tries to get the export to work. FYI - Mac users, the spreadsheet will open on Office for Mac, but I don't think the export was working. So I opened it with Office on Parallels and it worked fine. No big deal.

I used a custom house curve by entering data on the right side column. It might be a nice addition if the frequencies on the custom column were also adjustable.


Just a note on REW house curves. When you load up these crossover curves, make sure you go into EQ section, then Target Settings and set "Speaker Type" to "None." The reason why is because these curves that the spreadsheet is generating already have crossover slopes applied. You want to disable the additional slopes added by REW.
 
#23 ·
Thank you so much!!!! this is exactly what I was looking for!!

Big up to you!! :D
 
#24 ·
I'm glad you enjoy it, and a big thank you to everyone for your feedback.

School has started again so I don't have as much time to put into this project as I wanted to, but perhaps I'll make some more progress again one day.
 
#26 ·
First you should get your install ready... :p
 
#32 · (Edited)
Ok Wow just Wow! Slick!!!

Can't wait until this audit's over so I can get back to re-tuning among a few other hundred items. This will go nicely with some tips and explanation, thank you Hanatsu for that, to match the better of two like drivers to the curve, then the more ragged of the two to the better, EQ-matching drivers so that A = B = Curve. Looking forward to trying this.