cut and fill calculation on cross section chart with vba excel

Follow Excel for Land Surveyors

Excel for Land Surveyors is a Hub for sharing helpful spreadsheet tools and applications to be used in the surveying field.

If you are new to the Excel Support for Land Surveyors Group, please start by adding a discussion and introducing yourself to the community! Start a new discussion to share a spreadsheet with your fellow 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.

660 EXCELlant Surveyors

👉️Join this Hub

cut and fill calculation on cross section chart with vba excel

Posted by zainul ulum on November 23, 2012 at 7:08pm in Spreadsheet for Surveyors, Calculations Spreadsheet, Spreadsheet Program

Hi Forum,

my name is zainul land surveyor from indonesia

this is my first post in this forum and first share my spreadsheet as well

i made user define functions (udf) saved in excel addins (*.xla) to calculate cut and fill area.

Attached file is zipped file consists of 2 files, one file is xla and the other one is sample of cross section charts. There are 2 (two) UDF in addins, named xCatchPoint() to obtained left and right coordinates of "catch points" and UDF xCutFill to calculate cut and fill area.

Cross section samples consist of two cross sections and resume for volume calculation.

please feel free to download it. lets discuss for further development.

I also posted this spreadsheet on My Blog , in "bahasa indonesia"

thanks

-zainul-

Download xs.zip

You need to be a member of Land Surveyors United - Surveying Education Community to add thoughts!

Join Land Surveyors United - Surveying Education Community

xls, chart, cross, cut, excel, fill, section, spreadsheet, surveying, volume

★

Votes: 0

Email me when people reply –

Replies

Land Surveyor

ABHISHEK MOHANTY November 17, 2019 at 11:07am

[email protected]

SIR PLEASE SEND ME.
emren July 4, 2018 at 7:31am

Thanks.
Land Surveyor

adil ahmad malik May 30, 2018 at 4:48am

please send the sheet at [email protected]
Land Surveyor

RAYMOND KINGSLY July 19, 2016 at 3:22am

sir please do tutorial in English ,its very good program.
martin zamarripa August 25, 2015 at 12:13pm

Que puedo hacer para descargar la aplicación.
zainul ulum August 17, 2015 at 9:22pm

dear forum,

sorry for corrupted file and late replay.

i re-upload the revised one. hoping it works fine.
- Government Professional
  
  EDWIN B. ILDEFONSO > zainul ulum August 19, 2015 at 11:37pm
  
  The file is corrupted. Could you please re upload. There are a lot of us who want to try your program. Please?
Vendor

Sikander Singh August 16, 2015 at 4:54am

Sir,

I am a Surveyor from India Kindly Provide me Cross Section Program in Excel And AotuCad I Shall be very Thankful to your.

Sikander Singh

[email protected]
- zainul ulum > Sikander Singh August 17, 2015 at 9:27pm
  
  i'll add tool to draw in CAD in the program.
  - Student Surveyor
    
    MARLO GERODIAS TESTADO > zainul ulum June 1, 2021 at 11:25pm
    
    I am Marlo Gerodias Testado from Philippines currently a student of Geodetic Engineering 5th year please include me sending the files I am very happy for your help. Thank you brother. God bless.