- Formula
- reference curve shifted (0.05 steps) until Σ unfavourable deviations ≤ 0.10; αw = shifted curve at 500 Hz
- Output
- αw, with an (L)/(M)/(H) shape indicator when relevant — e.g. 0.90 or 0.65 (H)
- Bands
- 250 Hz – 4 kHz (octave), or 1/3-octave measured values (auto-converted)
- Standard / Source
- ISO 11654
- Access
- Toolbar block, Inline =function
What it does
Rates a measured sound absorption coefficient spectrum against the ISO 11654 reference curve, returning the single-number weighted sound absorption coefficient αw. When the practical coefficient overshoots the shifted reference curve by 0.25 or more in a particular range, a shape indicator — L (250 Hz), M (500–1000 Hz), H (2–4 kHz), or a combination — is appended to flag where the absorber is unusually peaked.
Accepts 1/3-octave measured values directly — they are converted to octave practical absorption coefficients (arithmetic mean of each octave's three 1/3-octave values, rounded to the nearest 0.05 and capped at 1.00; an octave is only formed when all three values are present) before rating.
Equation
The reference curve is shifted in 0.05 steps toward the measured coefficients. αw is the shifted curve's value at 500 Hz, using the largest shift for which the sum of unfavourable deviations stays within the standard's cap:
A shape letter is added when the practical coefficient exceeds the shifted curve by ≥0.25 in its band(s): L at 250 Hz, M at 500 or 1000 Hz, H at 2000 or 4000 Hz.
How to use it
- From the ribbon — select a row of absorption coefficients and click Ratings → Absorption → αw (Weighted Absorption); this writes
="αw " & ABSORPTIONWEIGHTING(range, anchor). Written straight into the Rating column — no dialog, no inserted calc block. - As a function — type
=ABSORPTIONWEIGHTING(range)in any cell (returns e.g.0.90or0.65 (H)).
Toggles independently of the Absorption Class rating — both can be active on the same row and render on separate lines.
Never disabled: on a sheet without the full 250 Hz–4 kHz octave range (e.g. the low-frequency sheet) the tooltip says which bands are absent, and the rating is worked out over the bands present.
Inputs
| Input | Meaning | Unit | Example |
|---|---|---|---|
| Spectrum | practical (or 1/3-octave measured) absorption coefficient | — (0–1) | see below |
Worked example
Spectrum [31.5: 0.10, 63: 0.15, 125: 0.55, 250: 0.85, 500: 0.95, 1000: 0.90, 2000: 0.85, 4000: 0.80, 8000: 0.75]:
→ αw 0.90
A more high-frequency-peaked absorber → αw 0.65 (H) — the H flags excess absorption above 2 kHz relative to the shifted reference curve.
Source
ISO 11654 — Acoustics: Sound absorbers for use in buildings — Rating of sound absorption. Reference curve, shape indicator rule, and shift method.