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"



This Content Originally Published by a land surveyor to Land Surveyors United Network

Views: 48437

See Your Saved Posts Timeline

Replies to This Discussion

Great template... very helpful. I am designing a pond with a 3:1 grade... How can I change B10 and C10 to reflect this? Thanks!


input =1/3 both on B10 and C10 to reflect grade of V:H = 3:1

Okay, so I've entered 3:1 and it didn't change the graph. I'm wanting to make the graph look like a mound instead of a cone, since I am designing a pond. Any ideas?

Great work Zainul, wish it can by converted to English for my understanding, thx

rev.01 since the previous file contains calc. error at the right catch point..

Download Survey Documents-Members Only
Was this resource helpful? Show your appreciation with a comment below. 

Donations are how we exist and grow for the surveying community worldwide.

thanks dear

Dear Assalam u Aalikum,
your attached file contain error plz upload new and fresh file.


wa'alaikum salaam

i just uploaded the revised one

Please Note that above file is damaged, please upload a fresh copy of that xls file

a good program it is, actually i have writtensome too but would upload mine soonest

looking forward for uploading your file. thanks

please re-download, i've just upload the new one.


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

Land Surveyor Forum - Community Discussions


Started by gajendra singh. Last reply by ⚡Survenator⌁ Nov 19, 2018. 1 Reply

Traverse Calculation excel sheet download

Started by Soumen Samanta. Last reply by Debabrata Patra Jul 7, 2018. 2 Replies


Started by abdu aziz abdu rahman Jan 15, 2018. 0 Replies

EDM Distance Reductions

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

Format for billing Highway

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


Started by ⚡Survenator⌁. Last reply by Gifton Samuel Godwin Oct 1, 2018. 2 Replies

3D Point to Line in Excel

Started by ⚡Survenator⌁. Last reply by ⚡Survenator⌁ Feb 16, 2016. 1 Reply

Quick Excel Hack

Started by Jaybird. Last reply by emren Jul 4, 2018. 4 Replies

Road Profile

Started by Amjad Shahzad Rizvi. Last reply by Dharmesh Shah May 9, 2017. 4 Replies

Cut and Fill Spreadsheet - Good Base

Started by Ted Woods. Last reply by rahadi jumali Mar 21, 2016. 4 Replies

Cross Section Program in Excel and AutoCad

Started by Sikander Singh. Last reply by emren Jul 4, 2018. 6 Replies


Started by Mat Win Jul 29, 2015. 0 Replies

Bar bending Schedule

Started by Manoj Kumar Yadav. Last reply by Manoj Kumar Yadav Jul 25, 2016. 5 Replies

Tools,Apps and Quick Guides


Help With Survey Equipment

Social Support For Equipment

Surveying Video Categories

Surveying Photo Categories

United States Hub Forums

International Surveyor Hub Forums

Resources for Company Owners

Land Surveyor Social Media

Surveyor Resources Collections

Getting Started & Newsletter

Featured Land Surveyor Hubs

Surveyor Birthdays

© 2019   © Created by Land Surveyors United   Powered by

Badges  |  Contact LSU  |  Privacy Policy  |  Terms of Service

Site Explorer