{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":101,"n_cols":15,"rows_kept":101,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Tricking EXCEL into plotting azimuth and take-off angle data is simply a matter "]
["of calculating polar coordinates and remembering that the gradations from 0 to 90 "]
["degrees are linear.  You want Take-off angle = 0 on the equator and Take-off angle = 90 in the center."]
["So the slope (b) is dposition/dx or (1 - 0)/(0 - 90)  (d's for derivatives)"]
["Thus, -0.0111 is the slope (m) for plotting inclination and 1.0 is the intercept (b)"]
[]
["Data","m=",-0.011111111111111112,"b=",1]
[null,"Take-off"]
["Azimuth","Angle","H=m*Inc+b","Y=H*cos(D)","X=H*sin(D)"]
[]
[142,78.48,0.1279999999999999,-0.10086537646166031,0.0788046688416842,"D",1,null,244,49.2,0.45333333333333325,-0.19872825321104853,-0.40745330098895555,"C",2]
[244,49.2,0.45333333333333325,-0.19872825321104853,-0.40745330098895555,"C",2,null,10,41.21,0.5421111111111111,0.5338752252162847,0.09413660653743923,"C",3]
[10,41.21,0.5421111111111111,0.5338752252162847,0.09413660653743923,"C",3,null,192,39.65,0.5594444444444444,-0.5472192410771901,-0.11631504036304631,"C",4]
[192,39.65,0.5594444444444444,-0.5472192410771901,-0.11631504036304631,"C",4,null,155,30.82,0.6575555555555556,-0.5959477204092105,0.27789498588682887,"C",6]
[302,32.83,0.6352222222222222,0.33661649262458126,-0.5386989961918098,"D",5,null,116,29.84,0.6684444444444444,-0.2930267576758989,0.6007938869484208,"C",7]
[155,30.82,0.6575555555555556,-0.5959477204092105,0.27789498588682887,"C",6,null,223,29.2,0.6755555555555556,-0.4940700562049508,-0.4607277810199989,"C",8]
[116,29.84,0.6684444444444444,-0.2930267576758989,0.6007938869484208,"C",7,null,187,20.98,0.7668888888888888,-0.761172615403156,-0.09346024535359218,"C",9]
[223,29.2,0.6755555555555556,-0.4940700562049508,-0.4607277810199989,"C",8,null,28,10.81,0.8798888888888888,0.7768957764277603,0.41308281174460765,"C",13]
[187,20.98,0.7668888888888888,-0.761172615403156,-0.09346024535359218,"C",9,null,142,78.48,0.1279999999999999,-0.10086537646166031,0.0788046688416842,"D",1]
[56,18.83,0.7907777777777778,0.4421973215557006,0.6555844893193591,"D",10,null,302,32.83,0.6352222222222222,0.33661649262458126,-0.5386989961918098,"D",5]
[1,15.8,0.8244444444444444,0.8243188775622692,0.01438853952940485,"D",11,null,56,18.83,0.7907777777777778,0.4421973215557006,0.6555844893193591,"D",10]
[36,12.02,0.8664444444444445,0.7009682802373156,0.5092832663751895,"N",12,null,1,15.8,0.8244444444444444,0.8243188775622692,0.01438853952940485,"D",11]
[28,10.81,0.8798888888888888,0.7768957764277603,0.41308281174460765,"C",13,null,36,12.02,0.8664444444444445,0.7009682802373156,0.5092832663751895,"N",12]
[]
["Unit Circle:  plot cosine versus sine to get a circle"]
[]
["DEC","UNIT","cos(DEC)","sin(DEC)"]
[]
[0,1,1,0]
[5,1,0.9961946980917455,0.08715574274765817]
[10,1,0.984807753012208,0.17364817766693033]
[15,1,0.9659258262890683,0.25881904510252074]
[20,1,0.9396926207859084,0.3420201433256687]
[25,1,0.9063077870366499,0.42261826174069944]
[30,1,0.8660254037844387,0.49999999999999994]
[35,1,0.8191520442889918,0.573576436351046]
[40,1,0.766044443118978,0.6427876096865393]
[45,1,0.7071067811865476,0.7071067811865475]
[50,1,0.6427876096865394,0.766044443118978]
[55,1,0.5735764363510462,0.8191520442889918]
[60,1,0.5000000000000001,0.8660254037844386]
[65,1,0.42261826174069944,0.9063077870366499]
[70,1,0.3420201433256688,0.9396926207859083]
[75,1,0.25881904510252074,0.9659258262890683]
[80,1,0.17364817766693041,0.984807753012208]
[85,1,0.08715574274765814,0.9961946980917455]
[90,1,6.1257422745431e-17,1]
[95,1,-0.08715574274765824,0.9961946980917455]
[100,1,-0.1736481776669303,0.984807753012208]
[105,1,-0.25881904510252085,0.9659258262890683]
[110,1,-0.3420201433256687,0.9396926207859084]
[115,1,-0.42261826174069933,0.90630778703665]
[120,1,-0.4999999999999998,0.8660254037844387]
[125,1,-0.5735764363510458,0.819152044288992]
[130,1,-0.6427876096865394,0.766044443118978]
[135,1,-0.7071067811865475,0.7071067811865476]
[140,1,-0.7660444431189779,0.6427876096865395]
[145,1,-0.8191520442889916,0.5735764363510464]
[150,1,-0.8660254037844387,0.49999999999999994]
[155,1,-0.9063077870366499,0.4226182617406995]
[160,1,-0.9396926207859083,0.3420201433256689]
[165,1,-0.9659258262890682,0.258819045102521]
[170,1,-0.984807753012208,0.17364817766693028]
[175,1,-0.9961946980917455,0.08715574274765864]
[180,1,-1,1.22514845490862e-16]
[185,1,-0.9961946980917455,-0.08715574274765794]
[190,1,-0.984807753012208,-0.17364817766693047]
[195,1,-0.9659258262890684,-0.25881904510252035]
[200,1,-0.9396926207859084,-0.34202014332566866]
[205,1,-0.90630778703665,-0.4226182617406993]
[210,1,-0.8660254037844386,-0.5000000000000001]
[215,1,-0.819152044288992,-0.5735764363510458]
[220,1,-0.766044443118978,-0.6427876096865393]
[225,1,-0.7071067811865477,-0.7071067811865475]
[230,1,-0.6427876096865395,-0.7660444431189779]
[235,1,-0.5735764363510464,-0.8191520442889916]
[240,1,-0.5000000000000004,-0.8660254037844384]
[245,1,-0.42261826174069994,-0.9063077870366497]
[250,1,-0.3420201433256694,-0.9396926207859082]
[255,1,-0.25881904510252063,-0.9659258262890683]
[260,1,-0.17364817766693033,-0.984807753012208]
[265,1,-0.08715574274765825,-0.9961946980917455]
[270,1,-1.83772268236293e-16,-1]
[275,1,0.08715574274765789,-0.9961946980917455]
[280,1,0.17364817766692997,-0.9848077530122081]
[285,1,0.25881904510252113,-0.9659258262890682]
[290,1,0.34202014332566816,-0.9396926207859085]
[295,1,0.4226182617406996,-0.9063077870366499]
[300,1,0.5000000000000001,-0.8660254037844386]
[305,1,0.573576436351046,-0.8191520442889918]
[310,1,0.6427876096865393,-0.7660444431189781]
[315,1,0.7071067811865474,-0.7071067811865477]
[320,1,0.7660444431189778,-0.6427876096865396]
[325,1,0.8191520442889916,-0.5735764363510465]
[330,1,0.8660254037844384,-0.5000000000000004]
[335,1,0.9063077870366497,-0.4226182617407]
[340,1,0.9396926207859084,-0.3420201433256686]
[345,1,0.9659258262890683,-0.2588190451025207]
[350,1,0.9848077530122079,-0.17364817766693127]
[355,1,0.9961946980917455,-0.08715574274765832]
[360,1,1,-2.45029690981724e-16]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}