PO.DE.Dir.ClosureAzimuth


Description

Direction of a station from the surface location, in degrees from north, 0 to 360. Excel's ATAN2(x, y) takes x first, so ATAN2(N, E) is the angle from north toward east. A station on the surface location returns 0.

Formula

=LAMBDA(North_ft, East_ft, IF(AND(North_ft = 0, East_ft = 0), 0, MOD(DEGREES(ATAN2(North_ft, East_ft)), 360)))

Parameters

Parameter Unit Description
North_ft ft Northing from the surface location
East_ft ft Easting from the surface location

Examples

Invocation Expected
=PO.DE.Dir.ClosureAzimuth(300, 400) 53.130102
=PO.DE.Dir.ClosureAzimuth(-300, -400) 233.1301

Need a custom LAMBDA? Suggest a New Lambda