Graphing angles -- any ideas?

[Brad Reid]

I have converted the standard notation of DDD.MMSS (degrees minutes and
seconds) used for land surveys into angles (for use with Excel) with the
following results:

DDD.MMSS ANGLE Distance
N 80°46'00'' W 80.75000 74.8 feet
N 42°15'13'' W 42.25361 62.63
N 48°10'30'' E 48.17500 56.1
N 00°07'20'' W 0.12222 43.81
S 89°58'30'' E 89.98 61.95
S 05°01'45'' E 5.03 140.09

So, the first row means " from a northerly bearing (N), the line extends
74.8 feet at an angle of 80.75 degrees westerly (W). Well, I'm not an
engineer, but that seems to be what the map suggests as I study each of
these surveyor measurements. I used this formula, one that I found on the
Internet to derive the angle from the DDD.MMSS in a cell shown as, for
example, 804600, but formatted using a customized format to end up with
80°46'00'' :

=(TRUNC(B2/10000))+((B2/100-TRUNC(B2/100))*100/3600+TRUNC(((B2/10000)-TRUNC(
B2/10000))*100)/60)

80°46'00'' is equal to 80.75000 degrees. I added the directional info in
separate columns adjacent to the DDD.MMSS stat for later reference. Too,
the distance of each property line is recorded from the plat.

Well, if I now have the angle of each line, and the length of each line,
could someone suggest a possible step that would lead to me being able to
draw the shape of the boundaries of this residential lot on an Excel chart?

I'm making slow progress but certain progress toward a solution to graph
this odd-shaped 6-sided lot. Thanks in advance for any suggestions. Brad

 

[Dan E]

Brad,

With what you've given you'll need to vary your formula's
based on the NESW
For X's
If you have an east use
=Distance*COS(Angle*PI()/180)
If you have a west use
=-Distance*COS(Angle*PI()/180)
For Y's
If you have a south use
=-Distance*COS(Angle*PI()/180)
If you have a north use
=Distance*COS(Angle*PI()/180)

If all of your data are as your data is as you showed
For X's
=IF(RIGHT(DDD.MMSS,1)="E", Distance*SIN(Angle*PI()/180), -Distance*SIN(Angle*PI()/180))
For Y's
=IF(LEFT(DDD.MMSS,1)="N", -Distance*COS(Angle*PI()/180), Distance*COS(Angle*PI()/180))

This will give you X and Y coordinates to scatterplot
DDD.MMSS, Angle, and Distance refer to cells that
contain these values.


Dan E

 

[Dan E]

Brad,

Error in the last formula, it should be
=IF(LEFT(DDD.MMSS,1)="N", Distance*COS(Angle*PI()/180), -Distance*COS(Angle*PI()/180))

Dan E