Show us why the public should always call a land surveyor

Where are you surveying?

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.

653 EXCELlant Surveyors
👉️Join this Hub

Excel Spreadsheets for Land Surveyors

Land Surveying Related Spreadsheets shared by the Community

Hi Forum,

I wrote a spreadsheet to calculate distance and azimuth on ellipsoid sphere using T Vincenty formula. Input coordinates of two locations in lat-lang then the distance and its azimuth will be calculated accordingly.

I applied "Name Manager" to wrote The vincenty formula instead of vba-excel.

Since the formula deals with iterative calculation, please set your excel to "enable iterative calculation". If you miss this setting, excel will notify you an error 'circular reference'

as usual, i also post in my blog in 'bahasa indonesia'

warm regards from indonesia

-zainul-

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

Join Land Surveyors United - Global Surveying Community

Votes: 0
Email me when people reply –

Replies

  • oops!

    i missed the attachment while posting. please find the file as attached.

     

  • Hello zainul,

     

    I'm interested in your spread sheet. Is it posted?

     

    I'm also working on a spread sheet that calculates Grid Azimuth for Lambert Conical Projection and Transverse Mercator. Your input would be appreciated.

     

    Thanks, Paul

This reply was deleted.