1 Insert the formulas in Worksheet 1 of the Mass Diagram 1 E

1) Insert the formulas in Worksheet 1 of the Mass Diagram 1 Excel workbook (posted on WyoWeb) that are required to determine: a) The average end areas of embankment and excavation between cross sections b) The incremental volumes of excavation and embankment between cross sections c) The mass ordinate at each cross section d) The incremental haul at each cross section e) The total volumes of excavation and embankment, and the total amount of haul for the entire project

Solution

STATION DISTANCE AREA AVG AREA VOLUME EXC EMB EXC EMB EXC EMB 100 32 21 207 107 25 18 28.5 19.5 112.9 77.3 300 93 42 35 33.5 26.5 115.4 91.3 400 100 74 45 58 40 214.8 148.1 498 98 153 121 113.5 83 412.0 301.3 600 102 207 153 180 137 680.0 517.6 651 51 185 132 196 142.5 370.2 269.2 700 49 170 150 177.5 141 322.1 255.9 800 100 132 144 151 147 559.3 544.4 900 100 100 112 116 128 429.6 474.1 1011 111 47 65 73.5 88.5 302.2 363.8 1099 88 35 22 41 43.5 133.6 141.8 1200 101 65 71 50 46.5 187.0 173.9 1300 100 85 61 75 66 277.8 244.4 1400 100 97 62 91 61.5 337.0 227.8 1500 100 115 85 106 73.5 392.6 272.2 1615 115 127 95 121 90 515.4 383.3 1700 85 127 102 127 98.5 399.8 310.1 1795 95 144 113 135.5 107.5 476.8 378.2 1850 55 153 122 148.5 117.5 302.5 239.4