Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Notice that “termites” has been moved from the community cells (B9 and D9) to the label in A10.

Data should not be stored 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.

The BSS ingestion will refuse to load a BSS that contains data in unexpected locations, because we need to ensure that no important data is lost.