Reef Central Online Community
Tampa Bay Saltwater

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 > Reef Discussion
Register Blogs FAQ Calendar Mark Forums Read

Notices

User Tag List

Reply
Thread Tools
Old 01/20/2006, 01:48 PM   #1
theop
Registered Member
 
theop's Avatar
 
Join Date: Mar 2005
Location: Durham, NC
Posts: 1,493
Excel Spreadsheet for Reef Aquarium Logging

Member crumbletop and I have developed this spreadsheet to help with keeping a log of tank conditions, water parameters, addtives, and changes in livestock. I've posted it in the "New to the Hobby" forum here, but wanted to share it over here as well. It is fairly simple, but we hope you find it useful. Feel free to give us any feedback or suggestions.

The .zip file is attached, while the unzipped excel is available for download here (too large to attach).

Here are some features which I think make it useful:

1. There is a place to put additives and the quantity used. This list can be customized under the "Lists" worksheet.

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

3. You can choose the units of temperature (F or C) and alkalinity (dKH or meq/L) via a drop-down list on the column title bar units. This will change the normal ranges to the indicated units.

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

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

6. Entries are stored in rows rather than columns to make it easy to enter lots and lots of entries.


Attached Files
File Type: zip reefaquariumlog.zip (13.7 KB, 535 views)
theop is offline   Reply With Quote
Old 01/20/2006, 03:31 PM   #2
andynyc
Registered Member
 
Join Date: Aug 2004
Posts: 216
Great spreadsheet!

But I never learned how to make the top columns remain even when I scroll down... how did you code that?

Thanks.


andynyc is offline   Reply With Quote
Old 01/20/2006, 03:40 PM   #3
theop
Registered Member
 
theop's Avatar
 
Join Date: Mar 2005
Location: Durham, NC
Posts: 1,493
1. Go to Window -> Split. This will split the pane. Drag the panes to the size you want (Move all the way to one side to get rid of that split).

2. Scroll the top window to show the cells you want to keep there.

3. Go to Window -> Freeze Panes.


theop is offline   Reply With Quote
Old 01/20/2006, 03:41 PM   #4
brettandlyndi
Registered Member
 
Join Date: Aug 2005
Location: Fresno, CA
Posts: 142
Very nicely done! Thank you for sharing.


brettandlyndi is offline   Reply With Quote
Old 01/20/2006, 04:06 PM   #5
crumbletop
Registered Member
 
crumbletop's Avatar
 
Join Date: Nov 2005
Location: Nashville, TN
Posts: 4,718
andynyc,

You don't need to split the panes. Just click on the cell that has the stuff above it that you want to remain the same for vertical scrolling, and the stuff to the left of it that you want to remain the same for left right scrolling and then select Window->Freeze Panes.

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, 04:11 PM   #6
Fastmarc
Premium Member
 
Fastmarc's Avatar
 
Join Date: Nov 2004
Location: Kingston, Jamaica W.I.
Posts: 460
Very nice. Thanks for sharing.


__________________
Compared to motorsports, this hobby is a bargain.

Current Tank Info: 50 gallon reef with refugium
Fastmarc is offline   Reply With Quote
Old 01/20/2006, 04:51 PM   #7
m1a1fan
Premium Member
 
m1a1fan's Avatar
 
Join Date: Jan 2004
Posts: 253
Thanks for sharing the file. It'll come in handy.


m1a1fan is offline   Reply With Quote
Old 01/21/2006, 03:12 PM   #8
crumbletop
Registered Member
 
crumbletop's Avatar
 
Join Date: Nov 2005
Location: Nashville, TN
Posts: 4,718
I've also thought about how to track light bulbs -- what was placed and when, to aid in knowing when to replace. I'm new enough to this that I don't really know how useful something like that might be. Could also do the same thing for RO/DI filters. Maybe this would best be done on the notes sheet or on a new sheet altogether as the entries wouldn't be frequent, and they aren't really "tank parameters." Any thoughts?


__________________
"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/27/2006, 04:15 PM   #9
Lordhelmet
Registered Member
 
Lordhelmet's Avatar
 
Join Date: Nov 2004
Location: San Jose, CA
Posts: 2,008
this will work great for my wife. she gets the privlage of watching my tank this summer while i work out of town for a few months


__________________
I need a new signiture

Current Tank Info: 90 gallon, 14 gallon
Lordhelmet 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:49 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.