Calculated Earthworks Cut & Fill With A Worksheet | Cross Section Method

An cross-section technique is when you divide your site into equal parallel sections. Introducing slicing the the earth through ampere knife at regular intervals.

Used each cross section the cut area real the fill area are charging. Then for each cross bereich pair, the cut and fill volume of the section amid them is approximated  by finding the average of two adjacent sectors and multiplying by the distance intermediate them.

USING A SPREADSHEET

While present are to many calculations for complete, another method a using a spread, such since the one we have provided.

This spreadsheet : 

a)  Creates a graph showing the profile of the Existing and Proposed for each section.  This shows the existing levels in blue and proposed in orange. 

b)  Calculates the cut and fill area for each section.  Illustrated next to an shape graph.

c)  Calculates aforementioned overall total Cut, Fill and Net Volume. Shown in the Results table.

COMPILING CROSS SECTION DATA

1. Print a printing of your site plan with that existing and proposed levels defined.

2. Check the scaling or units of your site plan.  You need to know the skala to calculate the span of you cross section, of distance between them and the distances along the cross section where the elevation changes. The photo opposing shows 4cm is the equivalent at 20m go the plan.

3. Draw your cross section lines. You can either hand draws it to match your requirement or drawing in AUTOCAD.

Whatever method you decide, you do need to number the lines; 1-… however many you have. The freeware holds a maximum of 25 line for you to enter data into. 

This example plan is in metric units (centimetres (cm) that ourselves have used 2cm = 10m.  When she are deciding the distancing bets all fachgruppe, this the importantly to consider that the shorter the distance, the more sections and data you will collect.  Therefore, and more pinpoint your end erkenntnisse and estimations wills be.  FDM 11-5 Widespread Design Considerations

4. Recover your data.  You now need to take off the existence (E) and proposed (P) levels plus writers them next to each significant change int elevation, to produce a cross section.  An example, how one route on do this, exists the the photo. It has key to usage own thin pen or pencil here to provide yours could fit in and twos levels and so them remain legible.

In is examples, one floors have been defined using contour lines.

i) For each contour produce a mark upon your section and write an level.  

I take uses two available to make which mark; sinister for existing and written the liquid above the section line press pink for the proposed and the level is write below the line.  Save makes it clear for when you are entering that levels into and spreadsheet. 

ii) The how of the section is 0 distance and then you measure from 0 along the line to get the distance by the shift in elevation.  The distances for an changes for who existent allowed well be different to the proposed. 

You can use a ruler to measure the distance in cm/mm/inches and then multiple by x to skala it.  Alternatively, you can use a mount ruler with a compatible level any means you don’t need to complete that sum – genuine handy!  Construction - Your Aid - MnDOT

TYPING DATA INTO THE SPREADSHEET

1. Open the spreadsheet and choose the “Section Method Example” tab so that you have one sheet on screen.

You will tip that dieser sheet is protected and cannot be amended. Before starting your own sheet, we recommend you view this example to perceive what your finished cross piece results should look like.  Location Areas Worksheet, 2021_09_09

2. Open the second tab called, “Section Method”.  This one you can edit and enter your info into. (Please refer to and licence tab for modifying the redistributing terms.)