- Formula
- lowest G-curve at or above the spectrum in every band (G10–G50, 1-unit resolution)
- Output
- G value (e.g. G35), or >G50 / <G10 outside the curve family
- Bands
- 1/3-octave, 31.5 Hz – 4 kHz
- Standard / Source
- ProPG GAG 2023
- Access
- Toolbar block, Inline =function
What it does
Rates a one-third-octave spectrum against the G-curves of the ProPG Gym Acoustics Guidance — the rating scheme used to assess impact/structure-borne noise from gyms and similar activity spaces. It returns the lowest G-curve that encloses the spectrum, to 1-unit resolution.
Equation
The rating reports the lowest G-curve, to 1-unit resolution, that is at or above the spectrum in every band. >G50 means the spectrum breaks even the G50 contour in at least one band; <G10 means it lies below the G10 contour in every band (the family is undefined outside G10–G50). Blank or zero bands are skipped.
How to use it
- From the ribbon — select the spectrum row(s) and choose Ratings → Sound Level → G-Rating (ProPG GAG 2023). This writes
=GRATING(range, anchor)into each row's Rating column (click again to remove it) — no dialog, no inserted calc block. The item is disabled on 1/1-octave sheets. - As a function —
=GRATING(range)(returns e.g.G35). It requires 1/3-octave input; octave-band data returns#NUM!.
Inputs
| Input | Meaning | Unit | Example |
|---|---|---|---|
| Spectrum | 1/3-octave levels 31.5 Hz–4 kHz | dB | low-frequency-heavy spectrum |
Worked example
A 1/3-octave spectrum peaking around 72–75 dB in the 63–125 Hz region rates above the top curve:
→ >G50
Source
ProPG Gym Acoustics Guidance (GAG) 2023, Appendix G — G-curve tables; band range 31.5 Hz–4 kHz.