Earthwork Calculation Sheet-standard V5.0 2z643l
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 3i3n4
Overview 26281t
& View Earthwork Calculation Sheet-standard V5.0 as PDF for free.
More details 6y5l6z
- Words: 1,011
- Pages: 3
EARTHWORK CALCULATION WORKSHEET Upstream
PROJECT NAME:
STRUCTURE ID #:
COUNTY:
PREPARED BY:
PROJECT ID#:
DATE:
0
EL. = 0.00
0
0
0 0
Top Width (ft):
Embankment Elevation
Front Slope ( :1):
Settlement (%):
0
Embankment Subcut
Bottom Width (ft) Side Slope (:1)
Back Slope ( :1): DESIGN DATA
STA.
EXISTING GROUND ELEV.
CORE TRENCH DEPTH
EMBANKMENT
DIST B/W STA.
SUBCUT
AVG END AREA (SQ.FT.)
CU. YARDS PER FT.
TOTAL CUBIC YARDS
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AVG END AREA (SQ. FT)
CU. YDS. PER FOOT
TOTAL CUBIC YARDS
BTM. CORE ELEV.
END AREA (SQ.FT)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00
0.00
0.00
0.00
0.00
FILL HEIGHT
END AREA (SQ.FT.)
SUBCUT GRADE ELEV.
END AREA (SQ.FT)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
EMBANKMENT TOTAL (C.Y. )
0.00
SUBCUT TOTAL (C.Y. )
TOTAL YDS³ OF COMPACTED FILL Prepared by Minnesota Board of Water & Soil Resources 06/17/02 Version 5.0
CORE
SURFACE AREA OF EMBANKMENT (ACRES)
0.00
0.00 0.00
AVG END AREA (SQ.FT.)
CORE TOTAL (C.Y. )
CU. YDS. TOTAL CUBIC PER FOOT YARDS
0.00
CLICK PROFILE TAB TO SEE A GRAPHIC REPRESENTATION OF EMBANKMENT
12.00
10.00
ELEVATION (FT.)
8.00
6.00
4.00
2.00
0.00 0
2
4
EMBANKMENT
6
SUBCUT
STATION (FT.)
8
EXISTING GROUND
10
CORE
12
Instructions/tips for using BSWR Earthwork-Standard v.5 Spreadsheet
The spreadsheet is “Protected”, meaning that only certain cells can be edited. O with a white background may be edited or have info. entered into them. Cells with a red triangle in the upper right corner have “Tool Tips” associated w them. Just place the pointer in one of these cells and a box will appear with inf about what that cell does or what values should be entered into it. The 1st station entered should be the beginning station of the planned embankm example: Your profile runs from 0+00 to 9+30. Your embankment starts at 0+1 station entered must be “10”. If your embankment starts at 0+00, then the 1 entered must be “0”, etc… The elevation of the 1st station entered must be equal to the value entered in the Embankment Elevation field. In order for the subcut quantity to calculate correctly, the 2nd station entered sh within 1 or 2 feet of the 1st station and the 2nd exiting ground elevation should b tenths less than the 1st existing ground elevation. Conversely, the 2 should be within 1 or 2 feet of the last station and the 2nd to last existing ground elevation should a few tenths less than the last existing ground elevation. Example: the 1st value is station 0 with an existing ground elevation of 100 ft. T value should be station 1 with an existing ground elevation of 99.9. The same applies to the end of the series. If the last value is station 50 with an existing g elevation of 100 ft., than the second to last value should be station ground elevation of 99.9 ft. This will force the spreadsheet to calculate the beg and ending points of the subcut in the correct spots. Clicking the Profile tab at the bottom of the spreadsheet gives the a graph information entered. This page has been sized to print out so that the graph can trimmed and be manually placed on the BWSR standard design sheets. This el the need to hand draw the profile and should save people not using the standard on CAD a lot of time. If anyone has problems using the spreadsheet or has any questions, please feel :
PROJECT NAME:
STRUCTURE ID #:
COUNTY:
PREPARED BY:
PROJECT ID#:
DATE:
0
EL. = 0.00
0
0
0 0
Top Width (ft):
Embankment Elevation
Front Slope ( :1):
Settlement (%):
0
Embankment Subcut
Bottom Width (ft) Side Slope (:1)
Back Slope ( :1): DESIGN DATA
STA.
EXISTING GROUND ELEV.
CORE TRENCH DEPTH
EMBANKMENT
DIST B/W STA.
SUBCUT
AVG END AREA (SQ.FT.)
CU. YARDS PER FT.
TOTAL CUBIC YARDS
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AVG END AREA (SQ. FT)
CU. YDS. PER FOOT
TOTAL CUBIC YARDS
BTM. CORE ELEV.
END AREA (SQ.FT)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00
0.00
0.00
0.00
0.00
FILL HEIGHT
END AREA (SQ.FT.)
SUBCUT GRADE ELEV.
END AREA (SQ.FT)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
EMBANKMENT TOTAL (C.Y. )
0.00
SUBCUT TOTAL (C.Y. )
TOTAL YDS³ OF COMPACTED FILL Prepared by Minnesota Board of Water & Soil Resources 06/17/02 Version 5.0
CORE
SURFACE AREA OF EMBANKMENT (ACRES)
0.00
0.00 0.00
AVG END AREA (SQ.FT.)
CORE TOTAL (C.Y. )
CU. YDS. TOTAL CUBIC PER FOOT YARDS
0.00
CLICK PROFILE TAB TO SEE A GRAPHIC REPRESENTATION OF EMBANKMENT
12.00
10.00
ELEVATION (FT.)
8.00
6.00
4.00
2.00
0.00 0
2
4
EMBANKMENT
6
SUBCUT
STATION (FT.)
8
EXISTING GROUND
10
CORE
12
Instructions/tips for using BSWR Earthwork-Standard v.5 Spreadsheet
The spreadsheet is “Protected”, meaning that only certain cells can be edited. O with a white background may be edited or have info. entered into them. Cells with a red triangle in the upper right corner have “Tool Tips” associated w them. Just place the pointer in one of these cells and a box will appear with inf about what that cell does or what values should be entered into it. The 1st station entered should be the beginning station of the planned embankm example: Your profile runs from 0+00 to 9+30. Your embankment starts at 0+1 station entered must be “10”. If your embankment starts at 0+00, then the 1 entered must be “0”, etc… The elevation of the 1st station entered must be equal to the value entered in the Embankment Elevation field. In order for the subcut quantity to calculate correctly, the 2nd station entered sh within 1 or 2 feet of the 1st station and the 2nd exiting ground elevation should b tenths less than the 1st existing ground elevation. Conversely, the 2 should be within 1 or 2 feet of the last station and the 2nd to last existing ground elevation should a few tenths less than the last existing ground elevation. Example: the 1st value is station 0 with an existing ground elevation of 100 ft. T value should be station 1 with an existing ground elevation of 99.9. The same applies to the end of the series. If the last value is station 50 with an existing g elevation of 100 ft., than the second to last value should be station ground elevation of 99.9 ft. This will force the spreadsheet to calculate the beg and ending points of the subcut in the correct spots. Clicking the Profile tab at the bottom of the spreadsheet gives the a graph information entered. This page has been sized to print out so that the graph can trimmed and be manually placed on the BWSR standard design sheets. This el the need to hand draw the profile and should save people not using the standard on CAD a lot of time. If anyone has problems using the spreadsheet or has any questions, please feel :
Related Documents 3h463d
Earthwork Volume Calculation Methods 572x6r
February 2022 0
Autocad Civil 3d-earthwork Calculation 5a5c
November 2022 0
Earthwork Calculation Sheet-standard V5.0 2z643l
November 2019 60
Earthwork Specification 6i221s
October 2019 70
Earthwork Rates 1b3b3i
January 2022 0
Innbox V50 Quick Start 1r1hs
December 2021 0More Documents from "SureshKumar" 1666x
Nema Rn1 Pvc Coated Rs Conduit 2xm69
December 2019 45
Biodisk Testimonies 3m4b4q
December 2019 51
Earthwork Calculation Sheet-standard V5.0 2z643l
November 2019 60
Olai Suvadi Maruthuvam 4q3w6
December 2019 103
Iipm-pmp%20course-brochure 3g1x27
November 2019 30