Instructions:

1
2
3

5
 6
7
8
9

9
10
Instructions:
Add cut and fill volumes to the corridor
Run Quantities by Named boundary report and save file in excel format. Be surt to end/begin named boundaries at changes i
Select the volumes report

The report should be in the following format:

Right click on the report in ORD and select Export to Excel

Select entire sheet in the volumes excel spreadsheet. (CTRL-A or select the select all button)
Paste data in the quantities report tab in the grading summary spreadsheet.
Select the rows that contain the whole project totals and cut and paste to the Totals - QA_QC tab
Go to the "Manual Inputs" page and click on the "Click Here to Format Worksheet" button.

Determine if it is an excavation or embankment job and fill out the appropriate table.
For major secondary roads use the secondary report tabs.
Shrink/
Swell
Number
Factor
of Rows Station Range
Summa
Begin
ry End
Factor #N/A
Station Station Add Starting Station
Click here to
format worksheet

Note: Do not use '+'

sign in begin and end
stations above
 Pay Column

TOTALS 0.00 0.00 0.00 0.00

Excavation Total

Total Excavation
Volumes_Cut+E
Roadway prism
xisting_Payment Total Excavation
minus topsoil Approach Road
(removed) for Pay
and pavement
+Topsoil
(removed)

Total Excavation
ORD Component Name Volumes_Cut: Total Excavation --
for Pay

Enter Start of Project

 0.00 0.00 0.00 0.00 0.00 0.00
Excavation Material Available for Fill Excavation Material Unavailable for Fills

(+)
(+) (-)
Excavation (-) (-)
Structure (+) Disposal of
From Pavement Topsoil Stripping
Excavation Subexcavation Subexcavation
Roadway Removal in Cuts in Cuts
(Walls) Material
Obliteration

Exist Pvmt Layer Exist Topsoil

-- -- Subex_Exc2: Subex_Exc2:
1 (removed): (removed):
 Pay Column

0.00 0.00 0.00 0.00 0.00

Embankment

Roadway Prism
(Embankment)
plus backfill for
Total Roadway Total Roadway
topsoil in fills Approach Road
Prism Fill Prism Fill for Pay
and existing
pavment in fills
Shrink/Swell Total Excavation
Factor Available for Fills

Total
Volumes_Fill: -- Embankment
for Pay
 0.00 0.00 0.00 0.00 0.00 0.00
Backfill (Nee

(+) (+) (+) (+) (+)

(+)
Common Foundation Select Granular Granular Structural
Rock
Backfill Fill Backfill Rock Backdrain Backfill

MSE Wall Rockery Wall Rockery Wall

Wall Backfill: -- Wall Backfill 2:
Backfill 2: Backfill: Backfill 2:
 0.00 0.00 0.00 0.00 0.00 0.00
Backfill (Needed Volume for Backfill Placed on Site)

(+) (+) Backfill for

Backfill for (+) (+)
Common Granular Pavement
Topsoil Removal Sub-excavation Aggregate Base
Backfill Backfill Removal Under
Under Fill
Fill

Exist Pvmt Layer Exist Topsoil

-- -- 1 (removed and (removed and Subex_Backfill1:
replaced): replaced):
0.00 0.00 0.00 0.00 0.00 0.00

Excavation
Total
(+)
(+) -
(+) Embankment For (+) Embankment
Riprap
Special Rock
Roadway Topping
Embankment
Embankment
Obliteration
0.00 0.00 0.00 0.90 0.00

Unclassifed Unclassified
Embankment Unclassified
Waste Borrow Borrow Mass Ordinate
Construction Borrow
Required Shrink/Swell

0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
TOTALS 0.00 0.00 0.00
Station Pavement Removed Pavement Removed/Replaced Total
Exist Pvmt Layer 1 Exist Pvmt Layer 1 (removed and Total Exist Pvmt
(removed): replaced): Layer 1:
 0.00 0.00 0.00 0.00
Topsoil Removed Topsoil Removed/Replaced
Pavement Pavement Exist Topsoil Exist Topsoil (removed and
Removed Removed/Replaced (removed): replaced):
 0.00 0.00 0.00
Total
Total Exist Topsoil Topsoil
Topsoil: Removed Removed/Replaced
 TOTALS 0.00 0.00 0.00
Structure Excavation
Soil Nail MSE Wall GFMSE Wall
Soil Nail Wall MSE Wall GFMSE Wall
ORD Component Name
Excavation: Excavation: Excavation:
Enter Start of Project
 0.00 0.00 0.00 0.00
Structure Excavation
Rockery Wall Concrete Walls Guardwall Total
Rockery Wall Guard Wall
Wall Excavation:
Excavation: Excavation:
 TOTALS 0.00 0.00 0.00

Parapet Parapet Rockery

(+) (+) (+)
Common Foundation Foundation
Backfill Total Common Fill Fill
Backfill (+)
Rockery Wall
Wall
ORD Component Name Wall backfill: Foundation
Foundation:
Backfill:
Enter Start of Project
 0.00 0.00 0.00 0.00

MSE Parapet
(+) (+)
(+) (+) (+)
Select Granular Granular
Foundation Rock Structural
Total Backfill Rock Backdrain
Fill Backfill
Foundation Fill
(+)
MSE Wall MSE Wall Rockery Wall Rockery Wall
Wall Backfill 2:
Foundation: Backfill 2: Backfill: Backfill 2:
 0.00 0.00 0.00 0.00 0.00

MSE MSE Parapet

(+) (+)
(+) (+) (+)
Common Common
Common Common Common
Backfill Backfill
Backfill Backfill Backfill Total Common
Backfill (+)
MSE Wall Soil Nail Wall Wall Backfill Guard Wall
MSE Wall Front:
Backfill 3: Backfill: Top: Backfill 1:
 0.00 0.00

(+) (+)
Select Granular Granular
Backfill Rock Backdrain
Total Granular
Backfill (+)
MSE Wall Rockery Wall
Backfill 1: Backfill 2:
 EARTHWORK SUMMARY
USING ROADWAY EXCAVATION AND EITHER BORROW OR WASTE PAY ITEMS

EXCAVATION (unadjusted volumes)

Total Roadway Prism Excavation = 0 CUYD
Total Approach Road Prism Excavation = +00 CUYD
Total Pay Item 20401-0000 Roadway Excavation = 0 CUYD

EXCAVATION MATERIAL AVAILABLE FOR FILL (unadjusted volumes)

Total Structure Excavation (walls) = 0 CUYD
Total Excavation from Roadway Obliteration = +00 CUYD
Total Subexcavation = +00 CUYD
Total = 0 CUYD

EXCAVATION MATERIAL UNAVAILABLE FOR FILL (unadjusted volumes)

Total Pavement Removal in Cuts = 0 CUYD
Total Topsoil Stripping in Cuts = 0 CUYD
Total Waste Subexcavation = 0 CUYD
Total = 0 CUYD

TOTAL EXCAVATION AVAILABLE FOR FILLS (adjusted volume)

Total Volume After Adjustments Applied (Including Shrink/Swell) = 0 CUYD

EMBANKMENT (unadjusted volumes)

Total Roadway Prism Fill = 0 CUYD
Total Approach Road Prism Fill = +00 CUYD
Total = 0 CUYD

BACKFILL
Total Various Types of Wall Backfill Material = 0 CUYD
Total Backfill for Pavement Removal Under Fill = +00 CUYD
Total Backfill for Topsoil Removal Under Fill = +00 CUYD
Total Volume for Riprap = +00 CUYD
Total Volume for Special Rock Embankment = +00 CUYD
Total Embankment for Roadway Obliteration = +00 CUYD
Total Subexcavation = +00 CUYD
Total Volume for Topping or Select Topping = +00 CUYD
Total Volume for Aggregate Base = +00 CUYD
Total = 0 CUYD

EXCAVATION MINUS EMBANKMENT

Total Estimated Excavation Available for Fills = 0 CUYD
Total Estimated Fill Material Required = -00 CUYD
Excavation - Embankment = 0 CUYD

WASTE
Estimated Total Pay Item 20441-0000 Waste = NA CUYD

BORROW
Estimated Unadjusted Volume of Unclassified Borrow Required = NA CUYD
Estimated Shrink / Swell at Borrow Pit Site = 0.9
Estimated Total Pay Item 20403-0000 Unclassified Borrow = NA CUYD
 GRADING SUMMARY
Pay Item Additional Excavation Embankment
Roadway Excavation For info only For info only For Info Only
20401-0000 For info only For info only

(+) (-) Total

Shrink/Swell (+) UNCLASSIFIED
Prismoidal Approach ROADWAY Available Unavailable Excavation Prismoidal Approach Total Excavation-
Factor Backfill BORROW
Station to Station Volume Roads EXCAVATION Material Material Avaliable For Volume Roads Embankment Embankment
(see note 5) (see note 6) (see note 7)
(see note 3) (see note 4) Fills

BCY BCY CUYD BCY BCY CCY CCY CCY CCY CCY CCY CUYD

Secondary Alignment

TOTALS 0 0 0 0 0 0 0 0 0 0 0 NA

NOTE:
1 Quantities based on prismoidal (surface to surface) volumes.
2 Conserve <<XXX>> inches of topsoil in cut and fill slope areas.
3 Available material includes <<INSERT PROJECT SPECIFIC INFORMATION-See Notes to Designer Note 1>>.
4 Unavailable material includes <<INSERT PROJECT SPECIFIC INFORMATION-See Notes to Designer Note 2>>.
5 The average shrink/swell factor shown is computed by taking an average of recommended values over the specified range. Refer to the Geotech Report for recommended shrink/swell factors.
6 Backfill includes <<INSERT PROJECT SPECIFIC INFORMATION-See Notes to Designer Note 3>>.
7 Unclassified borrow quantity calculated using volumes adjusted using shrink/swell. An assumed value of 0.9 was used for borrow material calculations. The contractor is responsible for determining the actual shrink/swell on the borrow material.

8 The quantities shown herein are approximations. Payment will be made for the actual quantities of work performed.
 EARTHWORK SUMMARY
USING EMBANKMENT CONSTRUCTION PAY ITEM

EXCAVATION (unadjusted volumes)

Total Roadway Prism Excavation = 0 CUYD
Total Approach Road Prism Excavation = +00 CUYD
Total = 0 CUYD

EXCAVATION MATERIAL AVAILABLE FOR FILL (unadjusted volumes)

Total Structure Excavation (walls) = 0 CUYD
Total Excavation from Roadway Obliteration = +00 CUYD
Total Subexcavation = +00 CUYD
Total = 0 CUYD

EXCAVATION MATERIAL UNAVAILABLE FOR FILL (unadjusted volumes)

Total Pavement Removal in Cuts = 0 CUYD
Total Topsoil Stripping in Cuts = 0 CUYD
Total Waste Subexcavation = 0 CUYD
Total = 0 CUYD

TOTAL EXCAVATION AVAILABLE FOR FILLS (adjusted volume)

Total Volume After Adjustments Applied (Including Shrink/Swell) = 0 CUYD

EMBANKMENT (unadjusted volumes)

Total Roadway Prism Fill = 0 CUYD
Total Approach Road Prism Fill = +00 CUYD
Total = 0 CUYD

BACKFILL
Total Various Types of Wall Backfill Material = 0 CUYD
Total Backfill for Pavement Removal Under Fill = +00 CUYD
Total Backfill for Topsoil Removal Under Fill = +00 CUYD
Total Volume for Riprap = +00 CUYD
Total Volume for Special Rock Embankment = +00 CUYD
Total Embankment for Roadway Obliteration = +00 CUYD
Total Subexcavation = +00 CUYD
Total Volume for Topping or Select Topping = +00 CUYD
Total Volume for Aggregate Base = +00 CUYD
Total = 0 CUYD

EXCAVATION MINUS EMBANKMENT

Total Estimated Excavation Available for Fills = 0 CUYD
Total Estimated Fill Material Required = -00 CUYD
Excavation - Embankment = 0 CUYD

EMBANKMENT CONSTRUCTION
Estimated Total Pay Item 20420-0000 Embankment Construction = 0 CUYD

UNCLASSIFIED BORROW
Estimated Unadjusted Volume of Unclassified Borrow Required = 0 CUYD
Estimated Shrink / Swell at Borrow Pit Site = 0.9
Estimated Quantity of Unclassified Borrow Required = 00 CUYD
 GRADING SUMMARY
Additional Excavation Pay Item
Roadway Excavation For info only Embankment For info only For info only
For info only 20420-0000

(+) (-) Total Estimated

Shrink/Swell (+)
Prismoidal Approach Roadway Available Unavailable Excavation Prismoidal Approach Embankment Total Excavation - Unclassified
Factor Backfill
Station to Station Volume Roads Excavation Material Material Available For Volume Roads Construction Embankment Embankment Borrow Volume
(see note 5) (see note 6)
(see note 3) (see note 4) Fills (see note 7)

BCY BCY BCY BCY BCY CCY CCY CCY CUYD CCY CCY CCY BCY

TOTALS 0 0 0 0 0 0 0 0 0 0 0 0 0

NOTE:
1 Quantities based on prismoidal (surface to surface) volumes.
2 Conserve <<XXX>> inches of topsoil in cut and fill slope areas.
3 Available material includes <<INSERT PROJECT SPECIFIC INFORMATION-See Notes to Designer Note 1>>.
4 Unavailable material includes <<INSERT PROJECT SPECIFIC INFORMATION-See Notes to Designer Note 2>>.
5 The average shrink/swell factor shown is computed by taking an average of recommended values over the specified range. Refer to the Geotech Report for recommended shrink/swell factors.
6 Backfill includes <<INSERT PROJECT SPECIFIC INFORMATION-See Notes to Designer Note 3>>.
7 Unclassified borrow quantity calculated using volumes adjusted using shrink/swell. An assumed value of 0.9 was used for borrow material calculations. The contractor is responsible for determining the actual shrink/swell on the borrow material.

8 The quantities shown herein are approximations. Payment will be made for the actual quantities of work performed.
9 BCY = Bank cubic yard - one cubic yard of material as it lies in the natural state.
CCY = Compacted cubic yard - one cubic yard of material after it has been compacted to specification density.

NOTES TO DESIGNER:
1 Available material is anything in the grading tab in columns G, H and I. Use exact description from the grading tab in the notes.
2 Unavailable material is anything in the grading tab in columns J, K and L. Use exact description from the grading tab in the notes.
3 Backfill is anything in the grading tab in columns S, T, U, V, W, X, Y, Z, AA, AB, AC, AD, AE, AF, AG and AH. Use exact description from the grading tab in the notes.
4 Be sure to change all text to black before printing.
 CONSERVED TOPSOIL SUMMARY
For info only 62406-0300

PLACING
Topsoil Topsoil Turf CONSERVED
conserved in conserved in Fill: Cut: Total Area
Station to Station cuts fills Establishment: TOPSOIL, 4-INCH
DEPTH

BCY BCY SQFT SQFT SQFT ACRE ACRE

TOTALS 0 0 0 0 0 0.00 0.0

 CONSERVED EXISTING PAVEMENT SUMMARY
For info only

Existing Existing
pavement pavement
Station to Station conserved in conserved in
cuts fills

BCY BCY

TOTALS 0 0

Note:
Shrink/
Swell
Number
Factor
of Rows Station Range
Summa
Begin
ry End
Factor #N/A
Station Station Add Starting Station
Click here to
format worksheet

Note:
Do not
use '+'
sign in
 Pay Column

TOTALS 0.00 0.00 0.00 0.00

Excavation Total

Total Excavation
Volumes_Cut+E
Roadway prism
xisting_Payment Total Excavation
minus topsoil Approach Road
(removed) for Pay
and pavement
+Topsoil
(removed)

Total Excavation
ORD Component Name Volumes_Cut: Total Excavation --
for Pay

Enter Start of Project

 0.00 0.00 0.00 0.00 0.00 0.00
Excavation Material Available for Fill Excavation Material Unavailable for Fills

(+)
(+) (-)
Excavation (-) (-)
Structure (+) Disposal of
From Pavement Topsoil Stripping
Excavation Subexcavation Subexcavation
Roadway Removal in Cuts in Cuts
(Walls) Material
Obliteration

Exist Pvmt Layer Exist Topsoil

-- -- Subex_Exc2: Subex_Exc2:
1 (removed): (removed):
 Pay Column

0.00 0.00 0.00 0.00 0.00

Embankment

Roadway Prism
(Embankment)
plus backfill for
Total Roadway Total Roadway
topsoil in fills Approach Road
Prism Fill Prism Fill for Pay
and existing
pavment in fills
Shrink/Swell Total Excavation
Factor Available for Fills

Total
Volumes_Fill: -- Embankment
for Pay
 0.00 0.00 0.00 0.00 0.00 0.00
Needed V

(+) (+) (+) (+) (+)

(+)
Common Foundation Select Granular Granular Structural
Rock
Backfill Fill Backfill Rock Backdrain Backfill

MSE Wall Rockery Wall Rockery Wall

Wall Backfill: -- Wall Backfill 2:
Backfill 2: Backfill: Backfill 2:
 0.00 0.00 0.00 0.00 0.00 0.00
Needed Volume for Backfill Generated on Site

(+) (+) Backfill for

Backfill for (+) (+)
Common Granular Pavement
Topsoil Removal Sub-excavation Aggregate Base
Backfill Backfill Removal Under
Under Fill
Fill

Exist Pvmt Layer Exist Topsoil

-- -- 1 (removed and (removed and Subex_Backfill1:
replaced): replaced):
0.00 0.00 0.00 0.00 0.00 0.00

Excavation
Total
(+)
(+) -
(+) Embankment For (+) Embankment
Riprap
Special Rock
Roadway Topping
Embankment
Embankment
Obliteration
0.00 0.00 0.00 0.90 0.00

Unclassifed Unclassified
Embankment Unclassified
Waste Borrow Borrow Mass Ordinate
Construction Borrow
Required Shrink/Swell

0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
0.9
TOTALS 0.00 0.00 0.00
Station Pavement Removed Pavement Removed/Replaced Total
Exist Pvmt Layer 1 Exist Pvmt Layer 1 (removed and Total Exist Pvmt
(removed): replaced): Layer 1:
 0.00 0.00 0.00 0.00
Topsoil Removed Topsoil Removed/Replaced
Pavement Pavement Exist Topsoil Exist Topsoil (removed and
Removed Removed/Replaced (removed): replaced):
 0.00 0.00 0.00
Total
Total Exist Topsoil Topsoil
Topsoil: Removed Removed/Replaced
 TOTALS 0.00 0.00 0.00
Structure Excavation
Soil Nail MSE Wall GFMSE Wall
Soil Nail Wall MSE Wall GFMSE Wall
ORD Component Name
Excavation: Excavation: Excavation:
Enter Start of Project
 0.00 0.00 0.00 0.00
Structure Excavation
Rockery Wall Concrete Walls Guardwall Total
Rockery Wall Guard Wall
Wall Excavation:
Excavation: Excavation:
 TOTALS 0.00 0.00 0.00

Parapet Parapet Rockery

(+) (+) (+)
Common Foundation Foundation
Backfill Total Common Fill Fill
Backfill (+)
Rockery Wall
Wall
ORD Component Name Wall backfill: Foundation
Foundation:
Backfill:
Enter Start of Project
 0.00 0.00 0.00 0.00

MSE Parapet
(+) (+)
(+) (+) (+)
Select Granular Granular
Foundation Rock Structural
Total Backfill Rock Backdrain
Fill Backfill
Foundation Fill
(+)
MSE Wall MSE Wall Rockery Wall Rockery Wall
Wall Backfill 2:
Foundation: Backfill 2: Backfill: Backfill 2:
 0.00 0.00 0.00 0.00 0.00

MSE MSE Parapet

(+) (+)
(+) (+) (+)
Common Common
Common Common Common
Backfill Backfill
Backfill Backfill Backfill Total Common
Backfill (+)
MSE Wall Soil Nail Wall Wall Backfill Guard Wall
MSE Wall Front:
Backfill 3: Backfill: Top: Backfill 1:
 0.00 0.00

(+) (+)
Select Granular Granular
Backfill Rock Backdrain
Total Granular
Backfill (+)
MSE Wall Rockery Wall
Backfill 1: Backfill 2: