Excel file utilizing Great Circle Formula and Law of cosines for doing what-if analysis
$30-250 USD
Paid on delivery
I need an Excel file for doing what-if analysis on the variables employed in the Great Circle Formula.
Specifically, the 5 variables are latitude 1 and latitude 2 for Point 1, and latitude 2 and longitude 2 for Point 2, and the distance between them, ie these 2 points.
So, at any one time, given the values of the other 4 variables, I must be able to determine the 5th variable that is the only unknown.
Need 5 Worksheets inside, each for targeting one of the 5 variables above as the only unknown.
So worksheet 1,worksheet 2, worksheet 3, worksheet 4, and worksheet 5 shall target latitude 1, longitude 1, latitude 2, longitude 2, and distance between the 2 points successfully as the unknown, while holding the rest of the variables in each case as the knowns.
The distance formulas shall be the Great Circle Formula, and the law of Cosines on each worksheet. User shall be able to pick one of these at their discretion to be applied.
For latitude and longitude, need an expression inside to do the conversion from degrees and minutes to other measure.
Need proof that the variables derived are correct by checking against Google Map for instance, and send me the url to deliver proof of accurate formulas used.
Project ID: #6706668
About the project
7 freelancers are bidding on average $127 for this job
I will customise the excel sheet t perform the task as required. I will also create user interface to put user data for conversion.
I have several years of working experience in GIS and Image processing, Geography, Survey, Climate change etc. I have proven working knowledge and hands on experience in almost all fields of GIS, Geometrics, Geography More
Dear sir, I had read your project requirement carefully and sure that I can do it perfect for you. Hope you choose me do it for you. Thank you very much, Hung
I am able to do the required work. I work since 1997 with GIS, specially with ESRI software, so I think to be ok to do this work.
Hello, I can do this job and deliver you the output within 2 days. I will send you the equations and url for authentication. Reply awaited. Regards.
