I have three columns of cells with geographic coordinates. For example:
40.614362,-73.974187 | 40.618654,-73.989636 | 40.629675,-73.979092
I want to calculate an area between these coordinates to get similar results as I would get from http://www.daftlogic.com/projects-google-maps-area-calculator-tool.htm It seems like a regular "planar" formula for a triangle area as seen here https://math.stackexchange.com/a/516223/195545 does not produce accurate results.
Note that latitude and longitude coordinates are in the same cell. I figured out that I can use the following formula to extract latitude and longitude values:
=REGEXEXTRACT(A1,"(.*?),") # for latitude =REGEXEXTRACT(A1,",(.*?)$") # for longitude
How can I reproduce area calculations in Google Sheets?