Results 1 to 10 of 10

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

  1. #1

    Calculating the Work Done Cut Fill Area of Canal Cross Section



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Canal Section-Model.jpg 
Views:	376 
Size:	67.4 KB 
ID:	4201  
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    It would probably be an adaptation of the xCutFill udf, but since it's password protected…

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


    Password of VBA project is = 0078

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    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. #5
    Excel 2010
    Get coordinates from superimposed charts,
    or from calculated intersections.
    http://www.mediafire.com/download/19g46546bhu6h9c/11_26_15b.xlsm
    http://www.mediafire.com/download/v6.../11_26_15b.pdf


  6. #6
    work done level always horizontal


  7. #7
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    Some changes to existing code, test the attached.
    Seems to handle non-horizontal work done levels too.
    Attached Files Attached Files
    Last edited by p45cal; 2015-12-01 at 11:41 PM.

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

  9. #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.
    Attached Files Attached Files

  10. #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
  •