Quote:
Originally Posted by gafftaper
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.
|
I can make them independent, should have it done by the end of the day...
the only problem is that the angle function in Excel in on some serious crack. It can prove consistency, but if you try and create a 30 60 90 triangle, it'll say like 54 degrees for the 60 degree angle...
Just for you buddy :
http://www.divshare.com/download/2880495-a92
Phil