Oops, when I said the hyperfocal distance was about 2000 times the entrance pupil, I neglected the critical element of the image being viewed in correct perspective. Corrections for deviations of viewing perspective can be done mentally in the field with basic math. Your spreadsheet applies to the special condition of constant magnification. I change lenses more to change the field of view than to change the subject distance for constant magnification. As for the math used to derive the formula I use, it was done decades ago with pencil and probably a slide rule, although by then I might have had a new and amazing five function digital Heathkit calculator that cost only $128, and had to be wired and assembled from the individual components. The math was merely a step in understanding practical optics. Once there, the math could be forgotten, and was. Kingslake in Lenses in Photography gives the formula for hyperfocal distance as 1000 d = h where d is the entrance pupil and h is the hyperfocal distance. This seems too lax for modern film and printing, and too forgiving for Facebook selfies.
Bookmarks