Sponsor Our Community
Go Back   The Reef Tank > Suggestions and Feedback for The Reef Tank
Have a question? It's Free!

Suggestions and Feedback for The Reef Tank A forum for suggestions, feedback and questions to help make The Reef Tank a better place for the discussion of Reef/Marine related topics.


Registered Members don't see these ads. Register now it's free!

Reply
 
Thread Tools
Old 06-14-2008, 08:03 PM   #1
tiberus
Plankton
 
Join Date: Jun 2008
Location: Tulsa, OK
Posts: 13

Aquarium Water Tool


I spent this afternoon creating myself an Excel spreadsheet to help me manage my fish tanks, and I thought it might be useful to share it with others. The main thing it does is provide graphs to help keep track of water quality compared to water changes.

An added functionality that I built into it is a 'mixing' calculator. For example, let say that the salinity of my fish tank had increased beyond the desired level. I could input the salinity of my freshwater, press the calculate button, and the spreadsheet will tell me what volumes of water I need to mix together. Granted the actual mixing will be rather imprecise, but this will give me the optimum numbers.

Warning though, this spreadsheet uses macros, so you will have to enable excel to allow them to be run. Also, the input cells are colored tourquise; the other cells should be left alone.

Really, I'm just an engineer who enjoys making spreadsheets, but I figured others might find this convenient. If the admins felt this was something others could make use of, I would be willing to provide support if other people have problems using it.

Anyway: enjoy.
Registered Members don't see these ads. Register now it's free!
Attached Files
File Type: zip Water-v2.zip (19.7 KB, 150 views)
tiberus is offline   Reply With Quote
Old 06-14-2008, 10:58 PM   #2
tims
Admin/ Super mod
 
tims's Avatar
 
Join Date: Aug 2003
Location: New Castle, Delaware
Posts: 20,364
Images: 224
very nice thank you!
__________________
Tim
need something to read? just ask me.
tims is offline   Reply With Quote
Old 06-15-2008, 01:48 AM   #3
OneDummHikk
Non-Hypocritical
 
Join Date: Dec 2007
Location: Hillbillyville Alabama
Posts: 8,064
Images: 274
Reviews: 11
That is awesome. I have something similar but it isn't very user friendly. It is a Javascript driven spreadsheet. I could modify it to save user input but I just put them in manually. No graphs from mine though
OneDummHikk is offline   Reply With Quote
Old 06-15-2008, 06:26 AM   #4
Loverotties
I've got the REEF rash!
 
Loverotties's Avatar
 
Join Date: Nov 2004
Location: New Jersey
Posts: 34,114
Good Job!
__________________
Loverotties is offline   Reply With Quote
Old 06-16-2008, 09:54 PM   #5
tiberus
Plankton
 
Join Date: Jun 2008
Location: Tulsa, OK
Posts: 13
One thing I did forget to mention. The sheet is setup assuming weekly water testing. If you do yours more frequently, make sure to change the dates on the "Test Results" tab, or else the calculator won't have the most recent test results.
tiberus is offline   Reply With Quote
Old 06-25-2008, 10:10 PM   #6
PEMfish
Plankton
 
PEMfish's Avatar
 
Join Date: Jun 2008
Location: St.Charles Il.
Posts: 48
If I tested weekly I would really use this alot.
__________________
Paul`EM
PEMfish is offline   Reply With Quote
Comparison Shopping
TetraPond Dynamag 250gph w Fountain Set

As low as $40

at 12 sellers

Salifert Coral Grower 1000 ml

As low as $30

at 3 sellers

Members with more than 50 posts don't see this bar

Impeller Shaft Assembly without Magnet for Magnum 350 Canister Filter

As low as $3

at 11 sellers

Tom Aquatics Algae Scraper 14 inch Short

As low as $8

at 14 sellers

Members with more than 50 posts don't see this bar

Marineland HOT Magnum Filter Sleeve 1pk

As low as $2

at 13 sellers

Cap Fitting - 2 inch FPT

As low as $3

at 6 sellers

Members with more than 50 posts don't see this bar

Coralife Turbo-Sea 790-P Pump

As low as $169

at 16 sellers

SeaGarden Saltwater Artificial Aquarium Decor Sargassum Fluitans Large

As low as $4

at 5 sellers

Members with more than 50 posts don't see this bar

Kordon Ich Attack Disease Inhibitor - 1gal

As low as $38

at 7 sellers

Ecosystem Aquarium Eco Strontium - 16oz

As low as $8

at 35 sellers

Members with more than 50 posts don't see this bar

30 Inch Satellite Dual 2x65W SunPaq with 1 Lunar Light

As low as $84

at 18 sellers

Salifert All-In-One 250 ml

As low as $15

at 3 sellers

Members with more than 50 posts don't see this bar

Caribsea African Cichlid Mix Rift Lake Authentic 20lb

As low as $13

at 9 sellers

36 Inch Nova Extreme T5HO X2 2x39 Watt

As low as $76

at 7 sellers

Members with more than 50 posts don't see this bar

Reply
 
Quick Reply
Reply:
Image Verification
Please enter the six letters or digits that appear in the image opposite.



 
You may also search for:


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Sitemap:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196
Sponsor Our Community

All times are GMT -5. The time now is 03:08 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Our lawyer tells us that, by pressing the "New Thread" or "New Reply" button, you acknowledge that the opinions and information expressed in your article are yours alone and not those of thereeftank.com, dba The Reef Tank. Further, you agree to indemnify The Reef Tank, its moderators, administrators and agents from any and all liability which may arise as a result of your article. (C)opyright 2006 TheReefTank.com
 
close
Sign up for free and join one of the largest communities of saltwater aquarists!
Our members will be glad to help you with anything you need!

Join over 30,000 TRT members!

Email

Email Confirm Email
Username
Password Confirm Password

I agree to the website rules