keeping track of water tests
- Thread starter salt210
- Start date
J
jojo727
Guest
i have an oversized calender in my fishroom that i use to jot down things, and i also have excel spreadsheets with the same as what uneverno has but i dont update it as often as i should.
uneverno
Active Member
Originally Posted by salt210
http:///forum/post/3019096
is that all under one spreadsheet? how did you work that out? all mine has is the date the test was done and then lists the tests
I started out w/ the Months across the top in Columns (vertical) and the data in Rows (horizontal). It got a little cumbersome to do it like that so I switched it - Months in rows, and data in columns. Just a quick note in the Cell w/ test result. Test type and whatever other info titles are in Row 1 starting w/ column B. Column A is reserved for Month/date.
I use the "freeze panes" function in the "Window" dropdown in the toolbar to lock row 1 and Column A. That way no matter which direction or how far you scroll, that info is always visible.
As the data piles up, I just hide the rows I don't need to look at (like from 4 months ago) but the data's still there if I need it. Anything where I need to add long notes is at the far right so I can extend the cells or wrap the text as needed. That way, pertinent test data is all available at a glance on the left side of the spreadsheet.
Sorry for the lesson in XL if you already know these things. I included it so that those who don't could figure it out.
HTH,
Emil
http:///forum/post/3019096
is that all under one spreadsheet? how did you work that out? all mine has is the date the test was done and then lists the tests
I started out w/ the Months across the top in Columns (vertical) and the data in Rows (horizontal). It got a little cumbersome to do it like that so I switched it - Months in rows, and data in columns. Just a quick note in the Cell w/ test result. Test type and whatever other info titles are in Row 1 starting w/ column B. Column A is reserved for Month/date.
I use the "freeze panes" function in the "Window" dropdown in the toolbar to lock row 1 and Column A. That way no matter which direction or how far you scroll, that info is always visible.
As the data piles up, I just hide the rows I don't need to look at (like from 4 months ago) but the data's still there if I need it. Anything where I need to add long notes is at the far right so I can extend the cells or wrap the text as needed. That way, pertinent test data is all available at a glance on the left side of the spreadsheet.
Sorry for the lesson in XL if you already know these things. I included it so that those who don't could figure it out.
HTH,
Emil
J
jojo727
Guest
me too,thanks
uneverno
Active Member
Sounds like we're doing about the same thing. There are as many ways to do it as Windows has to crash your computer I'm sure
I use the chemical shorthand 'cuz then the data stays more compact - I adjust cell size to 35 pixels and everything I want to know is across the 1st 2" of my screen..
I use the chemical shorthand 'cuz then the data stays more compact - I adjust cell size to 35 pixels and everything I want to know is across the 1st 2" of my screen..
oceansidefish
Active Member
I use aqualog....It's a program I downloaded for free
don trinko
Member
Mine is not near as sofisticated as you all are doing; I have a word file for each SW tank. I put the test results and date of test in. I also put the date for WC , adding new fish or snails, and death of any thing. Don T.
meowzer
Moderator
Originally Posted by Don Trinko
http:///forum/post/3019210
Mine is not near as sofisticated as you all are doing; I have a word file for each SW tank. I put the test results and date of test in. I also put the date for WC , adding new fish or snails, and death of any thing. Don T.
I think I'll use a pen and notebook
http:///forum/post/3019210
Mine is not near as sofisticated as you all are doing; I have a word file for each SW tank. I put the test results and date of test in. I also put the date for WC , adding new fish or snails, and death of any thing. Don T.
I think I'll use a pen and notebook
invertcrazy
Member
don trinko
Member
Nothing wrong with pen and notebook; No harddrive to crash! Don T.