Excel Spreadsheet to Monitor Readings "HERE"

[thirty5]

I know that there was another thread on asking for software. In answer to that thread I threw together this quick workbook in Excel for anyone who want to use it.

This is only the first run, so if anyone has any ideas for modifications just let me know.

http://dl.dropbox.com/u/24661185/Tank%20Readings.xls

You will see multiple tabs across the bottom of the screen.
The first tab is for ENTERING your data.
The rest of the tabs are READ ONLY, and they will also show your readings for that specific test along with a 1-year graph.

UPDATE:

09/13/2011
Changed Dates back to 08/01/2011 in the sheet so that anyone keeping a journal can enter that info to get better term tracking.


Added tabs for feeding, water changes, dosing.
Made charts pretty (different colors), tried to match color of chart to color of test kit readings

If you know Excel you can easily edit this file. If you do not know, and don't want to mess it up, shoot me a PM and I will make changes for you.

If you decide to get new file, make sure that you SAVE AS a new file name (or change name of old file) then juts copy and paste your data in, it will then create the graphs on the fly.

Let me know what you think. I have not made it "pretty Yet" which I will get to.

 

[pecan2phat]

Very nice

 

[Alex]

good chart, thanks.

 

[thirty5]

good chart, thanks.

I am going to update it.. So when I do, all you will to do is copy and paste your data from the first version to future.

 

[howze01]

Great so far! Now all I need to do is get up the ambition to test my tank more than once a month

 

[thirty5]

Great so far! Now all I need to do is get up the ambition to test my tank more than once a month

Ha!

 

[thirty5]

New File with updates... See first post for details.

If you update file, make sure that you save it first as a new name and then copy and paste your data from old sheets into this one.

 

[Widdy]

Great work!

 

[thirty5]

Great work!

:thanks:

 

[thirty5]

Small change to file see 1st post for more.

 

[turbotone]

damn i dont have excel on my damn mac!!! ugh...i was looking for something like this...my journal is chaotic smh

 

[rkaragozler]

same here, can you convert file to pdf

 

[rkaragozler]

Just found openoffice for mac and free
http://download.openoffice.org/cont...e/3.3.0/OOo_3.3.0_MacOS_x86_install_en-US.dmg

 

[thirty5]

Can't convert t pdf. Can't save it unless u have acrobat pro. Acrobat reader will not all you to save the info. The charting featjre wil also not work

Openoffice works well!! Free is the best part

Sent from my SPH-D700 using Tapatalk

 

[charliethetuna88]

Thanks bro pretty cool .i suck with computersand I got it working great spread sheet

 

[thirty5]

Thanks bro pretty cool .i suck with computersand I got it working great spread sheet

Hahahahah even if you suck you should be able to use this. Just type in the number and the program will do the rest....

If you want I will create personalized files for anyone who wants. Just give me specifics and I will get them to you.

 

[charliethetuna88]

Lol hahaha .i added a few extra things to it like strontium under dosing ,prodibio,and zeozym,under dosing then I added under readings cal reactor ph .I like to monitor my oh dailey outta my cal reactor .I cant figure out how to add the lines in the columes though i can add the numbers but there's no horizontal or vertical lines in the new ones i added no biggie ill mess with it again and see if I can figure it out

 

[charliethetuna88]

Oh can u add a on more to it i wanna measure out my peanut intake lol j/k bro lol thanks again great spread sheet for us reef nerds

 

[thirty5]

Oh can u add a on more to it i wanna measure out my peanut intake lol j/k bro lol thanks again great spread sheet for us reef nerds

HAHAHAAH!!!! I actually laughed at that! And it is sesame count!!! Not peanut!

 

[charliethetuna88]

Glad u laught thanks again