The purpose of the first tab "Pipe and Tank Dimensions" is to ensure the volume and the surface area of the water tank is greater than that of the pipe. This is to ensure that I am seeing the impact of the pipe getting slowly more dirty over time and not the tank.
Pipe Dimensions
- Pipe volume/m^3 = pipe surface area/m ^2 * pipe length/m
- Pipe surface area/m ^2 = PI() * pipe radius/m ^2
- Pipe total internal surface area/m^2 = PI() * (pipe diameter/m / 100) * pipe length/m
Tank Dimensions
- Tank volume/m^3 = height/m * width/m * length/m
- Tank surface area/m^2 = (2 * tank length/m * tank width/m) + (2 * tank length/m * tank height/m) + (2 * tank width/m * tank height/m)
Example
A 3" (0.0762m) diameter 10m long pipe has the following:
- Pipe radius/m 0.0381
- Pipe surface area/m^2 0.004560367
- Pipe volume/m^3 0.045603673
- Pipe volume/l 45.60367312
- Pipe total internal surface area/m^2 2.393893602
Required Water
The second tab "Required Water" is to calculate the amount of water needed per day to ensure my rig functions.
A 3" (0.0762m) diameter 22m long pipe with a 3 day water age, a 0.1ml/s leakage rate and a 0ml/s trickle drain rate has the following:
- Rig capacity (130l) / no. days (3 days) = 43l/day - leakage/day (0.1ml/s * 86.4 = 8.64l/day) = ~34l/day
- Rig capacity/l 130
- Required water for turnover/l/day 39.48269362
- Required water for turnover/l/hour 1.645112234
- Required water for turnover/l/s 0.000456976
- Required water for turnover/ml/s 0.456975621
