Shopping Cart

Free Newsletter
Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

FileMaker Pro Custom Functions

List | Show Random | Upload | Add This to Your Site

PolygonArea ( xlist ; ylist )

Rate this function:

Average rating: 4.5 (29 votes)
Discuss this Custom Function

Jeremiah Small, Soliant Consulting
http://jsmall.us

Calculate area of a polygon from array of XY coordinates

Sample Input:

PolygonArea ( List ( 0;3;0 ) ; List ( 0;0;3 ) )

Sample Output:

4.5

//20060806 jsmall@soliantconsulting.com //purpose: calculates area of polygon using Double Meridian Distance //dependency: PolygonAreaHelper //key: Lat is Latitude; Dep is Departure If ( ValueCount ( xlist ) ≥ 3 and ValueCount ( xlist ) = ValueCount ( ylist ) ; Let ([ Lat = MiddleValues ( ylist ; 2 ; 1 ) - MiddleValues ( ylist ; 1 ; 1 ) ; Dep = MiddleValues ( xlist ; 2 ; 1 ) - MiddleValues ( xlist ; 1 ; 1 ) ; DMD = Dep ; DArea = Lat * DMD ; TotalDArea = DArea + PolygonAreaHelper ( xlist ; ylist ; Dep ; DMD ; 2 ; ValueCount ( xlist ) ) ]; Abs ( TotalDArea ) / 2 ) ;//endLet "Lists must contain same number of values, minimum 3." )//endIf
Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

Calculate the area of a polygon from an arbitrary number of xy coordinates. It uses an old surveying technique called Double Meridian Distance.

Requires helper function: PolygonAreaHelper

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:

Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1.	StopwatchMilliseconds ( StartTimeLapLapsStopClear , LapPrefix )
	(Fri, Jun 23, 9:46am)
2.	StopwatchSeconds ( StartTimeLapLapsStopClear , LapPrefix )
	(Fri, Jun 23, 9:40am)
3.	LinkedInLookup ( name )
	(Fri, Jun 23, 1:07am)
4.	BaseX_ToDecimal ( baseString; decimalNumber )
	(Tue, Jun 20, 8:40am)
5.	BaseX_FromDecimal ( baseString; decimalNumber )
	(Tue, Jun 20, 8:33am)
6.	AutoPct ( myValue )
	(Thu, Jun 15, 12:07pm)
7.	BarcodeCode128B_BMP_380px ( string )
	(Wed, Jun 14, 4:05pm)
8.	FrontTabPanelNames ( param )
	(Tue, Jun 13, 5:46am)