The present case study looks at a situation where we have CUT and LAND only. p>
It would be, for example, the case of the opening of any local road. p>
In this example, it will be easy to understand the Bruckner diagram, which will be M $ Excel b> and Civil 3D Mass Haul Diagram i> tool. p>
Initially, we need a data source, that is, a project where we have Cut and Landfill. Use the drawing that is in the program package in the .dwg / ddm_2012_corte_aterro.dwg b> folder. P>
In it, identify the Sample Line Group i> axis and see its properties: p>
center>
We will only analyze CUT x LAND b>, then delete the other materials from Material List i>. We will have for this project, for example: p>
When tracing the Bruckner Diagram for this project with the CREATEMASSHAULDIAGRAM b> command, we will have: p>
center>
Note that we have a small amount of material. Very well. The The homegeneration used is 1.13. Given this came from the earthmoving guidelines provided by the geotechnical team. p>
If we look again at Material List i> we have: p>
See, for the Brukner diagram to work, all excavated material can be used. That is, there is no mention yet about the quality of the excavated materials. Likewise, all landfills have the same characteristics. This is no longer true in the projects of the Carajás Railroad, which inspired the creation of the program DDM b>. p>
To extract the data from the cross-sectional areas and draw the Bruckner diagram in Excel, you can use the NOTASERV b>, or even the GENERATEQUANTITIESREPORT b> command >
Copy and paste into M $ Excel b> and add the formulas. p>
Well, now passes the distribution phase. In theory, any line drawn horizontally on the Bruckner diagram, balances the cut and embankment if a closed polygon is formed: p>
Here we see a compensation where the cut is close to the landfill: p>
center>
Here, we see a compensation where the cut is far from the landfill: p>
center>
Note the construction of rectangles of equivalent area for determination of the DMTs between the source and the demand. This construction will have to be done as many times as necessary until we indicate all the Source x Demand pairs, with their respective volumes and DMTs. The result of this is what we call the distribution tab. P>
Note that Civil 3D does not offer a practical method for doing this distribution. This is done manually. P>
Yes, you can take the Cut and Land data to Excel, tabulate this data with their respective DMTs, and proceed with the use of Solver. p>
I even encourage you to do this, see an example of what it would look like: p>
center>
Explaining: p>
After the solver resolves the distribution, we see that we will have certain cuts feeding on more than one landfill, for example, C4 b> feeds A2 b> to A5 b> p>
There is only one small detail. I noticed that the solver is limited to 16 bids by 16 claims. So, get over it !!! p>
Bruckner's distribution in Excel will have: p>
Note, these worksheets are in the program folder. You can check the data there. P>
As expected, the graph is the same as Civil 3D p>
But we do not have the distribution yet. p>
Now, let's use the
DDMLINK b> to process the data.
p>
First, go back to Civil 3D. Forget Excel for now. P>
If you have not yet installed, follow the procedures to install . p>
Next, use the command Now , we need to draw the result of the spreadsheet Results b> p>
To do this, we will use the program Final considerations: p>
If you need to sort your materials as first, second, and third categories, you should model this in the sections.
To do this, you will need the polls that generate the points, which give you grants to create the corresponding surfaces.
There, Sample Line Group will have first, second, and third category excavated separately.
p>
In DDM b> the first, second and third category materials can be classified in such a way that the first material
category can go to the body of landfill.
The second, for the initial layer of landfill.
This layer should be modeled in order to quantify
the location and amount to be used.
The third material may be destined to the ADMP, or waiting boot, in order to be taken somewhere to
be crushed and subsequently be used in the superstructure.
This is at the discretion of the designer.
P>
The ddm_2012_corte_aterro.dwg b> files, and also the solver.
Xlsx b> file and the ddm_2012_corte_x_aterro.
Ddm b> file are in the "dwg"
which accompanies the DDM b> program.
p>
DDMLINK b> and click enter b>, to select a Sample Line Group.
i> p>
DDT b>
li>
center>
Note that this gives us the REMANESCENT b>, which appears in the Bruckner tab that is in the Excel file, so
this coefficient 1.13 multiplying.
It is nothing more than the Homogenization Factor b>
li>
center>
li>
DDT b>
li>
Note that these values ??are a trick to circumvent the program.
We will consider all landfills to accept any type of material.
Therefore these values
are such that any material exclusively from the remaining cut serves to
it.
li>
Note that this gives us the HOMOGENIZED REMANESCENT b>, which appears in the Bruckner tab that is in the Excel file, so
this coefficient 1.13 multiplying.
It is nothing more than the Homogenization Factor b>
See what's in the image:
center>
Upgrade Areas b> li>
See that they were filled with the value of the Remaining b> areas of Cut and Landfill, respectively.
li>
Classify b>.
It indicates that you need to sort
the volumes.
In practice it means defining where cuts and landfills begin and end.
Li>
Calculate Distribution b>
center>
li>
center>
li>
That's right, compensation will come in as much as Source b> as Demand b>
li>
center>
Note that this makes the Side Compensation that is on the Sources b> tab only falls within the Side Compensation range that is on the Demands b>
li>
Rank Items b> button and then the
Calculate Distribution b> li>
DDT b> a > p>
DDT b> command.
Select the ddm_2012_corte_x_aterro.
DDM b> li>
Draw b>, insertion point and see the result:
center>
li>
ol>
body>
html>