Nice Spreadsheet Phil and welcome to the booth.
This is the modification I would like to see in a photometric spreadsheet. I want to be able to manually enter:
Instrument Height, Height above deck of target (for example 6' for head height), Horizontal distance to target, and the downward angle of the instrument. Both your sheet and Derek's automatically calculate Throw distance and beam angle. But I want to accurately know what's going on 6' above the deck. Simply changing the height in your sheets, changes the angle and results inaccurate information. So it would be great if all four of those factors were independent.
__________________
Community College Technical Director
If you have learned as much from CB as I have,
donate now to keep CB alive for others to find and learn from.