ABCDEFGHIJKLMNO
1
2
To use this sheet:
- Click "File" and then "Make a copy" to add it to your Google Drive. This will allow you to enter values into the sheet
- Select the types and thickness of material you have on each leaf (up to 4)
- Select the types and thickness of material your leaves are made of
- Finally, input the space between the leaves
- To use "RESET SHEET" button you need to allow permissions

Note: The Wyle Report states that the best performance is achieved when M1 = M2 in an MSM system
3
4
5
Gregwor & audiomutt's MSM Transmission Loss Calculator Version 2.03Check back for updates!
Version 2.03 Feb 9, 2019
Contact us through John Sayer's Forum
6
7
8
MATERIAL 1MATERIAL 2MATERIAL 3MATERIAL 4
9
LEAF 1 SHEATHINGNONENONENONENONESelect what you will be using for your "custom" unit measurements
10
11
THICKNESS in
12
Enter custom values below. Select your "MATERIAL", then in the thickness box, select "CUSTOM". If an option other than "Custom" is selected, the calculator will not use the custom thickness value. Use top right light blue box to choose units.
13
CUSTOM
14
15
LEAF 2 SHEATHINGNONENONENONENONEQuick Conversion Calculator
*DOES NOT AFFECT MEASUREMENTS*
16
Units
Thickness
kg/m^3kg/m^2
17
THICKNESS in0.00
18
Enter custom values below. Select your "MATERIAL", then in the thickness box, select "CUSTOM". If an option other than "Custom" is selected, the calculator will not use the custom thickness value. Use top right light blue box to choose units.
19
CUSTOM
20
21
LEAF 1 SUPPORT STRUCTURE MATERIAL LEAF 2 SUPPORT STRUCTURE MATERIAL GAP BETWEEN SUPPORT STRUCTURE MATERIAL
USE CUSTOM UNITS		INPUTinft
22
cm0.000.00
23
mmcmm
24
SIZE 00.000
25
The boxes below are where you enter custom depth values. If an option other than "Custom" is selected, the calculator will not use the custom value. Use top right light blue box to choose units.
26
27
CUSTOM
30
31
TL and Resonant Frequencies (Note: We want our resonant frequency <= 1/2 lowest dominant frequency)
32
33
TL of Leaf 1TL of Leaf 2F0 (empty cavity)F0 (insulated cavity)F1
34
DATA N/ADATA N/ADATA N/ADATA N/A#DIV/0!
35
36
37
F (Hz)
Transmission Loss in dB with insulation (isothermally)
38
20#NUM!
39
25#NUM!
40
31.5#NUM!
41
40#NUM!
42
50#NUM!
43
63#NUM!
44
80#NUM!
45
100#NUM!
46
125#NUM!
47
160#NUM!
48
200#NUM!
49
250#NUM!
50
315#NUM!
51
400#NUM!
52
500#NUM!
53
630#NUM!
54
800#NUM!
55
1000#NUM!
56
1250#NUM!
57
1600#NUM!
58
2000#NUM!
59
2500#NUM!
60
3150#NUM!
61
4000#NUM!
62
5000#NUM!
63
6300#NUM!
64
8000#NUM!
65
10000#NUM!
66
12500#NUM!
67
16000#NUM!
68
20000#NUM!
72
73
Equations (So you can learn to do it yourself!)
74
75
TL = 14.5*LOG(M*0.205)+23dB
76
where M = surface density of leaf
77
78
F0 = C((m1+m2)/(m1*m2*d))^0.5
79
where C = constant for empty or insulated cavity
80
where m1 and m2 = mass of each leaf (kg/m^2)
81
where d = cavity depth IN METERS!
82
83
F<F0 = 20LOG(f*(m1+m2))-47
84
F0<F<F1 = R1+R2+20LOG(f*d)-29
85
F>F1 = R1+R2+6
86
where f = frequency you want to check the TL of
87
where m1 and m2 = mass of each leaf (kg/m^2)
88
where d = depth of cavity
89
where F1 = 55/depth of cavity
90
91
MASS LAW = 20LOG(f*(m1+m2))-47.2
92
96
Change Log:
97
Oct 23, 2018 - Version 2.00 (Official Release)
98
Oct 24, 2018 - Version 2.01
99
- Added "INSIDE OUT" to Wood Stud and Steel Stud SUPPORT STRUCTURE MATERIAL SIZE
100
- Added "Plywood (X)" to LEAF SHEATHING MATERIAL
101
Dec 21, 2018 - Version 2.02
102
- Changed labeling from "GAP BETWEEN LEAVES" to "GAP BETWEEN SUPPORT STRUCTURE MATERIAL"
103
Feb 9, 2019 - Version 2.03
104
- Added "Homasote 440 SoundBarrier®" to LEAF SHEATHING MATERIAL
105
106