CIVL 1112 - Assignment #11
"What lies behind us and what lies before us are tiny matters compared to what lies within us." - Ralph Waldo Emerson
Objective
The purpose of this assignment is twofold: (1) compute the bearings of a traverse based on survey data and a reference bearing; and (2) develop a spreadsheet to compute the area of traverse and the x and y coordinates of the points on a traverse.
Part 1: A five-sided closed field traverse has the following distances in feet: AB = 285.13', BC = 610.24', CD = 720.35', DE = 203.03', and EA = 647.25'. The interior angles are as follows (measured as angles to the right): A = 100º 45' 37", B = 101º 34' 24", C = 89º 03' 28", D = 17º 12' 59", and E = 231º 23' 43". The bearing of AB is N 26º 09' 40" E. Determine the bearings of each side and then use your traverse spreadsheet to compute the corrected and balanced latitudes and departures for the traverse. Show all work for determining the bearing of each side.
Part 2: This workbook should supplement your work from Assignment 10 to include the double meridian distance (DMA), the double area, and the x and y coordinate calculations. Your traverse workbook will be used in your design for the detention pond project. The workbook should compute latitudes and departures from given bearings and distances, DMD's, and the area of the closed, balanced traverse. The figure below shows a typical spreadsheet layout for this problem. Your spreadsheet may look different as long as it provides the same input and parameter definitions. Note that the directions N/S and E/W are in separate cells. Also, the values for degrees and minutes are in separate cells.
Make a copy of the previous spreadsheet and compute the x and y coordinates of the points in your traverse for given values of point A and plot of traverse area. The figure below shows a typical spreadsheet layout for this problem. Your spreadsheet may look different as long as it provides for the same input and parameter definitions.
Use your traverse spreadsheet to compute the latitude and departures, balance the latitudes and departures with the compass rule, compute the area using DMD, compute the x and y coordinates, assuming point A is (3,000, 3,000), and plot the traverse area for the traverse shown below.
