Skip to content
ContentsFormula ReferenceUser guide
Formula Reference

=SRITHIRDTOOCTAVE — SRI 1/3 → 1/1

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

Roct=10 log⁡10 ⁣(13∑i=1310Ri/10)R_{oct} = 10\,\log_{10}\!\left(\frac{1}{3}\sum_{i=1}^{3} 10^{R_i/10}\right)

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:

10 log⁡10 ⁣(13(10−3.0+10−3.2+10−3.4))=−31.7 dB10\,\log_{10}\!\left(\tfrac{1}{3}(10^{-3.0} + 10^{-3.2} + 10^{-3.4})\right) = \mathbf{-31.7\ dB}

Source

ISO 717-1 — conversion of sound reduction indices from 1/3-octave to octave bands.

Register interest

Tell us a little about you and we'll be in touch when Timbral is ready.