### How to Perform Traverse Correction in EXCEL /Transit Rule/Bowditch Rule- Closed Traverse

Survey Legend
Views: 289

Traverse correction is a process used by land surveyors to adjust measurements taken during a traverse, which is a series of connected surveying lines or sides. The correction process ensures that the final traverse is accurate and meets the required standards.

There are different methods for traverse correction, including the Transit Rule and the Bowditch Rule. These methods can be implemented in a spreadsheet program like Microsoft Excel to perform the calculations efficiently.

To understand the process of traverse correction in Excel, let's focus on a closed traverse, which is a looped traverse where the starting and ending points are the same. The steps involved are as follows:

1. Data Entry: Enter the survey data into an Excel spreadsheet. The data typically includes the observed angles, the measured distances, and the coordinates of the traverse stations.

2. Calculation of Adjusted Angles: Calculate the adjusted angles by summing the observed angles and applying the appropriate correction. In the case of a closed traverse, the sum of the observed angles should be equal to the sum of the interior angles of a polygon, which is (n-2) * 180 degrees for an n-sided polygon.

a. Apply the Transit Rule: According to the Transit Rule, the correction for each angle is calculated as the difference between the sum of observed angles and the sum of interior angles divided by the number of angles. This correction is added to or subtracted from each observed angle.

b. Apply the Bowditch Rule: The Bowditch Rule involves calculating a correction factor (CF) for each angle. The CF for an angle is calculated as the difference between the sum of observed angles and the sum of interior angles divided by the sum of the measured distances. The correction for each angle is then obtained by multiplying the CF by the measured distance for that angle.

3. Calculation of Adjusted Distances: Calculate the adjusted distances by applying the appropriate corrections to the measured distances. There are different methods for distance corrections, such as the Compass Rule, Transit Rule, and Crandall's Rule, but for simplicity, we will assume the measured distances are already adjusted.

4. Calculation of Coordinate Corrections: Calculate the coordinate corrections for each traverse station by multiplying the adjusted distances by the cosine and sine of the adjusted angles, respectively.

5. Calculation of Final Coordinates: Calculate the final coordinates of each traverse station by summing the initial coordinates with the coordinate corrections.

6. Closure Check: Perform a closure check by comparing the final coordinates of the starting and ending points. If they are not the same or within an acceptable tolerance, further adjustments may be required.

By following these steps and implementing the necessary formulas in Excel, land surveyors can efficiently perform traverse correction for closed traverses using the Transit Rule or the Bowditch Rule.

You need to be a member of Land Surveyors United - Global Surveying Community to add thoughts!

### Our Collection for Learning Surveying

Check out this Special Collection of Videos

Sharing your videos and those surveying videos you think will be helpful to other members of the community is incredibly simple.

Upload your Video to the community and describe the video and why you think it is useful to the community.  Use the Rich Text description area to link to more resources.

Embed a video that you found elsewhere from Youtube, Vimeo, etc.

### Add Survey Videos to Hubs

Did you know that Hubs have videos too?  If you would like a more targeted audience for your videos, you can share your videos inside hubs based on any surveying topic, type of equipment or location.

### Discover Videos by Type

Find Surveying Videos By Subject Tag
Representing Land Surveyors in 190 Countries
and all 50 US States. Contribute to your local
chapter and promote Land Surveying globally.

Surveyor Hubs

We have members in every region of the planet. Add
your local Land Surveyor events to the calendar and turn
them into Land Surveyors United Meetups worldwide.

Surveyor Events

Inspire the next generation by contributing
your expertise and experience in Land Surveying
to our 20k+ Surveyor Hive Mind. Mentor the Green!

Mentorship