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.
Think: If you could take any experimental design and with one click expand it out three years or five years. Not only that, but when you analyze the data, all the means are stored for every location and every year.
The nuances of data standardization become absolutely critical. If you don’t standardize certain points of data, a functioning relational database is simply not possible.
Are you seriously contemplating using plant breeding software for your research program?