formulas needed please

[paul_pearson]

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)

Any help with this would be greatly appreciated

Paul
Excel 2010


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=UywjKEMjSp0&lc=UgxIySxHPqM1RxtVqoR4AaABAg. 9edGvmwOLq99eekDyfS0CD
https://www.youtube.com/watch?v=UywjKEMjSp0&lc=UgxIySxHPqM1RxtVqoR4AaABAg. 9edGvmwOLq99eevG7txd2c
https://www.youtube.com/watch?v=SIDLFRkUEIo&lc=UgzTF5vvB67Zbfs9qvx4AaABAg
https://www.youtube.com/watch?v=9P6r7DLS77Q&lc=UgzytUUVRyw9U55-6M54AaABAg
https://www.youtube.com/watch?v=9P6r7DLS77Q&lc=UgzCoa6tOVIBxRDDDbN4AaABAg
https://www.youtube.com/watch?v=9P6r7DLS77Q&lc=UgyriWOelbVnw4FHWT54AaABAg. 9dPo-OdLmZ09dc21kigjmr
https://www.youtube.com/watch?v=363wd2EtQZ0&lc=UgzDQfo5rJqyVwvv2r54AaABAg
https://www.youtube.com/watch?v=363wd2EtQZ0&lc=UgzHTSka7YppBdmUooV4AaABAg. 9cXui6zzkz09cZttH_-2Gf
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgxhXnQ-mWYhrHWuM354AaABAg.9bepnegjnRu9iMmBDtf4m1
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgxFIZ858qf7w_uA9bd4AaABAg.9dKpEpUk3YT9d VEGnka6yj
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=Ugz8oC8iGd6-SPhpaQZ4AaABAg.9bhRt-kPXri9brzh_99JF9
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=Ugz8oC8iGd6-SPhpaQZ4AaABAg.9bhRt-kPXri9bsrQIgXb3L
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzFkoI0n_BxwnwVMcZ4AaABAg
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgxwJDkFskrMW8EpcXt4AaABAg.9bmKMz5-Z1g9bmx0REIz41
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgxhXnQ-mWYhrHWuM354AaABAg.9bepnegjnRu9bmyko2YUvQ
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgxwJDkFskrMW8EpcXt4AaABAg.9bmKMz5-Z1g9bmzpPqfLRD
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzZwbV_Y_7UFzHwNBh4AaABAg.9dKb0Vc7MOB9d VK8si3ont
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=Ugx6Ec_r4kb9EYOVgIt4AaABAg.9dOW613fb8V9d VIJECZIdC
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgwBho9tBLQ4nPVdYqd4AaABAg.9fWvoBWY3Da9g 9cLjhPiaz
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzZy1NAMBx5Uv4U2cJ4AaABAg.9f0XX-_JaGp9g9bYLMZiIy
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgyL-xp8IiiahmQ12kJ4AaABAg.9f7xHCpAEx29g9asFhVFfT
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgxRxyFNNp3WHTzuiJJ4AaABAg.9fFR6ECmXk69g 9afNBcS4Z
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgwsdMh0FGDfvA249_B4AaABAg.9fLR6FHCIVI9g 9aLlUyzog
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgwBho9tBLQ4nPVdYqd4AaABAg.9fWvoBWY3Da9g 9_4422NzK
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=Ugwyy8JXr56HJ8m_od94AaABAg.9gSFgqqJQNV9g TXco41b5l
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgyS8stMz5B9NrpPrbR4AaABAg.9gOjiS0rs8l9g TYl6RldpA
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgyS8stMz5B9NrpPrbR4AaABAg.9gOjiS0rs8l9g TfhAWU9ju
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgyS8stMz5B9NrpPrbR4AaABAg.9gOjiS0rs8l9g TfuYQGmUa
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgyS8stMz5B9NrpPrbR4AaABAg.9gOjiS0rs8l9g Tg3AmMPUc
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgyS8stMz5B9NrpPrbR4AaABAg.9gOjiS0rs8l9g TgEqh5wdo
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgxmUK0S_aZVZWz8-gt4AaABAg.9gLc3DfWfHl9gTZ3y6fL1H
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzZloYeY2wQr7-xTOh4AaABAg.9gB2bbbs9mB9gTZUkNYI8e
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzlM96nGEhW9J1Gpgd4AaABAg.9fmOFVcXZh49g T_8CYeQgz
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[paul_pearson]

Hi

Please see attached spreadsheet.I made some advancement but need further help please to compleete

Any help appreciated

Paul
Excel 2010

[Excel Fox]

So you say 3000L is lost when the machine run flow is 15000L/hr. From what I understand, your first scenario should give 1500L loss since you are running it at the same run flow capacity for half the time, ie, 30 minutes. The formula being (30/60)*3000*(15000/15000)

If this is true, then if the run flow is reduced to 500L, ie 3.3% of 15000L, and for 25 minutes, ie, 41.67% time of 1 hour, then your formula becomes (25/60)*3000*(500/15000), doesn't it? which is ~42L of water loss.

Is this what you wanted?

[paul_pearson]

Thanks
1) equation is correct
2) equation is not.even though it runs at 500L/H it will still lose 25minutes of 3000l/H
3) i have the equation as 350*0.02
4) This is critical to work this formula out
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)

Thank you

[Excel Fox]

For 2, shouldn't (X/60)*3000 work, where X is your minutes?

[paul_pearson]

Thank you
Yes that works

Would you have a solution for
) This is critical to work this formula out
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)