Skip to content
HidraSoftwareHydraulic calculatorsEspañol
Preferences
Decimal separator
Units by quantity

Units for the inputs, the results and the report checks to start with. You can still change a single input or result afterwards.

All in:
Regional terms

Applied to the calculator and to the PDF report.

Saved in this browser only.

Earthwork volume calculator — average end area method

Cut and fill volumes with a measurement report ready to submit: paste the areas of your cross-sections, get the earthwork quantities and the mass haul diagram, and certify progress against the previous measurement.

Cross-sections

Units

Paste from Excel the columns station, cut area and fill area (onto any cell), or type them. The station can be written as 0+120.50 or as a number. Up to 200 sections.

StationCut area (m²)Fill area (m²)Remove section

Factors (optional)

Swell: loose volume / bank volume (e.g. 1.25). Shrinkage: compacted volume / bank volume (e.g. 0.90). Without them, the volumes are geometric.

Previous measurement (progress certificate, optional)

Load the CSV you exported with the previous measurement, or paste the cut and fill volumes already certified by station. They are matched by exact station.

Results

Paste or type the sections and press “Calculate”.

Volumes by average end areas: V = (A₁ + A₂)/2 · d. Balance = cut − fill.

Calculation report (PDF)

Calculation report with input data, assumptions, development of the formulas, checks and conclusions, ready to attach to your project. It uses the inputs of the calculator above. All fields are optional.

Project details

Shown in the document header. If left empty, the author is used.

Source of the inputs

Where each input comes from: topographic survey, geotechnical study, approved certificate… If left empty, the document states “Input by the Author”.

See a sample report →

The average end area method calculates the volume of each segment between two cross-sections as the mean of their areas times the distance between them. It is the usual method for measuring the cut and fill of linear works and submitting their measurement.

How it works

How to use the calculator

  1. Copy in Excel the columns of station, cut area and fill area, and paste them onto the table.
  2. If you need them, enter the swell and shrinkage factors.
  3. To certify progress, load the CSV of the previous measurement or paste its volumes by station, with the certificate number and period.
  4. Press “Calculate”, review the earthwork quantities table and export the CSV for the next measurement.

Cut and fill

Cut is the ground excavated down to the formation level, and fill is the material that has to be placed. The balance, cut minus fill, shows whether there is surplus material (positive) or a deficit (negative).

Method, mass haul diagram and progress certificates

Volumes by average end areas

V = (A1 + A2) / 2 · d

It assumes that the area varies linearly between sections: the accuracy depends on their spacing. Where the ground changes sharply, take sections closer together.

Swell and shrinkage

Excavated material takes up more space once loose (swell, Fsw > 1) and less once compacted (Fsh < 1). The loose cut is Fsw·V_c, the volume to be hauled; the fill needs V_f/Fsh of material in bank measure.

Mass haul diagram

It accumulates, section by section, the cut minus the fill in bank measure. Where the curve rises, cut dominates; where it falls, fill. Its shape helps to plan balancing, borrow and waste.

Work progress and certificates

With the previous measurement, each segment shows the volume already certified, the progress for the period and the volume to date. Sections are matched by exact station: a new one starts from zero, and one that disappears keeps its previous volume in the total, with a notice in the calculator.

Frequently asked questions

Can I paste the sections directly from Excel?

Yes: copy the three columns (station, cut area, fill area) and paste them onto any cell of the table. Text headers are ignored.

Which station format does it accept?

Notation such as 0+120.50 (kilometre + metres) or numbers such as 120.5. In feet, 100 ft stations (1+20.50).

How do I prepare next month’s certificate?

Export the CSV of this measurement and keep it. Next time, load it as the previous measurement: the calculator works out the progress for the period by station.

Why does it not use the prismoidal method?

Average end areas is the usual method for measurement and progress certificates. The prismoidal method corrects the shape between sections but needs more data; it is not included in this version.

References