Suoritettu

Excel sheet to read GPS coordinates and plot google Map

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Google Earth, Google Maps API

Näytä lisää: plot latitude longitude google maps excel, map gps coordinates from excel, draw map using gps coordinates, plot latitude and longitude on google map, excel bing maps latitude longitude, plotting latitude and longitude on google earth, plot multiple coordinates on map, create map from gps coordinates, gps coordinates using google maps api, record gps log based google map, plot gps coordinates excel, vb6 gps project embed google map, google map read gps data mysql, gps coordinates city google maps excel, gps nmea data google map converter, plot gps coordinates map, excel gps coordinates map, web based gps tracking via google map, displaying google map gps coordinates php, gps coordinates tracking google maps vb net

Tietoa työnantajasta:
( 17 arvostelua ) Kano, Nigeria

Projektin tunnus: #17896577

Myönnetty käyttäjälle:

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 Lisää

$10 USD 1 päivässä
(5 Arvostelua)
2.5

23 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$180 USD 1 päivässä
(285 arvostelua)
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 3 päivässä
(176 arvostelua)
7.3
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 3 päivässä
(72 arvostelua)
6.3
MohsanEijaz

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

$155 USD 1 päivässä
(66 arvostelua)
6.0
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 Lisää

$200 USD 1 päivässä
(2 arvostelua)
5.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 Lisää

$30 USD 1 päivässä
(4 arvostelua)
3.0
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 1 päivässä
(5 arvostelua)
2.8
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 Lisää

$25 USD 1 päivässä
(3 arvostelua)
1.3
$25 USD 1 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
0.0
chadid18

Hello, i’m an expert on data analytics, and i have done this kind of request many time, so i propose a best quality of work with a double check for the data, and for sure to deliver the work done ASAP

$77 USD 2 päivässä
(0 arvostelua)
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 Lisää

$55 USD 1 päivässä
(0 arvostelua)
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, Lisää

$45 USD 1 päivässä
(0 arvostelua)
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 Lisää

$15 USD 0 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0
FedericoRiva

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

$20 USD 1 päivässä
(0 arvostelua)
0.0
alexandradalca1

Hello, I have experience with excel files. i am certified by ECDL and i can do what you ask very fast:). Have a nice day, Alexandra

$25 USD 1 päivässä
(1 arvostelu)
0.0
shanu1403

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

$25 USD 1 päivässä
(0 arvostelua)
0.0
$35 USD 1 päivässä
(0 arvostelua)
0.0
$70 USD 1 päivässä
(0 arvostelua)
0.0