Back to home page

The following versions of this spreadsheet are available:

1. General points
   • Operating this spreadsheet is largely self explanatory.
   • Spin buttons have been provided to allow you to adjust values quickly.
   • Any field with a yellow background may be typed in, or its value changed by pressing the associated spin button. All other fields are read only.
   • If you wish to change an input field by a large amount, you can simply type in the new value. You do not have to hold the spin button down whilst the field slowly increments!
   • Once a value has been manually entered into an input field, the associated spin button needs to be clicked on a couple of times in order to resynchronize its value with the new value in the input field. If you don't do this, you could encounter a false range check warning message.
   • If, for security reasons, your installation of Excel has Macros disabled, then you will still be able to use the spreadsheet, but none of the spin buttons will function.


2. Sheet SR Calculator
   • This sheet allows you to enter the parameters required for the PAG and NAG calculations.
   • Built in limits for spin buttons:

     Dimension	Units	Min	Max	D
     Distances from talker
     To their mic	m	0.01	5.00	0.01
     To the nearest listener	m	1.00	50.00	0.01
     To the farthest listener	m	2.00	200.00	0.01
     Distances to nearest speaker
     From the talker's mic	m	2.00	50.00	0.01
     From the listener	m	2.00	50.00	0.01
     Other values
     Number of open mics	n/a	1	50	1
     Feedback stability margin	dB	0.1	10.0	0.1



3. Sheet Acknowledgements
   • All source material is listed here. I believe that all sources quoted here are accurate, reputable and respected in their various fields.

1. All dimensions are entered in metres and converted to feet and inches.

© Chris Whealy, 2006