Excel Navigation Calculator for Latitude & Longitude

Job ID: 38019100

Budget: $30 – $250 NZD

I need an Excel spreadsheet that allows me to input a starting point's latitude and longitude, a heading (in degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes.

Key Features:
- Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers)
- Calculation of a new latitude and longitude based on the input
- Utilization of the Rhumb line formula for the calculation

Ideal Skills:
- Advanced Excel proficiency
- Understanding of geographical coordinate systems and navigation
- Experience with mathematical calculations in Excel
- Prior experience in developing navigation tools would be a plus

This project requires an individual with a strong background in Excel, a keen eye for detail, and the ability to translate mathematical formulas into functional Excel functions. If you have experience with similar projects, please provide examples in your bid.