...
Notice that “termites” has been moved from the community cells (B9 and D9) to the label in A10.
Column A should explicitly state the expected data values for the row
If data is expected in the row, then the label in column A should explicitly state what data is expected.
For example, if the data is the number of local units purchased, then the label might be bambara nuts: no. local meas., whereas if the data is the amount produced then the label could be bambara nuts: kg produced.
This avoids the ambiguity inherent in labels such as Other Crop Type: bambara nuts, where it is unclear whether the values represent the amount in kg, or the number of local measures, or just a label where no additional data is expected.
Data should not be stored in label rows
As well as avoiding using cells in the main body of the worksheet for capturing metadata, it is also important to not put data values, including 0, in cells on rows where the value in Column A is a heading or other label. This sometimes happens when the previous Livelihood Activity contained a 0 entry for many rows and they have been copied down one row too far, into the heading for the next section of the BSS.
...