Aquarium Log Sheet
- Thread starter MojaveReefer
- Start date
MojaveReefer
Aquarium Log Guy
Hmm I'll have to know a little more to help you out.
Additive = something you add to supplement water chemistry.
Type = type of additive.
QT = quarantine.
The sheet is available for download by clicking the huge blue link, please enjoy it.
Download My Aquarium Log Here
Open office version for those that do not have excel. The sheet loses macro functionality (click-able buttons for auto archive, etc.) in open office, but the other features still work.
Open office version of the sheet is available for download by clicking this huge blue link, please enjoy it.
Download Open Office Version Here
MojaveReefer
Aquarium Log Guy
That's odd, it should work just fine with excel 2013. If you're able to post a screen shot of what you're seeing I might be able to help yuo fix it. Make sure you're using the normal version, not the open office version.
The sheet is available for download by clicking the huge blue link, please enjoy it.
Download My Aquarium Log Here
Open office version for those that do not have excel. The sheet loses macro functionality (click-able buttons for auto archive, etc.) in open office, but the other features still work.
Open office version of the sheet is available for download by clicking this huge blue link, please enjoy it.
Download Open Office Version Here
A feature I think would be nice is to track when and how much RODI water I have produced. I think it would also be nice to track how much waste water the unit also produce. Also tracking TDS and pressure readings
For example, my unit produces 2.78 gallons of waste water for every gallon of product water. The ratio could be something that is user defined and can be changed. It also has two dual TDS monitors, one before the sediment/carbon filters and one after, then one after the RO membrane but before the DI cartridges and then one after the cartridges.
I think this would also help with equipment maintenance.
For example, my unit produces 2.78 gallons of waste water for every gallon of product water. The ratio could be something that is user defined and can be changed. It also has two dual TDS monitors, one before the sediment/carbon filters and one after, then one after the RO membrane but before the DI cartridges and then one after the cartridges.
I think this would also help with equipment maintenance.
Last edited:
It won't let me post the snip/pic!!
I can click "insert image" a hundred times and nothing :headwallblue:
Hollifields
HOG Owners Group
Thanks Moj been on my list of to do's....now done!
dirtyfrank
In Memoriam
MojaveReefer
Aquarium Log Guy
Glad it's working out for you, thank you for the feedback.
If there are a lot of folks that would benefit from it I could look at adding it, however, I don't think too many folks would monitor those reading beyond a visual inspection.
My pleasure
At the time I did not have a place to upload it. Fortunately a generous member here donated server space for this so everyone can download it. You can find the link in this post.
The sheet is available for download by clicking the huge blue link, please enjoy it.
Download My Aquarium Log Here
Open office version for those that do not have excel. The sheet loses macro functionality (click-able buttons for auto archive, etc.) in open office, but the other features still work.
Open office version of the sheet is available for download by clicking this huge blue link, please enjoy it.
Download Open Office Version Here
dirtyfrank
In Memoriam
Lol.. The link wasn't here when I posted right? I feel dum.
MojaveReefer
Aquarium Log Guy
Available for download via the link here.
It was but it happens, no biggie.
Thanks
The acceptable range is completely adjustable. You can change the numbers to set your own range and the sheet will adjust all the graphs, conditional formatting, etc. for you.
The sheet is available for download by clicking the huge blue link, please enjoy it.
Download My Aquarium Log Here
Open office version for those that do not have excel. The sheet loses macro functionality (click-able buttons for auto archive, etc.) in open office, but the other features still work.
Open office version of the sheet is available for download by clicking this huge blue link, please enjoy it.
Download Open Office Version Here[/QUOTE]
MojaveReefer
Aquarium Log Guy
Been a bit since I've posted pictures of the sheet, Here are some shots of what the sheet looks like folks.
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 till 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
Open office for those that do not have excel. The sheet loses macro functionality (click-able buttons for auto archive, etc.) in open office, but the other features still work.
Open office version of the sheet is available for download by clicking this huge blue link, please enjoy it.
Download Open Office Version Here
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 till 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
Open office for those that do not have excel. The sheet loses macro functionality (click-able buttons for auto archive, etc.) in open office, but the other features still work.
Open office version of the sheet is available for download by clicking this huge blue link, please enjoy it.
Download Open Office Version Here
Last edited:
reefmutt
Active member
Sean!!
Wow! I just read through this thread like a book and I am truly impressed with your dedication, generosity and patience..
You are one COOL DUDE for doing all of this! Everybody has a life to live and everybody's life is busy. The fact that you had the initiative to create such a smooth product and then stick to it for the last couple of years is a real testament to your great character.
I Just wanted to say a HUGE thank you!!
Wow! I just read through this thread like a book and I am truly impressed with your dedication, generosity and patience..
You are one COOL DUDE for doing all of this! Everybody has a life to live and everybody's life is busy. The fact that you had the initiative to create such a smooth product and then stick to it for the last couple of years is a real testament to your great character.
I Just wanted to say a HUGE thank you!!
Similar threads
