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: 208
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.

Latest Discussions By Category ▿

master survey programs spreadsheet

Started by aamir shahzad. Last reply by aftab ahmad on Friday. 13 Replies

Enjoy this spreadsheet of useful Master Survey Programs download the attachment below…Read more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: xls, excel, spreadsheet, CAD, Autocad

Horizontal Curve Calculator in Excel

Started by Surveying Jobber. Last reply by LSU Justin Mar 23. 1 Reply

Attached is a Horizontal Curve Calculator which i found from the State of Michigan Department of Transportation.  which may come in handy in your surveying adventuresRead more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: surveying, transportation, Michigan, calculator, horizontal

Project Estimate Spreadsheet Download

Started by SurveyEarthinaDay. Last reply by LSU Justin Mar 22. 3 Replies

Download Project Estimate Spreadsheet for Free. It has two-page template in excel format fully formula ready. Calculate both cost profit for labor and material items that used. This is an Excel estimating template where you…Read more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: download, excel, resources, contractor, spreadsheet

Surveyor's Formula Calculator Tool in Excel

Started by Surveying Jobber. Last reply by SurveyEarthinaDay Mar 17. 1 Reply

Greetings Surveyors,Attached is a handy excel tool for managing surveyor calculations.  Enjoy!Read more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: xls, excel, calculations, tool

Excel spreadsheet to calculate Deed and export to Autocad

Started by William J Barrows Jr. Last reply by LSU Justin Jan 26. 8 Replies

I wrote a spreadsheet to enter metes and bounds from a deed. Spreadsheet calculates coordinates, plots the deed on a chart in the spreadsheet. Option to output a script file that can be input into Autocad. Creates layer(s) for Polyline, Labels, Line…Read more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: autocad, deed, spreadsheet

Adjustment of Survey Measurements with Solver Add-ins

Started by zainul ulum. Last reply by Ramona Kiss Jan 24. 2 Replies

Excel Survey Forum,I've developed "solver model" to adjust survey measurement using least square method. the model covers …Read more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: spreadsheet, excel, level, levelling, traverse

For Road Strip chart

Started by Manoj Kumar Yadav Jan 24. 0 Replies

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

Find Similar Content by Clicking These Tags ☟
Subject Tags: Progress, chart, and, Chart, Strip

cut and fill calculation on cross section chart with vba excel

Started by zainul ulum. Last reply by Mohammad Aamir Jan 23. 16 Replies

Hi Forum,my name is zainul land surveyor from indonesiathis is my first post in this forum and first share my spreadsheet as welli made user define functions (udf) saved in excel addins (*.xla) to calculate cut and fill area.Attached file is zipped…Read more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: spreadsheet, XLS, excel, surveying, volume

STAR NET PROCESSING

Started by Durai Kannan. Last reply by kenneth foong Jan 16. 3 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 →

Radial Easting Northing

Started by Malik Abdur Rehman. Last reply by RAJA M.HALEEM MINHAS Nov 28, 2014. 2 Replies

Dear all,Find attached programme hope it works like privies programmes.RegardsMalikRead more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: download, spreadsheets, excel

Surveying Videos on the network tagged 'excel'

Loading… Loading feed

Leave a Comment

Say Something ⇣

Comments Welcome!   Sign in or register.

Reply by Abdul Ghaffar on August 2, 2014 at 5:27am
Reply by Usman Ahmad on January 18, 2014 at 10:56am

i want cross section vba program for thesis work please help me 

my email id : usmanahmadis@gmail.com

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.

 
 
 

Global Trade organization for Professional Land Surveyors and Geospatial Pros. Frictionless GeoCollaboration Surveying Forum and Groups

Surveyor Hubs and Tags

Try Out the New Search Here:

Surveyor Community Hubs For World Regions

Surveying Hubs For US States

Social Support For Equipment

Surveying Photos by Tag

Surveying Videos by Tag


Share on Tumblr
+ Surveyor Sharer

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

What You Missed

mobeen bilal ahmad posted a status
"TOPOGRAPHICAL SURVEY FOR ROAD"
1 hour ago
mobeen bilal ahmad commented on LSU Justin's video
1 hour ago
Barry Coughlin promoted Barry Coughlin's photo
6 hours ago
Severino S. Monteiro commented on LSU Justin's group Unemployed Surveyors
"Unemployed and looking... "
7 hours ago
Severino S. Monteiro joined LSU Justin's group
Land Survey Media Thumbnail

Unemployed Surveyors

If you are a currently unemployed surveyor who would like tips or recently employed surveyor with…See More
8 hours ago
Roger Morales Barba Jr. replied to Barry Graham's discussion Free COGO Software - Evaluation and Feedback
"Good day sir, You've said that "Bearings are whole-circle, clockwise from north"…"
9 hours ago
pasha posted a discussion

traverse

dear all,gud day to alll,im new to survey,please explain me what is traverse?when we need to do…See More
11 hours ago
mauricio palacios commented on Eddy Vargas's photo
Land Survey Media Thumbnail

trimble 3605 DR

"cuales son los pines utilizados para la bateria externa???"
12 hours ago
Severino S. Monteiro promoted Arie Lise, OLS, OLIP, Dipl.T.'s discussion Senior CAD Operator-Calculator Position Available in Guelph, Ontario
12 hours ago
Regis Kapuyah updated their profile
18 hours ago
Michael Papenhagen posted a surveying story
19 hours ago
Profile IconJafar Majeed, Marcin Stepien, Michael Papenhagen and 10 more joined Land Surveyors United ::
19 hours ago
LSU Justin replied to ePalmetto's discussion Sokkia SX Series Total Station Manual in the group Sokkia Support Group
"Nice one"
yesterday
Deward Karl Bowles commented on ePalmetto's blog post International Surveyors Week 2015
"Fabulous."
yesterday
LSU Justin commented on ePalmetto's blog post International Surveyors Week 2015
"Nice post dad"
yesterday
LSU Justin promoted ePalmetto's blog post International Surveyors Week 2015
yesterday
LSU Justin promoted Patrick Leigh's discussion A little about me
yesterday
LSU Justin replied to Patrick Leigh's discussion A little about me
"Welcome to the club Patrick... you might like to upload that photo as your profile image so that…"
yesterday
LSU Justin promoted Lalith Senanayake's discussion Is Surveying a daylight profession?
yesterday
Adam Piasecki promoted ePalmetto's group Professional Land Surveyors Europe
yesterday

Take This Page With You

follow us in feedly

Take this Page With You

QR Code for This Page: What is this?

Surveyor Support

Get Started Guide

Network Feedback

Send Us a Tip

Questions Comments

Help Keep Us Free



© 2015   © Created by Land Surveyors United

Badges  |  Contact LSU  |  Privacy Policy  |  Terms of Service

Related Posts for Land Surveyors UnitedRelated Posts Plugin for Land Surveyors United Network ForumRelated Surveying Photos Land Surveyors United Live Support