Microgreens are grown in a week or two, a tray at a time, and every tray is a small experiment whether you mean it to be or not. A microgreens log sheet has a row for each tray: the variety, the seed lot, the weight of seed sown, the date sown, the date it came out of blackout, the date harvested and the yield. With those eight things written down, the questions that otherwise stay arguments have answers. Is the heavier sowing worth the seed? Did the new lot of radish germinate worse? Which trays went to which restaurant? Below is a log for a made-up grower, what each column is for, and the file.
The short version
- One row for each tray, with a tray number on the tray itself.
- Write the seed lot every time.
- Weigh the seed, don't scoop it.
- Three dates: sown, out of blackout, harvested.
- Weigh the harvest. Yield is the number the rest is for.
- Note what went wrong on the day you see it.
- TaroStack records each harvest as a lot with the seed lot behind it. More below.
An example log
| Tray | Variety | Seed lot | Seed | Sown | Out of blackout | Harvested | Days | Yield | Oz from a gram |
|---|---|---|---|---|---|---|---|---|---|
| T-101 | Sunflower | SF-2610 | 150 g | Nov 6 | Nov 10 | Nov 16 | 10 | 14.5 oz | 0.10 |
| T-102 | Pea shoots | PE-2609 | 220 g | Nov 6 | Nov 9 | Nov 17 | 11 | 16.0 oz | 0.07 |
| T-103 | Radish | RD-2611 | 35 g | Nov 9 | Nov 12 | Nov 17 | 8 | 9.0 oz | 0.26 |
| T-104 | Broccoli | BR-2608 | 20 g | Nov 9 | Nov 12 | Nov 19 | 10 | 6.5 oz | 0.33 |
| T-105 | Radish | RD-2611 | 35 g | Nov 9 | Nov 13 | Nov 17 | 8 | 4.0 oz | 0.11 |
| T-106 | Sunflower | SF-2610 | 150 g | Nov 13 | Nov 17 |
The seed weights, days and yields are this made-up grower's own, for its trays, its room and its seed. They aren't targets. The point of a log is to find your own.
What the log shows
T-103 and T-105 are the pair worth looking at. Same variety, same seed lot, same weight, same sowing day. One gave 9.0 oz and the other 4.0. The log has the difference in it: T-105 came out of blackout a day later, on the 13th, and its note says mold took a corner and half the tray was cut. One line of dates turned "radish is unreliable" into "don't leave radish under the dome a fourth day".
The seed lot is there for the day a whole sowing comes up thin. If every tray from lot RD-2611 is poor and the trays from the last lot were fine, that's a call to the seed supplier, with the lot number. More on that code is in seed lot number.
Ounces from a gram of seed is yield divided by seed weight. Seed is this grower's largest cost for sunflower and pea, so the column shows whether sowing heavier pays. If 180 g of sunflower gives 15.5 oz and 150 g gives 14.5 oz, the extra 30 g bought one ounce.
The columns, and how to fill them
- Tray. A number written on tape on the tray. Without it, the row and the tray part company on the rack.
- Seed (g). Weighed on a scale. A scoop of sunflower varies by more than the difference you're trying to measure.
- Out of blackout. The day the cover or the stacked tray came off and the lights went on.
- Harvested and yield. Cut weight, before packing. If a tray is cut over two days, write both.
- Note. Mold, uneven germination, a missed watering, a tray dropped. Written that day, in a few words.
By variety
| Variety | Trays harvested | Average days | Average yield |
|---|---|---|---|
| Sunflower | 1 | 10 | 14.5 oz |
| Pea shoots | 1 | 11 | 16.0 oz |
| Radish | 2 | 8 | 6.5 oz |
| Broccoli | 1 | 10 | 6.5 oz |
After a month this table is your planning data. Days tells you when to sow for a Thursday delivery. Average yield tells you how many trays an order needs: a restaurant that takes 2 lb of sunflower a week is 32 oz, which at this grower's 14.5 oz a tray is three trays, with 11.5 oz to spare. Radish's average is dragged down by the tray that molded, which is honest: some trays do.
Seed, trays and clamshells on hand are in microgreens inventory spreadsheet. Pricing is in how to price microgreens, and how long a cut tray keeps in microgreens shelf life.
Get the log sheet
Download the microgreens log sheet. Two sheets and a read-me: a tray log that works out days and ounces from a gram of seed, and a by-variety summary to fill in. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
At six trays the log is a page. At sixty a week it's a second job, and the first thing dropped is the part that matters most later: which trays went into which clamshells, for which customer. When a chef says Tuesday's pea shoots were slimy by Thursday, the log knows T-102 was harvested on the 17th. It doesn't know whose box it went in.
How TaroStack does it
TaroStack carries the seed lot through to the customer.
Receiving records each bag of seed as a lot, with the supplier's lot number.
A tray, or a sowing of trays, is a batch. Record it and the seed comes off stock, by lot. The batch notes which lot it used, automatically.
Your checks are fields on the batch record: seed weight, blackout days, cut weight, a note.
Each harvest is a lot with a date, and what ships is recorded by lot.
One report for a lot: from a seed lot to the trays sown from it, the customers who got them, and what's left.
| The chef's call | Paper log | In TaroStack |
|---|---|---|
| Which harvest was in Tuesday's box | Unknown | The lot on the delivery |
| Which seed lot it grew from | The log, if the tray is known | The lots on the batch |
| Who else got that harvest | Memory | One report |
| How that variety has yielded | Add it up | On each batch record |
TaroStack doesn't water the trays or time the lights. Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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.
