The way to do this is with good database software designed specifically for plant breeding. To make the best decisions you MUST use all possible data available, if not it could be costly.
when I was conducting yield trials as a plant breeder, drought seemed imminent a few months after planting. Rather than lose the entire trial, I requested sprinkler irrigation at the research station. Unfortunately, water pressure to the far end of the station wasn’t ideal, and there wasn’t a perfect fit for one of the pipe connections.
Are you seriously contemplating using plant breeding software for your research program?
Do you know how much time you, or plant breeders within your company, spend looking at spreadsheets? It might surprise you. I’ve recently had conversations with leaders at one large seed company who estimate breeders there spend about 20 percent of their time looking at spreadsheets.