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.

483 EXCELlant Surveyors
👉️Follow Hub to Contribute

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 - Surveying Community & Forums to add thoughts!

Join Land Surveyors United - Surveying Community & Forums

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.

Recent Excel Posts

Personal Introduction

Hello everyone, I'm an merican citizen and surveyour living and working in Europe. I came across this community in a search for knowldge and help for my professional challenges, it seems fine so far, so I hope i'll be able to contribute in any way i can. Regards, C. Correia

Read more…
1 Reply · Reply by Justin Farrow Jul 23