Archives for

# Coupons

## See Google Earth coordinates in Excel - and convert them to UTM

I have data in Google Earth, and I want to visualize the coordinates in Excel. As you can see, it is a plot with 7 vertices and a house with four vertices. Save Google Earth data. To download this data, right click on "My Places", and select "Save place as ..." For being a file ...

## Draw a polygon in Microstation from Excel

Using this template, you can draw a polygonal in Microstation, from a list of bearings and distances in Excel, or a list of coordinates x, y, z. 1 case: List of Directions and Distances Suppose we have this table of data from the field: In the first columns you have the stations, ...

## Template to create dxf file from list of points in Excel

Recently Juan Manuel Anguita has passed me the new version of this application that we had previously promoted, but that time had left with some problems with the new version of Excel. Its use is very simple, but highly functional. You have to enter a point number, coordinate x, y, z; I have placed ...

## Convert decimal geographic coordinates to degrees, to UTM and draw in AutoCAD

This Excel template is initially made to convert geographic coordinates into UTM, from decimal format to degrees, minutes and seconds. Just the opposite of the template that we had previously done, as seen in the example: Additionally: The concatenates them in a chain Converts them to UTM coordinates, with the option to choose a ...

## Export list of geographic coordinates to Google Earth, from Excel, with image and rich text

This is an example as with Excel you can send content to Google Earth. The case is this: We have a list of coordinates in decimal geographic format (lat / lon). We want to send to Google Earth, and we want to show the code of the point of interest, a text in bold, a descriptive text, a photograph of ...

## Excel to Google Earth, from UTM coordinates

Let's see the case: I have gone to the field to build a property, as shown in the following table and I want to visualize it in Google Earth, including a couple of photos that I have taken The genius of the template is that of a single one: It converts the UTMa Geographical coordinates in decimal format, as it is the ...

## Draw a polygon with bearings and distances from Excel to Microstation

A few years ago I published an article in which showed how to concatenate data in Excel to build a polygonal with AutoCAD, without having to do the whole protocol: @distancia <angle .... The other day we were in the AutoCAD course, someone asked me if that could be done with the Microsation command line. The…

## Convert degrees / minutes / seconds to decimals

Some time ago I have been asking for this, and since the friend seems a bit rushed and today is a day to celebrate many things, here is a tool that allows you to convert geographic coordinates, degrees to decimals. Why the conversion table It is common to find coordinates that are in degrees, minutes, seconds, ...

## Build Polygon based on directions and distances in an Excel table

Let's see what the point is: I have the data of a polygonal with directions and distances, and I want to build it in AutoCAD or Microstation. Previously we saw that AutoCAD has its way of feeding this type of data under the format @dist <while in Microstation it is done through the AccuDraw. Well, in response to our ...

## Create a box of bearings and distances from UTM coordinates

This post is in response to Diego, from Paraguay, who asks us the following question: a pleasure to greet him ... a while ago for a search that I had arrived without wanting to want to his website and I found it very interesting, both for the content and for the friendly way to communicate your science. I would like to ask you, if you know any ...

## Convert UTM to Geographic Coordinates with Excel

In the previous post we had shown an Excel sheet to convert Geographical coordinates to UTM from a sheet that Gabriel Ortiz had popularized. Let's see now this tool that does the same process in reverse, that is, having coordinates in UTM format (Universal Traverso de Mercator) and knowing the area, transforming them to latitudes ...

## Excel template to convert from Geographic Coordinates to UTM

This template facilitates the conversion of geographic coordinates in degrees, minutes and seconds to UTM coordinates. 1 How to enter the data The data must be processed in an excel sheet, so that they come in the format that is required. Of course, the normal restrictions regarding the ranges of accepted values ​​must respect them ...