Reef Central Online Community

Go Back   Reef Central Online Community > General Interest Forums > Reef Discussion
Blogs FAQ Calendar Mark Forums Read

Notices

User Tag List

Reply
Thread Tools
Unread 01/20/2006, 02: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, 536 views)
theop is offline   Reply With Quote
Unread 01/20/2006, 04: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
Unread 01/20/2006, 04: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
Unread 01/20/2006, 04: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
Unread 01/20/2006, 05: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
Unread 01/20/2006, 05: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
Unread 01/20/2006, 05: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
Unread 01/21/2006, 04: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
Unread 01/27/2006, 05: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



All times are GMT -6. The time now is 05:50 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Powered by Searchlight © 2024 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-2022
User Alert System provided by Advanced User Tagging v3.3.0 (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.