Acoustic gain, G (Strength), total, early and late
A spreadsheet for calculating G and portions of G before and after 80 ms (Ge and Gl) at different source-receiver distances (r) (56 kB). The theoretical direct sound level (Gd) is also included. The calculations are based on measured G and C80, or based on measured T and V, the latter using Barron’s Revised Theory.
Old spreadsheets can be found here:
Calculating Gl (and Ge) (11 kB) based on measured Strength (G) and clarity (C80).
Estimating Gl (18 kB) based on measured reverberation time (T), hall volume (V) and source-receiver distance (r).
Direct sound and floor reflection interference – comb filtering vs frequency and distance
A spreadsheet for calculating comb filter interference versus frequency
(214 kB). A comb filter related to the direct sound will not only change the frequency response of the sound. It will, maybe more importantly, also contribute to drastically reduce the ratio of direct sound and reflected sound for sound within enclosed spaces and consequently reduced clarity and speech intelligibility. So keeping track of possible comb filters can be worthwhile!
A spreadsheet for calculating comb filter interference versus distance (383 kB). A comb filter interference can be observed in terms of the total level at a single frequency at difference distances from the source, instead of at different frequencies at one single position (source-receiver distance). This spreadsheet can be used to estimate the combined level of the direct sound and floor reflection within the orchestra at lower (single) frequencies, as described in my PhD thesis Chapter 4 and the October 2010 JASA paper (see above).
Total sound level
A simple spreadsheet for calculating total sound levels (277 kB). The total level can be found for coherent, phase shifted coherent and uncorrelated sources. Additionally, the level change for two coherent source can be found as function of phase relation.
Disclaimer: The spreadsheets are available for use at own risk.