Aquarium Log Sheet - Page 36

Capt'n T · 12/05/2013, 03:06 AM

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 · 12/05/2013, 09:09 PM

Quote:

Originally Posted by 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.

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 · 12/07/2013, 07:09 PM

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 · 12/11/2013, 05:32 AM

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

MojaveReefer · 12/11/2013, 02:06 PM

Quote:

Originally Posted by 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

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.

Quote:

Originally Posted by btucker7587

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 · 12/16/2013, 01:38 PM

Very nicely done, thanks for sharing

spoofer · 12/27/2013, 10:34 AM

Thank you for this, I appreciate the detail and time put into this

TimCMaurer · 12/27/2013, 03:47 PM

Nice job, I've been looking for something exactly like this.

Thanks,
Tim

james2369 · 12/29/2013, 03:35 AM

Quote:

Originally Posted by SantaMonica

Nice job. Had to enable macros, but got it working.

Quote:

Originally Posted by MojaveReefer

This is a aquarium log I received from a fellow RC member, I updated a lot of things and felt it was nice enough to share with everyone. I hope you all enjoy it.

Test Results Sheet

Graphing Feature

This Log uses macros for functionality and they must be enabled to utilize the log.

Key Features
Complete test array logging
1 button archive feature
1 button clear feature
Graphs for every test
Ability to view graph from current results or archive with the click of a button
Printable blank sheet for field testing

Big Thank you to thegrun for the base of this log. If anyone would like to get a copy you can post or pm me an email address.

If anyone can think of some other features they would like to see added let me know and I'll try to add them.

-Sean

aleithol · 12/29/2013, 07:01 AM

Also wanted to add in my thanks. I had on my to-do list to build tracking log, and voila! I found something 1000% better than I could have generated.

dsustko · 12/31/2013, 02:53 PM

Thank you very much for this!!! It helps me a lot.

queball1 · 01/01/2014, 11:40 PM

Thanks for sharing!

GianMaria · 01/09/2014, 08:14 AM

Quote:

Originally Posted by MojaveReefer

Out right now. I'll send you a copy as soon as I get home.

Could i get copy also? Thxs

m9dale06 · 01/12/2014, 09:16 PM

SAme here can i get a copy too?

dsobo · 01/13/2014, 04:35 PM

Thank you from me as well, great job!

mpjones · 01/15/2014, 02:34 PM

Downloaded your Aquarium Log a few days ago and love it!

Just curious if it is possible to add a couple of items to this already lengthy but very effective list.

I also test for Iron and Potassium. Would it be possible to get these added to the spreadsheet as well?

Thanks MojaveReefer for the awesome spreadsheet!

mrelect · 01/15/2014, 03:26 PM

^ +1

Bellaru · 01/15/2014, 04:41 PM

This thing is awesome!!
My hat is off to you.

m9dale06 · 01/15/2014, 08:33 PM

Where can i get the copy of this log sheet?

mpjones · 01/15/2014, 08:42 PM

Quote:

Originally Posted by m9dale06

Where can i get the copy of this log sheet?

go to post 880 and click the download link!

m9dale06 · 01/15/2014, 09:42 PM

Thank you mpjones

MojaveReefer · 01/18/2014, 12:52 PM

Quote:

Originally Posted by spoggy

Very nicely done, thanks for sharing

Quote:

Originally Posted by spoofer

Thank you for this, I appreciate the detail and time put into this

Quote:

Originally Posted by TimCMaurer

Nice job, I've been looking for something exactly like this.

Thanks,
Tim

Quote:

Originally Posted by aleithol

Also wanted to add in my thanks. I had on my to-do list to build tracking log, and voila! I found something 1000% better than I could have generated.

Quote:

Originally Posted by dsustko

Thank you very much for this!!! It helps me a lot.

Quote:

Originally Posted by queball1

Thanks for sharing!

Quote:

Originally Posted by dsobo

Thank you from me as well, great job!

Quote:

Originally Posted by Bellaru

This thing is awesome!!
My hat is off to you.

You're all welcome, thank you all for stopping back in to say a kind word about the sheet.

Quote:

Originally Posted by mpjones

Downloaded your Aquarium Log a few days ago and love it!

Just curious if it is possible to add a couple of items to this already lengthy but very effective list.

I also test for Iron and Potassium. Would it be possible to get these added to the spreadsheet as well?

Thanks MojaveReefer for the awesome spreadsheet!

I'm glad you're loving it. It would be possible to add in additional parameters, however, it would be a lot of work. I created the sheet to cover the majority of parameters the general population tested for. If you would like to add in additional parameters for yourself I'd be happy to advise you on how to go about it, but it will be a lot of work in excel and visual basic.

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

ttboys · 01/21/2014, 05:34 PM

Thanks my friend ,,nice layout

Gato1 · 01/22/2014, 10:56 PM

Thanks for all the work and effort you put into this, grate work and time you put into this, and sharing with us. Now I can go to just one spreadsheet and cover the matric of my tank.

Once again thanks

Sniffles · 01/23/2014, 10:20 AM

Great Log Thingie!!!!

12/05/2013, 03:06 AM	#876
Capt'n T Premium Member Join Date: Aug 2005 Location: Colorado Posts: 170	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. __________________ Teneele "The only thing needed for evil to triumph is for good men to do nothing" Current Tank Info: 75g w/ 29g sump

12/11/2013, 05:32 AM	#879
btucker7587 Registered Member Join Date: Aug 2013 Location: Okinawa, Japan Posts: 305	Thanks for the link. Will put the sheet to good use. __________________ Building a new one. 150g Reef Current Tank Info: 150 Gallon (60x24x24) Acrylic Reef Tank. Apex Controller, Vertex Omega 150 Skimmer, Reefbreeder 48” LED Lights, 2x Jebao RW 15 Power heads, 2x 300w Heater (Kotobuku), 70 Gallon DIY sump, Jebao UV sterilizer, GFO and Carbon reactors

12/16/2013, 01:38 PM	#881
spoggy Registered Member Join Date: Nov 2005 Location: Elyria Posts: 53	Very nicely done, thanks for sharing __________________ Steve "Moderation is a fatal thing. Nothing succeeds like excess." Oscar Wilde Current Tank Info: 200 gal Oceanic, 150 Gal sump, Trigger Systems TS800 Beckett Injector Protein Skimmer, Schuran Jetstream I Calcium Reactor, 4 DE 250w MH 20,000K, 4 96w 03 Actinic, 50g refugium

12/27/2013, 10:34 AM	#882
spoofer Registered Member Join Date: Jul 2007 Location: Uptown-Chicago, IL Posts: 654	Thank you for this, I appreciate the detail and time put into this __________________ "Nothing good ever happened fast in a Reef Aquarium- there is no quick fix's to Reef tanks!" Current Tank Info: 120g Tech Tank, Vortech MP40, Apex, ATI 8x54, Vertex IN-180, Mag 9.5, Phos & Carb Reactors, Kalk Drip via reefdosingpumps.com sentry model, 40 gallon Breeder DYI Sump

12/27/2013, 03:47 PM	#883
TimCMaurer Registered Member Join Date: Sep 2012 Posts: 1	Aquarium Log Sheet Request Nice job, I've been looking for something exactly like this. Thanks, Tim Last edited by TimCMaurer; 12/27/2013 at 03:49 PM. Reason: Missed the big blue link.

12/07/2013, 07:09 PM	#878
Mr Limpet Registered Member Join Date: Oct 2011 Location: Roseville, Ca Posts: 53	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

12/29/2013, 07:01 AM	#885
aleithol Registered Member Join Date: Dec 2003 Location: Carlsbad, CA Posts: 425	Also wanted to add in my thanks. I had on my to-do list to build tracking log, and voila! I found something 1000% better than I could have generated. __________________ Bert

12/31/2013, 02:53 PM	#886
dsustko Registered Member Join Date: Feb 2013 Location: Oklahoma Posts: 30	Thank you very much for this!!! It helps me a lot.

01/01/2014, 11:40 PM	#887
queball1 Registered Member Join Date: Sep 2013 Posts: 2	Thanks for sharing!

01/12/2014, 09:16 PM	#889
m9dale06 Registered Member Join Date: Jul 2012 Location: Ventura Posts: 44	SAme here can i get a copy too?

01/13/2014, 04:35 PM	#890
dsobo Registered Member Join Date: Feb 2012 Posts: 8	Thank you from me as well, great job! __________________ SaltyReefer

01/15/2014, 02:34 PM	#891
mpjones Registered Member Join Date: Jun 2013 Location: Neenah, WI Posts: 97	Downloaded your Aquarium Log a few days ago and love it! Just curious if it is possible to add a couple of items to this already lengthy but very effective list. I also test for Iron and Potassium. Would it be possible to get these added to the spreadsheet as well? Thanks MojaveReefer for the awesome spreadsheet!

01/15/2014, 03:26 PM	#892
mrelect Registered Member Join Date: Nov 2007 Location: New Jersey Posts: 21	^ +1

01/15/2014, 04:41 PM	#893
Bellaru Registered Member Join Date: Jun 2013 Location: South Carolina Posts: 53	This thing is awesome!! My hat is off to you. __________________ 55gl with 20gl sump/fuge 9 months old 2 Ocellaris Clownfish, 1 Neon Dotty Back, 2 Cleaner Shrimp, lawn mower blenny Fox face, Snails , Hermits and tons of pods, corals

01/15/2014, 08:33 PM	#894
m9dale06 Registered Member Join Date: Jul 2012 Location: Ventura Posts: 44	Where can i get the copy of this log sheet?

01/15/2014, 09:42 PM	#896
m9dale06 Registered Member Join Date: Jul 2012 Location: Ventura Posts: 44	Thank you mpjones

01/21/2014, 05:34 PM	#898
ttboys Registered Member Join Date: Dec 2012 Posts: 53	Thanks my friend ,,nice layout

01/22/2014, 10:56 PM	#899
Gato1 Registered Member Join Date: Jan 2014 Location: Anaheim Ca Posts: 2	Thanks for all the work and effort you put into this, grate work and time you put into this, and sharing with us. Now I can go to just one spreadsheet and cover the matric of my tank. Once again thanks

01/23/2014, 10:20 AM	#900
Sniffles Registered Member Join Date: Jan 2014 Location: Minnesota Posts: 84	Great Log Thingie!!!! __________________ ~Sniffles Current Tank Info: 55 Gallon Double-Barred Rabbit, Royal Gramma, 2 Pajama Cardinals, 2 Green Reef Chromis, Engineer Goby, Long-Fin FryWrss, Sand-Sifter Star, Tile Star, Feather Duster, Red Leg Cortez Crabs, Emerald Crabs, Ruby Red Crab, 20 Lbs. Live Rock

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Anybody have a good log sheet they use?	sbonder	New to the Hobby	4	02/24/2010 11:25 AM
looking for printable water parameter log sheet	cdbias2	The Reef Chemistry Forum	3	05/10/2007 06:30 PM
saltwater log sheets	robcropper	Reef Discussion	4	12/18/2006 07:49 AM
saltwater log sheets	robcropper	New to the Hobby	1	12/17/2006 11:00 PM
Excel Spreadsheet for Reef Aquarium Logging	theop	Reef Discussion	8	01/27/2006 05:15 PM