Skip to content
ContentsFormula ReferenceUser guide
Formula Reference

=SUMTHIRDTOOCTAVE — Levels 1/3 → 1/1

Formula
L_oct = 10·log₁₀(10^(L₁/10) + 10^(L₂/10) + 10^(L₃/10))
Output
dB
Bands
1/3-octave in → octave out
Standard / Source
General acoustics (no standard cited)
Access
Inline =function

What it does

Converts a one-third-octave sound level spectrum to octave bands by energy-summing each group of three adjacent 1/3-octave bands into their parent octave. This is the correct way to coarsen a level spectrum. The 1/3 › 1/1 ribbon menu's Sum→Octave item does this for picked source rows, writing a live =SUMTHIRDOCTAVE formula into each octave band of the selected row.

Equation

For each octave band, over its three 1/3-octave sub-bands:

Loct=10 log⁡10 ⁣(10L1/10+10L2/10+10L3/10)L_{oct} = 10\,\log_{10}\!\left(10^{L_1/10} + 10^{L_2/10} + 10^{L_3/10}\right)

How to use it

  • =SUMTHIRDTOOCTAVE(range) — returns the overall energetic sum across the octaves.
  • =SUMTHIRDOCTAVE(range, band) — returns the value for a single octave band.

ℹ️ These functions map cells positionally and assume a full-range reference (27 cells for a 1/3-octave spectrum).

Worked example

Three 1/3-octave bands at 70, 72 and 74 dB combine into one octave:

10 log⁡10 ⁣(107.0+107.2+107.4)=77.1 dB10\,\log_{10}\!\left(10^{7.0} + 10^{7.2} + 10^{7.4}\right) = \mathbf{77.1\ dB}

Source

Standard energy summation. No specific published standard is cited in the software.

Register interest

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