"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.
You
must hand in the cover
sheet the assignment your work for Part 1 and printouts of your spreadsheet
for Part 2. Also, submit your
Excel file
for Part 2 to Canvas.
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 to determe the
bearing of each side (follow the homework format).

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.

Cover sheet for homework
This website was originally
developed by
Charles Camp for
CIVL
1112.
This site is maintained by the
Department of Civil Engineering
at the University of Memphis.
Your comments and questions are welcomed.
|