Follow Excel for Land Surveyors

Excel for Land Surveyors is a Hub for sharing helpful spreadsheet tools and applications to be used in the surveying field.

If you are new to the Excel Support for Land Surveyors Group, please start by adding a discussion and introducing yourself to the community! Start a new discussion to share a spreadsheet with your fellow land surveyors!

 

Use this group to leverage the power of excel spreadsheets and formulas in your daily land surveying adventures.. To add information to this group, simply start a new discussion and give it a catchy title, tags and thick description. Or simply respond to a discussion already created.

660 EXCELlant Surveyors
👉️Join this Hub

Dear all,

One of our user Mr. Younis sends me the idea that you produce the spread sheet for the traverse by co-ordinates method. It was the good idea and I produce this sheet according to that.

I always well com good ideas from you gays. If somebody has any idea for any kind of spread sheet for surveying works I will appreciate.

Enjoy the attachment.

 

Download TraverseCloseLinkbycoordinatemethod.xls

 

Traversing is an essential task for surveyors. It involves measuring the distance and angles between a series of points on the ground to determine their positions relative to each other. The process of traversing is typically performed by using a combination of electronic instruments and manual calculations.

Traverse Link and Close

The Traverse @ Close & Link by co-ordinate method is a technique used by surveyors to calculate the position of a point relative to a series of other points. This method involves taking measurements of the distance and angles between a series of points and using these measurements to calculate the coordinates of each point.

To perform the Traverse @ Close & Link by co-ordinate method, the surveyor first selects a starting point and measures the distance and angle to the next point in the series. This process is repeated for each point in the series until the surveyor returns to the starting point. The surveyor must ensure that the measurements are taken accurately and that the points are properly identified and labeled.

Once the measurements have been taken, the surveyor can use the co-ordinate method to calculate the coordinates of each point. The co-ordinate method involves using a series of equations to solve for the x and y coordinates of each point based on the distance and angle measurements.

To perform the calculations, the surveyor typically uses a spreadsheet program. The spreadsheet program allows the surveyor to input the distance and angle measurements and automatically calculates the coordinates of each point. The program can also be used to store and organize the data for future reference.

The Traverse @ Close & Link by co-ordinate method is an efficient and accurate technique for surveying. It allows surveyors to quickly and accurately determine the positions of a series of points relative to each other. The use of a spreadsheet program simplifies the calculations and reduces the likelihood of errors.

In conclusion, the Traverse @ Close & Link by co-ordinate method is an important technique used by surveyors for determining the position of a series of points relative to each other. The use of a spreadsheet program simplifies the calculations and reduces the likelihood of errors, making it an efficient and accurate method of surveying.

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

Join Land Surveyors United - Surveying Education Community

Votes: 0
Email me when people reply –

Replies

  • Land Surveyor
    I need all of excel sheets related to survey. Please send it to my email [email protected] because i cannot find any attachment here.
  • Land Surveyor
    Where is the attachment?
  • Land Surveyor
    Please send me the attachment...Malik ji
  • This program is good although there is need to improve on it as well as include area computation.However i have had some problems with it especially when i prompt the program to compute, it redirects me to the vba dialogue box requesting for a password which i don't know and don't know how to get it. Please Mali advise me on how to go about this obstacle.thanks
    • Dear which version of excel you are using?

       

  • I FIND THIS PROGRAM GOOD .THANKS MALIK SAB.

  • Seeking Employment

    Thanks, Malik Abdur Rehman sab. you did a great job....


    •  I have disscused with Mr.Malik to add more Features to the same Routine but he is busy in these days I think he will do something new within while

      regards

       

  • Dear Sir ,

    I checked the example provided and it works well with Linked Traverse , but i tried  Closed traverse by Coordinate method , but i couldnot get the answer correctly so I want to get the EXAMPLE of Closed traverse from you plz. send me the Example in  <<<      [email protected]       >>>.

    • Try this data,

       

      Traverse Data Input:

      Start Station: Start Back sight:
      Point I'D 2 Point I'D 1
      Easting -637.696 682.8932 -889.677
      Northing 1161.886 Northing 525.134
      Elevation 0.000 Elevation 0.000
      End Station: End Foresight:
      Point I'D 6 Point I'D 7
      Easting -889.677 Easting -637.696
      Northing 525.134 Northing 1161.886 Scale Factor
      Elevation 0.000 Elevation 0.000 1.000000000
      Point I'D Easting Northing Elevation Remarks
      3 231.384 1161.886 0.000 new station
      4 617.070 591.890 0.000 new station
      5 -155.153 69.368 0.000 new station
      6 -889.677 525.134 0.000 Fixed
      7 -637.696 1161.886 0.000 Fixed
This reply was deleted.

Excel Spreadsheets for Land Surveyors

Land Surveying Related Spreadsheets shared by the Community

Spreadsheets for Surveyors Forum