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: 193
Latest Activity: yesterday

Excel For 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.

Latest Discussions By Category ▿

STAR NET PROCESSING

Started by Durai Kannan. Last reply by kenneth foong yesterday. 1 Reply

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 →

Excel spreadsheet to calculate Deed and export to Autocad

Started by William J Barrows Jr. Last reply by Nel W. Bacz Oct 1. 3 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

drawing point in autocad using excel

Started by aamir shahzad. Last reply by Kanagaratnam Rameshkumar Sep 8. 1 Reply

Read more →

drawing point in autocad using excel

Started by aamir shahzad. Last reply by Surveying Jobber Aug 28. 1 Reply

Read more →

Parsing Nikon RAW data with excel formula

Started by zainul ulum. Last reply by Eletu A. Ajiboye Aug 4. 2 Replies

Hi Surveyors,I made formulas in excel spreadsheet to parse raw data of Nikon Total Station (Nikon RAW data format V2.00). Please download the file attached below. If you have raw data from another total station (topcon,…Read more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: surveying, tool, total station, spreadsheet, trn

cut and fill calculation on cross section chart with vba excel

Started by zainul ulum. Last reply by Surv Felix E Okunbor Jul 20. 14 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

Vertical curve solution in excel for Surveyors

Started by talat. Last reply by ePalmetto Jul 18. 2 Replies

vertical curve solution for land surveyors in excelthis spread sheet can calculate both crest and sag curves. You can calculate levels at desired distance. Feel free to download and use the workbook belowRead more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: excel, surveying, spreadsheet, vertical, curve

Curves,Widening etc

Started by Shahid Iqbal Chaudhry. Last reply by Pedro Hernandez Jul 18. 3 Replies

Friends plz chek this survey spreadsheet maybe its useful to you for survey calculations related to curves curve widening etc. Please download belowRead more →

Find Similar Content by Clicking These Tags ☟
Subject Tags: excel, calculations, spreadsheet, widening, curves

SPREADSHEET, TRANSFORMATION COORDINATES AND XYZ dxf

Started by Pedro Hernandez Jul 18. 0 Replies

SPREADSHEET,  TRANSFORMATION COORDINATES AND XYZ  dxfRead more →

master survey programs spreadsheet

Started by aamir shahzad. Last reply by mkululi moyo Jul 15. 10 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

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 : [email protected]

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.

 

Members (193)

 
 
 

Land Surveyors Celebrate the Past Present and Future of Professional Land Surveying in this Geosocial Network. Frictionless GeoCollaboration

Surveyor Hubs and Tags

Help Keep Us Alive and Free!

Surveyor Community Hubs For World Regions

Surveying Hubs For US States

Social Support For Equipment

Surveying Photos by Tag

Surveying Videos by Tag

What You Missed

Pedro Hernandez's photo was featured

Measuring in Industrial Plant.

Industrial Plant Seamless Pipes.Puerto Ordaz Bolivar State.
3 hours ago
Thiago Paim commented on Thiago Paim's photo
Land Survey Media Thumbnail

Brazil Surveying in VW

"Yes Charlie, is Topcon. OS-105"
4 hours ago
Profile IconThere are 7069 members on Land Surveyors United
4 hours ago
mike joined ePalmetto's group
Land Survey Media Thumbnail

Professional Land Surveyors Europe

The Professional Land Surveyors of Europe is a social support group forum for land surveyors who…See More
5 hours ago
ePalmetto replied to Jansen Loi's discussion Starnet Help in the group Microsurvey Support Group
"i believe these are the manuals you seek.. let me know"
5 hours ago
Jansen Loi's discussion was featured

Starnet Help

Hi,I am currently using starnet V6 and I am having a problem. Tried searching through the manuals…See More
5 hours ago
Profile IconJosh Frazer, Brad Martin, Gerald Bernhard and 2 more joined Land Surveyors United
12 hours ago
Jansen Loi added a discussion to the group Microsurvey Support Group
Land Survey Media Thumbnail

Starnet Help

Hi,I am currently using starnet V6 and I am having a problem. Tried searching through the manuals…See More
12 hours ago
Jansen Loi joined LSU Justin's group
Land Survey Media Thumbnail

Microsurvey Support Group

Microsurvey Support group is for  MicroSurvey users in the field and office. This group is for…See More
12 hours ago
charlie-jm commented on Thiago Paim's photo
Land Survey Media Thumbnail

Brazil Surveying in VW

"es total station by topcon "
19 hours ago
kenneth foong joined Malik Abdur Rehman's group
Land Survey Media Thumbnail

Excel Spreadsheets for Surveyors

This group is for discussions related to the use of spreadsheets and excel in land surveying.See More
yesterday
kenneth foong replied to Durai Kannan's discussion STAR NET PROCESSING in the group Excel Spreadsheets for Surveyors
"You can try use this FRT to covert start net format."
yesterday
Mike McCulley promoted LSU Justin's group Topcon Support Group
yesterday
Desmond Elliott updated their profile
yesterday
Profile Iconkenneth foong, Brian Loucks, kayveen murithi and 3 more joined Land Surveyors United
yesterday
Achilles Nizamopoulos replied to Achilles Nizamopoulos's discussion survce localization problem
"Hello Desmond, thanks for the reply. i am tryin gto follow tour steps. how do you procces the RINEX…"
yesterday
Surveying Jobber's video was featured

Precision and Accuracy in Geodetic Surveying

This brief video, produced in collaboration between NOAA’s National Geodetic Survey and The COMET Program, is aimed at surveying professionals, planners, policy-makers and others who use mapping products. The video emphasizes that survey…
Thursday
Gennady's 2 photos were featured
Thursday
ePalmetto shared their page on Tweet This
Thursday
Jacquelin RAMAROLAHY's discussion was featured

SOFTWARE with NAVCOM SF2050M

Hi all,Did you already have any experience with this device? which software is fit better to read…See More
Thursday

Take This Page With You

follow us in feedly

Take this Page With You

QR Code for This Page: What is this?

Surveyor Goodies

© 2014   © 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