I don't know what your transformation process entails so I couldn't suggest whether you updated it by script (automatically) or by hand.
I would love to know, for instance, how you transform the data in the spreadsheet you showed into your 'final' output. Without knowing the exact steps I don't know if a tolerance table would work for you or not, it just sounds like you have the same calculations going on by crop type, but your parameters may change (i.e. multiplying by .25 for a quarter size plot as opposed to a 1 or perhaps even a 2 or 4 or 8 multiplier for other crop types)
If you were to have a normalized table you'd have to have something like
Code:
Weed_ID WeedDesc ----> calculation related fields (possibly)
TRFPRR
TRFPRS
PALAMAR
PLAMAS
SPELT
where WEED_ID would match your column headers on your excel spreadsheet and and WEEDDESC would be whatever you wanted, then you could have your variables you want to plug into your various formulas in the related fields to ensure that once it is set up there are no human related errors in the calculations.
and your normalized table would be something like:
Code:
Plot Weed_ID Weed_Count ---> other weed specific information
11A SPELT 4
11A TRFPRR 10
11A TRFPRS 1