This Excel sheet calculates the sound pressure level inside the room taking into account the existing reverberation time and the directivity of the sound source.
It also calculates the Critical Distance and the Cocktail Party Effect.
DIRECTIVITY AND SOUND PRESSURE LEVEL INSIDE A ROOM
This spreadsheet calculates the reverberation time in a room using different equations.
Since this spreadsheet is for quick use, it assumes that the room initially is fully reflective, using only the acoustic treatment materials to calculate the reverberation time (you can pickup one material per surface room). It takes into account air absorption due to humidity (valid for large rooms).
It only works in rooms that are empty before placing the acoustic treatment or highly reverberant.
It does not take into account furniture, chairs or people inside the room.
It does not take into account diffusion, spaces with non-rectangular shapes and open rooms.
Includes a list of materials that can be easily changed with their respective absorption data