Work out the excavation volume

Rules

Prismoidal formula

Exact for sloped pits with plane faces. Worked out from the base, middle and top section areas.

Average end area method

The mean area of two consecutive cross-sections times the distance between them; along a line of many sections, the pairs are added up. Common for roads and channels.

Slope

Entered as horizontal : vertical; 1 means 1:1, opening 1 m on each side for each metre of depth. 0 is a vertical side.

Working margin

Width added to each side of the base; blank means 0. The item description or the technical specification sets it.

No rounding along the way

Lines and total are worked out with exact values; only the figure on screen is rounded: m, m², m³ and kg to 3 decimals, tonnes to 6. A copied value carries 8 decimals. A quantity rounded along the way leaves a gap that turns into money once multiplied by the unit price.

Deduction lines

Each thing to deduct goes on its own line, marked as a deduction; the sheet counts it negative. If the deductions exceed what was added, no total is given.

Measurement rules come from the item description

The "Measurement" clause of the item description and the technical specification decide which voids are deducted and how intersections are measured. The tool applies no void threshold and deducts no intersection by itself.

Copying for Excel

The sheet is copied with its header, lines and total as tab-separated text. Numbers use the page's decimal mark and no thousands separator; deductions carry a minus sign.

• Price IndicesDomestic PPI sub-indices and CPI, monthly tables since 2012.
• Price Adjustment CalculatorPrice adjustment with the official formula, from Domestic PPI and CPI.
• Progress Payment Deductions CalculatorThe cover's VAT, every deduction from a) to k) and the net amount paid to the contractor, on one sheet.
• Index Change CalculatorHow Domestic PPI and CPI moved since your tender month, with the In/Io ratio.
• Work Experience Update CalculatorWhat a work experience certificate counts for in the tender you enter, with the right Domestic PPI months for its kind.
• Stamp Duty CalculatorThe 9.48 per mille stamp duty on a progress payment, with the yearly cap.
• VAT Withholding CalculatorThe VAT withheld on a progress payment, at the communiqué's rate for the work type.
• Withholding Tax CalculatorWithholding tax on a multi-year construction payment, at the rate for the work type and payment month.
• Performance Bond CalculatorThe performance bond on a bid, with the below-limit 9% rule and additional bonds.
• Minimum Labour CalculatorThe minimum labour to declare for the SGK clearance, the shortfall and its estimated premium.
• Advance Payment CalculatorThe advance, its 30% or one-third cap, the recovery rate and what comes off each progress payment.
• Work Increase CalculatorThe work increase room left under the 20% (unit price) or 10% (lump sum) limit.
• Completion Compensation Calculator5% of the shortfall when work ends below 80%, updated to the acceptance month by Domestic PPI.
• Delay Penalty CalculatorThe delay penalty from the first contract price, daily rate and days late, with the 15% cap.
• Work Duration CalculatorCompletion date from the site handover, days late, final acceptance and payment deadlines.
• Fuel PricesEPDK monthly averages by fuel type, for the fuel coefficient of a price adjustment.