I cleaned up the EV-based spreadsheet a bit and replaced the web link file with the updated version.
So, the final sheet takes pinhole diameter and pinhole-to-film ("focal length"} distance and calculates the effective pinhole aperture and pinhole-to-film distance in inches.
For EV values from 0.1 to 20.0 in tenth EV steps, the exposure in seconds and in days:hour:minutes:seconds is shown.
This works best for electronic meters that take the set ISO value into account when in EV mode. Mechanical meters and some electronic meters display ISO referenced to ISO 100 regardless of the set ISO. This chart is less convenient for those meters, since further correction is needed to get correct times.
To use, simply set ISO, but meter in EV mode, take reading, and look up exposure in the tables. This method eliminates issues with imprecise time and f/stops, as exposure time is calculated directly.
No adjustment for reciprocity failure is made in the tables.
http://projectmf.homelinux.com/Pinhole_Exposure_by_EV.xlsx
The example images show a table for the parameters I have been using.
I believe the formulas to be accurate and cross-checked the results with some other tools with good results, but user beware!
Best,
Don
