Coral inventory spreadsheet....

[Mr Cob]

Does anyone do this? Keep track of their corals/tank with an inventory spreadsheet...

I just started doing it and downloaded a template. I modified it to fit my needs.

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.

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.

[Pennies2Cents]

That is a great idea Rob.. Thanks for sharing. :) This will definitely come in handy. :)

[Big_Pun]

your nuts rob all i do is count how many frags are on my frag rack and if the number matches from the day before im good

[Mr Cob]

That is a great idea Rob.. Thanks for sharing. :) This will definitely come in handy. :)

Sure thing! Thanks for posting. :)


your nuts rob all i do is count how many frags are on my frag rack and if the number matches from the day before im good

LOL! What can I say? I'm organized and I'm forgetting names of stuff. I think it's worth remembering if it's Tyree or ORA or Dr. Mac... etc. Actually, I'm just organized! LOL! Been working on getting my life cleaned up...haha...remember I just cleaned my stand too and managed all of the cables. I guess it's part of "nesting", remember my wife is pregnant...

[Pennies2Cents]

oh yea! Your Nesting!:bighug::bigsmile:

[FireWater]

Great idea, I am too scared to put values in the spread.
Thanks for the info - and did you remember the names of the coral from the trade?

[Europhyllia]

Yeah, I am not about to add up all I spent. That would be crazy. And I'm great with names: pink one, orange one, green one, bleached one, ...

[Texreefer]

used to do it years ago when I first started.. took too much time away from working on my tank( too lazy to keep it up):angel: Just leave out the " how much you spent on it" column:bigsmile:

[txav8r]

Nice lay out Rob! Great idea but like others said I'd almost be afraid to know what all I have spent on corals.

[Pennies2Cents]

Considering we just spent a fortune on a "New" tank. The prices of the coral, fish and all other inhabitants are just a friendly reminder of what this great hobby has to offer that are almost always beautiful & captivating. :) JMHO.:bigsmile:

[Mr Cob]

John, part of the reason I started the spreadsheet was from our trade. I had my little sheet and was making it electronic and then next thing you know I start documenting my entire tank and then I downloaded a template...haha! Man...I can't remember all of those names. LOL! I didn't realize I had so many corals until I started adding them to the list.

I think it's a useful tool. Most everyone is interested in lineage. Values and what you paid for something also help should you ever decide to sell a coral or if you ever decide to add it to the Frag Exchange program, you'll have a better idea of where to put it. I was very interested in comparing corals on my list after I finished to see what size they were when I first purchased them.

I'm sure it will be a good tool to reference in the future. Especially when the tank hits the one year mark.

Anyways, I'm a dork.

[Mr Cob]

I don't look at it as what I spent, I look at as what it's worth!

[txav8r]

Rob, You should put this in the library and sticky it.

[Mr Cob]

Cool, thanks. Where though? Reference Material?

[allan]

DUDE!!! dude dude dude dude,

...dude...

I pretty sure you know this but I'm bringing it up anyway becuase, dude, that's a great idea.

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.

Never thought of doing what you're doing, but I have done those other things for my capital expense database at my last place of faux work.

Allan

[txav8r]

Exactly!


Cool, thanks. Where though? Reference Material?

[Mr Cob]

Ok, added it:
http://maast.org/forums/showthread.php?p=725285#post725285

Allan, I did not know all of that. Thanks for posting. Good info dude. I'm not an excel wizard like you...I just downloaded a template and modified it...LOL.

[allan]

The images are actually quite simple, but imbedding the files would take small block of instruction, less than the one used for uploading photobucket pictures.

Basically, you open the pdf file, save entire document (which is alt E, B)... then you must leave the file open. Closing it will dump your clipboard. Go to the spot on your excell where you want the thumbnail and paste. I think the hot keys have changed with MS07 as we didn't upgrade until mid09 in the army.

Then you can close the pdf. Your thumbnail can be resized and placed as necessary as it doesn't reside in a cell, but rather over the page. Then if you email out the xls everything goes with it.

Recommend pdf for this purpose as images take up so much space over a pdf.

Anyway, good idea Rob.

[jesserettele]

This is very nice. The problem is that if I downloaded it the file size would stay at 25.5 KB ;) since I don't have anything to put in there yet. But I will definately use this as I get started again, and this time, have a way to remeber what I have, when, how much it grew, when fragged, and what it cost vs. worth.

Thanks allen for the instruction on the excells and pdf's for embedding that will rock.

Rob I like your way of thinking about the what it's worth!

[Mr Cob]

Thanks guys...Jesse on the same line of thinking that is why I did not calculate the totals for what was spent...only the column of what it's worth.

[Mrs. z28pwr]

:hypnotyized: OHH Gosh sounds complicated. I just have a simple list. I need to get on the ball and have Jose do this for me...........:bigsmile:

[ErikH]

FWIW If anyone needs a program similar to the office suite, look up openoffice.org

[CoryDude]

Very detailed and well laid out. I have one like this (not as detailed as Rob's) for a coral wish list.

I actually built a linked database program similar to ms access that allows me to include gif/jpeg files, names, coral source, and anything else I want to add. No prices though. If my wife were to get into that linked list and total up the prices, I'd be pretty easy to spot at the next meeting. I'd be the only guy with half a high heel sticking out of my rump.

If I can get it to where I'm happy with it, I'll be happy to provide the program to charter members.

[Mr Cob]

Hahahahaha!

Hey, that would be cool...can't wait to see more.