Excel sheet to read GPS coordinates and plot google Map

Končano Objavljeno pred 5 letoma/leti Plačilo ob prevzemu
Končano Plačilo ob prevzemu

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.

Vnos podatkov Obdelava podatkov Excel Google Earth Google Zemljevidi API

ID projekta: #17896577

Več o projektu

21 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

Dodeljeno:

dissanayakepvt

My professional experience includes designing, data collecting, maintaining and updating GIS databases, converting complex data into information that is easily readable and accessible to the general public, creating hi Več

$10 USD v 1 dnevu
(7 mnenj)
3.6

21 freelancerjev ponuja v povprečju za $64 na tem delu

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Excel sheet to read GPS coordinates and plot google Map. I can assure you the quality job. I have good experience in Data Entry, Data Process Več

$180 USD v 1 dnevu
(296 ocen)
7.7
deepbluetech

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

$200 USD v 3 dneh
(179 ocen)
7.3
MohsanEijaz

Hi, I am interested in your project, I have experience also. ' Mohsan

$155 USD v 1 dnevu
(67 ocen)
6.0
xtxskif

Hello! I graduated from AGH (Poland) and IFNTUOG (Ukraine). I have master degree in GIS and Cartography. I can help you. Best Regards Michael

$150 USD v 3 dneh
(72 ocen)
6.3
xiqian88

Hello, Thanks for your post on my good experience. Excel data processing and Google Map API development is very good job for me. So I think I can do this in high quality. My releavant skill is: Data Entry, Data P Več

$200 USD v 1 dnevu
(2 ocen)
5.6
sofieneach

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

$15 USD v 1 dnevu
(7 ocen)
3.6
infernalwrath

Hi, I know how to turn the angular Lat Lon to Decimal GPS coordinate in excel and then upload it to Google My Maps to plot them. I can show you the process. To automate, it will need macro which is quite advanced. Chec Več

$30 USD v 1 dnevu
(5 ocen)
3.1
FedericoRiva

Hello! I've already done something like this. But using R. Do you want to do it only using excel?

$20 USD v 1 dnevu
(1 Ocena)
1.2
neiljason20

Hi There! Your job post has caught my attention because I'm an “AutoCAD” Operator for 5 years and I’m considering your job for me as I have these capabilities. I'm a Licensed Civil engineer my past jobs was on D Več

$25 USD v 1 dnevu
(3 ocen)
1.3
shanu1403

i am proficient to do your work kindly hire me i need money plzz hire me thankyou

$25 USD v 1 dnevu
(0 ocen)
0.0
chaeldinho

Hello! I´m very interest to work in this project and make asap all the requirement that you need in the assignation i have very confidence to be self-motivated and i have plenty of time to elaborate this kind of job, Več

$45 USD v 1 dnevu
(0 ocen)
0.0
reshamsehgal

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.

$15 USD v 1 dnevu
(0 ocen)
0.0
antegabelica

Hii, I'l do this for 10$ and outstanding review. You can get this for 3 hours after acceptence. Even before. I know the formula. Example; Latitude: 11.7413889 Longitude: 8.69111111111111 Thank you An Več

$15 USD v 0 dneh
(0 ocen)
0.0
GeoSpatialServ

Hi, Regarding your job I want to inform you that I have the required qualifications and skills to bring great success to this position, as you will see in my profile. Over the course of the last 9 years, I have been Več

$55 USD v 1 dnevu
(0 ocen)
0.0
TeodoraF

I have worked with gps coordinates and plotting before. I’m willing to help out for even less than the price bid. Let me know

$23 USD v 7 dneh
(0 ocen)
0.0