- Formula
- R_oct = 10·log₁₀( mean of 10^(Ri/10) )
- Output
- dB (negative = attenuation)
- Bands
- 1/3-octave in → octave out
- Standard / Source
- ISO 717-1
- Access
- Inline =function
What it does
Converts a sound reduction index spectrum from one-third octaves to octaves. Unlike levels, SRI is combined as the energy average (mean transmission) of the three sub-bands, per ISO 717-1. There is also a 1/3 › 1/1 ribbon menu whose SRI→Octave item does this for picked source rows, writing a live =SRITHIRDOCTAVE formula into each octave band of the selected row.
Equation
with the R values entered negative (attenuation).
How to use it
=SRITHIRDTOOCTAVE(range)— overall figure.=SRITHIRDOCTAVE(range, band)— a single octave band.
Worked example
Three 1/3-octave SRI values of −30, −32 and −34 dB combine into one octave:
Source
ISO 717-1 — conversion of sound reduction indices from 1/3-octave to octave bands.