Originally Posted by PeteHski

OMG! It doesn’t need to be that complicated. If buying a road bike just make sure it has a compact crankset. If buying a gravel bike then the gearing will be plenty low enough without even looking at it.

As a rule of thumb a 1:1 ratio is about as low as road race/endurance bikes go, with a 50/34 chainset and 11-34 cassette. Gravel bikes go a step lower than that for off-road climbing.