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: 377
Latest Activity: on Friday

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 Chris Ninyio Emmanuel Apr 16. 26 Replies

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

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

Traverse Calculation excel sheet download

Started by Soumen Samanta Mar 14. 0 Replies

I have shared an excel spreadsheet for Traverse Corrections and Traverse Calculations by Compass Rule or Bowditch Rule.Also I have described about Traversing:what are the types of Traverse (closed traverse, Open Traverse), Traverse calculations and…Read more →

Subject Tags: excel, spradshet, download, surveying, Correction

STAR NET PROCESSING

Started by Durai Kannan. Last reply by MUHAMMAD USMAN Jan 21. 7 Replies

Hi every one.. now I am using leica TS15A instrument. So I can download GSI files. So this GSI data files how to use with starnet processing?Read more →

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

Started by Malik Abdur Rehman. Last reply by Olayinka Raji Jan 18. 3 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

Leveling & Adjustment Spreadsheet

Started by Malik Abdur Rehman. Last reply by Olayinka Raji Jan 18. 20 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

LEVELING RISE AND FALL METHOD

Started by abdu aziz abdu rahman Jan 15. 0 Replies

HI dear friends this is my first work that i have uploaded and its a spreadsheet of  leveling  using RISE and FALL method enjoyRead more →

Subject Tags: LEVELING

Bearing and Distance Calculation from Easting, Northing (Download Link Inside)

Started by Soumen Samanta. Last reply by Soumen Samanta Nov 14, 2017. 1 Reply

With this excel file you can calculate Distance and Bearing easily, just you have to input the Easting and Northing values only.Download Link :…Read more →

Traverse @ Close & Link by co-ordinate method

Started by Malik Abdur Rehman. Last reply by Naveed Abbas Oct 12, 2017. 11 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

EDM Distance Reductions

Started by Christopher James Drayton. Last reply by Javier A bañados Sep 7, 2017. 1 Reply

Attached below is  an old spreadsheet I created many years ago to reduce long line…Read more →

Subject Tags: Spreadsheet, Excel, Distance, EDM

Format for billing Highway

Started by Manoj Kumar Yadav Sep 3, 2017. 0 Replies

I've attached a file, I need a format that does not contain duplicate entries. As if I had passed from 450 kms to 460 kms, then no entry between 450 and 460 would be possible.ThanksManojRead more →

Surveying Videos on the network tagged 'excel'

How to Calculate coordinates from distance and bearing where we have coordinate of a known point


Land Survey Media Thumbnail

Download this excel file here: https://goo.gl/NBGrxX (Link Shorten with Google URL Shortener) In this video I have shown how to calculate coordinates of…

Traverse Surveying : Traverse Calculation: How to Close a Traverse


Land Survey Media Thumbnail

Surveying Traverse: How to Close a Traverse: Traverse Calculation/ how to solve a traverse,
in this video you have Learn how to Do Traverse Calculations or How to close a traverse
i use here Compass (Bowditch) Rule to Solve Close…

Topography from Google Earth


Land Survey Media Thumbnail

Grab accurate topography data from Google Earth via Sketchup, and convert to NURBS geometry in Rhino.

Importing Survey Data


Land Survey Media Thumbnail

This video demonstrates how to import survey data into the program AutoCAD Civil 3D.

Engineer It is a video series created primarily to supplement engineering classes at CSU Chico, but also to expose non-engineers to these same concepts in an understandable way. For more information please visit the official website at…

Leave a Comment

Communicate ⇣

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

Reply by YASIN MALIK on October 6, 2012 at 3:38am

Mr malik,

 NICE GREAT WORK U HAVE DONE.

Reply by akhtar nawaz on September 6, 2012 at 3:47pm
Reply by Muhammad Zeeshan on September 1, 2012 at 3:49pm

it is awesome.U really done a good job.it is very helpfull to all who belongs to survey field.

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

 
 
 

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

Tools,Apps and Quick Guides

BMC logoSupport Us! +LandSurveyorsUnitedon Google+

Next Generation Land Surveyor Community Where Every Day is a Surveying Conference

© 2018   © Created by Land Surveyors United   Powered by

Badges  |  Contact LSU  |  Privacy Policy  |  Terms of Service