Spreadsheet for tracking (and graphing) Tank Values

[Protodad]

Anyone have an excel sheet (or sheets) they are willing to share that is set up for inputting measured tank values and graphing them over time?

 

[xiongsy]

I don't use one but you can take a look at the AquaticLog app

 

[Rmckoy]

ReefTrace app

I haven’t used it in awhile since they changed it to require payments

 

[doubleshot00]

Google sheets

 

[Protodad]

Google sheets

I was planning to set up my own sheet, calculations and graphs but figured someone has already done most of the work.

 

[doubleshot00]

I was planning to set up my own sheet, calculations and graphs but figured someone has already done most of the work.

I like to keep mine simple. I use my Apex if i want a graph.

 

[Rmckoy]

I was planning to set up my own sheet, calculations and graphs but figured someone has already done most of the work.

It would be fun to create a sheet to enter values for each test and calculate using one specific product to dose .
Rather than tracking and using a different reef dose calculator

 

[olonmv]

I use the Aquarimate app. You gotta buy it but it’s an awesome app.

 

[LivingroomDiver]

I have been using Aquarium Note. Works great

 

[n2585722]

Are you looking for something like this. I have each one on a different worksheet. I include the reading I add to the graph by clicking the graph and moving the highlighted data area to include the new data.

 

[Drake2910]

Are you looking for something like this. I have each one on a different worksheet. I include the reading I add to the graph by clicking the graph and moving the highlighted data area to include the new data.

Are you able to share this excel spreadsheet?

 

[Clowning_Around72]

Time to start running linear regressions on my fish tank.

 

[TrudeMudeni]

You can make a simple table where each column represents the date, and others are for values like pH, nitrate, salinity, or whatever you’re measuring. Once you’ve got the data in, you can highlight it and use Excel’s built-in charts to create graphs that show trends over time.

 

[rgulrich]

Been a while since I've used it, but it might give you a baseline to play around with.
Cheers,
Ray :cool:

 

[Snoopy 67]

I have a tracking sheet in excel but no graphing if interested PM me.
Good for 6 months of weekly testing per sheet.

 

[TrudeMudeni]

You can make a simple table where each column represents the date, and others are for values like pH, nitrate, salinity, or whatever you’re measuring. Once you’ve got the data in, you can highlight it and use Excel’s built-in charts to create graphs that show trends over time.
If you’re looking for something already made, you might find inspiration or ideas in Best Excel Books. They’ve got great examples and tips for organizing and visualizing data in Excel.

 

[slagman]

Are you able to share this excel spreadsheet?

very nice I would like a copy