You've got some serious VBA skills! Thanks!

 

Thanks, i hacked my way through it, lol! Justin the original sheet creator laid down an excellent baseline to learn to rift off of!

 

WOW.... Seriously COOL !! Thank you !!!

 

Are the Grid Line Hz off a bit?? Or are supposed to be this way?

 

Supposed to be that way. It provides a reference to octaves, which is more closely to how we hear vs evenly spaced.

 

REW's Grid Lines.....

 

Dang, that upload picture didnt work out.. the bottom was cut off... here is a better pic....

 

I should add there is no specific direct correlation to the graph settings in Excel, REW or SMAART. The Excel graph is set to auto-scale the x and y axis and it does what is does. What REW and SMAART display on their specific x and y axis gridlines as markers and labels is specific to those programs. With default settings in REW and SMAART any similarity is pure coincidence.

 

thanks for your hard work!

 

Super awesome !

 

Looks awesome! Can't wait to download and give it a try!
Out of curiosity, how about uploading it to GitHub to allow for crowdsourcing new functions? I'm not a great coder myself, but I know there are a ton of smart people that wouldn't mind adding a few lines here and there.

 

At some point perhaps but a dedicated Beta testing community would need to be established before anything could be released. For now i would like to keep things in house just to keep my sanity what little i have left , lol!!

 

Now how can I get excel to work with out paying Microsoft $100 a year?

 

Microsoft Office Pro 2021 for Windows: Lifetime License | StackSocial

For Windows 10 or Newer! Get All Essential Microsoft Apps for Your PC with This One-Time Purchase

stacksocial.com

 

Thank you! This is amazing!

 

Mods: any way to make this new one a sticky? Thanks.

 

Here is a teaser screen shot of what i am working on next. I also fixed a minor bug with the SMAART/REW selection button I found that prematurely displays the SMAART settings when in REW mode.

The new features allow the user to plot the custom curves on the graph screen as desired. This way House Curves can be compared on the same screen before exporting. This was an obvious missing feature that needed to be added. All 3 custom curves can be displayed with the selected house curve. The driver responses only correct against the selected house curve.

 

 

This is really, really exciting. Huge thank you to AudioGal for taking the lead and making it happen!

To be super clear, Erica is now taking lead on this project.
I am thrilled to continue supporting in the background and helping where I can.

Thank you to everyone who enjoyed the tool so far, all the feedback, and encouragement.
I hope you all can show Erica the same love and support that you gave to me!

 

Okay the latest version 7.05 is up on the google drive link. Please see post #1.

Updates:
1) Graphing function support improvements including target curve comparison capability.
2) ATF ( Helix) target curve support.
3) a brand spanking new Jazzi tuning curve
4) Some minor bug fixes and code optimizations.
5) Tuning guide updated with new features.

Below: Screen shot

 

Erica and Justin, Thank you a lot for investing your precious time and knowledge into this project!

 

100%
This kind of thing doesn't come free (or even cheap)... a lot of hours have been invested in this project.
Thank you @Justin Zazzi @AudioGal

 

Thank you both for contibuting in a huge way to this community. I took the plunge into House curves and REW about three years ago. At the time I knew nothing but wanted to learn. Justin's spread sheet looked very intimidating. I got it all figured out in a limited way in that I probably only scratched the surface. My tunes are consistant and replicable and I have a better understanding on whats going on. I'm going to try and keep up with this thread. Again it looks to be way over my head but not imposible to learn. Does anybody have links to articles or videos to get a better understanding on how to use this knowledge. I'm willing to get my feet wet all over again. Also keep in mind there are only about 10-20 people on here that understand REW in a simple way let alone this complex. There are a lot of of us that are still sucking on a binki. We may need a little more guidance.

 

Thanks Stycker!, I find it is best to not take the whole tuning project in all at once. Pick the sheet that is of interest and play with it. nothing will break (hopefully!!) by pressing all the buttons and entering data. If something goes wonky just press the reset to default buttons

1. Select either 2-way or 3 way
2. Select the RTA analyzer you would like to use ( REW, SMAART, Helix (ATF) )
3 Enter in your cross over values you want to start with for each driver
4. Select the House tuning curve you want to use, or create a custom one and select that.
5. Either download specific target curves you want or export all of them at once.
6. Import into your RTA analyzer of choice and tune away.
7. If needed loop back to step 3 and generate new curves and cross-over points, rinse and repeat as needed!


The Global Offset - used to apply a common dB offset to all traces to place the target curves at the reference level you want in your analyzer. The Global offset has no affect on the helix RTA curves.

Please play away and enjoy, the whole spirit of this thing at least for me is to learn, grow and enjoy while helping to further facilitate community knowledge while building tools that make the task much easier 😎

Ps. I have a micrphone calibration sheet that i am going to redo and put up in the same directory this year. this sheet takes the transfer function of a know good reference mic and the transfer function of the mics to be calibrated, and create calibration files for the mics to be calibrated that can be imported into your analyzer of choice. The program works, however i need to go through it and fortify, optimize and generally do a 2nd pass run through with what have learned to update it. The nice thing is a multi-mic array can be created cost effectively using 1 expensive mic as a reference. No need to have multiple expensive mics putting a mic array in reach of a diy person. This is a future audiogal spare time project to get it ready for the masses

 

Thank you so much. That is exactly what I needed. A little bit of guidance and a bit of a step by step. I will certainly play with it and appreciate your work.

 

I want to add that it is always good to go back to the google drive to get the latest version of the sheet. A lot of times minor improvements are done with no special announcement. Using the latest ensures that you are current. Since this is a fun project the versioning of the sheet is not very rigid, meaning major, minor and bug fixes tracking in the release version number so please do not rely on that to determine that you have the latest version. Any medium to significant changes or major bug fixes will be announced in this thread.

The sheet has seen a lot of changes and is at a good place to stabilize and hold for a while. I have nothing I am itching to add or fix at this time to anything. Unless something comes to my attention that i need to attend to.

So enjoy and have fun with it!

 

You’re the coolest chick here no doubt! Great work! Maybe add the link to your signature?

 

Thanks DaveG, good idea i will indeed do that, thanks or the tip!

 

What I appreciate most is the new EPY target curve, its exactly what I've coalesced on myself - very similar to the ATF curve but a little less aggressive in the lower midrange. I mean its easy enough to tweak it yourself but its nice to validate your own notions against someone else who knows what's going on. I'm making an assumption that the EPY curve is from Erica.

 

Ya guilty as charged, that is my curve. 😁

I was going to put the BBC dip into it at 2K but i figure i can adjust for that during the salt and pepper phase as each new improvement or system change does different things to this area of the freq. band.

 

All a new version 7.06 is up on the download directory. A big thanks to Uberverbosity for finding a bug that got missed, much appreciated!

 

Found a glitch when using curves with Dirac.
When exporting target curves it leaves several spaces between the frequency and the data that Dirac doesn't recognize.
After manually leaving one space, it works just fine.

J.

 

Which RTA type are you usihg to fudge a dirac curve @doitor?

I can certainly add DIRAC to the list so the proper formatting comes out. Each RTA seems to do their own thing. I do not have ay ability to test Dirac RTA curve imports so I will need others to test this functionality. So by what you are showing is a single space between Freq and value, that is correct?

 

Following the "Quick tuning guide" found in this forum it says to use Jazzi´s tunning sheet to create the target curve for REW and then paste this on top:

NAME
Unnamed
DEVICENAME

BREAKPOINTS

I used your new one, pasted the headliner and Dirac didnt recognize it. Compared it to an attached example on the "Quick Tunnig Guide" and found the only differrence was the number of spaces between the frequency and the value. Modified it an it worked just fine.
So yes, to make a Dirac target curve it would need to have the above pasted on top and just one space between frequency and value.

J.

 

Okay got it. I will add DIRAC as a separate radio button selection and it will export in the format you describe for all TG curves available. I will post a note for the new release when it is up. As stated you will need to verify for me that it works as intended thought

Thank you @doitor for putting the time in to create the details to be able to add a new feature to the sheet!

I do not have Systune software, so if someone can provide the formatting requirements for that, perhaps we can get that one in there as well. If nothing else for completeness sake.