surveying Excel

User Generated

Zngrq

Business Finance

Description

do both of them in EXCEL

Unformatted Attachment Preview

TT T Insert Table Chart Text Shape Media Comment Do both of them in excel HW1 I For the following traverse data: • Calculate the departures and latitudes Calculate departure and latitude misclosures • Calculate relative precision and relative precision Calculate the adjusted departures and latitudes • Calculate the adjusted X and Y coordinates if you know A(8000.000,5000.000) Course Azimuth Length AB 79.8651012 238.91 BC 351.7840242 205.09 CD 252.8974026 259.23 DE 193.7602941 101.87 EA 136.8943810 96.74 (All values are in meters and degrees) MacBook Air HW2 For the following traverse data: • Calculate the departures and latitudes Calculate the Azimuths and lengths • Calculate the bearings Course XY A 12765.567 43280.543 B 13696.456 43755.654 C 14354.345 42993.765 D 15110.234 43476.876 E 14797.123 44384.987 (All values are in meters and degrees)
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Station
A
AB
B
BC
C
CD
D
DE
E
EA
Perimeter

Length (m)

Azimuth= X

Cos (X)

Sin (X)

79.8651012

238.91

-0.516383874

-0.856357224

351.7840242

205.09

-0.905642822

-0.424041365

252.8974026

259.23

-0.186866965

-0.982385229

193.7602941

101.87

-0.205691811

0.978616819

136.894381

96.74

-0.117364073

0.993088956

1015.201203

Misclosure

Correction of Latitude = [Total Latitude Misclosure/Total Perimeter] x Length
Correction of Departure = [Total Departure Misclosure/Transverse Perimeter] x Length

Calculating the X and Y Coordinates

is as follows:

YB = YA + Latitude AB
XB = XA + Departure AB

Relative precision is a ratio of linear misclosure and divided by the tranverse perimeter expressed in the reciprocal form:
Calculated as: [(-463.0112848)^2 +(-140.4413264)^2]^1/2
(234102.86)^1/2 = 483.841772
hence precision is 1/483.841772 = 0.00206679137

Latitude = dcos(X)

in the reciprocal form:

Departure = dsin(X)

-41.24105036

-68.39305636

-318.5906764

-149.1709778

-47.25817008

-248.4426728

-39.85490579

189.6170827

-16.06...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags