Reef Central Online Community

Home Forum Here you can view your subscribed threads, work with private messages and edit your profile and preferences View New Posts View Today's Posts

Find other members Frequently Asked Questions Search Reefkeeping ...an online magazine for marine aquarists Support our sponsors and mention Reef Central

Go Back   Reef Central Online Community > General Interest Forums > New to the Hobby
Register Blogs FAQ Calendar Mark Forums Read

Notices

User Tag List

Reply
Thread Tools
Old 01/19/2006, 07:20 AM   #26
crumbletop
Registered Member
 
crumbletop's Avatar
 
Join Date: Nov 2005
Location: Nashville, TN
Posts: 4,718
Thanks, Billionzz. I look forward to seeing it!

Jack


__________________
"Misers get up early in the morning; and burglars, I am informed, get up the night before." - GK Chesterton

Current Tank Info: 90 gallon AGA RR. 20 gal sump. 6x54W T5. AquaController Jr.
crumbletop is offline   Reply With Quote
Old 01/20/2006, 08:43 AM   #27
theop
Registered Member
 
theop's Avatar
 
Join Date: Mar 2005
Location: Durham, NC
Posts: 1,493
Here is a new version which crumbletop and I collaborated on. There are quite a few improvements. I had to .zip it because it is 130K, which exceeds the max allowed size for an attachment. PM me if you would like me to email you the .xls file.

1. There is a place to put additives and the quantity used. Under the "Lists" tab, these can be customized.

2. The normal ranges for each water parameter are now listed under "Lists" and can be customized. Values outside of this range are highlighted in yellow to indicate undesirable levels.

3. Related to #2, you can choose the units of temperature (F or C) and alkalinity (dKH or meq/L) via a drop-down list on the column header units. This will change the normal ranges to the indicated units.

4. There is some basic data validation now, such as checking for numbers in appropriate fields.

5. You can delete a column if you never test for that item.

Let us know what you think and if you have any suggestions.


theop is offline   Reply With Quote
Old 01/20/2006, 09:05 AM   #28
theop
Registered Member
 
theop's Avatar
 
Join Date: Mar 2005
Location: Durham, NC
Posts: 1,493
Oops forgot to put the attachment on. This is the .zip version:


Attached Files
File Type: zip aquarium3.zip (13.5 KB, 174 views)
theop is offline   Reply With Quote
Old 01/20/2006, 01:38 PM   #29
theop
Registered Member
 
theop's Avatar
 
Join Date: Mar 2005
Location: Durham, NC
Posts: 1,493
Here is the "new" new version, with no real changes except being renamed and some instructions on changing the values of the normal ranges.

The Zipped file is attached.
You can download the excel file here.


Attached Files
File Type: zip reefaquariumlog.zip (13.7 KB, 217 views)
theop is offline   Reply With Quote
Old 01/20/2006, 06:31 PM   #30
abfleck
Registered Member
 
abfleck's Avatar
 
Join Date: Oct 2004
Location: Lake in the Hills, IL
Posts: 3,773
Nice Work.....I may use it!


__________________
((((((((((((((((29 Gallon Reef, 10 gallon sump/Fuge, Tunze Nano Skimmer, Precision Marine media reactor, 250 watt MH with XM 20K and two VHO actinics)))))))))))))))))0

Current Tank Info: 29 rr
abfleck is offline   Reply With Quote
Old 02/27/2006, 02:41 PM   #31
revnull
Premium Member
 
revnull's Avatar
 
Join Date: Jan 2006
Location: Morgan Hill, CA
Posts: 235
Kicking the dust off of this one.

Great spread sheet! Keep up the good work. Please post any updates you may have/come up with.

Thanks!


__________________
- Ray

Current Tank Info: Moving from 90g to 30g AIO
revnull is offline   Reply With Quote
Old 02/27/2006, 04:08 PM   #32
crumbletop
Registered Member
 
crumbletop's Avatar
 
Join Date: Nov 2005
Location: Nashville, TN
Posts: 4,718
Thanks for the comments!

Jack


__________________
"Misers get up early in the morning; and burglars, I am informed, get up the night before." - GK Chesterton

Current Tank Info: 90 gallon AGA RR. 20 gal sump. 6x54W T5. AquaController Jr.
crumbletop is offline   Reply With Quote
Old 03/20/2006, 03:52 PM   #33
kabal2
Premium Member
 
kabal2's Avatar
 
Join Date: Dec 2004
Location: North JERSEY 07438
Posts: 1,103
excelent log, i love the update, keep the good work


__________________
Within the beauty of woman....
.... lies the face of God
kabal2 is offline   Reply With Quote
Old 07/12/2006, 07:00 AM   #34
Marti
Registered Member
 
Join Date: May 2006
Location: Arkansas
Posts: 70
This is GREAT! Thank you!


Marti is offline   Reply With Quote
Old 07/12/2006, 08:11 AM   #35
theop
Registered Member
 
theop's Avatar
 
Join Date: Mar 2005
Location: Durham, NC
Posts: 1,493
Thanks for the bump!

I am glad this is useful to people. If you have any suggestions about how to make it better, please PM me or crumbletop.


theop is offline   Reply With Quote
Old 06/03/2007, 02:19 PM   #36
revnull
Premium Member
 
revnull's Avatar
 
Join Date: Jan 2006
Location: Morgan Hill, CA
Posts: 235
Have there been any updates on this project?

Thanks!


__________________
- Ray

Current Tank Info: Moving from 90g to 30g AIO
revnull is offline   Reply With Quote
Old 06/03/2007, 06:45 PM   #37
crumbletop
Registered Member
 
crumbletop's Avatar
 
Join Date: Nov 2005
Location: Nashville, TN
Posts: 4,718
You bet!

I added automatic calculations for Randy's 2-part. The calculations are the same that are used on the reef chemistry calculator (http://jdieck1.home.comcast.net/chemcalc.html). I use this for my own tank and it works fine. If you don't already use 2-part, I'd exercise caution. I got the calculations from jdieck, who I think got them from Randy Holmes-Farley.

I think I also added tabs for logging corals and other inhabitants -- I can't really remember if that was in the old spreadsheet or not...

Disclaimer: If you do decide to use the 2-part calulation feature, double check the calculations against the web calculator. Use the feature at your own risk. The only reason I mention this is you need to be careful dosing 2-part, and I don't want you to blindly trust the spreadsheet.

Here is the link to the latest spreadsheet:

http://bellsouthpwp2.net/c/r/crumble...uariumLog3.zip


__________________
"Misers get up early in the morning; and burglars, I am informed, get up the night before." - GK Chesterton

Current Tank Info: 90 gallon AGA RR. 20 gal sump. 6x54W T5. AquaController Jr.
crumbletop is offline   Reply With Quote
Old 06/04/2007, 10:42 PM   #38
PatMayo
Registered Member
 
PatMayo's Avatar
 
Join Date: Sep 2005
Location: Seattle
Posts: 2,843
Quote:
Originally posted by Konadog
Hear's another one I use:

http://www.infinitysoft.net/
I used to use that one all the time but it is not compatible with Vista. I was forced to go to an excel sheet.

The updating for that product does not seem to be too good.

I really liked the product so it's a shame it's not compatible with Vista?

Regards,

Pat


__________________
90 AGA Megaflow (Setup 1-24-06)
120 Lbs. Liverock
EuroReef RS 100 Skimmer
2 X 150 MH
2 X 96 watt PC Actinic
2 Clarki Clowns (31 months old)
1 Niger Trigger (Owned 6 months)
2 Tunze 6055 PH

Current Tank Info: 90 AGA Megaflow To Be Mixed Reef
PatMayo is offline   Reply With Quote
Old 06/04/2007, 10:54 PM   #39
PatMayo
Registered Member
 
PatMayo's Avatar
 
Join Date: Sep 2005
Location: Seattle
Posts: 2,843
Quote:
Originally posted by crumbletop
You bet!

I added automatic calculations for Randy's 2-part. The calculations are the same that are used on the reef chemistry calculator (http://jdieck1.home.comcast.net/chemcalc.html). I use this for my own tank and it works fine. If you don't already use 2-part, I'd exercise caution. I got the calculations from jdieck, who I think got them from Randy Holmes-Farley.

I think I also added tabs for logging corals and other inhabitants -- I can't really remember if that was in the old spreadsheet or not...

Disclaimer: If you do decide to use the 2-part calulation feature, double check the calculations against the web calculator. Use the feature at your own risk. The only reason I mention this is you need to be careful dosing 2-part, and I don't want you to blindly trust the spreadsheet.

Here is the link to the latest spreadsheet:

http://bellsouthpwp2.net/c/r/crumble...uariumLog3.zip
Very nice. You could also use graphs and look at your parameters over time which would give you a more grapical look at the data. That would be easy to do as well.

Very nice work.

Regards,

Pat


__________________
90 AGA Megaflow (Setup 1-24-06)
120 Lbs. Liverock
EuroReef RS 100 Skimmer
2 X 150 MH
2 X 96 watt PC Actinic
2 Clarki Clowns (31 months old)
1 Niger Trigger (Owned 6 months)
2 Tunze 6055 PH

Current Tank Info: 90 AGA Megaflow To Be Mixed Reef
PatMayo is offline   Reply With Quote
Old 06/05/2007, 12:51 PM   #40
crumbletop
Registered Member
 
crumbletop's Avatar
 
Join Date: Nov 2005
Location: Nashville, TN
Posts: 4,718
Quote:
Originally posted by PatMayo
Very nice. You could also use graphs and look at your parameters over time which would give you a more grapical look at the data. That would be easy to do as well.

Very nice work.

Regards,

Pat
I'd add the graphs if I knew how. Simple ones are easy, but simple isn't user friendly enough

What I'd like to do is have the normal range highlighted across the graph for a particular component, based on the ranges set by the users in the "lists" tab of the spreadsheet. Then graph using a line graph the actual measured values. I can get the normal ranges to show up, or the measured values, but I'm not enough of a graphing wizard to figure out how to combine them.


__________________
"Misers get up early in the morning; and burglars, I am informed, get up the night before." - GK Chesterton

Current Tank Info: 90 gallon AGA RR. 20 gal sump. 6x54W T5. AquaController Jr.
crumbletop is offline   Reply With Quote
Old 06/05/2007, 02:34 PM   #41
theop
Registered Member
 
theop's Avatar
 
Join Date: Mar 2005
Location: Durham, NC
Posts: 1,493
I've done a good bit of excel graphing, so I'll take a look at it when I have some time.


theop is offline   Reply With Quote
Old 06/05/2007, 02:59 PM   #42
HPD Turbo
Registered Member
 
HPD Turbo's Avatar
 
Join Date: Apr 2007
Location: I really dont know
Posts: 569
Very nice!!


HPD Turbo is offline   Reply With Quote
Old 06/05/2007, 08:23 PM   #43
crumbletop
Registered Member
 
crumbletop's Avatar
 
Join Date: Nov 2005
Location: Nashville, TN
Posts: 4,718
Thanks, HPD!

Good to hear from you theop.


__________________
"Misers get up early in the morning; and burglars, I am informed, get up the night before." - GK Chesterton

Current Tank Info: 90 gallon AGA RR. 20 gal sump. 6x54W T5. AquaController Jr.
crumbletop is offline   Reply With Quote
Old 06/05/2007, 09:14 PM   #44
fishyface
Premium Member
 
fishyface's Avatar
 
Join Date: Apr 2005
Location: surrey, bc
Posts: 135
i've tried posting the one i've made but i got an error saying that my excel sheet was an invalid attachment. wha's up?


__________________
darryl

Current Tank Info: 120g reef in the making, custom sump and stand. RS250 skimmer, Luminarc minis with 250w aquaconnect bulbs, 4x54w T5's
fishyface is offline   Reply With Quote
Old 06/05/2007, 10:16 PM   #45
Konadog
Master of the 16 hour day
 
Konadog's Avatar
 
Join Date: Feb 2002
Location: East Long Beach, So Cal
Posts: 13,151
Blog Entries: 4
Quote:
Originally posted by fishyface
i've tried posting the one i've made but i got an error saying that my excel sheet was an invalid attachment. wha's up?
It should work as long as it has a valid file extension.

Valid file extensions: txt zip pdf htm doc xls


__________________
Save the Reefs................................................................Save the world!

-Ken

Current Tank Info: Currently tankless, and loving it!
Konadog is offline   Reply With Quote
Old 06/06/2007, 12:23 AM   #46
fishyface
Premium Member
 
fishyface's Avatar
 
Join Date: Apr 2005
Location: surrey, bc
Posts: 135
it is an excel worksheet...but i get the following error when i try to attach the file:

"You have attempted to upload an invalid type of attachment. The valid extensions for attachments are: txt zip pdf htm doc xls"


__________________
darryl

Current Tank Info: 120g reef in the making, custom sump and stand. RS250 skimmer, Luminarc minis with 250w aquaconnect bulbs, 4x54w T5's
fishyface is offline   Reply With Quote
Old 06/18/2010, 02:10 PM   #47
scott26
Registered Member
 
Join Date: Nov 2009
Location: Santa Maria
Posts: 624
Rise from the dead o' thread. Sorry to bring this back up but has there been any imporvments with graphs?


__________________
Tank list:
55 Gallon Mixed (Broken Down), 95 Gallon Wave (Sold), 30 Gallon Cube (Rebuilding), 225 Gallon (Sold), 150 Gallon (Building).

Current Tank Info: 150 Euro Building
scott26 is offline   Reply With Quote
Old 06/18/2010, 02:15 PM   #48
thegrun
Registered Member
 
Join Date: Dec 2008
Location: Garden Grove, Ca
Posts: 17,021
Aquarium Log .xls Try this.


thegrun is offline   Reply With Quote
Old 06/18/2010, 07:19 PM   #49
colotl
Registered Member
 
colotl's Avatar
 
Join Date: Sep 2007
Location: San Jose, CA
Posts: 648
http://www.reefcentral.com/forums/sh...ht=reef+logger

Try this out.


colotl is offline   Reply With Quote
Old 06/18/2010, 09:29 PM   #50
Gangrene
Registered Member
 
Gangrene's Avatar
 
Join Date: May 2010
Location: Fremont, Ohio
Posts: 90
I am an Excel guru(probably one of the top in the country)... Tell me what you want and I'll develop it for you or add bells and whistles as needed. IM me and let me know what you are looking for.


Gangrene is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not 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

Forum Jump


All times are GMT -6. The time now is 11:22 AM.


TapaTalk Enabled

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Powered by Searchlight © 2021 Axivo Inc.
Use of this web site is subject to the terms and conditions described in the user agreement.
Reef CentralTM Reef Central, LLC. Copyright 1999-2014
User Alert System provided by Advanced User Tagging v3.3.0 (Pro) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.