Hello Ecolog, I am currently trying to revamp a sample tracking program. I'd like to streamline the whole system; everything from coming up with the sample codes and pre-labelling vials, to keeping track of where samples are and matching up data after samples are analyzed. Right now I'm using an Excel spreadsheet for tracking and Word for printing labels sheet by sheet, but I'm sure there's a more efficient way.
The samples I'm collecting are salmon scales and DNA, and the scales and DNA are analyzed in separate locations, and then the data is matched. To give you an idea, I am dealing with between 15,000 and 60,000 samples in a short time period, 2 or 3 months. Batches of sampling kits are prepared for each sampling location (approx 30 different locations) before the season begins. Currently each location has a different code, and every sample collected has a unique number. Along with other data, I need to know where sample vials are at any given time and their status (used or not), and keep track of the dates when they are prepared, used, sent, recieved, and analyzed. I'm looking for suggestions on sample tracking software, and possibly labelling equipment, that might make this process more efficient. I'm considering creating an Access database, but I thought I would investigate other options that might already be available, as I'm sure many of you deal with similar challenges. Does anyone know of any freeware that might work for this process? Has anyone else found any efficient and cost-effective options? Any advice or suggestions would be very much appreciated. Thanks so much for your time! Erica
