T3D Macro DOF calculations

[Greg Erker <erker@xxxxxxxxxxxxxx>]

Hi all,

  I made up a spreadsheet to calculate
DOF for macro shots based on the equations
in Question 14 of the lens FAQ on photo.net:
http://photo.net/photo/optics/lensFAQ.html

  This:
http://members.home.net/gillettm/DOF.html
DOF calculator is handy but isn't accurate
for macro AFAIK.

  Does anyone have some DOF numbers
based on Magnification and Circle of
Confusion that I can test my spreadsheet
with?  (IE total DOF for mags of
0.1, 0.5 and 1 at a certain f-stop and
a CoC*).

Thanks - Greg E.

* I'm currently using CoC of 0.03mm
for 35mm and 0.06mm for 6x6. Same as
the DOF calculator URL'd above.