# Thread: Calculating the Work Done Cut Fill Area of Canal Cross Section

1. ## Calculating the Work Done Cut Fill Area of Canal Cross Section

I am a AutoCad Operator by profession & i am working on Irrigation Canal Project. i have more then 500 Cross Section of Canal in AutoCAD, i can receive Work Done Level of Each Cross Section in the end of each month and i can plot the work done level in each cross section for calculating the work done area of cut and fill.

Please someone help me for calculating the Area of Work Done of Canal Cross Section in excel.

I have a formula ("xCutfill") in excel which is calculate the total area of Cross Section (Cut & Fill),

I have Work Done Levels of each cross Sections (more than 500 cross sections) I want to calculate the work done area (Cut Area & Fill Area) in Excel sheet.

Work Done Area means “Which area is done at site”

Please see the attachments for better understanding.

2. It would probably be an adaptation of the xCutFill udf, but since it's password protected…

3. Originally Posted by p45cal
It would probably be an adaptation of the xCutFill udf, but since it's password protected…

Password of VBA project is = 0078

4. In your example file the work done level in cells K4:K6 are all the same level (205.5, 205.5, 205.5).
1. Is the work level always quoted using just 3 points?
2. Are all these values always equal to each other in each case? (ie is the work done level always horizontal)

5. Excel 2010
Get coordinates from superimposed charts,
or from calculated intersections.

6. work done level always horizontal

7. Some changes to existing code, test the attached.
Seems to handle non-horizontal work done levels too.

8. it works perfect Thanks a lot for help Sir..

9. ## Cross Section offsets and elevations

Dear sir, i hope you fine.

when i update the NSL , Design & Work Done Data in Excel Sheet,
I want the Work Done Area offsets and elevations in Excel Sheet for placing the hatch in to AutoCAD.

10. respected sir if the work level are not limited to 3 points and as well as if they are not of having same levels.then how to do?????? pls suggest me.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•