Saturday, February 03, 2018

enhanced the plotter

Updated my Excel double star plotter workbook. Version 5 now correctly calculates the non-primary details, that is, if a CD angle and separation is quoted, it will figure out the AD position angle and angular separation. To solve a side-angle-side (SAS) triangle I had to use The Law of Cosines. That was to calculate the unknown side. Then I used The Law of Sines to find the smaller of the other two angles. Trig. Ugh. Had to blow out the cobwebs but it works! While it doesn't work for multiple instances, it is completed automated for each individual pair. Very happy.

No comments: