- Formula
- class from αw: A ≥ 0.90, B ≥ 0.80, C ≥ 0.60, D ≥ 0.30, E ≥ 0.15, else Not classified
- Output
- Sound absorption class — A, B, C, D, E, or Not classified
- 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
Converts the αw weighted absorption coefficient into the single-letter sound absorption class ISO 11654 defines for labelling and specification — the same classification you'll see on manufacturers' absorption-product datasheets.
This is a separate rating from αw, not a second line of the same one: the two toggle independently in the Ratings menu, and both can be active on the same row (rendering on separate lines) since a spec often needs to quote both the coefficient and its class.
Equation
Direct lookup against αw:
| Class | αw ≥ |
|---|---|
| A | 0.90 |
| B | 0.80 |
| C | 0.60 |
| D | 0.30 |
| E | 0.15 |
| Not classified | < 0.15 |
How to use it
- From the ribbon — select a row of absorption coefficients and click Ratings → Absorption → Absorption Class; this writes
="Class " & ABSORPTIONCLASS(range, anchor), shown as e.g.Class A. Written straight into the Rating column — no dialog, no inserted calc block. - As a function — type
=ABSORPTIONCLASS(range)in any cell (returns e.g.AorNot classified).
Shares αw's band handling, since the class is derived from αw underneath: never disabled, and on a sheet without the full 250 Hz–4 kHz octave range the tooltip says which bands are absent and the class 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):
→ Class A
Source
ISO 11654 — Acoustics: Sound absorbers for use in buildings — Rating of sound absorption, class table.