This group is for discussions related to the use of spreadsheets and excel in land surveying.
Geolocation: The World
Members: 127
Latest Activity: yesterday
Pass This On Tweet This
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.
Started by zainul ulum. Last reply by Stephen Donaldson yesterday. 5 Replies 2 Promotions
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: fill, volume, cut, section, cross
Started by Malik Abdur Rehman. Last reply by junaidiqbal on Sunday. 9 Replies 1 Promotion
Fellow SurveyorsFeel free to enjoy this video on Cross Section & Quantity by VBARead more →
Find Similar Content by Clicking These Tags ☟
Subject Tags: tutorial, video, VBA, Quantity, Cross Section
Started by Malik Abdur Rehman. Last reply by Nagendra Bahadur Katwal Mar 26. 22 Replies 7 Promotions
Dear All, Like a previos attachments i hope this attachment will be also very useful for you.Road Horizontal and vertical alignment calculationThanks, Malik Abdur RehmanRead more →
Find Similar Content by Clicking These Tags ☟
Subject Tags: calculation, spreadsheet, vertical, horizontal, road
Started by zainul ulum Mar 24. 0 Replies 0 Promotions
Excel Survey Forum,I've developed "solver model" to adjust survey measurement using least square method. the model covers …Read more →
Loading feed
Say Something ⇣
Welcome! Sign in or register.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.
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
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
The largest geospatial network on planet earth, covering all land surveying related topics! Share surveyor knowledge with media in forums.
Take this Page With You
QR Code for This Page: What is this?
Follow Our Progress
Share and Learn new surveying techniques and tips in this Social Surveying Education Experiment and learn what it takes to be a Level 10 Land Surveyor.
June 21st-June 19th 2013
Read More
How it Works
© 2013 © Created by Land Surveyors United
Disclaimer: our moderators do not verify the accuracy of your postings and assume no responsibility for the contents therein.
