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.
Replies
Hello Zainul,
Thanks for posting these...are you also planning on Lambert Conical?
Paul
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
thanks
-zainul-
Hello Zainul,
Your welcome, I'm glad that they helped. Thanks for creating the spread sheets, they're awesome. Have a good new year!
Paul
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...
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!