Discussion in 'Water Chemistry' started by ReefSparky, Aug 12, 2008.
Join 3reef now to remove this notice and enjoy 3reef content with less ads. 3reef membership is free.
Reef Sparky for President!!!!!
Thanks for the compliment.
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.
Nice work, Orion!!
Great post and good timing.
Karma to ya.
Also posted a web version calculator
For those that don't want to download an excel sheet here is a web based version of the same thing.....
Total Water Volume of a Reef System Calculator
Thanks so much! 8)
3reef desperately needs more calculators. I will follow up in a PM to get this here. THANKS AGAIN!!!
sorry guys iam no expert but found this, maybe one of you guys who is real good at this stuff wants to try it out and see if its very accurate.
it seems to work, but it doesnt take in account sumps, and refugiums.
reef sparky just brought this to my attention. and all i can say is WOW. simply brilliant
Separate names with a comma.