- 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
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:
Source
Standard arithmetic averaging of absorption coefficients. No specific published standard is cited in the software.