Introduction

Loading new Baseline Storage Sheets (BSS) into  the database requires the import to recognize the data in the various worksheets and allocate the correct standard metadata. Data that cannot be recognized automatically because it uses different terminology or different cell locations to the norm must be reconciled manually, requiring an additional level of effort.

Below are recommendations for data entry in a BSS that ensure that it will be easy to load into the HEA Baseline Database.

Guidelines

File Formats

All new BSS should be maintained using current versions of Excel and saved in the .xlsx file format. The .xls format is obsolete and is not supported by many modern tools.

Livelihood Strategies (Data, Data2, Data3)

Metadata should only be in Column A

Don’t put metadata (data that describes the livelihood strategy in the per-community columns (i.e. column B onwards). The reported income or kcals for each community are used to produce a reconciled value for the Livelihood Zone, and so the numbers for each community must be referring to the same Livelihood Strategy. For example, if the strategy refers to a particular type of food, then it should be in the label in Column A, and not in that row in Column.  

For example, the following data:

Should properly be entered as:

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