As many readers are looking for a reference to calculate land lot area and perimeter with GPS coordinates data (Global Positioning System), so I create an Excel software specifically for that purpose.

**Download here.**

Simply by writing longitude and latitude data of each vertex of a land lot, then the program will instantly calculate the area and perimeter. To avoid confusing, always use a clockwise direction to input vertex coordinates of the land lot. Counter clockwise direction will get negative result of area calculation.

In the picture below, I calculate area and perimeter of an area around National Monument (Monas, Jakarta). Picture shows GPS coordinates obtained from Google Maps. Please note that Google Maps uses latitude-longitude order.

Shown in the picture above the land lot is an irregular shaped polygon with 8 vertices (octagon). The starting point is the vertex at bottom left, then this point is also used as an end point to form a closed irregular polygon so that the program can calculate it’s area and perimeter. Total 9 GPS coordinates are written, as the starting point and end point at the same vertex. Coordinates are written in yellow cells, and they are sorted in clockwise order. On the right, there is a graph illustrating the measured polygon shape. In this example, octagonal polygon area is 231,339 square meters, and the perimeter is 1782.7 meters.

Read also how

**.**

__Microsoft Excel calculates degrees__In the attached Excel software workbook, there is also formula to convert GPS data with sexagesimal (degrees minutes seconds) format to become decimal format, then that decimal format will be used to calculate the area and perimeter of a land lot with irregular and regular polygon shaped.

This article is related to previous articles: calculation of polygons and

**calculate distance with GPS coordinates**.

There are two methods for calculation of polygon area,

**by matrix**and

**by rectangles**.

Matrix method is rather difficult to understand but the formula is simpler. And there is an article that explain about

**polygon perimeter calculation**.

If you are looking for a reliable and high quality GPS equipment such as Garmin, TomTom, Magellan, Midland, Rand McNally, including the popular Garmin GPS 60, vehicle GPS, fleet GPS, please check at GPS online shop "

**".**

__Best Sellers in GPS & Navigation Equipment__
Thank you. Your area calculation spreadsheet was very helpful in the calculation of the area of body of water I own. Dan

ReplyDeleteYou are welcome...I use that spreadsheet to calculate GPS data at field. Once I get data and put it into that spreadsheet, it calculates immediately. No need special application, no need internet connection.

DeleteCould not download file. Is it still available?

ReplyDeleteI've checked already with different computer and found no problem, the file is still available publicly for download.

DeleteAs that Excel file also contains other GPS calculations such as: heading, bearing, distance, etc; you can download the same Excel file from other articles about GPS in this blog. Please select 'Global Positioning System' label to find more articles about GPS.

May be you should open it with Firefox or Google Chrome web browser in your computer.

Thanks for your input, Heru.

Thank you so much! This is an amazing free tool that made my life so much easier as I was calculating the land size of over 100 farmers in Mali, West Africa!

ReplyDeleteYou are welcome, hope the tool will help you to produce more food in the future, and better economy for Mali's farmers.

DeleteRgs, Heru

magnificient..solved a big headache for me

ReplyDeleteHi Maruza,

ReplyDeleteIs the excel sheet still available? I need one to do my field work ..

Hi JD.. just checked, the file is still available for download..

DeleteYou can check to below Google docs address also

https://docs.google.com/file/d/0B-nhsU-fDuE6XzJLaEt2cDNJU0U/edit?pli=1

where is this file? the .xls or .xlsx file. The link does not link to an excel file.

ReplyDeleteSorry..Got the file now but it is not working even in a new version of excel.

ReplyDeleteI just checked and found no problem at all.. tx

Deletei think the area is plain area how can i get the actual surface area of land using GPS?

ReplyDelete

DeleteThat Excel program has already calculated area on sphere surface, not plain area.

If you need to calculate area with texture or with elevation, then you need 3 dimensional calculation. Surveyor softwares can do that, and AutoCad also can do.

Regards, Heru.

Hi..

ReplyDeleteIm working at several sites in Indonesia. Thanks to your Excel program with English and Bahasa guidance. Myself and my Indonesian crews can calculate and report land lot areas with their smart phones, helped by your Excel spreadsheet.

Regards JJ

tnx

ReplyDeletearea table works very nice! :)

keep it up

Very helpful.

ReplyDeleteMany thanks

Nice post,it's very informative.i found the best information.I updated my knowledge with this blog.it can help me to crack GIS jobs in Hyderabad.

ReplyDeleteWith a very irregular land, is there a limit of lat & lon points (say one hectare) one could enter to determine area?

ReplyDeleteThe limit is only Excel row number(65,536 rows), because calculation start on row 10th, so maximum 65,527 points of polygon vertices can be calculated (Latitude and Longitude).

DeleteCan this program be saved in a laptop computer as an XL file to be accessed manually later where there is no connection to Chrome with WI-FI?

ReplyDeleteYou can download and save it in your computer to work offline. Because that Excel file is shared for public.

DeleteThank you Heru for your replies. I think if you could provide additional information it would greatly be appreciated - such as step by step instructions on how to insert your file in to XL 2003 users.

DeleteIt is simply using Copy Paste command in Excel, nothing complicated. But maybe your Excel is too old (97-2003??), I don't have it anymore. But the file and formula in it was created in 2007 and I was using 2003 Excel. Later I was using newer Excel 2010 to publish it in this article. I think you can Copy Paste those formulas to your Excel, after creating table/chart with the same formatting. Try with a simple square land lot area and perimeter calculation to test your formula, before calculate a more complicated polygon.

DeleteWhat's more, remember to agree to accept Active Junky to get selective offers and cashback on your hardware buys. montre golf

ReplyDeleteMounts designed to hold a GPS in your car or RV will typically attach to your front windshield, published but some will also work on your dashboard. You need to see the directions while you are driving, and that means having the map and written street names or addresses directly in front of you.

ReplyDeleteGreat Article Artificial Intelligence Projects

ReplyDeleteProject Center in Chennai

JavaScript Training in Chennai

JavaScript Training in Chennai

Artificial Intelligence (AI) is the human process simulated by computer, such as: learning, reasoning, and self-correction. In the future, AI will help us as our jobs become more complex

DeleteAivivu chuyên vé máy bay, tham khảo

ReplyDeletevé máy bay đi Mỹ tháng nào rẻ nhất

vé máy bay từ los angeles về việt nam

vé máy bay giá rẻ đi Los Angeles

giá vé máy bay từ Toronto đến việt nam

instagram takipçi satın al - instagram takipçi satın al - tiktok takipçi satın al - instagram takipçi satın al - instagram beğeni satın al - instagram takipçi satın al - instagram takipçi satın al - instagram takipçi satın al - instagram takipçi satın al - binance güvenilir mi - binance güvenilir mi - binance güvenilir mi - binance güvenilir mi - instagram beğeni satın al - instagram beğeni satın al - polen filtresi - google haritalara yer ekleme - btcturk güvenilir mi - binance hesap açma - kuşadası kiralık villa - tiktok izlenme satın al - instagram takipçi satın al - sms onay - paribu sahibi - binance sahibi - btcturk sahibi - paribu ne zaman kuruldu - binance ne zaman kuruldu - btcturk ne zaman kuruldu - youtube izlenme satın al - torrent oyun - google haritalara yer ekleme - altyapısız internet - bedava internet - no deposit bonus forex - erkek spor ayakkabı - webturkey.net - minecraft premium hesap - karfiltre.com - tiktok jeton hilesi - tiktok beğeni satın al - microsoft word indir - misli indir

ReplyDeleteinstagram takipçi satın al

ReplyDeleteinstagram takipçi satın al

aşk kitapları

tiktok takipçi satın al

instagram beğeni satın al

youtube abone satın al

twitter takipçi satın al

tiktok beğeni satın al

tiktok izlenme satın al

twitter takipçi satın al

tiktok takipçi satın al

youtube abone satın al

tiktok beğeni satın al

instagram beğeni satın al

trend topic satın al

trend topic satın al

youtube abone satın al

instagram takipçi satın al

beğeni satın al

tiktok izlenme satın al

sms onay

youtube izlenme satın al

tiktok beğeni satın al

sms onay

sms onay

perde modelleri

instagram takipçi satın al

takipçi satın al

tiktok jeton hilesi

instagram takipçi satın al pubg uc satın al

sultanbet

marsbahis

betboo

betboo

betboo

ReplyDeleteI am very impressed with your post because this post is very beneficial for me and provide a new knowledge to me

Minecraft Crack

takipçi satın al

ReplyDeletetakipçi satın al

takipçi satın al

marsbahis

ReplyDeletebetboo

sultanbet

marsbahis

betboo

sultanbet

For this situation, the best wellspring of data would be those common in the different gatherings and talk bunches visited by GPS gadget clients. ADN GPS

ReplyDeleteFor this situation, the best wellspring of data would be those common in the different gatherings and talk bunches visited by GPS gadget clients. ADN GPS

ReplyDeleteHi, I recently bought an irregular piece of land I have no idea what its area is. I was struggling to find out the exact dimensions of the land. I hope this application will help me. Thanks. Honest

ReplyDelete