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.