John Sayers' Design Forum

John Sayers' Recording Studio Design Forum

A World of Experience
Click Here for Information on John's Services
It is currently Tue Mar 02, 2021 5:54 am

All times are UTC + 10 hours




Post new topic Reply to topic  [ 6 posts ] 
Author Message
PostPosted: Fri Jan 05, 2018 11:03 am 
Offline
Moderator
User avatar

Joined: Wed Feb 01, 2017 6:03 pm
Posts: 1501
Location: St. Albert, Alberta, Canada
Hi,

I built an excel spreadsheet to calculate the TL and Resonant Frequency of a two leaf MSM wall because I was curious how big of gap/cavity I should have between my wall to achieve my needed TL.

I followed Stuarts instructions:

Soundman2020 wrote:
The equations for calculating total isolation of a two-leaf wall are simple:

First, for a single-leaf barrier you need the Mass Law equation:

TL = 14.5 log (M * 0.205) + 23 dB

Where: M = Surface density in kg/m2

For a two-leaf wall, you need to calculate the above for EACH leaf separately (call the results "R1" and "R2"), then you need to know the resonant frequency of the complete system, using the MSM resonance equation:

f0 = C [ (m1 + m2) / (m1 x m2 x d)]^0.5

Where:
C=constant (60 if the cavity is empty, 43 if you fill it with suitable insulation)
m1=mass of first leaf (kg/m^2)
m2=mass of second leaf (kg/m^2)
d=depth of cavity (m)

Then you use the following three equations to determine the isolation that your wall will provide for each of the three frequency ranges:

R = 20log(f (m1 + m2)) - 47 ...[for the region where f < f0]

R = R1 + R2 + 20log(f x d) - 29 ...[for the region where f0 < f < f1]

R = R1 + R2 + 6 ...[for the region where f > f1]

Where:
f0 is the resonant frequency from the MSM resonant equation,
f1 is 55/d Hz
R1 and R2 are the transmission loss numbers you calculated first, using the mass law equation


Clearly I screwed up somewhere because my F<F0 isn't working and my TL's seem very unrealistic.

Here is the excel file:
https://drive.google.com/open?id=1maDSn ... VBuR7uyEFg

Can someone please check my excel spreadsheet to see where I went wrong? Once this is working, I think it would be a good resource for everyone to use.

Thanks!

Greg

_________________
It appears that you've made the mistake most people do. You started building without consulting this forum.


Report this post
Top
 Profile  
 
PostPosted: Sat Jan 27, 2018 4:02 pm 
Offline
Moderator
User avatar

Joined: Wed Feb 01, 2017 6:03 pm
Posts: 1501
Location: St. Albert, Alberta, Canada
UPDATE!

I finally figured out what the problem was. Two things:

- I was calculating using inches for depth instead of meters.
- Excel needs * entered to do multiplication, you can't just put 5(10) and it know to multiply the two.

Anyway, this seems to work great. I hope this is a tool people can use! I'd like to spend some time and maybe update it to graph 20Hz-20kHz isolation. If I get around to it, I'll post the updated version here.

Greg

NEW WORKING VERSION:

https://drive.google.com/open?id=1ktKnf ... RfY_HUZhAv

_________________
It appears that you've made the mistake most people do. You started building without consulting this forum.


Report this post
Top
 Profile  
 
PostPosted: Sat Jan 27, 2018 11:07 pm 
Offline
Senior Member
User avatar

Joined: Thu Aug 21, 2008 10:17 am
Posts: 11938
Location: Santiago, Chile
Glad you found the problem!

I did notice that the calculations for "with insulation" and "without insulation" are showing the same numbers...


- Stuart -

_________________
I want this studio to amaze people. "That'll do" doesn't amaze people.


Report this post
Top
 Profile  
 
PostPosted: Sun Jan 28, 2018 8:02 am 
Offline
Moderator
User avatar

Joined: Wed Feb 01, 2017 6:03 pm
Posts: 1501
Location: St. Albert, Alberta, Canada
UPDATE AGAIN:

I removed a bunch of redundant stuff and added a second sheet that graphs everything from 20Hz-20kHz in 3rd octave format.

Basically, on sheet one, just type how thick (in inches) your studs are and how much air gap between the walls you have.
As you can see at the top of sheet one, it is set to calculate with two sheets of 5/8" drywall on each leaf. You can easily change those parameters if you wish.

I personally just wanted this to see how much a 1/2" gap differed from 1" or even 6" with overall isolation. I'm not an excel wizard. Ideally, I'd like the chart to adjust itself, ultimately removing the lines where necessary based on the input data which would mean one nice TL line instead of all three visible at one time. Oh well, this is good enough for what I need!

Hopefully it helps someone other than me. Here's version 3:

https://drive.google.com/open?id=1rC1qE ... FVIs5bWjUq

_________________
It appears that you've made the mistake most people do. You started building without consulting this forum.


Report this post
Top
 Profile  
 
PostPosted: Thu Jun 28, 2018 8:25 am 
Offline
Moderator
User avatar

Joined: Wed Feb 01, 2017 6:03 pm
Posts: 1501
Location: St. Albert, Alberta, Canada
Updated version with notes to help use the spreadsheet!

http://www.mediafire.com/file/shl5c966q ... .xlsx/file

I decided to host this version on mediafire. If for some reason it ever stops working, PM me and I'll post a new link or email it to you.

Greg

_________________
It appears that you've made the mistake most people do. You started building without consulting this forum.


Report this post
Top
 Profile  
 
PostPosted: Mon Aug 31, 2020 8:13 am 
Offline

Joined: Mon Aug 03, 2020 7:31 pm
Posts: 1
Gregwor wrote:
Updated version with notes to help use the spreadsheet!

http://www.mediafire.com/file/shl5c966q ... .xlsx/file

I decided to host this version on mediafire. If for some reason it ever stops working, PM me and I'll post a new link or email it to you.

Greg


Hi Greg

I checked your spreadsheet and I think there is a mistake in the calculation for the two formulas (TL around F0 and above F1) which start with R1+R2.

Since R1 and R2 are values in dB I think they should be summed in a logaritmic way.

For example: R1 = 33 R2 = 33 ---> 33+LN(33)= 36,49 dB.

In your calculation the sum is calculated as e.g. 33+33= 66dB which is not correct if I am not mistaken.

D


Report this post
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: thedavidlim and 31 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group