Hi All



I am new to Excel.I would like to make a spreadsheet for calculating running processes

Please i need help with the following formula

1. Machine holds 200 litres & pipes hold 150 liters...
2. 1st run-Flow rate through machine is 15000 litres per hour of water & 2nd run-500 litres per hour
3. The water is from a 200 liter tank which has a hose filling it as the level drops .
4. Water is sucked from the 200 liter tank and it goes through the machine and returns back to the 200 liter tank...is is recirculating
5. 3000 litres per hour is lost though as it is thrown out the other end of the machine.Some returns to the 200 liter tank and some is lost out the other end of machine
6. Chemical is added at 2% volume to water amount

I need the formula to calculate please the following
1. How much water will be lost (3000 l/h) out the other end if it runs for 30 minutes at 15000 litres per hour
2. How much water will be lost (3000 l/h) out the other end if it runs for 25 minutes at 500 litres per hour
3. At any one time there is 350 liters in the machine/pipes.How much is 2% solution of 350 liters .
4. As there is a loss out the other end of the machine the chemical strength of 2% will gradually lower.The chemical is circulating (number 4 above) but the strength will lower due to loss out the other end.How do i calculate maintaining the chemical strength at 2% due to losses out the other end of the machine...how much chemical would i need to continue to add (liters) and how often (time between adding)

I started a spreadsheet but need help progressing

Any help with this would be greatly appreciated

Paul
Excel 2010

Attached Files

WATER LOSS.xlsx (10.7 KB, 13 views)