Database-ready data collection for a randomised 18-plot grain sorghum trial: three replicates of T1-T5 and an untreated control.
Trial Workbook
The workbook contains a flat Field_Data table, 72 linked Lab_Samples records, and a reference-only field map. Enter plot observations in the blank cells; yield per hectare, control mean yield, and PGP yield increase calculate in Excel.
Use the SQL schema to create trial_plots, plot_assessments, and lab_samples. The importer reads the completed workbook and derives any missing yield per hectare or PGP percentage before loading SQLite or PostgreSQL.