I have a very high-end machine, a quad core i7 with hyper threading and 12GB of RAM, two RAID arrays (1TB and 4TB). This workbook would crash my machine on calculations. Excel
is not the correct program. You need a database, like Access to store the data and then produce reports. I absolutely know that's not what you want to hear, and I don't expect you to pay me for this, unless you want me to make the Access database, but that is the answer. The reason is Excel can do that work in a VBA macro or an Array Formula. Everytime you enter a cell it would make an array of all the data, sort and parse the data as told, and recalculate every cell. Every cell would need to refer to the array. So if you have 100 entries, with 4 columns, that's 4000 pieces of information, copied once for each farm, so say 20 farms. You now have 80000 pieces of information for get the unique farms. Now you have to match crops... So what's important to understand is the limited scale of Excel solutions based on its primary purpose, accounting and automate fiscal calculation, versus your problem which is multidimensional. So each time you add a factor in Excel, it scales dimensionally, or in other terms you have a 6-dimensional problem that requires a different approach, like entity-relationship sorting, matching and grouping, which is what R, SQL, Ruby or Python do very well. SQL is the correct choice for manipulated information, so that's why I would recommend Access. I mean there is always MS-SQL with a C# ***** or MySQL, but Access you probably have and does not require an Admin to maintain.