Do some Excel Work
$10-30 USD
货到付款
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.
项目ID: #7696980
关于项目
授予:
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
有17名威客正在参与此工作的竞标,均价$42/小时
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] 更多
H! ready to start the work accept the bid Thanks ..............................................................................
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 更多
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.
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.
Hi, I have seen your files and Ican do this. Please check my profile and contact me if you're interested. Thanks
hi mate, i understood what needs to be done. i have few doubts in your project requirement. let's discuss about that. Thanks
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 更多
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 更多