Automated Materials List
The final goal of the Automated Materials List is to output the total amounts and prices of different materials needed to construct the plant to the user. The final Materials List should act as a rough outline for on-site construction and facilitate the job of the engineers and planners. This program requires inputs from the user and from the design assumptions
to compute the necessary calculations. Currently, the List calculates the total materials needed for construction and various dimensions for different components of the plant.
The output of the [Design Tool] now includes a list of 18 variables comprising the Materials List. Engineers designing plants will now be able see how much material is needed to construct the components of the plant, including the walls of the various tanks and channel, lengths of PVC pipe, corrugated plastic sheets for the lamella, and ferrous cement for the floc baffles. The Materials List is conveniently located at the bottom of the Design Values excel spreadsheet that is returned to the user with all the outputs for the plant. This will allow them to have a better of idea of what is needed to construct an AguaClara plant. The Materials List will continue to be updated based on feedback from the engineers in Honduras so that it provides information that is most useful to them in the construction process.
Materials List Program Algorithm
Automated Materials List Program Inputs
Automated Materials List Program Outputs
Algorithm
The Automated Materials List is designed to give the user an estimate of the materials needed to construct the plant based on the input specifications.
The first step in calculating the materials was to determine the geometry of the different components of the plant and which parts of the plant were constructed out of which types of materials (e.g. concrete, ferrous cement, corrugated plastic, PVC pipe). Then the volumes and quantities were calculated from the dimensions used in each components design algorithm.
Entrance Tank
The Entrance tank volume was found using the design specifications from the automated entrance tank design program and the user inputs. The tank's volume is calculated by considering the four walls lengths, widths and thicknesses. The algorithm also accounts for the entrance to the flocculation tank by subtracting the volume of the channel from one of the entrance tank walls.
\large
$$
Vol_
= 2(W_
\cdot T_
\cdot H_
) + 2(L_
\cdot T_
\cdot H_
) - (W_
\cdot W_
\cdot T_
)
$$
Note: the lengths (L.Et) conflict in the two diagrams below. The length in the top diagram encompasses the thicknesses of the walls of the entrance tank, and the length in the bottom diagram does not. To our knowledge, the bottom one is correct.
The total area of the walls of the entrance tank can be found by adding up the areas of the individual walls and consequently subtracting the area of the inlet channel, and the floor area can be found by multiplying the effective width and length of the entrance tank:
Finally, volume of the entrance tank floor is simply the product of the area and thickness of the entrance tank floor:
Flocculation Tank
The total volume for the flocculation tank depends on the width and total number of floc channels and the length of the sedimentation tank. This information, along with the user inputs and design assumptions, provides all the necessary information to calculation the tanks volume.
\large
$$
Vol_
= 2\left( {L_
+ T_
} \right) \cdot T_
\cdot H_
+ 2\left[ {W_
\cdot N_
+ (N_
\cdot T_
)} \right] \cdot T_
\cdot H_
+ (N_
- 1) \cdot T_
\cdot L_
\cdot H_
$$
The total volume of the walls of the flocculation tank depends on the length of the flocculation tank, the thickness of the plant wall, the height of the flocculation tank, the number of flocculation channels, and the width of the flocculation channels. Since the thickness of all walls in the flocculation tank are the same (T.PlantWall), the area of the flocculation walls is simply the quotient of volume of the flocculation walls and the thickness of the plant wall:
The area of the floor of the flocculation tank depends on the length of the flocculation tank, the thickness of the plant wall, the number of flocculation channels, and the width of the flocculation channels. The volume of the floor of the flocculation tank is simply the product of the area and thickness of the floor:
The volume of the floc baffles is dependent on the width of the channels, the thickness of the baffle, the length of the baffle, and the number of baffles per channel. The number of baffles per channel is a calculated variable based on the length of the flocculation tank and the perpendicular spacing between baffles, which differs per channel. The baffles are also split between upper and lower baffles. Since the floc channel begins with a lower baffle, the equation is set-up so an odd number of baffles results in an extra lower baffle. If there are an X number of floc channels in a floc tank, the N.FlocChannelBaffles, L.FlocBaffleUpper, and L.FlocBaffleLower are X value arrays, which allow us to use a simple dot product to find the total length of the tank's baffles, rather than calculating each channel individually.
\large
$$
Vol_
= W_
\cdot T_
\left[ {L_
\left( {ceil\left( {{{N_
} \over 2}} \right)} \right) \cdot L_
\left( {floor\left( {{{N_
} \over 2}} \right)} \right)} \right]
$$
Inlet and Exit Channels
The volumes of the exit and inlet channels are derived from the user-input dimensions for each component. Using the widths, lengths, and thicknesses of each wall, the volume is computed by direct multiplication. The inlet channel also considers the dimensions of the sedimentation manifold entrance and the number of sedimentation inlet pipes. The quantity that is removed from the inlet channel due to the sedimentation inlet pipes is the volume of a single inlet pipe multiplied by the number of pipes.
\large
$$
Vol_
= (W_
\cdot H_
\cdot T_
) + (W_
+ 2T_
) \cdot T_
\cdot L_
+ 2(L_
\cdot T_
\cdot H_
) - (A_
\cdot T_
\cdot N_
)
$$
Below are two equations for the volume of the exit channel of which the bottom one is, for now, correct, but this may change in the future:
\large
$$
Vol_
= (W_
+ 2T_
) \cdot T_
\cdot H_
+ 2(L_
\cdot T_
\cdot H_
)
$$
The outer surface area of the exit channel depends on the width, length, and height of the exit channel and thickness of the channel wall:
The inlet and exit channels are attached to tanks containing the weirs that connect to the sedimentation tank. Since the plant weirs are being recoded, these equations will change in the future, but for now, these dimensions were calculated to be built around the nominal diameter of the plant weir and the spacing required between the elbows.
\large
$$
Vol_
= {2(S_
+ 3ND_
+ T_
) + 2(4ND_
+ 3S_
+ T_
)} \cdot H_
\cdot T_
$$
\large
$$
Vol_
={2(S_
+ 3ND_
+ T_
) + 2(2ND_
+ 2S_
+ T_
)} \cdot H_
\cdot T_
$$
The total length of weir pipes in the inlet and exit channel tanks is derived from the user-input values that are found upon calculating the necessary height of the pipe for the determined water velocity. This height multiplied by the number of weir pipes yields the total length of pipe necessary.
\large
$$
L_
= 2 \cdot H_
$$
The inlet channel is also attached to drop chimneys that run to the sedimentation tank. These chimneys are rectangular blocks of concrete molded around a pipe, to leave a hole for the water to flow through. We first calculated the volume of this pipe based on it's diameter and the height of the chimney. The height of the chimney is equal to the height of the sedimentation tank minus the inlet channel and wall and also accounting for the space at the bottom of the sedimentation tank for the sludge drain.
The volume of the inlet chimneys was then determined by calculating the volume of the rectangular block of the chimney, subtracting the calculated volume of the pipe and finally, multiplying by the number of chimneys, which is based on the number of sed tanks and sed bays.
\large
$$
Vol_
= N_
\cdot [W_
\cdot (W_
+ T_
) \cdot (H_
- H_
- T_
- H_
- T_
) - Vol_
]
$$
Sedimentation Tank
The volume of the sedimentation tank depends on user-input values. The dimensions of the sludge drain must then be subtracted from the overall volume to account for the design of the drainage system.
\large
$$
Vol_
= 2\left[ {\left( {L_
+ T_
) \cdot T_
\cdot H_
} \right)} \right] + 2\left[ {W_
\cdot N_
+ (N_
\cdot T_
)} \right] \cdot T_
\cdot H_
- (A_
\cdot L_
)
$$
The area of the floor of the sedimentation tank depends on the length and width of the sedimentation tanks as well as the number of sedimentation tanks. The volume of the floor of the sedimentation tank is simply the product of the area and thickness of the floor. There has been some question as to whether the thickness of the inner walls of the sedimentation tank (T.PltWall) and that of the outer walls (T.PlantWall) is the same. Assuming they are not the same, the equations for the area and volume of the floor of the sedimentation tank are as follows:
The volume of the sedimentation inlet slopes is derived from the user input dimensions for the sedimentation slope plate and the slope manifold. There is one inlet slope per sedimentation port.
\large
$$
Vol_
= T_
\cdot L_
\cdot W_
\cdot N_
$$
The total length of launder pipe is dependent on the number of sedimentation tanks and bays, which determines the number of launders. The size of the PVC pipe will depend on the user-input ND.SedLaunder.
\large
$$
N_
= N_
\cdot N_
\cdot N_
$$
\large
$$
L_
= L_
\cdot N_
$$
The launder also requires a coupling to go through the concrete wall of the sedimentation tank. The number of couplings needed is equal to the number of launders in the plant
\large
$$
N_
= N_
$$
The necessary output to construct the plate settlers is the number of corrugated sheets used. This is determined by calculating the total number of plate settlers, how many plate settlers would fit on a given sheet of plastic, and thus finding the total number of required sheets.
\large
$$
N_
= N_
\cdot N_
\cdot N_
$$
\large
$$
N_
= ceil\left( {{{N_
} \over {N_
}}} \right)
$$
The plate settlers are supported by a sedimentation plate frame constructed of PVC pipes running across the width and length of the sedimentation tank. The length of PVC pipe required to construct this module was determining using the dimensions of the sedimentation tank and the center-to-center distance between each parallel pipe.
\large
$$
L_
= N_
\left[ {\left( {{{W_
} \over {B_
}} - 1} \right) \cdot L_
+ \left( {{{L_
} \over {B_
}} - 1} \right) \cdot W_
} \right]
$$
The number of valves and valve couplings needed to drain the tank are found from the sedimentation design specifications with one valve per sedimentation bay.
\large
$$
N_
= N_
= N_
\cdot N_
$$
The flocculation tank and floc hopper valves have yet to be coded, so these will need to be added in the future.
The total wall volume of the channels and tanks is:
\large
$$
Vol_
= Vol_
+ Vol_
+ Vol_
+ Vol_
+ Vol_
+ Vol_
+ Vol_
+ Vol_
+ Vol_
$$