Determining The Water Volume Of Your Whole Reef System

Discussion in 'Water Chemistry' started by ReefSparky, Aug 12, 2008.

to remove this notice and enjoy 3reef content with less ads. 3reef membership is free.

  1. KOgle

    KOgle Zoanthid

    Joined:
    May 4, 2007
    Messages:
    1,109
    Location:
    Columbus Indiana
    Reef Sparky for President!!!!!
     
  2. Click Here!

  3. ReefSparky

    ReefSparky Super Moderator

    Joined:
    Nov 27, 2007
    Messages:
    3,675
    Location:
    South Florida

    Thanks for the compliment. :)
     
    1 person likes this.
  4. Orion7_11

    Orion7_11 Plankton

    Joined:
    Sep 6, 2008
    Messages:
    17
    Location:
    Pensacola, FL
    Excel Calculator for the mathematically challenged

    I ran across this thread and forum from a google search for "determining water volume of aquarium" I was wondering the exact thing that Reef Sparky educated us all on. I am very new to SW Aquariums.. I just bought and set up a Bio Cube 29 and I wanted to know this info for running all of the tests and adding the various supplements...

    I come from a strong background in Excel. So, I did all of the calculations for my own system in an excel sheet and that's when it dawned on me that maybe some of you would like to use it as well.
    So, I cleaned it up and made it look a little prettier and I'm sharing with you all.

    Please check it out and let me know if there are any problems... I did not do anything other than use Sparky's logic and calculations so I believe that it is correct.

    I have saved it with ReefSparky's example calculations in the sheet although, I had to make him start with 107 instead of 105 since he rounded up to 100 in his example. My numbers work out the same as his though.

    Total Volume of Water in a Reef System - Calculator

    *If an Admin wants to save it and host it from 3reef.com that is fine by me...just let me know so I can remove it from mine.
     
    Last edited: Sep 6, 2008
    2 people like this.
  5. ReefSparky

    ReefSparky Super Moderator

    Joined:
    Nov 27, 2007
    Messages:
    3,675
    Location:
    South Florida
    Nice work, Orion!! :)
     
    1 person likes this.
  6. techno2

    techno2 Stylophora

    Joined:
    Aug 18, 2007
    Messages:
    959
    Great post and good timing.
    Karma to ya.

    \Cheers
     
  7. Orion7_11

    Orion7_11 Plankton

    Joined:
    Sep 6, 2008
    Messages:
    17
    Location:
    Pensacola, FL
  8. Click Here!

  9. Matt Rogers

    Matt Rogers Kingfish

    Joined:
    Dec 31, 2000
    Messages:
    13,466
    Location:
    Berkeley, CA
    Thanks so much! 8) :beer:

    3reef desperately needs more calculators. I will follow up in a PM to get this here. THANKS AGAIN!!!
     
  10. sparticus

    sparticus Plankton

    Joined:
    Dec 20, 2008
    Messages:
    22
    Location:
    Oxford / UK
  11. Infantry1327

    Infantry1327 Fire Shrimp

    Joined:
    Feb 8, 2009
    Messages:
    309
    Location:
    Cali
    it seems to work, but it doesnt take in account sumps, and refugiums.
     
  12. NU-2reef

    NU-2reef Montipora Digitata

    Joined:
    Jan 27, 2008
    Messages:
    1,099
    Location:
    vancouver, canada
    reef sparky just brought this to my attention. and all i can say is WOW. simply brilliant