DiyMobileAudio.com Car Stereo Forum banner

461 - 480 of 497 Posts

·
Wave Shepherd
Joined
·
2,409 Posts
Discussion Starter #461
I don't think you missed anything. I don't get that error when I try to export. I changed a little thing in the VBA code to try and fix it. Try downloading again and see if it's better.
 

·
Registered
Joined
·
1,726 Posts
Have you tried using the custom column to to make this?
Yes, of course, it works just fine. I just thought it might be nicer if it were one of the selectable curves. No big deal if you don't want to include it, as I said I've already used it through the custom curve column, and saved the sheet that way.
 

·
Registered
Joined
·
5,675 Posts
Yes, of course, it works just fine. I just thought it might be nicer if it were one of the selectable curves. No big deal if you don't want to include it, as I said I've already used it through the custom curve column, and saved the sheet that way.
At one point I had an accumulation of some curves from various folks that I wanted to save. What I did was just add a tab, and add the curves there with titles over their columns. Worked like a champ. I'd pick one, copy/paste over into the output screen custom column.
 

·
Wave Shepherd
Joined
·
2,409 Posts
Discussion Starter #464
At one point I had an accumulation of some curves from various folks that I wanted to save. What I did was just add a tab, and add the curves there with titles over their columns. Worked like a champ. I'd pick one, copy/paste over into the output screen custom column.
That is a fantastic idea.
 

·
Registered
Joined
·
1,685 Posts
I don't think you missed anything. I don't get that error when I try to export. I changed a little thing in the VBA code to try and fix it. Try downloading again and see if it's better.
I downloaded 5.5 yesterday (10/2). I'm getting the export error too.
 

Attachments

  • Like
Reactions: Justin Zazzi

·
Wave Shepherd
Joined
·
2,409 Posts
Discussion Starter #466

·
Registered
Joined
·
41 Posts
i get a compilation error with variable not defined, in the debugger Xmax is marked, any clue why that might happen?
It has a value in the sheet.
 

·
Registered
Joined
·
389 Posts
Jazzi, since you are publishing releases, have you considered moving your project to GitHub? It will give you rev control and others can become contributors, with your oversight. Public repo is free.

Also, it would give you a place to bundle a tutorial and people can open defects that you can track and fix, or just use it for your own project purposes. Odds are it would make your tool better.
 

·
Registered
Joined
·
389 Posts
good idea except the excel format is a binary format. binaries aren't usually git/diff'able
Can it be refactored such that VB code is in source files loaded into xlsx? That way it can be rev controlled? Not trying to force the issue, just asking for the good of this project.

Sent from my LM-G820 using Tapatalk
 

·
Wave Shepherd
Joined
·
2,409 Posts
Discussion Starter #471
i get a compilation error with variable not defined, in the debugger Xmax is marked, any clue why that might happen?
It has a value in the sheet.
Please post a screenshot of what you are trying to do so I can replicate it?

Jazzi, since you are publishing releases, have you considered moving your project to GitHub?
My experience with GitHub is that the outrageously awesome features it is supposed to provide are needlessly complicated to the point of utter confusion. I wish Git stuff was easier to use because it seems fantastically powerful, but mostly I stumble along in the dark not sure when the next time I'm going to stub my toe.

I've tried a couple times to translate the spreadsheet into a webpage and realized webpage development changes too damn fast and I can't keep up with it.

I'm taking a different approach now. See my efforts in this other thread where I'm asking for help:

 

·
Wave Shepherd
Joined
·
2,409 Posts
Discussion Starter #472

·
Wave Shepherd
Joined
·
2,409 Posts
Discussion Starter #473
There's a fix for the Xmax variable not being defined.

I cannot update my signature to have the right post in it because the morons who bought this place only allow one link in a signature now.
 

·
Registered
Joined
·
41 Posts
works now, thank you!
 

·
Registered
Joined
·
389 Posts
Justin, sorry you had a bad experience. In interest of not clogging up this thread, I will DM you. I read your other thread and there is no doubt that you are committed to this. Perhaps I can help you in this area.

Sent from my LM-G820 using Tapatalk
 

·
Premium Member
Joined
·
645 Posts
My experience with GitHub is that the outrageously awesome features it is supposed to provide are needlessly complicated to the point of utter confusion. I wish Git stuff was easier to use because it seems fantastically powerful, but mostly I stumble along in the dark not sure when the next time I'm going to stub my toe
i've been using git daily for five years. it's easy to make a mess, especially starting out.
 

·
Registered
Joined
·
207 Posts
Jazzi,

I'm using LR/12 Crossovers in my Helix DSP,... BUT I used LR/24 in the Excel sheet when I created the House Speaker Curves. I tuned to the LR/24 House Curve using REW. So, the Electrical XO's are at LR/12, but the Acoustical XO's are line up really nice to LR/24 in REW. So, my question is... should I use the Phase Invert on Tweets & Mid-Base like your Excel sheet suggest, or should I not Invert because the Acoustical are lined up at LR/24? (front 3-way + Sub)
 

·
Registered
Joined
·
646 Posts
This exact point was discussed in linked thread. No. You should not flip your phase if acoustical phase is matching.

 

·
Registered
Joined
·
91 Posts
Since we are disabling slopes in REW, how much target range should I extend past crossover to match target curve. Example, if my tweeter is crossed at 3500, does it matter if my range is set to 800-20,000 or should I use something a little tighter like 2000-20,000? And so on for other drivers in my 3-way. I noticed I'm getting different values for EQ settings between tight ranges and extended ranges as it matches the target curve. I feel like with the extended range, the EQ suggestions tend to not be as bunched up and sometimes less adjustments.
 

·
Registered
Joined
·
307 Posts
Is there any way to see the numerical values for the house curves included in your spreadsheet ? What I mean is, I can enter my custom values and choose them and see them on the graph. But if I choose one of your included curves (Whitledge, Audio Frog, Jazzis) I can see the values on the graph change but not the numerical values driving the graph. I looked all through the sheet and the macros and couldn't figure out where you store these numbers, must be protected ? Do you allow the password so we can inspect this data ? I know its not a big deal, easy enough to guess the numbers from looking at the graph but it would be helpful to me if its easy enough to find those numbers.
 
461 - 480 of 497 Posts
Top