Earthwork Cut Fill Calculator

The Earthwork Cut and Fill Calculator estimates how much material a grading job moves and whether the site balances. You enter cross-section areas of cut and fill at stations along an alignment, and it computes the volumes between stations by the average end area method, converts between the three volume bases that earthwork uses, and reports whether the cut covers the fill or material must be imported or exported.

It also sizes the haul: how many truck loads the excavation makes, how many working hours those loads take at your cycle time and fleet size, and how many eight-hour days that is.

It works in United States customary units: feet for stations, square feet for cross-section areas, and cubic yards for every volume.

Use it for a quantity estimate and a first look at the mass balance, not as a design. The average end area method is an approximation, and the volume you are paid for depends on the measurement basis your contract specifies.

Purpose and model boundary

This model estimates cut and fill volumes between ordered cross sections, converts bank cut to compacted and loose volumes, reports import or export balance, and estimates truck loads and hauling time. It supports preliminary earthwork balancing for one alignment. It does not create a terrain surface, optimize haul routes, or replace a survey, geotechnical plan, or contractor production estimate.

The spreadsheet remains the calculation authority. The page sends the named inputs to the workbook and presents the returned values, charts, and status without recreating the equations in browser code.

Inputs and units

Governing relationships

For each adjacent station interval i of length Δx_i, the average-end-area method gives separate bank cut and compacted-fill volumes:

V_i = ((A_i + A_(i+1)) / 2) × Δx_i / 27

The division by 27 converts cubic feet to cubic yards. The workbook then applies:

• bank cut: V_cut = Σ V_cut,i;
• compacted fill required: V_fill = Σ V_fill,i;
• cut converted to compacted fill: V_cut,comp = V_cut × k_s;
• net compacted balance: B = V_cut,comp − V_fill;
• import required: max(0, −B);
• export available: max(0, B);
• bank cut needed for the fill: V_fill / k_s;
• loose volume to haul: V_cut × k_w;
• whole truck loads: ROUNDUP(loose volume / T, 0);
• haul hours: loads × t / (60 × n);
• eight-hour haul days: haul hours / 8.

Average cut and fill areas are arithmetic averages over entered stations. The cumulative-net chart adds interval compacted cut and subtracts interval fill in station order.

Calculation sequence

1. The station grid is checked for order and nonnegative areas.
2. Average-end-area cut and fill volumes are calculated for each adjacent interval and accumulated.
3. Shrinkage converts bank cut into its compacted-fill equivalent and establishes the project balance.
4. Swell converts bank cut into loose haul volume.
5. Truck capacity, cycle time, and fleet size convert loose volume into whole loads, hours, and eight-hour days.
6. The charts compare interval cut and fill and show cumulative compacted balance.
7. The workbook evaluates Model_Status in the precedence shown below.

Outputs and interpretation

Net_Earthwork_Balance is positive for compacted surplus and negative for compacted deficit. Import_Required and Export_Available split that signed balance into one-sided quantities. Truck_Loads rounds upward and therefore must be read with Loose_Volume_To_Haul, truck capacity, and the hauling assumptions. Bank_Cut_Needed_For_The_Fill is a conversion benchmark; it does not identify which material is reusable.

Validation and status logic

The workbook evaluates status in this order:

Assumptions and limitations

• Cross-section areas and stations are assumed to be measured on a consistent alignment and datum.
• Average-end-area volume approximates the shape between stations; accuracy depends on station spacing and terrain variability.
• Cut and fill areas are treated separately and no end-area correction, prismoidal correction, stripping, topsoil, unsuitable material, rock, or over-excavation is added automatically.
• One shrinkage factor and one swell factor apply to all material; moisture, material class, compaction specification, and reuse suitability are not modeled.
• The haul estimate assumes constant truck capacity, cycle time, and fleet availability. It omits queuing, traffic, loading constraints, haul distance variation, downtime, and cost.
• Positive cut balance does not prove that excavated material is acceptable as fill.

Restrictions and non-computing states

This calculator requires nonnegative grid areas and scalar hauling factors, at least one truck, and fixed grid capacity. Rows cannot be added beyond the workbook's twelve-station extent. The workbook additionally requires strictly increasing stations, a positive volume basis, positive shrinkage, and positive cycle time. Protected formulas may display zero during an invalid state; those values are not quantities to use.

Errors and warnings

A rejected entry means the submitted values did not satisfy the published input rules and no workbook result was made. A workbook NOT VALID status identifies unusable geometry or hauling assumptions. A CHECK status is a completed calculation with import demand or a relatively large surplus that deserves grading and material review. A connection or calculation-service failure is an availability problem, not an earthwork conclusion.

The workbook derives its relations rather than reproducing any table, chart or figure from a specification, standard or agency publication. The volume method is the average end area formula, and the shrinkage and swell conversions are simple ratios applied to it.

• Federal Highway Administration, Federal Lands Highway. Project Development and Design Manual, Earthwork Design, which directs use of the average end area method V = L (A1 + A2) / 2 and notes its approximation and curvature limitation. https://highways.dot.gov/federal-lands/pddm/dpg/earthwork-design
• Wikipedia. Cut and fill, for the mass balance vocabulary. https://en.wikipedia.org/wiki/Cut_and_fill

Shrinkage and swell factors shipped with the workbook are illustrative and carry no authority. Real values depend on the material and on the compaction specified, and must come from geotechnical data for the site. Truck capacities and cycle times are yours to supply.

Additional source notes migrated from Methodology

The governing volume relationship is the average-end-area method. The delivered audit uses FHWA Federal Lands Earthwork Design guidance as the authoritative reference and records an independent cut-and-fill calculator as a comparator. Survey data, geotechnical requirements, and project specifications govern actual quantities.