Coral inventory spreadsheet....

[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.p...285#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.