Finding if a set of coordinates is in a particular area

[rico355]

Is it possible to use excel to find if a particular set of coordinates falls within an area (composed of coordinates, like a fence)?

In the example below, I have coordinates for all four corners of a made-up home, gym, and work site. I am trying to see if Excel is capable of recognizing what site the Sample Points are located in.
Note: Sample Point 1 = Home, Sample Point 2 = Gym, Sample Point 3 = Work.

	Corner 1	Corner 2	Corner 3	Corner 4
	X	y	X	y	X	y	X	y
Home	29.929715	-95.250671	29.92932	-95.250758	29.929679	-95.250428	29.92933	-95.250389
Gym	29.937167	-95.248193	29.937171	-95.247482	29.936654	-95.248173	29.936656	-95.247466
Work	29.935902	-95.248618	29.935912	-95.247947	29.935369	-95.248625	29.935379	-95.247929
	x	y
Sample Point 1	29.929436	-95.250624
Sample Point 2	29.936901	-95.247904
Sample Point 3	29.935536	-95.248331

<tbody>
</tbody>

 

[Legacy 143009]

Is it possible to use excel to find if a particular set of coordinates falls within an area (composed of coordinates, like a fence)?

In the example below, I have coordinates for all four corners of a made-up home, gym, and work site. I am trying to see if Excel is capable of recognizing what site the Sample Points are located in.
Note: Sample Point 1 = Home, Sample Point 2 = Gym, Sample Point 3 = Work.

	A	B	C	D
	X	y	X	y	X	y	X	y
Home	29.929715	-95.250671	29.92932	-95.250758	29.929679	-95.250428	29.92933	-95.250389
Gym	29.937167	-95.248193	29.937171	-95.247482	29.936654	-95.248173	29.936656	-95.247466
Work	29.935902	-95.248618	29.935912	-95.247947	29.935369	-95.248625	29.935379	-95.247929
	x	y
Sample Point 1	29.929436	-95.250624
Sample Point 2	29.936901	-95.247904
Sample Point 3	29.935536	-95.248331

<tbody>
</tbody>

OK.. You have to follow me very carefully.
Order of the corners has a great importance.
Corners B and D should not be neighbors. They should be opposing corners. Since A, B, C, D is a 4-corner polygon:

1. Draw a line from corner B to D. Now you have a ABD triangle and DBC triangle. Calculate each triangle's area by coordinates theorem. Can I find the total area of the polygon if I merge these triangles base-to-base? Yess..
2. You can merge two triangles and find the total area of polygon.
3. Then think the point hits in a polygon range. Then you may think it as a cake. You can make 4 slices in the shape of a triangle.
4. If sum of all slices equals to total area of polygon, then yes the point is inside the rectangle.

Ok.. Things are getting complicated. Please follow the sample workbook below:
https://drive.google.com/file/d/1TLIq3RUM602qC9iGvtLnOFlAl-IB56VT/view?usp=sharing

Useful resources:
https://math.stackexchange.com/questions/190111/how-to-check-if-a-point-is-inside-a-rectangle
https://www.mathopenref.com/coordtrianglearea.html