There are quite a few potential road blocks thrown up by your current design. I strongly suggest NOT using repeating fields for this so that you can use relationships to match to records of the same crop type. Trying to do this from your current structure will be difficult if not impossible to do.
I see. I've tried a couple different calculations, so It makes sense to me that it seems undoable to others.
We had an older file on excel that was formatted to look that way, and so the Boss-man wants them all to be like that. I'm quite a fan of being able to tell him that it won't work, as I don't actually like the layout.
I started typing out a question regarding a hypothetical layout, and then many questions started following. So, unless someone has an idea regarding a database to manage crops, I don't think I have anything else to say..
Thanks for the fast and considerate response.
PhilModJunk suggestion has nothing to do with the look of the layout. You might can build a bicycle to go 100mph, but it is very doubtful, and why try when they invented the automobile.