Do some Excel Work

已完成 已发布的 May 18, 2015 货到付款
已完成 货到付款

I have a spreadsheet (attached) that contains geo-location information extracted from a KML file. The project requires a simple adjustment to the formatting and order arrangement of only some of the data. The polygon coordinate points within the ‘geometry’ column are currently formatted with the following values: first a Longitude decimal followed by a connecting comma and lastly followed by a Latitude decimal, such as this:

“<Polygon><outerBoundaryIs><LinearRing><coordinates>longitude,latitude longitude,latitude  longitude,latitude… </coordinates></ LinearRing></ outerBoundaryIs></ Polygon>”

while a few cells will contain multiple polygon coordinates with formatting such as:

“<MultiGeometry><Polygon><outerBoundaryIs><LinearRing><coordinates>longitude,latitude longitude,latitude  longitude,latitude...</coordinates></LinearRing></outerBoundaryIs></Polygon><Polygon><outerBoundaryIs><LinearRing><coordinates>longitude,latitude  longitude,latitude  longitude,latitude… </coordinates></LinearRing></outerBoundaryIs></Polygon></MultiGeometry>”

I need a new column (named ‘static’) created immediately to the right of the ‘geometry’ column with the same data provided in the ‘geometry’ column, but all of the coordinate points should be formatted as such with the following values: first a Latitude decimal followed by a connecting comma and lastly followed by a Longitude decimal. Each point should remain in its respective position, only the Latitude and Longitude decimals are being transposed for each and every coordinate point. This should be accomplished for every row in the spreadsheet.

Do not change or strip the KML tags in the ‘geometry’ cells. The data withing the other columns should remain the same.

A revised Excel spreadsheet has been uploaded as the first one may have become corrupted.

数据输入 数据处理 Excel PHP

项目ID: #7696980

关于项目

17个方案 远程项目 活跃的May 20, 2015

授予:

teeares

Appears to be a simple job. A small clarification, -whether the new column should contain the tags along with the longitude and latitude with a comma & decimal

$30 USD 在3天内
(62条评论)
5.3

有17名威客正在参与此工作的竞标,均价$42/小时

rajeshsonisl

Hello! With 98% to 99% completion rate, 800+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page [login to view URL] 更多

$210USD 在1天里
(982条评论)
8.6
zExcel

A proposal has not yet been provided

$55USD 在1天里
(261条评论)
7.7
editchamp

Hi I have read your job description ... I am highly experienced in this field. I did over 100 similar job perfectly like this one . I can fulfill your requirement . High quality work goes cheap . I a 更多

$30USD 在1天里
(217条评论)
7.2
gangabass

I can generate such file ASAP (in couple of hours) and I can offer you best price here. All I need to start is milestone payment from you. You'll release it after you check everything on your side so nothing to worr 更多

$25 USD 在0天内
(409条评论)
7.2
mehedi276

"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed sever 更多

$10USD 在1天里
(449条评论)
7.4
cybersolutionvw

H! ready to start the work accept the bid Thanks ..............................................................................

$34USD 在1天里
(267条评论)
6.9
cugamelover

I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see the reviews on my profile. It would be my pleasure to do your project. Please have a look at a some Excel p 更多

$40USD 在1天里
(203条评论)
7.2
maverick44000

Hello Sir. I can format the sheet in your desired manner in a few hours. I am ready to accept payment after your verification of output file. Please discuss. Regards.

$50USD 在1天里
(72条评论)
6.8
Rajni0802

Greetings, I'm interested in your proposed project and can do this task of formatting the geo-location data in a new column as per your provided specifications. I have skills in Web-research tasks and collecting inf 更多

$30USD 在1天里
(103条评论)
6.1
Yapson

Hi there I believe that I am the perfect person for this project. With my excellent Excel skills, I can guaranty you a precise result on each and every adjustment and order arrangement of your data. I am really look 更多

$20USD 在1天里
(24条评论)
5.7
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll I have provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST.

$25USD 在1天里
(115条评论)
5.5
tomislav1975

Hi, I have seen your files and Ican do this. Please check my profile and contact me if you're interested. Thanks

$50USD 在1天里
(35条评论)
5.3
Pradeepj5061

hi mate, i understood what needs to be done. i have few doubts in your project requirement. let's discuss about that. Thanks

$30USD 在1天里
(12条评论)
3.6
sanjay1208

A proposal has not yet been provided

$35 USD 在0天内
(2条评论)
1.8
francisroy06

Hi, As PCO at the agency of the revenu of Quebec, I've developed a complex management tool with VBA macros, an advance coding software within Excel. In my everyday job I use Excel and I am sure I can do the work you 更多

$25USD 在1天里
(0条评论)
0.0
jamunaaprajapati

I am a graduate engineer with vast experience of 20 years in Excel / lotus-123 in formula, charts, graphs, macros and VB codes. I have also full exposure to the Engineering, managerial and commercial mathematics. I 更多

$11USD 在1天里
(0条评论)
0.0