Office for mortals
-
Google earth / maps
View UTM coordinates in Google Maps and Street View – using AppScript on Google Spreadsheet
This is an exercise developed with students from a Google Scripts course carried out by the AulaGEO Academy, with the aim of demonstrating the possibilities of applying development to the well-known Geofumadas Templates. Requirement 1. Download a template of…
Read More » -
AutoCAD-AutoDesk
Draw points, lines and texts of a polygonal from Excel to AutoCAD
I have this list of coordinates in Excel. No. ,1 In these there is an X coordinate, a Y coordinate, and also a name for the…
Read More » -
Maps
Insert map in Excel - get geographic coordinates - UTM coordinates
Map.XL is an application that allows you to insert a map into Excel and obtain coordinates directly from the map. In addition, you can also display a list of latitudes and longitudes on the map. How to insert the map in Excel Once…
Read More » -
AutoCAD-AutoDesk
Paste a spreadsheet in AutoCAD, which is automatically updated
Although we could get to the point, indicating that Office Importer is a tool with which you can have an Excel spreadsheet or a Word file linked, and have it dynamically update according to…
Read More » -
Geospatial - GIS
Import coordinates from Excel to QGIS and create Polygons
One of the most common routines in the use of Geographic Information Systems is the construction of spatial layers from information from the field. Whether this represents coordinates, parcel vertices, or elevation grids,…
Read More » -
GPS / Equipment
Microstation: Import Excel Coordinates and Annotations
The case: I have data collected with GPS Promark 100, and by using the post-processing GNSS application that these teams have, it allows me to send the information to Excel. The columns marked in yellow are the coordinates east, north and their respective…
Read More » -
AutoCAD-AutoDesk
Convert decimal geographic coordinates to degrees, to UTM and draw in AutoCAD
This Excel template is initially made to Convert geographic coordinates in UTM, from decimal format to degrees, minutes and seconds. Just the opposite of the template that we had made before, as seen in the example: Additionally:…
Read More » -
Internet and Blogs
How to access an external email from Gmail using POP3
In this article we will see how to configure POP Gmail. For those who travel a lot or need to access email from different computers, using the Microsoft Outlook client is really inconvenient; although for institutional purposes it is almost inevitable,…
Read More » -
Internet and Blogs
Fix Smart Quotes for Straight Quotes in Microsoft Word
This is usually a problem when editing html text in Microsoft Word or Live Writer. The problem is a code like Strange questions about CAD technologies It will give us a problem, since the quotes we use must be the…
Read More » -
Internet and Blogs
How to make an automatic index with Microsoft Word
Microsoft Word is usually one of those programs that we learned to use without taking a course. By clicking and entering we realized that it is used to make documents, that it has tables, that the tables add up like in Excel...
Read More » -
Others
Show more recent files, Word and Excel
It often happens to us that we forget where a file was stored. Sometimes we moved it, we opened it in the download folder of the browser or simply the obsolete Windows search engine is a calamity. So if that file...
Read More » -
Internet and Blogs
How to remove commas and hyperlinks from numbers in Excel
Many times when copying data from the Internet to Excel, numbers have commas as thousands separators. No matter how much we change the format of the cell to a number, it is still text because Excel cannot understand the thousands separator...
Read More » -
Others
How to Compare Word Documents
It often happens to us that we work on a document, then someone changes it without checking changes and sooner or later we have to compare the two. Despite the fact that I rarely write about programs for mere mortals,…
Read More » -
My geofumadas
4 Problem: Acer Aspire One does not send to Datashow
In the case of Acer Aspire computers, the combination to send the screen view to an external monitor projector is in the combination Fn + F5. It can happen that they don't respond, and when you have 200 people...
Read More » -
Others
Change uppercase to lowercase with Microsoft Word and something else
Word 2007 and its ribbon, like AutoCAD left us with some things out of control when we are in a hurry. The problem I was looking to convert text from lowercase to uppercase, which was previously a menu click away. …
Read More » -
Maps
Convert degrees/minutes/seconds to decimal degrees
This is a very common task in the GIS/CAD field; a tool that allows you to convert geographical coordinates from heading format (degree, minute, second) to decimals (latitude, longitude). Example: 8° 58′ 15.6” W that requires conversion to decimal format:…
Read More » -
Geospatial - GIS
MapinXL, maps from Excel
MapinXL is an application built by ARTICQUE, aimed at office people, who are not GIS experts but want to impress with colored maps. We spend our lives trying to connect our maps to Excel, aware that others…
Read More » -
innovations
How to know the password of a file
There are various tools on the Internet, which allow you to find a secret password, or as we will call it today: the password of a file, I do not intend with this post to promote malice; rather explain the risk that exists in believing that…
Read More »