LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #14   Report Post  
Old 04-04-2008, 07:25 PM posted to rec.gardens.orchids
external usenet poster
 
First recorded activity by GardenBanter: Jul 2006
Posts: 15
Default Orchid Inventory

I don't use anything to track potted plants, but I have a
custom-built database for the lab. It got to the point where paper wasn't
good enough, so now the Access database keeps it all straight.

For the uninitiated: Excel and other spreadsheets are "flat"
databases, although it is possible to tie things together if needs be-
with a bit of programming. Access and other relational databases have a
lot more power, if needed. For example, Excel could give you a nice
breakdown of the average pot size (if someone wanted that information for
some weird reason) of all your cattleyas. A relational database would be
more useful if one needed to produce a list of all plants belonging to
cattleya species starting with the letter "m" that were last repotted more
than 16 months ago.

In my case, I could have a list generated on command of all flasks
still on the shelves after X number of days- along with the shelf
location, and container identification. At the end of the day, I could
(and do) get an average age of containers on the shelves, and a standard
deviation of that age. Helps keep things fresh, you see.

A little tip: Open Office has a free (as in beer) office suite
that mimics that of Microsoft's, including its own database program and
spreadsheet. Lots of power there. And it's all free.

The address in the header is bogus. Send no email there.

-AJHicks
Chandler, AZ


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Orchid research at the ANH [Was: Orchid Taxonomy and Mycorrhiza] Phred Plant Science 0 04-09-2003 03:23 PM
WANTED: back issues of the American Orchid Society Bulletin & The Orchid Digest. Kenneth Bruyninckx Orchids 0 02-09-2003 08:02 PM
morning thoughts and a mind tearing inventory of sorts..........(give or take a few members) madgardener Gardening 3 03-06-2003 05:32 AM
morning thoughts and a mind tearing inventory of sorts..........(give or take a few members) Tyra Trevellyn Gardening 0 02-06-2003 03:44 PM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 GardenBanter.co.uk.
The comments are property of their posters.
 

About Us

"It's about Gardening"

 

Copyright © 2017