Skip to content
ContentsFormula ReferenceUser guide
Formula Reference

=ABSORPTIONTHIRDTOOCTAVE — α 1/3 → 1/1

Formula
α_oct = (α₁ + α₂ + α₃) / 3
Output
absorption coefficient α (0–1)
Bands
1/3-octave in → octave out
Standard / Source
General acoustics (no standard cited)
Access
Inline =function

What it does

Converts absorption coefficients from one-third octaves to octaves by taking the simple arithmetic mean of each group of three sub-bands. The 1/3 › 1/1 ribbon menu's α→Octave item does this for picked source rows, writing a live =ABSORPTIONTHIRDOCTAVE formula into each octave band of the selected row.

Equation

αoct=α1+α2+α33\alpha_{oct} = \frac{\alpha_1 + \alpha_2 + \alpha_3}{3}

How to use it

  • =ABSORPTIONTHIRDTOOCTAVE(range) — overall figure.
  • =ABSORPTIONTHIRDOCTAVE(range, band) — a single octave band.

Worked example

Three 1/3-octave coefficients of 0.30, 0.35 and 0.40 combine into one octave:

0.30+0.35+0.403=0.35\frac{0.30 + 0.35 + 0.40}{3} = \mathbf{0.35}

Source

Standard arithmetic averaging of absorption coefficients. 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.