Đã hoàn thành

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.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Google Earth, Google Maps API

Xem nhiều hơn: 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

Về Bên Thuê:
( 18 nhận xét ) Kano, Nigeria

ID dự án: #17896577

Được trao cho:


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 Thêm

$10 USD trong 1 ngày
(7 Đánh Giá)

21 freelancer đang chào giá trung bình $64 cho công việc này


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 Thêm

$180 USD trong 1 ngày
(296 Nhận xét)

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 trong 3 ngày
(179 Nhận xét)

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

$155 USD trong 1 ngày
(67 Nhận xét)

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 trong 3 ngày
(72 Nhận xét)

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 Thêm

$200 USD trong 1 ngày
(2 Nhận xét)

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 Thêm

$30 USD trong 1 ngày
(5 Nhận xét)

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 trong 1 ngày
(7 Nhận xét)

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 Thêm

$25 USD trong 1 ngày
(3 Nhận xét)

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

$20 USD trong 1 ngày
(1 Nhận xét)
$25 USD trong 1 ngày
(0 Nhận xét)

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 trong 7 ngày
(0 Nhận xét)

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 Thêm

$55 USD trong 1 ngày
(0 Nhận xét)

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, Thêm

$45 USD trong 1 ngày
(0 Nhận xét)

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 Thêm

$15 USD trong 0 ngày
(0 Nhận xét)

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 trong 1 ngày
(0 Nhận xét)

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

$25 USD trong 1 ngày
(0 Nhận xét)
$35 USD trong 1 ngày
(0 Nhận xét)
$70 USD trong 1 ngày
(0 Nhận xét)

hello sir/madam I am glad to be here for this [login to view URL] for given this chance to show myself. My name is ANKIT YADAV from DELHI NCR UTTER PRADESH GHAZIABAD .I have a B.A degree with a major in Information T Thêm

$28 USD trong 1 ngày
(0 Nhận xét)
$30 USD trong 1 ngày
(0 Nhận xét)