VBA Revamped.xlsx

	A	B	C
1	In a closed room with dimensions (L: Length x W: Width x H: Height)
2	c is the speed of sound in air (approximately 343 m/s at room temperature/air pressure)
3	The resonant frequency f in Hz is given by:
4	f = c / (2 * (L + W + H))
5
6	Room Dimensions	m	Feet
7	Length	6.1	21.60
8	Width	5.79	19.00
9	Height	3.51	11.00
10	Total	15.4	51.60
11	Resonant freq (Hz)	11.14	10.90
12	Wave length (ms)	44.8980
13
14	Damping factor	22.57%
15
16	Speaker first peaks (Hz)
17	Measurements	L	R
18	1	27.3000	42.3110
19	2	27.3000
20	Average	27.3000	42.3110
21
22	Impulse Peak (ms)	-36.6300	-23.6345
23	XO shift	3.9	3.9200
24	Net shift	-32.7300	-19.7145
25
26		l	R
27	1	13.65000	21.15550
28	2	27.3000	42.3110
29	3	40.9500	63.4665
30	4	54.6000	84.6220
31	5	68.2500	105.7775
32	6	81.9000	126.9330
33	7	95.5500	148.0885
34	8	109.2000	169.2440
35	9	122.8500	190.3995
36	10	136.5000	211.5550
37	11	150.1500	232.7105
38	12	163.8000	253.8660
39	13	177.4500	275.0215
40	14	191.1000	296.1770
41	15	204.7500	317.3325
42	16	218.4000	338.4880
43	17	232.0500	359.6435
44	18	245.7000	380.7990
45
46	Peaks
47	Dips
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100