...
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.
Community Names
The Community Full Name is constructed from the admin unit name (typically labeled District) and the community name (typically labeled Village) that are in rows 4 and 5 of the WB, Data, Data2 and Data3 worksheets in a BSS. The database uses these names to ensure that the data from the different worksheets can be linked to the correct Community entry in the database. Consequently, the spelling of those names in all places where they appear is critical to successfully recognizing the data.
Ideally, either cell validation or conditional formatting should be used to ensure that the names are accurate, for example by comparing them to the Form 3 interview results in ‘WB’!C4:L5.
Livelihood Strategies (Data, Data2, Data3)
...