Spreadsheet for Geodetic Calculations

Dansk version

With this spreadsheet, you can:

• convert geodetic positions (longitude and latitude coordinates) between various formats (degrees, minutes and seconds)
• convert to/from UTM coordinates
• calculate the geodetic distance between two positions or calculate the bearing from one position to another
• project a position with a distance and bearing, to get a new position (or bearing)
• find the geodetic intersection of two lines (great circles), two archs (small circles) or a line and a arc
• find the geodetic position that are the center (CircumCenter, InCenter, Centroid or OrthoCenter) of three other positions
• convert between Datums (Molodensky transformation)
• save the calculated positions in a GPX file with waypoint name, description and symbol
• convert GC numbers (you'll have to be a geocacher to understand)
• calculate the digital sum of digits in a text or of the character values
• decipher Viginère (or Caesar ciphers such as Rot13)
• decipher Beale challenges
• decipher Enigma challenges
• perform floating point arbitrary base (2-36) conversion
• perform basic calculations on Big Integers (Add, Subtract, Multiply, Divide, Mod, Power, Sqrt)
• perform modular calculations on Big Integers (ModPower, ModInv, GCD)
• perform arbitrary base (2-36), base64 and ascii85 conversion on Big Integers
• perform basic calculations on Big Numbers (Add, Subtract, Multiply, Divide, Power, Sqrt)

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>