Water Changes-Galloping Elephants Meet Pouncing Lions

pezenfuego

Active Member
I will begin by accrediting beaslbob for the original idea. His analogy involved galloping elephants, which were used as a general unit of measure. They can be easily replaced with other elements/molecules/levels in the aquarium. Specifically those that we wish to reach 0 (nitrates, phosphates, ammonia, nitrites)
I like the analogy, but I want to get a formula for this. So the question is this: "How important are water changes?" To answer this question we are going to begin with a few assumptions. As we proceed, we will eliminate these assumptions. We start by creating a formula for water changes. To use the formula, you will not need any sort of mathematical ability, but to follow the thread, you will need a very basic understanding of mathematics.
Assumption:
1) The aquarist knows exactly how much water is in their system.
2) The aquarist has constant husbandry
3) Galloping elephants are equally distributed throughout the water (if this is not a fair assumption, then we are improperly testing our water for galloping elephants).
4) Galloping elephants increase at a uniform rate (independent of water changes) that can be measured (the important part of this assumption is the increase portion. If they increase in such a way that is not uniform, this does not hinder the overall idea, but will render the formula itself useless).
5) Water changes are the only thing that can remove galloping elephants
.
6) No galloping elephants were in the system to begin with
(This assumption is almost never true, but we will tackle this problem later on)
The bolded assumptions are assumptions that I deem unfair. We will tackle them later. Keep the first bolded assumption in mind. It is the most important part of this thread.
Variables:
n= number of weeks
r= rate that galloping elephants increases each week
w= fraction of water that is replaced each week (0<w<1)
If you know these three variables, you can estimate the CHANGE in your water parameters throughout time and calculate how big of a water change you need to do (assuming r is uniform and positive). Go through this thread and if you get caught, reread it. It should be easy to understand, but may take some effort to follow.
So let's begin by figuring out this series. Here an=the amount of galloping elephants in the tank.
To begin, we know that

Because one of our assumption was that there were no galloping elephants in the water to begin with. So after a week (and before a water change) how many galloping elephants are in the water? That's also easy. The answer is r galloping elephants (as we gain r galloping elephants each week). Next we need to determine what a water change does. Since galloping elephants are equally distributed in the water, then removing w percent of the water will remove w percent of the galloping elephants. So:
forums.saltwaterfish.com/content/type/61/id/365626/">

is the amount of galloping elephants that are removed. So after 1 week and 1 water change, we get:

Now we wait another week. After another week, we have to add an additional r galloping elephants.

And our water change will remove w percent of these galloping elephants:

And the difference is:

This form looks a little different than our a1 value, but we can rewrite it like this:

Recall that n is the number of weeks. We want to find a formula for any number of weeks. Then it becomes obvious that the general form of this is:

By plugging in 1 and 2, we see that this checks out for those values. This is the simplest form, but not the easiest to work with. So we revert a little bit. After doing that, we want to see if we can find a value for an that does not include an-1. We do this because an-1 is very difficult to work with.

Now, we want to represent this as a summation.

We don't want this as a summation though, we want this as an equation that we can easily plug values into. So we use the geometric series formula:

I will not provide a proof for this here. It is unnecessary and can be found easily online. It is important to note 2 things about this:
1. The variables that are usually used to represent this are a and r. However, because we are already using this variables, b and p are used to simplify things.
2. This is only true where the absolute value of p is less than 1. Since p is equal to 1-w and since w cannot be greater than or equal to 1 or less than 0, this does not present a problem (unless you attempt to plug in 0 for the value of w. If this is the case, you will have to take a limit. Fortunately, calculating these values without water changes is so easy, you don't need the formula in the first place).
But you will notice that our summation is different from the one we need to use. So we change it a little. This can be done in your head pretty easily:


We know that to be true as shifting k=1 to k=0 forces us to shift the value of n to n+1 in the equation. But if we just leave it like that, then our series will end with the term r(1-w)^(n+1). That is not a good thing. We don't want that. So we must end our series at n-1 such that the last term is r(1-w)^n. Now that's what we want. So we have this equation, but it still isn't quite right because we can't evaluate that n+1. So we have to pull out a (1-w).

And we check it to make sure that what we did was valid:

Well, that's the same as before, so we're good.
Now we have this in the form we need it in and can evaluate it using the geometric series.

So there is the formula...Let's test it (using something other than galloping elephants-how about nitrates?)
Ex:
1. A nitrate increase of 7 ppm per week
2. Over the course of 3 weeks
3. Doing a 20% water change per week (note that it may be easier to convert this to a fraction- e.g. 1/5)
And it comes back with...13.664 ppm
Is this reasonable? Well, let's assume that we don't do any water changes (ie w=0). If this was the case, then we would simply have r*n as our value. So we would end up with 21 ppm of nitrates. So the water changes reduced this but not by a whole lot.
So we are done with the first portion of the problem, but a big hole still remains. This only works when we don't have any galloping elephants to begin with. That is almost never the case. So we have to move on to part two.
Part 2
We will now tackle assumption number 5. Before we assumed 0 initial galloping elephants and a linear increase in galloping elephants (r). Now let's reverse that. We begin with some initial value of galloping elephants and assume that there is no increase in galloping elephants. Let's define our variables.
v=initial value of galloping elephants
w=percent water change
n= number of weeks
So the reduction of galloping elephants is given by:

and of course the initial value of galloping elephants is v, so our equation after 1 week becomes:

So we look at the first few terms:

And the pattern becomes clear very quickly (as it is similar to the other one):

Then we test this to see if we get the same thing for the first few values.

We do! This is our equation. It is much simpler than before.

Now let's test this.
w=25% or (1/4)
v=30ppm nitrates
n=5 weeks
50/height/700" />
Here we see that the nitrates were reduced significantly in this five week period. We also notice that it will take an infinite amount of time to reach 0 and that we reduce it by less and less each time. Just something to note. So now the hard part comes. How do we take these two different equations and combine them so that we can determine the value of nitrates in the water with both a rate of increase and an initial value.
So how do we do that. It must be complicated, right?
Wrong, we just add the two equations. How do we justify that? Think about it. It is difficult to explain, so I'll just say this:
What is different about the galloping elephants that were in the tank initially and the galloping elephants that showed up over the course of time? The answer is nothing. So we can consider them together.

We have our formula. Since we did a lot of work and there is tons of room for error, let's test this for values that we know. Let's test to see what happens when we do a 100% water change.

That makes sense. If we do 100% water changes, we should expect to have no galloping elephants in the water.
Now, we could test this for 0, but that wouldn't work because we decided to use the geometric series and that dictates that w cannot be 0.
So we could either find the limit as w approaches 0, or evaluate it for a very small value (a cop-out)
First let's define a few values.

Plugging in these values we get:
34.89
Now, if we did a 0% water change each week, we would expect that the value for our galloping elephants would be the initial value plus the rate times the amount of time (n) that passes. In essence (rn+v) or (5*4+15) or 35. That means that this equation is correct. Now let's test it for some real values.

And we get 10.27ppm nitrates
Another question that might come up is "What if I don't do weekly water changes?" This same formula can be applied to daily, weekly, biweekly, etc. water changes. The units must be the same, but otherwise it will work. For example, if r is in terms of a day, then n must also be in terms of days.
Does this reflect reality? The answer to that is no. Why does it not reflect reality? We need to go back to the assumptions:
1) Galloping elephants increase at a uniform rate (independent of water changes) that can be measured
2) Water changes are the only thing that can remove galloping elephants.
3) No galloping elephants were in the system to begin with
.
We can eliminate assumption 3 because we have already handled it. Now, we assumptions 2 and 3 cannot be dealt with. There is no way to deal with the other two. Does that render everything we just did useless? No, it doesn't. Remember the point of this thread was not to create a formula that can predict galloping elephant levels throughout time. The point of this thread was to examine how useful water changes are. We can still achieve this goal even with our faulty assumptions. We can combine the two assumptions and realize that if we assume nothing else can remove galloping elephants, then (r) can only increase or be 0. That is the important bit, we don't particularly care if galloping elephants increase at an exponential or geometric rate; and we don't care if these rates are constant. As long as they are increasing, we can trudge on.
Okay, so let's examine the second assumption more closely. We do this by taking our formula and seeing what the value for an is after an infinite number of weeks. In other words, our question is "Will my galloping elephant count ever reach 0 with water changes?" We do that by taking the limit of the equation as n approaches infinity.
Just by looking at the equation, it appears as though an approaches infinity, but that is not the case. Let's look at this rule:

This is true, and somewhat intuitive. Now let's look at this for (1/a)

Basically what this proves is that when a is greater than 1, the answer is infinity. But when a is a fraction, the answer is 0. The value that we are raising to the power of n is (1-w) and we know that w is between the values of 0 and 1, so we look at how (1-w) behaves:

Interestingly, it behaves the same was as w and more importantly, it behaves the same way as (1/a)

So that proves this:
"https://forums.saltwaterfish.com/data/9/98/980fcbbc_33.gif
Now we have an equation for this and there are two things that I want to recognize. The first is that this equation does not rely on the value for v. That is important to realize and it shows that water changes do help the system. The question then becomes, at what values of w will we end up with 0 galloping elephants?

We will only get to 0 galloping elephants when we do 100% water changes. But that is not entirely true as it relies on this assumption:
Water changes are the only thing that can remove galloping elephants
What have we mathematically proven? Simply put:
In order to get our galloping elephant count to 0, we cannot rely solely on water changes.
Here is where the analogy gets extended. If we cannot rely solely on water changes, then what do we for our system? The answer is to add pouncing lions
to our system to eat the galloping elephants.

What are pouncing lions? Pouncing lions is an analogy for anything except water changes that can remove galloping elephants. Things things include, but are not limited to, protein skimmers (perhaps aided by vodka or vinegar dosing), turf scrubbers, natural and chemical filtration, macroalgae, and deep sand beds.
These things have the potential to get your galloping elephant count to 0 and water changes can help.
It is also worth mentioning that there are other chemicals in the aquarium which cannot be considered galloping elephants (sodium, potassium, calcium, etc). These things can be thought of as the opposite of galloping elephants. We want them in our tank and our tank consumes them. That is the extent of the galloping elephant analogy. Water changes are important to keep these levels in balance, but if we flip the idea, it logically follows that eventually we will have to add these elements via dosing. But we cannot dose for everything, which renders water changes essential. It also shows that in order to keep your system in balance indefinitely, a very large water change (much closer to 100% than your regular water changes) is essential on occasion. How often you do this is dependent on your system. Perhaps you will never need to do this as your levels will never fall below what is acceptable in your lifetime.
-Cameron
 
S

smallreef

Guest
PEZ... please take my calculus class for me because NONE of that made any sense..until your explanation and your joking use of Wolfram Alpha (which I LOVE but my teacher would not let us use on tests :( we had to show our work using derivatives)
 

2quills

Well-Known Member
I would probably pay to see somebody actually do this consistently for a few years. I don't know how well it would really help the rest of us as hobbyists since I doubt that most of us here have the discipline or the will to accomplish such things (I know I don't). But it would be pretty sweet to see some real data, tracked from real systems over a period of time and compare the differences.
 

pezenfuego

Active Member
I just realized that wolfram alpha decided my copy and paste tactics were no bueno. That in conjunction with the minor error I found is enough to scrap this thread and do a repost later (or at the very least fix edit it). I did this in haste and was not very clear or thorough. I will also try to make the formulas look nice, clear, and crisp instead of looking like this (((TIDUdjhfne(kd)9Kdkd)))+)-(38rf=)
But another night.
Something else to chew on: The formula assumes that the rate of nitrate/phosphate/ammonia increase is linear and constant. How accurate is this, really? I honestly have no idea. You put in some fish food and at what point does it cease to decay and leach these things (assuming it is not removed)? Would the rate be geometric? exponential? Only experimentation would be able to answer that. The more balanced and habitual the system is, the better this formula will work. Just remember, this isn't to be taken strictly. If it works, then great. If it doesn't, then no big deal. Like a lot of things in mathematics and physics, it does not have to be useful or practical to aid in our understanding of something.
 

flower

Well-Known Member
Quote:
Originally Posted by PEZenfuego http:///t/393267/water-changes-an-extension-to-galloping-elephants#post_3497324
I just realized that wolfram alpha decided my copy and paste tactics were no bueno. That in conjunction with the minor error I found is enough to scrap this thread and do a repost later (or at the very least fix edit it). I did this in haste and was not very clear or thorough. I will also try to make the formulas look nice, clear, and crisp instead of looking like this (((TIDUdjhfne(kd)9Kdkd)))+)-(38rf=)
But another night.
Something else to chew on: The formula assumes that the rate of nitrate/phosphate/ammonia increase is linear and constant. How accurate is this, really? I honestly have no idea. You put in some fish food and at what point does it cease to decay and leach these things (assuming it is not removed)? Would the rate be geometric? exponential? Only experimentation would be able to answer that. The more balanced and habitual the system is, the better this formula will work. Just remember, this isn't to be taken strictly. If it works, then great. If it doesn't, then no big deal. Like a lot of things in mathematics and physics, it does not have to be useful or practical to aid in our understanding of something.

.....aid in understanding????????????????? I have never been more confused in my entire life...
I have decided that I really, really hate math. 100%
 

2quills

Well-Known Member
Pez I think that there are too many variables that come into play for this to really be usefull for any of us. Changes in bacterial populations, growth and harvesting of macro's, filter cleanings, skimmer performance, growth rates of livestock, waxing/wanning of CUC. I dont think that our systems are that linear. Perhaps for short periods of time it could be useful. But I dont see any huge advantage here over test kits and a little common sense.
 

mr. limpid

Active Member
What I know and what I see as result in water changes tells me that, you can do the math or you can see reality. My Polys and Xina start to look sad (staying closed, sagging and shriveled) after 3 weeks of no water changes. The day after a change especially when I do about 30% change vs 20% they are open and very perked up. So something about a water change makes them happy and that is what we are all striving for a happy and vibrant tank.
 

flower

Well-Known Member
Quote:
Originally Posted by Mr. Limpid http:///t/393267/water-changes-an-extension-to-galloping-elephants#post_3497363
What I know and what I see as result in water changes tells me that, you can do the math or you can see reality. My Polys and Xina start to look sad (staying closed, sagging and shriveled) after 3 weeks of no water changes. The day after a change especially when I do about 30% change vs 20% they are open and very perked up. So something about a water change makes them happy and that is what we are all striving for a happy and vibrant tank.
I know we want a happy and vibrant tank. However back in the day...the "goal" for any fish hobbyist was to create a little self sustaining ecosystem. IF
(and I know very few who have managed to do it) a system is actually balanced, everything would do what it is supposed to do...all the way down to the fish feeding on the eggs and algae, so feeding them would even balance out. Such a perfect balanced little ecosystem wouldn't need a thing but some top off water, and if you could create a dome where water that evaporates goes back into the tank you could even do away with top offs.
Nowadays we use anything we can to keep our critters alive and happy (vibrant), which is much better than failing to create the perfect self sustained system, and let everything in the tank die. That being said...the closer we can get to that perfect balanced system, the less back breaking work we have to do to achieve our desire to keep these amazing creatures alive for us to watch and enjoy.
Every tank is different, and for you...a 30% water change keeps everything looking good and healthy. So if it isn't broke, don't fix it. As long as you are able do those water changes, it's all good.
For me, who is no longer able to do the water changes, I use macroalgae to remove the NO3 and PO4 to keep my tank water pristine for my seahorses. We each find what works for us. So our reality (AKA experience) is not the same for everyone. So the math professors, the work alcoholics, the lazy buggers, the disabled, the financially insecure, and the over and under achievers can all have a little piece of the ocean in their homes.
 

beaslbob

Well-Known Member
Thanks to this board for taking my original water change analysis and allowing it to remain. On another forum I posted a similiar thread and they removed the thread thinking I was just being a smart A** or advocating dangerous ideas.
For reference:
https://forums.saltwaterfish.com/t/369985/beaslbobs-water-change-analysis
Although things are not constant or have some constant rate of change, that analysis is designed to hold things constant just for analysis of how effective water changes actually are.
I ran tanks for long time and constantly noticed 100ppm or more nitrates even with a regular water change schedule. So I thought and thought and thought. And even did some spread sheets and series analysis.
But then the light came on.
The analysis is not what happens day to day but rather where does the tank winds up. What do then conditions converge too? Sure we don't have infinite water changes but we can get to a point where the galloping elephants measured before the water changes are within the sensitivity of the test equipment. In other words we measure the same amount.
So the key is what caused that to happen?
Just like in algebra "word problems" there is a "hidden" relationship that makes the problem simple.
That is in order to get the same readings before the water changes, the water change must remove the amount of change between water changes.
So if you change 1/10 of the water, that change must remove the build up between changes. So there must be 10 times the build up. 1/5 5 times, 1/3 3 times and so on.
With no build up and a given amount of galloping elephants in the replacement water, the tank will have that concentration of galloping elephants after an infinite amount of changes.
Because the concentration is linear you can simply add that to the final conditions.
So
amount before water change=(buildup between changes)/(fraction of water change) + the concentration in the replacement water
.
Notice initial conditions are not relevant because we are determing the final conditions.
I think if you do a simple spreadsheet and play with the parameters, you will find that equation is right on.
If you have been doing a 10% water change every 10 days and have say 80 ppm nitrates after a few months, you on average have been building nitrates at the rate of 1ppm/day.
If anyone wants a spreadsheet to play with I can do a simple excel or opoen office and email it to ya.
my .02
 

pezenfuego

Active Member
I have this totally figured out. In fact I was editing the thread when my computer crashed. Are you kidding me? Later tonight I'll have this up. The equation is ugly. Here's a sneak peek.
 

pezenfuego

Active Member
It's funny. This is a simple problem to understand, but the solution is incredibly complicated. I expected to spend a few minutes on this. Boy was I wrong. The thread is finally fixed.
 

2quills

Well-Known Member
Can this be applied to new tanks?
So is this something that really should apply to folks with high nitrates? Cause it almost seems automatic that if I change 5% of my water a week and my nitrate levels won't drop down to target levels that naturally I would start increasing to 10% and so on until they do. Once you reach target level then at that point you know what you need every week. Or are you saying that it changes once you reach target levels?
 

pezenfuego

Active Member
Quote:
Originally Posted by 2Quills http:///t/393267/water-changes-an-extension-to-galloping-elephants#post_3497446
Can this be applied to new tanks?
So is this something that really should apply for folks with high nitrates? Cause it almost seems automatic that if I change 5% of my water a week and my nitrate levels won't hit target levels that naturally I would start increasing to 10% and so on until they do. Once you reach target level then at that point you know what you need every week. Why you tryin to make this so hard on us, Pez? lol
No, it cannot be applied to new tanks as the cycle will screw everything up. This formula needs stability to even work hypothetically. Estimate your increase in a week and throw that 5% into the formula. See what it spits out. That should give you an idea of how much that 5% water change is actually removed. If the number that it spits out is greater than your initial amount, well then you really should consider a larger water change. How much of a difference does 5% make in water changes? Look to the formula. You can find uses in estimation with this. Then you can get an idea BEFORE experimenting. Is experimentation a better method? Yes. But experimentation takes a whole lot more time than plugging numbers into an equation.
I would love to experiment with this formula myself, but as I have one of the smallest tanks on the site, I have a feeling it will be a poor representation.
 

pezenfuego

Active Member
Now I made the equation much more user-friendly!
Here are three easy ways that the equation can be used (check out the last one-it is my favorite)
Here is the equation, simply plug in your values for everything but w and a. What you will end up with is a graph. The graph will show you what your galloping elephant values will be on the y axis compared with your potential water change values on the x axis.
http://www.wolframalpha.com/input/?i...Fw+from+0+to+1
Of course, this can be modified to do even more things! Simply use this link
http://www.wolframalpha.com/input/?i...9%29%2Fw+graph
Plug in the values for all of the variables except two and graph it. This will tell you how one variable effects the other.
Finally, my favorite. Use this formula and plug in everything but n.
http://www.wolframalpha.com/input/?i...9%29%2F%28w%29
What does it do? It tells you the value of galloping elephants that you will eventually reach if you continue the same water change schedule forever. If this number is finite, then things are working in your favor. If the number is infinite, then you need to either increase the size of your water change or do them with more frequency.
 

pezenfuego

Active Member
I have restructured the thread to be more mathematically conclusive and to prove mathematically the original point brought up by beaslbob. I also extended the analogy in a way that I really like.
 
Top