I did an Excel exercise on this subject. Lots of typing and checking, to catch any mistakes. I did this mostly out of curiosity: is f/0.95 1/8- or 1/6-stop below f/1? An 11% overall light loss makes an f/1.1 effectively an f/1.2 (but neither were 100% to begin with, . . . . . .). It looks like the sharpness of the various 50mm f/1.7 - f/1.8 primes usually makes them a better choice than the costly f/1.4s (except when I visit museums and historic buildings and can’t use my tripod).
The 1/8-stop increments I’ve seen on digital cameras has slightly better granularity (+9%open, -8.3%close) than 1/6-stops (+12.25%open,-9.1%close), but I wonder how much of an advantage this difference is.
On one worksheet, I created a list of apertures (areas), from f/0.5 to f/32, in whole stop (1-stop) increments. I then interpolated between each stop, in ¼-stop increments and in 1/6-stop increments.
I set the table up so that I could enter a focal length on the f/1.0 row, and the area and radius would be calculated, displayed and used as a basis for other area calculations. This simplifies things a bit (a 50mm f.1,0 has a nominal diameter of 50mm), and lets me change the focal length in one place, and see the results.
I repeated this exercise a few columns over, I repeated the exercise using the formula M=2^(0.5*stop). I used the resulting f-stop numbers to calculate the area for this part of the table (based on the shared f/1.0 base value), so there is a question of accuracy.
Both tables agree, to 5 decimal places, only at whole stop rows (f/1, f/1.4, f/2. F/2.8, . . .). Otherwise, they disagree, varying up to about 7%.
The formula generates f-stop numbers, and they seem to agree with published values (Wiki, etc.). There are minor questions, such as whether f/1.3 is a 3/4 -stop number (1.29684) or a 5/6-stop number (1.33482), but I assume that this is simply a rounding and convenience agreement (2/3-stop: 1.25989).
The areas generated do increase (or decrease) in constant percentage amounts for both 1/4- and 1/6-stop increments, which is expected, because of the function. The whole-stop relationships work (increase from f/1.4 to f/2.0, decrease area by 50%, etc), but the rest are off.
Is f/1.5 91.667% of f/1.4, or only 83.333%? Is f/1.7 75% of f/1.4, on only 70.7%? This is a small matter, as it’s only a few percent (but it does repeat for every whole-stop interval). I can’t find any errors in my table.
The interpolated area values show the expected relationships: f/1.8 is 33.33% larger than f/2; f/1.2 is 25% smaller than f/1.0, etc, The calculated f-stop numbers are off (except at whole-stops).
I don’t have good explanation(s) for my results. I think that I caught all of my errors. I suspect legacy reasons, and that possibly there is a correction factor that the formula covers nicely. In pre-PC days, simply doing a lookup in a book might have been very a good choice.
Additional information and comments are welcome.