- Formula
- tabulated per-band weighting corrections
- Output
- dB — fills a row with weighting corrections
- Bands
- Sheet resolution (9 or 27 bands)
- Standard / Source
- General acoustics (no standard cited)
- Access
- Curve fill
What it does
Fills the selected row with the per-band correction values of a chosen frequency weighting — A, B, C, D, R, H or Z (Z is 0 dB at every band — a flat/no-op fill, for the plain energy-sum total). Add such a row to your sheet and combine it with a measured spectrum (e.g. via =DBADD down each column, or the A-Weighted Total tools) to apply the weighting. The values are filled at the sheet's resolution: 9 bands on an octave sheet, 27 on a one-third-octave sheet.
Worked example — A-weighting (octave)
| Band (Hz) | 31.5 | 63 | 125 | 250 | 500 | 1000 | 2000 | 4000 | 8000 |
|---|---|---|---|---|---|---|---|---|---|
| A (dB) | −39.4 | −26.2 | −16.1 | −8.6 | −3.2 | 0 | +1.2 | +1.0 | −1.1 |
| C (dB) | −3.0 | −0.8 | −0.2 | 0 | 0 | 0 | −0.2 | −0.8 | −3.0 |
Source
The A- and C-weighting values correspond to IEC 61672-1 (tabulated down to 10 Hz on one-third-octave sheets). B and D are not part of IEC 61672-1, and R and H are curves tabulated in the software with no published standard cited; none of B, D, R or H has a value below 25 Hz, so those bands are left blank.