Coral/Tank Inventory Spreadsheet template

[Mr Cob]

Thought I would share for others. I've been forgetting what I paid for corals and what their lineage/name is so decided I would start documenting everything including value and growth. I think this makes a good reference tool as your tank progresses.

The "Total Estimated Value" section will automatically calculate the "Est. Value" columns and give you a total of all items.

Modify as you see fit. You could even keep track of your equipment. I also posted a link in the document to an article that discusses reef parameters.

Enjoy. It's attached as a .xls file. I left a couple of my corals on there to give you an idea of how I'm using it. Just delete the rows and add yours.

[Mr Cob]

Good info:




You can embed a picture and other documents into xls. You can place a picture of your frag in as an image next to the name... and under JAN11, another. JUL11, another. That would show you at a glance how well you're doing.

As far as documents, taking a PDF of the care of or documented paperwork on that particular line can be embedded (not a link to your HD, but an actual document within xls that opens in another window when clicked twice) to show receipts or other information to include general care and stuff.


Allan

[Mr Cob]

Feel free to post and attatch your own versions or revised versions of this one.

[allan]

Rob, I wonder if it would be a good idea to go ahead and add a pdf and image to the existing document to show range? Should only take a few moments...

[Mr Cob]

That's a great idea. Open it up and add your candy then post with an attachment.

[allan]

Ok, file turned out at 50M with just two pdf files. I think that would have killed our bandwidth.