I had another acoustical consulting company GRACIOUSLY send me a "plug in formula" for an Excel spread sheet. Not knowing how Excel spread sheets function, it's a little greek to me. Here's what they sent me.
C4 (the internal depth inside box between back plate and front skin, inches)=(((78.5)*(POWER((B4/E4),2))/(D4+(0.8*B4)))*(POWER((200/A4),2)))
Where:
B4 = diameter of the hole you drill (inches)
E4 = center-to-center hole spacing pattern (inches)
A4 = target frequency in Hz
D4 = thickness of the front plywood skin (essentially the throat length of the drilled hole) (inches)
I'm told that the following traslation applies for the "POWER" thingy!...lol:
POWER(x,2) = x squared
POWER((x/y),3) = (x/y) cubed, etc, etc
K,here's the deal...when I plug either of these formula configurations in with the variables, and compare the charts in the MASTER HANDBOOK OF ACOUSTICS no less, I get completely wrong answers from what they have!!!!...double, doh!!! This has been nothing short of down right pissin' me off! (lol)
For instance, using the chart in F.Alton's Master Acoustics book, some of their chart examples bellow give:
Air Depth Hole Diam. Panel Diam Perf% Hole spacing Freq rez.
3.625" 1/8" 1/8" 1.25% .991" 248
3.625" 1/8" 1/4" 1.25% .991" 199
3.625" 1/4" 1/4" 1.25% 1.98" 199
If I plug in the variables in these equations, I DON'T GET THEIR ANSWERS! And this is supposed to be the MASTER HANDBOOK! Or maybe I'm just a mathematical numbskull!? Lol
Again, plese post to audiogon for all to see, if anyone has answers here.
C4 (the internal depth inside box between back plate and front skin, inches)=(((78.5)*(POWER((B4/E4),2))/(D4+(0.8*B4)))*(POWER((200/A4),2)))
Where:
B4 = diameter of the hole you drill (inches)
E4 = center-to-center hole spacing pattern (inches)
A4 = target frequency in Hz
D4 = thickness of the front plywood skin (essentially the throat length of the drilled hole) (inches)
I'm told that the following traslation applies for the "POWER" thingy!...lol:
POWER(x,2) = x squared
POWER((x/y),3) = (x/y) cubed, etc, etc
K,here's the deal...when I plug either of these formula configurations in with the variables, and compare the charts in the MASTER HANDBOOK OF ACOUSTICS no less, I get completely wrong answers from what they have!!!!...double, doh!!! This has been nothing short of down right pissin' me off! (lol)
For instance, using the chart in F.Alton's Master Acoustics book, some of their chart examples bellow give:
Air Depth Hole Diam. Panel Diam Perf% Hole spacing Freq rez.
3.625" 1/8" 1/8" 1.25% .991" 248
3.625" 1/8" 1/4" 1.25% .991" 199
3.625" 1/4" 1/4" 1.25% 1.98" 199
If I plug in the variables in these equations, I DON'T GET THEIR ANSWERS! And this is supposed to be the MASTER HANDBOOK! Or maybe I'm just a mathematical numbskull!? Lol
Again, plese post to audiogon for all to see, if anyone has answers here.