Excel file help you guys with port tuning/area, volume?

[bikinpunk 10+ year member]

I'm kinda bored at work lately and was thinking of making an Excel file to help with box building. I thought of something basic like entering in all the thiele-small parameters, and desired tuning to get port area, or desired area to get tuning. Or a few dimensions to get the other missing dimension for volume. Not sure how much work this would be, but it would be a time killer. Is this worth doing? I know there are a few sites that are dedicated to this already, but thought it would be a good time killer. I don't know how I would distribute it, so if you guys think I should go for it, let me know how to post it to where others can view it.

Click to read more...

 

[psych0ticnemes1 5,000+ posts]

I already built one. Uses the Solver function to adjust the dimensions according to the parameters you set. Automatically adjusts for port area, sub displacement, etc. If anything, just do it for yourself.

 

[bikinpunk 10+ year member]

nice. Care to send it to me? I'd like to take a look at it.

hardisj@gmail.com

 

[psych0ticnemes1 5,000+ posts]

haha, actually i do. Not that you'll steal it or anything but i'm not going to take the chance... i will post a screen shot of what it looks like though.

 

[Flipx99 5,000+ posts]

Can you use it for me then?

 

[psych0ticnemes1 5,000+ posts]

Most of what is at the bottom is jibberish, i'm still working on getting the lengths to come out properly depending if it is a slot port or not. This is not for round ports, only slot ports.

 

[bikinpunk 10+ year member]

That's pretty nice.

Right now I"m just working on Volume equations. Like, given 2 dimensions & internal volume, solve for 3rd dimension.

I'll work on port later. I figure this would be good for me to learn a little bit about how all the parameters influence design.

I understand not wanting to send it. I wouldn't copy it, but I still understand. When I finish mine, let's trade. //content.invisioncic.com/y282845/emoticons/wink.gif.608e3ea05f1a9f98611af0861652f8fb.gif

 

[psych0ticnemes1 5,000+ posts]

its a deal...