Aquarium Log Sheet

[sticks10]

Great,thanks for sharing:thumbsup:

 

[AbderramanZT]

Excellent thank you!

 

[lemkerailroad1]

this is going to work out real nice

thanks

 

[MojaveReefer]

<3 Thanks a ton!!!!

Thanks!!!

Thank alot.

Very nice spreadsheet. Much better than my current one. Has anyone tried loading it on their phone?

thanks for the log... pretty handy

Thanks for the awesome job you shared

Great,thanks for sharing:thumbsup:

Excellent thank you!

this is going to work out real nice

thanks

My pleasure guys, I'm glad it's helping you all out.


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

 

[Shawno82]

can u send me a copy please? shawno82@yahoo.com
Thank u!

 

[Sethjamto]

AWESOME! I was going to build one myself but you saved the trouble!

Quick question....on the additive column, how can we enter multiple items? I normally dose Cal/Alk/Vodka daily. Do I have create a new line item for each dose? Is there a way to fill in everything into one line so I don't have three entries for each day?

 

[Sethjamto]

Also, are we limited to how many days we can do before having to archive? I noticed the charts only display so many days. I entered about 35 lines of data off my scrap paper data sheet I have laying around and the last few lines won't transfer to the charts.

 

[MojaveReefer]

AWESOME! I was going to build one myself but you saved the trouble!

Quick question....on the additive column, how can we enter multiple items? I normally dose Cal/Alk/Vodka daily. Do I have create a new line item for each dose? Is there a way to fill in everything into one line so I don't have three entries for each day?

The way it is set now, one item per line yes.

Also, are we limited to how many days we can do before having to archive? I noticed the charts only display so many days. I entered about 35 lines of data off my scrap paper data sheet I have laying around and the last few lines won't transfer to the charts.

The results sheet is limited to 35 lines for performance, just click the archive button and the entire results sheet will be copied and pasted for you. You are able to utilize the graph from either results or archive sheets, just click the button for which you'd like to view on the graph page.



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

 

[Sethjamto]

Thanks!

 

[fishouttawater]

Awesome! Thank you. This will be quite an improvement on my blank word template haha.

 

[ravin01]

Is there anyway to get a copy of the log sheet as well? Thanks in advance.

jeffsmith23@comcast.net

 

[ravin01]

Sorry, I see the link and thank you so much!

Jeff

 

[star99]

Hey, thanks Log guy! I am also new to saltwater and since I am waiting for my tank to cycle I thought a log would be handy.

It will make me "see" the evolution and the cycle in a better way. I used it with open office and it is working fine for now.

It is very nice to have the ranges at the top of each columns. Thanks again.

EDIT: OH this is crazy!!! I just noticed the many tabs at the bottom!! So complete and nice with the graphs, I love it.

 

[MojaveReefer]

Thanks!

My pleasure

Awesome! Thank you. This will be quite an improvement on my blank word template haha.

heheh, glad to hear it. Thanks for checking it out

Sorry, I see the link and thank you so much!

Jeff

No problem, enjoy

Hey, thanks Log guy! I am also new to saltwater and since I am waiting for my tank to cycle I thought a log would be handy.

It will make me "see" the evolution and the cycle in a better way. I used it with open office and it is working fine for now.

It is very nice to have the ranges at the top of each columns. Thanks again.

EDIT: OH this is crazy!!! I just noticed the many tabs at the bottom!! So complete and nice with the graphs, I love it.

There is a lot of info you can play with for sure. Thanks for stopping by to post a comment.



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

 

[Capt'n T]

Thank you! Got it on my iPad. Open in "numbers" app. It saves automatically when you click on "spreadsheets" at the top left hand corner when you're done entering values.

 

[MojaveReefer]

Thank you! Got it on my iPad. Open in "numbers" app. It saves automatically when you click on "spreadsheets" at the top left hand corner when you're done entering values.

Very nice! Thanks for sharing your experience.



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]

 

[Mr Limpet]

First, let me say that this is a wonderful spreadsheet that does a lot of things to help the reefers out. A really fantastic piece of work. I have turned a number of reefers onto the spreadsheet both for both versions.
I have a couple of things I would like to bring to you for consideration. First I really use the trending function because it really demonstrates how to maintain a quality and constant water parameters. However, I don't test everything on a daily or weekly basis and therefore I leave some of the reading out. When I do that it breaks the trending analysis datasets, if I enter a zero for a 'no' entry it shows up as a value and produces a 'spike' in the trend line. Is it possible to have the dataset trend through a no value?
The other suggestion is in reference to the archive data. Once the data is archived I am unable to see past trends for comparison of my current data. Is it possible to trend this data as well? Perhaps there is a way to move archived data back to the results spreadsheet so that I and functionality of the trend calculations?
As you can see once you build a better 'mouse trap' someone will come along and want more than what you have already provided. I certainly understand if can't or don't want to address my issues.
Thanks for your time.
Douglas

 

[btucker7587]

Thanks for the link. Will put the sheet to good use.

 

[MojaveReefer]

First, let me say that this is a wonderful spreadsheet that does a lot of things to help the reefers out. A really fantastic piece of work. I have turned a number of reefers onto the spreadsheet both for both versions.
I have a couple of things I would like to bring to you for consideration. First I really use the trending function because it really demonstrates how to maintain a quality and constant water parameters. However, I don't test everything on a daily or weekly basis and therefore I leave some of the reading out. When I do that it breaks the trending analysis datasets, if I enter a zero for a 'no' entry it shows up as a value and produces a 'spike' in the trend line. Is it possible to have the dataset trend through a no value?
The other suggestion is in reference to the archive data. Once the data is archived I am unable to see past trends for comparison of my current data. Is it possible to trend this data as well? Perhaps there is a way to move archived data back to the results spreadsheet so that I and functionality of the trend calculations?
As you can see once you build a better 'mouse trap' someone will come along and want more than what you have already provided. I certainly understand if can't or don't want to address my issues.
Thanks for your time.
Douglas

1. I'm not sure if i can make the graph ignore null cells(no data), but i will look in to it.

2. You can view the archived data in the graph as well. there is a "results" and "archive" button on each graph. clicking each button will change the display to that source.

I hope that answered the questions.

Thanks for the link. Will put the sheet to good use.

I hope it does everything you want it to.



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][/QUOTE]

 

[spoggy]

Very nicely done, thanks for sharing