B
Bob
Hello,
I am working on a little spreadsheet that works out the range of fire alarm
speakers. The dBA drops off 6 dBA every time you double the distance from
the speaker. I am confident that I have the number of times that the
distance should be double, but I do not know of a way to translate it to a
formula. Below is a bare bones description of what I believe needs done.
I have a number X, that I would like to double Y number of times. Each time
X is doubled the answer becomes the new X. For example, X=10 and Y=3.25.
1.) 10x2=20
2.) 20x2=40
3.) 40x2=80
[Then to get the .25 part]
4.) 80x2=160
160-80=80x.25=20
Answer: 80+20=100.
Any thoughts on a clever way to do this in excel?
Many Thanks!!
I am working on a little spreadsheet that works out the range of fire alarm
speakers. The dBA drops off 6 dBA every time you double the distance from
the speaker. I am confident that I have the number of times that the
distance should be double, but I do not know of a way to translate it to a
formula. Below is a bare bones description of what I believe needs done.
I have a number X, that I would like to double Y number of times. Each time
X is doubled the answer becomes the new X. For example, X=10 and Y=3.25.
1.) 10x2=20
2.) 20x2=40
3.) 40x2=80
[Then to get the .25 part]
4.) 80x2=160
160-80=80x.25=20
Answer: 80+20=100.
Any thoughts on a clever way to do this in excel?
Many Thanks!!