Greetings!

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 [email protected] and I can email you the file to look at.

I would appreciate any help that can be offered.

Mike

Try zipping or stuffing your file to get it in a format that you can attach.