LHotelUmbraQua
Aquarium Advice Apprentice
I am pondering how substrate and fill levels (Earth & Air) will displace water as I plan a custom tank order.
I want a solid idea of what I really have to work with, so fish:water ratio is optimum. I like math, and Excel, so I created an EZ-fill worksheet (happy to share if you like).
I would love to hear other things I can measure before ordering a tank. (And a good custom builder.
The sheet pictured calculates a tank's usable capacity in gals. (I call it Life-Supporting Cap.*) vs. its actual total capacity, based on:
• its actual interior (my direct L, W, H measures), and
• inches of substrate and fill-level-to-brim
I enter these into the two green cells, the only ones I need to touch once int. L/W:H is noted.
L and W of the interior floor (area), multiplied by total displacement H in inches (earth + air), produces the volume to subtract from your total tank capacity.
Another version allows me to set a Golden Ratio of L to W, and input my Fish Capacity, to determine both the adjusted volume and total actual volume, AND the interior dimensions, and use glass thickness to calculate the exterior.
Questions are welcomed.
Best,
* Maybe “Fish Capacity” is better, since gallons of water and inches of fish are 1 to 1, and that is how some people determine the gallons of tanks they buy.
I want a solid idea of what I really have to work with, so fish:water ratio is optimum. I like math, and Excel, so I created an EZ-fill worksheet (happy to share if you like).
I would love to hear other things I can measure before ordering a tank. (And a good custom builder.
The sheet pictured calculates a tank's usable capacity in gals. (I call it Life-Supporting Cap.*) vs. its actual total capacity, based on:
• its actual interior (my direct L, W, H measures), and
• inches of substrate and fill-level-to-brim
I enter these into the two green cells, the only ones I need to touch once int. L/W:H is noted.
L and W of the interior floor (area), multiplied by total displacement H in inches (earth + air), produces the volume to subtract from your total tank capacity.
Another version allows me to set a Golden Ratio of L to W, and input my Fish Capacity, to determine both the adjusted volume and total actual volume, AND the interior dimensions, and use glass thickness to calculate the exterior.
Questions are welcomed.
Best,
* Maybe “Fish Capacity” is better, since gallons of water and inches of fish are 1 to 1, and that is how some people determine the gallons of tanks they buy.