Excel Spreadsheets for Surveyors

Community Hub Information

Excel Spreadsheets for Surveyors

This group is for discussions related to the use of spreadsheets and excel in land surveying.

Geolocation: The World
Members: 323
Latest Activity: on Monday

Excel For Land Surveyors

View my Flipboard Magazine.

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.

Surveyor Community Forum Discussions

Cross Section & Quantity by VBA

Started by Malik Abdur Rehman. Last reply by Malek Abu Safieh on Saturday. 23 Replies

Fellow SurveyorsFeel free to enjoy this video on Cross Section & Quantity by VBARead more →

Subject Tags: tutorial, video, VBA, Quantity, Cross Section

Road Profile

Started by Amjad Shahzad Rizvi. Last reply by Dharmesh Shah May 9. 4 Replies

Can somebody tell me how to create road profile in autocad  with using only existing levelsRead more →

Cross Section Program in Excel and AutoCad

Started by Sikander Singh. Last reply by Sikander Singh Apr 28. 4 Replies

Sir,I am a Surveyor From India Kindly Provide me Cross Section Program in Excel and AutoCad i shall be very thankful to you.Sikander Singhsikanderbtpl@gmail.comRead more →

Subject Tags: and, AutoCad, Excel, in, Section

For Road Strip chart

Started by Manoj Kumar Yadav. Last reply by fikadu tazeze Mar 6. 5 Replies

How to create road strip chart like shoe embankment layer and subgrade layer etc please helpe meRead more →

Subject Tags: Progress, chart, and, Chart, Strip

Leveling & Adjustment Spreadsheet

Started by Malik Abdur Rehman. Last reply by Rakesh Roshan Sahu Dec 12, 2016. 15 Replies

Dear all, Please find attached excel sheet for leveling and adjustment.If you have any question please feel free to contact me. Regards,MalikRead more →

Subject Tags: surveying, surveyors, spreadsheet, calculator, excel

Bearings Spreadsheet Tool for Surveyors

Started by Survenator. Last reply by Rakesh Roshan Sahu Dec 12, 2016. 2 Replies

Simple excel formula tool which calculates the Bearing between two points. Updated thanks to John Vossepoel.  Please find the attached spreadsheet at the bottom of post.Read more →

Subject Tags: calculations, surveying, spreadsheet, tool, excel

Spreadsheet Excel to Calculate center of circle from coordinates

Started by zainul ulum. Last reply by hafiz Dec 11, 2016. 2 Replies

CircleBestFitting.zipHi Forum,This calculates center and radius of…Read more →

Subject Tags: coordinates, Excel.surveying

Fly Levelling Calculation & Adjustment+(Convert Topcon & Leica,Raw Data )

Started by Malik Abdur Rehman. Last reply by Rakesh Roshan Sahu Nov 14, 2016. 2 Replies

Dear All,Find attached file for fly leveling calculation & adjustment.There are two more option in the sheet you can also convert the data of (topcon & leica digital) levels.Thanks,Malik,…Read more →

Subject Tags: excel, spreadsheet, calculation, Leveling

Traverse @ Close & Link by co-ordinate method

Started by Malik Abdur Rehman. Last reply by Rakesh Roshan Sahu Nov 14, 2016. 9 Replies

 Dear all, One of our user Mr. Younis sends me the idea that you produce the spread sheet for the traverse by co-ordinates method. It was the good idea and I produce this sheet according to that.I always well com good ideas from you gays. If…Read more →

Subject Tags: co-ordinate method, Link Traverse, Excel spread sheet',, Link, Close

Excel Sheet for Coordinate Transformation State Plane AZ E to Local Site ?

Started by Paul Quagge. Last reply by fikadu tazeze Sep 10, 2016. 2 Replies

Hello Fellow Scientists, I would like to create an Excel Spreadsheet that transforms US State Plane Coordinates Arizona East to our Local Sites Coordinate system which is at ground. I have all the parameters for both systems but need help getting…Read more →

Subject Tags: coordinates, state plane, surveying, excel

Surveying Videos on the network tagged 'excel'

Google Earth results to Excel


Land Survey Media Thumbnail

how to export Google Earth data to excel

Geocoding in Web GIS and Excel


Land Survey Media Thumbnail

Geocoding in Web GIS and Excel by using Google map api

Surveying Sheet In excel


Land Survey Media Thumbnail

Surveying Sheet In excel ? Urdu

Using ArcMap 10 to join Excel data with a shapefile


Land Survey Media Thumbnail

Using ArcMap 10 to join Excel data with a shapefile
This video uses the join method to add user created data from an Excel file to a shapefile of airport…

TIP: Using Maps with Microsoft Excel


Land Survey Media Thumbnail

Demonstrates how to easily enrich Microsoft Excel with mapping software provided by MSOR Solutions.

Join the Excel Group for Land Surveyors Here:…

Leave a Comment

Communicate ⇣

Comments Welcome Surveyor!   Please Sign in or register to continue.

Reply by Kyaw Naing Oo on May 10, 2012 at 5:03am

Hi Mr Malik,

  You have done the great job and thanks a lot for sharing road alignment calculation spread sheet. I am using this spreadsheet to calculate the Tunnel alignment  and  very useful for me. Thanks a lot.  

Kyaw

Reply by farouk bukwa mayeko on May 3, 2012 at 5:00am

Thank bwana Malik for your good work, am using one of your spreadsheets road alignment calculation v104 and following are the problems so far am facing.

1.V CURVES: When i change the first(custom) chainage, it still computes the pvc elevation. eg. my pvi chainage is 0+101, curve length 200m then i expect the pvc chainage to be 0+001 and if i want chainages of 10m the next chainage after pvc will be 0+010 of which i used as my custom but the elevation i got was for pvc station. the same problem with horizontal alignment. pliz bwana Malik help me for that.

Reply by Gary Breisch on April 29, 2012 at 11:43pm

---------------------

Update 20120429.1039P - just sent Paul a sample working spreadsheet to play with via regular email.   Perhaps we can improve it for ease and automation together or with others interested in making improvements and using.

Reply by Paul Quagge on April 29, 2012 at 8:53pm

Hello Mr Breisch,

 

 I have created my own spreadsheet...but it is not as efficient as it could be. You enter each bs and fs and a beginning elev. But it is a two step process to calculate hi and next elev. Once it is all entered you can edit it globally because it is all dependent.

 

I am familiar with formulas, I created a spreadsheet to take gps data from grid to ground within granted tolerances...but not familiar with if then statements in excel. I have taken fortran,basic etc... and familiar with if then statements.

ok I'll be aware of your concerns

 

Thank you for getting back to me.

 

Paul

Reply by Gary Breisch on April 29, 2012 at 5:20pm

---------------------

Update 20120429.1039P - just sent Paul a sample working spreadsheet to play with via regular email.   Perhaps we can improve it for ease and automation together or with others interested in making improvements and using.

--------------------------- previous below.....

Before I send anyone my spreadsheet that simulates a field book level loop complete with automatic calculations, I have questions and will need you to email me and let me know if you found or created what you needed.


Why not create your own spreadsheet to do what you want?

Have you tried?

Are you familiar with formulas and if statements?

Before I send my sheet, it is important to note that one should copy it to back it up because each time you use it, you will want to change the data and may want to arrange it while preserving the formulas so that it will calculate correctly.

Since you will have Point ID,  +, HI, -, Elevation, & description columns, you will need to be aware of when you do a turning point and make sure it is computing a new HI to be used till you go on to the next turning point.

I normally do not use this blog post system here but I just sent a message to a guy looking for such a spreadsheet.   I own the gbreisch.com domain.  You can visit my website at gbreisch.com for all my direct & current contact information if you want to email me about getting a copy or example of this spreadsheet I created years ago.

Reply by mashaka ally mwageni on April 29, 2012 at 4:40am

Arnel I didnt get you when you say plotting in autocad (automated). do you mean you export first the data or! please clarify it for me. thank you

Reply by Paul Quagge on April 28, 2012 at 7:22pm

Hello, I am working on a 4.25 mile road project. We are running levels through our control. Does anyone have an excel program for differential leveling? I've been dubbing around trying to create a program but its not going as good as it could.Your help would be appreciated,
Thanks, Paul Quagge

Reply by YASIN MALIK on February 26, 2012 at 3:03am
Reply by YASIN MALIK on February 26, 2012 at 3:02am
Reply by Dean Brian Teska Jr. on January 31, 2012 at 10:58am

I cannot live without this.  http://www.trimble.com/construction/heavy-and-highway/site-position...   Go to downloads, then SCS900 Utilities, the SCS900 Report Utility and download your appropriate version and language.  Can import text/csv files and shows the original raw data, what the rod height's were, what time/day the shots were taken.    ENJOY!

 
 
 

Where Thousands of Professional Land Surveyors, Students of Surveying and Educators are United through Collaborative Knowledge and Purpose.

Dedicated to the Memory of Skip Farrow (1953-2015)

+ Surveyor Sharer

Drag Button to bookmark bar and view submitted links here.Will soon be moved to a directory

AFGHANISTAN SURVEYORS ALBANIA SURVEYORS ALGERIA SURVEYORS AMERICAN SAMOA SURVEYORS ANDORRA SURVEYORS
ANGOLA SURVEYORS ANGUILLA SURVEYORS ANTIGUA & BARBUDA SURVEYORS ARGENTINA SURVEYORS ARMENIA SURVEYORS
ARUBA SURVEYORS AUSTRALIA SURVEYORS AUSTRIA SURVEYORS AZERBAIJAN SURVEYORS BAHAMAS SURVEYORS
BAHRAIN SURVEYORS BANGLADESH SURVEYORS BARBADOS SURVEYORS BELARUS SURVEYORS BELGIUM SURVEYORS
BELIZE SURVEYORS BENIN SURVEYORS BERMUDA SURVEYORS BHUTAN SURVEYORS BOLIVIA SURVEYORS
BOSNIA & HERZEGOWINA SURVEYORS BOTSWANA SURVEYORS BRAZIL SURVEYORS BRITISH INDIAN OCEAN TERRITORY SURVEYORS
BRUNEI DARUSSALAM SURVEYORS BULGARIA SURVEYORS BURKINA FASO SURVEYORS BURUNDI SURVEYORS CAMBODIA SURVEYORS
CAMEROON SURVEYORS CANADA SURVEYORS CAPE VERDE SURVEYORS CAYMAN ISLANDS SURVEYORS CENTRAL AFRICAN REPUBLIC SURVEYORS
CHAD SURVEYORS CHILE SURVEYORS CHINA SURVEYORS COLOMBIA SURVEYORS COMOROS SURVEYORS
CONGO SURVEYORS DEMOCRATIC REPUBLIC OF THE CONGO SURVEYORS COOK ISLANDS SURVEYORS COSTA RICA SURVEYORS COTE D'IVOIRE SURVEYORS
CROATIA SURVEYORS CUBA SURVEYORS CURACAO SURVEYORS CYPRUS SURVEYORS CZECH REPUBLIC SURVEYORS
DENMARK SURVEYORS DJIBOUTI SURVEYORS DOMINICA SURVEYORS DOMINICAN REPUBLIC SURVEYORS ECUADOR SURVEYORS
EGYPT SURVEYORS EL SALVADOR SURVEYORS EQUATORIAL GUINEA SURVEYORS ERITREA SURVEYORS ESTONIA SURVEYORS
ETHIOPIA SURVEYORS EUROPEAN UNION SURVEYORS FAROE ISLANDS SURVEYORS FIJI SURVEYORS FINLAND SURVEYORS
FRANCE SURVEYORS FRENCH GUIANA SURVEYORS FRENCH POLYNESIA SURVEYORS GABON SURVEYORS GAMBIA SURVEYORS
GEORGIA SURVEYORS GERMANY SURVEYORS GHANA SURVEYORS GIBRALTAR SURVEYORS GREECE SURVEYORS
GREENLAND SURVEYORS GRENADA SURVEYORS GUADELOUPE SURVEYORS GUAM SURVEYORS GUATEMALA SURVEYORS
GUERNSEY SURVEYORS GUINEA SURVEYORS GUINEA-BISSAU SURVEYORS GUYANA SURVEYORS HAITI SURVEYORS
HOLY SEE SURVEYORS HONDURAS SURVEYORS HONG KONG SURVEYORS HUNGARY SURVEYORS ICELAND SURVEYORS
INDIA SURVEYORS INDONESIA SURVEYORS IRAN SURVEYORS IRAQ SURVEYORS IRELAND SURVEYORS
ISLE OF MAN SURVEYORS ISRAEL SURVEYORS ITALY SURVEYORS JAMAICA SURVEYORS JAPAN SURVEYORS
JERSEY SURVEYORS JORDAN SURVEYORS KAZAKHSTAN SURVEYORS KENYA SURVEYORS KIRIBATI SURVEYORS
KOREA SURVEYORS KOREA REPUBLIC OF SURVEYORS KUWAIT SURVEYORS KYRGYZSTAN SURVEYORS LAO PEOPLE'S DEMOCRATIC REPUBLIC SURVEYORS
LATVIA SURVEYORS LEBANON SURVEYORS LESOTHO SURVEYORS LIBERIA SURVEYORS LIBYAN ARAB JAMAHIRIYA SURVEYORS
LIECHTENSTEIN SURVEYORS LITHUANIA SURVEYORS LUXEMBOURG SURVEYORS MACAU SURVEYORS MACEDONIA SURVEYORS
MADAGASCAR SURVEYORS MALAWI SURVEYORS MALAYSIA SURVEYORS MALDIVES SURVEYORS MALI SURVEYORS
MALTA SURVEYORS MARSHALL ISLANDS SURVEYORS MARTINIQUE SURVEYORS MAURITANIA SURVEYORS MAURITIUS SURVEYORS
MAYOTTE SURVEYORS MEXICO SURVEYORS MICRONESIA SURVEYORS MOLDOVA SURVEYORS MONACO SURVEYORS
MONGOLIA SURVEYORS MONTENEGRO SURVEYORS MONTSERRAT SURVEYORS MOROCCO SURVEYORS MOZAMBIQUE SURVEYORS
MYANMAR SURVEYORS NAMIBIA SURVEYORS NAURU SURVEYORS NEPAL SURVEYORS NETHERLANDS SURVEYORS
NEW CALEDONIA SURVEYORS NEW ZEALAND SURVEYORS NICARAGUA SURVEYORS NIGER SURVEYORS NIGERIA SURVEYORS
NIUE SURVEYORS NON-SPEC ASIA PAS LOCATION SURVEYORS NORFOLK ISLAND SURVEYORS NORTHERN MARIANA ISLANDS SURVEYORS NORWAY SURVEYORS
OMAN SURVEYORS PAKISTAN SURVEYORS PALAU SURVEYORS PALESTINIAN TERRITORY OCCUPIED SURVEYORS PANAMA SURVEYORS
PAPUA NEW GUINEA SURVEYORS PARAGUAY SURVEYORS PERU SURVEYORS PHILIPPINES SURVEYORS POLAND SURVEYORS
PORTUGAL SURVEYORS PUERTO RICO SURVEYORS QATAR SURVEYORS RESERVED SURVEYORS REUNION SURVEYORS
ROMANIA SURVEYORS RUSSIAN FEDERATION SURVEYORS RWANDA SURVEYORS SAINT KITTS & NEVIS SURVEYORS SAINT LUCIA SURVEYORS
SAINT MARTIN SURVEYORS SAINT VINCENT & THE GRENADINES SURVEYORS SAMOA SURVEYORS SAN MARINO SURVEYORS SAO TOME & PRINCIPE SURVEYORS
SAUDI ARABIA SURVEYORS SENEGAL SURVEYORS SERBIA SURVEYORS SEYCHELLES SURVEYORS SIERRA LEONE SURVEYORS
SINGAPORE SURVEYORS SINT MAARTEN SURVEYORS SLOVAKIA (SLOVAK REPUBLIC) SURVEYORS SLOVENIA SURVEYORS SOLOMON ISLANDS SURVEYORS
SOMALIA SURVEYORS SOUTH AFRICA SURVEYORS SOUTH SUDAN SURVEYORS SPAIN SURVEYORS SRI LANKA SURVEYORS
ST. PIERRE AND MIQUELON SURVEYORS SUDAN SURVEYORS SURINAME SURVEYORS SWAZILAND SURVEYORS SWEDEN SURVEYORS
SWITZERLAND SURVEYORS SYRIAN ARAB REPUBLIC SURVEYORS TAIWAN; REPUBLIC OF CHINA (ROC) SURVEYORS TAJIKISTAN SURVEYORS TANZANIA UNITED REPUBLIC OF SURVEYORS
THAILAND SURVEYORS TIMOR-LESTE SURVEYORS TOGO SURVEYORS TOKELAU SURVEYORS TONGA SURVEYORS
TRINIDAD AND TOBAGO SURVEYORS TUNISIA SURVEYORS TURKEY SURVEYORS TURKMENISTAN SURVEYORS TURKS AND CAICOS ISLANDS SURVEYORS
TUVALU SURVEYORS UGANDA SURVEYORS UKRAINE SURVEYORS UNITED ARAB EMIRATES SURVEYORS UNITED KINGDOM SURVEYORS
UNITED STATES SURVEYORS URUGUAY SURVEYORS UZBEKISTAN SURVEYORS VANUATU SURVEYORS VENEZUELA SURVEYORS
VIET NAM SURVEYORS VIRGIN ISLANDS (BRITISH) SURVEYORS VIRGIN ISLANDS (U.S.) SURVEYORS WALLIS AND FUTUNA ISLANDS SURVEYORS YEMEN SURVEYORS
ZAMBIA SURVEYORS ZIMBABWE SURVEYORS SURVEYORS

Location Based Surveying Practices

Land Surveyors United is the world's FIRST Global Social Network for geospatial professionals. We have dedicated, geolocated support groups for practically every country, continent and state on earth, for you to utilize for building your personal network. We are all essentially concerned with the same issues, no matter where we are located on earth. However, surveying practices and methods vary depending on the geographic location where we work. If you have noticed similarities and differences between the conditions, laws and practices between two or more areas of the world,discuss it in this forum. Build your reputation online by posting relevant discussions in your local group below.

Join and Introduce Yourself in Your Local Geosocial Forum:

Alabama Alaska Arizona Arkansas California
Colorado Connecticut Delaware Florida Georgia
Hawaii Idaho Illinois Indiana Iowa
Kansas Kentucky Louisiana Maine Maryland
Massachusetts Michigan Minnesota Mississippi Missouri
Montana Nebraska Nevada New Hampshire New Jersey
New Mexico New York North Carolina North Dakota Ohio
Oklahoma Oregon Pennsylvania Rhode Island South Carolina
South Dakota Tennessee Texas Utah Vermont
Virginia Washington West Virginia Wisconsin Wyoming

Not based in the US? Here are other groups for surveyors around the world to join and contribute knowledge and experiences as a land surveyor:

Africa Asia Australia Europe Russia Canada
Antarctica S.America N. America India Malaysia Caribbean

And more... Find your group forum based on location.

Choose Your Equipment Group Here

Handheld US Social Support for Land SurveyorsNIKON Social Support for Land SurveyorsTrimble Social Support for Land SurveyorsTopcon Social Support for Land SurveyorsSokkia Social Support for Land SurveyorsAshtech Social Support for Land SurveyorsNAVCOM Social Support for Land SurveyorsMagellan Social Support for Land SurveyorsLeica Social Support for Land SurveyorsAltus Positioning Social Support for Land SurveyorsMicroSurvey Social Support for Land SurveyorsJuniper Systems Social Support for Land SurveyorsTraverse PC Social Support for Land SurveyorsCarlson Software Social Support for Land Surveyors

what where  
job title, keywords or company
city, state or zip jobs by job search

PLEASE DONATE TODAY. Your generosity preserves surveying and mapping knowledge for future generations. Thank you.

Survey Equipment Troubles?

Geo Visitors Map

Choose Your Group Here

Surveying Equipment Support for Leica, Carlson, Sokkia, Trimble, Topcon, Altus, Nikon equipment


© 2017   © Created by Land Surveyors United   Powered by

Badges  |  Contact LSU  |  Privacy Policy  |  Terms of Service

Live Support