Bradders
Member
Hi All,
I have been developing a simple spreadsheet model which allows you to select your filter media type and the amount of media (inch/3), and it will spit out some values for a) crystal clear stocking levels and b) ammonia-only stocking levels.
This is based on data provided by Dave at Aquarium Science (and scientific data on effective filter media surface area), and I just took his math and created a straightforward spreadsheet. I know some of you have raised concerns with Dave's data on planted aquariums, but I feel his filter sections are very good for obtaining a feel (or at least a consideration) for how to potentially stock your filter. As many of you are acquascapers and planting experts, I understand that the below model will not take into account all the other important factors (plants, substrate, rocks. aeration, flow etc) within the aquarium - nor does it take into account the size of an aquarium and the ethics of fish stocking. But playing around with the figures and different media types is quite interesting.
Does anyone find this interesting? If so, I'll try to brush up my Excel skills a little more and post on here somehow.
BTW - the screenshot below is the output of my Oase Biomaster 250 when I pump the data into the model. (And yes, I did actually measure the cubic inches of media as I am just that sad! 😀)
Regards,
Brad

I have been developing a simple spreadsheet model which allows you to select your filter media type and the amount of media (inch/3), and it will spit out some values for a) crystal clear stocking levels and b) ammonia-only stocking levels.
This is based on data provided by Dave at Aquarium Science (and scientific data on effective filter media surface area), and I just took his math and created a straightforward spreadsheet. I know some of you have raised concerns with Dave's data on planted aquariums, but I feel his filter sections are very good for obtaining a feel (or at least a consideration) for how to potentially stock your filter. As many of you are acquascapers and planting experts, I understand that the below model will not take into account all the other important factors (plants, substrate, rocks. aeration, flow etc) within the aquarium - nor does it take into account the size of an aquarium and the ethics of fish stocking. But playing around with the figures and different media types is quite interesting.
Does anyone find this interesting? If so, I'll try to brush up my Excel skills a little more and post on here somehow.
BTW - the screenshot below is the output of my Oase Biomaster 250 when I pump the data into the model. (And yes, I did actually measure the cubic inches of media as I am just that sad! 😀)
Regards,
Brad
