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

LSU forum,

I'm developing spreadsheet to calculate geographical coordinates (latitude, longitude) to  grid coordinates (East, North) and vice versa complete with  Grid Convergence and Point Scale) using  RedFearns Formula on single zone .

If you found some misscalucaltion, errors or bugs, please share with us for further development.

for the member who understand bahasa indonesia, please visit my web on

for detail instuction.



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 –


  • Hello Zainul,

    Thanks for posting these...are you also planning on Lambert Conical?


    • Hello Paul,

      Yes, I've planned and still seeking a good reference specially for formula. Thanks for files that you uploaded on Lat/Long to Coordinates conversion & vice versa.

      I will develop on Lambert Conical on it



    • Hello Zainul,


      Your welcome, I'm glad that they helped. Thanks for creating the spread sheets, they're awesome. Have a good new year!



  • thanks for advice & recommended link Justin.
    I donwloaded the spreadsheet from link you provided. This spreadshet applies visual basic application for calculation. My intention is to develop the same calculation without using visual basic application, hopefully i can do it.....

    once again thanks for your valuable input...
  • GEO Ambassador

    Here are a couple of places where you might find your answer

    Convert Between Geographic and UTM Coordinates

    If you calculate coordinates across normal zone boundaries, alert messages may appear warning you that the results may be unreliable. Unless you specifically intend to carry grids across zone boundaries, you should consider these error messages and correct your input.

    Spreadsheets help and examples

    From this page you can download a Microsoft® Excel 2002 spreadsheet which will carry out common calculations with coordinates. All of the concepts and formulae given in A guide to coordinate systems in Great Britain, which is the user manual for these calculations, are detailed in the spreadsheet. The guide gives some important warnings about the use of its formulae, which you should be aware of. There are also other projection functions such as scale factors, convergence and t-T in the spreadsheet that are not in the guide.

    Hopefully someone else will come along and give more advice..good luck!

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.