I need a freelancer to convert a spreadsheet to a [url removed, login to view] script. it is not the whole spreadsheet that needs to be converted but rather the UTM to Latitude and Longitude section of the spreadsheet. Basically what i want to be able to achieve is to use the [url removed, login to view] script to input a full UTM coordinate, and the script would convert that UTM coordinate to a latitude and longitude coordinate and return those coordinates.
So for example, your script would be a function which has an input I could call (e.g. MappingUTMConvert(Zone,Eastings,Northings)) which would then convert the UTM to the full latitude and longitude and return those numbers.
The script needs to be in [url removed, login to view], and you should test it quite a few times against the spreadsheet to make sure it is returning the appropiate data. I can provide grid references if needed.
A link to the spreadsheet is provided below:
[url removed, login to view]
Please note this is a personal project, not a commercial one so it is a low budget ($30 - $50) but since the spreadsheet has already done all of the hard work it should just be a case of converting the spreadsheet to a [url removed, login to view] script (must be a [url removed, login to view] script that i can use in other [url removed, login to view] scripts - so not a dll). The code should also be well commented.
Also i should be able to call the function more than once (that is it could be called twice or more at the same time with different grid references) and still function fine.