I need an excel sheet to be able convert some series of numbers
eg. N 11° 37′ 449′ E 008° 27' 868"
into real GPS coordinates and also plot google maps. please if you have no experience in this, do not bid
I have four task, to be done on that Excel sheet
Task 1:Please check the coordinates, you will notice that they are not well entered, see the first coordinate on the sheet, I want to be able to enter a number like this 113744900827868, and it will appear in the coordinate column with N, and E as it is written in the coordinate column on that excel sheet.
The goal is to have another column close to the coordinate column or just to format the coordinate column so that if I type in those kind of numbers it appears like the way it should with N and E just as it is in the excel sheet, like my example above.
Task2: i want to be able to arrange those farms in groups so that if i add the farm size and it is equal 10Hecters, i will call it cluster 1, but the coordinates of the farms have to be close together to give me one group, which will be called a cluster. Meaning, i am adding closer locations together, but, they don’t have to be more than 10 Hectares to be called a cluster furthermore, if i click say, cluster A, it will show me all the details of farmers that make up that cluster A, etc., meaning all the people and their information( Names, phone No, etc.) In that group
Task 3: the excel sheet should be flexible to add more data.
Last Task: show all the coordinates in Google map, work should be neat and user friendly
Summary of work:
1. Edit Co-ordinated entered as plain number and modify its format like GPS co-ordinate North + East., 2. Add nearby 10 hectare land area into one sector. 3. Show it in Google Map plot., in web browser 4. Should be able to add more data.
21 freelancer đang chào giá trung bình $64 cho công việc này
Hi, I have prior experience in dealing with plotting of GPS coordinates on Google maps. Would be using Excel formulas/macros to deliver a user friendly solution. Let me know. Regards, Arul
I am very passionate about the kind of work. I worked on several types of project of this kind which explains that I have a good experience in this field I count on you so that we can work together
I have completed Advanced Excel Certification and have worked in a reputed bank. I have a strong hold over English language and data statistics. I have an undergraduate degree in business administration.