Excel Spreadsheet for Reef Aquarium Logging

theop · 01/20/2006, 02:48 PM

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.

andynyc · 01/20/2006, 04:31 PM

Great spreadsheet!

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

Thanks.

theop · 01/20/2006, 04:40 PM

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.

brettandlyndi · 01/20/2006, 04:41 PM

Very nicely done! Thank you for sharing.

crumbletop · 01/20/2006, 05:06 PM

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

Fastmarc · 01/20/2006, 05:11 PM

Very nice. Thanks for sharing.

m1a1fan · 01/20/2006, 05:51 PM

Thanks for sharing the file. It'll come in handy.

crumbletop · 01/21/2006, 04:12 PM

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?

Lordhelmet · 01/27/2006, 05:15 PM

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

01/20/2006, 05:06 PM	#5
crumbletop Registered Member 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.

01/20/2006, 05:11 PM	#6
Fastmarc Premium Member 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

01/21/2006, 04:12 PM	#8
crumbletop Registered Member 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.

01/27/2006, 05:15 PM	#9
Lordhelmet Registered Member 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

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.

01/20/2006, 04:40 PM	#3
theop Registered Member 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.

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.

01/20/2006, 05:51 PM	#7
m1a1fan Premium Member Join Date: Jan 2004 Posts: 253	Thanks for sharing the file. It'll come in handy.