I have built a small utility that uses a complex formula to calculate the distance in meters between two points based on their respective Latitude, Longitude and Altitudes as reported by a GPS tracking unit.
The utility appears to work but the values that it returns are way off. The reason that I know they are way off is that I have runt the same numbers/formulas, etc. through excel and know what the correct answers should be. I set up the formulas in Calculation fields and copied the formulas directly from Excel.
My guess is that there is something going on with the conversion of Radians/Degrees that is done differently between FileMaker and Excel, but for the life of me I can't figure it out!
I tried to attach the FM file but it wouldn't let me.
If you think you can help, email me at firstname.lastname@example.org and I can email you the file to look at.
I would appreciate any help that can be offered.