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

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.

How to close traverse in land surveying

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.

Votes: 0
E-mail me when people leave their comments –

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

Join Land Surveyors United - Global Surveying Community

Share your Surveyor Articles

Surveying Articles is a place for members to Share Land Surveying related articles, presentations and knowledge with the Land Surveyors United Community. Post or embed articles for future generations of land surveyors.

Surveying Articles and Presentations

Do you have an article about Land Surveying that you would like to share?

Land Surveying is a timeless art and science and it is therefore, evergreen! You may also know that a lot of older publications have gone away, unfortunately.   If you have written or published land surveying articles in the past, we would be honored for you to share them here with us.  If it is an older article, you can even republish it here with updates and reflections.  

class="block"Tip:   If you published an article in the past on one of the older sites which no longer exist, you can use the Wayback Machine to find it.  Then just copy/paste the old article inside a new post here.  Just be sure to tell us where it was previously posted.

Want to embed a PDF Document?

 If you have a PDF document or article related to land surveying that you would like to embed inside an article post, simply copy/paste the following code block into the HTML view of the post editor and replace the BOLD part of the code with the URL of the PDF you'd like to embed.   

Code to use:

<iframe src="https://docs.google.com/viewer?url=https://landsurveyorsunited.github.io/cssfiles/manuals/Surveying-Photos-Submitted-Land-Surveyors-United.pdf&embedded=true" frameborder="0" height="500px" width="100%"></iframe>

TIP:  You can also upload your PDF using the file upload button and then copy/paste the URL of the document you uploaded with the BOLD part of the code above to get a flippable PDF like so:

Uploading PDF land surveying documents to Surveying Articles

Differences between Forums, Blogs and Article posts

Forum Posts are great for asking questions which have a definate answer.  Forum posts are best for a quick exchange of information between Land Surveyors United members.   Please note that All Community Hubs have their own dedicated Forums so if your post is related to a specific hub, it is best to ask your question or share your tip inside the hub in which it belongs for targeted answers.  For example, if your question relates to Leica equipment, ask your question inside the Leica Hub forum for best results as all members inside that hub uses the equipment in question.  Likewise if your question pertains to a Location, you should consider making your post inside the appropriate hub.

Add Discussion

Blog Postsdiffer from Forum posts because you can embed and upload different kinds of information.  Blog posts are best for presenting information and updates for feedback and sharing.  When posting a Blog Post, you can also publish a short excerpt at the bottom which is what most members will see before reading the blog post.  Blog posts are also great for posting new surveying projects and digests of links to multiple surveying topics or your own website.   Things that can be embedded into Blog Posts are videos, images, slideshows, powerpoints, spreadsheets, PDFs, documents and more.

Add Blog Post

 

Articles are similar to Blog Posts in all ways except one.  Articles allow for you to post an Author Block at the bottom with links to your contact info, website information, credentials, etc. Similar to Blog Posts, things that can be embedded into Blog Posts are videos, images, slideshows, powerpoints, spreadsheets, PDFs, documents and more.  Similar to both types above, Hub Owners can add article sections and features to any hub they control on the community.

Add Article

Land Survey Guides