- Formula
- dB(A) = 10·log₁₀( Σ 10^((Li + Ai)/10) )
- Output
- dB(A) — single figure
- Bands
- Summarises every band of the row (1/1: 31.5 Hz – 8 kHz; 1/3: 25 Hz – 10 kHz; LF: 0.8 – 315 Hz)
- Standard / Source
- IEC 61672
- Access
- Toolbar block, Inline =function
What it does
Collapses a full spectrum into a single A-weighted level in dB(A) — the everyday single-figure loudness rating. It applies the standard A-weighting correction to each band, then energy-sums across all bands.
Equation
where is the A-weighting correction for band i (see the Weighting Curve Fill entry for the values).
How to use it
- From the ribbon — select the spectrum row(s) and choose Ratings → Weightings → Overall dB(A). This writes
=DBA(range, anchor)into each row's Rating column (click again to remove it) — no dialog, no inserted calc block. The anchor is the sheet's first band frequency, so the same formula works on 1/1-octave, 1/3-octave and low-frequency sheets. - As a function —
=DBA(range)(returns e.g.64.2 dB(A)). The pre-rename spelling=AWEIGHTRATING(range)still works and still gets written by any formula saved before the rename — the short names are simply what a fresh insert writes now.
The same rename applies to its B–H siblings: DBB/DBC/DBD/DBR/DBH (old spellings BWEIGHTRATING/CWEIGHTRATING/DWEIGHTRATING/RWEIGHTRATING/HWEIGHTRATING likewise still recognised), plus the new Z-Weighted Total (DBZ, no legacy spelling — it's new).
Inputs
| Input | Meaning | Unit | Example |
|---|---|---|---|
| Spectrum | octave-band levels | dB | see below |
Worked example
Spectrum [31.5: 78, 63: 85, 125: 91, 250: 83, 500: 78, 1000: 65, 2000: 64, 4000: 62, 8000: 55] dB:
→ 79.9 dB(A)
(The low bands are heavily discounted by A-weighting — e.g. −26.2 dB at 63 Hz — so the mid bands dominate the total.)
Source
A-weighting corrections per IEC 61672; energy summation as standard.