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.

658 EXCELlant Surveyors
👉️Join this Hub

Excel Spreadsheet to calculate Distance and Azimuth on Ellipsoid Sphere

Posted by zainul ulum on November 23, 2012 at 7:34pm

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-

Views: 492

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 –
Follow

Replies

  • zainul ulum November 26, 2012 at 7:58pm

    oops!

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

     

  • Paul Quagge November 26, 2012 at 4:01pm

    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.

Excel Spreadsheets for Land Surveyors

Land Surveying Related Spreadsheets shared by the Community

Spreadsheets for Surveyors Forum

  • Recent Excel Posts
  • Featured Surveyor Spreadsheets