Calculating Distance Between Two Geographical Coordinates In Excel

calculate distance between two coordinates

Every day you can learn something new, and when it comes to programs whose management is essential for perform different types of activities and projects , any time is ideal to understand how important and useful it can become some software tools that might be considered basic.

Have you ever made you think of the number of tools and hidden features of a program ? Surely you’ll get a positive surprise to the take a look at what you can do office automation program.

Much more than just numbers

Within the office software, programs that make up Microsoft Office have always highlighted. By far, this software package is the most used in the world, regardless of the operating system using the computer.

You may also be interested in:

The management of these programs has been Pretty required since its inception . Although today some have been displaced, others remain as basic as necessary both on your computer and that of millions of people around the world.

Microsoft Excel is one of those programs that let gaped many people. Its interface is simple and basic, has a huge versatility and inventory Baggy formulas that & nbsp; can easily work


A spreadsheet for distance

Despite being a program very required for administrative and accounting tasks, the fact is that Microsoft Excel has much more to offer. One is the calculate distances between two points .

spreadsheet for distance

You can have all the security of the world in which information you’ll meet here at some point, you will find it extremely useful and you will not regret having read this article and have tried everything you are here indicated.

What you need to start

You should be aware that, anyway, precisarás of the use of platforms or applications that you provide certain information.

To carry out this information, you will need, for example, the longitude and latitude of both the departure point as the end point, information that can get through GPS services like Google available.

The other is to know that for this, equation Haversine , an equation used by the vast majority of GPS systems because of the precision that can have, shall apply earning a put on the recommendations of many people.

Structuring variables and constants

Once you run Excel on your computer, the time comes to shape everything you need for the equation. In this sense, you’ll need four cells for the longitudes and latitudes of the colon, these variables are called them. Ideally take the first cells and , so that:

  • The cell A1, becomes «Latitude1».
  • A2 becomes «Longitud1».
  • B1 becomes «Latitud2».
  • B2 becomes «Length2».

    On the other hand, for constants, they are the cells that continue to set the values ​​for the radius of the sphere to go use. In this sense, the cells:

    variables and constants

    • C1 corresponds to « RadioMillas «.

      • Enter the value «3959» in this cell.

      • C2 to «RadioKilometros».

        • Enter the value «6371» in this cell.

        • C3 will be used for data validation.
        • Go to the «Data» tab.
        • Click the «Data Validation» button.
        • In the» allow» section, select the «List» option.
        • Set «Miles, Kilometers» for the type of validation.

          structure of formula

          Already having the structure of variables and constants, and you count, in turn, with the necessary information, it’s time to specify the formula that will help you the calculation of the distance . You can use the cell C4 to establish the following formula:

          • = ACOS (COS (RADIANS (90-Latitude_1)) & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; COS (RADIANS (90-Latitude_2))
          • + SIN (RADIANS (90-Latitude_1)) & nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; SIN (RADIANS (90-Latitude_2))
          • COS (RADIANS (Longitude_1-longitude2 IF (C3=»Miles» RadMiles, RadKilom)

            It is checked!

            List formula, it is time to enter the values ​​for each of the variables and constants to verify that indeed the Haversine equation works perfectly in Excel to calculate distance between two points. On the other hand, you can also learn to calculate and measure complete distances and areas.

            How useful did you find this content?

            Click on a star to rate!

            Average score 0 / 5. Counting of votes: 0

            So far, no votes. Be the first to rate this content.

            I'm sorry this content was not useful for you!

            Let me improve this content!

            Tell me, how can I improve this content?

            You may also be interested in:

Deja un comentario