Spreadsheet for Geodetic Calculations

Dansk version

With this spreadsheet, you can:

The spreadsheet, that can be downloaded below,  is extented with functions that does the geodetic calculations. By, for example, entering the formula: =GcProjection("N55º00.000 E015º00.000";1700;45) in a cell, the result: N55º00.648' E015º01.127' will be shown, as the position 1.7 kilometers in a 45º angle (northeast) of the entered position. The spreadsheet is fairly tolerant about the format of the entered coordinates; they can be in degrees, in degrees and minutes or in degrees, minutes and seconds, the special characters (degree sign etc.) does not need to be present. The output coordinate format can be controlled by the optional Format parameter. The coordinates can even be entered as Radians; if the latitude is lower than π/2 and the longitude is lower than π, the position is assumed to be in radians rather than degrees.

The spreadsheet, with its functions, is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. It is experimental and not thoroughly tested.

The spreadsheet is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

Yes, I accept the abowe terms, please take me to the download section.

Please let me know of any errors you find. Linguistic help are also welcome as english is not my native language.
Per "crumlin" Pedersen <per@crumlin.dk>