Problem 1 (of 1) Using the three-page Excel table provided (HW5-TRAVERSE DATA.xlsx), do the following: a) That table (your table") contains the measurements seen in class on my table. b) On your table, try to duplicate the results shown in class, performing the horizontal and vertical adjustment c) Turn in your completed Excel table only. B D N 50 15' 45 w A Elevation A= 1000.00 Elevation Adj.Elev LINE HI V HR To B 5.47 0.00 4.26 To C 4.26 6.34 5.47 0.00 0.00 To D 4.26 To A 6.05 0.00 4.26 0.00 Miscl= Corr= 0.00 0.00 n= 4 Y 1000.00 Z 1000.00 COORDINATES of A= 1000.00 AZAP= a= AZAB= Angle A B C 0.00000 0.00000 0.00000 0.00000 Azimuth D From-To HD Latitude A-B 0.00 0.00 B-C 0.00 Departure 0.00 0.00 0.00 0.00 0.00 C-D 0.00 0.00 D-A 0.00 0.00 Sum= Check AzAB= 0.00 Misclosures Correction 0.00 0.00 0.00 0.00 Adj.Lat. Adj.Dep. From-To A-B B-C C-D D-A Check COORDINATES X Y B D Check To Sta HC VC SD HD VD At Sta hi 5.47 hr 4.26 B D 125.52640 215.52690 9.56870 -9.56870 356.47 348.56 B 6.34 4.26 A 210.58740 120.58730 -9.56870 -9.56870 356.47 348.56 C 5.47 4.26 B 10.68140 280.68120 -9.56870 -10.59000 348.56 356.47 D D 6.05 4.26 C 93.22110 3.22070 RawAngs 9.56870 9.56870 AdjAngs 356.47 348.66 A B D A Inside Angs B-D C-A D-B A-C Sum= 180*(n-2) misclosure Correction Corr. Check n= 4 0 seconds Problem 1 (of 1) Using the three-page Excel table provided (HW5-TRAVERSE DATA.xlsx), do the following: a) That table (your table") contains the measurements seen in class on my table. b) On your table, try to duplicate the results shown in class, performing the horizontal and vertical adjustment c) Turn in your completed Excel table only. B D N 50 15' 45 w A Elevation A= 1000.00 Elevation Adj.Elev LINE HI V HR To B 5.47 0.00 4.26 To C 4.26 6.34 5.47 0.00 0.00 To D 4.26 To A 6.05 0.00 4.26 0.00 Miscl= Corr= 0.00 0.00 n= 4 Y 1000.00 Z 1000.00 COORDINATES of A= 1000.00 AZAP= a= AZAB= Angle A B C 0.00000 0.00000 0.00000 0.00000 Azimuth D From-To HD Latitude A-B 0.00 0.00 B-C 0.00 Departure 0.00 0.00 0.00 0.00 0.00 C-D 0.00 0.00 D-A 0.00 0.00 Sum= Check AzAB= 0.00 Misclosures Correction 0.00 0.00 0.00 0.00 Adj.Lat. Adj.Dep. From-To A-B B-C C-D D-A Check COORDINATES X Y B D Check To Sta HC VC SD HD VD At Sta hi 5.47 hr 4.26 B D 125.52640 215.52690 9.56870 -9.56870 356.47 348.56 B 6.34 4.26 A 210.58740 120.58730 -9.56870 -9.56870 356.47 348.56 C 5.47 4.26 B 10.68140 280.68120 -9.56870 -10.59000 348.56 356.47 D D 6.05 4.26 C 93.22110 3.22070 RawAngs 9.56870 9.56870 AdjAngs 356.47 348.66 A B D A Inside Angs B-D C-A D-B A-C Sum= 180*(n-2) misclosure Correction Corr. Check n= 4 0 seconds