Earthwork finals - borrow pit

qnty-erthwrk-fnl-brw-pit-01.mp4 11:26

This section will demonstrate three ways to obtain final site volume information and how to create the two surfaces needed; a Borrow site surface created from point and breakline files, and an existing surface built from a data reference. This workflow can also be used for almost any earthwork site volume calculations.

Create drawing from template

1. Create a new drawing using the wisDOT12.dwt template.
2. Save the drawing.

Creating the Borrow site surface from an SRV file

1. Ensure the Final SRV file has been placed into the project folder structure (Refer to WisDOT project folder structure for recommended folder structure). The SRV file contains point and break line information that will be used to create a surface.
2. Run Convert SRV to PNT/FLT macro from the WisDOT toolbox, in the Toolbox tab of the Toolspace (The Autocad 2012 VBA Enabler needs to be installed for this macro to run).
3. Respond No to the save dialog that appears at the end of running the macro. This macro will build point and Breakline/Fault files with extension PNT and FLT in the same folder location as the original SRV file. These file can now be used as definitions for a surface.
4. Create a new surface and name it ACME Borrow Site
5. Select the Final Top Border as the surface style
6. Add Point file definitions to the surface using PENZD (Space Delimited) file format. Press the Plus icon/button and select the PNT file.
7. Select break link to file and OK.
8. Add Breakline definitions to the surface using the From file option and select the FLT file
9. Select break link to file and OK
10. The ACME Borrow Site surface is created. Zoom extents to see the surface.
11. Save the drawing.

Create the Existing Surface by creating a Data Reference

1. Navigate in the Toolspace, on the Prospector tab and expanding the Data Shortcuts collection. Select the Exist surface under the Surface collection and right-click and select Create Reference.
2. Select the EX border surface style for best drawing performance and for visual reference.
3. Save the drawing.

Calculate Borrow Site volume using the Composite Volumes tool

1. Select Analyze>Volume tool, to create a new volume entry
2. Select the Exist surface as the base surface and ACME Borrow Site as the comparison surface to be used.

3. Save the drawing.

Calculate Borrow Site Volume using the Volume Dashboard tool

1. Open the Volume Dashboard from the command line by typing VOLUMEDASHBOARD. This tool can also be accessed in the Toolspace, Toolbox tab, under the Subscription Extension Manager collection. Expand Volumes Dashboard Extension for AutoCAD Civil 3D 2012 and right-click on Volumes Dashboard for AutoCAD Civil 3D 2012 and select Execute.
2. Create a new Volume Surface. Select the Exist surface as the base surface and ACME Borrow Site as the comparison surface to be used.
   • Review the cut and fill volumes that are shown in both tabular and graph form on the Dashboard. This information is derived from a Volume surface. This new volume surface is saved in the drawing.
3. Generate a Volume Report by selecting the Generate Cut/Fill Report button on the Dashboard.
   • A report is created for viewing. The information in the html report can be copied and pasted into an excel worksheet.
4. Save the drawing.

Calculate Borrow Site volume from Section areas using the Average End-Area Method

1. Create an Alignment that extends down the middle of the longest direction of the borrow pit surface
   • The alignment should extend past the surface area on both ends.
2. Create a Sample Line Group from Ribbon>Profile & Section Views>Sample Lines
3. Select the newly created alignment
4. Set the data sources to sample in the Create Sample Line Group dialog. Verify the Exist surface and ACME Borrow Site surface are selected and close dialog.
5. Create Sample lines by range of stations
6. Define the swath width and station frequency of sample lines so they extend beyond the width of the borrow site surface.
7. Set the sample increments. A 10' increment is appropriate for most sites.
   • The sample increments are in direct correlation to the desired volume precision.
8. Select OK and close the Sample Line Tools dialog.
9. To add more sample lines for critical location and site irregularities select the sample method At a Station, then pick on screen the location desired for an additional sample line. Follow the command line prompts for left and right swath width, then select another location or press enter to quit the command

10. Erase all the Sample lines in the model that do not cross over both surfaces, except for the first sample line
11. Open the Sample Line Group Properties Dialog by selecting one of the sample lines, then selecting Group Properties on the contextual ribbon.
    • In the Material List tab, Click on Import another criteria and use the WisDOT Mass Ordinate Quantity Takeoff criteria.
    • Choose <Click here to set all> next to Exist surface and assign the "Exist" surface.
    • Choose <Click here to set all> next to Final Datum surface and assign the ACME Borrow Site surface.
      • Not all materials will be assigned.
    • Press OK to continue
12. Set Volume calculation method to Average End Area and click OK to exit
    • The material volumes have now been computed.
13. On the sample line contextual ribbon, select Generate Volume Report.
    • Verify the alignment, sample line group, and material list is correct.
14. Generate Volume Report using the earthwork.xls style sheet.
15. Save the drawing.