We have built a fountain in our front garden and as part of the structure, there is a fish tank or aquarium at the base. I needed to estimate the volume of water in the tank so that we can accurately estimate the amount of any ammonia and so on that we need to use to keep the tank clean and the fish alive.

Here is my drawing of the tank: not so square and not so rectangular is it?


I needed to use the

  • area of a rectangle
  • area of a circle
  • volume of a cylinder

This involved using two calculations using Pi, the mathematical constant that approximates to 22/7

Here is my spreadsheet:

Screen Shot 2014-08-04 at 17.36.47

I found very easily using an internet search how to convert cubic metres to Imperial Gallons but I wanted to enhance my spreadsheet so that it could be used as a template for other constants. This also explains why you can see Cu M in columns B and D … useful for drawing the two graphs from which you can take the trend line function as I did to calculate the cubic metres of water I was trying to find:

Screen Shot 2014-08-04 at 11.06.04


Screen Shot 2014-08-04 at 11.06.14

I can use the second graph to find the cubic metres in a body of water if I know the Imperial Gallons!

The Pi based formulas are:

area of a circle (please note, each of the circular ends of the aquarium are semi circles!) = PiR^2

= PI()*0.35^2

Volume of a cylinder: there are two of these and the are the foundations of the two fountain units = PiR^2H

= PI()(0.45/2)^20.2

There you are, we have a 215 gallon aquarium that needs careful management now!

Download the spreadsheet from here volume_water_aquarium

Duncan Williamson


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: