An oyster harvest log has a row for each lot: everything taken from one place on one trip. It records the date, the lease or growing area, the time the oysters came out of the water, the time they went into the cooler, how many, who bought them, and the tag numbers on their bags. Two of those columns are clock times, and the log's most useful sum is the gap between them. If your State's shellfish program gives you a limit on the hours from harvest to cooling, the sheet below marks any lot that went over it. And when a dealer or an inspector asks about one day's oysters, the row answers in a minute: which lease, what time, how cold, whose truck. Below is a log for a made-up farm, what each column is for, and the file. The 5-hour limit in the example is invented. Use the one your own program gives you.
The short version
- One row for each lot: one area, one trip.
- Write two times: out of the water, into the cooler.
- The sheet works out the hours between.
- Type your own State's limit. The sheet shows NO for a lot over it.
- Count the oysters and the bags, and write the tag numbers.
- Name the buyer on every row.
- TaroStack keeps each harvest as a lot and records who got it. More below.
An example log
| Harvest date | Lot | Lease or growing area | Out of the water | Into the cooler | Hours to cooling | Limit | Within the limit? | Oysters | Bags | Cooler temp | Sold to | Tag numbers |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Nov 16 | H-1116A | Lease 12, north racks | 6:30 AM | 8:30 AM | 2.0 | 5 | Yes | 1,200 | 12 | 41°F | Harbor Fish Co. | 4401 to 4412 |
| Nov 16 | H-1116B | Lease 12, south racks | 7:30 AM | 10:30 AM | 3.0 | 5 | Yes | 800 | 8 | 41°F | Dockside Raw Bar | 4413 to 4420 |
| Nov 18 | H-1118A | Lease 7, floating bags | 7:00 AM | 12:30 PM | 5.5 | 5 | NO | 1,000 | 10 | 42°F | Harbor Fish Co. | 4421 to 4430 |
| Nov 19 | H-1119A | Lease 12, north racks | 6:45 AM | 9:00 AM | 2.3 | 5 | Yes | 1,500 | 15 | 40°F | Harbor Fish Co. | 4431 to 4445 |
Four lots, 4,500 oysters, 45 bags.
What the log shows
The lot of November 18. Out of the water at 7:00 AM, into the cooler at 12:30 PM: five and a half hours against this farm's limit of five. The other three lots took between two and three hours. The log shows the exception on the day it happens, while the oysters are still on the dock.
The log doesn't decide what happens to that lot. That's a question for the farm's State program. This farm phoned it before anything left, and the row's note says so, with the answer and a name kept in the file.
It also shows why. Lease 7 is the farm's far lease, and the boat came back on a falling tide. The next trip there starts an hour earlier and carries ice.
Two lots on one day. The 16th has two rows because the oysters came from two parts of the lease at two times and went to two buyers. One row for the day would have said "2,000 oysters, about 7 AM", and it would have been wrong about both.
Tags. Bags 4421 to 4430 are lot H-1118A. A bag in a restaurant's walk-in leads back to a row, and the row to a lease and two times. What a tag has to show, and what a restaurant does with it, is in shellfish tag requirements.
The columns, and how to fill them
- Lot. A code made from the date, with a letter for each trip or area: H-1116A.
- Lease or growing area. The name your permit uses, and the part of it if you work it in sections.
- Out of the water. When the first oysters of the lot were taken, from a watch, not from memory at the dock.
- Into the cooler. When the last bag of the lot went in.
- Your limit. The hours your State's program gives you for this month and this kind of harvest. If it changes with the season, retype it when it does.
- Cooler temp. Read when the lot goes in. A sheet for the cooler itself, through the day, is in temperature log template.
- Sold to. The dealer, restaurant or market, and the date it left if that's a different day.
A general tally for crops is in harvest log template, and how to build a code that says what you need it to in traceability lot code. The money side of a farm like this one is in is oyster farming profitable.
Get the log
Download the oyster harvest log. One sheet and a read-me: a row for each lot, with the hours from the water to the cooler worked out and a Yes or NO against the limit you type. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Print it for the boat, and type it up at the dock.
Where this stops working
On the water the log is a wet clipboard, and the times get written at the dock from memory. In the office it's a binder. When a dealer phones on Friday about bags from Monday, somebody finds the page, reads the tag range, and then goes to the invoices to see who else got bags from that lot. The log knows what was harvested. Who received which bags is in another book.
How TaroStack does it
TaroStack keeps the harvest and where it went in one record.
Each harvest is a lot, with its date and your own code.
Your checks are fields on the record: the two times, the cooler temperature, the tag range, a note.
Customers and sales orders, with what ships recorded by lot.
One report for a lot: which customers got it, how much, and what's still in the cooler.
Starting a recall holds what's left and gives the recall a number.
| The dealer's call | Binder and invoices | In TaroStack |
|---|---|---|
| Which lot were Monday's bags | Find the page | Search the lot |
| Who else got that lot | Read the invoices | One report |
| How many are still in the cooler | Count | The lot's stock |
| Stop the rest going out | Tell everyone | Starting a recall holds it |
TaroStack doesn't read thermometers or know your State's time limits: you type what you measured. Keep the paper tags and any record your program requires as it requires them. Lots, sales orders and recalls are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
