Orchid Record Keeping - Excel Template/s?

[CableGirl]

A spreadsheet to keep track of progress and care sounds like a wonderfully helpful idea. I'm not a Windows user, however. I use Linux. Does anyone have an open source template that would work for me?

[razka3]

You can open .xls with OpenOffice no problem.

[Lindafvb]

I would think everyone's spreadsheet would be and could be designed to capture what interests the collector. My headings include type of orchid; Name; flower color; fragrance(Y/N); flower size; yr. acquired; bought where; spec. direction/etc.; blooming season; date bloom opened. All of them are numbered, with each group type colorized. I also color the names in bloom now and the ones in spike. I find I can locate these faster when at a show or looking for a particular orchid when it is time to update the sheet. Do a cut and paste and just bring the rows of interest to the sale.
Ofcourse many of the stats do not change but the others are so interesting. Especially the amount of buds and flowers(on my sheet that is in spec. direc/etc)love to see that number go up each time and what's different since the last bloom.

[jeninhk]

I know this topic is old.. but I was wondering if any one was still willing to send me an excel template they use.. I would really like something basic as I am learning about all the orchids I have been given and keep track of blooms, care instructions, repotting, fertilizing ect.
I love keeping organized in Excel or having databases for things.. however I am horrible at excel and can not create them...

[boytjie]

Originally Posted by razka3

I can send you a copy of mine if you want - I got it from Gwen a little while ago. Check your private messages.

Oooh, could I trouble you for a copy of this as well? Many thanks!

[Grandma M]

I use the form from Gwen and it is fantastic. I tweked it a bit to add the info I wanted to record such as.....on her form, I list blooming dates. When it re-blooms, I do not make a separate column for that, I just print it in the same box. You can expand the depth of the box so there is room for more dates.

It may be possible that Gwen had modified hers since I got it from her.

I have quite a large collection so I make a separte sheet for the different types such as,
Phrags
Paphs
Vanda
Mini
Misc - any other of which I only have 2 or 3 plants.

It is so easy to switch from one sheet to another.

I also record a thumbnail of the blooms.

Try it, you will wonder how you ever lived without it.

If you get a copy from Gwen, I will send a message with the headings which I use, just as an example, but I use most of the headings from Gwen.

I also have OrchidWiz. Alex put in a program on which you can record more details, but I have a lot of not listed crosses and some NOIDs. So far, I haven't figured out how to record these. Hopefully the new version will have added a few more options.

I hope Gwen doesn't hate me for this. She may get a lot of requests for her form.

Marilyn

[Suresh Kalyanpur]

Frank I 'd like to request you to send me a copy as well. Thanks in advance.

[Granny]

I made my d-base with Access 2007 and it looks like this:
It opens with a menu:


Then you go to the records:



You can see which orchids flowers if you make web-albums for example in Picasa.



And you can print all sort of reports you wish, by species, hybrids, temperature or whatsoever.



This is only suitable for Access 2007, but then it works fine.
Unfortunately I cannot give it for free and I have not translated it yet.

greetz,
jeannine/Granny

[Brookpoint]

Originally Posted by charmbutterfly

I have something like what you guys are talking about but its not in excel, i just did it in word.

If anyone is interested i can show you

I would love to have it. I now have 50 orchids, and it is hit or miss......tks., brookpoint

[jeninhk]

granny, your database is amazing!..maybe i will look into access and find some tutorials...
Chamberbutterfly I would really love to be snet your word document

Thanks