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.

592 EXCELlant Surveyors
👉️Join this Hub

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.

Hey there!
It looks like you are enjoying the community content.

That's nice! Please don't forget to mention us if you use what you just copied on your website. Help strenthen the community by linking back to us!


Thank you very much! Have a nice day! :)

Ok. Don't bother me again, for this session.