{"id":32,"date":"2018-12-31T11:14:55","date_gmt":"2018-12-31T11:14:55","guid":{"rendered":"https:\/\/www.howtoexcel.info\/Civil\/?p=32"},"modified":"2021-09-29T06:57:53","modified_gmt":"2021-09-29T05:57:53","slug":"earthwork-volume","status":"publish","type":"post","link":"https:\/\/www.howtoexcel.info\/Civil\/earthwork-volume\/","title":{"rendered":"Earthwork Volume Using Simpson&#8217;s Rule"},"content":{"rendered":"<p><span style=\"text-decoration: underline; font-size: 12pt;\"><i>Step by step procedure to find out volume of earthwork using Simpson&#8217;s Rule<\/i><\/span><\/p>\n<p style=\"text-align: justify;\">This article is about using Simpson&#8217;s rule (also known as Prismoidal Rule) to find out the quantity of earthwork by means of contour maps. The procedure is explained here with the help of an example. In the example here below, the map is divided into 6 horizontal and 6 vertical grids each of 5m interval. The reduced levels are given at the intersections. Let us find out the volume of earthwork.<\/p>\n<p><img loading=\"lazy\" id=\"_x0000_i1025\" class=\"aligncenter\" src=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Images\/Contour_Map.JPG\" width=\"339\" height=\"309\" align=\"center\" border=\"0\" \/><\/p>\n<p>Let us first note down the reduced levels in a tabular form.<\/p>\n<p><img loading=\"lazy\" id=\"_x0000_i1026\" class=\"aligncenter\" src=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Images\/reduced_levels.GIF\" width=\"513\" height=\"137\" border=\"0\" \/><\/p>\n<p>A three dimensional view will look like the following.<\/p>\n<p><img loading=\"lazy\" id=\"_x0000_i1027\" class=\"aligncenter\" src=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Images\/Simpsons_rule_Volume_of_Earthwork.jpg\" width=\"469\" height=\"179\" border=\"0\" \/><\/p>\n<p style=\"text-align: justify;\">Suppose the final level for filling is 24.1m. Then the required depth of filling at each point is as given in the table below.<\/p>\n<p><img loading=\"lazy\" id=\"_x0000_i1028\" class=\"aligncenter\" src=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Images\/level_difference.GIF\" width=\"513\" height=\"137\" border=\"0\" \/><\/p>\n<p>The area on the side of each grid can be found out as follows<\/p>\n<p><img loading=\"lazy\" id=\"_x0000_i1029\" class=\"aligncenter\" src=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Images\/area.GIF\" width=\"577\" height=\"137\" border=\"0\" \/><\/p>\n<p>Each side can be considered as a trapezoid. Hence the area of each side<\/p>\n<p><img loading=\"lazy\" id=\"_x0000_i1030\" src=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Images\/Area_of_Trapizoid.JPG\" width=\"154\" height=\"66\" border=\"0\" \/><\/p>\n<p>eg: (0.98+0.97)\/2 x 5 = 4.875<\/p>\n<p>(0.80+0.80)\/2 x 5 = 4.000<\/p>\n<p>Now the volume according to Simpson&#8217;s rule is as follows<\/p>\n<p><img loading=\"lazy\" id=\"_x0000_i1031\" src=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Images\/Simpsons_formula_for_Volume.JPG\" width=\"540\" height=\"61\" border=\"0\" \/><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter\" src=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Images\/Volume.jpg\" width=\"727\" height=\"162\" border=\"0\" \/><\/p>\n<p>eg: (4.875+3.375)=8.25<\/p>\n<p>4 x (4+3.75+3.925)=46.7<\/p>\n<p>2 x (3.575+3.875)=14.9<\/p>\n<p>Total = 69.85<\/p>\n<p><strong>Total earth filling volume = 341.425 x (d\/3)<\/strong><\/p>\n<p><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0=341.425 x (5\/3) = 569.042 M<sup>3<\/sup><\/strong><\/p>\n<p style=\"text-align: left;\">Note: We express thanks to <a href=\"https:\/\/www.e-quantities.com\/volumes.htm\"><span style=\"color: #0000ff;\"> https:\/\/www.e-quantities.com\/volumes.htm<\/span><\/a> for bringing up an error in this page to our notice which now has been rectified. You may download the excel file detailing\u00a0 volume calculation using Trapizoidal Rule <span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.e-quantities.com\/download\/simptrap.xls\">here<\/a>.<\/span><\/p>\n<p dir=\"ltr\"><strong>More Articles in Civil Engineering<\/strong><\/p>\n<p dir=\"ltr\"><span style=\"font-size: 10pt;\">Are Contractors Entitled for Variations in Lump Sum Contracts? &#8211; <a href=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Lumpsum_Variation.htm\"> Read Article<\/a><\/span><\/p>\n<p dir=\"ltr\"><span style=\"font-size: 10pt;\">What is Day Work in Construction Contracts? &#8211; <a href=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Day_Work.htm\">Read Article<\/a><\/span><\/p>\n<p><span style=\"font-size: 10pt;\">How to Calculate Earthwork Volume Using Simpson&#8217;s Rule? &#8211; <a href=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Earthwork_Volume.htm\"> Read Article<\/a><\/span><\/p>\n<p dir=\"ltr\"><span style=\"font-size: 10pt;\">What is Contingency Allowance in a Construction Contract? &#8211; <a href=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Contingency_Allowance.htm\"> Read Article<\/a><\/span><\/p>\n<p dir=\"ltr\"><span style=\"font-size: 10pt;\">What is Clause 14 programme? &#8211; <a href=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Clause14_Programme.htm\"> Read Article<\/a><\/span><\/p>\n<p dir=\"ltr\"><span style=\"font-size: 10pt;\">What is FIDIC? &#8211; <a href=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/What_is_FIDIC.htm\">Read Article<\/a><\/span><\/p>\n<p dir=\"ltr\"><span style=\"font-size: 10pt;\">What is Prime Cost Sum in Construction Contracts? &#8211; <a href=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Prime_Cost_Sum.htm\">Read Article<\/a><\/span><\/p>\n<p dir=\"ltr\"><span style=\"font-size: 10pt;\">What is Provisional Sum in Construction Contracts? &#8211; <a href=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/Provisional_Sum.htm\"> Read Article<\/a><\/span><\/p>\n<p dir=\"ltr\"><span style=\"font-size: 10pt;\">What is TOR Steel? &#8211; <a href=\"https:\/\/www.howtoexcel.info\/Civil_Engineering\/TOR_Steel.htm\">Read Article<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Step by step procedure to find out volume of earthwork using Simpson&#8217;s Rule This article is about using Simpson&#8217;s rule (also known as Prismoidal Rule) to find out the quantity of earthwork by means of contour maps. The procedure is explained here with the help of an example. In the example here below, the map &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.howtoexcel.info\/Civil\/earthwork-volume\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Earthwork Volume Using Simpson&#8217;s Rule&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/posts\/32"}],"collection":[{"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/comments?post=32"}],"version-history":[{"count":19,"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/posts\/32\/revisions"}],"predecessor-version":[{"id":126,"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/posts\/32\/revisions\/126"}],"wp:attachment":[{"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/categories?post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Civil\/wp-json\/wp\/v2\/tags?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}