Aquarium Log Sheet
- Thread starter MojaveReefer
- Start date
MojaveReefer
Aquarium Log Guy
wabooth555
New member
It looks great! Would you send me a copy? wabooth555@gmail.com
Thanks!
Posted from ReefCentral.com App for Android
Thanks!
Posted from ReefCentral.com App for Android
makdaddy386
New member
Wait where do I find my e-mail address to send you so you can send me....
....errr I'm all confused.
THANKS!!!
....errr I'm all confused.
THANKS!!!
makdaddy386
New member
Wait where do I find my e-mail address to send you so you can send me....
....errr I'm all confused.
THANKS!!!
....errr I'm all confused.
THANKS!!!
MojaveReefer
Aquarium Log Guy
Laddies and Gentlemen the sheet is available for download by clicking the huge blue link, please enjoy it and post any comments on this thread.
Download Aquarium My Log Here
-Sean
Download Aquarium My Log Here
-Sean
You have an amazing amount of patience; for creating the spreadsheet and for taking the time to post on everyone's request for the spreadsheet. Truly better than I could have done.
Two weeks of data already stored in the spreadsheet, and working great.
MojaveReefer
Aquarium Log Guy
Thanks for the kind words Someone19, it's been a pleasure creating and sharing this sheet, with the communities input it has really shaped up into something special I feel.
The sheet is available for download by clicking the huge blue link, please enjoy it and post any comments on this thread.
Download My Aquarium Log Here
-Sean
jeffreed39
New member
Here is another fyi
Here is another fyi
I think its downloadable. :bigeyes:
Here is another fyi
I think its downloadable. :bigeyes:
MojaveReefer
Aquarium Log Guy
Alright folks I went through the thread and consolidated all the update pictures and such in to this one post so it's clear what you're getting. I hope this helps.
Log Sheet Features
*Adjustable Parameters - Not everyone runs their tank the same, set your own parameters.
*Conditional Formatting - Provides at a glance in or out of tolerance viewing by coloring cells, with the added the ability to turn this feature on or off.
*One Button Archiving - Send recent results to your archive with the click of a button.
*Equipment Tracking - Stay on top of your maintenance schedule by tracking replaceable media and parts, and keep track of how long your equipment has been online.
*Livestock Tracking - Keep an inventory of all your tanks inhabitants.
*Calculators - Links to chemistry and volume calculators.
Here are some screen shots of the sheet
Conditional Formatting Off
All you have to do for adjusting the parameters is type in the number you want, I have my temp set From 77 To 82, if I wanted to run my tank a little cooler all I would need to do is replace the 77 with whatever number I choose, It works the same with all the parameters. The graphing is also tied in to the adjustable parameters so you won't miss a beat.
Conditional Formatting On
The small check box above the notes section is what turns the conditional formatting on or off, checked box = on unchecked box = off, it's that easy. Please be aware if you click the archive button while the conditional formatting is on it will copy over colored cells to the archive, if that's how you like it great! If not be sure to turn it off before archiving.
Graphing Feature
All parameters are graphed automatically based on your input. Graphing can also be switched from viewing current results to viewing archived results with the click of the buttons on the graph pages.
Equipment Tracking
For parts tracking you'll enter the date you changed said equipment and in how many days you would like to change it again, the sheet does the math for you and calculates the next change date, as well as counts down the days for you. When the countdown has reached 10 or less days it will highlight yellow, when it has reached 0 you will get the change notification.
For equipment tracking you'll enter the date you put said equipment on your tank, the sheet will do the math for you and display how long that equipment has been online.
I hope you all find this to be useful, please don't hesitate to ask any questions about the sheet or it's use, I'll be more than happy to answer.
Comments and ideas for possible additions are also welcome.
The sheet is available for download by clicking the huge blue link, please enjoy it.
Download My Aquarium Log Here
-Sean
Log Sheet Features
*Adjustable Parameters - Not everyone runs their tank the same, set your own parameters.
*Conditional Formatting - Provides at a glance in or out of tolerance viewing by coloring cells, with the added the ability to turn this feature on or off.
*One Button Archiving - Send recent results to your archive with the click of a button.
*Equipment Tracking - Stay on top of your maintenance schedule by tracking replaceable media and parts, and keep track of how long your equipment has been online.
*Livestock Tracking - Keep an inventory of all your tanks inhabitants.
*Calculators - Links to chemistry and volume calculators.
Here are some screen shots of the sheet
Conditional Formatting Off
All you have to do for adjusting the parameters is type in the number you want, I have my temp set From 77 To 82, if I wanted to run my tank a little cooler all I would need to do is replace the 77 with whatever number I choose, It works the same with all the parameters. The graphing is also tied in to the adjustable parameters so you won't miss a beat.
Conditional Formatting On
The small check box above the notes section is what turns the conditional formatting on or off, checked box = on unchecked box = off, it's that easy. Please be aware if you click the archive button while the conditional formatting is on it will copy over colored cells to the archive, if that's how you like it great! If not be sure to turn it off before archiving.
Graphing Feature
All parameters are graphed automatically based on your input. Graphing can also be switched from viewing current results to viewing archived results with the click of the buttons on the graph pages.
Equipment Tracking
For parts tracking you'll enter the date you changed said equipment and in how many days you would like to change it again, the sheet does the math for you and calculates the next change date, as well as counts down the days for you. When the countdown has reached 10 or less days it will highlight yellow, when it has reached 0 you will get the change notification.
For equipment tracking you'll enter the date you put said equipment on your tank, the sheet will do the math for you and display how long that equipment has been online.
I hope you all find this to be useful, please don't hesitate to ask any questions about the sheet or it's use, I'll be more than happy to answer.
Comments and ideas for possible additions are also welcome.
The sheet is available for download by clicking the huge blue link, please enjoy it.
Download My Aquarium Log Here
-Sean
morgan175
New member
firstlight10
New member
Please download at the link above!
Does anyone have issues when saving the file on a mac. I am using a mac with excel 2011. When i go to save my data i receive a message "this workbook contains features that will not work or may be removed if you save it in the selected file format. Do you want to continue?". When i save it the results and archive buttons on my graphs overlap and make it hard to select one or the other.
firstlight10
New member
If you would like I can send you my Openoffice version which has the active functions (results and archive buttons) disabled. If you want it please PM me your e-mail address.
mcjlance
New member
firstlight10
New member
Sent
MojaveReefer
Aquarium Log Guy
Firstlight,
Thanks for taking care of the open office version for those without excel. If you send me a copy of it i'll add it to the download page so people can choose which one works for them. I sent you my address in PM, thanks again.
-Sean
Similar threads
