Extract management data from xlsx

[Illustratien]

1. Soil
2. Fertilizer
3. Plant protection
4. Disease note

[Illustratien]

@tillrose could you please double check where we can improve?

1. wether fill the blank from column D (yellow area) to others
2. some missing date (not only in DKI but also in HAN)
3. whether need to translate or not in column G in English (e.g., Düngung -> Fertilizer)

[tillrose]

What do you think, should I overwork the original management files or the extracted lists (would be much easier) and we leave the original files behind?

[Illustratien]

Since the extraction is automatic now. I would suggest to correct/filling the original one.

What do you think, should I overwork the original management files or the extracted lists (would be much easier) and we leave the original files behind?

[Illustratien]

Do we need these nearly empty columns?

[Illustratien]

Relevant discussion #15 #4

[tillrose]

I think nearly empty columns should not be featured in the extraction.

[Illustratien]

I think nearly empty columns should not be featured in the extraction.

You mean the note ? or

[Illustratien]

what are the differences between inhibited or not?

[tillrose]

An inhibitor is a compound added to a nitrogen-based fertilizer to reduce gaseous losses when the fertilizer has been applied to the crop. We used it because we gave the 3rd nitrogen dressing very early because in the rain out shelter there was later no water at the surface that is usually needed for the active use of fertilizer by the crop.

If you think another wording is more common, go for it.

[Illustratien]

I don't have a recommendation for new wording. But I am thinking wether we need an addtional table for explaining the abbreviation or the "term/jargon" shown in the table.

[tillrose]

Perhaps ad a sentence in the manuscript? "nitrogen fertilizer was either applied as calcium ammonium nitrate (CAN), urea ammonium nitrate (UAN) or urea ammonium nitrate with inhibitors (UAN inhibited)."

[tillrose]

I would prefer to delete all fertilizer information except nitrogen. This information is only given in sporadic seasons but in all experiments magnesium, phosphor, potassium were given in sufficient amount. The actual state is confusing.

[Illustratien]

I would prefer to delete all fertilizer information except nitrogen. This information is only given in sporadic seasons but in all experiments magnesium, phosphor, potassium were given in sufficient amount. The actual state is confusing.

filterout the magnesium rows, since they are the base fertilizer