Without the having the actual spread sheet this is about the best that I can respond.

Bennett's formula calculates refraction for light from distant celestial bodies (e.g., stars, the Sun) entering the atmosphere at high altitudes.

Terrestrial theodolite measurements (e.g., sighting distant peaks) require a different refraction coefficient due to localized atmospheric effects near Earth's surface, such as temperature gradients and pressure variations